skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

After completing a work breakdown structure and estimating tasks, the schedule and corresponding Gantt chart need to be created. Using Excel, please create a project schedule with attached Gantt chart for the following small project. You must follow the video below – do not manually “shade” in the cells in Excel.
Project Information
You are tasked with organizing a webinar at your place of employment.  Consider that you need to open a registration page online, accept registrations for a month, close the registration, and run the webinar. You will need tasks to create the webinar content, record yourself in a video that will play during the webinar, begin the webinar and play the video, then field questions for half an hour, plus any other tasks you can think of. You should have between 15 – 25 tasks.
You are going to create a project schedule with attached Gantt chart. In order to do so, you need to:
create a list of tasks along with a start date and duration of time (in days) for each task;
ensure the list of tasks are arranged such that a task that depends on a preceding task has a start date that falls after the preceding task ends;
enter the tasks, duration, and start dates into Excel
create a Gantt chart as shown below
Important Note
In the WBS assignment, you created estimates of work effort for each work package. The project schedule/Gantt chart now looks at  “duration” of time.  Duration refers to the span of time during which you need to complete the task; it does NOT reflect the actual time (“effort”) to complete the task.
For example, one of your tasks might be to schedule a kickoff meeting that you expect will have a work effort of 2 hours.  You know you want the kickoff meeting to take place the week of November 2nd but you’re not set on any particular day yet.  For this kickoff task, you will set the duration to 5 days (40 hours).  Your task might look like this:
Task                                     Duration (days)       Start Date
Hold kick-off meeting            5                               11/02/2020
Where do you account for the 2 hours of work effort? – You don’t, in the project schedule you’re creating for this assignment. You just indicate the 5 days of duration. (This seems counter-intuitive!)
Continue this for all the tasks, assigning them a duration (in days) that seems reasonable to you.  You don’t have to assign them in week increments.  It’s up to your discretion – you might set durations of just a few days. 
Open Excel
Populate the spreadsheet with the project schedule data that you create, in the format above (task, duration, start date). You should have between 15 – 25 tasks.
Create the GANTT chart by watching this video.
You may have to watch it as you create your GANTT chart. Hint: open 2 windows.
Pause the video as you follow the speaker’s instructions. Follow along carefully.
When done, save and name your spreadsheet.
Upload it by clicking “Add Assignment” below.
Reference:
Subjectmoney. (2013). Gantt Chart Excel Tutorial – How to make a Basic Gantt Chart in Microsoft Excel 2013. Retrieved from https://www.youtube.com/watch?v=-oD50HSBBBI

GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don't hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®

Back To Top