GB 2.5 Import Grades
Allows faculty to download a pre-formatted spreadsheet with students and all currently entered assignments and grades so the instructor can grade offline.
Reference the annotated wireframe specification pages 66-70.
Setup
You'll need at least one gradebook item already set up in Gradebook to run this test properly. It is desirable to have some graded items and some ungraded items for this test.
Steps
- Select Import Grades from the gradebook navigation. Verify that the onscreen version matches the documentation , page 66 - except that the document page name Import Spreadesheet (IM-1) is not online. Report andy differences.
- Select the Download Spreadsheet Template
link and verify that you can successfully download the .csv file. - Verify that the students, gradebook items, and grades in the spreadsheet accurately reflect your current gradebook.
- Enter and/or change student grades for some of the items. Save the modified spreadsheet as a .csv file.
- Take a snapshoot of your current grades from Roster or an individual gradebook item screen so that you can compare grade changes. Follow the import instructions and import your spreadsheet.
- Verify that you now see the Verify Gradebook Import screen as displayed in the documentation, page 69 - except that the content matches your course and the document page name Verify Import (IM-2) is not online.
- Verify that grades are entered/changed as specified.