IGNORE SPELLING IN CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER. QUESTION 1 File name: 1Effect Total Q1: 24
No
Criteria
Max Mark
Candidate Mark
1.1.1
First Page
(Any) picture added to first page ✓
Correct picture 1Music added ✓
Picture wrapping/alignment changed to appear at top right-hand corner of page ✓
3
1.1.2
First Page
Text box added (anywhere) to the first page ✓
'Elvis High School' added as text to the text box ✓
2
1.2
Styles
New style 'Music' created ✓
Font size formatted to 48 pt ✓
Text centred ✓
3
1.3
Page Border
Any page border added ✓
First page only ✓
2
1.4
Watermark
Watermark text: 'First Draft' added ✓
Watermark text added only to first page ✓ (Note to marker: Do not accept if 'Different First Page' has been selected and watermark has not been deleted from second page.)
2
1.5
Comment
Comment deleted ✓
1
1.6
Text Effect
Font colour orange ✓ gradient text fill effect ✓ applied to heading 'The Effect Music Has On Me' (Notes to marker:
Allocate first mark if font colour was changed.
Mark from dialogue box.)
2
1.7
Dropped Cap
Dropped cap effect applied to the 'M' of 'Music' ✓
Over 2 lines ✓
0.6 cm/16 pt away from text ✓
3
1.8
Line Spacing
Second paragraph line spacing set to 'Multiple 1.15' ✓
1
1.9
Endnote
Endnote inserted ✓ on text 'Rap and Rock'
Appears in capital Roman number format 'I' ✓
Text entered in endnote ✓ ('Adapted from an article by S Mariam')
3
1.10
Find and Replace
2 occurrences ✓ of manual line break (soft enter)
Replaced with hard enters/paragraph marks ✓ (Note to marker: Located at the end of the second and third paragraphs under the heading 'The Effect Music Has On Me'.)
2
Total for QUESTION 1
[24]
QUESTION 2 File name: 2Facts Total Q2: 26
No
Criteria
Max Mark
Candidate Mark
2.1
Page numbering
Page numbering (any style) inserted in the footer ✓
Automatic page numbering inserted (as a field) ✓
Page numbers are centred ✓
First page is not numbered ✓
Numbering starts as page 1 on the second page (after the table of contents page) ✓ (Note to marker: Ignore if the numbering on the landscape pages from Question 2.6 onwards differs.)
5
2.2
Table of Contents
Automatic table of contents inserted ✓
Fancy style used (Small caps) ✓
Two levels of headings appear ✓
Solid line leader tab appears for page numbers ✓ (Note to marker: Ignore if ToC appears twice.)
4
2.3
Styles and Table of Contents
'Heading 1' style applied to the heading ✓
Table of contents reflects new entry (any style) ✓
2
2.4
Citations
New interview source added ✓
'Steve Johnson' inserted ✓ as interviewee
Text 'Placeholder1' replaced with automatic citation ✓
3
2.5
Columns
Text appears in 3 columns ✓
Spacing between columns is set at 1.1 cm ✓
Column break ✓ applied to each sub-heading
Text justified ✓ (Note to marker: Award third mark for any column break.)
4
2.6
Page Orientation
Page containing text in landscape orientation ✓
All other pages remain portrait orientation ✓
2
2.7
Numbered and Bulleted List
Level 1 numbering set to 1. 2. 3. ✓
Level 1 numbering aligned to 1 cm ✓
Level 1 text relatively aligned/indented to 2 cm ✓
Level 2 set to ✓✓
Level 2 bullet relatively aligned/indented to 2 cm ✓ (Note to marker: Ignore if 1., 1 or 1) and type of ✓ bullet.)
5
2.8
Table
Function inserted =AVERAGE(Above) ✓
1
Total for QUESTION 2
[26]
QUESTION 3 File name: 3Learners Total Q3: 25
Mark the questions from the formulae and not the values/answers in the cell.
Check against candidates' actual work (Cell references may differ, depending on the candidates' response).
Candidates may use multiple formulae or cells as 'building blocks' to answers.
Named ranges can be used instead of cell references.
No
Criteria
Max Mark
Candidate Mark
Member worksheet
3.1
Range A1:M1:
Merge and centre ✓ applied to text in range A1:M1
1
3.2
Cell G2:
=TODAY() ✓ OR NOW()
1
3.3
Cell B3: =COUNTA(B5:B103) OR =COUNTIF(B5:B103,"*")
COUNTA/COUNTIF function ✓
Range✓: (B5:B103) (Note to marker: Accept COUNTA function on columns C, D, E, F, G, I or L OR COUNT function on columns D, E, F, G or I.)
2
3.4
Cell A5: =UPPER(B5)
UPPER function ✓
Cell (B5) ✓
2
3.5
Print setting:
Print area set ✓ to range B4:D103
Print gridlines set to show ✓ Notes to marker:
Accept if column A has been included.
Accept if 'Headings – Print' were selected in 'Sheet Options' and range is B5:D103.)
2
3.6
Column G:
Format changed to yyyy-mm-dd ✓ (Note to marker: Accept if just cell G5 formatted.)
1
3.7
Cell H5: =CONCATENATE("011",I5) OR ="011"& I5
CONCATENATE function OR & ✓
"011" ✓
I5 ✓
3
3.8
Cell K5: =IF(J5="","Yes","No") OR =IF(ISBLANK(J5),"Yes","No") OR =IF(J5<>"","No","Yes") OR =IF(COUNTA(J5)=0,"Yes","No") OR =IF(LEN(J5)=0,"Yes","No")
Testing if J5 is "blank" ✓
If cellphone is not available: "Yes" ✓
If cellphone is available: "No" ✓
Function copied to cells K6:K103 ✓ (Note to marker: Accept any suitable variations and if "Y" and "N" used instead of "Yes" or "No".)
4
3.9
Cell M5: =MID(L5,FIND("@",L5,1)+1,LEN(L5)) OR =RIGHT(L5,LEN(L5)-FIND("@",L5))
To the end of the text/domain: LEN(L5), etc.✓ (Note to marker: Check for 'building blocks' in other columns.)
7
Dec worksheet
3.10
Extract and copy:
Two members born in the month of December ✓
Copied to the Dec worksheet ✓ (Notes to marker:
2 members expected (Killian R and Hassim T).
Accept if not all the information was copied.)
2
Total for QUESTION 3
[25]
QUESTION 4 File name: 4Club Total Q4: 25
Mark the questions from the formulae and not the values/answers in the cell.
Check against candidates' actual work (Cell references may differ, depending on the candidates' response).
Candidates may use multiple formulae or cells as 'building blocks' to answers.
Named ranges can be used instead of cell references.
No
Criteria
Max Mark
Candidate Mark
Music
4.1
Column B:
All data is visible in column B ✓
1
4.2
Column G:
Data in column G formatted to 2 decimal places ✓ (Note to marker: Accept if only part of the column has been changed or if formatted as a currency format.)
1
4.3
Cell F2: =VLOOKUP(A2,Code!$C$2:$D$4,2)
Lookup value: A2 ✓
Table array: Code_Kode!C2:D4 ✓
Reference column: 2 ✓ or use of LOOKUP function
Absolute cell reference: Code_Kode!C$2:D$4 ✓
Copied to remaining cells ✓ (Notes to marker:
Ignore 'True' or 'False'.
Also accept absolute cell reference $C$2:$D$4.)
5
4.4
Cell H2: =IF(A2=1,G2*1.2,IF(A2=2,G2*1.25,G2*1.15)) OR =IF(A2=1,G2+G2*20/100,IF(A2=2,G2+G2*25/100,G2+ G2*15/100)) OR =IF(A2=1,G2*120/100,IF(A2=2,G2*125/100, G2*115/100)) OR =IF(F2="CD",G2*120/100,IF(F2="DVD",G2*125/100, G2*115/100))
Nested IF/Function-construct is correctly used ✓
Condition CD OR Code 1 and value G2*1.2 ✓
Condition DVD OR Code 2 and value G2*1.25 ✓
Condition MP3 OR Code 3 and value G2*1.15 ✓ (Note to marker: Accept if column F was used with 'MP3', etc. If the percentage was calculated without the increase, penalise conditions by one mark.)
4
4.5
Cell L2: =COUNTIF($D$2:$D$612,K2)
Absolute cell reference D$2:D$612 ✓
'1990' replaced with cell reference K2✓ (Note to marker: Accept ($D$2:$D$612) as range.)
2
4.6
Cell L21: =SUMIF(E2:E612,"POP",G2:G612)
SUMIF function ✓
Criteria range: (E2:E612) ✓
Criteria: "POP" OR K21 ✓
Sum range: (G2:G612) ✓
4
Copy worksheet
4.7
Cell J2:
Expected answer: 101 ✓ Method J3:
Removed duplicate ✓ owners ✓ --------------------------------------------------------------------------------------------------------------- OR
Sorted, deleted duplicate owners ✓ and counted ✓ -------------------------------------------------------------------------- OR
Sorted owners ✓ and counted unique owners ✓ (Notes to marker:
Accept any other correct method e.g. =SUMPRODUCT((G2:G636<>"")/COUNTIF(G2:G636,G2:G636)).
Allocate all three marks if the correct answer displays.)
3
Graph worksheet
4.8
Chart:
Horizontal axis title ('Years') inserted ✓
Horizontal axis labels changed to display years 2000 - 2005 ✓
Legend changed to 'Number of songs' ✓
Vertical axis label major unit set to fixed 50 ✓
Data labels set (any position) to show values✓
5
Total for QUESTION 4
[25]
QUESTION 5 File name: 5Music Total Q5: 42
No
Criteria
Max Mark
Candidate Mark
Table: Learners
5.1.1
Field: Gender
Default value set to 'M' ✓
1
5.1.2
Field: Grade
Set as required field ✓
1
5.1.3
Field: Class
Display control: List box/Combo box ✓
Row source type: Value list ✓
Row source: A, B, C, D OR a, b, c, d ✓ (Notes to marker:
Allocate third mark if one option added.
Also accept if separate table created and used with rows/source type set to Table/Query.)
3
5.1.4
Field: DOB
Format Set to Medium Date ✓
Input Mask symbol Placeholder changed to # via wizard: 00\->L<LL\-00;0;# ✓
2
5.1.5
Field: Cell
Validation rule: Len ✓ ([Cell_Sel]) ✓ =10 ✓
Validation text: Refers to 10 characters ✓
4
Form: frm5_2
5.2
Displays all 12 fields from Learners table ✓
Font colour of the data in the Owner field appears as reddish ✓
Combo box/List box added in details section ✓
Row source based on Owner field ✓
Row source: SELECT [Learners].[Owner] FROM Learners; ✓
Label 'Find what' added ✓
Horizontal line added to form footer ✓ Notes to marker:
Mark from Form view.
Do not allocate fifth mark if selected record does not display.
Accept any line inserted anywhere in form footer.)
7
Query: qry5_3
5.3
Fields displayed: Title, Artist, Year and Genre ✓
Year criteria: 1996 ✓
Genre criteria: 'DANCE' ✓
Title field sorted ascending ✓ (Note to marker: 1 record expected.)
4
Query: qry5_4
5.4
Cost field added ✓ and format set to any currency ✓
Calculated field added: Inc: ✓ [Cost] * 2 award two marks if *2 is omitted OR Inc: [Cost]+[Cost]
5
Query: qry5_5
5.5
Total row displayed ✓
Grouped by Genre ✓
Cost field: Total property set to Sum ✓
(Note to marker: 3 records for three genres expected.)
3
Query: qry5_6
5.6
Address field criteria: Like "13 *Crescent"
13 ✓
Compulsory space after 13 ✓
*Crescent/*Cre* ✓ (Note to marker: 3 records expected. Accept any alternative method.)
3
Report: rpt5_7
5.7
Report display fields: Artist, Title, Year, Cost and Genre ✓
Report grouped according to Year field ✓
Sorted on Artist field ✓
Report heading changed to 'Year released' ✓
Function in Year footer/header ✓: =SUM([Cost]) and suitable label added ✓
Function in report footer/header ✓: =MAX([Cost]) ✓ (Note to marker: Do not penalise if label in the report footer is not given or not suitable.)
9
Total for QUESTION 5
[42]
QUESTION 6 File name: 6Poster Total Q6: 19
This question should be marked from the web browser as far as possible unless otherwise indicated or it cannot be seen in the web browser.
A maximum of 1 mark will be deducted if one or more closing tags are omitted.
The code of the candidates that use a word processor will contain additional unnecessary tags. Markers will need to work through the code to check for the answers provided below.
No
Criteria
Max Mark
Candidate Mark
6.1
Title <head> <title>'60s Music</title> </head>
Title with title tags moved to head section of web page ✓
