Nelson Information Technology VCE Units 1 & 2
Apply your knowledge answers
Chapter 1: From data to information
The worlds population
1
A chart that shows Australias population growth from 1990 to 2020.
Students select the first row of data that indicates the year and the third row of
data that shows the population figures for Australia. Students choose an
appropriate chart type (such as a line graph) and produce and format the chart.
Example chart below:
Australia's Population Growth
25
20
Population 15
millions
10
5
0
1990
2007
2020
Year
A chart that shows the estimated populations of the 20 countries in 2020.
Students select the first and last columns of data. Students choose an appropriate
chart type (such as a column graph) and produce and format the chart. Example
chart below:
Estimated populations 2020
Information Technology VCE Units 1 & 2, 5th edition 9780170187466
Cengage Learning Australia 2011
1
New Zealand
Liechtenstein
Italy
Belgium
Denmark
Spain
Austria
United States
Finland
Luxembourg
Japan
Switzerland
France
Sweden
Netherlands
Ireland
Canada
Iceland
Australia
Norway
400
350
300
250
Population
200
millions
150
100
50
0
A chart that depicts each countrys population as a percentage of the total
population of these 20 countries in 2020.
Students must sum the population figures for the column 2020. Using this,
students should enter a formula to calculate the percentage of each countrys
population. Students should then select the first column of data and the
percentage column and choose an appropriate chart type (such as a pie graph) and
represent this data. The pie graph should be appropriately formatted. Example
chart below:
Population percentage of world's top 20
countries
1.40
0.71
1.08
0.00
0.60
7.69
0.66 3.02
0.05
4.72
Norway
0.65
2.18
1.23
Australia
Iceland
6.18
Canada
8.26
1.01
Ireland
Netherlands
Sweden
15.74
France
Switzerland
44.06
0.06
0.70
Japan
Luxembourg
Finland
Fixed telephone lines use
1
Go to the UN data website at [Link] and find the Information and
Communication Technology database. Select to view the data on Main (fixed)
telephone lines per 100 inhabitants.
Access the appropriate data on the website.
Filter the data to show number of users with fixed telephone lines in Australia
from 2000 to 2008.1
After filtering the UN data, students should have a data table with the years 2000
to 2008 and number of fixed telephone lines per 100 inhabitants.
Copy and paste this data into a spreadsheet program.
Please note that the textbook incorrectly instructs students to filter data to show the estimated Internet users in
Australia, which is a different link to the Main (fixed) telephone lines per 100 inhabitants.
Information Technology VCE Units 1 & 2, 5th edition 9780170187466
Cengage Learning Australia 2011
2
4 Create a column chart, a scatter diagram and a bubble chart that depict these
statistics.
Students should select all of the data in the table and produce a column chart,
scatter diagram and a bubble chart. Example column chart, scatter diagram and
bubble chart below:
Lines per 100 inhabitants
54
52
50
48
46
44
42
40
2008
2007
2006
2005
2004
2003
2002
2001
2000
54
53
52
51
50
49
48
47
46
45
44
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2008
2006
2004
2002
2000
1998
42
44
46
48
Information Technology VCE Units 1 & 2, 5th edition 9780170187466
Cengage Learning Australia 2011
3
50
52
54
56