8 You are creating a presentation on the World Games. You have created a spreadsheet showing the number of gold, silver and bronze medals awarded to different countries. You are planning to create a graph in the presentation showing the country, the number of gold medals and the total number of medals. A 12 3 4 5 6 7 8 9 10 11 12 13 B C D E F World Games Medals Country Gold 1 2 3 4 5 6 7 8 9 10 Italy United States Germany Russia France China Great Britain Japan Ukraine Spain 153 142 137 137 101 68 61 55 47 42 Silver 145 131 111 110 102 55 89 38 36 42 Bronze 142 109 138 72 105 27 210 53 125 42 Total 440 382 386 319 308 150 360 146 208 126 Original data (a) Explain how you would create a vertical bar chart, showing the name of the country, the number of gold medals and the total number of medals awarded to each country, on a new slide in the presentation. … … … … … … … … … … … … [6] (b) The total number of medals has been calculated manually and entered as a value. This could lead to errors. Explain how you could create a formula to calculate the total number of medals awarded for Italy, using only the mouse. … … … … … … … … [4] (c) Explain how the data could be sorted by the total number of medals won by each country. The country with the largest number of medals should be at the top of the list. … … … … … … … … [4]

8(a) Max four from: Open spreadsheet Load the file Select B3 to C13 Then hold CTRL and select F3 to F13 Click insert then click bar chart/graph Select the format/type of chart/graph Highlight the chart/graph Copy the bar chart/graph Max four from: Open the presentation software Add a new slide Click on new slide Paste the bar chart/graph Add titles/legend/axes labels Save the file 6 8(b) Four from: Click on the cell F4 Select formulas Click Autosum/Σ Check the correct range has been highlighted/highlight/drag C4 to E4 Click  4 8(c) Four from: Highlight B3 to F13 Click Data then Sort Select data has headers Sort by Total/Column F Select Largest to smallest/Descending/Z to A Click OK/enter 4

A headteacher is planning to produce a presentation to showcase the school’s achievements. 11 Describe two methods the headteacher could use to gather information about the requirements of the target audience. (a) 1… … 2… … [2] 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. (b) … … … … … … … … [4] 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. (c) … … … … … … … … [4]

11(a) Interview members of the target audience to see what they want from the presentation Give out questionnaires to the target audience 2 11(b) Four from: Select slide 1 Click Insert … ... Select Audio Locate the music on PC and select Click play in background Test it by running the slideshow 4 11(c) Four from: The font needs to be easy to read Larger font needed Different font Bright colours Animation used Simpler language Shorter length Transition effects More pictures than text Different music 4

12 A teacher is teaching students about history using a virtual reality (VR) system. (a) Identify three devices that could be used with a VR system. 1 … 2 … 3 … [3] (b) The teacher carefully monitors the students’ use of the VR system. She only allows them 20 minutes on the device before taking a break. This is to ensure that they remain healthy whilst using it. Identify three health problems associated with the prolonged use of VR systems. Problem 1 … … Problem 2 … … Problem 3 … … [3] (c) The teacher asks the students to create a presentation for their parents to explain to them about the history of their town. Describe the features that the students must include to make the presentation appeal to the adults. … … … … … … … … [4]

12(a) Three from: Controller wand/joystick/control buttons/microphone Tracking/force balls//trackpads//trackers Treadmill/motion platforms Pressure mats Data gloves/bodysuits Head mounted display/head mounted device/projector Headset/head mounted device/ear mounted device Goggles/VR eyeglasses Steering/gaming wheels/consoles Pedals/Paddles Cameras Motion sensors 3 12(b) Three from: Eye problems/strain Neck pain/back pain Headaches Balance problems/motion sickness Tiredness Injuries caused by being too involved in the VR system 3 12(c) Four from: A small font size A formal font type Formal content Pastel shade colours to make it easier to read Use of both upper and lower case characters to make it easier to read Use of technical/appropriate language Fewer images and more text Don’t use too much colour Use suitable/appropriate images Use plain and simple backgrounds 4

A sales representative is planning a presentation about a new product. He is considering whether to use a multimedia presentation or to give a talk and hand out leaflets. 13 Discuss the advantages and disadvantages of using a multimedia presentation rather than printed leaflets. (a) … … … … … … … … … … … … … … … … [8] The sales representative decides to create a multimedia presentation and wishes to place an image of the new product on one of the slides. Explain the steps he would need to take to do this. (b) … … … … … … … … [4] He searches his company website to find a suitable image for his multimedia presentation. Part of the markup language from the web page to load the image is shown. When the markup is run, the words ‘company logo’ are displayed and not the image. Explain why this may be the case. (c) … … … … [2]

13(a) Advantages Max five from: Allows the use of sound/animation/video/transitions to make the presentation//leaflets cannot use sound/animation/video Can be more interactive therefore can be used on a company website/interactive whiteboard Hyperlinks can be used//the users of the leaflet would have to type in the hyperlink No printing costs More accessible (speak text, etc.) People can throw away leaflets without reading them Easier to update Disadvantages Max five from: Special equipment is needed to view the presentation Power/equipment failure/corrupted software can be an issue There could be more focus on the presentation rather than the content People have to be present in the lecture room The leaflet can be read at any time Presentations cannot be written in braille 8 13(b) Four from: Open the presentation Take/photograph an image of the product Upload an image of the new product from a camera/file/the company website//export from camera Save the image Select the correct slide Create a frame on the slide Browse/search for the image Import/insert/copy and paste the image into the presentation/slide Place/drag the image in correct place Edit the image Save the presentation 4 13(c) Two from: The image is not in the current/same folder The name of the image/format/extension is incorrect The image does not exist//software does not support the file extension The image has not been uploaded 2

A teacher is planning to develop a presentation to show his younger students, aged 5 to 6. Describe the factors which need to be considered when designing the presentation for these students. 11 … … … … … … … … … … … … [6]

11 Six from: Use animation to keep their attention Use sound to keep them interested Use larger font size so the text is easier to read Use a font that is easier to read Use a font that is suitable to the age group Make the presentation colourful to keep their attention More vibrant colours used The language used needs to be simple Short sentences should be used The words used need to be short and simple More images than text is needed Slide transitions need to be used/exciting 6

Cambridge IGCSE ICT · 0417

IGCSE ICT (0417) Presentations past paper questions

Revise IGCSE ICT (0417) — Presentations with real Cambridge past-paper questions grouped by topic, each shown with its marking scheme. Working one topic at a time targets exactly the skill each question tests.

8 free questions from 2016–2021, each with its marking scheme. Open the full topical bank to filter by subtopic, paper, and year.