3

profilejamsession
part2sample.xlsx
Home>Information Systems homework help>3

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
1.1 Student Add 1
2.1 Course Add 2
3.1 Class Add 3
4.1 Registration Add 4
5.1 Mobile Add 5
1.2 Student Modify 6
2.2 Course Modify 7
3.2 Class Modify 8
4.2 Registration Drop 9
5.2 Mobile Delete 10
1.3 Student Delete 11
2.3 Course Delete 12
3.3 Class Delete 13
1 Student Records
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'