1. Resources Home
2. Primary
3. Computing
4. Computational thinking

#### Most used Excel functions - function, syntax, description quick reference sheets

This resource contains a Table of the most used functions in Excel. It is separated by Core functions, Date Functions, Text Functions, and Lookup / Reference Functions. It is set out attractively in a table, the column headings being: Function Name, Syntax and Description. It gives a quick reference to over 35 different functions. It is available in a pdf and word document so that you can make any changes required.

#### Year 7 Computing/ICT Scheme of work & Resources

Complete collection of Scheme of work, lesson plans, Power Points and homework for Year 7 introduction to computing and ICT. Includes: Topic 1 - Introduction &amp; using computers safely and effectively • 7 Lessons, Power Points, Assessment, Homework and Pupil Progress Diary Topic 2 - Introduction to coding through Scratch • 5 Lessons (can be stretched depending on pupil progress), Power Points, Assessment, homework and Pupil Progress Diary Topic 3 - Spreadsheet Modelling • 6 Lessons, Power Points, Assessment, homework and Pupil Progress Diary All lessons are ready to teach and require minimal, if any preperation (may need tweaking to work with your school system) - everything is provided! Pack includes a scheme of work with lesson objectives and lesson overview and how these lessons fit into and satisfy the new National Curriculum for Computing. Ideal resource for non-specialists to follow, or for a specialist to pick up and run with. Feel free to adapt the resources as needed. All lessons are ready to teach. Year 8 and Year 9 packs coming soon.

#### Computer Science GCSE - Logic Gates - Match up the name, symbol, description and truth table

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.

#### Logic - Exam practice - Computer Science GCSE 0478

A mix of exam questions adapted from past papers. Complete with answers and student worksheets

#### Logic Statements to Circuits - Computer Science GCSE 0478

Logic Statements to Circuits - Computer Science GCSE 0478 Unit 3 – Logic Statements to Circuits A set of exam questions with answers and step by step instructions adapted from past papers Each with solution on presentation and a worksheet for students Ideal for teaching how to answer exam style questions

#### Mobile Application Development Activity

This could be used whilst teaching ‘Appshed’ to KS3 students. It would be a good homework for either the 1st or 2nd week as it begins to questions the features of mobile applications which will support when students begin to draft their own applications. This could either be used as an activity in class or as a homework.

#### App Inventor Alluring Audio - (Lesson 4)

This is the forth lesson in the ‘App Inventor’ scheme of work. This lesson combines practical and theory to teach the “representing sound” concepts covered in the Computer Science 9-1 GCSE specifications, (including; sample rate, sample resolution &amp; calculating audio file size.) All lessons within the scheme are targetted at KS3/KS4. Each slide includes detailed notes to support teacher understanding and have been based on a lesson plan structure. There is no prior knowledge required from the class teacher as the guides provided are step-by-step &amp; all code is catered for in the documentation provided. For this lesson a video tutorial is available to support learners with the design of their app. The lesson includes a minimum 45 minute assessment (electronic &amp; paper based included) with mark scheme both of which are custom made, this will truly test learner’s understanding. Using the ‘App Inventor’ emulator or a mobile device with the 'MIT App Inventor app’ installed will allow learners to practically use the apps they build. The app can be downloaded freely from the ‘Google Play’ store.

#### Small Basic Text Window (Using For and While Loops)

Worksheet for students to assist them in generating Small Basic code to write a times table and list multiples of a number. (Output in the Text Window) This activity will develop understanding of For and While loops (and consoldiate use of a variable e.g. name) Answers for the teacher included. The worksheet is available in** .docx** and **.pdf **formats.

#### Small Basic Graphics Window (FULL LESSON drawing a polygon)

FULL LESSON for teaching students how to use Small Basic Graphics Window. **Learning objectives: • Identify mistakes in Small Basic code • Predict what given code will do • Choose code to complete a given outcome Some students will be able to: Comment their code ** Teacher presentation included for large display. Full lesson plan included. 3 levels of worksheets included for use with differentiated groups in your classroom. PowerPoint with further examples of small basic code for optional demonstration to students/further explanation of lesson outcomes.

#### Python Pack

a collection of text files which feature python code including: Creating coloured patterns Guess the Number X’s and O’s

#### X's and O's Python Game

a text file which contains the python code for a X’s and O’s game

#### Computational Thinking - Decomposition and Abstraction

A whole lesson with information slides and activities to introduce the computing concepts of decomposition and abstraction. Includes an extended writing task focusing on A.I with accompanying informational video links.

#### Excel Chart Types Activity

This resource can be used during a lesson with Excel Charts. It is useful to become familiar with different chart types and their application. The activities can be carried out individually, in pairs or in teams. It is always more fun to team up, as two heads are better than one and lots of discussion can be generated. Files are available in both pdf and docx format for editing if required. Preparation for Mix N Match Activity: Print out the document named ‘Chart Type Activity Answers’ Laminate the sheets (optional) Cut out all the segments Learners now match up all three elements (Chart name, Description, Picture). This activity can be timed and completed in teams to add a competitive edge. Other Activity Options: Print out the document named ‘Chart Type Activity without Chart Type’. Learners will review the description and the pictorial view and name the Chart Type. Print out the document named ‘Chart Type Activity without Description’. Hand out the cut outs of ‘Descriptions’. Learners place them in the appropriate slot. Print out the document names ‘Chart Type Activity without Picture’. Hand out the cut outs of ‘Pictures’. Learners place them in the appropriate slot.

#### Flowcharts and Computational Thinking

An ideal lesson to continue learning of computational thinking and flowcharts. Encourages correct use of symbols and application of knowledge with open ended tasks as well as worksheet which can be used as an assessment material. Requires previous knowledge of flowcharting including correct symbols.

#### App Inventor FortuneT --- (Lesson 3)

This is the third lesson in the ‘App Inventor’ scheme of work. This lesson introduces programming concepts including; Variables, data structures &amp; the randomise method in a completely interactive manner. All lessons within the scheme are targetted at KS3/KS4 and appropriately mapped to elements of the Computer Science 9-1 GCSE. Each slide includes detailed notes to support teacher understanding and have been based on a lesson plan structure. There is no prior knowledge required from the class teacher as the guides provided are step-by-step &amp; all code is catered for in the documentation provided. Using the ‘App Inventor’ emulator or a mobile device with the 'MIT App Inventor app’ installed will allow learners to practically use the apps they build. The app can be downloaded freely from the ‘Google Play’ store.

#### Presentation: how a selection sort works

Presentation on how a selection sort works. It includes: A presentation explaining the principle of operation behind a selection sort A presentation introducing the code written in python to perform a selection sort The selection sort python code in a separate text file.

#### Planning to Code (DS for Kids aONP)

10 single-page resources that require the planning of data structures as a prerequisite for coding. Simple variables, lists and more complex structures.

#### Programming Using Kodu

Students will understand the term ‘programming’ whilst using Kodu. Students will use Kodu to create a world and program Kodu to move. Students will then design and create their own game whilst providing evidence. Lesson One-Six Kodu Lesson Seven Revision Lesson Eight Assessment Lesson Nine Feedback and Improvements This unit has a lesson presentation for every lesson that includes a starter activity, main activity and plenary. Resources also include homework, worksheets, helpsheets and an overall assessment sheet that can be used for self, peer and teacher assessment. A full Scheme of Work is also provided. This unit of work is suitable from Years 6-8 depending on ability.

#### App Inventor Drawing Tools -- (Lesson 2)

This is the second lesson in the ‘App Inventor’ scheme of work. This lesson introduces learners to being able to apply drawing tools in ‘App Inventor.’ Learners will code a solution to a given problem and will apply computational thinking skills. All lessons within the scheme are targetted at KS3/KS4 and appropriately mapped to elements of the Computer Science 9-1 GCSE. Each slide includes detailed notes to support teacher understanding and have been based on a lesson plan structure. There is no prior knowledge required from the class teacher. Using the ‘App Inventor’ emulator or a mobile device with the 'MIT App Inventor app ’ installed will allow learners to practically use the apps they build. The app can be downloaded freely from the ‘Google Play’ store.

#### Find your way Algorithms, Coordinates (Coding and STEM for Juniors)

Can you guide the little pig to his mud pit by using a range of common commands and instructions. Incorporates elements of algorithmic design, coding, mapping and location

#### Create your own dance sequence (Algorithms, Coding and STEM for Juniors)

Teach younger students the basics of following and creating algorithms with these fun and engaging worksheets.

#### Name that Animal QR Code Challenge ( STEM for Juniors )

Introduce your students to QR codes with these easy to follow worksheets incorporating the concepts computational thinking and abstraction.

#### Decoding Sight Words ( Coding & STEM for Juniors )

Teach younger students the basis of ciphers, cryptography and decoding with these 4 technology based sight word worksheets.

#### GUESS WHO COMPUTATIONAL THINKING CHALLENGE (STEM & DIGITAL TECHNOLOGIES )

☀️ This has got to be one of our most engaging STEM activities yet!!! An absolute cracker of a resource for teaching COMPUTATIONAL THINKING, ALGORITHMS, MATHS and TECHNOLOGY. The challenge is simple… CAN YOU CREATE THE PERFECT FACIAL RECOGNITION ALGORITHM? It draws upon the classic game “GUESS WHO?” to instantly engage students with ease. The learning is incredibly deep and this resource could easily FILL A WEEK of class time or a single 90 minute session depending on how far you wish to go… And it’s completely EDITABLE Whats inside ⭐Computational Thinking resources and activities related to the topic ⭐Teacher Hints and Tips ⭐ Complete lesson plans ⭐ Facial Recognition Lessons and Content ⭐ Removable / Hints and Tips for Beginners ⭐ Lessons on Data and Attributes ⭐ Custom made Graphic Organizers ⭐ Custom made Flowcharting Activities ⭐ Heaps of digital video and interactive content ⭐ Literacy related tasks to the ethics of facial recognition ⭐ Glossary of terms ⭐ Video tutorial explaining the perfect solution ⭐ Assessment and Reflection Tool Compatibility with Google Classroom and NO PREP REQUIRED

#### Coordinates Color in ( Coding and STEM for Juniors )

✨ Teach your students the basic elements of coordinates, pixels and how a television screen works with these simple to follow coordinate color in worksheets.

#### Itsy Bitsy Spider Algorithm Challenge (STEM and Coding for Juniors)

✨Draw upon a classic nursery rhyme to teach younger students the basics of coding and algorithms with these easy to follow worksheets. Or alternately you can create your own path for the spider to follow.

#### Computer Science Poster: How to read and write Edexcel pseudo code

This handy poster is a great revision tool to help your GCSE computer scientists prepare for their computational thinking problem solving paper! Although focused around Edexcel specification, it is also easily applicable for others. This poster will help your students to both understand what the pseudo code means within exams as well as help them write their own, well structured pseudo code. Update: High Resolution 1440x2560 in both PNG &amp; JPEG Please leave a review

#### End of year Computing Summer Quiz 2018

NEW COMPUTER SCIENCE QUIZ FOR THE END OF YEAR / SUMMER TERM 2018! A fun whole class quiz, ideally suited to keep pupils engaged and settled for the final lesson of the summer term. Suitable for year 7 to year 11. The quiz includes computer science elements as well as other fun summer related questions getting them into the summer holiday spirit. Guaranteed to make the final lesson fun before they break up for summer. Print out the answer sheets (enough for 1 per team) and then run through the quiz on the whiteboard. After each section the answers are provided allowing the quiz to easily be cut shorter if you wish. Suitable for GCSE Computer Science classes and KS3 Computing and ICT classes.

#### Introduction to Computer Science

An ideal first lesson to introduce the subject or topic surrounding computing, computer science or computational thinking. -Computational Thinking -Introduction to Flowchart design Complete with information slides, activities, starter and plenary. Suitable for a 1 hour lesson.

#### Introduction to OCR GCSE Computer Science

This resource is great to use for you’re first lessons with year 9’s as an introduction to GCSE Computer Science.

#### Microbit- a lazy set of 6 problem-solving lessons

This is a great set of lessons for microbit that require NO prep on the teacher, entirely student led, guaranteed to create engagement. Perfect for year 7 but could be extended to year 8 and 9 as well. my students love it! it gives opportunity for discussion,planning, pseudocode,flowchrt, testing. each lesson has a real life problem that the students need to solve using the microbit I used the microbit “let’s create” block editor online software (which will give simulation of the real microbit on days when i am too lazy to even get the microbits off the shelf!),though my higher students are asked to complete it in Python once they have solved the problem successfully in the block editor.

#### Gamemaker Language Resource

I have made this resource using GameMaker to help teach how to use GameMaker Language. The resource is interactive and allows object to be dragged into space and code dragged onto the object to see what the code does. It explains all code that can be dragged onto object. It is bug/error free but there are things I plan to add when I have more time. There are some easter eggs like the player objects can be controlled by WASD. Please see my other resource if you want something to support teaching logic gates and boolean algebra. You will need to extract the zip and make sure both files are together when running the .exe. Please support me with reviews and constructive feedback, this will encourage further contributions. Please do not maximise the window as this will cause the mouse pointer to not set objects down properly.

#### Python Mathematical Operators Practical Challenges

A great 2 page handout for your pupils to practice using mathematical operators and functions in Python. Includes example code, a task to correct code and 6 practical challenges for them to practice writing for loops in Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.

#### Python Random Values Practical Challenges

A great 2 page handout for your pupils to practice using random values in Python. Includes example code, a task to read code, a task to correct code and 4 practical challenges for them to practice writing for loops in Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.

#### Year 9 Computer Science Assessment

This year 9 computer science assessment could either be used at the start of the year to assess suitability or at the end to assess learning. Another option is to do both and measure student progress and impact of teaching. Students aspiring to student computer science at GCSE must aim to score between 30 and 75. Answers/ Mark scheme provided.

#### Scratch UltraBundle - 3 Units

This bundle includes the Scratch beginner’s bundle, intermediate bundle and expert bundle all in one. I have used this for Years 5-7, using one unit each year as they move up the school. This could be used for other year groups as they encounter and improve with Scratch. Each unit should take 6-8 lessons, which is why I have spread them out over three year groups. In total there are 18 different resources bundled together here.

#### KS2 / KS3 Scratch Expert Bundle

This bundle is the third in a series of Scratch units, intended for KS3 or possibly high ability KS2 students. The first two lessons include looking at flowcharts and creating an algorithm using a flowchart, which then feeds into creating the game in Scratch. The third lesson involves creating a slug trail maze, which draws on what they might have done previously in creating mazes and drawing with the pen tool. The fourth lesson is more in depth with a look at variables and iteration, creating an endless scrolling flying game. The fifth lesson involves debugging and coding a Space Invaders-style game using starter code. This task includes subroutines and is the hardest of the unit. The unit ends with a project (3+ lessons) where the students create their own game based on some loose instructions. They then write about how they have made their game using a template in Powerpoint.

#### KS3 Scratch Game Project

This resource is a set of instructions for KS3 students to create their own game. Ideally they will be at or near to finishing with Scratch before moving on to more complex programming languages. This is intended for the end of my KS3 Scratch Unit of work. Included is the Word document which details what they will need to include in their game (and what they might want to include), as well as an example game evaluation written in Powerpoint to make it easy for them to write about. There is also a skeleton evaluation which describes what they need to include in their evaluation. As the students can create their own game and need to write about how they have made it, this is likely to take a minimum of three lessons.

#### KS3 Scratch Space Intruders game tutorial

This resource includes a finished Space Invaders-style game made with Scratch, as well as a starter code version of the game and a tutorial/help sheet. This is intended for one lesson to help teach variables and subroutines. The finished version can be shown as a demonstration of how the game should work, then the students can be shown the starter code. This version does not work, and they will need to complete the tasks on the tutorial to get it working correctly. The tutorial includes screenshots of code snippets and explanations of how any why they work to get the game functioning correctly.

#### KS3 Endless scrolling game scratch tutorial

This resource is a tutorial to help students understand how variables and iteration are used to create a simple scrolling game. The tutorial includes screenshots of code snippets and instructions on how and why the code works to create the finished version of the game. The resource also includes the finished version of the game, which I use to demonstrate the game before showing the first few steps in making it. The tutorial can be used as a help sheet for students who push on further with the game before the rest of the class, or who might need help in getting their game to work as intended.

#### KS2/KS3 slug trail maze tutorial

In this resource is a working version of a ‘slug trail’ maze game, and a Word document tutorial to go with it. The tutorial can be given to students as a help sheet once they have been given an introductory demonstration, or if they are pushing on further than the rest of the class. The tutorial help sheet includes screenshots of code and explains how and why this code is used to create the finished version of the game.