A stay at home task sheet in Excel covering formulae, formatting, sorting and a bit of football knowledge.
Great for Year 7/8 for basic skills in ICT/Computing
Task sheet and model answer attached.
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!
Time for a python coding task -my Yr7 will have a go at this as I have covered Sequence, Selection and Iteration. So if you have taught For and While loops then this is a cute little challenge.
Room for extension with lives if the array is extended.
Have fun!
A lovely ICT project using Sway from Microsoft Office 365 suite of programmes - an alternative to PowerPoint with lots of fun and presentation skills to consider.
The students can create a SWAY for a fictitious shop - Wind and Waves - consider layout, graphic skills and language to support all abilities and a lovely transition topic for Year 6 too.
Our students enjoy this to round off the year in Computing.
If you are teaching Python to lower school and have taught sequence and selection then perhaps they need an assessment, perhaps they need to go on a bear hunt!
Attached is a task sheet with marks allocated for different jobs - also my rudimentary code on repl.it - I show the students the output first and then they should have a go at coding it in a lesson or homework.
A fun task (open book) so look up old code - if you have taught random and if statements then this is an ideal challenge.
A suggested solution can be accessed here:
https://replit.com/@WilsonWorks/BearHunt#main.py
Who says we can't have festive fun in Computing.
If you are teaching Small Basic (free coding software from Microsoft) then how about a Christmas assessment for KS3 with If Then Else. Teaching Selection has never been more festive!
Try the worksheet and then set the assessment - Mark Scheme and code provided.
HO - HO - HO!
Teaching game narrative in Computing combines English skills with their coding ability. This sheet offers the nudge that Kodu gaming demands a seed of creativity just like a story. Make them think about characters and setting then create the worlds and the creatures that inhabit their visualisations.
Plenty of discussion and then loads of fun. A writing frame is provided.
Kodu is a great platform for game making of any age. It is free from Microsoft. This worksheet will allow students to add interactive buttons. So many possibilities for coding and teaching Selection.
Do you think you can make CIRCLE in Scratch? Have a go - Get busy making your favourite apps in Scratch. A step-by-step guide which you can adapt for the ability of your coders.
Computing can be so much fun - when you are making games. Tried and tested in KS3.
The English Language is influenced by our technological age. This SOW comes at Language Change from the front-end and offers students a glimpse into Language and Technology with a view to future A Level English Language aspirations.
Ideally for Yr 8 but Yr 9 could be switched on. The lessons offer discussion points, linguistic terminology and tasks to do in class or at home. I have put together 8 lessons covering topics such as the language of Webpages, Reviews, Texting, Twitter, Memes, Emails and a fun game show to end the term.
Grab a bargain and be enthused by language that is evolving in our influential tech world.