National 5 Computing Science Teaching Resources & Lesson Plans

​N5 specification

​GCSE Document Reference

​Additional content

​1

​Software design and development

Cell
Cell
Cell

​Development methodologies

​Describe and implement the phases of an iterative development process

Cell

​Analysis

​Analysis

Cell

​Design

​Structure diagrams

​Describe, exemplify, and implement user-interface design, in terms of input and output, using a wireframe

Cell

​Implementation (data types and structures)

Cell
Cell

​Implementation (computational constructs)

​Predefined functions such as random and round with parameters

Cell

​Implementation (algorithm specification)

Cell
Cell

Testing

​Evaluation

​Test table

​fitness for purpose, efficient use of coding constructs

​2

Computer systems

Cell
Cell
Cell

​Data representation

​Describe the vector graphics method of graphic representation for common objects with attributes

Cell

​Computer structure

Cell
Cell

​Environmental impact

​Energy use of computer systems and how these could be reduced

Cell

​Security precautions

Cell

3

​Database design and development

Cell
Cell
Cell

​Analysis

Cell

​Analysis

Cell

​Design

​General Data Protection Regulation (GDPR) — Regulation (EU) 2016/679

​Data dictionary

​Query for multiple tables & sort order

Cell

​Implementation

​Referential integrity &
SQL operations for pre-populated relational databases, with a maximum of two linked tables

Cell

​Testing

Cell

​Testing

Cell

​Evaluation

Cell

​Evaluation

​4

​Web design and development

Cell
Cell
Cell

​Analysis

Cell

​Analysis

Cell

​​Design

​Website structure.

​Describe, exemplify and implement, taking into account end-user requirements, effective user-interface design (visual layout and readability) using wire-framing.

​Copyright, Designs and Patents Act 1988.

​Describe, exemplify and implement prototyping (low-fidelity) from wireframe design at this level.

Cell

​​Implementation (CSS)

Cell

​​Implementation (CSS)

Cell

​​Implementation (HTML)

Cell

​​Implementation (HTML)

Cell

​Testing

Cell

​Testing

Cell

​Evaluation

Cell

​Evaluation