Advanced Data Skills Yrs 9-10  (CoP051)
Students learn about relational databases then build one themselves for a sports or gaming competition. Data dictionaries, relationships, schemas, foreign keys, SQL statements and aggregate functions are all tackled through supported tasks. We look at lossy and lossless compression in JPG and PNG images, as well as codecs for video and audio files. Students use online software to visualise data then investigate advanced spreadsheet tools such as absolute referencing, trigonometry and financial functions. They build iterative models for compound interest and ecological populations then finish up having fun with encryption, secret keys and hashing algorithms.

94pp plus completed databases and 35 spreadsheet solutions (created in both Excel and Google Sheets).

Free Samples
MouseOver > Large Image
Click > Free Sample
Basic (Fixed) (?)15MB $169 Add
Premium (Editable) (?)31MB $239 Add
GST Included   View
Curriculum Links

Digital Technologies

0. Checklist

1. Vocab

2. Working with Data
how human interaction with networked systems introduces complexities surrounding access data
use structured data to analyse, visualise, model and evaluate objects and events.
importance of separating content, presentation and behavioural elements for data integrity and maintenance purposes.
Analyse simple compression of data and how content data are separated from presentation (ACTDIK035)

3. Database Project: Planning
documenting the attributes of complex objects and processes using a data dictionary
interpreting schemas that represent relationships between entities and querying data across tables
using foreign keys to represent relationships

4. Database Project: Building

5. Database Project: Populating

6. Database Project: Querying

7. Database Project: SQL
joining tables in structured query language (SQL) SELECT statements

8. Database Project: Reporting
summarising data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases

9. Encoding Recap

10. Image Compression
explaining how simple compression schemes reduce the size of repetitive data, for example how run length encoding reduces the size of images
explaining the difference between lossy and lossless compression, for example the difference between JPEG and PNG images

11. AV Compression
explaining codecs for audio-visual compression, for example common codecs for video formats

12. Data Visualisation
Analyse and visualise data to create information and address complex problems, and model processes, entities and their relationships using structured data (ACTDIP037)
using visualisation software tools to identify patterns and relationships between sets of data and information, and support abstract reasoning, for example representing data using histograms, network diagrams and maps

13. Spreadsheet References
automating calculations, for example using absolute cell referencing to automatically extend formulas

14. Spreadsheet Maths
automating arithmetic calculations using built-in functions such as trigonometry

15. Spreadsheet Finance
automating arithmetic calculations using built-in functions such as compound interest
simulating simple, iterative processes, for example modelling compound interest or ecological models using a spreadsheet

16. Spreadsheet Ecology
simulating simple, iterative processes, for example modelling compound interest or ecological models using a spreadsheet

17. Encryption
explaining encryption of data as a means of protecting data, for example secret keys and 'exclusive or' (XOR) and hashing algorithms to digitally sign data (from Inf Sys outcome)
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.





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.


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