Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach.
1.1 Project Life Cycle Lesson
1.2 Iterative Reviews Lesson
1.3 Inputs and Outputs Lesson and Worksheet
1.4 Initial Project Considerations Lesson
1.5.1-2 Planning Tools Lesson
1.5.2-3 Planning Tools and software Lesson
2 x Homework sheets with marking scheme
1 x End-of-module test question paper with marking scheme
1 x Module self-assessment learning checklist for students
All lessons are tried-and-tested. Save yourself hours of work by downloading now.
Mouse Maze is a fun introduction to decomposition, algorithms and iteration (loops). It works well as an extended starter.
Print out the simple maze, or distribute the PowerPoint file to students (the mouse icon can be dragged and rotated). They must list the steps required for Mousey to reach the cheese.
Decomposition: breaking the problem into smaller steps (i.e. solving the maze)
Algorithms: listing the steps to guide Mousey through the maze
Iteration: making the algorithm more efficient by repeating parts of it (challenge / extension activity)
The download includes:
A full set of teacher’s instructions
PowerPoint maze for students which can be used electronically or printed out
PowerPoint 6 slides showing the task, solution, sections which are repeated, and a more efficient solution. The final slide has definitions of ‘algorithm’ and ‘decomposition’, plus a note to tell students that they have already achieved both during the lesson.
Pupils enjoy the activity and it is a great way to introduce the concepts for the first time. I hope you and your pupils enjoy it :)
Use SQL to return results of queries on the supplied James Bond movie database (e.g. What is the average IMDB rating of movies directed by John Glen?)
The worksheet includes instructions for creating a new database, uploading the SQL file to it, then using SQL to obtain the answers to questions. Students can copy and paste their queries and results into the worksheet, then save or print for marking.
SQL commands used: describe, select, count, from, where, group by, like, and, or; and wildcards.
The database is a single-table flat database.
This is an intermediate-level task, suitable for students who are already familiar with SQL commands and structure. It also assumes that users will be using phpMyAdmin and they have sufficient privileges to create and edit databases.
My Year 12 and 13 Computer Science A-Level students enjoyed the lesson, which took around 1 hour for most to complete.
Included: SQL file, student worksheet, teacher’s answer sheet.
Create quiz questions and answers in a spreadsheet, export to a CSV file, and write a Python program to use the CSV files for a multiple-choice quiz. Printable student instructions; stretch / challenge tasks; and example files for teachers, this makes a great revision or end-of-unit activity! Students can re-visit the CSV file and add more questions as the year progresses.
Teaches:
CSV (comma-separated value) files
Python file-handling; two-dimensional lists; variables; iteration
Stretch / challenge activities:
Add a scoring system
Accept upper and lower case inputs
Fix a ‘bug’ where the same question may appear multiple times
Add a graphic interface
Files included:
Printable PDF worksheet (copy and paste is restricted so students must type their code
Sample CSV file with six questions and answers
Python file of the completed activity
Python file containing stretch / challenge solutions (except the GUI)
This is a great one or two lesson activity – ideal for a spare lesson at the end of term. Download for free.
Introduce Adobe Illustrator CC to your KS4 iMedia and KS3 Computing students. Easy-to-deliver, with all example files included too. Introduces:
An overview of bitmap vs vector graphics
Benefits of vector graphics
Creating simple shapes
Creating bezier curvers
Adding text to a path
Included files:
PowerPoint lesson
9 x Example Adobe Illustrator files
To improve support for schools running older versions of Adobe software, supplied example files are compatible with Adobe Illustrator CS6 and all versions of Illustrator CC.
Introduce Python 3 to your students using Turtle and Edublocks 4 (a free online drag-and-drop Python editor). Students program Turtle to draw a Christmas card. Their code can be downloaded and opened using IDLE or any other Python IDE.
Includes:
PowerPoint to get students started
Printable worksheet with step-by-step instructions to complete the project and challenge activities
Completed file which can be imported into Edublocks
Python files which can be opened using IDLE
Teachers’ instruction sheet
This is an ideal end-of-term standalone lesson ready for Christmas. I hope you and your students enjoy it.
Introduce your students to HTML using a drag and drop interface. Designed to be intuitive and colourful, students drag Lego-like ‘tag’ blocks onto the board to build up their page. Works on both mouse-based computers and touch-screen tablets.
This resource includes “Tutorial 1” and “Teacher’s Notes”, both as printable PDFs.
Tutorial 1 is an introduction to the Weggo! interface and a quick “Hello world” lesson. The Teacher’s Notes provide an overview of Weggo’s usage, system compatibility, limitations and pointers for each of the five tutorials.
Please be aware that Weggo! is ‘beta’ software, and some bugs will be present.
Weggo! is a free-to-use website with no adverts or logins.
I hope you and your students enjoy using Weggo!
Add links to other web pages using the <a> tag. Links can be added to headline, paragraph, and list item tags.
Please be aware that Weggo! is ‘beta’ software, and some bugs will be present.
Weggo! is a free-to-use website with no adverts or logins.
I hope you and your students enjoy using Weggo!
Use the IMG tag to add images to your Weggo! HTML page. Images can be hot linked from other online resources, or a small amount of clipart images are supplied. Support for ALT text is included to promote accessibility and search engine-friendly authoring.
Please be aware that Weggo! is ‘beta’ software, and some bugs will be present.
Weggo! is a free-to-use website with no adverts or logins.
I hope you and your students enjoy using Weggo!
Create HTML ordered (numbered) and unordered (bullet-point) lists using Weggo’s unique drag-and-drop editor.
The printable PDF shows step-by-step instructions of how to create simple lists.
Please be aware that Weggo! is ‘beta’ software, and some bugs will be present.
Weggo! is a free-to-use website with no adverts or logins.
I hope you and your students enjoy using Weggo!
The second tutorial for the Weggo! HTML Editor introduces more text tags such as headlines and paragraphs, which students use to begin adding more content to their web page.
Please be aware that Weggo! is ‘beta’ software, and some bugs will be present.
Weggo! is a free-to-use website with no adverts or logins.
I hope you and your students enjoy using Weggo!
Design and code a Python game with 10 step-by-step worksheets. Use Pygame and Pygame Zero to create a cheese-collecting, cat-avoiding, fast-paced game!
Introduces students to:
Python graphics
Sprites
Tile maps
Keyboard events
Gameplay ideas
This is an ideal project for extra-curricular clubs. All images, sample code, and teacher support information is included.
I hope your students have as much fun making this game as mine did.
Ten string manipulation programming challenges to help students practice their Python and problem-solving skills and prepare for their Computer Science GCSE.
Students use their existing programming knowledge to plan each challenge in the booklet before testing it on their computer. This “writing-before-typing” approach helps to develop the crucial skills needed to gain maximum marks in the algorithms section of their exam.
The booklet is supplied ready to be printed and stapled to make a 16-page booklet (uses four duplex-printed A4 sheets), and as single pages for individual printing or uploading to your VLE.
A full set of example code is provided for teachers, written in a way which is appropriate for the GCSE students to fully understand.
This is a great way for students to practice their coding skills. Download today.
Ten list programming challenges to help students practice their Python and problem-solving skills and prepare for their Computer Science GCSE.
Students use their existing programming knowledge to plan each challenge in the booklet before testing it on their computer. This “writing-before-typing” approach helps to develop the crucial skills needed to gain maximum marks in the algorithms section of their exam.
The booklet is supplied ready to be printed and stapled to make a 16-page booklet (uses four duplex-printed A4 sheets), and as single pages for individual printing or uploading to your VLE.
A full set of example code is provided for teachers, written in a way which is appropriate for GCSE students to fully understand.
This is a great way for students to practice their coding skills. Download today.
Complete scheme of work for J277 OCR Computer Science 2.1 Computational Thinking, including PowerPoint for each lesson, homework sheets, worksheets, unplugged activities, Python example files, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students.
Includes the following lesson PowerPoints and resources:
Scheme of Work document
2.1.1a Abstraction
2.1.1b Decomposition, including “Decomposing Mickey Mouse” worksheet
2.1.1c Algorithmic Thinking, including “River Crossing Challenge” worksheet
2.1.2a Inputs, Processes, Outputs, including “Problem Solver Cheat Sheet” and Python code example file
2.1.2b Structure Diagrams, including Python files
2.1.2c Flowcharts
2.1.2c Pseudocode, including worksheet, answers, and Python files
2.1.2d Common Errors, including worksheet, answers, and Python files
2.1.2e Trace Tables, including worksheet, answers, and Python files
2.1.3a Linear Searches, including example PowerPoint
2.1.3b Binary Searches, including example PowerPoint
2.1.4a Bubble Sort, including Star Wars Bubble Sort PowerPoint
2.1.4b Merge Sort, including worksheet and example PowerPoint
2.1.4c Insertion Sort, including example PowerPoint
4 x homework sheets, with answers
1 x end-of-unit test, with mark sheet
My students especially enjoyed the unplugged searching and sorting algorithms!
Save yourself hours of planning by downloading now.
Complete scheme of work for J277 OCR Computer Science 1.5 Systems Software, including PowerPoint for each lesson, programming activity, homework sheet, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students.
Includes the following:
1.5.1a - The purpose of an operating system
1.5.1b - Interfaces, Users, Files
1.5.1c - Memory, Multitasking, Peripherals
1.5.2a - Utility Software
1.5.2b - Encryption, Defragmenting, Compression + Python encryption activity
Homework sheet (10 marks, plus answer sheet)
End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet)
Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!
Complete scheme of work for J277 OCR Computer Science 1.6 Ethical, Legal, Cultural and Environmental Impacts, including PowerPoint for each lesson, two homework sheets, end-of-topic exam, and mark sheets.
Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students.
Includes the following:
1.6.1a - Introduction to topic and Stakeholders
1.6.1b - Ethical issues
1.6.1c - Society
1.6.1d - Cultural issues
1.6.1e - Environmental issues
1.6.1f - Privacy Issues
1.6.1g - Legislation (includes courtroom class activity)
1.6.1h - Software Licenses
2 x Homework sheets (10 marks, plus answer sheet)
End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet)
All lessons are tried-and-tested. Save yourself hours of work by downloading now. Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!
Complete scheme of work for J277 OCR Computer Science 1.3 Networks, Connections, and Protocols, including PowerPoint for each lesson, homework sheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students.
Includes the following lesson PowerPoints:
1.3.1a Types of Networks
1.3.1b Performance Factors
1.3.1c Client-Server and Peer-to-Peer Models
1.3.1d Networking Hardware
1.3.1e The Internet, plus printable diagram
1.3.1f Star and mesh network Topologies
1.3.2a Wired and Wireless Connections
1.3.2b Encryption
1.3.2c IP and MAC Addressing
1.3.2d Standards and Protocols
1.3.2e The Concept of Layers
2 x Homework sheets (10 marks each, plus mark sheets)
1 x End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet)
Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!
Complete scheme of work for J277 OCR Computer Science 1.1 Memory & Storage, including PowerPoint for each lesson, homework sheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students.
Includes the following:
1.2.1 Primary Storage Lesson
1.2.2 Secondary Storage Lesson + Worksheet
1.2.3 Units of Data Lesson
1.2.4a-1 Binary Conversion Lesson + Links to Binary Bingo & Denary Bingo games
1.2.4a-2 Binary Addition Lesson + Worksheet + Answers
1.2.4a-3 Hexadecimal Lesson
1.2.4b Character Sets Lesson
1.2.4c Image Representation Lesson + Worksheet + Answers + Python task
1.2.4d Audio Representation Lesson + Worksheet + Answers + Python task
1.2.5 Compression Lesson
3 x Homework sheets (10 marks each, plus mark sheets)
1 x End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet).
Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!
Complete unit of work for J277 OCR Computer Science 1.1 Systems Architecture, including PowerPoint for each lesson, two homework sheets, end-of-topic exam, and mark sheets.
Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students.
Includes the following:
1.1.1a - Purpose of the CPU (including unplugged activity)
1.1.1b - CPU Components
1.1.1c - Von Neumann Architecture
1.1.1d - Factors Affecting CPU Performance
1.1.1e - Embedded Systems
2 x Homework sheets (10 marks each, plus answer sheet)
End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet)
All lessons are tried-and-tested. Save yourself hours of work by downloading now. Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!