{"id":28181,"date":"2024-10-17T19:17:10","date_gmt":"2024-10-17T19:17:10","guid":{"rendered":"https:\/\/www.orbeducation.com\/au\/?post_type=product&p=28181"},"modified":"2025-03-10T14:31:17","modified_gmt":"2025-03-10T14:31:17","slug":"spreadsheets-and-data-visualisation-2024-yrs-7-8","status":"publish","type":"product","link":"https:\/\/www.orbeducation.com\/au\/product\/spreadsheets-and-data-visualisation-2024-yrs-7-8\/","title":{"rendered":"Spreadsheets and Data Visualisation 2024 (Yrs 7-8)"},"content":{"rendered":"

Curriculum Information<\/strong><\/h3>\n

0. Cover, Checklist<\/strong><\/p>\n

1. Wordlist<\/strong><\/p>\n

2. Introducing Spreadsheets<\/strong>
\nAC V9.0 (7-8): Acquire, interpret and model with spreadsheets and represent data with integers and binary.
\nNSW Comp Tech (2024) – CT-Data \/ CT-Net: \u00a4 acquires, represents, analyses and visualises simple and structured data<\/p>\n

3. Basic Excel Skills<\/strong><\/p>\n

4. Google sheets<\/strong><\/p>\n

5. Sorting & Filtering<\/strong>
\nAC V9.0 (7-8): – using a spreadsheet table to model objects and events, including choosing appropriate formats for each column, and filtering and sorting rows to answer questions
\nNSW DT(Tech Mand): \u2013 filtering or sorting to answer a specific question
\nNSW Comp Tech (2024) – CT-Data: \u00a4 Filter, group and sort data using a spreadsheet, including using filters and sorting, using conditional formatting and grouping and aggregating data: <\/p>\n

6. Formulas<\/strong>
\nNSW Comp Tech (2024) – CT-Data: \u00a4 Summarise data using formulas, functions and features of a spreadsheet\u2026<\/p>\n

7. Plots and Trendlines<\/strong>
\nAC V9.0 (7-8): Recap 5-6: Develop confidence and competencies in using digital systems to create displays of data, such as visualisations, which assist in interpreting data sets.
\nNSW DT(Tech Mand): \u00b7 interpret and visualise data using a range of software to create information. (ACTDIP026)
\nNSW Comp Tech (2024) – CT-Net \/ CT-UE: \u00a4 Visualise data to identify trends, patterns, relationships and outliers using a range of tools:
\nAC V9.0 (7-8): Model structured data in meaningful ways using spreadsheets and single-table databases, and analyse and visualise the data to extract meaning from it.
\nNSW DT(Tech Mand): \u2013 using a graph to identify patterns, trends and outliers
\nNSW Comp Tech (2024) – CT-Data: \u00a4 Generate a data visualisation to identify trends and outliers using a range of tools:
\nAC V9.0 (7-8): – visualising multidimensional data by choosing appropriate graphs, for example a scatter plot of food prices and sales, coloured by each food\u2019s sugar content, or diagrams such as a social network diagram and maps of crime rates by location to reveal trends, outliers or other information<\/p>\n

8. Validating Data<\/strong>
\nAC V9.0 (7-8): Validate the data they acquire to ensure it is accurate and consistent.<\/p>\n

9. Forecasting<\/strong>
\nAC V9.0 (7-8): \u00b7 analyse and visualise data using a range of software, including spreadsheets and databases, to draw conclusions and make predictions by identifying trends (AC9TDI8P02)
\nAC V9.0 (7-8): – summarising data based on its attributes to identify trends and make predictions, for example sorting crime data by type of offence, showing that burglaries have decreased over time to predict fewer burglaries will happen next year
\nAC V9.0 (7-8): – making predictions about future population distribution of First Nations Australians based on identified trends, for example analysing and visualising data using spreadsheets and databases on their population growth in metropolitan areas<\/p>\n

10. Collaborating on Spreadsheets<\/strong>
\nAC V9.0 (7-8): – collaborating effectively online using cloud storage, for example setting up and managing a shared space in an online repository\u2026
\nNSW DT(Tech Mand): LS – – collaboration
\nNSW Comp Tech (2024) – UE: \u00a4 manages, documents and explains individual and collaborative work practices
\nAC V9.0 (7-8): Select and use a range of digital tools efficiently and responsibly to create, locate and share content; and to plan, collaborate on and manage projects.
\nAC V9.0 (7-8): – determining and recording the tasks, responsibilities and timeframes for a collaborative project, for example using a spreadsheet to record tasks and their sequence, critical dates and who is responsible for each task so a project can be finished on time<\/p>\n

11. Algorithms and the IF Function<\/strong>
\nAC V9.0 (7-8): Represent and communicate their algorithmic solutions using flowcharts and pseudocode.
\nNSW DT(Tech Mand): \u00b7 design algorithms that use a range of data types, branching and iteration and represent them diagrammatically and in English (ACTDIP029)
\nAC V9.0 (7-8): – describing algorithms with nested control structures, including a nested if, for example IF it is raining THEN [IF parents are home THEN drive to school]; or an IF inside a loop, for example REPEAT [select the largest coin smaller than the remaining total, and subtract it] UNTIL the remainder is zero<\/p>\n

12. Conditional Formatting<\/strong>
\nNSW Comp Tech (2024) – CT-Data: \u00a4 Filter, group and sort data using a spreadsheet, including using filters and sorting, using conditional formatting and grouping and aggregating data: <\/p>\n

13. Skills 1 – Sports<\/strong>
\nVarious from above.<\/p>\n

14. Skills 2 – Personal Finances<\/strong>
\nNSW DT(Tech Mand): \u2013 calculating a budget or numerical simulation
\nVarious from above.<\/p>\n

15. Skills 3 – Students<\/strong>
\nVarious from above.<\/p>\n

16. Skills 4 – Environment<\/strong>
\nVarious from above.<\/p>\n

17. Skills 5 – Business<\/strong>
\nVarious from above.<\/p>\n

18. Skills 6 – Staff and Salaries<\/strong>
\nVarious from above.<\/p>\n

By Curriculum<\/strong><\/h3>\n

Australian Curriculum V9.0 (2024)<\/strong>
\nAC V9.0 (7-8): – collaborating effectively online using cloud storage, for example setting up and managing a shared space in an online repository\u2026
\nAC V9.0 (7-8): – describing algorithms with nested control structures, including a nested if, for example IF it is raining THEN [IF parents are home THEN drive to school]; or an IF inside a loop, for example REPEAT [select the largest coin smaller than the remaining total, and subtract it] UNTIL the remainder is zero
\nAC V9.0 (7-8): – determining and recording the tasks, responsibilities and timeframes for a collaborative project, for example using a spreadsheet to record tasks and their sequence, critical dates and who is responsible for each task so a project can be finished on time
\nAC V9.0 (7-8): – making predictions about future population distribution of First Nations Australians based on identified trends, for example analysing and visualising data using spreadsheets and databases on their population growth in metropolitan areas
\nAC V9.0 (7-8): – summarising data based on its attributes to identify trends and make predictions, for example sorting crime data by type of offence, showing that burglaries have decreased over time to predict fewer burglaries will happen next year
\nAC V9.0 (7-8): – using a spreadsheet table to model objects and events, including choosing appropriate formats for each column, and filtering and sorting rows to answer questions
\nAC V9.0 (7-8): – visualising multidimensional data by choosing appropriate graphs, for example a scatter plot of food prices and sales, coloured by each food\u2019s sugar content, or diagrams such as a social network diagram and maps of crime rates by location to reveal trends, outliers or other information
\nAC V9.0 (7-8): \u00b7 analyse and visualise data using a range of software, including spreadsheets and databases, to draw conclusions and make predictions by identifying trends (AC9TDI8P02)
\nAC V9.0 (7-8): Acquire, interpret and model with spreadsheets and represent data with integers and binary.
\nAC V9.0 (7-8): Model structured data in meaningful ways using spreadsheets and single-table databases, and analyse and visualise the data to extract meaning from it.
\nAC V9.0 (7-8): Recap 5-6: Develop confidence and competencies in using digital systems to create displays of data, such as visualisations, which assist in interpreting data sets.
\nAC V9.0 (7-8): Represent and communicate their algorithmic solutions using flowcharts and pseudocode.
\nAC V9.0 (7-8): Select and use a range of digital tools efficiently and responsibly to create, locate and share content; and to plan, collaborate on and manage projects.
\nAC V9.0 (7-8): Validate the data they acquire to ensure it is accurate and consistent.<\/p>\n

NSW Digital Technologies (Tech Mandatory)<\/strong>
\nNSW DT(Tech Mand): \u2013 calculating a budget or numerical simulation
\nNSW DT(Tech Mand): \u2013 filtering or sorting to answer a specific question
\nNSW DT(Tech Mand): \u2013 using a graph to identify patterns, trends and outliersNSW Comp Tech (2024) – CT-Data: \u00a4 Generate a data visualisation to identify trends and outliers using a range of tools:
\nNSW DT(Tech Mand): \u00b7 interpret and visualise data using a range of software to create information. (ACTDIP026)
\nNSW DT(Tech Mand): LS – – collaboration
\nNSW DT(Tech Mand): \u00b7 design algorithms that use a range of data types, branching and iteration and represent them diagrammatically and in English (ACTDIP029)<\/p>\n

NSW Computing Technology (2024)<\/strong>
\nNSW Comp Tech (2024) – CT-Data \/ CT-Net: \u00a4 acquires, represents, analyses and visualises simple and structured data
\nNSW Comp Tech (2024) – CT-Data: \u00a4 Filter, group and sort data using a spreadsheet, including using filters and sorting, using conditional formatting and grouping and aggregating data:
\nNSW Comp Tech (2024) – CT-Data: \u00a4 Filter, group and sort data using a spreadsheet, including using filters and sorting, using conditional formatting and grouping and aggregating data:
\nNSW Comp Tech (2024) – CT-Data: \u00a4 Summarise data using formulas, functions and features of a spreadsheet\u2026
\nNSW Comp Tech (2024) – CT-Net \/ CT-UE: \u00a4 Visualise data to identify trends, patterns, relationships and outliers using a range of tools:
\nNSW Comp Tech (2024) – UE: \u00a4 manages, documents and explains individual and collaborative work practices NSW Comp Tech (2024)<\/p>\n","protected":false},"excerpt":{"rendered":"

Help your students acquire, analyse and visualise a range of data. They learn spreadsheet skills such as formulas, relative and absolute referencing, data validation, conditional formatting and forecasting via guided tasks. Charts are created with trendlines that are extrapolated forwards to help plan for the future. There are then 18 spreadsheet tasks covering the topics of sport, personal finances, students, the environment, business, and staff and salaries. These tasks offer a wealth of practice in the targetted skills for students of all abilities. The activities can be completed in either Excel or Google Sheets, and we include numerous extension tasks for the more able.<\/p>\n

The targeted curriculum outcomes were gathered from the new Australian Curriculum V9.0 as well as the new NSW Computing Technology course (2024). The relevant curriculum statements are listed below.<\/p>\n

Files: Cover \/ Checklist \/ Wordlist \/ Introducing Spreadsheets \/ Basic Excel Skills \/ Google sheets \/ Sorting & Filtering \/ Formulas \/ Plots and Trendlines \/ Validating Data \/ Forecasting \/ Collaborating on Spreadsheets \/ Algorithms and the IF Function \/ Conditional Formatting \/ Skills 1 – Sports \/ Skills 2 – Personal Finances \/ Skills 3 – Students \/ Skills 4 – Environment \/ Skills 5 – Business \/ Skills 6 – Staff and Salaries<\/p>\n

Includes all solution spreadsheets in both Excel and Google Sheets. The premium packages include the fixed PDF files as well as the editable Word versions (great for teacher editing or student answers). 90PP <\/em><\/p>\n

Sample Pages<\/a><\/p>\n","protected":false},"featured_media":28176,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"product_brand":[],"product_cat":[19],"product_tag":[],"class_list":{"0":"post-28181","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-years-7-8-digital-technologies","7":"desktop-align-left","8":"tablet-align-left","9":"mobile-align-left","11":"first","12":"instock","13":"taxable","14":"shipping-taxable","15":"purchasable","16":"product-type-variable","17":"has-default-attributes"},"_links":{"self":[{"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/product\/28181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/comments?post=28181"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/media\/28176"}],"wp:attachment":[{"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/media?parent=28181"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/product_brand?post=28181"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/product_cat?post=28181"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/product_tag?post=28181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}