0417_s20_qp_12
A paper of Information and Communication Technology, 0417
Questions:
14
Year:
2020
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
The 2020 Olympic Games committee is producing a database to show the medal winners in the cycling events. It is important that the correct data type is used in each of the fields. Tick (✓) the most appropriate data type for each of the following fields. Text (✓) Numeric (✓) Boolean (✓) Athlete_name Gold_medal (Y/N) Age Name_of_country 1 15 A report has been produced that shows the male gold medal winners from the past three Olympic Games. Write down six of the formatting features that have been used in the report. [Turn over 1 15
18. Databases  →  18.1. Create a database structure
20. Spreadsheets  →  20.3. Present data
Open
3
Complete the following sentences using the most appropriate network term. A communication method that wirelessly connects a mobile phone to a car, to allow hands-free use of the mobile phone is . A network device that allows a stand-alone computer, using a dial-up analogue connection, to connect to an ISP is a . A network device that allows a LAN to connect to the internet is a . A wireless communication method used in WLAN is .
4. Networks and the effects of using them  →  4.1. Networks
6. ICT applications  →  6.1. Communication
Open
4
A teacher is creating a spreadsheet that will record the grades students achieved in recent tests and compare the average grades of these tests with the students’ forecast grades. The grading the teacher is using awards 1 for the highest grade down to 10 for the lowest. The teacher has created a validation rule on the grade entered. Give examples of data used to test the validation rule. Your answers for abnormal test data must be for a different reason in each case. Example of test data Type of test data Normal Abnormal Abnormal Extreme [Turn over 1 15 Part of the spreadsheet is shown, column G subtracts the Forecast grade from the Average grade. Describe the steps the teacher can take to edit the spreadsheet to prevent new data being typed into the Forecast grade column. The teacher has typed a formula in cell E3. The formula is ROUNDUP(AVERAGE(B3:D3),0) Explain, in detail, what the formula does. 1 15 The teacher has produced a graph showing the differences between the forecast grade and the average grade for each student. The graph looks like this. Describe the steps taken to create the graph. Include in your answer three improvements that could be made to the graph. Method Improvement 1 Improvement 2 Improvement 3 [Turn over 1 15
20. Spreadsheets  →  20.1. Create a data model
7. The systems life cycle  →  7.3. Development and testing
Open
7
Complete each sentence using the most appropriate output device from the following list. Heater Dot matrix printer Buzzer 3D printer Wide format printer Light LCD monitor Laser printer The device that can produce prosthetic limbs is called a The device that can output soft copy is called a The device that can produce sound as its main output is called a [Turn over 1 15
2. Input and output devices  →  2.3. Output devices and their uses
1. Types and components of computer systems  →  1.2. The main components of computer systems
Open
11
A headteacher is planning to produce a presentation to showcase the school’s achievements. Describe two methods the headteacher could use to gather information about the requirements of the target audience. The presentation is to be shown on large monitors at the entrance to the school. The school is planning to embed music into the presentation so that music could be played as the presentation is shown. Describe the steps the headteacher would need to take to play music in the background of the slides. 1 15 After showing the presentation to the parents the headteacher wishes to use the presentation to show to young children to encourage them to come to the school. Describe the features that the headteacher must include to make the presentation meet the needs of an audience of young children.
9. Audience  →  9.1. Audience appreciation
19. Presentations  →  19.1. Presentation creation
Open