Specific marking instructions Task Expected response Additional guidance Marks available 1 Database design and development — part A 1a 1 mark for identifying: employee number 1 mark for identifying: first name surname address (or street, town) telephone number driving licence Must identify all five attributes 2 Analysis (2) 1b 1 mark for completion of each row: serialNumber — PK timeCompleted — time model — restricted choice: Jazz8, Rock100 and Blues55 testPassed — Boolean employeeNumber — FK No marks awarded for application specific field types in “Type” column (for example date/time, yes/no) Restricted choice must list all three choices 5 Design (5) Task Expected response Additional guidance Marks available 1 Database design and development — part B
1c 1 mark each for: all fields created with correct data primary key (serialNumber) presence check on every field restricted choice on with correct three options length = 10 characters on serialNumber linked table enforcing referential integrity Fields required: serialNumber — text dateBuilt — date timeCompleted — time — text testPassed — Boolean employeeNumber — FK 6 Implementation (8) 1d 1 mark each for: INSERT INTO Employee correct data, in correct Sample answer: INSERT INTO Employee VALUES (1599, ‘Jeremy’, ‘May’, ‘67 Red Lane’, ‘07923782534’,true); 2 Task Expected response Additional guidance Marks available 2 Software design and development 2a Array used in program 1 Implementation (15) Use of the following variables: total hits average points Variable names may differ in code All three variables are required for 1 mark 1 Fixed loop repeating six times (to enter player hits) 1 Input validation — conditional loop used 1 Input validation — correct loop condition hits >= 0 and hits <= 30 1 Input validation — input of player hits 1 mark if not implemented within input validation loop 1
Input validation — error message 1 Running total calculated correctly 1 Round function used with average 1 Calculation of bonus points: for one bonus point for an additional bonus point 2 Selection (if) used to display message showing one bonus point earned (totalHits > 50) Output must be within selection 1 Selection (if) used to display message showing additional bonus point earned (average >= 10) Output must be within selection 1 Selection (if) used to display message showing zero bonus points earned (totalHits <= 50) Output must be within selection 1 Matches design — same sequence of events as flow chart 1 2b Both test tables completed to produce the required output (one point or two) Table 1 hits should total 51-59 2 hits should total >=60 1 Testing (5) In first table, printed evidence of successful run of test data Both inputs and outputs should be printed 1 In second table, printed evidence of successful run of test data Both inputs and outputs should be printed 1 2c Completion of test data for validation of player’s hits for 1 mark each: extreme: 0 and 30 exceptional: any suitable, eg 1, 31 Only accept numerical answers for exceptional test data 2
Task Expected response Additional guidance Marks available 3 Web design and development 3b Using the printout of the HTML file, confirm the following for 1 mark each: all text and graphics content added (within structural head, title, body, tags, p, H1, div, etc) audio tag used link to external CSS file added in <head> section Using the printout of the CSS file, confirm the following for 1 mark each: School Name Text styled correctly Month and Pupil’s Name styled using a single CSS rule graphic size correct (CSS or HTML) background colour changed (CSS or HTML) Text and graphics checklist: School Name Month Photo Pupil’s Name CSS for School Name Text h1 { font-size: 16px; font-family: “Tahoma”; text-align: center; } CSS for Name Text: h2 { font-size: 14px; font-family: “Tahoma”; text-color: white; } CSS for <img> tag Internal style: External stylesheet: img { width:200px;height:250px;} CSS for page background internal style: <body style=”background-color:blue;”> External stylesheet: body {background-color:blue;} 7 Implementation (7)