Revision notes, activities, lesson plans, teaching ideas, and other resources for GCSE, A-Level, and IB Computer Science teachers and students.
Practice paper 3 exam questions
One of the drawbacks of the yearly case study is that there are no past p...
Emergency Management System Explainer Video
This short video gives an overview of some EMIS features. It includes many ...
Geographic Information Systems (GIS)
For some functionality, an EMIS may also be connected to a GIS (Geographic ...
Programming languages - from Scratch to machine code
The CS Field Guide has a very comprehensive guide to different types of pro...
Assembly language simulators
There are several assembly language simulators available for use online. Si...
Little Man Computer (LMC)
The Little Man Computer (LMC) is a software simulator of a simple computer ...
Lesson - Data representation - sound
This download contains all lesson resources necessary to teach students how...
Predictive placement is a feature of some CAD systems that enables more e...
AI to help emergency dispatch phone operators
The Singapore Civil Defence Force (SCDF) may trial an AI system to help tra...
Click here for recommended Edexcel GCSE Computer Science textbooks.
Database tutorials - GCFLearnFree YouTube channel
GCFLearnFree's YouTube channel has videos on a wide range of subjects, including Microsoft Access. The videos start with the absolute basics, introducing the background concepts and simple single table databases (very useful for the IGCSE Computer Science course). They then move on to more complex topics such as designing different types of queries, creating forms, and formatting reports. Video are generally less than 5 minutes, which means they get straight down into the details and make it easy to skip to the right part. The video focus on Access 2013 but students should be able to adapt the techniques to other versions too.
A good overview of database theory, which is sufficient to cover the syllabus for most GCSE courses, and is a good introduction to the topic for A Level and IB courses. The differences between structured and unstructured data are covered, along with database basics (fields, records, tables). The second half of the video explains relationships in more detail, including 1-to-1 and 1-to-many relationships.
Live Database Example - Try SQL
This site lets users try out queries and commands using SQL. The supplied test databases has a dozen tables and hundreds of records, and can easily be reset if a mistake is made. Although SQL is no longer part of the Edexcel Computer Science syllabus, this is still a great site to help students understand what queries are and how they work.