Cambridge Assessment International Education

Cambridge International Advanced Subsidiary and Advanced Level

APPLIED INFORMATION AND COMMUNICATION TECHNOLOGY 9713/02

Paper 2 Practical Test A October/November 2017
MARK SCHEME
Maximum Mark: 120

Published

This mark scheme is published as an aid to teachers and candidates, to indicate the requirements of the
examination. It shows the basis on which Examiners were instructed to award marks. It does not indicate the
details of the discussions that took place at an Examiners’ meeting before marking began, which would have
considered the acceptability of alternative answers.

Mark schemes should be read in conjunction with the question paper and the Principal Examiner Report for
Teachers.

Cambridge International will not enter into discussions about these mark schemes.

Cambridge International is publishing the mark schemes for the October/November 2017 series for most
Cambridge IGCSE®, Cambridge International A and AS Level components and some Cambridge O Level
components.

® IGCSE is a registered trademark.

This document consists of 21 printed pages.

© UCLES 2017 [Turn over

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017

No marks to be awarded for any printout not containing the candidate name,
candidate number and centre number.

© UCLES 2017 Page 2 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 1

Presentation created 1 mark

Slide master Slide 1
Candidate name & no’s top left 1 mark Title slide added 1 mark
Black 18pt serif font 1 mark Title & subtitle accurate & appropriate size/style 1 mark
All slides
Not overlapping 1 mark
Title/subtitle in appropriate format 1 mark
Body text on slides
Black font 1 mark
Sans serif font 1 mark
Consistent within slide 1 mark

© UCLES 2017 Page 3 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 2

© UCLES 2017 Page 4 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 3

© UCLES 2017 Page 5 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 4

© UCLES 2017 Page 6 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 5

© UCLES 2017 Page 7 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 6

© UCLES 2017 Page 8 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 7

© UCLES 2017 Page 9 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 8

© UCLES 2017 Page 10 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 9

© UCLES 2017 Page 11 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 10

© UCLES 2017 Page 12 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Slide 11

© UCLES 2017 Page 13 of 21

 9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Planning time for tasks Header 100% correct 1 mark
Fits to single page 1 mark
Gridlines visible 1 mark
Contents fully visible 1 mark Row 1 & Column A – Bold 1 mark
Row 2 deleted 1 mark Row 1 & Column A – Centre aligned 1 mark
Cells A1 to L20 only visible 1 mark

Data in row 11 correct 1 mark

Dates 100% correct 1 mark

Columns B & J – dd/mm/yyyy format 1 mark

Row 12 (now seen as 11)
Display for column K as shown 1 mark
Inserted & Event 10 placed 1 mark
Global replace –Task to Event 1 mark

Correct values shown for count 1 mark Candidate name & numbers
In footer 1 mark

© UCLES 2017 Page 14 of 21

 9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Header 100% correct 1 mark
Landscape 1 mark
Row & column headings fully visible 1 mark
Formulae, labels & gridlines fully visib. 1 mark

Day Correct function 1 mark

Month Correct function 1 mark
Year Correct function 1 mark
End date Correct calculation 1 mark
Most efficient method 1 mark

COUNTIF 1 mark
Correct range to working column 1 mark
Condition reference to cell in A 1 mark
Replication All formulae 1 mark

© UCLES 2017 Page 15 of 21

971
13/02 Ca
ambridge Interna
ational AS/A Lev
vel – Mark Scheme October/Novem
mber
PUBLISHED 2017
W
Working
=
=RIGHT() 1 mark
K
K2 1 mark
,16 characters 1 mark

Full en
nd date
Text Correcct function 1 m mark
Referennce Correcct cell 1mmark
Space Include
ed after date 1 m
mark
Day poortion Correcct format 1mmark
Month portion Correcct format 1mmark
Year poortion Correcct format 1mmark
Concattenate or & 1mmark
“[“ 1mmark
Lookupp Functio
on used 1mmark
Referen
nce Correcct cell 1mmark
Range Range from file 1mmark
Concattenate or & 1mmark
“]“ 1mmark

© UCLES 2017 Page 16 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017

Sorted
On end date with integrity 1 mark
Most recent at top 1 mark

Extract printed A1 to L20 fully visible 1 mark

Gridlines visible 1 mark

Correct data extracted 1 mark

Correct cell range, fully visible, row &
column headings and gridlines 1 mark

© UCLES 2017 Page 17 of 21

 9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017
Header –100% correct & printed as specified 1 mark

Working
Correct 5 events changed 1 mark
With years changed from 2017 to 2016 1 mark
No changes to any other data (esp. Full end date) 1 mark

Correct values shown for count 1 mark

© UCLES 2017 Page 18 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017

Header 100% correct & printed as specified 1 mark

Working
=IF () function 1 mark
Extracting quarter no (4 marks) e.g.:
LEFT( ,1) 1 mark
RIGHT(K2,2) 1 mark
=”4” 1 mark
Corrected version if test true (@ marks)
TEXT () 1 mark
J2 abs reference 1 mark
“yyyy” format 1 mark
-1 1 mark
Concatenate or & 1 mark
=RIGHT() 1 mark
K2 1 mark
,12 characters 1 mark
Else if incorrect
Same function as previous print 1 mark
Whole function
Most efficient working solution 1 mark

© UCLES 2017 Page 19 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017

Evidence document

Correct text« 1 mark

«Internal - to correct slide 1 mark

Correct text« 1 mark

«Internal - to correct slide 1 mark

© UCLES 2017 Page 20 of 21

9713/02 Cambridge International AS/A Level – Mark Scheme October/November
PUBLISHED 2017

Correct text« 1 mark

«Internal - to correct slide 1 mark

Correct text« 1 mark

«Web page 1 mark
«Correct URL 1 mark

© UCLES 2017 Page 21 of 21