It’s exam season and we are all thinking about holidays!
An ideal scenario for testing those Excel skills.
Here is a spreadsheet assessment with plenty of scope for good layout skills and calculations.
The resource offers a task sheet and suggested answers with 50 total marks available.
It should suit a 40-60 minute lesson.
I have written it for my Yr9 ICT class but certainly will suit other years to practice a range of skills.
Just added a revision crib sheet too plus a marking rubric for Microsoft Teams
The holiday planning scenario should be ideal for the summer term!
Year 7 Python lessons can be great for coding fun tasks. This assessment follows on after some early lessons on if elif else.
Feel free to adapt this task so can be used for picking: - what to watch on Netflix, where to go on holiday or what to have for dinner etc.
The resource offers a suggested Python solution and a Teams rubric for marking.
Have fun picking!