0417 y20 sm 3
Cambridge IGCSETM
INFORMATION AND COMMUNICATION TECHNOLOGY Paper 3 Data Analysis and Website Authoring MARK SCHEME Maximum Mark: 80
0417/03 For examination from 2020
Specimen
? UCLES 2018
This document has 14 pages. Blank pages are indicated.
[Turn over
0417/03
Cambridge IGCSE ? Mark Scheme SPECIMEN
For examination from 2020
Generic Marking Principles
These general marking principles must be applied by all examiners when marking candidate answers. They should be applied alongside the specific content of the mark scheme or generic level descriptors for a question. Each question paper and mark scheme will also comply with these marking principles.
GENERIC MARKING PRINCIPLE 1:
Marks must be awarded in line with:
? the specific content of the mark scheme or the generic level descriptors for the question ? the specific skills defined in the mark scheme or in the generic level descriptors for the
question ? the standard of response required by a candidate as exemplified by the standardisation
scripts. GENERIC MARKING PRINCIPLE 2:
Marks awarded are always whole marks (not half marks, or other fractions). GENERIC MARKING PRINCIPLE 3:
Marks must be awarded positively:
? marks are awarded for correct/valid answers, as defined in the mark scheme. However, credit is given for valid answers which go beyond the scope of the syllabus and mark scheme, referring to your Team Leader as appropriate
? marks are awarded when candidates clearly demonstrate what they know and can do ? marks are not deducted for errors ? marks are not deducted for omissions ? answers should only be judged on the quality of spelling, punctuation and grammar when
these features are specifically assessed by the question as indicated by the mark scheme. The meaning, however, should be unambiguous. GENERIC MARKING PRINCIPLE 4:
Rules must be applied consistently e.g. in situations where candidates have not followed instructions or in the application of generic level descriptors. GENERIC MARKING PRINCIPLE 5:
Marks should be awarded using the full range of marks defined in the mark scheme for the question (however; the use of the full mark range may be limited according to the quality of the candidate responses seen). GENERIC MARKING PRINCIPLE 6:
Marks awarded are based solely on the requirements as defined in the mark scheme. Marks should not be awarded with grade thresholds or grade descriptors in mind.
? UCLES 2018
Page 2 of 14
0417/03
Cambridge IGCSE ? Mark Scheme SPECIMEN
Task 1
Answer
Task 2
Answer Please see below for allocation of marks.
Task 3
Answer Please see below for allocation of marks.
Printout 1 ? TTSsales formula view
Name and details centred in the header Text Branch inserted in E1
For examination from 2020 Marks
Marks 52
Marks 28
1 mark 1 mark
VLOOKUP() function used
1 Mark
Lookup_value C2 used
1 Mark
Table_array TTSanalysis $A$3:$B$1 2 used
1 Mark
Index_number, 2 used
1 Mark
False parameter included
1 Mark
Printout only Amsterdam ? Almere and complete
1 Mark
Landscape orientation row and column headings shown1 Mark
All contents visible
1 Mark
? UCLES 2018
Page 3 of 14
0417/03
Cambridge IGCSE ? Mark Scheme SPECIMEN
Printout 2 ? TTSsales values
For examination from 2020
Data in Branch order ? values shown Sales descending order in Branch Printout only Naples ? Porto Portrait orientation, no row or column headings shown All contents visible
1 Mark 1 Mark 1 Mark 1 Mark 1 Mark
? UCLES 2018
Page 4 of 14
0417/03
Cambridge IGCSE ? Mark Scheme SPECIMEN
Printout 3 ? TTSanalysis ? Formulae
For examination from 2020
Branches in ascending order and data integrity maintained SUM() function used Contiguous ranges within TTSsales D2:D146 Landscape orientation with row and column headings shown All labels and data fully visible
1 Mark 1 Mark 1 Mark 1 Mark 1 Mark
? UCLES 2018
Page 5 of 14
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- paper 3 fundamentals of laws and ethics
- supplement for economic and commercial laws module 1 paper 3
- notes and guidance paper 3 issue evaluation
- igcse 0610 32 biology paper 3 jun20 papacambridge
- igcse physics 0625 31 june 2020 papacambridge
- cambridge international as a level
- principles of business cxc store
- information and communication technology 0417 31
- caie igcse mathematics 0580 32 paper 3 core
- caie gcse 0580 31 mathematics paper 3 core
Related searches
- activity 1 3 3 thermodynamics answer key
- activity 1.3.3 thermodynamics answer key
- act 1 3 3 thermodynamics answer key
- 3 3 t score bone density
- 3 by 3 linear system calculator
- 3 by 3 matrix solver
- 3 by 3 system solver
- 3 by 3 system calculator
- 3 equation 3 unknown solver
- 3 x 3 equation solver
- solving 3 x 3 linear systems calculator
- 3 3 repeating as a fraction