Sprint Planning for CapraTek’s Alfred! Smart Thermostat Project Effective Labeling and Tracking in Project Management: Part 2 – Burndown Chart

Projet Background Info:
CapraTek® a longtime leader in computer server
technology, is developing Alfred!, an integrated wireless smart-home system
that seamlessly connects household electronics, appliances, and devices.
While many of the functions Alfred! will
manage are actually third party devices, one that is being designed and
manufactured by CapraTek® specifically for the Alfred! system is a smart
thermostat for the consumer market. You have been brought in as the project
manager for the IOS software that will interface with Alfred! and the
thermostat. 
The Sprint Assignment:
The Sprint is the essence of the Scrum methodology and is manifest in daily meetings. During each meeting, the team addresses what has been done, what needs to be done, and how to remove existing impediments to progress.
The first Sprint meeting is an opportunity for the project sponsor or project manager to introduce the project or product that the team will be working on, including the project schedule and the product backlog. It is also an opportunity for the team members to become acquainted with one another and discuss ideas, skills, and other factors to enable the project to get off to a good start. As the meeting progresses, the team needs to:
Identify a Sprint goal.
Identify Sprint tasks and times for completion.
Designate team member roles.
Define what it means to be “done,” that is, when the Sprint is considered finished.
Subsequent Sprint meetings occur on a daily basis and focus on what has been done, what needs to be done, and identification of impediments and how to address them.
You have carefully planned your first Sprint meeting. Now it is time to conduct it. Your goal in this first Sprint meeting is to gain enough information to plan a Sprint that fits into the project schedule and is within the abilities of your team to deliver. The meeting should produce a well-informed team that is ready to attack the Sprint backlog efficiently. Please note, this is the backlog for this individual Sprint. Do not confuse it with the product backlog that you created earlier.
View the CapraTek: Sprint Meeting activity.
Complete the following two parts of this assessment.
Part 1: The Sprint Plan
Create a Sprint plan based upon the CapraTek activity that includes:
Sprint goals. This should be a detailed description.
Sprint tasks.
A description of the roles, responsibilities, and authorities of project stakeholders.
A Sprint burndown chart (for the Sprint, not the entire project) that derives its source data from an Excel table. Include both the table and the chart in your submission. Paste the table from Excel into your Word document if possible. The table should include the following items:
Sprint tasks.
Days dedicated to the Sprint.
Start hours.
Total hours.
Estimated remaining hours.
Actual remaining hours. (Because this is the beginning of the first Sprint, actual remaining hours and estimated remaining hours will be the same.)
Note: The graph should depict a straight line representing estimated remaining hours. An example of a burndown chart can be found in Mastering Agile, in this assessment.
A definition for “done.” This should be detailed. For example, if your Sprint goal was to create a button that turns the system on/off, just writing “the button turns the system on and off,” is insufficient. You must describe the functionality, how it appears to the user, how it might affect other systems, et cetera. It should describe “done” in enough detail so that the team is clear about the product’s entire functionality at Sprint completion.
Part 2: Updated Burndown Chart
Imagine on day three one of your team members gets sick and does not come in to work. In addition, another team member is required to spend three hours in an unexpected mandatory training. Update your burndown chart to reflect the new project conditions.
Create a single Word document with both parts of the assessment. Copy your Excel table and graphs into the document if possible. Make sure all headings and graphics are effectively labeled.
I am attaching previous assignments/relevant documents that provide context. please use specifics (names, details,  user story ID#, story info, etc.) from these supporting documents in this assignment. Please create the part 2, the burndown chart, in Excel & then paste into the word document along with part 1 of the assignment. Also, please attach the excel document seperately to the finished assignment.