Select the alternative that corresponds to the best answer.

Answer ALL questions in this section. 

Record your answer in the answer sheet provided on page 21 of this booklet. 

Question 1

What is a collection of worksheets known as in spreadsheet software?

A. Cell

B. Row

C. Column

D. Workbook

Question 2

In which area are backdrops placed to create scenes in Scratch?

A. Block

B. Script

C. Sprite

D. Stage

Question 3

Which system unit component is used to connect input and output components to a device?

A. Ports

B. Hard disk drive (HDD)

C. Read only memory (ROM)

D. Random access memory (RAM)

Question 4

Below is a graphical representation showing the number of animals kept on a farm.

 

What type of graphical representation has been used to display the data?

A. Pie chart

B. Bar graph

C. Line graph

D. Column graph

Question 5

Below is a block from Scratch.

 

Each block is:

A. a stage

B. a sprite

C. a backpack

D. an instruction

Question 6

A network interface card is used to:

A. save data permanently

B. allow a device to connect to a network

C. connect two separate networks together

D. convert data signals from analogue to digital

Question 7

As part of a data analysis task Hiro created a survey. Once the survey was written, Hiro sent the survey to 30 of his friends to complete. The survey included the following question.

 

The type of question shown is best described as:

A. an open-ended question

B. a closed-ended question

C. a question collecting secondary data

D. a question that allows a participant to give a wide range of responses

Question 8

In which project stage would you test and debug a Scratch application?

A. Application design

B. Application evaluation

C. Application development

D. Application requirements

Question 9

Which security measure is best to stop an unauthorised user gaining access to data and information stored on a smart phone?

A. Firewall

B. Education

C. Username and password

D. Computer protection software

Question 10

Which design principle is related to the practice of placing headings and sub-headings in a larger font size?

A. Colour

B. Contrast

C. Proportion

D. White space

Question 11

How is animation added to a sprite in Scratch?

A. By adding a variable

B. By changing the backdrop

C. By changing the sprite’s costume

D. By using a timer to restrict the time allowed to complete a level

Question 12

Where is data located when saved to a cloud provider?

A. In the sky.

B. Nobody knows.

C. On a local area network (LAN).

D. On a server located in a different location to the user.

Question 13

Which spreadsheet feature has been used to interrogate the data below?

A. Conditional formatting

B. Sorting (by Student in ascending order)

C. Sorting (by Average in ascending order)

D. Sorting (by Average in descending order)

Question 14

Which of the following is an input device (or component)?

A. Speaker

B. Projector

C. Webcam

D. Headphones

Question 15

Which transmission media method uses wires?

A. Wi-Fi

B. Bluetooth

C. Cellular radio

D. Unshielded twisted pair (UTP)

Section B: Short-answer Questions (45 marks)

Answer ALL questions in this section. Write your answers in the space provided.

Question 1 (2 marks)

Explain how data differs from information.

Question 2 (2 marks)

Kim is 18 years old. For each of the last six years she has been measuring her height in centimetres.

She then created the following pie chart to help her visualise the change in her height over time.

 

Explain a problem with the type of graphical representation chosen by Kim. List a type of graphical representation that would be more appropriate to represent the data.

Problem ________________________________________________________________

Type of graphical representation _____________________________________________

Question 3 (5 marks)

Below is a spreadsheet that contains data collected as part of a survey about transport.

Eight participants completed the survey and the results are shown below.

	A	B	C
1	Transport survey data
2	Transport Type	Travel Time (minutes)	Distance travelled (kilometres)
3	Train	20	10
4	Bus	40	15
5	Walking	10	1
6	Car	20	8
7	Bus	30	9
8	Train	20	12
9	Walking	10	1
10	Bicycle	10	8
11	Average Travel Time	=AVERAGE(B3:B10)
12	Number of Participants who travel by Train	2
13	Total Travel Time of Bus participants	70

a. State one convention applied to the spreadsheet. 1 mark

b. List the value that would be displayed in cell B11. 1 mark

c. Write the formula that would be entered into cell B12. 1 mark

d. Write the formula that would be entered into cell B13. 2 marks

Question 4 (3 marks)

For his studies about digital systems, Jason created a presentation about networks.

Below is one slide from the presentation.

 

a. Describe how the design principle of contrast has been incorporated (included) in the presentation. 1 mark

b. Besides proportion and contrast, list and explain one other design principle that has been incorporated (included) in the presentation. 2 marks

Design principle __________________________________________________________

Explanation ______________________________________________________________

Question 5 (3 marks)

Types of data include quantitative and qualitative.

a. Describe how quantitative data differs from qualitative data. 1 mark

b. Outline one advantage and one disadvantage of using quantitative data when analysing a topic. 2 marks

Advantage _______________________________________________________________

Disadvantage ____________________________________________________________

Question 6 (2 marks)

Explain how a digital system differs from an information system. 2 marks

Question 7 (8 marks)

Below is an application created in Scratch.

 

a. Outline the purpose of a sprite in Scratch. 1 mark

b. List one block used that comes from the Operators group. 1 mark

Time is a variable used in the application.

c. Describe the purpose of a variable in Scratch. Explain the purpose of the variable ‘Time’ in the application. 2 marks

Purpose of a variable ______________________________________________________

Purpose of Time __________________________________________________________

d. List two methods that can be used to add a new backdrop to the application. 2 marks 

Scratch is a programming language.

e. Explain how the purpose of a programming language is different to the purpose of application software. 2 marks

Question 8 (3 marks)

Angel created the application below using Scratch:

 

The application includes the use of a custom block.

a. List a block, in the application, that is a custom block. 1 mark

b. Define a custom block. 1 mark

c. Explain one advantage of using custom blocks in an application. 1 mark

Question 9 (6 marks)

Chao and Li have been working together on a group film project. They used a provider to save all project files in the cloud.

 

a. Outline one advantage and one disadvantage of storing files in the cloud. 2 marks

Advantage _______________________________________________________________

Disadvantage ____________________________________________________________

b. State the type of network used in cloud computing – LAN or WAN. Give a reason for your answer. 2 marks

Type of network __________________________________________________________

Reason _________________________________________________________________

When Li transmits files from her device to the cloud, the files travel through a router and modem.

c. Describe the function of a router and modem in transmitting data across a network. 2 marks

Router __________________________________________________________________

Modem _________________________________________________________________

Question 10 (8 marks)

Bader has installed a network at his workplace. A diagram of the network is shown below.

The network includes three desktop computers. Each desktop has a motherboard and read only memory (ROM) installed.

a. Explain the function of both system unit components. 2 marks

Motherboard _____________________________________________________________

Read only memory (ROM) __________________________________________________

Some devices are connected using wires, other devices connect wirelessly to the network.

b. Explain one advantage and one disadvantage of wired transmission. 2 marks

Advantage  _____________________________________________________________

Disadvantage ____________________________________________________________

The network includes a firewall.

c. Describe the function of a firewall. State a security threat that is reduced by using a firewall. 2 marks

Firewall _________________________________________________________________

Security threat ____________________________________________________________

The network uses protocols.

d. List the protocol used on the internet. 1 mark

e. Outline the purpose of protocols on a network. 1 mark

Question 11 (2 marks)

Explain how an operating system differs from utility software.