Organise, visualise and analyse
Unit Organise, visualise and analyse
Year level: 9-10 Topic: Data: Collect, organise and create Time: 10 hours
Data visualisation is the presentation of numerical data pictorially or graphically so that users can more easily make sense of complex data to identify patterns and trends. Usually, data visualisations allows input of new sets of data (or circumstances) so that the solution can model the effects of that changed data. When working with large amounts of data, tools are needed (for example, a spreadsheet or programming language such as Python) to manage the volume of information and get the most value from it. Databases enable data to be stored so it can be efficiently and reliably retrieved using relevant queries. When students are asked to respond to meaningful questions that they want to answer, they will be engaged when applying their understandings and developing their skills of data analysis and visualisation.
Flow of Activities
Meaningful questions
Apply understandings about, and develop skills of, data analysis and data visualisation.Working with data
Use tools to enable the students to manage large amounts of data to get the most value from it.Channels of information
Explore how data can be encoded and represented visually as channels of information.Presenting information
Consider both the appearance and functionality of information when presenting information.Activity Meaningful questions
How can a data set be used to answer my question?
Australian Curriculum Alignment
- Collecting, managing and analysing data (ACTDIP036)
- Collecting, managing and analysing data (ACTDIP037)
What's this about?
Students consider meaningful questions that they want to answer. They use these questions to apply their understandings about, and develop their skills of, data analysis and data visualisation.
When acquiring data, students consider whether the data set is representative of the entire audience. Some data sets may be biased as they are from a sample that does not fully represent all views.
Data acquired from a range of resources may include both quantitative and qualitative data. To effectively use qualitative data, techniques may need to be applied.
To undertake useful data analysis, students need to start with quality data. There are plenty of things that can go wrong with data; for example, data may be inappropriately structured or organised, may have formatting issues such as empty cells or apostrophes, may have spelling errors or may be numeric data imported in an incorrect format such as date or currency.
In acquiring data from a database, students should develop an understanding that data is stored in a way that allows it to be efficiently and reliably retrieved, and this is different to how it is presented.
Learning tasks
- Discuss some broad areas for inquiry that are of interest to students and that would require data to make evidence-based claims. These may be able to be integrated into a classroom context for example in English, science or geography.
- Some areas of interest:
- Social conscience (eg homelessness): Who is affected? Do we have people in our area who are homeless? What can be done to help?
- Entertainment (eg books, music or movies): What genre of music creates the most money annually and has this changed over time? Choose a favourite novel and determine which characters within the story interact the most. In the ‘Star Wars’ series of movies, who are the villains and who are the heroes; who is related and who isn’t?
- Health: What are the top ten health risks for Australians? Do certain environmental conditions trigger asthma? What factors affect life expectancy?
- Environment: What data supports climate change theory? How has the climate changed over time? What habitat is most vulnerable and which species are likely to be impacted?
- Sports: How fit does an athlete need to be to play a particular sport? Are athletes who warm up before physical activity less likely to be injured?
- Locate data sets that can be used to answer questions of interest. Data sets can be found on the internet or data can be collated from an online survey; for example, using an online survey tool such as Survey Monkey or Google Forms.
- Although not a requirement at this level, students could use a structured query language to retrieve specific data from a structured database, and compare this to ad hoc queries and search engine queries. Students could identify the advantages of different forms of queries.
- Often data needs to be cleaned up to make it useful for analysis and visualisation. Provide guidance to students on how to make sure data is in a useable form; for example, in a spreadsheet such as XLS and CSV.
Supporting Resources




Assessment
Take account of privacy and security requirements when selecting and validating data.
Suggested approaches may include
- Identification of sources of data
- List of validation techniques to enhance the reasonableness of the data to be manipulated
- Examples of a coding system for qualitative data
Activity Working with data
What are some ways to organise, analyse and visualise data in a spreadsheet?
Australian Curriculum Alignment
- Collecting, managing and analysing data (ACTDIP036)
- Collecting, managing and analysing data (ACTDIP037)
What's this about?
When working with large amounts of data, tools enable the user to manage the bulk of information to get the most value from it.
Spreadsheets enable you to sort and filter data insert subtotals into sorted lists, use simple formula and visualise data.
More complex data sets may require the use of pivot tables to make it easier to analyse all of the information in your worksheet. Pivot tables help make your worksheets more manageable by summarising your data and allowing you to manipulate it in different ways.
When using large data sets, it is possible to use a programming language such as Python to read and write the data enabling analysis. To do this, data should be in CSV format, which is like Excel standard spreadsheet format, presented in plain text.
Learning tasks
- Revise various ways students can use a spreadsheet to make sense of data sets.
- Model, or use students with expertise in this skill or provide online tutorials so that all students explore how to create a pivot table.
- Once you've created a pivot table, you can use it to answer different questions by rearranging, or pivoting, the data.
- Model ways to use a pivot table or provide suitable video tutorials (some are available on YouTube).
- Creating a dashboard as part of your workbook can be used to summarise the data and present related data visually.
- Remind students that correlation does not necessarily equal causation. Spend time looking at charts where data correlates but does not have a causal link.
- Provide online tutorials or model as a lesson how to use spreadsheet software such as Excel to create a heat map by assigning a colour to numerical data and using conditional formatting.
- As a further challenge, students may incorporate data within programming; for example, using Python programming language to run a series of commands to interrogate a data set imported as a CSV.
Supporting Resources






Lesson Ideas


Assessment
Take account of privacy and security requirements when selecting and validating data.
Suggested approaches may include
- Presentation or demonstration
Activity Channels of information
How does data visualisation help us identify patterns in a data set?
Australian Curriculum Alignment
- Collecting, managing and analysing data (ACTDIP037)
What's this about?
Data can be encoded and represented visually as channels of information. These visual channels include spatial position, colour, size, shape, orientation and direction of motion. Multiple visual channels can be used to simultaneously represent data.
Heat maps are a way of visualising numerical data represented as colour. Interactive data visualisations help further to model processes and examine relationships.
Learning tasks
- After a brief discussion about data visualisations and what they are, provide students with a set time to use the internet to locate a visualisation that appeals to them. Share as a class and ask generic questions such as:
- What information does the visualisation convey?
- What is done well; what is misleading?
- What channels of information are used; for example, size, colour, position etc?
- Examine a numeric data set shown in a table compared with an analysis based on colour; for example, numerical data such as temperatures, moisture levels and ocean depth.
- Many other types of numerical data can be effectively used; for example, retail data and population data – in fact, any data that is within a range where colour can be used to represent the values in that range. Let students explore a data set of interest and report back their findings.
- Provide access to relevant tools that enable users to visualise data on a map; the data set will need to contain location data such as latitude and longitude, countries/regions, states, counties or postal codes.
- Analyse population data made up of structured data categorised as, for example, income ($), life expectancy (years), population (millions of people), country (name), age (years) etc. Examine the relationships using visualisation tools such as those provided by Gap Minder.
Supporting Resources








Assessment
Take account of privacy and security requirements when selecting and validating data.Evaluate information risk, sustainability and potential for innovation and enterprise.
Suggested approaches may include
- Artefact analysis
Activity Presenting information
How can I present data effectively as information?
Australian Curriculum Alignment
- Collecting, managing and analysing data (ACTDIP036)
- Collecting, managing and analysing data (ACTDIP037)
- Investigating and defining (ACTDIP038)
What's this about?
Both the appearance and functionality of information contribute to its quality. Appearance relates to the aesthetics of information and it usually draws on design principles, such as alignment, repetition, contrast, space and balance. Alignment connects elements visually through an invisible line. Contrast shows differences between elements. Repetition involves re-using the same or similar elements for consistency. Space relates to the distance between elements. Balance relates to the weighting given to different elements.
Functionality also contributes to the effectiveness of information. Characteristics of functionality include the useability of a solution such as its flexibility and ease of use, and accessibility such as its ease of navigation.
The quality of information is also enhanced if conventions (or normally accepted procedures) are applied such as a chart having a legend, heading and labelled axes. Similarly, the use of colour should promote contrast but also consider users who are colour blind.
Learning tasks
- After analysing the data students can create their own infographic to present their ideas visually.
- Students create a structured database of something of interest; for example, games, sporting teams, digital photographs, music, etc.
- Students implement methods of validating data as it is entered, using data types, range and constraints, codes and cross-referencing. Students implement various checks from the wide range available and compare their effectiveness in reducing data errors.
Supporting Resources







Assessment
Take account of privacy and security requirements when selecting and validating data.Define and decompose complex problems in terms of functional and non-functional requirements.
Suggested approaches may include
- Presentation or demonstration
- Artefact analysis