assignment2excelexample.xlsxW3_Initial Set Up
| Initial Set Up | ||||
| ID Number | Feature/Backlog Item | Priority | ||
| 1 | Student Records | |||
| 1.1 | Student Add | 1 | ||
| 1.2 | Student Modify | 6 | ||
| 1.3 | Student Delete | 11 | ||
| 2 | Course Records | |||
| 2.1 | Course Add | 2 | ||
| 2.2 | Course Modify | 7 | ||
| 2.3 | Course Delete | 12 | ||
| 3 | Class Records | |||
| 3.1 | Class Add | 3 | ||
| 3.2 | Class Modify | 8 | ||
| 3.3 | Class Delete | 13 | ||
| 4 | Registration | |||
| 4.1 | Registration Add | 4 | ||
| 4.2 | Registration Drop | 9 | ||
| 5 | Mobile Access | |||
| 5.1 | Mobile Add | 5 | ||
| 5.2 | Mobile Delete | 10 | ||
| Notes | ||||
| 1. Save a new MS Excel file | ||||
| 2. In Cells A1, B1, and C1 set up titles | ||||
| 3. Indicate the features with ID numbers 1, 2, 3, 4, and 5 | ||||
| 4. Insert enough rows for the backlog items or user stories under each feature. | ||||
| 5. Under each feature insert the backlog items and assign an ID number that ties it to the feature. | ||||
| For example student add would be ID 1.1, Student Modify would be 1.2, and Student delete | ||||
| would be 1.3. | ||||
| 6. Set priorities for each backlog item. I arbitrarily set the priorities shown above. | ||||
| Sort Backlog Items by Priroty | ||||
| ID Number | Feature/Backlog Item | Priority | Estimated Work Level | |
| 1.1 | Student Add | 1 | 3 | |
| 2.1 | Course Add | 2 | 3 | |
| 3.1 | Class Add | 3 | 3 | |
| 4.1 | Registration Add | 4 | 3 | |
| 5.1 | Mobile Add | 5 | 3 | |
| 1.2 | Student Modify | 6 | 2 | |
| 2.2 | Course Modify | 7 | 2 | |
| 3.2 | Class Modify | 8 | 2 | |
| 4.2 | Registration Drop | 9 | 2 | |
| 5.2 | Mobile Delete | 10 | 1 | |
| 1.3 | Student Delete | 11 | 1 | |
| 2.3 | Course Delete | 12 | 1 | |
| 3.3 | Class Delete | 13 | 1 | |
| 1 | Student Records | 27 | Total Effort Units | |
| 2 | Course Records | |||
| 3 | Class Records | |||
| 4 | Registration | |||
| 5 | Mobile Access | |||
| Notes: | ||||
| 1 | Go to tab data | |||
| 2 | Within tab data go to sort | |||
| 3 | Cover all cells with data in them | You should see gray area. Note this may happen | ||
| automatically if you go to step 4 first. | ||||
| 4 | Click on sort | |||
| 5 | Select 'sort by' priority | |||
| 6 | The result is that all of the backlog items are now shown in priority order. | |||
| Note 2: | You can also resort by feature by sorting again but this time select 'sort by' |
W4_Proj.Schedule
| Plan Item | Amount | Units | Derivation | |||
| Project Cadence | 2 | weeks | ||||
| User Story Effort | 26 | user story effort units | From +D23 | |||
| Velocity Estimate | 3 | |||||
| Number of Fixed Length Iterations | 9 | Sprints | User Story Estimate/Velocity Estimate rounded up | |||
| User Story Effort Units and Revised Priorities (to comply with customer request for three release dates) | ||||||
| ID Number | Feature/Backlog Item | Initial Priority | User Story Effort Units | Revised Priority | ||
| 1.1 | Student Add | 1 | 3 | 1 | ||
| 1.2 | Student Modify | 6 | 2 | 2 | ||
| 1.3 | Student Delete | 11 | 1 | 3 | ||
| 2.1 | Course Add | 2 | 3 | 4 | ||
| 2.2 | Course Modify | 7 | 2 | 5 | ||
| 2.3 | Course Delete | 12 | 1 | 6 | ||
| 3.1 | Class Add | 3 | 3 | 7 | ||
| 3.2 | Class Modify | 8 | 2 | 8 | ||
| 3.3 | Class Delete | 13 | 1 | 9 | ||
| 4.1 | Registration Add | 4 | 3 | 10 | ||
| 4.2 | Registration Drop | 9 | 2 | 11 | ||
| 5.1 | Mobile Add | 5 | 2 | 12 | ||
| 5.2 | Mobile Delete | 10 | 1 | 13 | ||
| 26 | ||||||
| Schedule | ||||||
| Sprint Identification | Start | End | Sprint User Story Effort Units | |||
| Sprint 01 | 1/6/20 | 1/17/20 | 3 | |||
| Sprint 02 | 1/20/20 | 1/31/20 | 3 | |||
| Sprint 03 | 2/3/20 | 2/14/20 | 3 | |||
| Sprint 04 | 2/17/20 | 2/28/20 | 3 | |||
| Sprint 05 | 3/2/20 | 3/13/20 | 3 | |||
| Sprint 06 | 3/16/20 | 3/27/20 | 3 | |||
| Sprint 07 | 3/30/20 | 4/10/20 | 3 | |||
| Sprint 08 | 4/13/20 | 4/24/20 | 2 | |||
| Sprint 09 | 4/27/20 | 5/8/20 | 3 | |||
| Double Check >> | 26 | |||||
| Release Plan | ||||||
| User Story Work Plan by Sprint | Release Details | |||||
| Sprint Identification | WBS ID | User Story | WBS ID | User Story | Release Date | Released Effort Units |
| Sprint 01 | 1.1 | Student Add | ||||
| Sprint 02 | 1.2 | Student Modify | 1.3 | Student Delete | ||
| Sprint 03 | 2.1 | Course Add | ||||
| Sprint 04 | 2.2 | Course Modify | 2.3 | Course Delete | 2/28/20 | 12 |
| Sprint 05 | 3.1 | Class Add | ||||
| Sprint 06 | 3.2 | Class Modify | 3.3 | Class Delete | ||
| Sprint 07 | 4.1 | Registration Add | ||||
| Sprint 08 | 4.2 | Registration Drop | 4/24/20 | 11 | ||
| Sprint 09 | 5.1 | Mobile Add | 5.2 | Mobile Delete | ||
| 5/8/20 | 3 | |||||
| Double Check >> | 26 |
W5_Sprint_Plan
| Sprint 01 Plan | |||||
| User Story Assigned | |||||
| 1.1 | Student Add | ||||
| Tasks and Hours | |||||
| Task ID | Tasks | Hours | |||
| S1 | Student Graphical User Interface (GUI) | 60 | |||
| S2 | GUI for Student Add | 40 | |||
| S3 | Business Logic | 60 | |||
| S4 | Data Base | 40 | |||
| 200 | |||||
| Team Members and Assignments | |||||
| Name | Email Address | Hours Available | Assignments | Hours | |
| Susan | [email protected] | 80 | S1 | 60 | |
| Thomas | [email protected] | 80 | S2, S4 | 80 | |
| John | [email protected] | 80 | S3 | 60 | |
| 240 | 200 | ||||
| Available | 40 |
