Teacher instructions to help with tracking data for departments, school wide or individual class trackers. These instructions show how to insert an IF statement to compare a grade (for a unit/exam/module etc.) to a target, to show whether it's above, below or meeting target grade. Two separate instructions for grades A*-G and numbers 9-1. Ideal for whole staff training. More advanced staff should be adapting the formulae to suit their needs. Enjoy.

It's a great idea, at the end of a topic or unit, to get students to create their own quizzes. They can then complete one another's to test their understanding or to revise a topic. I've created a PowerPoint template for students to be given to produce a quiz. The PowerPoint is fully linked because the main purpose of this type of activity is the questions and the answers, not the linking together! This also means this activity lends itself to ANY SUBJECT and a range of year groups. There are ten question spaces, students can easily use 'duplicate slide' to add more questions though. As an extension, whilst other students complete their work, students can improve the look of their quiz or add further elements. This activity comes with a peer assessment sheet - the idea being that students should be given the opportunity to complete one another's quizzes (further recapping and revising a topic) and 'rate' them on various criteria. This sheet is in word format, should teachers wish to add to or amend the criteria. As the sheet is editable, it could be used for other peer assessment evidence - as you're paying for this resource it's worth adapting to get the best value for money!! Overall, a fun activity leading to quite an interactive peer assessment activity. Teachers don't need to be skilled in the IT behind the linking/functions of the quiz - just make it available on a shared drive for students to take a copy of before completing it! Enjoy.

THIS RESOURCE USES PYTHON VERSION 3. There are subtle differences between version 2 and 3, I believe. It's free to download though, so maybe update your systems. This is the third lesson in a series of my new resources on Python Programming. I'm teaching this to low ability year 9, though I know my higher ability year 7 would love it and I've also seen Python used within some primaries. It's suitable for any novice programming teacher (like me!). This lesson introduces data types within Python and sees students introduced to the terms String and Integer. The lesson is fully resourced and will last at least a full hour, if not longer. If you're an absolute beginner, this is ideal. Just read it through and print before teaching - that's it! Look out for my other Python programming resources as part of this series. Enjoy.

THIS RESOURCE USES PYTHON VERSION 3. There are subtle differences between version 2 and 3, I believe. It's free to download though, so maybe update your systems. This is the 4th lesson in the series of my new resources on Python Programming. I'm teaching this to low ability year 9, though I know my higher ability year 7 would love it and I've also seen Python used within some primaries. It's suitable for any novice programming teacher (like me!). This lesson introduces Boolean logic and writing if statements in Python. The lesson is fully resourced and will last at least a full hour, if not longer. If you're an absolute beginner, this is ideal. Just read it through and print before teaching - that's it! Look out for my other Python programming resources as part of this series. Enjoy. ...look in bundles if you're buying more than one though, there's some discounts to be had there!

THIS RESOURCE USES PYTHON VERSION 3. There are subtle differences between version 2 and 3, I believe. It's free to download though, so maybe update your systems. This is the second lesson in a series of my new resources on Python Programming. I'm teaching this to low ability year 9, though I know my higher ability year 7 would love it and I've also seen Python used within some primaries. It's suitable for any novice programming teacher (like me!). This lesson builds on my first lesson which introduced variables - although this lesson does include a recap if you wanted this as a standalone lesson without the first resource! The lesson is fully resourced and will last at least a full hour, if not longer. If you're an absolute beginner, this is ideal. Just read it through and print before teaching - that's it! Look out for my other Python programming resources as part of this series. Enjoy.

A single, well designed help sheet that guides students through the process of creating a movie using images they have saved on their work areas using Serif Movie Plus. This is IDEAL if you've got Serif Movie Plus installed on your network, but don't know quite how to use it! Give students this sheet and get them to work it out independently. I've had some great results from this, students loved it too. Great end of term fun activity if students can choose their own topic of movie. Enoy.

YOU MUST HAVE MS ACCESS TO USE THIS LESSON (THE FBI FILES IS A DATABASE!). Teachers need to show students how to carry out a query using Microsoft Access first. Students can then use the database provided to independently practice their ability to carry out a query by answering questions 1 - 7 on the provided handout. Teachers should then bring the class together to play 'Guess Who' using the PowerPoint and database. Teachers display the clues to each of the four people and students should carry out a query to find the correct person. A reward for each quickest query-carry-outer could be provided. A long activity to complete your database lesson for Key Stage 3 ICT or Computing/Computer Science!

Another FULL Micro:bit lesson. I actually used the spare devices supplied by the BBC to deliver this lesson for Year 6 induction recently. Equally ideal for year 7 or 8 ICT/Computing groups. The PowerPoint, handout and attached code get the students to program a decision maker on their Micro:bit device. So, when shook, the device provides a random answer to the question the student asks - quite fun! Everything needed, including extra challenges to stretch the top end or step by step support for lower ability groups. A review of the lesson objectives at the end is also included. If you don't like paying for resources, I've also uploaded a FREE Rock, Paper, Scissors resource. Enjoy!

This lesson is PERFECT for an end of term Computing lesson or as a really FUN introduction to Scratch Programming. The 17 slide PowerPoint guides acts as your FULL lesson planning, guiding students through the process of making a racing car game in Scratch. It introduces and explains key terms like Spite, Stage and Variable as the lesson goes along too. If you wish, you could give students the glossary handout to complete throughout the lesson as seven key terms have been highlighted in PINK text to be written into the glossary and defined as the lesson progresses (optional extra!). The lesson includes a short peer assessment activity to look at each other’s games and offer pointers for improvements. In addition, the code on the handout could be annotated by students as a homework task or additional plenary. The lesson includes an extension challenge for higher ability students (fully differentiated by outcome, task and resources available to students). This would really suit KS2 or KS3 classes. My students LOVED it; I’ve used it with all of my year 7 Computing groups as a fun end of term lesson AND with my lower ability year 9 Computer Science GCSE group as an ice breaker introductory lesson to programming basics. Enjoy!

FULL lesson that introduces Phishing. Includes starter, 2 main activities, lots of discussion, no computers required, 2 worksheets/handouts, full lesson PowerPoint with all answers included and a lesson review. 1. What is Phishing - discuss and write initial ideas (to show progress on the progress path sheet) 2. Identify pointers of a dodgy email (handout included with extension task) 3. Discussion and answers revealed (including possible answers to the extension task) 4. Poster raising awareness task - includes differentiated success criteria that matches the objectives. 5. Plenary review (on handout) that proves progress. No additional planning or adaptation required (bonus!). Enjoy.

This lesson introduces students to the different connections available for digital devices (wired and wireless connections). Students should mind map their own ideas first, before answers are revealed (click on the slide to reveal answers!). Students must then research OR use the support sheet to group advantages and disadvantages of each connection type. On the back page of the booklet is a review of the lesson where students must decide on the BEST method of connection; there are more answers, but the IDEAL answer is shown on the PowerPoint itself and students should be told this! Enjoy!

Update: The files marked NEW! include a template for this resource which already has the hyperlinks included in PowerPoint; so if you’re tight on time, students can still make use of this resource without having to learn how to make links. Along with this are 6 challenges (differentiated) and a log for students to complete and take with them - PERFECT for Year 6 Induction in a computer room/IT/Computing lesson. As it’s the end of term, this fun activity still gets students learning about how to add hyperlinks into PowerPoint presentations. The scary maze can be changed for Santa’s maze, if you’re aiming to do something ‘Christmassy’! The activity gets students to create a version of the ‘scary maze game’ (Google it!). They find a scary image that, if their users hit the wall of their maze, will flash on the screen (after slides are linked). I don’t want students having nightmares though, so I have provided an alternative ‘nicer maze game’ too! Included is a student handout, PowerPoint to act as a short lesson guide (two versions - scary and nicer) as well as a scream sound for students to use if placed on a shared area. As always, feedback is welcome! Enjoy! *Copyright - I either own everything or it comes from an acknowledged, royalty free source!

A fully resourced and differentiated lesson. Includes PowerPoint to guide you fully through the lesson - NO ADDITIONAL RESOURCES REQUIRED! Download, print and go! Suitable for teaching in or out of a computer room too. Includes; - Starter to introduce what malware is (students work this out themselves) - Research task - use the internet or the fact sheets provided (printing on A3 is best) - Malware for beginners leaflet (like malware for dummies!) template for computer or for printing included - Exam style questions to complete independently - I let my students use their leaflets, so there's some purpose to completing the task - Review from my plenary selector BUT includes template of a mobile phone - students text the teacher what they've learnt! Enjoy...

Two activities to introduce five laws to students. I teach low ability GCSE Computer Science, and this is perfect for them. Specifically mapped to OCR Computer Science J276, though good for any lessons covering these five laws: - Data Protection Act 1998 - Computer Misuse Act 1990 - Copyright Designs and Patents Act 1988 - Creative Commons Licensing - Freedom of Information Act 2000 There are TWO activities here which make teaching this (slightly dull) topic easier. 1. Laws Jigsaw - Print on A3. Students cut out all pieces and connect to make 5 jigsaws, one about each law. There's an answer sheet which I stick at the front if students struggle they're allowed a peek! 2. Laws Summary - Students fill in the missing words. Answers are provided to discuss. There is also a help sheet with potential words to use; this is again stuck at the front and students are allowed one or two peeks whilst completing the task. There are TWO versions of the sheet, one with letter prompts to make it easier. The harder one is good because students often use different words, so good for discussion. Enjoy.

Let's learn about... Social Networks. This is a FULLY resourced double lesson and includes a lesson plan to hand to anyone who has to pop in to observe! The lesson includes a progress path to show ideas at the start and at the end of the lesson, so progress can clearly be identified. Students learn what a Social Network is and then discuss the good and bad things of Social Networking sites. Higher ability students can then move to giving advice/solutions to avoid the bad things from being an issue. A short homework task is also included to complete the circle and ensure you don't need to do any planning at all!! This lesson includes EVERYTHING. Download, print and go. No alterations required. Update - I've also added an electronic version of the good/bad points sorting activity, just in case you're in a computer room or want to do it on the board!

Fully resourced guide to guide students through the creation of their own board game and the coding of a Micro:bit device to determine how many moves players should take around the board. Fully differentiated - pick and choose what you use. Includes solution for lower abilities to still access the lesson and additional challenges to stretch the top end. Board game template included - this would be a very creative, fun and engaging project to complete with students over numerous lessons. Students I've done this with have even created game play cards and programmed their Micro:bit's to decide when players should take a card. They've coloured their board in fully and make a real professional job of the activity. Enjoy! There are plenty of other Micro:bit activities listed in my free and premium resources lists.

A FULL lesson that introduces your students to four network topologies (bus, ring, star and mesh). The PowerPoint will equally double as a really useful resource for revision, if printed or made available electronically to your learners. Lesson plan and student handout included which asks them to draw topology diagrams and give advantages/disadvantages of each topology. Enjoy!

A short unit of work that gets students to collect data for a car database, create two databases, make a questionnaire and carry out queries. This is best suited to years 5 - 8 but might suit lower ability KS4 students too. There are six lesson outlines - not full lessons, just a brief outline of what needs to be done in each lesson; this is reflected in the low price for this resource. Teachers do need to compliment this scheme of work with additional resources, though the student book and lesson outlines provided act as a cheap and cheerful guide to a full unit of work! The eight page student booklet also includes an assessment page for students to shade in using pencil/crayons. Enjoy.

A full section of work that introduces Computer Science students to different types of Computer Memory. **Watch the video preview **BEFORE you buy so you can see the quality of this resource! This mega resource includes: **17 slide **PowerPoint with introduction memory task and notes on different types of memory 4 page booklet for students to complete 30 mark assessment / test Mark scheme of the assessment / test 15 page student revision booklet on the Memory topic (adapted from the lesson PowerPoint) Tarsia puzzle on memory (students need to match the phrases together to make a pyramid shape - GREAT for group work). The solution to the Tarsia puzzle (I often print this and put it in the corridor, giving students who struggle a chance to peek if needed). This resource is suitable for anyone teaching RAM, ROM, Primary, Secondary, Virtual and Flash Memory. I have mapped this against OCR GCSE Computer Science - though anyone teaching these topics will be able to use this resource as there’s no mention of OCR specifically. Enjoy.