These Templates can be used to create Assessment Sheets for a single Subject across multiple year groups with the ability to add assessment data against Topics and Statements, for example Key Stage 3 English Curriculum.
Use this guide to;
Access: the minimum permissions required to access Curriculum Assessment Templates is found in the Assessment Module from Config>Set Up> Roles and Permissions
See also How to Create Assessment Components
Create New Curriculum Assessment Templates
From the left go to Modules>Assessment> Manage Templates
Then from the Assessment Templates dropdown choose Curriculum Assessment
Then click New
In the Template Details panel complete the following. Fields marked with an * asterisk must be completed
- Name: type in a name, remember these sheets can be used for more than one year group so be aware when naming
- Notes: type in notes as required
- Active : defaults to Yes
- Subject – single dropdown choiceTopic Result Type: this is for the Topics choose either Grade Set or Markset.
- Topic Result Type choose either Gradeset or Markset
- Gradeset – choose a Gradeset for the Statements
- Data Entry Term – choose from the following options:
- leave blank and the Terms defined in the Term scope will show in alphabetical order
- or choose a term from the drop down, this will be the visible term when you open the Assessment Sheet however, you will be able to choose the other terms defined in the Term Scope Panel
- Choose a Term and tick Term locked then only that Term will be visible in the Assessment Sheet List
- Term Locked: this locks the Data Entry Term and no other Terms are visible in the Assessment Sheet list
- KPI Assessment Type: define the Assessment Type from the dropdown. Topic results across a single subject can be combined and converted into a percentage to show in an Assessment Type(with a 0-100 markset attached) to be then added to a Tracking Template.
In the Termly Progress Column Calculations click to Calculate Termly Progress Column Value Automatically and the from the Calculation Type choose either; either;
- Add all statement results
- Add termly collected statement results
- Average all statement results
- Average of termly collected statement results
In the Default Additional Student Columns & Year, Term Scope you can click Add to add additional student information to your assessment sheets. In this example we have added Ethnicity, Free School Meals, Gender and Pupil Premium
For the Group scope we’ve toggled on for Other Group Type so we can choose Teaching Class, you can also choose Tutor Group if required. If the toggle isn’t clicked on then you can choose Year Groups.
In this example we’ve chosen 4 maths classes in Selected Groups.
For the Term Scope we’ve chosen 6 Terms
Use the Sort Order to define the visible order of the Groups and Terms when viewing them in the Assessment Sheets
In the Topics panel click Add to add a Topic with a Name and Description, you can choose to hide a Topic if you don’t want this visible, for example you may have a Topic that isn’t being covered at the start of the academic year so keep it hidden and then open it up later on in the academic year
Once you’ve added a Topic you can then click on it to see the Statement Panel below where you can add Statements to be ‘Mapped’ to the Topic.
Give the Statement a Name and Description, tick Is Required if you want this Statement Column to be mandatory in the Assessment Sheets, choose a Forced Term and Weighting if required.
Repeat this process for adding more Statements to a Topic
Import Topics and Statements
You do have the option to Import the Topics and Statements from a spreadsheet with the six column headings as below, do not amend the Headings in the spreadsheet as this will prevent the import.
Note the tabs at the bottom of the spreadsheet so for example you could create two Curriculum Assessment Templates called for example KS3 Mathematics and KS3 English and instead of inputting the Topics and Statements manually you can import them in.
To import the Topics and Statements go to Modules>Assessment>Manage Templates then from the Actions dropdown choose Import Templates
In the Centralised Import pop up choose Excel and then click Browse to locate your spreadsheet. Note the Import File must be a valid EXCEL file (.XLSX)
Then once you have chosen your file from your computer click Analyze
In this example as we’ve already created the KS3 Mathematics Curriculum Assessment Template this has mapped, for the KS3 English this will create a new Curriculum Assessment Template.
In the final Import panel choose again to Create New and map the Topics and Statements to a previously created Template
Finally choose Proceed to complete the process.
View Assessment Sheets
Before informing any teachers about the new Assessment Sheets you may want to view and check them beforehand, to do this go to Modules>Assessment>Assessment Sheets lists.
In the example below we have typed in Admin in the User Access and in the Marksheet Type we’ve chosen Curriculum Assessment Sheets
Click on the Marksheet name to open the Assessment Sheet.
In this example we can choose the Topic, Term or Group from the dropdown choices plus just show Statement Names Only and hide the Statement description
There are two options to enter data in the columns;
1.Click in a cell in the Statement columns to add the relevant Assessment Data, click Skip or Remove Mark if required, you can also change to tab direction from across to down in the top right
The teaching staff timetabled for the group can view and enter data into the Curriculum Assessment Sheets from their Teachers Dashboard as per the example below;
2.To enter data directly into the Curriculum Assessment Sheets
Select the Input grades using a keyboard option on the top right marksheet toolbar to toggle keyboard entry for the marksheet on or off.
Enter a grade using the keyboard, and then press Enter or Tab to move to the next cell in the marksheet. Entered grades can be deleted and re-entered. If required, use the arrow keys to move up or down within the marksheet.
Note: if a user enters an invalid grade for the marksheet, a warning message is displayed, as shown in the sequence above.
When the toggle option is set to off, grades can only be entered using the dropdown list. This option is set to off by default.