Course Info

Advanced Higher Computing has two assessment components.

The Question Paper is 2 hours long and is worth 55 marks (Approx 40%)

The Project is worked on throughout the session and is work 80 marks (Approx 60%)

Question Paper

The question paper has 55 marks, which is approximately 40% of the overall marks for the course assessment (135 marks).

It has three sections. Section 1 is mandatory, and candidates have the option to complete wither section 2 or section 3.

Section 1: Software design and development — 35 marks
Section 2: Database design and development — 20 marks
Section 3: Web design and development — 20 marks

Integration

The ‘Database design and development’ and ‘Web design and development’ sections will each contain a question set in the context of a database-driven website.

Part of this question will require some integration with the other option. The summaries below detail what could be asked in the question paper.

Integration within the Database Design Section

For ‘Database design and development’, candidates will need to be familiar with the following ‘Web design and development’ skills, knowledge and understanding so they can design and implement HTML forms:

Design

Describe, exemplify, and implement wireframe designs showing:

visual layout
navigation
consistency
underlying processes

Implementation

Describe, exemplify, and implement form elements including:

FORM element:
- action
- method (get and post)

INPUT, SELECT and TEXTAREA elements:
- name
- value

Describe, exemplify and implement form elements:

form element: INPUT
- - text
  - number
  - textarea
  - radio
submit
form element: select

Describe, exemplify and implement form data validation:

length
presence
range

Read and explain code that makes use of the above HTML.

Integration within the Web Design Section

For ‘Web design and development’, candidates will need to be familiar with the following ‘Database design and development’ skills, knowledge and understanding in order that they can implement SQL queries:

SELECT
- FROM
- WHERE:
  - AND, OR, <, >, = o
  - ORDER BY with a single field —
- use of MAX, MIN, AVG, COUNT and SUM to return a single value

INSERT
UPDATE
DELETE

Read and explain code that makes use of the above SQL.