Unit Learning Outcomes:
ULO2 Apply appropriate project management software to help plan and manage projects.
ULO4 Analyse complex and unexpected project management problems and identify appropriate solutions
PGCLO 4.1 Demonstrate personal autonomy and accountability in the execution of a substantial authentic project.
PGCLO 4.2 Apply knowledge and skills with initiative and/or creativity to new situations.
Instructions
Your Tasks
The assignment requires you to create project progress information in both Agile burned down charts and Waterfall earned value management. The information needs to be interpreted in a document explaining the information.
Create a spreadsheet that has four sheets.
Sheet one should show an Agile Backlog. This is similar to Lab 7. The stories and points are for you to define.
Sheet two should show a completed sprint using some of the stories from the Backlog. This is similar to Lab 7. The actual work should differ from the planned work, being either quicker or slower to complete.
Sheet three should show a second completed sprint using some of the stories from the Backlog. This is similar to Lab 7. The actual work should differ from the planned work, being either quicker or slower to complete.
Sheet four should show the same information that is in the sprint using a cost baseline. See video explanation below. The information in the cost baseline should be calculated using earned value management (EVM).
Word document explanation
Write an approximately two page document explaining the information in the spreadsheet. Explain a backlog, burned down chart, EVM calculations. Interpret the information in your spreadsheet.
It is expected that students’ stories, point, tasks and values will differ between students.
Videos from Canvas
EVM Explanation
https://ecu.ap.panopto.com/Panopto/Pages/Viewer.aspx?id=c6993862-98cc-4958-9140-af26007402fa
Lab 7 Backlog and Sprints
https://ecu.ap.panopto.com/Panopto/Pages/Viewer.aspx?id=8ce66eb6-c1fd-41e5-a1fa-af25003b4552
https://ecu.ap.panopto.com/Panopto/Pages/Viewer.aspx?id=5d9b4806-73e5-4d82-bc64-af25003d03fd
Note
The first sheet of the assignment should have sufficient user stories for three sprints.
Sprint one will have a third of the user stories points. Identify the number of story points you can complete in a day, perhaps 5 points per day, Then create the planned burned down chart and an actual burndown that differs – allocate user stories with a total of 100 points for a 20 day sprint, obviously 5 points per day.
Do the same for sprint 2 in a separate excel sheet. Allocating one third of the user story points to the sprint. Create a burndown chart.
The final, one third, of user stories are not required for a sprint. They are used in the cost baseline for a budget for month 3 only.
Allocate a notional cost per day e.g. $1,000 per day. The budgeted cost in the cost baseline should be the number of days a user story will take multiplied by the cost per day e.g. A user story has 20 points, a sprint plans to complete 5 story points a day, the cost is therefore 20 points divided by 5 points per day which is 4 days multiplied by $1,000, the budgeted cost would therefore be $4,000.
Appendix
PMBOK earned value management formulas.
Budget at completion (BAC) is the total PV at completion
Formula: BAC = total cumulative PV at completion
Planned value (PV) is the budgeted cost for the work scheduled to be completed on an activity or WBS component up to a given point in time.
Earned value (EV) is the budgeted amount for the work actually completed on the schedule activity or WBS component during a given time period.
Actual cost (AC) is the total cost incurred in accomplishing work on the schedule activity or WBS component during a given time period.
Get expert help for Agile Backlog Task and many more. 24X7 help, plag-free solution. Order online now!
