Introduce your students to databases and SQL / SQLite and build their knowledge through to a mini-project which uses their existing knowledge of Python and Tkinter.
1.3.2a - Database Concepts
Flat file databases
Entity identifiers
Indexing
Primary, Secondary, and Foreign keys
Relational databases
1.3.2b - Database Normalisation
Relational DB design
Relationships and ERD
Referential integrity
Linking DB tables / Link tables
Normalisation - reasons and 1NF, 2NF, 3NF
1.3.2c Transaction Processing
Capturing Information
ACID
Record locking
Redundancy
1.3.2d SQL
SELECT FROM WHERE
Conditions
Sorting
Dot notation
JOIN
Data types
ALTER / UPDATE / DELETE / DROP
SQL Worksheets
Customer database: Import provided flat-file database and query it
James Bond movies: Import provided flat-file database and query it. Note: this resource is available separately from my TES store
High Scores: Import provided relational database and query it
Marvel Cinematic Universe: examine provided SQL to create a new database
Mini-project: plan and create a relational database and use Python and Tkinter to build an interface. Note: this project expects students to have a basic knowledge of Tkinter and independently research how to implement SQLite 3 in Python. No support files are provided for this activity.
Ten programming challenges to help students practice their problem-solving and Python 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 algorithm 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.
Challenge your higher-ability students to complete these difficult Python programming tasks. Example solutions are included, written using skills which students will be familiar with and no need to install any additional libraries.
Music Quiz
Create and store music titles and artists in a CSV file, choose one at random, remove most of the characters, and ask the player to enter the correct title and artist.
Play Your Cards Right
Based on the classic game show. A card is randomly chosen and the player must guess whether the next card has a higher or lower value. You get nothing for a pair!
Word Clock
Output the current time as a sentence. E.g., 22:53 is “Seven minutes to eleven”.
Binary Converter
Ask the user to enter a denary integer and convert it to binary.
Book Maker
Download a free book and write a program which counts the number of characters; calculates the number of words and pages; adds page numbers; and a search function. And you get a free classic book!
Full unit of work for Edublocks, moving KS3 from Scratch to Python Turtle programming, with an emphasis on Computational Thinking, ready for moving to IDLE. Everything is fully resourced for simple delivery: answers, example files, and an end-of-unit assessment using Quizizz
Lesson 1: Introduction to Python
Overview of Computational Thinking; overview of the Python language; drawing equilateral shapes using Edublocks and Python Turtle. Edublocks XML files included.
Lesson 2: Iteration
Count-controlled and condition-controlled loops; Python’s for and while statements; using iteration to simplify drawing shapes using Edublocks and Python Turtle. Edublocks XML files included.
Lesson 3: Variables
Fun unplugged activity to explain the need and purpose of variables; using variables to store data. Edublocks XML files included.
Lesson 4: Selection
A comparison between how humans and computers make decisions; introduction to if, elif, and else statements. Edublocks XML files included.
Lesson 5: Bringing it all Together
A step-by-step guide to creating a program which asks the user to enter a shape name, and Turtle drawing it. Edublocks XML files included.
Lesson 6: Revision and Assessment
Q&A Revision; link to a Quizizz assessment on the unit of work; and a chance for students to reflect on their progress during the topic.
Edublocks is a drag-and-drop programming language, visually similar to Scratch. My own students have enjoyed this topic and it has provided a good starting point for moving-on to IDLE.
Lessons and examples use Edublocks 4 (due for release in Summer 2021) making this unit of work future-ready and a time-saving way to prepare students for IDLE.
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.2.1a Variables, Constants, Operators, Inputs, Outputs, Assignments
2.2.1b Sequence, Selection, Iteration (inc Python files) - Updated October 2022 to include Python Switch (match) Statements
2.2.1c Arithmetic and Arithmetic Operators
2.2.2 Data Types (inc worksheet and Python solutions)
2.2.3a String Manipulation (inc Python solutions)
2.2.3b File Handling (inc Python solutions)
2.2.3c Databases and SQL (inc worksheet, answers, and Python SQLite 3 database file)
2.2.3d Arrays
2.2.3e Subprograms
3 x Homework worksheets and answers
1 x End-of-topic test
Includes dozens of Python demonstration files and a Python-based SQLite 3 database for students to test their SQL commands.
Save yourself hours of planning. Download now.
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.
Database lessons use Microsoft Access.
5.1.1a Spreadsheet Functions Lesson PLUS worksheet and example files
5.1.1b VLOOKUP Lesson PLUS worksheet and example files
5.1.2 Cell Referencing and Importing Lesson PLUS example and solution files
5.1.3 Charts and Tables Lesson PLUS worksheet
5.1.4 What-If Analysis Lesson PLUS worksheet, answer and example files
5.1.5 Macros Lesson PLUS worksheet
5.2.1 Relational database Lesson
5.2.2 Import data from other sources Lesson PLUS worksheet, sample and example files
5.2.3 Data validation Lesson PLUS worksheet, sample and example files
5.2.4 Input Forms Lesson PLUS worksheet, sample and example files
5.2.5 Queries Lesson PLUS worksheet, sample and example files
5.2.6-8 Reports, Security, Exporting Data Lesson plus database file
5.2.x Bringing It All Together – recap lesson incorporating all database learning
5.2.x Mini-project – Mini project Lesson to consolidate learning. WAGOLL included.
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.
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.
2.1 Analysing Project Requirements Lesson and Sample Design Brief
2.2 Mitigating Risks Lesson
2.3.1a Gantt and PERT Charts Lesson PLUS ProjectLibre example file and activities
2.3.1b Spreadsheets Lesson PLUS worksheet and solution files
2.3.2 Critical Path Lesson PLUS Worksheet and solution files
2.3.3 Project Documentation Lesson
2.4.1 Testing (Functionality) Lesson
2.4.2 Testing (Useability) Lesson
2.4.3 Testing (Accessibility) Lesson
2.4.4 Testing (Test Plans) Lesson
4 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.
When starting Secondary School, Year 7 students suddenly find they have to navigate the school’s vast network. Where are their files? What is a network location? How do they print? How do they open a document?
This resource is designed to teach students to navigate the network and print using a fun Digital Treasure Hunt. The provided web page directs them to a file which contains a challenge – solve the challenge, enter the code into the web page, and move on to the next challenge. When all five challenges are completed, they can print a certificate.
This resource includes:
Digital Treasure Hunt Map (HTML, will run locally on your network)
Treasure Hunt Lesson PowerPoint
Activity 1: Web research task
Activity 2: ASCII table lookup
Activity 3: Logic puzzles
Activity 4: Binary image encoding
Activity 5: Opening a Python file
Printable certificate
Answer sheet
Set up instructions
You will need to edit a JavaScript file to personalise the locations of the activity files, but this is a straightforward task and full instructions are provided.
Complete scheme of work for J277 OCR Computer Science 1.4 Network Security, 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.4.1a Forms of Attack Lesson
1.4.1b Social Engineering Lesson
1.4.1c Brute-force Attacks Lesson + Brute-force demo (Python)
1.4.1d Denial of Service Attack Lesson + Overview of AO3 DDoS attack, questions, and mark scheme
1.4.1e Data Interception and Theft Lesson
1.4.1f SQL Injection Lesson + Worksheet + Demo database to hack (Python)
1.4.2a Software Prevention Methods
1.4.2b Prevention Against Hacking
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!
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.
A complete scheme of work for AQA 8132 Business Studies: 3.5 Marketing, featuring exam-style questions, case studies, paired and group activities, worksheets, and discussions.
Designed for a mixed-ability group, PowerPoints are clear and concise with chunked explanations and plenty of stretch activities for higher-attaining students. And, of course, all answers are supplied!
The scheme of work includes the following:
3.5.1 Identifying and Understanding Customers
3.5.2 Market Growth and Segmentation + worksheet
3.5.3 The Purpose and Methods of Market Research
3.5.4a Overview of the Marketing Mix + printable case study
3.5.4b The Marketing Mix - Product + printable activity sheet
3.5.4c The Marketing Mix - Price + printable worksheet
3.5.4d The Marketing Mix - Promotion + printable worksheet
3.5.4e The Marketing Mix - Place + printable worksheet
Save yourself hours of planning. Download now.
Complete scheme of work for AQA 8132 Business Stdies: 3.4 Human Resources, featuring exam-style questions, paired activities, worksheets, and group discussions.
Designed for a mixed-ability group, and including large colourful diagrams and graphics; simple, chunked explanations; plenty of stretch activities for higher-ability students; and answers to all questions!
This scheme of work includes the following:
3.4.1a Organisation Structures + worksheet
3.4.1b Organisation Structures
3.4.2 Recruitment and Selection of Employees (double lesson) + worksheet
3.4.3a Motivating Employees
3.4.3b Motivating Employees
3.4.4 Training
A complete scheme of work which gives your students an interesting and informative lesson, and saves lots of planning for you! Download now.
A complete scheme of work for AQA 8132 Business Studies 3.1: Business in the Real World, featuring exam-style questions, case studies, paired and group activities, printable worksheets, and discussion activities.
Designed for a mixed-ability group, PowerPoints are clear and concise with chunked explanations and plenty of stretch activities for higher-attaining students. And, of course, all answers are supplied!
The scheme of work includes the following:
3.1.1a The Purpose and Nature of Business + worksheet
3.1.1b The Purpose and Nature of Business + worksheet + support sheet
3.1.1c The Purpose and Nature of Business + exam question sheet + mark scheme
3.1.2 Business Ownership
3.1.3 Setting Business Aims and Objectives
3.1.4 Stakeholders + answer sheet
3.1.5 Business Location + worksheet
3.1.6 Business Planning + worksheet
3.1.7 Expanding a Business + worksheet + answer sheet
Save yourself hours of planning with these tried and tested resources. Download now.
A complete scheme of work for AQA 8132 Business Studies 3.6 Finance, featuring exam-style questions, financial statement spreadsheet examples, paired and group activities, printable worksheets, and discussion activities.
Designed for a mixed-ability group, PowerPoints are clear and concise with chunked explanations and plenty of stretch activities for higher-attaining students. And, of course, all answers are supplied!
3.6.1 Sources of Finance + worksheet
3.6.2 Cashflow + worksheet + spreadsheet examples
3.6.3a Break-even + worksheet + spreadsheet example
3.6.3b Investment + worksheet
3.6.4 Financial statements + worksheets + spreadsheet examples
Save yourself hours of planning with these tried and tested resources. Download now.
Complete scheme of work for AQA 8132 Business Studies: 3.3 Business Operations, featuring exam-style questions, paired activities, and group discussions.
Designed for a mixed-ability group, and including large colourful diagrams and graphics; simple, chunked explanations; plenty of stretch activities for higher-ability students; and answers to all questions!
This scheme of work includes the following PowerPoint lessons:
3.3.1 - Production Processes
3.3.2 - The Role of Procurement
3.3.3a - The Concept of Quality (Part A)
3.3.3b - The Concept of Quality (Part B)
3.3.4a - Good Customer Service (Part A)
3.3.4b - Good Customer Service (Part B)
Download this complete unit of work and save yourself hours of planning!
Save countless hours of planning (and nearly a quarter compared with buying units individually) with these complete units of work for Component 1 of J277 Computer Science.
1.1 Architecture of the CPU: 5 lessons, 2 homework sheets
1.2 Memory and Storage: 10 lessons, 3 homework sheets
1.3 Networks: 11 lessons, 2 homework sheets
1.4 Network Security: 8 lessons, 2 homework sheets
1.5 Systems Software: 5 lessons, 1 homework sheet
1.6 Ethical, Legal, Cultural, and Environmental Impacts: 7 lessons, 2 homework sheets
In total, there are 46 complete lessons and 12 homework sheets
Save by buying in bulk and get your weekends back!
Save countless hours of planning (and £10) with these complete schemes of work for LO1 - LO7 in Cambridge National Level 1/2 Information Technologies.
Each of the seven Learning Objectives includes complete lessons, worksheets, examples, homework, answer sheets, learning checklist, end of module test and mark scheme.
In total, there are 76 complete lessons and 21 homework sheets
Save by buying in bulk and get your weekends back!
Complete scheme of work for AQA 8132 Business Studies: 3.2 Influences on Business, featuring exam-style questions, paired activities, group work, and online research tasks.
Designed for a mixed-ability group, and including large colourful diagrams; simple, chunked explanations; plenty of stretch activities for higher-ability students; and answers to all questions!
This scheme of work includes the following PowerPoint lessons:
3.2.1 - Technology
3.2.2a - Ethical Considerations, plus printable class scenarios
3.2.2b - Environmental Considerations
3.2.3a - The Econcomic Climate
3.2.3b - Interest Rates
3.2.4 - Globalisation
3.2.5a - Legislation (a)
3.2.5b - Legislation (b)
3.2.6 - The Competitive Environment
Download this complete unit of work to save hours of work.
Download the binary bingo card, then use the free bingo-caller website* to randomly generate numbers to call out.
How to use: each student choses four numbers between 0 and 15 and writes them onto the bingo card. The teacher loads the website onto a screen or SMART Board. A random binary number is chosen and displayed. Students convert the binary number into denary. The first student to get all four numbers shouts "BINGO!" and wins.
Called numbers are listed at the bottom of the screen, and can be clicked for conversion to denary.
A great plenary activity for KS3 and KS4 students which reinforces binary to denary conversion. Have fun :)
* The website URL is stated at the bottom of the downloadable PDF.
A comprehensive unit of work covering operating systems, interfaces, accessibility, and an introduction to utility software. Ideally suited to Year 8, but with enough stretch and challenge activities for Year 9. I have also taught this module to Year 7 with some work removed.
The focus on operating systems feeds into J277 GCSE Computer Science; the interface aspects feed into BTEC Level 1/Level 2 Tech Award in Digital Information Technology.
This unit of work comprises:
Lesson 1: OS Functions
PowerPoint: Introduction to different operating systems and their primary functions
Worksheet and answer sheet
Lesson 2: OS Types
PowerPoint: More in-depth look at operating system functions and the difference between different operating systems.
Worksheet and answer sheet
Lesson 3: User Interfaces
PowerPoint: Command Line Interfaces, Graphical User Interfaces (WIMP and Touch-based)
Worksheet and answer sheet
Lesson 4: Accessibility and Design
PowerPoint: How users with different abilities can use computers and the evolution of the interface
Worksheet and answer sheet
Lesson 5: Utility Software
PowerPoint: Introduction to utility software; introduction to compression and defragmentation
Worksheet and answer sheet
Online defragmentation activity
Lesson 6: Recap and Quiz
PowerPoint: Recap of unit and link to Quizizz activity
This unit has been professionally designed (I’m an ex-graphic designer) and is suitable for delivery by subject and non-subject specialist teachers.
Download the complete unit today for less than 60p per lesson!