Category: Revision

National 5 & Higher Course Content

You have a paper copy of this in your folders but I thought you might want an electronic copy.

The document is divided into

  • Yellow (SDD)
  • Orange (SDD & ISDD)
  • Red (ISDD)

For the exam National 5 pupils could be asked question from National 4 & 5. Higher pupils can be asked about content from all three courses.

TIP: Take a highlighter and mark of areas as you study them, use traffic lights to mark areas you need to come back to.

Structures and links (database)

  • Database structure: field, record, file
  • Database structure: flat file, linked tables, primary keys, foreign keys
  • Field types (text, numbers, date, time, graphic, object, calculated, link, boolean)
  • Validation (presence check, restricted choice, field length, range)
  • Database operations search, sort (on multiple fields)
  • Good design to avoid data duplication and modification errors (insert, delete, update)

Read more

N5 – Revision Booklet

Here are the notes that we handed out last week

You will need to find the answers for the question papers online.

To use this resource

  1. Print out the revision pack.
  2. Look at the summary pages and mark off areas you are confident in.
  3. Fill in the calendar pages with revision topics you are not confident in.
  4. The revision notes in the pack are very brief, so use the book or BBC bitesize to help you study.
  5. Use the question papers to test you knowledge, if you can not do a question then use the notes to help you before going to the book or bitesize.

If you have any questions then please ask!

Computational Constructs

  • Expressions to assign values to variables
  • Expressions to return values using arithmetic operations (+, -, *, /, ^, mod)
  • Execution of lines of code in sequence demonstrating input – process- output
  • Expressions to concatenate strings and arrays using the & operator
  • Use of selection constructs including simple and complex conditional statements and logical operators.
  • Iteration and repetition using fixed and conditional loops Pre-defined functions (with parameters)

Read more