SDD Overview Analysis Design Implementation Testing Evaluation Other
DDD Overview Analysis Design Implementation Testing Evaluation Other
WDD Overview Analysis Design Implementation Testing Evaluation Other
Systems Overview Data Representation Computer Structure Legislation Environmental Security
☰

SQA Assignment

Assignment Key points

  • You have 6 hours in class to complete your Assignment
  • You are not allowed to access the task or work on it outwith the class.
  • The task is open book and you can access previous learning/tasks including online resources.
  • You must use offline software like MuEditor or Brackets to complete the task.
  • Email and any other form of communication is prohibited
  • This is an independent task and your teacher will not be able to assist you during the 6 hour period

Assignment Tips

  • Manage your time. Don't drop easy marks because you have ran out of time!
  • Use a highlighter to pick out the important parts of the task
  • The design notation provided is there to help and should be followed. You will drop marks otherwise
  • Good programming techniques like internal commentary should be included
  • Don't hand in any work without fully checking. You won't get it back!

SQA Assignment - Quick Notes

Topic Analysis Design Implementation Testing Evaluation

Software Development

Identify Functional Requirements

  • Input
  • Process
  • Output

Use Design Notation

  • Pseudocode
  • Structure Diagram
  • Flowchart

Could include:

  • Input Validation
  • Running Total with Fixed/Condtional Loops
  • Traversing an Array

Code your solution using Python

Classwork - Example code

All previous Assignment solutions are further down on page.

Test your solution using Normal, Extreme, Exceptional Test data

 When Evaluating, it is IMPORTANT that you evaluate your own code.
You could be asked to evaluate:
  • Readability
  • Efficiency
  • Fit for Purpose
  • Robustness

Web Development

Identify Functional Requirements
The page should include...

Identify End-User Requirements- Verb

Functional Requirements - start with "The website should contain"

End user requirements should contain a VERB. Something the user does: Reads, Clicks, Views, Listens

Draw a wireframe

Draw a navigation map

Code a page/section of a page using HTML

Apply styles using internal CSS or external CSS file

Classwork Example Solutions

See section below for coding solutions to previous assignments

Test media elements (pictures, sound, video) display correctly

Test hyperlinks take the user to correct page

Evaluate 'Fit for Purpose'

Does the website include ALL the functional requirements set out at the Analysis stage. "YES" or "NO" and justify your answer

Database Development

Identify Inputs

Read through scenario and identify which fields/attributes are required for each table/entity. Don't forget the Foreign Key will feature in both tables as the link field.

Data Dictionary - fill in gaps in data dictionary. Identify PK/FK and any validation required.

Create the table structure with relationship 1:M

Add in Validation

Perform Queries - SELECT, INSERT, UPDATE, DELETE, EQUI-JOIN

Test the results of queries - do the Actual results match your Expected results.

Evaluate 'Fit for Purpose'

Does the database/query function correctly? and produce accurate results "YES" or "NO" and justify your answer

Past SQA Assignment Solutions

Year Software Solution Web Solution Database Solution

2023

2022

2021

2020

2019

2018

Specimen

Exam Revision - Theory Notes


Software Development
Database Development
Web Development
Computer Systems

SQA Past Papers

2022
2021
2019
2018
2017

Old Prelim Papers

2021-22

Exam Style - Topic by Topic

SQA Revision Support document (March 2022)

Question Paper Marking Scheme