代做MUF0051 INFORMATION & COMMUNICATION TECHNOLOGY调试SPSS

2024.05.10 - 首页 >> Web

MUF0051 INFORMATION & COMMUNICATION TECHNOLOGY

Section A: Multiple Choice Questions (15 marks)

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)Page 3 of 21

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 requirementsPage 5 of 21

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.Page 6 of 21

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)Page 7 of 21

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. 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.

________________________________________________________________________