Professor Cody Teaches Kids to Code using Scratch 3.0 – Lesson 5 – Using Procedures & Functions This lesson introduces the concept of Procedures and Functions using My Blocks. Students have the opportunity of developing programs that use procedures to spray a car in a car factory as well as procedures used to build a house. They will also have the opportunity to create a function that returns a value to the main program. Students also have to complete a series of challenges at the end of each activity.

Professor Cody Teaches Kids to Code using Scratch 3.0 – Lesson 3 – Using Selection This lesson introduces the concept of selection and students have the opportunity of developing programs that use If and If then Else block structures. They will learn how to make a multi-answer quiz and create a Crack the Code game. Students also have to complete a series of challenges at the end of each activity.

These adaptable PowerPoint Presentations (38 Slides) cover all aspects of the specification in relation to AQA GCSE Computer Science 8525 (from 2020) component 3.8. It includes: Teaching PowerPoint Presentations (includes checkpoint questions and answers) - 38 slides Student PowerPoint Presentations (Includes checkpoint questions, but omits the answers) Content Covered: Explain the current ethical, legal and environmental impacts and risks of digital technology on society. Where data privacy issues arise, these should be considered. Exam questions will be taken from the following areas: • cyber security • mobile technologies • wireless networking • cloud storage • hacking (unauthorised access to a computer system) • wearable technologies • computer-based implants • autonomous vehicles.

These adaptable PowerPoint Presentations (23 Slides) cover all aspects of the specification in relation to AQA GCSE Computer Science 8525 (from 2020) component 3.7. It includes: Teaching PowerPoint Presentations (includes checkpoint questions and answers) - 23 slides Student PowerPoint Presentations (Includes checkpoint questions, but omits the answers) Content Covered: Explain the concept of a database. Explain the concept of a relational database. Understand the following database concepts: • table • record • field • primary key • foreign key. Understand that the use of a relational database facilitates the elimination of data inconsistency and data redundancy. Be able to use SQL to retrieve data from a relational database, using the commands: • SELECT • FROM • WHERE • ORDER BY…ASC | DESC Be able to use SQL to insert data into a relational database using the commands. INSERT INTO table_name (column1, column 2 …) VALUES (value1, value2 …) Be able to use SQL to edit and delete data in a database using the commands. UPDATE table name SET column1 = value1, column2 = value2 … WHERE condition DELETE FROM table_name WHERE condition

Two great programming games for your students to create. Each game provides education and entertainment for a one hour lesson, with a number of challenges to stretch pupils knowledge and understanding of programming concepts. Halloween Part 1 This game includes the creation of spooky ghosts that need to be caught. Each time you catch a ghost you get points. Halloween Part 2 This game includes a flying witch who is really hungry and gets points each time she eats a flying bat. The witch must also try to avoid the thunder and lightening as each time she is hit she loses points. Students can open an online Scratch template to get them started on their adventure.

This photocopiable resource has been produced to provide 7 to 14 year olds with exciting and engaging opportunities to learn coding concepts using Python in a fun standalone project. Mystery of the Crystal Ball - Students have fun looking into their future. Students learn to use the time and random modules, Variables and IF-ELIF statements. The project takes around one hour to complete and includes a series of activities to extend learning.

This photocopiable resource has been produced to provide 7 to 14 year olds with exciting and engaging opportunities to learn coding concepts using Python in a fun standalone project. Students learn about the random module, while loops, IF functions and variables. The project takes around one hour to complete and includes a series of activities to extend learning.

This photocopiable resource has been produced to provide 7 to 14 year olds with exciting and engaging opportunities to learn coding concepts using Python in a fun standalone project. Guess the number -Students have fun making a game to guess the number. They learn to use IF-ELSE Statements, the random module, variables and nested IFs. The project takes around one hour to complete and includes a series of activities to extend learning.

This photocopiable resource has been produced to provide 7 to 14 year olds with exciting and engaging opportunities to learn coding concepts using Python in a fun standalone project. Play the name game - Students have fun with their name. Students learn about print statements and manipulating text. The project takes around 30 minutes to complete and includes activities to extend learning.

This is a 17 page introduction to programming using Python. It includes: The use of Lists (arrays), including one and two dimensional arrays File handing operations (open, read, write and close) Each section includes activities for the students to complete. I would greatly appreciate feedback on what you think of this resource.

This is a 15 page continuation from Part 1 of programming using Python. It includes: The use of sequences and selection (including Boolean and comparison operators) The use of iteration (count and condition controlled loops) Each section includes activities for the students to complete. I would greatly appreciate feedback on what you think of this resource.

This photocopiable resource has been produced to ensure that your students are able to successfully complete their GCSE Computer Science GCSE (9-1), but can also be used by other exam systems. This test has been designed to provide a stimulating, engaging and effective way of assessing the progress of your students. As well as the topic test, you are also provided with a comprehensive marking scheme. Please be aware that there may be appropriate alternative answers to some of the questions, and it is therefore suggested that the teacher uses their discretion when marking students work.

This sample project is designed to provide a stimulating, engaging and effective way of preparing students for the Programming Project Component of the 9-1 GCSE in computer science. Students use Python to create a Quiz Board Game. Including: Sample project scenario Sample student solution Sample Python code

This photocopiable resource has been produced to ensure that your students are able to successfully complete their GCSE Computer Science GCSE (9-1), but can also be used by other exam systems. This test has been designed to provide a stimulating, engaging and effective way of assessing the progress of your students. As well as the topic test, you are also provided with a comprehensive marking scheme. Please be aware that there may be appropriate alternative answers to some of the questions, and it is therefore suggested that the teacher uses their discretion when marking students work. Python is used as the programming language.

This resource has been produced to determine a baseline for Year 7 students starting secondary school. The test is designed for Year 7 students who have been taught computing in primary school. As well as the baseline test, you are also provided with a comprehensive marking scheme for the test. Please be aware that there may be appropriate alternative answers to some of the questions, and it is therefore suggested that the teacher uses their discretion when marking students work.

This resource has been produced to teach 8 - 16 year olds about programming concepts by creating fun games using the text-based programming language Python. The activities and challenges have been designed to provide a stimulating, engaging and effective way of improving students knowledge of the core programming concepts. In this game students make a noughts and crosses game (tic tac toe) using Python. Students learn about sequences, selection using IF, variables and the use of iteration (Conditional and Count Controlled loops), 1D and 2D arrays.

This 35 page photocopiable resource has been produced to ensure that your students are able to successfully complete the Living in a Digital World component of the Edexcel ICT GCSE. These tests are designed to provide a stimulating, engaging and effective way of assessing the progress of your students. This set of topic tests provides complete coverage of Unit 1 and includes 5 standalone tests.

This video provides an introduction to the use of data types in programming. It’s a good idea to watch the video on variables before you watch this video. Find out about String, Integer, Real, Character and Boolean data types. Find out about how casting can be used to change a variable from one data type to another.