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.

Programming project Sample Task 1 - Archside Academy Detention Database. Including: Sample project scenario Sample student solution Sample Python code

These adaptable PowerPoint Presentations (121 Slides) cover all aspects of the specification in relation to Edexcel GCSE Computer Science 1CP2 (from 2020) topic 4. It includes: Teaching PowerPoints (including checkpoint questions and answers) Student PowerPoint (Including checkpoint questions, but omits the answers) Content Covered: · understand why computers are connected in a network · understand different types of networks (LAN, WAN) · understand how the internet is structured (IP addressing, routers) · understand how the characteristics of wired and wireless connectivity impact on performance (speed, range, throughput, bandwidth) · understand that network speeds are measured in bits per second (kilobit, megabit, gigabit) and be able to construct expressions involving file size, transmission rate and time · understand the role of and need for protocols (Ethernet, Wi-Fi, TCP/IP, HTTP, HTTPS, FTP and email (POP3, SMTP, IMAP)) · understand how the 4-layer (application, transport, network, data link) TCP/IP model handles data transmission over a network · understand characteristics of network topologies (bus, star, mesh) · understand the importance of network security, ways of identifying network vulnerabilities (penetration testing, ethical hacking) and methods of protecting networks (access control, physical security, firewalls)

This pack consists of 13 end of topic tests that can be used to support your delivery of the course. In addition, the topic test bundle also contains a mark scheme for each test. Topic 1 & 6 - 3 Tests Topic 2 – 1 Test Topic 3 – 5 Tests Topic 4 – 2 Tests Topic 5 – 2 Tests

Professor Cody Teaches Kids to Code using Scratch 3.0 – Lesson 6 – Using Arrays (Lists) This lesson introduces the concept of Arrays using Scratch Lists. Students have the opportunity of developing programs that use arrays to make a birthday present list. They also get to make a memory game, where they have to memorise a series of items in a list. Finally, they use an array to create a high scorer list in a game. 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 2 – Using Variables This lesson introduces the concept of variables and students have the opportunity of using text variables and number variables and completing a series of challenges.

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

Professor Cody Teaches Kids to Code using Scratch 3.0 – Lesson 4 – Using Iteration (Repetition) This lesson introduces the concept of Iteration (Repetition) and students have the opportunity of developing programs that repeat loops as well as forever loops. They will learn how to make programs more efficient by creating shapes using a repeat loop and will then move on to create a scary game using repeats and forever loops. 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 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 1 – What is Coding? This lesson is about algorithms and how they are used to produce computer programs. Students will learn about the use of sequences of instructions and why it is important that these instructions are given in the correct order. They will create a dance computer program, add music and watch their very own choreographed dance!