Answer To: SITXHRM003 Learners Assessment Guide Assessment 1 BSBMGT617 Develop and implement a business plan...
Ishmeet Singh answered on Nov 03 2021
ProjectSchedule
Create a Project Schedule in this worksheet.
Enter title of this project in cell B1.
Information about how to use this worksheet, including instructions for screen readers and the author of this workbook is in the About worksheet.
Continue navigating down column A to hear further instructions. LORNE HOTEL UPGRADE PROJECT
Enter Company Name in cell B2. Company: Lorne Hotel
Enter the name of the Project Lead in cell B3. Enter the Project Start date in cell E3. Pooject Start: label is in cell C3. Project Lead: Project Start: Fri, 1/1/2021
The Display Week in cell E4 represents the starting week to display in the project schedule in cell I4. The project start date is considered Week 1. To change the display week, simply enter a new week number in cell E4.
The starting date for each week, starting with the display week from cell E4, starts in cell I4 and is auto calculated. There are 8 weeks represented in this view from cell I4 through cell BF4.
You should not modify these cells.
Display Week: label is in cell C4. Display Week: 1 Dec 28, 2020 Jan 4, 2021 Jan 11, 2021 Jan 18, 2021 Jan 25, 2021 Feb 1, 2021 Feb 8, 2021 Feb 15, 2021 Feb 22, 2021 Mar 1, 2021 Mar 8, 2021 Mar 15, 2021 Mar 22, 2021 Mar 29, 2021 Apr 5, 2021 Apr 12, 2021 Apr 19, 2021 Apr 26, 2021 May 3, 2021 May 10, 2021 May 17, 2021 May 24, 2021 May 31, 2021 Jun 7, 2021 Jun 14, 2021 Jun 21, 2021 Jun 28, 2021 Jul 5, 2021 Jul 12, 2021 Jul 19, 2021 Jul 26, 2021 Aug 2, 2021 Aug 9, 2021 Aug 16, 2021 Aug 23, 2021 Aug 30, 2021 Sep 6, 2021 Sep 13, 2021 Sep 20, 2021 Sep 27, 2021 Oct 4, 2021 Oct 11, 2021 Oct 18, 2021 Oct 25, 2021 Nov 1, 2021
Cells I5 through BL5 contain the day number for the week represented in the cell block above each date cell and are auto calculated.
You should not modify these cells.
Today's date is outlined in Red (hex #AD3815) from today's date in row 5 through the entire date column to the end of the project schedule. 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7
This row contains headers for the project schedule that follows below them.
Navigate from B6 through BL 6 to hear the content. The first letter of each day of the week for the date above that heading, starts in cell I6 and continues through cell BL6.
All project timeline charting is auto generated based on the start and end dates entered, using conditional formats.
Do not modify content in cells within columns after column I starting with cell I7. TASK ASSIGNED
TO PROGRESS START DEADLINE END DEADLINE DAYS M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S
Do not delete this row. This row is hidden to preserve a formula that is used to highlight the curren day within the project schedule.
Cell B8 contains the Phase 1 sample title.
Enter a new Title in cell B8.
Enter a name to assign the phase to, if it applies for your project, in cell C8.
Enter Progress for...