23Uploads
4k+Views
2k+Downloads
All resources
L2 - What is a drainage basin
A geography lesson to find out what a drainage basin is and fun tutorial for students to create their own drainage basin.
This lesson is part of the Rivers unit for KS3 (Year 8)
Learning objectives:
• To know the different parts of a river found in a drainage basin.
Excel QLA Markbook
A QLA (Question Level Analysis) excel markbook to easily input and show the areas of strength and weakness in your students.
This markbook is tailored for Geography AQA GCSE, however the amount of papers and total marks can be easily edited and the formulas will update automatically.
Features:
Automatically calculate total and percentage for each section of the paper and the overall total, percentage, grade.
Creates a residual mark (grade - target) for each paper and an average residual of all 3.
Average residuals for each paper are also calculated based on males, females, HAP, MAP, LAP, EAL, SEN, PP.
Can easily add/extend more classes.
Excel Markbook Template
An Excel spreadsheet that can be used for any subject to easily input marks for assessments.
This sheet really saves me a lot of time, and could save you a lot of time too.
Key features:
Automatically works out percentage, grade, and residual (grade - target grade)
Colour coded based on students in the top/bottom 10%
Calculates average residual over multiple assessments.
Ranks students from highest residual to lowest residual.
Displays average residuals for males, females, HAP+, HAP, MAP, LAP, EAL, SEN, PP.
Easily print out spreadsheet and use for parents evening.