3

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'