Information System Design and Development Units N5 Higher Subject Content

Source

Below is a table summarising the content for the Information System Design and Development unit taken from the Computing Science National 5 and Higher course support notes:

Information System Design and Development
Topic National 5 Higher
Structures and links
  • Database structure: flat file, linked tables
  • Field types: text, numbers, date, time, graphics, calculated, link,  Boolean)
  • Field lengths and range
  • Key field
  • Website, page, URL
  • hyperlink (internal, external), navigation.
  • Frames, sequence

 

  • database structures: relational, web-based
  • stylesheets, CSS
  • page structure: head, title, body
  • metadata
  • dynamic web pages, database-driven website
  • interactive web page, multimedia application
  • multi-level navigation

 

User interface User requirements: visual layout, navigation, selection, consistency, interactivity, readability
  • Usability: fit for purpose, efficient, robust, maintainable
  • Accessibility
  • Optimisation

 

Media Types Standard file formats:

  • text: txt, rtf
  • audio: wav, mp3
  • graphics: jpeg, bmp, gif, png
  • video: mpeg, avi
  • spreadsheet: xls, csv, xml
  • pdf

Factors affecting file size and quality, including resolution, colour depth, sampling rate

Need for compression

Compression:

  • lossy and lossless compression techniques, applied to sound, graphic and video data files

 

Coding
  • Scripting languages (including JavaScript)
  • Mark-up languages
  • Client-side scripting
  • Server-side scripting
Testing
  • Links and navigation
  • Matches user interface design
  • Beta testing
  • Usability
  • Compatibility issues (including memory and storage requirements, OS compatibility)
Purpose, features, functionality, users Description of purposeUsers: expert, novice, age range
  • Detailed descriptions of purpose
  • Users:

-human: expert, novice, age-range

-machine: search engines (crawlers and bots)

 

Technical implementation (hardware and software requirements) Hardware:

  • input and output devices
  • processor type and speed (Hz)
  • memory (RAM, ROM)
  • device type (including supercomputer, desktop, laptop, tablet, smartphone)

Software considerations:

  • operating systems

 

Hardware

  • input and output devices
  • processor type and speed (Hz)
  • memory (RAM, ROM)
  • device type (including supercomputer, desktop, laptop,
  • tablet, smartphone)

Software considerations:

  • operating systems
  • licensing
  • proprietary versus open source
  • transferability

 

Technical implementation (storage) Storage devices:

  • built-in, external, portable
  • magnetic, optical
  • solid state
  • capacity, speed
  • rewritable, read-only
  • interface type and speed

 

Storage devices:

  • built-in, external, portable
  • magnetic, optical
  • solid state
  • capacity, speed
  • rewritable, read-only
  • interface type and speed
  • distributed and off line storage
  • backup systems and strategy

 

Technical implantation (networking\connectivity)
  • Peer-to-peer versus client/server
  • Media: wired, optical, wireless
  • Comparison of local versus web/cloud
Cloud systems and server provision

  • public, private, hybrid
  • cloud-based services
  • web hosting

 

Security risks
  • Spyware, phishing, keylogger
  • Online fraud, identity theft
  • DOS (Denial of Service) attacks
Security precautions
  • Passwords/encryption
  • Biometrics
  • Security protocols and firewalls
  • Use of security suites

 

  • Encryption
  • Digital certificates and signatures
  • Server-side validation of online form data
  • Biometrics in industry

 

Legal implications
  • Computer Misuse Act
  • Data Protection Act
  • Copyright, Designs and Patents Act (plagiarism)
  • Health and Safety regulations

 

  • Freedom of Information (Scotland) Act (2002)
  • Regulation of Investigatory Powers Act (2000)

 

Environmental impact
  • Energy use
  • Disposal of IT equipment
  • Carbon footprint

 

  • Lifetime carbon footprint (manufacture, use, disposal)
  • Environmental benefits
Economic and social impact
  • Economic: competitive advantage, global marketplace, business costs, maintainability, scalability
  • Social: censorship and freedom of speech, privacy and encryption, global citizenship, online communities

 

Computing Science Progression Framework

From SQA Computing Science

The Computing Science progression framework (194 KB) provides advice and guidance on how experiences and outcomes at third and fourth curriculum levels relate to the Outcomes and Assessment Standards of National 4 and National 5 qualifications.

For the purposes of this document, experiences and outcomes, and Outcomes and Assessment Standards have been grouped under five main headings:

  • Designing and creating computer programs
  • Information storage and communication
  • Computer systems and architecture
  • Security considerations
  • Impact of technological developments on society and environment

Information System Design and Development Units N4 and N5 Subject Content

Source

Below is a table summarising the content for the Information System Design and Development unit taken from the Computing Science National 4 and 5 course support notes:

Information System Design and Development
Exemplification and implementation of the following in an application development environment:

Topic

National 4

National 5

Structures and links Database structure: field, record, fileField types: text, numbers, date, time, graphics, calculatedWebsite, page, URL

Hyperlink

Database structure: flat file, linked tablesField types: text, numbers, date, time, graphics, calculated, link, BooleanField lengths and range

Key field

Website, page, URL

Hyperlink: internal, external

Navigation.

Frames, sequence

User interface Target audience User requirements: visual layout, navigation, selection, consistency, interactivity, readability
Media types Sound, graphics, video, text Standard file formats:

  • text: txt, rtf
  • audio: wav, mp3
  • graphics: jpeg, bmp, gif, png
  • video: mpeg, avi
  • spreadsheet: xls, csv, xml
  • pdf

Factors affecting file size and quality, including resolution, colour depth, sampling rate

Need for compression

Coding Macros Scripting languages (including JavaScript)Mark-up languages
Testing Links and navigationMatches user interface design
Purpose, features, functionality, users Simple descriptions of main features and functionality Description of purposeUsers: expert, novice, age range
Technical implementation (hardware and

software

requirements)

Hardware:

  • input and output devices
  • processor clock speed (Hz)
  • memory (RAM, ROM)

Software considerations:

  • operating system platform required
Hardware:

  • input and output devices
  • processor type and speed (Hz)
  • memory (RAM, ROM)
  • device type (including supercomputer, desktop, laptop, tablet, smartphone)

Software considerations:

  • operating systems
Technical implementation (storage) Storage devices:

  • built-in, external, portable
  • magnetic, optical
  • capacity, speed
  • rewritable, read-only

 

Storage devices:

  • built-in, external, portable
  • magnetic, optical
  • solid state
  • capacity, speed
  • rewritable, read-only
  • interface type and speed
Technical implementation (networking/ connectivity) Stand-alone or networkedLAN/internetWired/wireless

 

Peer-to-peer versus client/serverMedia: wired, optical, wirelessComparison of local versus web/cloud
Security risks Viruses, worms, TrojansHacking Spyware, phishing, keyloggerOnline fraud, identity theft.DOS (Denial of Service) attacks
Security precautions Anti-virus software Passwords/encryptionBiometricsSecurity protocols and firewalls

Use of security suites

Legal implications   Computer Misuse ActData Protection ActCopyright, Designs and Patents Act (plagiarism)

Health and safety regulations

Environmental impact   Energy useDisposal of IT equipmentCarbon footprint

Computing Science National 4/National 5 – Course Materials

Education Scotland have made available the following files to assist teachers develop their own materials.

These support materials, which are neither prescriptive nor exhaustive, provide suggestions on approaches to teaching and learning which will promote development of the necessary knowledge, understanding and skills for Computing Science National 4/National 5. 

Staff are encouraged to draw on these materials, and existing materials, to develop their own programmes of learning which are appropriate to the needs of learners within their own context.

AOK Learning Computing Science Pupil Notes

AOK Learning has made pupil notes for Computing Science National 4 and National 4.

National 4 and 5 Computing Science Information Systems Design and Development Unit – Pupil Notes – 254 pages in standard fonts

National 4 and 5 Computing Science Software Design and Development Unit – Pupil Notes – 185 pages in standard fonts. Updated so that all exercises where students are expected to demonstrate their understanding of programming concepts now use Haggis pseudocode.