wB - School Calculation Rules Button
webBook will be discontinued from the January 2025 release (version 60.01.200).
Please switch over to Staff Kiosk Assessment > Markbook or Assessment > Enter Results and Comments if you haven't already.
Calculation rules are used in Progressive Assessment by:
- The Markbook Final Results calculation.
- The Markbook Overall Subject Grade calculation.
- The Export to Existing Excel Spreadsheet function.
- The Upload Final Results from an Excel spreadsheet function.
- The Upload Overall Subject Grade from an Excel spreadsheet function.
Important!
Access to the 'School Calculation Rules' button is only available to webBook Unrestricted Users only. This button is used to create and maintain calculation rules.
An example of a common 'Calculation Rule':
Student Grade | Numeric value from: | Numeric value from: |
---|---|---|
NA | -1* | -1* |
E- | 1 | 1 |
E | 2 | 2 |
E+ | 3 | 3 |
D- | 4 | 4 |
D | 5 | 5 |
D+ | 6 | 6 |
C- | 7 | 7 |
C | 8 | 8 |
C+ | 9 | 9 |
B- | 10 | 10 |
B | 11 | 11 |
B+ | 12 | 12 |
A- | 13 | 13 |
A | 14 | 14 |
A+ | 15 | 15 |
Important!
*To exclude a student's result and its associated weighting for an Objective in the calculation of the Final Results and/or Overall Subject Grade, an 'NA' must be used. The 'NA' must be set up in the Calculation Rule as '-1'.
Using the example below, Daniel Glover did not receive a mark for Objective 3. Because an N/A was entered, the calculation was based on two Objectives (not three) and he still received an A.
Student | 33.3% Weighting | 33.3% Weighting | 33.3% Weighting | Final Result |
---|---|---|---|---|
Objective 1 | Objective 2 | Objective 3 | ||
Dunn, James | A (14) | A (14) | A (14) | A (42/3 = 14) |
Glover, Daniel | A (14) | A (14) | NA | A (28/2 = 14) |
To Create a New Rule
Click the 'Create New Rule' button
Step 1 – Enter a meaningful description for the rule (e.g. A+ to E-) and click the 'Next' button.
Step 2 – Enter each 'Grade' and a corresponding 'Numeric Value from:' and 'Numeric Value to:
(Example: A+ = 15 to 15, A = 14 to 14 etc.)
If you are setting up a calculation rule for a large result range such as 1 – 100, you do not need to create 100 entries. Instead, you can just enter the 'from' and 'to' numeric range for each Grade.
For example:
Student Grade | Numeric value from: | Numeric value from: |
---|---|---|
E | 0 | 19 |
D | 20 | 49 |
C | 50 | 69 |
B | 70 | 89 |
A | 90 | 100 |
The grades need to be entered in ascending order. In the example above, start with grade 'E'.
Click the 'Save ' button when finished.
Important!
The 'Numeric Range' rule is a system reserved rule that cannot be deleted or edited.
You cannot edit or delete a rule that is being used in the current reporting period.