Instructions for teachers on how to create and use look up tables within Excel to calculate grades from scores automatically. Equally, you might use these instructions when teaching this skill to students. I hope these instructions are fairly straight forward. I used Excel 2013 for the print screens, though the skill is similar in whatever Excel version is being used. Great for staff training. ALL staff should know how to do this to save time when tracking data. 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!

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.

A quick and easy starter activity. Students need to name the parts of a computer (leading to my lesson on input, output or storage devices which is also available in my resources). Enjoy!

A good little starter to settle an ICT class quickly and to reinforce key terms relating to spreadsheets. Aids the spelling of key terms which is often over-looked in ICT (how many times do your pupils misspell columN?!).

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!

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.

A short introduction to the Cambridge National in Creative iMedia course. 7 slides that introduce the course structure and each unit. Editable with spaces for you to populate for optional units. Enjoy.

Ideally printed on A3, students write about each part of the computer shown in the boxes and label the parts they can see. Space for teacher feedback and a gap task/extension/homework task to find one more part of the computer and define/label it. I've used this with year 7, but equally would suit up to GCSE and as low as year 5/6. Enjoy!

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...

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!

***NEW! ***See video preview to view the quality of this resource BEFORE you buy (click the video). FULLY RESOURCED set of lessons and ASSESSMENT. See the topic list below. This resource includes: 33 slide PowerPoint (this is also REALLY useful if given to students for revision, deleting instruction slides) 9 page work booklet for students to complete with lots of activities Quiz on Von Neumann Architecture Answers to the quiz Test on system architecture (40 marks) to assess progress in this unit Test mark scheme A 16 page revision booklet for students (this is the adapted lesson PowerPoint without instructions etc.) These resources have been mapped against GCSE OCR Computer Science (J276), Computer Systems Unit (J276/01) 1.1 System Architecture, though are useful for anyone teaching the following topics in Computer Science (any spec!): Hardware and Software Input and Output devices Internal components of a PC The CPU Parts of the CPU / registers Von Neumann Architecture Factors impacting on processor speed Cores

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!

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!

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.

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!

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.

An eight page student booklet and accompanying outline of six lessons of work that gets students to create a PowerPoint presentation about either the Loch Ness Monster or Big Foot to include text, links, images and sounds. This is a fun, short unit of work suitable for Key Stage 3 ICT or Computing lessons. I must stress that, unlike some of my other resources, this is not a pick up and go, fully planned unit of work. It is an engaging student booklet that is GREAT for collating evidence of student work and it is a collection of six lesson OUTLINES. Teachers will need to add to this in order to fully teach reliability and skills in producing a multimedia presentation. I'd see this as a perfect first unit for either year 7 or 8 to get them started for a year of engaging ICT or Computing lessons. Enjoy! Any feedback is, as always, greatly received.

'Understanding Computers'; scheme of work and accompanying student booklet for Key Stage 3 Computer Science. Fully planned and resourced, print and go. The unit of work has been referenced against the new KS3 programme of study for Computing. The unit includes short topics on hardware, software, devices, input, output, storage, binary numbers, convergence and future technologies and is a good basis for an introduction to computers. This unit would ideally suit year 7 or 8 students and has elements of differentiation throughout to allow teachers to deliver the same unit of work to multiple ability groups (save on the planning!). The scheme of work should also give you some fresh ideas for more creative teaching strategies in Computing. *Copyright Notice* I have produced this under the name Barnett Education (that's me!). All text is mine, all images are public domain and are credited (p.12 student book).