Weighted Type spreadsheet basics

A weighted type spreadsheet resembles a traditional gradebook that records numeric task information. You enter scores and InteGrade Pro calculates the grade. Students are listed on the left side, scores are in the middle, and the calculated grades are on the right side. Scores are generally numeric, although special scores may also be entered.

 

Each weighted type spreadsheet can have a different letter grade table. This enables you to use different grading rules for sets of tasks or for different terms. The spreadsheet uses task types to weight scores when calculating the final spreadsheet grade. Weighted type numeric spreadsheets display a Letter Grade column and a Total % column.

Weighted Type spreadsheet header

Header item

Description

Class

This is where you select the class for which you wish to update scores.

Spreadsheet

Select the appropriate weighted type spreadsheet.

Tasks

Select the task for which you wish to update scores.

 

Scores on:

This shows the task selected in the Tasks box. Clicking on the task name here takes you to the Edit Task pages.

Show

There are two viewing options for each spreadsheet. Click on the view box and select an alternate view.

Hot linking Numeric and Skill spreadsheet grades

Hot links are used for linking spreadsheet grades from Numeric and Skill spreadsheets to End Term spreadsheets. Any time changes are made to the Numeric or Skill spreadsheet, the End Term spreadsheet is automatically updated. Hot links must be created using InteGrade Pro (non-web).

 

If a hot link has been created, InteGrade Pro Web will display the linked data in the column on the End Term spreadsheet as a hyperlink. The link can be broken at any time by clicking on one of the hot link hyperlinks. A message will ask you to confirm removal of the link. Removing the link from any one score in the column removes the link for the entire column.

Where to from here?