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

These adaptable PowerPoint Presentations (188 Slides) cover all aspects of the specification in relation to OCR GCSE Computer Science J277 (from 2020) component 1.2. It includes: Teaching PowerPoint Presentations (including checkpoint questions and answers) Part 1 – Memory (33 Slides) Part 2 – Secondary Storage (45 Slides) Part 3 – Data Storage – Numbers (49 Slides) Part 4 - Data Storage: Characters, Images & Sound (61 Slides) Student PowerPoint Presentations (Including checkpoint questions, but omits the answers) Part 1 – Memory Part 2 – Secondary Storage Part 3 – Data Storage – Numbers Part 4 - Data Storage: Characters, Images & Sound Content Covered: The need for primary storage The difference between RAM and ROM The purpose of ROM in a computer system The purpose of RAM in a computer system Virtual memory The need for secondary storage Common types of storage: Optical Magnetic Solid state Suitable storage devices and storage media for a given application The advantages and disadvantages of different storage devices and storage media relating to these characteristics: Capacity Speed Portability Durability Reliability Cost The units of data storage: Bit Nibble (4 bits) Byte (8 bits) Kilobyte (1,000 bytes or 1 KB) Megabyte (1,000 KB) Gigabyte (1,000 MB) Terabyte (1,000 GB) Petabyte (1,000 TB) How data needs to be converted into a binary format to be processed by a computer Data capacity and calculation of data capacity requirements Numbers How to convert positive denary whole numbers to binary numbers (up to and including 8 bits) and vice versa How to add two binary integers together (up to and including 8 bits) and explain overflow errors which may occur How to convert positive denary whole numbers into 2-digit hexadecimal numbers and vice versa How to convert binary integers to their hexadecimal equivalents and vice versa Binary shifts Characters The use of binary codes to represent characters The term ‘character set’ The relationship between the number of bits per character in a character set, and the number of characters which can be represented, e.g.: ASCII Unicode Images How an image is represented as a series of pixels, represented in binary Metadata The effect of colour depth and resolution on: The quality of the image The size of an image file Sound How sound can be sampled and stored in digital form The effect of sample rate, duration and bit depth on: The playback quality The size of a sound file The need for compression Types of compression: Lossy Lossless

These adaptable PowerPoint Presentations (74 Slides) cover all aspects of the specification in relation to AQA GCSE Computer Science 8525 (from 2020) component 3.1. It includes: Teaching PowerPoint Presentations (includes checkpoint questions and answers) -74 Slides Student PowerPoint Presentations (Includes checkpoint questions, but omits the answers) Content Covered: Understand and explain the term algorithm. Understand and explain the term decomposition. Understand and explain the term abstraction. Use a systematic approach to problem solving and algorithm creation representing those algorithms using pseudo-code, program code and flowcharts. Explain simple algorithms in terms of their inputs, processing and outputs. Determine the purpose of simple algorithms. Understand that more than one algorithm can be used to solve the same problem. Compare the efficiency of algorithms explaining how some algorithms are more efficient than others in solving the same problem. Understand and explain how the linear search algorithm works. Understand and explain how the binary search algorithm works. Compare and contrast linear and binary search algorithms. Understand and explain how the merge sort algorithm works. Understand and explain how the bubble sort algorithm works. Compare and contrast merge sort and bubble sort algorithms.

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)

These adaptable PowerPoint Presentations (69 Slides) cover all aspects of the specification in relation to AQA GCSE Computer Science 8525 (from 2020) component 3.5. It includes: Teaching PowerPoints (including checkpoint questions and answers) - 69 slides Student PowerPoints (Including checkpoint questions, but omits the answers) Content Covered: Define what a computer network is. Discuss the advantages and disadvantages of computer networks. Describe the main types of computer network including: • Personal Area Network (PAN) • Local Area Network (LAN) • Wide Area Network (WAN). Understand that networks can be wired or wireless. Discuss the advantages and disadvantages of wireless networks as opposed to wired networks. Describe the following common LAN topologies: • star • bus. Define the term network protocol. Explain the purpose and use of common network protocols including: • Ethernet • Wi-Fi • TCP (Transmission Control Protocol) • UDP (User Datagram Protocol) • IP (Internet Protocol) • HTTP (Hypertext Transfer Protocol) • HTTPS (Hypertext Transfer Protocol Secure) • FTP (File Transfer Protocol) • email protocols: • SMTP (Simple Mail Transfer Protocol) • IMAP (Internet Message Access Protocol). Understand the need for, and importance of, network security. Explain the following methods of network security: • authentication • encryption • firewall • MAC address filtering. Describe the 4-layer TCP/IP model: • application layer • transport layer • internet layer • link layer. Understand that the HTTP, HTTPS, SMTP, IMAP and FTP protocols operate at the application layer. Understand that the TCP and UDP protocols operate at the transport layer. Understand that the IP protocol operates at the internet layer.

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

This photocopiable resource has been produced to ensure that your students are able to successfully complete the OCR Computer Science GCSE NEA. This support pack is designed to provide a stimulating, engaging and effective way of preparing both teachers and students for the Non-Examined Assessment Component of the 9-1 GCSE in computer science. The pack contains: Introduction for students - NEA Procedures Technical Preparation for the NEA component J276 Programming project Sample Task 1 - Archside Academy Detention Database. Including: NEA sample project scenario NEA sample student solution NEA sample Python code J276 Programming project Sample Task 2 - Quiz Board Game Including: NEA sample project scenario NEA sample student solution NEA sample Python code Help sheet 1 - Creating a board game using Python - Includes a complete set of instructions Help sheet 2 - Creating a database using Python - Includes a complete set of instructions Help Sheet 3 - Menus, Lists and Exporting using Python - Includes a complete set of instructions

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

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.