Post Edit Home Help

Key Pages

Technology Reflection Home |
Teacher Help Pages |
Google Sites Help

Changes [Oct 01, 2018]

Resource Link Page
SAM Class Install
   More Changes...
Changes [Oct 01, 2018]: Switches, Resource Link Page, Home, SAM Class Install, ... MORE

Find Pages

Exporting Grades

The easiest way to get averages from the grade book for a particular "category" of assignment is by Score Sheet Report export

Select the Score Sheet Report from the reports tab by double clicking. (use the settings below)

External Image

Then click run report button lower right, and select save the report, saving to your H: drive

External Image

Then Open the Excel Spread Sheet by going to the H: drive and Double Clicking on the file.

External Image

Then you can delete any unwanted columns by right clicking on the letter of the column and selecting delete.

To get the average, in an empty cell type =average(

Then Hi-lite the row of cells to be averages

the Type ) to finish the calculation.

When its complete the cell should hold the average

External Image

You can copy the average to the rest of the cells down the page by

hovering the mouse over the right lower black box until the cursor becomes a solid black cross

the click and drag down the column, this will copy the formula to all the lower cells.

External Image then release External Image

New Page - Edit this Page - Attach File - Add Image - References - Print
Page last modified by seth Wed Nov 01/2017 11:05
You must signin to post comments.
Site Home > Albion Power School Forum > ExportingGrades