Path: System Functions → Curriculum Control Files → Areas of Assessment
Collated Markbooks should only be created by the Curriculum Co-ordinator or Heads of Departments. The Markbooks are created in Setup Default Areas of Assessment.
Select the Subject
1. Select the Subject No.
2. Tag the Year Level you wish to create a Markbook for (multiple year levels can be done
at once).
3. Select Allocate Tagged to Markbook. This will bring up the Auto Build of Master
Created in version 2007.3.0.1485 39/50 Auto Build Master Collating Markbook
Path: Scholastic → Curriculum Control Files → Areas of Assessment
The Auto Build Master Collating Markbook view allows you to select the various items you wish to include when building the collated Markbook.
1. Select the Subject Period ID you wish to create the Markbook in.
2. Select Items to include in the Markbook, check the codes in the Areas of Assessment.
3. Select the Grade or Result field to include in the Markbook.
4.
Validation codes can be entered now, if not available these can be created, to create them;
• • •
• Enter an Alpha or Numeric digit in the bottom box and click +. •
• •
• The codes can also be entered in the Markbook.
5. Select the Column Heading and Column Format to be used in the Markbook.
6. Tick if Subject 999999 is to be included in the Markbook.
7. Currently Markbooks will only replace results in your student result set. The option Add
or Adjust Results is not available.
8. Will populate the Markbook with Students already attached to the Subject.
9.
File Name Template will default to Master %1, this will name the Markbook as Master and add the information from the Subject. Leave as default or enter a different name for the Markbook.
10. Select Begin to create the Markbook. A Markbooks Created window will appear listing
Working with a Collated Markbook in Collated Mode
Curriculum and Subject Co-ordinators should be the only staff to open Markbooks in Collation Mode. This will allow access to all students in a year level, studying the selected subject, to be viewed at once.
Path: Assessment → Result Entry by Spread Sheet → Collation
Opening the Collated Markbook, when the Markbook is created the appearance will depend upon your selection when creating the Markbook.
1. Select the correct Subject Period ID.
2. Select the Subject.
3. Select the Year Level.
4. Select Markbook tab.
5. Select the Markbook / Sheet Name.
6. Click Markbook then Open.
7.
When the Markbook is opened students studying the subject in the selected year level will be displayed alphabetically with the subject Teachers Timetable code and their form class.
Created in version 2007.3.0.1485 41/50 Markbook Management
Once the Collaged Markbook has been created through the Curriculum Control Files, you can modify it (edit, delete or add columns) through Markbook Management.
1. Go to Markbook, select Manage Markbooks
2. This will bring up the Markbook Management view displaying Markbooks created for the
displayed subject.
3. Select the Markbook you wish view or modify.
4. Heading: displays the name of the Markbook column. These can be renamed in this
view.
5. Type: displays the data type of the column. These can be changed in this view.
6. Validation: displays the Validation for the column. These codes can be edited in this
view.
7. Synch Field: displays the synchronise path for the column.
8.
Synch?: displays the saving option for the column.
• • •
• Display Only; this would not be used for results. •
• •
• Not Synchronised: select if you wish the data in this column to never be
synchronised (saved) to Students results.
• • •
• Synchronised: select if you wish the data in this column to be synchronised
only when you select to do a Full Save of the Markbook.
• • •
• Synchronised Off: allows you to turn the Synchronise on and off.
9. Columns can be moved up or down, highlight a line and click the arrows.
10. Select Save Column Settings to save any changes made to your Markbook.
11. Exit the Markbook Management View and go to Markbook → Open to display the
Entering Results into a Collated Markbook
1. Once you open the Markbook you can enter student results.
2. Invalid data will be highlighted in RED. This means that the data entered in this field
does not fit the Validation Codes for this column.
3.
Missing Areas of Assessment will be highlighted in ORANGE. This means that these students have not been allocated this Area of Assessment and this will need to be done through your Curriculum Control Files.
Created in version 2007.3.0.1485 43/50
Saving in a Collated Markbook
1. Once the correct data has been entered you can now save the Markbook. Go to Markbook to view your save options. 2. No Sync Save: Saves the data to the Markbook only, without impacting the student
result set.
3. Synchronised saving will write the results entered in the Markbook to the student result
Working with a Collated Markbook in Result Entry Mode
Once the Master Collated Markbook has been created by the Curriculum Co-ordinator teachers will be able to use the Master Markbook to view and enter student results for their class through the Result Entry – Markbook tab.
Path: Assessment → Result Entry by Spread Sheet → Result Entry tab → Markbooktab
Opening the Collated Markbook in Result Entry Mode
1. Select the correct Subject Period ID.
2. Select the Teacher.
3. Select the Subject / Class.
4. Select the Markbook / Sheet Name.
5. Go to Markbook → Open.
6. When the Markbook is opened Students studying the selected subject with the selected
Created in version 2007.3.0.1485 45/50
Entering Results the Collated Markbook in Result Entry Mode
1. Open the Markbook and enter student results.
2. Invalid data will be highlighted in RED. This means that the data entered in this field
does not fit the Validation Codes for this column.
3.
Missing Areas of Assessment will be highlighted in ORANGE. This means that these students have not been allocated this Area of Assessment and this will need to be done through your Curriculum Control Files.
4. You will be unable to save the Markbook until you have corrected the invalid data.
Saving a Collated Markbook in Result Entry Mode
1. Once the correct data has been entered you can now save the Markbook. Go to
Markbook to view your save options.
2.
If ‘Enable Result Sync in Collating Markbook’ has NOT been ticked in the Curriculum Control Files teachers will only be able to do a No Sync Save. This will save the results in the Markbook, but not write them against the student results.
3.
If ‘Enable Result Sync in Collating Markbook’ has been ticked in the Curriculum Control Files teachers will have Quick Save, Full Save and 2Way Sync Save available and results will be saved in the Markbook as well as the student result set.
Writing/Saving the Results to the Student Result Set
1. Open the Master Markbook in the Collation Tab.
2. Results entered by teachers through the result entry tab will be displayed.
Created in version 2007.3.0.1485 47/50
Inserting Formulas into Spreadsheets
Path: Scholastic → Assessment → Result Entry by Spreadsheet
Before inserting a formula the field must be set to Numeric.
1. Right click a cell and select Set to Numeric.
Formula Wizard
1. Select the Required Formula.
2. Some Formula options have a brief description.
3.
When a Formula has been selected the expression will be automatically inserted. Enter the fields the function relates to. For example: AVERAGE () is automatically inserted, the fields which are to be averaged are (C4:F4).
Formula Operators
Operator Description Literal (Samples) Cell Reference
+ Addition 2 + 2 B1 + A2
- Subtraction 2 – 1 B1 – A1
* Multiplication 2 * 3 BI * C1
/ Division 2 / 3 B1 / C1
: Create a Range Average cells from A1 to D1 A1:D1
# Wild Card Relative reference of all rows from A1 to A? A#
, Expression (Argument)
delimiter.
Sum (cell 1 and cell 2 and cell
3) (A1,A2,A3,)
Formula Descriptions
AVERAGE Finds the Average of the values within a range of cells MAX Returns the Maximum value within a range of cells. MEDIAN Returns the Centre most value of a range of values.
Created in version 2007.3.0.1485 49/50 Sample Formulas
SUM Step 1
Sum row values and display row total in Column F for all rows.
1. Right click in cell F3.
2. Drag the mouse to cell F12.
Step 2
Right click and select Insert Formula.
1. Select Sum.
2. View the description of Sum.
3.
In Formula to be inserted enter the following;
• • • • Sum (C3,D#,E#) • • •
• The () begin and end the formula. •
• •
• The # is used as a wildcard and will be replaced with the relevant row reference. •
• •
• The comma , separates the argument.
The formula could also be written as;
• • • • Sum(C#:E#) • • •
Step 3