Spreadsheets and Data Yrs 7-8  (CoP045)
Description
These great resources will help your students acquire, analyse, validate and evaluate various types of data. We start by considering the vast quantities of data now playing an everyday part in our lives, then learn a range of spreadsheet skills via guided tasks. Activities can be completed in Excel or Google Sheets, and we provide all final spreadsheets in both forms.

Files: Data in our Lives / Representing Data / Working with Data / Introducing Spreadsheets / Basic Excel Skills / Google Sheets / Sorting & Filtering / Formulas / Plots and Trendlines / Spreadsheet Practice / Web Searches / Collaborating on Spreadsheets / Validating Data / Data Authenticity / Algorithms and the IF Function / Conditional Formatting / Financials / Pivot Tables / Copying Data / Exporting Data

Includes full answers + all Excel and Google Sheets spreadsheets developed along the way. The premium packages include the fixed PDF files as well as the editable Word versions (great for teacher editing or student answers).
Free Samples
Preview
MouseOver > Large Image
Click > Free Sample
 
Purchases(?)  
Basic (Fixed) (?)10MB $149 Add
Premium (Editable) (?)23MB $229 Add
GST Included   View
Curriculum Links

 
Digital Technologies
 

 
0. Checklist
 

 
1. Data in our Lives
 
Role that data plays in their lives
 

 
2. Representing Data
 
Structured data to model objects and events that shape their communities
 

 
3. Working with Data
 
Acquire, analyse, validate and evaluate various types of data
 

 
4. Introducing Spreadsheets
 
Recap - storing and transmitting data in digital systems recognising the difference between numerical, text and date formats in spreadsheets
 

 
5. Basic Excel Skills
 

 
6. Google sheets
 

 
7. Sorting & Filtering
 
Applying a set of conditions to a spreadsheet to organise and filter data, for example using conditional formatting to highlight the state of particular cells, and filtering and sorting categorical data using column filters
 

 
8. Formulas
 
Using software to automate calculations to help with interpreting data, for example using functions to make arithmetic calculations using multiple cells and summing cell ranges
 

 
9. Plots and Trendlines
 
Recap - using data visualisation software to help in interpreting trends, for example uploading data to a web application and building a visualisation of the dataset
 
Visualising data to create information, for example identify trends and outlier data from spreadsheets using plots, or displaying geocoded data on a map
 

 
10. Spreadsheet Practice
 
Recap - selecting and using peripheral devices suitable to the data, for example using a data probe to collect data about changing soil temperatures for plants, interpreting the data and sharing the results as a digital graph
 

 
11. Basic Web Searches
 
Recap - acquiring data from online sources by narrowing the focus, for example filtering data using provided options or performing queries using advanced search functions
 

 
12. Collaborating on Spreadsheets
 

 
13. Validating Data
 
Recap - using digital systems to validate data, for example setting data types in a spreadsheet to make sure a date is input correctly
 

 
14. Data Authenticity
 
Acquire data from a range of sources and evaluate authenticity, accuracy and timeliness (ACTDIP025)
 
Checking authenticity of data, for example ensuring the source or author is a reliable individual or organisation
 
Acquiring data from a range of sources, for example people, websites, books, mobile phones, radiofrequency identification (RFID) and data repositories such as the Australian Bureau of Statistics datasets, and compiling these data into a digital format
 
Designing a search engine query to find specific information on the web and checking its accuracy against information contained in other sources, for example entering instructions such as intitle: and inurl: prefixes to find information within a general directory, and comparing the results with information found in a wiki
 

 
15. Algorithms and the IF Function
 

 
16. Conditional Formatting
 
Applying a set of conditions to a spreadsheet to organise and filter data, for example using conditional formatting to highlight the state of particular cells, and filtering and sorting categorical data using column filters
 

 
17. Financials
 
Using features and functions of software to summarise data to create information, for example calculating a simple budget of income and payments and creating a summary table for analysis
 

 
18. Pivot tables
 
Explore different ways of showing the relationship between data elements to help computation, such as using pivot tables, graphs and clearly defined mark-up or rules.
 

 
19. Copying Data from the Web
 

 
20. Exporting Data
 
Explaining ways media elements are presented, for example the difference between embedded and linked media elements
 
Send a link to selected friends
ORB Education. Teaching and Learning made Easy
Free and priced teaching resources. Teach with our worksheets, PowerPoints, lessons and interactive resources for school and distance learning.
 

 
 

 
 

PURCHASING INFORMATION

 

Closed and Open Licenses

ORB Education resources are provided with full site licenses, enabling you to view resources on your interactive whiteboards, share on your networks, print and photocopy or place on your protected school intranet. Our Open Licences also allow you to copy resources to student laptops, place them on a protected website and email them to students.  You may purchase an open licence for either the Basic or Premium resources at a cost of 30% extra.  See our Typical Licence for more information.

 

Back to Top

 

Basic (Fixed) or Premium (Editable)?

Basic resources are for printing or using in their present state. You are not offered permission to digitally edit the materials. Resources are forwarded as fixed pdf documents or password protected files.

Premium Resources can be altered, dissected, collated or added to your own materials (with one or two exceptions). Resources are forwarded as Word files, Publisher files or with the passwords necessary to edit the materials.

Please note: Premium versions of individual resources are not available.  You will need to purchase a Pack or Set to obtain editable copies.

 

Back to Top

 

Pack or Bulk Buy Set?

The resources in a Pack have been created by a single author. Packs normally consist of between 20 and 70 worksheets, or about the equivalent in other digital forms.  Packs can be requested through mailorder or via download from our website.

To simplify bulk purchases, packs are sometimes collected together and made available as a Set.

Back to Top

 

Credit Card Purchases

We accept the following credit cards.

CC

Our order system uses the 'PayPal' system. PayPal is trusted by over 100 million people worldwide.  ORB Education receives no information about your Credit Card.

 

Back to Top

Mailorder Purchases

Mailorders are available to all school teachers in Australia. You may include a school order form or order number when requesting resources.

School orders will be sent to a school email address with an invoice along with download links for your selected products. Payments can be made using the following methods:

 - Credit Card
 - Bank Transfer
 - Cheque

GST is additional to the prices shown.

NOTE: Please ensure that you include a school email address with all mailorders.

Click here to open the Mailorder window.

 

Back to Top