{"id":28344,"date":"2025-01-22T17:37:11","date_gmt":"2025-01-22T17:37:11","guid":{"rendered":"https:\/\/www.orbeducation.com\/au\/?post_type=product&p=28344"},"modified":"2025-03-10T14:27:52","modified_gmt":"2025-03-10T14:27:52","slug":"databases-2025-yrs-7-8","status":"publish","type":"product","link":"https:\/\/www.orbeducation.com\/au\/product\/databases-2025-yrs-7-8\/","title":{"rendered":"Databases 2025 (Yrs 7-8)"},"content":{"rendered":"

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

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

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

2. Information systems<\/strong><\/p>\n

3. Introducing Databases<\/strong><\/p>\n

4. Designing a Database<\/strong>
\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 Comp Tech (2024) – CT-Net \/ CT-Data: Represent, store and transmit data to facilitate computation, including selecting appropriate data types, understanding the limitations of data types and structuring data systematically:
\nNSW Comp Tech (2024) – CT-UE \/ CT-Data: Model entities, events and their attributes using structured data:
\nAC V9.0 (7-8): analyse and visualise data using a range of software, including spreadsheets and databases, to draw conclusions and make predictions by identifying trends (AC9TDI8P02)<\/p>\n

5. Creating the Database<\/strong><\/p>\n

6. Entering Data<\/strong>
\nNSW Comp Tech (2024) – CT-Net \/ CT-Data: Load, insert and update data in a database:<\/p>\n

7. Data Validation<\/strong>
\nAC V9.0 (7-8): Validate the data they acquire to ensure it is accurate and consistent.
\nNSW Comp Tech (2024) – CT-Net: Validate data is correct and investigate the impact of invalid data: <\/p>\n

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

9. Visual Queries<\/strong>
\nAC V9.0 (7-8): model and query the attributes of objects and events using structured data (AC9TDI8P03)
\nNSW Comp Tech (2024) – CT-Net: Filter, sort and limit database queries using SELECT, WHERE, ORDER BY and LIMIT clauses: <\/p>\n

10. Query Criteria<\/strong><\/p>\n

11. Wildcards<\/strong><\/p>\n

12. Select SQL<\/strong>
\nAC V9.0 (7-8): interpreting and querying single-table databases using visual or simple SQL queries with SELECT, WHERE and ORDER BY clauses, for example answering queries in a database for a historical\u202fevent<\/p>\n

13. Reports<\/strong>
\nNSW Comp Tech (2024) – CT-Data: Analyse data to make decisions and generate reports using a database: <\/p>\n

14. Exporting Data<\/strong>
\nNSW Comp Tech (2024) – CT-Data: Compare the usability of data using a spreadsheet or database to analyse the same dataset: <\/p>\n

15. Skills 1 – School<\/strong>
\nAC V9.0 (7-8): modelling objects and events as structured data, that is, the attributes relevant to the task, for example products in the canteen and the sale of those products, with attributes such as the product name, price, quantity and nutritional value.<\/p>\n

Plus various from above.<\/p>\n

16. Skills 2 – Sports<\/strong>
\nVarious from above.<\/p>\n

17. Skills 3 – Entertainment<\/strong>
\nVarious from above.<\/p>\n

18. Skills 4 – Populations<\/strong>
\nVarious from above.<\/p>\n

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

Australian Curriculum V9.0 (2024)<\/strong>
\nAC V9.0 (7-8): 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): interpreting and querying single-table databases using visual or simple SQL queries with SELECT, WHERE and ORDER BY clauses, for example answering queries in a database for a historical\u202fevent
\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): model and query the attributes of objects and events using structured data (AC9TDI8P03)
\nAC V9.0 (7-8): modelling objects and events as structured data, that is, the attributes relevant to the task, for example products in the canteen and the sale of those products, with attributes such as the product name, price, quantity and nutritional value.
\nAC V9.0 (7-8): Validate the data they acquire to ensure it is accurate and consistent.<\/p>\n

NSW Computing Technology (2024)<\/strong>
\nNSW Comp Tech (2024) – CT-Data: Analyse data to make decisions and generate reports using a database:
\nNSW Comp Tech (2024) – CT-Data: Compare the usability of data using a spreadsheet or database to analyse the same dataset:
\nNSW Comp Tech (2024) – CT-Data: 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-Net \/ CT-Data: Load, insert and update data in a database:
\nNSW Comp Tech (2024) – CT-Net \/ CT-Data: Represent, store and transmit data to facilitate computation, including selecting appropriate data types, understanding the limitations of data types and structuring data systematically:
\nNSW Comp Tech (2024) – CT-Net: Filter, sort and limit database queries using SELECT, WHERE, ORDER BY and LIMIT clauses:
\nNSW Comp Tech (2024) – CT-Net: Validate data is correct and investigate the impact of invalid data:
\nNSW Comp Tech (2024) – CT-UE \/ CT-Data: Model entities, events and their attributes using structured data: <\/p>\n","protected":false},"excerpt":{"rendered":"

An introduction to designing and querying Databases. Students put together ideas for an information system then design a single table database to support it. We consider data types for a range of information then use Microsoft Access as a platform for development. Students learn to validate, sort and filter using our sample data then apply the techniques to their own development. We introduce the use of SELECT SQL to collect records for reports, then finish the tutorial section with the exporting of data into spreadsheets and documents.<\/p>\n

To practice the skills learned, we follow up with eight independent database design tasks covering the topics of school, sport, entertainment and populations. These activities offer a wealth of practice in the targetted skills for students of all abilities. The resources include frequent 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 \/ Information systems \/ Introducing Databases \/ Designing a Database \/ Creating the Database \/ Entering Data \/ Data Validation \/ Sorting and Filtering Data \/ Visual Queries \/ Query Criteria \/ Wildcards \/ Select SQL \/ Reports \/ Exporting Data \/ Skills 1 – School \/ Skills 2 – Sports \/ Skills 3 – Entertainment \/ Skills 4 – Populations<\/p>\n

‘Includes all answer sheets and solution databases. The premium packages include the fixed PDF files as well as the editable Word versions (great for teacher editing or student answers). 83PP + 18 databases + 5 spreadsheets<\/em><\/p>\n

Sample Pages<\/a><\/p>\n","protected":false},"featured_media":28332,"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-28344","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\/28344","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=28344"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/media\/28332"}],"wp:attachment":[{"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/media?parent=28344"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/product_brand?post=28344"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/product_cat?post=28344"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.orbeducation.com\/au\/wp-json\/wp\/v2\/product_tag?post=28344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}