16.1. Graph and chart creation
A subsection of Information and Communication Technology, 0417, through 16. Graphs and charts
Listing 4 of 4 questions
Below is a spreadsheet showing the countries which have hosted the Commonwealth Games. Canada England Australia New Zealand Canada Wales Australia Jamaica Scotland New Zealand Canada Australia Scotland New Zealand Canada Malaysia England Australia India Scotland Canada England Australia New Zealand Wales Jamaica Scotland Malaysia India Venues for the Commonwealth Games A B C D E F G H I Canada England Australia Wales Jamaica Scotland Malaysia India New Zealand Write down suitable titles for: The category axis The value axis The chart What is this type of chart called? 1 17
0417_s16_qp_11
THEORY
2016
Paper 1, Variant 1
View
A school is voting to see if they should change the timings of the school day or not. You have been asked by the head teacher to present the data from a number of opinion polls in the form of a graph. The data shows the changes in people’s opinions over time. The data is stored in a spreadsheet. Part of the spreadsheet is shown. 01/10/2018 03/10/2018 06/10/2018 08/10/2018 09/10/2018 11/10/2018 14/10/2018 16/10/2018 18/10/2018 20/10/2018 A B C D Against For Don’t know Opinion Poll E F G Name the most appropriate type of graph or chart that would be used to present the data. The head teacher wishes the data to be presented as a graph to be shown at a public meeting. He requires a legend to be included in the graph. Describe how you would produce the graph or chart of the data including the legend.
0417_w18_qp_13
THEORY
2018
Paper 1, Variant 3
View
A student is creating a database for her geography project to show all the earthquakes that occurred in 2019. She has produced part of the database which is shown. Country Magnitude DepthVanuatu Vanuatu Indonesia Vanuatu Nepal Myanmar Japan Japan Vanuatu Japan Ecuador South Georgia Ecuador Ecuador Mexico Mexico Vanuatu 6.9 6.7 6.1 6.7 4.1 6.9 6.2 6.4 7.8 6.2 6.2 27.6 10.2 20.6 When she has completed her database, she needs to carry out some searches on the data. To search for all the earthquakes with a depth of more than 20 km she will need to type the following search criteria. Depth>20 Write the search criteria to find all the earthquakes of a magnitude greater than or equal to 6.5, with a depth less than 15 km. Give the name of the country that satisfies the search criteria in part . The student has transferred the data into a spreadsheet in order to create a graph. A B C D E F G World Earthquakes - 2019 Country Magnitude Depth16 Vanuatu Vanuatu Indonesia Vanuatu Nepal Myanmar Japan Japan Vanuatu Indonesia Nepal Myanmar Japan Ecuador South Georgia Mexico Vanuatu Japan Ecuador South Georgia Ecuador Ecuador Mexico Mexico Vanuatu 6.9 6.7 6.1 6.7 4.1 6.9 6.2 6.4 7.8 6.2 6.2 27.6 10.2 20.6 She has entered a formula in cell G3. The formula is COUNTIF(A$3:A$19,F3) Explain in detail what the formula in G3 does. Include in your answer an explanation of the use of the $ sign. The student is creating an appropriate chart/graph of the data in cells F3 to G10. Write down the steps she needs to take to produce a chart/graph of the data on the same sheet. Your answer must include examples of an appropriate title and labels.
0417_w20_qp_11
THEORY
2020
Paper 1, Variant 1
View
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 B C D E F World Games Medals Country Gold Italy United States Germany Russia France China Great Britain Japan Ukraine Spain Silver Bronze Total Original data 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. 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. 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.
0417_w21_qp_12
THEORY
2021
Paper 1, Variant 2
View
Questions Discovered
4