Data Representation & Analysis

Detailed Term Planner for Primary

Lower Primary (PP, Y1 & Y2)

Data Representation

• The Patterns Practice Song https://youtu.be/MBjjxSx45-Q 

• Sesame Street - Guess what's next https://youtu.be/pO9b7BTOIOU 

• http://www.beyondthehourofcode.com/2016/02/07/off-line-programming-and-dance/ 

• Kidz Bop Shuffle https://youtu.be/QfzRP6V5rE4?t=1m48s 

• Sequence - What comes next? http://www.math-only-math.com/sequence.html 

• Patterns Worksheet - https://www.teacherspayteachers.com/Product/Data-Reperesentation-Patterns-10128372 (CUSTOM BY MRS CHOM)

• Following Directions - https://www.youtube.com/watch?v=Qr9ge4XGUYs

• How is data stored on a computer? http://www.bbc.co.uk/guides/z82v34j

• How do you save your work? http://www.bbc.co.uk/guides/zgtgr82 

• How can you write a story on a computer? http://www.bbc.co.uk/guides/z2s49j6 

• How do you make video on a computer? http://www.bbc.co.uk/guides/z2cmxnb 

• How do you make art on a computer? http://www.bbc.co.uk/guides/zy2v34j 

Data Collection

• Kindy tech graph - https://www.teacherspayteachers.com/Product/Digital-Media-Literacy-1247295 usage notes here: http://larremoreteachertips.blogspot.com/2014/05/digital-media-literacy.html 

• Eye Colour Survey - https://www.twinkl.co.uk/resource/t-t-2075-eye-colour-survey-pictogram 

• All about Me Data Collection Sheet https://www.teacherspayteachers.com/Product/Data-Collection-All-About-Me-10117895 (CUSTOM BY MRS CHOM )

• Easy Pictographs and Graphs for PP & Y1 - https://www.j2e.com/j2data/ 

• Graph Templates - https://www.twinkl.co.uk/resource/t2-m-222-tally-and-graph-worksheet-template 

• Data Detective - https://www.digitaltechnologieshub.edu.au/teachers/lesson-ideas/data-detective

Data Analysis

• Matching charts to data - https://www.teachstarter.com/teaching-resource/data-match-game-cards-set-1/  (Y2/3 as hard for Y1 to read)

Middle Primary (Y3 & Y4)

Data Representation

• Using Emojis to communicate - https://unicode.org/emoji/charts-12.0/emoji-released.html   

• PigPen Cipher worksheet - https://www.teacherspayteachers.com/Product/Data-Representation-PigPen-Cipher-10117913 (CUSTOM BY MRS CHOM)

• Caesar Cipher worksheet - https://www.teacherspayteachers.com/Product/Data-Representation-Caesar-Shift-Cipher-10117911- (CUSTOM BY MRS CHOM)

• Decoding days in Braille - http://www.jumpstart.com/common/decoding-days-view 

• Cracking Codes - https://designedbyteachers.com.au/who-ate-all-the-pavlova-crack-the-codes/ 

Data Collection & Analysis

• Information Fluency - https://globaldigitalcitizen.org/21st-century-fluencies/information-fluency/

• Choosing the Appropriate Graph - https://www.teacherspayteachers.com/Product/FREEBIE-Choosing-the-Appropriate-Graph-273458?aref=z6aaqtm0 

• Analysing Text Data - http://www.abcya.com/word_clouds.htm

• What is digital data? - http://www.bbc.co.uk/guides/zx3q7ty 

• Creating and understanding charts - http://www.bbc.co.uk/guides/z83wjxs 

• Rubbish Recording and Presenting -  https://www.digitaltechnologieshub.edu.au/teachers/lesson-ideas/rubbish-recording-and-reduction-part-1 

• Assessment Quiz - Graphs and Data - https://quizizz.com/admin/quiz/5951f58fa8c68717007b42fa 

Upper Primary (Y5 & Y6)

Data Representation

• Using Emojis to communicate - https://unicode.org/emoji/charts-12.0/emoji-released.html 

• Information Fluency - https://globaldigitalcitizen.org/21st-century-fluencies/information-fluency/

• Braille, Numbers, Text, and Images/Colours -  http://www.csfieldguide.org.nz/en/teacher/chapters/data-representation.html

• What is digital data? - http://www.bbc.co.uk/guides/zx3q7ty 

• How do digital images work? - http://www.bbc.co.uk/guides/z2tgr82 

• Icon Draw History of the Icon - http://www.cs4fn.org/hci/susankare-icondraw.php

• What are Pixels (from Code.org) - https://youtu.be/15aqFQQVBWU

• Creating pictures - https://www.digitaltechnologieshub.edu.au/teachers/lesson-ideas/using-binary-to-create-on-off-pictures 

• Pixel Viewer - http://www.csfieldguide.org.nz/en/interactives/pixel-viewer/index.html

• History of codes -  https://www.teachstarter.com/teaching-resource/comprehension-history-codes/ 

• What are coding systems -  https://www.teachstarter.com/teaching-resource/comprehension-coding-systems/ 

• Data Rep: Infographics - https://www.facebook.com/triplej/photos/a.147721015159/10163286567310160/?type=1&theater 

Data Collection & Analysis

• Choosing the right kind of graph - https://infogram.com/page/choose-the-right-chart-data-visualization 

• Graphs (SCSA) - http://k10outline.scsa.wa.edu.au/home/assessment/judgingstandards/judging-standards-choose-a-year/year-6#326694 

• Creating and understanding charts - http://www.bbc.co.uk/guides/z83wjxs 

• Twinkl Spreadsheets Unit - http://www.twinkl.co.uk/resource/tp2-i-041-new-planit-computing-year-6-spreadsheets-unit-pack 

• Is it going to rain today? https://www.digitaltechnologieshub.edu.au/teachers/lesson-ideas/is-it-going-to-rain-today 

• Choose Your Own Statistics http://abcspla.sh/m/1520313 

• Data Selfie - https://www.lifehacker.com.au/2017/02/data-selfie-analyses-your-facebook-usage-to-show-what-companies-can-learn-about-you/ 

• ACTIVITY: M&Ms Data Collection & Spreadsheet - https://www.teacherspayteachers.com/Product/Microsoft-Excel-Spreadsheet-and-Graph-Skills-MMs-Scenario-1227713 

Year 7 & 8

Data Representation

• Data Rep: Text, images and sound - https://www.bbc.co.uk/bitesize/guides/zpfdwmn/revision/1 

• Data Rep: Everything - https://csfieldguide.org.nz/en/chapters/data-representation/ 

• Data Rep: Data is Beautiful animated graphs - https://www.youtube.com/channel/UCkWbqlDAyJh2n8DN5X6NZyg/videos 

• Types of Data: ASCII & Unicode - https://www.teach-ict.com/gcse_new/data_info_knowledge/data_info_know/home_data_info_know.htm

• New Unicode Emoji released - https://unicode.org/emoji/charts-12.0/emoji-released.html

• Types of Data: Bit mapped graphics - https://www.bbc.co.uk/bitesize/guides/zscvxfr/revision/5 

• Types of Data: Representing Colour - https://www.w3schools.com/colors/colors_picker.asp 

• Separation of Content/Data and Presentation: Notepad vs Word, or HTML vs CSS - http://w3programmers.com/bangla/wp-content/uploads/2018/12/HTML-VS-CSS.jpg 

• ACTIVITY: Text, Binary, Images, Audio, Emoji - https://groklearning.com/course/aca-dt-py-functions-data-rep/ 

Binary

• https://www.teachstarter.com/teaching-resource/binary-coding-cards/ 

• https://www.teachstarter.com/teaching-resource/binary-codes-20-worksheet/ 

• https://www.teachstarter.com/teaching-resource/binary-codes-20-without-guide-dots-worksheet/ (for smarter kids)

• Ted-Ed How exactly does binary code work? (video) https://youtu.be/wgbV6DLVezo 

• Introduction to Binary - https://www.digitaltechnologieshub.edu.au/teachers/lesson-ideas/introduction-to-binary 

• Binary to Decimal Worksheet - https://drive.google.com/open?id=1iw7ImkdbHxhusIKn5sfTmisJu0U4gr73 

• Decimal to Binary Worksheet - https://drive.google.com/open?id=1Ilc8ILFRYHY-9J6nI7vsK-lbiWZVjTEm (CUSTOM BY MRS CHOM)

• Binary Game - http://www.mrgober.com/games/game.php?id=273 

Data Collection & Sorting

• VIDEO: Sorting algorithms in a Library - https://www.youtube.com/watch?v=WaNLJf8xzC4 

• Sorting algorithm animations - https://www.toptal.com/developers/sorting-algorithms 

• VIDEO: Various sorting algorithms - https://www.youtube.com/watch?list=PLZh3kxyHrVp_AcOanN_jpuQbcMVdXbqei&v=8oJS1BMKE64  

• Data Representation: Classify & Sort - https://aca.edu.au/resources/decision-trees-classifying-animals/ 

• Data Australis (SCSA) - https://k10outline.scsa.wa.edu.au/home/year-7-to-year-10/technologies/documents/Technologies-Digital-Technologies-Year-8-Teaching-Learning-and-Assessment-Exemplar_Data-Australis.pdf 

Year 9 & 10

Transmission of data (Year 9)

• 2.5D Animation (SCSA) - https://k10outline.scsa.wa.edu.au/home/year-7-to-year-10/technologies/documents/Technologies-Digital-Technologies-Year-10-Teaching-Learning-and-Assesment-Exemplar-25D-animation.pdf 

• Sending emails - https://www.howtogeek.com/56002/htg-explains-how-does-email-work/

• Sending emails - https://www.howtogeek.com/171328/how-to-send-large-files-over-email/

• Convert audio - http://online-audio-converter.com/ 

Compression of data (Year 10)

• Code.org Compression Widget https://studio.code.org/s/text-compression/stage/1/puzzle/2 

• Lossy v Lossless - https://csfieldguide.org.nz/en/chapters/coding-compression/lossy-vs-lossless/

• Compression - http://www.teach-ict.com/2016/A_Level_Computing/OCR_H446/1_3_exchanging_data/134_compression/miniweb/pg3.php 

• Text Compression (CS Unplugged) - https://classic.csunplugged.org/text-compression/ 

• CS Field Guide - https://csfieldguide.org.nz/en/chapters/coding-compression/whats-the-big-picture/ 

• Data Compression (Khan) https://www.khanacademy.org/computing/computers-and-internet/xcae6f4a7ff015e7d:digital-information#xcae6f4a7ff015e7d:data-compression 

• Daft Hands - Using compression to communicate - Harder, Better, Faster, Stronger https://youtu.be/K2cYWfq--Nw 

Acquiring Data (Collection)

• Data, Info & Knowledge - https://www.teach-ict.com/gcse_new/data_info_knowledge/data_info_know/miniweb/index.htm 

• Data Types - https://www.teach-ict.com/gcse_new/data_info_knowledge/data_types/miniweb/index.htm 

• Qiality of Info - https://www.teach-ict.com/gcse_new/data_info_knowledge/quality/miniweb/index.htm 

• Coding of Data - https://www.teach-ict.com/gcse_new/data_info_knowledge/coding/miniweb/index.htm 

• Data Capture - https://www.teach-ict.com/gcse_new/databases/data_capture/home_data_capture.htm

• User Data Tracking - https://www.khanacademy.org/computing/computers-and-internet/xcae6f4a7ff015e7d:online-data-security/xcae6f4a7ff015e7d:user-data-tracking/a/web-cookies 

• Data Driven Innovation (DT Hub) - https://www.digitaltechnologieshub.edu.au/plan-and-prepare/scope-and-sequence-f-10/9-10-data-driven-innovation/ 

• Data and Medicine - https://youtu.be/bMrDHtGHFR4 

Data Storage and Organisation Techniques

• Organise, Visualise, Analyse (DT Hub) - https://www.digitaltechnologieshub.edu.au/plan-and-prepare/scope-and-sequence-f-10/9-10-organise-visualise-and-analyse/ 

• Spreadsheets - https://www.teach-ict.com/gcse_new/spreadsheets/spreadsheets/home_spreadsheets.htm 

• Formulas & Functions - https://www.teach-ict.com/gcse_new/spreadsheets/formula_function/home_formula_functions.htm 

• Charting - https://www.teach-ict.com/gcse_new/spreadsheets/charting/home_charting.htm

• Database Uses - https://www.teach-ict.com/gcse_new/databases/uses_of_databases/home_uses_databases.htm 

• Database terminology - https://www.teach-ict.com/gcse_new/databases/terminology/miniweb/index.htm 

• Flat File & Relational DBs - https://www.teach-ict.com/gcse_new/databases/flatfile_relational/home_flatfile_relational.htm 

• Welcome to SQL (Khan) - https://www.khanacademy.org/computing/hour-of-code/hour-of-code-lessons/hour-of-sql/v/welcome-to-sql 

• Intro to Databases (SQL) - https://groklearning.com/course/intro-sql-1/outline/ 

Year 10

• Modelling and simulation - https://www.teach-ict.com/gcse_new/spreadsheets/modelling_simulation/home_modelling_simulation.htm 

• Data Modeling - https://www.ibm.com/topics/data-modeling 

• SQLite Download - https://www.sqlite.org/index.html 

• DB Browser for SQLite - https://sqlitebrowser.org/ 

• SQLite tutorial - https://www.tutorialspoint.com/sqlite/index.htm 

• SQL Murder Mystery - https://mystery.knightlab.com/ 

Validating quantitative and qualitative data

• Validation & Verification - https://www.teach-ict.com/gcse_new/databases/validation_verification/miniweb/index.htm 

• Fitness for Purpose - https://www.teach-ict.com/gcse_new/data_info_knowledge/fitness/miniweb/index.htm 

• Data Validation - https://www.safe.com/what-is/data-validation/ 

• Quant v Qual Data - https://careerfoundry.com/en/blog/data-analytics/difference-between-quantitative-and-qualitative-data/ 

Analyse and visualise data

• Code.org Data Unit - https://studio.code.org/s/csp9-2022 

• Data Analysis (Khan) - https://www.khanacademy.org/computing/ap-computer-science-principles/data-analysis-101 

Big Data & Security

• Online Data Security - https://www.khanacademy.org/computing/computers-and-internet/xcae6f4a7ff015e7d:online-data-security 

• The Big Data Dilemma - https://www.commonsense.org/education/digital-citizenship/lesson/the-big-data-dilemma 

• Risk Check for New Tech - https://www.commonsense.org/education/digital-citizenship/lesson/risk-check-for-new-tech 

• Debating the Privacy Line - https://www.commonsense.org/education/digital-citizenship/lesson/debating-the-privacy-line 

• Video - What is Big Data and how does it work? 

• Video - What is big data? 

• Video - Beat The News Animation 

• Video - Apostle Animation 

• Video - Kenneth Cukier: Big data is better data

Separating Content Data from Presentation Data (Y10)

• HTML Starter - https://grokacademy.org/course/intro-html-css-starter/ 

• W3 Schools HTML - https://www.w3schools.com/html/default.asp

• W3 Schools Try It HTML Editor - https://www.w3schools.com/html/tryit.asp?filename=tryhtml_default 

• HTML Basics (Khan) - https://www.khanacademy.org/computing/computer-programming/html-css/intro-to-html/pt/html-basics