Today is July 20, 2022, and you have decided that you are going to need more time preparing for your classes than originally designated. Preliminary work preparing student materials is moving along smoothly, but you have run into problems allocating enough time to review course materials and work with the new textbooks. Build a timeline and delegate some tasks to others. You have enlisted some of your better students to help you with the preparation for the new courses you are going to be teaching. In addition, one of the students will be working through the projects with you to give you a better idea of what may cause issues with other students.

1. Using the information given at the end, open it in an excel file
2. Using the table below, add yourself and the following students to your Resource Sheet:

Resource Name	Type	Initials
Kyle Smith	Work	KS
David Grant	Work	DG
William Cook	Work	WC
John Walker	Work	JW

1. Select Task 2 and insert a new task named Word. Indent Task 3 to make it a subtask of Task 2.
2. Select Task 4 and insert a new task named Excel. Outdent the new task. Indent Task 5 to make it a subtask of Task 4.
3. Select Task 6 and insert a new task named PowerPoint. Outdent the new task. Indent Task 7 to make it a subtask of Task 6.
4. Select the Task Name column and Wrap Text.
5. Change the duration of Tasks 3, 5, and 7 to 18hrs.
6. You have decided to break down the book work more and have asked one of your students to be your helper. Add the following tasks to follow each of Task 3, 5, and 7:

Review end-of-chapter exercises	1 hr
Check all work	1 hr

1. Assign the following tasks as specified:

Kyle Smith: Task 3, 4, 5, 7, 8, 9, 11, 12, and 13. Ignore the overallocation.

David Grant: Tasks 21 and 22

William Cook: Tasks 14, 15 and 16

John Walker: Tasks 18 and 19

Assign any remaining tasks to yourself plus Tasks 3, 7, and 11. If given the informational warning symbol, select Increase the amount of work but keep the same duration. Ignore the overallocation.

1. Right-click the Task Name column and Insert Column. Select WBS. Adjust the column width as necessary.
2. Define the WBS Code with Level 1) Numbers; Level 2) Uppercase Letters; Level, 3) Lowercase Letters.
3. Copy the entire table and paste it into a blank Excel worksheet. Adjust columns as necessary. Save the file as Exercise2_Excel_LastName_First_Name
4. Open a blank Word document and paste the table into a Word document.

Task Mode	Task Name	Duration	Start	Finish	Predecessors	Resource Names
Auto Scheduled	Get new schedule	5 mins	Fri 19-08-23	Fri 19-08-23
Auto Scheduled	Read Word textbook and work through projects	2 days	Fri 19-08-23	Mon 19-09-02
Auto Scheduled	Read Excel textbook and work through projects	2 days	Fri 19-08-23	Mon 19-09-02
Auto Scheduled	Read PowerPoint textbook and work through projects	2 days	Fri 19-08-23	Mon 19-09-02
Auto Scheduled	Verify students and courses	1 hr	Fri 19-08-23	Fri 19-08-23
Auto Scheduled	Make necessary corrections to student list	1 hr	Fri 19-08-23	Fri 19-08-23
Auto Scheduled	Create labels with student name and course name	2 hrs	Fri 19-08-23	Fri 19-08-23
Auto Scheduled	Copy/print course materials	3 hrs	Fri 19-08-23	Fri 19-08-23
Auto Scheduled	Set color-coded folders	1 hr	Fri 19-08-23	Fri 19-08-23
Auto Scheduled	Add labels and course materials to folders	2 hrs	Fri 19-08-23	Fri 19-08-23
Auto Scheduled	Get books from bookstore	2 hrs	Fri 19-08-23	Fri 19-08-23
Auto Scheduled	Verify books and course material folders for each student	2 hrs	Fri 19-08-23	Fri 19-08-23
Auto Scheduled	Verify attendance sheets with books and course materials	2 hrs	Fri 19-08-23	Fri 19-08-23
Auto Scheduled	First Day	0 days	Tue 19-09-03	Tue 19-09-03