I started out as a science teacher and made the transition to teaching ICT and Computer Science, which I have now been doing for over 20 years. I have also worked with primary school teachers to support their delivery of the national curriculum in computing.
Edulito is a UK based educational publishing company that provides learning resources for school-aged children. All of the available resources have been tested in UK schools.
I started out as a science teacher and made the transition to teaching ICT and Computer Science, which I have now been doing for over 20 years. I have also worked with primary school teachers to support their delivery of the national curriculum in computing.
Edulito is a UK based educational publishing company that provides learning resources for school-aged children. All of the available resources have been tested in UK schools.
These adaptable PowerPoint Presentations (50 Slides) cover all aspects of the specification in relation to OCR GCSE Computer Science J277 (from 2020) component 2.3.
It includes:
Teaching PowerPoint Presentations (includes checkpoint questions and answers)
Student PowerPoint Presentations (Includes checkpoint questions, but omits the answers)
Content Covered:
Defensive design considerations:
Anticipating misuse
Authentication
Input validation
Maintainability:
Use of sub programs
Naming conventions
Indentation
Commenting
The purpose of testing
Types of testing:
Iterative
Final/terminal
Identify syntax and logic errors
Selecting and using suitable test data:
Normal
Boundary
Invalid
Erroneous
Refining algorithms
This activity pack contains five Christmas themed coding activities which can be used by students in KS2 and KS3. Students learn about sequence, selection and iteration, as well as how to use variables and arrays. All instructions on how to develop the code using Scratch 3.0 have been included, as well as several challenges for each activity. The pack is 35 pages and will take around 3 hours to complete all activities and challenges.
Activity 1 - Decorating the living room ready for Christmas - Make the Christmas decorations sparkle!
Activity 2 - Dancing Santa - Get Santa to dance - simple dances to choreographed dances.
Activity 3 - Christmas Gift Game - Christmas presents float around the screen and if you can click on a present you get to see what’s inside!
Activity 4 - Catch the Reindeer Game - In this game Santa has lost his reindeer (including Rudolph) and he has to catch them. At the same time he must avoid the dog pretending to be a reindeer.
Activity 5 - Naughty or Nice - In this activity Santa must check the Nice list before he gives a present.
The Python Programming Christmas Activities is designed for KS4.
This pack includes four practice exam papers with mark schemes for OCR GCSE Computer Science (9–1) specification (first teaching September 2020, examinations from 2022).
These papers provide students with an opportunity to familiarise themselves with the look and feel of an OCR paper.
The digital pack includes:
· two practice papers for Computer Systems (Paper 1)
· two practice papers for Computational thinking, algorithms and programming (Paper 2)
The papers combined cover all aspects of the computer science curriculum.
You will also receive a comprehensive mark scheme for each paper.
This pack includes four practice exam papers with mark schemes for Edexcel GCSE Computer Science (9–1) specification (first teaching September 2020, examinations from 2022).
The papers have been written to replicate the style of Edexcel examinations. These papers provide students with an opportunity to familiarise themselves with the look and feel of an Edexcel paper. Python is the programming language used.
The digital pack includes:
· two practice papers for Principles of Computer Science (Paper 1)
· two practice papers for Application of Computational Thinking (Paper 2) – Included with these papers are Python files for access by students during the exam and a complete set of Python file solutions.
The papers combined cover all aspects of the computer science curriculum.
You will also receive a comprehensive mark scheme for each paper.
These resource has been produced to teach 7 to 14 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.
This resource includes 7 Christmas themed, stand alone activities for students learning how to program using Python.
The activities go from basic activities to more complex tasks. Some of the skills and knowledge tested includes using input, FOR and WHILE loops, string manipulation, lists, exporting to an external file and importing from an external file.
This pack consists of 14 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.
Unit 1.1 – 1 Test
Unit 1.2 – 3 Tests
Unit 1.3 – 2 Tests
Unit 1.4 -1 Test
Unit 1.5 - 1 Test
Unit 1.6 - 1 Test
Unit 2.1 - 1 Test
Unit 2.2 - 1 Test
Unit 2.3 - 1 Test
Unit 2.4 - 1 Test
Unit 2.5 - 1 Test
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
This unit provides at least 6 hours of KS3 lessons on the use computer hardware components in a computer system. At the end of the units students are provided with an assessment to assess their progress.
This unit includes a:
PowerPoint presentation (56 Slides)
PDF teaching file
Unit Test (including mark scheme)
These resources can be used by a computing teacher or a non-specialist teacher to teach “What is a Computer?”. This unit can be taught in a classroom with no computers.
What will students learn?
ALL STUDENTS
• I can identify the main hardware components (CPU, RAM, Motherboard, HDD, SSD, PSU and GPU) and software components (operating system, application software) that make up a computer system.
• I understand that devices such as smart phones and tablets are computer systems
MOST STUDENTS
• I can explain the role the main hardware components (CPU, RAM, Motherboard, HDD, PSU and GPU) and software components (operating system, application software) that make up a computer system.
• I understand the role of input, output and storage devices.
SOME STUDENTS
• I can select the components of a computer system to ensure that they meet the needs of a user.
These adaptable PowerPoint Presentations (111 Slides) cover all aspects of the specification in relation to OCR GCSE Computer Science J277 (from 2020) component 1.3.
It includes:
Teaching PowerPoint Presentations (including checkpoint questions and answers)
Part 1 – Networks & Topologies (66 slides)
Part 2 - Wired & Wireless Networks, Protocols & Layers (45 slides)
Student PowerPoint Presentations (Including checkpoint questions, but omits the answers)
Part 1 – Networks & Topologies
Part 2 - Wired & Wireless Networks, Protocols & Layers
Content Covered:
Types of network:
LAN (Local Area Network)
WAN (Wide Area Network)
Factors that affect the performance of networks
The different roles of computers in a client-server and a peer-to-peer network
The hardware needed to connect stand-alone computers into a Local Area Network:
Wireless access points
Routers
Switches
NIC (Network Interface Controller/Card)
Transmission media
The Internet as a worldwide collection of computer networks:
DNS (Domain Name Server)
Hosting
The Cloud
Web servers and clients
Star and Mesh network topologies
Modes of connection:
Wired - Ethernet
Wireless Wi-Fi & Bluetooth
Encryption
IP addressing and MAC addressing
Standards
Common protocols including:
TCP/IP (Transmission Control Protocol/Internet Protocol)
HTTP (Hyper Text Transfer Protocol)
HTTPS (Hyper Text Transfer Protocol Secure)
FTP (File Transfer Protocol) o POP (Post Office Protocol)
IMAP (Internet Message Access Protocol)
SMTP (Simple Mail Transfer Protocol)
The concept of layers
This pack consists of 34 editable homework/classwork activities that can be used to support your delivery of the course. In addition, the homework bundle also contains a suggested mark scheme for each activity.
Unit 3.1
· Decomposition and Abstraction
· Flowcharts and High-Level Languages
· Sorting Data
· Sorting & Searching Programs
Unit 3.2
· Selection
· Iteration
· Arrays (Lists)
· Functions
· Improving Programs
· Testing
Unit 3.3
· Data Capacity
· Conversions
· Compression
Unit 3.4
· Components of a CPU
· CPU Performance
· Embedded Systems
· Operating Systems
· Utility Software
· Boolean Logic and Truth Tables
· Logic Gates
· Programming Languages
Unit 3.5
· LANs and WANs
· Wired & Wireless Networks
· Star & Bus Topology
· Network Protocols
· The Concept of Layers
Unit 3.6
· Malware
· Cyber Threats
· Network Vulnerabilities
Unit 3.7
· Relational Databases
· Relational Databases and SQL
Unit 3.8
· The Impact of Technology
· The Digital Divide
· Impact of New Technology
This pack includes four practice exam papers with mark schemes for AQA GCSE Computer Science (9–1) specification (first teaching September 2020, examinations from 2022).
The papers have been written to replicate the style of AQA examinations. These papers provide students with an opportunity to familiarise themselves with the look and feel of an AQA paper.
The digital pack includes:
· two practice papers for Computational Thinking and Programming Skills (Paper 1)
· two practice papers for Computing Concepts (Paper 2)
The papers combined cover all aspects of the computer science curriculum.
You will also receive a comprehensive mark scheme for each paper.
These adaptable PowerPoint Presentations (31 Slides) cover all aspects of the specification in relation to OCR GCSE Computer Science J277 (from 2020) component 2.5.
It includes:
Teaching PowerPoint Presenations (includes checkpoint questions and answers)
Student PowerPoint Presentations (Includes checkpoint questions, but omits the answers)
Content Covered:
Characteristics and purpose of different levels of programming language:
High-level languages
Low-level languages
The purpose of translators
The characteristics of a compiler and an interpreter
Common tools and facilities available in an Integrated Development Environment (IDE):
Editors
Error diagnostics
Run-time environment
Translators
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.
Unit 3.1 – 1 Test
Unit 3.2 – 2 Tests
Unit 3.3 – 1 Test
Unit 3.4 – 4 Tests
Unit 3.5 - 2 Test
Unit 3.6 – 1 Test
Unit 3.7 – 1 Test
Unit 3.8 – 1 Test
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 unit provides detailed teaching resources to teach students about computational thinking and includes at least 6 hours of lessons.Students develop simple algorithms and learn about key terminology such decomposition, abstraction and pattern recognition.
This unit includes a:
PowerPoint presentation (43 Slides)
PDF teaching file
Unit Test (including mark scheme)
These resources can be used by a computing teacher or a non-specialist teacher to teach about computational thinking. This unit can be taught in a classroom with no computers.
What will students learn in Unit 1?
ALL STUDENTS
• I understand the terms algorithm, decompose, abstraction and pattern recognition.
• I can produce a simple algorithm that solves a problem.
MOST STUDENTS
• I can produce an algorithm that solves a problem.
• I can apply the terms algorithm, decompose, abstraction and pattern recognition.
SOME STUDENTS
• I can compare two algorithms that perform the same task and understand why one algorithm is more efficient than another algorithm.
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.
In this lesson you are introduced to two programming concepts - Sequence and Selection.
You will learn how to use IF statements, IF then ELSE statements, IF and ELSE-IF statements and Nested IF.
Python and the Python Logo are trademarks or registered trade marks of the Python Software Foundation.
This is the first lesson in a series teaching Python Programming. It really starts at the very beginning. It’s designed to be used by children and adults with no experience of programming.
Python and the Python Logo are trademarks or registered trade marks of the Python Software Foundation.