Database Fundamentals
How relational databases work — tables, keys, relationships, integrity, design, and queries — using Riverside Public Library in York.
Learn
Free online courses
Self-paced, beginner-friendly courses with interactive lessons. Open a course and start learning — no account required.
Microsoft Access
Build Riverside Public Library in Microsoft Access — tables, relationships, queries, forms, reports, and maintenance.
Microsoft Word
Microsoft Word — Complete Mastery: follow James at Northgate Academy through 57 roadmap sections from Ribbon basics to fields, mail merge, VBA, and Copilot — building one handbook step by step.
Microsoft Excel
Enter data, write formulas, format worksheets, analyse with sort and filter, chart results, and build the Northgate Academy budget workbook.
Microsoft PowerPoint
Design slides, apply themes, add media and motion, and deliver the Northgate Academy open day presentation.
Basic Concepts of Algebra
Variables, expressions, equations, indices, solving linear equations and inequalities.
Sets and Functions
Set notation, Venn diagrams, functions, domain and range.
Trigonometry
Right-angled triangles, Pythagoras' theorem, sine, cosine and tangent.
Calculus
Differentiation and integration, built from first principles.
Numerical Precision, Accuracy and Errors
Rounding, significant figures, accuracy vs precision, and error types.
Descriptive Statistics
Averages, spread, frequency tables, charts, and comparing data sets.
Basic Probability
Simple probability, combined events, tree diagrams, and expected frequency.
Matrices and Determinants
Matrix operations, multiplication, and determinants.
Introduction to Solid Geometry
Surface area and volume of 3D solids.
Recap and Practice
A simple recap of Sections A–G with worked examples, then a practice paper with full answers.
Introduction to Computer Systems
What a computer is, how computers are classified, their history and generations, and basic architecture.
Number Systems
Binary, octal, decimal and hexadecimal, with every conversion shown step by step.
Boolean Algebra and Logic Gates
Logic gates, truth tables, Boolean expressions, simplification laws and turning real problems into circuits.
Computer Hardware and Peripherals
Motherboard, processor, memory, storage, peripherals and ports, and how to justify a computer specification.
Operating Systems
What an operating system does, the main types, comparing Windows, Linux and macOS, booting and the command line.
Internet Technologies
How the internet and the web work, and the services built on them — email, social media, cloud and online business.
Planning a Website
Purpose, audience, site maps, wireframes, colours, fonts and images — then set up your folders and editor.
HTML
Build a multi-page website with HTML — text, images, links, tables, forms and a consistent layout.
CSS
Style your website with CSS — colours, fonts, the box model, navigation, tables, forms, Flexbox, Grid and responsive design.
Digital Image Fundamentals
Pixels, resolution, colour modes, raster and vector, file formats and compression.
Design Principles
Hierarchy, alignment, contrast, repetition, balance, colour and type — the rules behind posters people actually read.
Adobe Photoshop
Layers, selections, masks, adjustments, type and effects — build and export a print poster step by step.
Introduction to Programming
Programming languages, translators, the programming process, types of errors and structured programming.
Algorithms, Flowcharts and Pseudocode
Plan programs before you code — flowchart symbols, decisions, loops, pseudocode and trace tables.
Python Programming
Variables, data types, operators, input and output, if statements, loops and functions — run every example in your browser.