Advanced Data Skills Yrs 9-10  (CoP051)
Description
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
Preview
MouseOver > Large Image
Click > Free Sample
 
Purchases(?)  
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.
 

 
 

 
 

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