Calculating the Final Semester Grade
District policy is that the cumulative semester average will form 80 percent and the comprehensive semester test will form 20 percent of the final semester grade. The following instructions will create some new spreadsheets in IGPro to perform that calculation and export the final letter grades to the office.

1. Creating New Calculation Spreadsheets
   (The following procedure needs to be completed for each class.)
   
   First you must set up a new spreadhseet to take the semester average percentage (out of 100%) and the semester test percentage (out of 100%) and calculate the final semester grade.
   1. Under the SETUP menu, choose SPREADSHEETS
   2. Click on NEW
   3. Click the checkbox next to CREATE A NUMERIC SPREADSHEET
   4. Click NEXT
   5. Name the spreadsheet 1st Semester Grade Calculation (or 2nd Semester Grade Calculation if appropriate)
   6. Click NEXT
   7. Click the checkbox next to TOTAL POINTS
   8. Click CREATE
   9. Hold down the Control (CTRL) key and use your mouse to click and drag the new spreadsheet title up the list so that it appears after "13.5 WK Progress..."
   10. Click CLOSE
   11. Repeat for each class
       
       
2. Copying the Semester Averages and Entering the Semester Test Grades
   Next you must copy the cumulative semester average to the new spreadsheets.
   1. Change to the 1st Semester Grade Calculation spreadsheet you created in part A (or 2nd Semester Grade Calculation sheet if appropriate)
   2. Click on TASKS, COPY TASKS...
   3. Choose the main semester spreadsheet, Click NEXT
   4. Click the checkbox beside the first thing in the list (...Spreadsheet Grade), Click NEXT
   5. RAW SCORE will be selected, Click NEXT
   6. Clock OK
   7. Click TASKS, EDIT TASKS
   8. Click on the POINTS tab
   9. Change the SCALE FACTOR to 4, hit the tab key (the OUT OF will change to 400), Click CLOSE
   10. Choose TASKS, NEW TASK...
   11. Name the task Semester Test. OUT OF should be 100, SCALE FACTOR should be 1.0. Click CREATE
   12. Enter your semester test grades as a percentage, entering the score of I for any student who has not taken the semester test
   13. Repeat for each class
       
       
3. Copying the Various Grades to the End-of-Term Spreadsheet
   Next you must copy the required grades to the end-of-term spreadsheet.
   1. Change to the 1st Semester [End Term... spreadsheet (or the 2nd Semester [End Term... if appropriate)
   2. Copy the Cumulative Semester grade to the end of term spreadsheet
      1. Right-click on the column labeled Sem1 Cum Gra (or Sem2 Cum Gra if appropriate) and choose REPLACE TASK...
      2. Choose the 1st Semester Grade Calculation spreadsheet (or 2nd Semester Grade Calculation sheet if appropriate), and click NEXT
      3. Choose the task near the bottom of the list with the name ending in "...Spreadsheet Grade", click NEXT
      4. Choose LETTER GRADE, click NEXT, click OK
   3. Copy the Semester Test Grade to the end-of-term spreadsheet
      1. Right-click on the column labeled Sem1 Exam Gr (or Sem2 Exam Gr if appropriate) and choose REPLACE TASK...
      2. Choose the 1st Semester Grade Calculation spreadsheet (or the 2nd Semester Grade Calculation sheet if appropriate), and click NEXT
      3. Choose the task near the bottom of the list entitled "Semester Test", click NEXT
      4. Choose LETTER GRADE, click NEXT, click OK
   4. Copy the Semester Grade to the end-of-term spreadsheet
      1. Right-click on the column labeled 1st Sem Grade (or 2nd Sem Grade if appropriate) and choose REPLACE TASK...
      2. Choose the 1st Semester Grade Calculation spreadsheet (or the 2nd Semester Grade Calculation sheet if appropriate), and click NEXT
      3. Choose the first item in the list, click NEXT
      4. Choose LETTER GRADE, click NEXT, click OK
   Complete steps 1-4 for EACH class
   
   
4. Exporting Semester Grades to the Office
   Make sure you have copied grades for ALL classes to the end-of-term spreadsheets before you export. You only need to export ONCE and it sends the grades for all of your classes to the office.
   1. Choose FILE, EXPORT FROM THE GRADEBOOK...
   2. Make sure the checkbox next to either 1st Semester or 2nd Semester is chosen, Click NEXT
   3. If it gives you an error message you should try to fix any errors, and check with your registrar if you aren't sure what grades are acceptable.
   4. Click NEXT, EXPORT