| Initial Set Up |
| ID Number | Feature/Backlog Item | Priority |
| 1 | Marketing Automation |
| 1.1 | Tracking sales and marketing | 1 |
| 1.2 | In-build reporting and Analytics | 6 |
| 1.3 | Customer Service and Support Tools | 11 |
| 2 | Customer Data |
| 2.1 | Identifying product owners | 2 |
| 2.2 | Contact management sytem | 7 |
| 2.3 | Lead Management | 12 |
| 3 | Contact Analytics |
| 3.1 | Sales forecasting | 3 |
| 3.2 | Salesfore automation | 8 |
| 3.3 | Accounting system | 13 |
| 4 | Website |
| 4.1 | Mobile applications | 4 |
| 4.2 | Tracking and visibility | 9 |
| 5 | Customer enquries |
| 5.1 | Feedback System | 5 |
| 5.2 | Product recall management | 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 | Tracking sales and marketing | 1 | 3 |
| 2.1 | Identifying product owners | 2 | 3 |
| 3.1 | Sales forecasting | 3 | 3 |
| 4.1 | Mobile applications | 4 | 3 |
| 5.1 | Feedback System | 5 | 3 |
| 1.2 | In-build reporting and Analytics | 6 | 2 |
| 2.2 | Course Modify | 7 | 2 |
| 3.2 | Salesfore automation | 8 | 2 |
| 4.2 | Mobile applications | 9 | 2 |
| 5.2 | Product recall management | 10 | 1 |
| 1.3 | Customer Service and Support Tools | 11 | 1 |
| 2.3 | Lead Management | 12 | 1 |
| 3.3 | Accounting system | 13 | 1 |
| 1 | Marketing Automation | | 27 | Total Effort Units |
| 2 | Customer Data |
| 3 | Contact Analytics |
| 4 | Website |
| 5 | Customer enquries |
| 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' |