2022 2 Ict
2022 2 Ict
2022 2 Ict
Time 1 hour
Paper
reference JCP11/01
Computing
Year 6
Achievement Test
Instructions
• Use black ink or ball-point pen.
• centrethe
Fill in boxes at the top of this page with your name,
number and candidate number.
• Answer all questions.
• Answer the questions in the spaces provided
– there may be more space than you need.
Information
• The total mark for this paper is 60.
• The marks for each question are shown in brackets
– use this as a guide as to how much time to spend on each question.
• You must NOT use a calculator.
Advice
• Read each question carefully before you start to answer it.
• Try to answer every question.
• Check your answers if you have time at the end.
Turn over
*P72022A0124*
P72022A
©2022 Pearson Education Ltd.
B:1/1/1/1/1
SECTION A
Answer ALL questions. Write your answers in the spaces provided.
Some questions must be answered with a cross in a box . If you change your mind about an
answer, put a line through the box and then mark your new answer with a cross .
1 Which one of these is a short code made up of numbers that is used to confirm the
identify of a user?
A Fingerprint
B Password
C PIN
D Username
envy fear happiness strength
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ........................................................................................................................................... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ........................................................................................................................................... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
2
*P72022A0224*
1 ............................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ........................................................................................................................................... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ........................................................................................................................................... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
2 ............................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
buzzer motor printer screen speaker
cable telephone video wireless
hardware networks software webpages
3
*P72022A0324* Turn over
8 Which one of these could be used as an online diary?
A Blog
B Spreadsheet
D Wiki
9 Draw one straight line from each description to the item it is describing.
Description Item
Bookmark
Work space
10 Explain one way in which playing computer games can damage someone’s health.
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4
*P72022A0424*
She records the number of each book sold and how much money she has taken.
Complete the table by adding the most appropriate type of software for each task.
Produce posters
Record sales
Cable TV network
5
*P72022A0524* Turn over
14 Monica wants to watch a movie on her smartphone.
Explain one reason why she might choose to stream the movie rather than
download it.
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
15 Draw one straight line from each description to the activity it is describing.
Description Activity
Pharming
Social interaction
B To save electricity
D To share a printer
6
*P72022A0624*
B To find errors
C To hold data
D To repeat an action
Which one of these calculates how many sweets each person will get?
A = number of sweets * 10
B = number of sweets / 10
C = number of sweets + 10
D = number of sweets − 10
19 Draw one straight line from each data type to the correct value.
Data type Value
Real
25
Char 11.2
TRUE
7
*P72022A0724* Turn over
20 Which one of these is a term for breaking a problem down into smaller
sub‑problems?
A Debug
B Decompose
C Interpret
D Write
algorithm event integer operator
22 Look at Figure 1.
It describes a process.
Figure 1
Give the output when the current time is 22:00.
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
8
*P72022A0824*
BLANK PAGE
9
*P72022A0924* Turn over
23 Look at Figure 2.
It shows the first draft of a flowchart that checks whether a password is correct.
A user gets three attempts to input the correct password before their account
is locked.
Start
Set attempts to 0
Input password
No
Add 1 to attempts
No
Has the user had 3 attempts?
Yes
Stop
Figure 2
10
*P72022A01024*
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
11
*P72022A01124* Turn over
24 This flowchart shows what happens when a car is started.
An alarm sounds if a door is not shut or if any of the passengers is not wearing a
seat belt.
Start
Start car
No
Yes
Yes
Stop
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
12
*P72022A01224*
Start
No
Yes
No
Stop
Here are the missing steps for the program. They are not in the correct order.
Complete the flowchart by adding the letter of each step in the correct flowchart box.
13
*P72022A01324* Turn over
SECTION B
Answer ALL questions. Write your answers in the spaces provided.
Some questions must be answered with a cross in a box . If you change your mind about an
answer, put a line through the box and then mark your new answer with a cross .
26 Which one of these is a tool used to remove part of an image?
A Caption
B Crop
C Format
D Scissor
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
14
*P72022A01424*
28 Look at Figure 3.
It was great to see you today as we It was great to see you today as
have not seen each other for ages. I we have not seen each other for
thought the movie we saw was very
good. Did you? We should not wait as ages. I thought the movie we saw
long to see each other next time. was very good. Did you? We should
not wait as long to see each other
next time.
Figure 3
State two features of word processing software that have been used to turn
version A into version B.
1 ............................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ........................................................................................................................................... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
2 ............................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ........................................................................................................................................... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
29 Look at Figure 4.
Figure 4
Which one of these layout features has been used to turn version A into version B?
15
*P72022A01524* Turn over
30 Complete the sentence by choosing one word from the box.
colouring drawing shading tabs
The background colour of a text box could be changed from white to red using the
31 Look at Figure 5.
It shows an extract from a student attendance database.
Figure 5
(a) Which one of these is where records are stored in a database?
(1)
A Cell
B Column
C Field
D Table
(b) Which one of these is a field used in Figure 5?
(1)
A 95.8
C Attendance %
D Davina
16
*P72022A01624*
(c) Which one of these is the data type used for Student ID?
(1)
A Char
B Number
C Integer
D Text
(d) Complete the query to find the students who have never missed a lesson.
(2)
............. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ........... = .............................................................................................
17
*P72022A01724* Turn over
32 Look at Figure 6.
It is part of a spreadsheet showing the marks students scored in tests.
A B C D
2 English test 10 8 7
3 Science test 7 6 8
4 Maths test 9 10 4
5 Total mark 26 24 19
Figure 6
(a) An example of a cell reference is E2.
Complete the table by adding a tick () to show the part of the cell reference that
identifies the row and the part that identifies the column.
(1)
18
*P72022A01824*
B =SUM(B4:D4)
C =SUM(D2:D4)
D =SUM(D4:D5)
(c) Give one reason why the teacher should save the spreadsheet with a sensible
filename.
(1)
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(d) The teacher must produce a printed report for the headteacher.
She wants to include part of the spreadsheet in the report.
State the type of software she should use to create the report.
(1)
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
19
*P72022A01924* Turn over
33 Look at Figure 7.
It shows the design for a slide.
################## ##################
B
(1)
(b) One use for a button on a slide is to provide navigation using a hyperlink.
Give one other use for a button.
(1)
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
20
*P72022A02024*
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................................................................................................................................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
21
*P72022A02124*
BLANK PAGE
22
*P72022A02224*
BLANK PAGE
23
*P72022A02324*
BLANK PAGE
24
*P72022A02424*