| 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' |
week4part2example.xlsx
