Changes to Blog

This blog will now contain information about three levels of the Computing Science Course.

  • National 4
  • National 5
  • Higher

Media Types

  • Standard file formats:
    • Text: txt, rtf
    • Audio: wav, mp3
    • Graphics: jpeg, bmp, gif, png
    • Video: mp4, avi
    • Pdf
  • Factors affecting file size and quality, including resolution, colour depth, sampling rate
  • Calculation of file size for colour bitmap
  • Need for compression

Read more

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