Whole-school computing resources

Teach the basics of Microsoft Word to beginners. The lesson engages students in following along with the basics of formatting, image insertion, creating tables, lists and useful tips. The lesson easily explains concepts which enable the learner to get to grips with the interface and create effective documents. There is a starter activity along with support materials required for the lesson. The teacher notes are in the comments for each slide, along with key points for demonstration and challenges for students if they complete the work. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn

Due to the prevalence of technology, cyber security is one of the greatest opportunities and threats humankind knows. Your pupils will already use computers on a daily basis, but probably don’t pay much attention to personal data, or even know what it is! It’s time to change that, and this lesson is a great place to start bringing together elements of both the IT and computing curriculum. It will also teach your class the Army-inspired skills of critical thinking, team work, leadership and perseverance.

Kodu is a friendly graphical programming language where students can build their own world and program objects within. This series of lesson uses kodu to introduce computer science terminology such as algorithm and variables to develop computational thinking skills.

This is the first lesson within the scheme that introduces learners to the online application, ‘App Inventor’. Regardless, of class ability or teacher experience this lesson will allow learners to develop an understanding of how apps have developed over time and will allow learners to build their first Android app. The easy to use guidance illustrates how to set up accounts and is available in both PDF and DOC format to suit learner needs. The app can be deployed to any android device providing the ‘App Inventor’ app is installed. Equally the’ App Inventor’ emulator can be installed on any networked machine. This lesson is particularly applicable to all computer science specifications and can be used to delve into the aspect of mobile development with ease and confidence. There is detailed notation and timings for teachers within the PPT which will offer a lesson plan structure. For more information or further resources linked to this topic, contact via e-mail.

Created this resource to support my CIDA group. This can be used with any version of FLASH and then imported into a web design program. simple step by step instructions to follow How to import and export Use the Animated Timeline Create simple banner animations in a flash

Pupils can use this resource to familarise themselves with 8-bit binary. Use color instead of 1’s and leave squares blank if they are 0’s Example on first pattern Three Pattern Levels Easy to Hard If the pupils complete the calculations correctly, they will have created retro game sprites.

A year plan of Computing curriculum for KS3 with dates/ times and assessment points. A suggested mastery SOL of KS3 to support the current Computer Science GCSE.

Guess the Celebrities eyes. Teacher goes through the slides on PowerPoint whilst pupils have to write down who they think the eyes belong to. The second part is a Guess the logo quiz, can be useful to use with Computing/Graphic lessons

Created this DIRT sheet for my Year 8’s but can be used for any year group. SIMPLE TO FOLLOW Teacher can look through their scratch projects and tick the boxes the pupils have covered in their Project. Pupils can then reflect on their project and suggest improvements they could make.

Created this resource to prepare pupils for CIDA exam and work. Simple stepe by steps Resoursce Template included

Created a guide for my pupils to create a simple web banner using Photoshop Elements. This was to prepapre my pupils for both CIDA exams and Web design tasks. Simple step by step Image included

A Mathematical Investigation Assessment Item for Year 8 & 9 looking at algorithms with Excel and Python.

This resource was developed for Advanced Higher Computing Science (Scottish Curriculum). It describes a linked list and works through the implementation in PHP of the following operations: insert and delete nodes, read the contents of a node, count the number of nodes, read the whole structure. Some suggestions are given for programming problems involving linked lists.

Teach the basics of Microsoft PowerPoint to beginners. Students will learn how to manage the production of a slide-show and the common errors that people make. There is advice about the use of images and presentation style. The 21 Slide PowerPoint is designed to deliver the whole lesson along with a starter activity. The lesson contains one mini activity and a main challenge. There are teacher notes in the comments for each slide, along with key points for demonstration and challenges for students if they complete the work. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn

A handout summarising what global and local variables are A worksheet for them to predict the output and then to try the code themselves (Python)

An introduction to algorithms using a flowchart with sequence, selection and iteration. The worksheet provided enables students to slow down their thinking to focus on each instruction in the algorithm until the last instruction is executed and the program ends.

Topics included: Computer Architecture Ethics Input Devices Memory Storage and media Programming concepts Pseudocode and Flowcharts Algorithm Design

IGCSE Computer science unit of work for computer Architecture, Languages and Operating systems

Worksheet for IGCSE computer science Logic Gates unit, covers all spec points in unit.

Worksheet for IGCSE computer science input devices unit, covers all spec points in unit.

Worksheet for IGCSE computer science sensors unit, covers all spec points in unit.

Worksheet for IGCSE computer science memory, storage and media unit, covers all spec points in unit.

Worksheet for IGCSE computer science output devices unit, covers all spec points in unit.

Worksheet for IGCSE Computer Science that covers the full units content.

Full set of worksheets for iGCSE computer science security unit.

Full set of worksheets for iGCSE computer science units included programming concepts, pseudo code and flowcharts and algorithm design and problem solving. Intended to be taught as linked units for a more comprehensive learning style.

Kodu is a friendly graphical programming language where students can build their own world and program objects within. This series of lesson uses kodu to introduce computer science terminology such as algorithm and variables to develop computational thinking skills.

Complete notes for paper 1 and 2

Hardware revision sheet.

This resource is a worksheet that contains a list of Word shortcut keys from Ctrl A to Ctrl Z. Learners fill out the worksheet to the best of their ability either individually or as a group exercise. An answer sheet is provided. They can then go and try out all the shortcuts for themselves.

This is the second part of a two part resource aimed at helping teachers present how to complete the project unit R013 for the new OCR nationals in ICT. It is a work in progress and other units will be placed on TES when available. I have uploaded this work prior to completion of all the units because I cannot find many free resources in this area of study and wanted to help other teachers if I could.

This is part 1 of a two part resource aimed at helping teachers present the Project Life Cycle. It is a work in progress and is designed to help with the creation of the project R013 element of the course but could also be used to cover many elements of unit R012 (Theory Exam). Please also upload part 2

Last week I found a small UK tech company which was giving out great computer prizes and no-one was entering them. I decided to use them to create a drawing competition in my class - after all what is more motivational to a class than a great chance of winning! I used it to share ideas about what makes a great invention. We discussed ideas of what would or would not win - then created our work of art. INVENT THE 2098 WORLD CUP Future Inventors, we have a new challenge for this week. The World Cup is about to start and it got us thinking: what will the 2098 World Cup look like? Flying referees? Virtual stadiums? Techno-vuvuzelas? Submit your ideas and the winner gets a FREE kit and see it become a project on Club Make! We accept ALL ideas: practical, fun to absolutely bonkers. Entering the challenge is super easy: just draw your idea and share it below! They accept submissions until the 24th of June at http://bit.ly/WinARobot.

A worksheet that allows pupils to convert between binary and denary / denary binary.

Understanding variables and loops are the most significant aspects of coding. It is important for students in early stages to grasp the concept of how loops work if the are to be successful candidates for computer science. This power point presentation is a scaffold building fundamental steps required in understanding and applying loops using python. Students must already know how to use basic input and output functions in python. The language and terminology used is simple enough for a non specialist to use and teach a coder at beginner level. The python idle software is available to download for free at https://www.python.org/downloads/. After students have fully grasp the concept of loops and how they work, they extension task will provide a challenge for them to apply their knowledge, using computational thinking to improve their code.

Computer Science GCSE CIE 0478 Unit: 3 Topic: Logic Gates A task to match up the name, symbol, description and truth table for each logic gate. The task produces a single A4 sheet/table which is great for a reference/revision of the topic. Students complete a table with four headings; name, symbol, description and truth table. All the details are provided and can be copied and pasted into the table. Final results can be printed and used for revision or as a quick reference guide during the topic. A homework has been included to reinforce the learning. Please leave some feedback.

A worksheet activity adding binary numbers and conversions to denary. Starts with 4 bits (nibble) and moves on to 8 bits (byte) additions. There is also an accompanying answer sheet. The activity also has some general questions about binary for students to answer, which could be part of an extension or small research activity.

The resource is specifically based against the IGCSE Computer Science syllabus, but is suitable for any Data Storage module. It includes some knowledge tests at the beginning and leads on to creating 5 groups to work on a presentation about a different element of Data Storage. The group worksheets can be handed out or sent electronically and each has a series of keywords to prompt research. Each group is challenged with answering one Big Question and explaining it to the class at the end of the lesson. If you find the resource useful please leave a review so that others can find it. HackDragn

Teach the basics of Microsoft Excel to beginners. Students will learn the difference between workbooks and worksheets, cell referencing, simple calculations, auto complete, formatting and functions (SUM, AVERAGE, MAX and MIN). There is a starter activity and 3 tasks to complete in a student spreadsheet which can be distributed. There are teacher notes in the comments for each slide, along with key points for demonstration and challenges for students if they complete the work. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn

8 page PDF document with a Karnaugh map on each page. Answer booklet included showing groups and final solutions. I have used these sheets after teaching this topic as a starter to ensure over a number of lessons that the students haven’t forgotten how to find boolena expressions from a Karnaugh map representation.

Under the Sea - using Google Expedition to explore Coral Reefs around the world and create a short animation using Scratch to show the different animals and highlight the impact humans are having on Coral Reefs. Grade 3 Geography and Computer Science Google Expedition - Underwater Excursion Scratch - creating a short animation

Computer Science and Music For Grade 3 Pupils Exploring making music through the use of Scratch and Google Expeditions to compare how music is made in a music studio. Google Expedition - Recording Studio - Capturing Sound Scratch