The purpose of the Marks Summary Spreadsheet is to perform semester and year end calculations.  This spreadsheet will vary depending on whether you teach in a block or non-block schedule school.  If you teach in a middle school, use non-block.

Minimal setup is necessary for grades to calculate correctly.

1. Click on the Setup Menu
2. Click on Spreadsheet
3. In the left portion of the window, select the correct Marks Summary Spreadsheet
4. In the right portion of the window, click on the drop down arrow beside calculation method and choose Total Points.
5. Click Close.
6. Click on the Tasks menu.
7. Select Edit Tasks
8. Click on the Points tab.
9. Highlight the value in the Scale Factor box in the right portion of the window, and enter the appropriate percentage.
 

Note: You can enter percentages for each grading period in this window, by clicking on the appropriate six weeks in the left portion of the window and changing the scale factor.

You will need to repeat all of these steps for each class.

To transfer grades from six weeks spreadsheet to the Marks Summary Spreadsheet:

1. Go to the Spreadsheet drop down arrow and select Marks Summary Spreadsheet.

If you teach in a non-block schedule school choose Marks Summary Spreadsheet.
If you teach in a block schedule school choose Marks Summary Spreadsheet Block.

2. With your mouse pointer, click on the appropriate 6th week column heading.
3. Select Replace Task.
4. In the next window select the correct 6 weeks and click on the Next button.
5. In the next window, click on the appropriate 6th weeks grade book Spreadsheet Grade and click Next.
6. In the next window select Raw Score or Percentage and click Next.
7. Click OK in the next window.
8. Grades should appear in the appropriate 6th weeks column.
9. Repeat these steps to perform calculations.

NOTE: You will need to manually enter midterm and final exam numeric values in their corresponding columns.

You will need to repeat all of these steps for each class.