Exporting Quarter Grades Comments Exporting Semester Grades TA and INC Scores
EXPORTING
QUARTER GRADES is a 2-step process:
A. Move the quarter grades from the Numeric spreadsheet to the
EndTerm spreadsheet
1. Open IGPro
2. Open Quarter 1 Grade (EndTerm) spreadsheet (or appropriate Quarter)
3. Click QTR 1 Grade (right column)
4. Select Replace Task
5. Double-Click Q1 (Numeric Weighted
Type)
6. Double-Click Q1 Spreadsheet Grade
7. Double-Click Letter Grade
8. Click Hot Link Grades; OK
9. Scores will appear in blue and will
reflect any changes made to the numeric spreadsheet.
Repeat this process for each
active class…
…then
B. Export the gradebook ONE time:
1. Click File (from the menu bar)
2. Select Export from Gradebook…
3. Check appropriate date; Next
4. (continue with the export anyway)—if
necessary; Next
5. Click Export
6. Click OK
COMMENTS (optional) may be added on the EndTerm spreadsheet in the Comments column
1. Right-click inside an
individual student’s cell in the Comments column
2. Select the appropriate
comment
EXPORTING
SEMESTER GRADES is a 3-step process:
A. Average
Q1 and Q2 grades
1. Open IGPro
2. Open Sem 1 spreadsheet
3. Use Replace Task to transfer Q1 and Q2 grades to the Sem
1 spreadsheet
Optional Note: To weight the semester grade using Q1, Q2,
and a semester test:
1. Add a
Task named Q1 with a Scale Factor of .45
2. Add a
Task named Q2 with a Scale Factor of .45
3. Add a
Task named Sem Test with a Scale Factor of .1
4. Use
Replace Task and enter the Q1 and Q2 final scores as a percentage.
5. Enter
the semester test scores by hand
B. Enter
both the Q2 grades and the Sem 1 grades on the Semester EndTern spreadsheet
1. Open the Semester EndTerm
spreadsheet
2. Use Replace Task to enter both
the Q2 and Sem 1 grades as a letter grade
Repeat Steps A and B for each
active class…
…then
C. Export the gradebook ONE time:
1. Click File (from the menu bar)
2. Select Export from Gradebook…
3. Check appropriate date; Next
4. (continue with the export anyway)—if
necessary; Next
5. Click Export
6. Click OK
Please note: before exporting, every student must have a score.
Also, as you review your students’ grades just before exporting,
you may notice an individual grade you’d like to change (over ride). For
example, you may want the grade to be INC instead of the letter grade, or you
may need to add/change your TA’s score to a P.
To change a score on the EndTerm Spreadsheet:
1. Click on the grade to
change
2. Type the change
3. The pop up will say that you will break the automatic update;
OK
4. The grade color will change from blue to black indicating the
scores are no longer linked to the Numeric spreadsheet.
This will not affect the export. It will save you having to change
the grade on the verification sheet as well as save the office staff from
having to look up the student in question and change the score by hand.