Information, Media and Telecommunications - DATA ANALYST

Let's Analyse: How Jobs are Represented

Primary

Australian Curriculum General Capability: Critical and creative thinking

Australian Curriculum General Capability: Numeracy

Australian Curriculum General Capability: Ethical Understanding

Australian Curriculum General Capability: Personal and social capability

Philosophy

Cooperative Learning Activity

Teacher

Resources:  "Let's Analyse" - Word Doc (7 pages)
  
Process

1. You are to download the following Word doc (7 pages) "Let's Analyse" and upload to your system for students to access and fill in. Initially, the activity is for individuals, then they are to form groups of 3 - 4 students for the second part.

2. You are to play the following video (3.08 mins) - at the beginning of the Checking the answers section of the word document.

Jobs Song | What Do You Want To Be? 2016
https://youtu.be/MdvTlQzsaYI

Students

1. You are to match the correct cartoon image to the correct name of that cartoon image.

2. Your teacher will play the video so you can check your answers.

3. You are then to explore the number of males vs females shown; the number of old vs young and discuss as a class your thinking.

4. You are to graph the numbers shown.

5. Re-draw one of the jobs represented as either: Female, Indigenous, Muslim or Asian.

6. Let's look at the Gamer.

As a class, read the article from The Conversation July 2016

7. Discuss the content of the article.

8. In your group, select ONE category from On the Job: these categories are under the Info Desk.

https://www.onthejob.education/info

Click on a category and it will take you to a list of all jobs within this category.

9. In a Word doc, fill out the table - M/F; Ethnicity; Non-traditional representation of M/F in this job.

10. Looking at the numbers, analyse the results! Compare with ABS figures.

11. Look at Life on the Job in your category. Analyse the M/F balance.

12.

Class discussion: Are the stereotypes broken in On the Job website? Why? Why not?

Stage 4: Data Analysis & Evaluation  (developed by NSW Dept of Education)

Middle 

Australian Curriculum General Capability: Critical and creative thinking
Australian Curriculum General Capability: Numeracy

Teacher

Local Copy (Word doc - 7 pages)

Strategy

Students can:

• find measures of location (mean, mode and median) for small sets of data

• use measures of location and range to analyse data that is displayed in a frequency table, stem and leaf plot or dot plot

• use spreadsheets to tabulate and graph data.

There are two activities for students to complete:

Activity 1: Using mean, median, mode and range from data about Year 8's texting.
   
Activity 2: Collecting temperature data over a month and comparing with BOM.

(Source: Physicians Practice)

A variant of this activity can be found at the Social Media Manager

Students survey the number of TicToks or Instagram they have watched during the week.

Big Data, What are you saying? (developed by Teach Engineering)

 Secondary

Australian Curriculum General Capability: Critical and creative thinking
Australian Curriculum General Capability: Numeracy

Cooperative Learning Activity

Teacher

Overview

"Students act as R&D entrepreneurs, learning ways to research variables affecting the market of their proposed (hypothetical) products. They learn how to obtain numeric data using a variety of Internet tools and resources, sort and analyze the data using Excel and other software, and discover patterns and relationships that influence and guide decisions related to launching their products. First, student pairs research and collect pertinent consumer data, importing the data into spreadsheets. Then they clean, organize, chart and analyze the data to inform their product production and marketing plans. They calculate related statistics and gain proficiency in obtaining and finding relationships between variables, which is important in the work of engineers as well as for general technical literacy and decision-making. They summarize their work by suggesting product launch strategies and reporting their findings and conclusions in class presentations." (Source: Teach Engineering)

Learning Objectives

After this activity, students should be able to:

• Use software tools to locate and import data into Excel.

• Organize and filter data to compare related factors.

• Generate graphs and statistics for analysis.

• Determine factors and influences on variables.

• Use data analysis to form and support conclusions.

• Think and argue critically about decisions and reflect on their advantages and shortcomings.
  (Source: Teach Engineering)

Pre-Req Knowledge
  
A familiarity with measures of center (mean, median and mode), measures of spread (range, variance and standard deviation) and other measures (mean absolute deviation), correlation and linear regression (at least a notion of its use; calculation comes later).
Basic ability to use Internet browsers and navigate menus on personal computers.

Materials List
  
Each group (student pair) needs:

• computer with reasonably fast Internet access
• Microsoft® Excel® spreadsheet software; or Google account to use Sheets
• Knoema Data Finder, a free app that queries data from web searches and imports it into Excel or Google Sheets
• extraction software, such as free 7 Zip [Open Source] or other software to extract data from compressed/zip files
• (optional) subscription to Wolfram Alpha Pro; $5/month, $3/month for students; to download data from queries
• (optional) Wolfram Mathematica, student edition; to graph and manipulate data; student group price is ~$90/computer
• Big Data Presentation Rubric [Local Copy - PDF one page], one per group (or one to post in the classroom)
• Student Tips to Finding Data Handout [Local Copy] one per group
• (optional) Student Self-Guided Worksheet to Working with Data in Excel [Local Copy 5 pages], alternative independent worksheet for students well-versed in Excel
• (optional) Microsoft® PowerPoint®, for making presentations
  
  For the entire class to share:
• capability to show the class websites, infographics, datasets and online videos