Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Assessment Manager Key Skills for Schools FREE
1: Aspects, grade sets and result sets
Result sets (2:33)
Grade Sets (3:30)
Grade Aspects (3:08)
Review
2: Creating a Template
Introduction
Creating a First Template and Marksheet (5:34)
Adding More Columns to our First Template (3:47)
Data Entry vs Data Review Columns (8:43)
General Marksheet Techniques Part 1 (9:56)
General Marksheet Techniques Part 2 (9:47)
Review: What Have We Achieved?
3: More Aspects and More Templates
Marks Integer and Marks Decimal Aspects (2:55)
Comment and Age Aspects (2:50)
Creating a template for formative assessment (4:46)
Creating Different Marksheets for Different Audiences (7:06)
Class Links and Group Filters in Templates (4:02)
Review: A Functional System!
4: Adding Formulas to Templates
Introduction: Using the DIFFERENCE Formula
Adding a Column for Data Review Using a Formula (4:23)
Columns vs Constant Values in Formulae (2:23)
Choosing Review or Entry Formulae Columns (2:14)
Adding a column for Data Entry Using a Formula (4:22)
5: More Formulae!
Using the DIFFERENCE formula with grade aspects (4:32)
Using the PLUS formula (2:41)
Using the SUM Formula (2:12)
Using the MULTIPLY formula (1:36)
Using the DIVISION formula (2:41)
6: Adding Colour to Marksheets
Adding Colour Using a NESTED IF THEN ELSE Formula (7:28)
Why the Order of Your NESTED IF THEN ELSE formula is important (3:23)
Highlighting Pupils with a C grade or Higher (6:17)
Using Colours to Create a RAG (Red-Amber-Green) System (5:07)
7: Creating a 'Real World' Marksheet
Introduction
Amending Grade Sets (to Include Sub Grades) (7:02)
Understanding the Side Effects of Changes to Grade Sets (3:19)
Deleting Columns in Templates and More Tips (5:14)
Why It's Better to Add Colour to Residual Values (8:39)
Why the Order of Your NESTED IF THEN ELSE formula is important
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock