National 5 Computing Science · James Gillespie's
Course units
CS · Computer Systems
Computer Systems
Data representation, computer architecture, storage, and the environmental and security impacts of computing.
11 of 11 lessons · Available
SDD · Software Design & Development
Software Design & Development
Design methodologies, programming constructs, standard algorithms, and testing — the largest unit in the course.
16 of 18 lessons · In progress
- SDD1Development methodologies
- SDD2Analysis and requirements
- SDD3Design: structure diagrams and flowcharts
- SDD3bDesign: wireframe UI design
- SDD4Design: pseudocode
- SDD5Variables, data types and arithmetic
- SDD6Input, output and string operations
- SDD7Selection: if/else statements
- SDD8Complex conditions: AND, OR, NOT
- SDD9Fixed loops
- SDD10Conditional loops
- SDD11Predefined functions
- SDD12Arrays
- SDD13Standard algorithms: linear search
- SDD14Standard algorithms: min, max, count
- SDD15Testing: errors and test plans
- SDD16Debugging techniques
- SDD17SDD past paper practice
DDD · Database Design & Development
Database Design & Development
Relational database concepts, entity-relationship modelling, and SQL queries from basic to multi-table joins.
5 of 10 lessons · Available
- SetupGetting started: install DB Browser for SQLite
- DDD1Database concepts and terminology
- DDD2Entity-relationship diagrams
- DDD3Analysis and UK GDPR
- DDD4Data Dictionary and Validation
- DDD5SQL: SELECT and WHERE
- DDD6SQL: ORDER BY and multiple conditions
- DDD7SQL: JOIN across two tables
- DDD8SQL: INSERT, UPDATE, DELETE
- DDD9Testing and evaluation
- DDD10DDD past paper practice
WDD · Web Design & Development
Web Design & Development
Site analysis, wireframing, semantic HTML, CSS layout and styling, accessibility, and usability testing.
0 of 10 lessons · Coming soon
- WDD1Analysis and site structure
- WDD2Wireframes and prototyping
- WDD3HTML: semantic elements and structure
- WDD4HTML: forms and media
- WDD5CSS: selectors, properties, box model
- WDD6CSS: typography, colour and layout
- WDD7CSS: navigation and pseudo-classes
- WDD8Testing: browsers, accessibility, usability
- WDD9Evaluation
- WDD10WDD past paper practice
Exam revision
Tools & resources