Information Systems and Databases Yrs 7-8  (CoP044)
Description
Study the design and sustainability of information systems, from their inputs, outputs and touchscreens to the collection, storage and presentation of data. Students evaluate systems on a national, regional and global scale before going on to design and build their own digital information system. We introduce Microsoft Access as a platform for development, validate data, then use some simple SQL to select records for reports.

Files: Vocab / Digital Systems / Inputs and Outputs / Information Systems / Environmental Sustainability / Materials Excel Task / Evaluating Information Systems / An Introduction to Databases / Designing an Information System / Data Types / Creating the Database / Entering Data / Data Validation / Sorting and Filtering Data / Queries / Query Criteria / Wildcards / SQL / Reports / Going Further

Includes full answers + all Access databases and 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) (?)12MB $129 Add
Premium (Editable) (?)24MB $179 Add
GST Included   View
Curriculum Links

 
Digital Technologies
 

 
Checklist
 

 
1. Vocab
 

 
2. Digital Systems
 
Recap - investigating how the internal and external components of digital systems are coordinated to handle data, for example how a keyboard, central processing unit and screen work together to accept, manipulate and present data and information
 

 
3. Inputs and Outputs
 
Recap - describing digital systems as having internal and external components that perform different functions, for example external components for inputting data including keyboard, microphone, stylus; internal processing components including the central processing unit; external output components including speakers, projector, screen; and data and information storage components including cloud and external devices
 
Recap - explaining why people interact so readily with touch systems, for example touch input requires less dexterity to issue instructions and is designed to be accessible to users through the use of icons
 
Recap - investigating what features of touch input rather than keyboard or mouse input contribute to their success in meeting a wide range of needs, for example mimicking a common movement such as expanding or contracting a hand to change the size of an object on screen, suits users with a range of dexterity
 

 
4. Information systems
 
Recap - consider time, tasks, data and the safe and sustainable use of information systems
 
risks associated with the use or adoption of such systems
 

 
5. Environmental Sustainability
 
Recap - considering opportunities and consequences of decisions for future applications, for example practices to save energy and other resources when using information systems, such as switching off when not in use, ensuring electronic devices are in energy-saving mode
 
Recap - comparing past and present information systems in terms of economic, environmental and social sustainability, including those of Aboriginal and Torres Strait Islander Peoples
 
Recap - 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
 

 
6. Sustainability Excel Task
 
Recap - Explain how student solutions and existing information systems are sustainable and meet current and future local community needs (ACTDIP021)
 

 
7. Evaluating Information Systems
 
Evaluate information systems and their solutions in terms of meeting needs, innovation and sustainability
 
Information systems in national, regional and global activities.
 

 
8. An Introduction to Databases
 

 
9. Designing an Information System
 
Structured data to model objects and events that shape their communities
 
10. Data Types
 

 
11. Creating the Database
 
Analyse and visualise data using a range of software to create information, and use structured data to model objects or events (ACTDIP026)
 
Describing the attributes of complex objects, for example defining the records, fields, formats and relationships of a simple dataset
 

 
12. Entering Data
 
Storing and transmitting data in digital systems
 

 
13. Data Validation
 
Acquire, analyse, validate and evaluate various types of data
 

 
14. Sorting and Filtering Data
 
Acquire, analyse, validate and evaluate various types of data
 

 
15. Queries
 
Querying an existing database to extract data for analysis, for example devising multiple selection criteria or using simple structured query language (SQL) SELECT statements to select records and retrieve specified fields
 

 
16. Query Criteria
 
Querying an existing database to extract data for analysis, for example devising multiple selection criteria or using simple structured query language (SQL) SELECT statements to select records and retrieve specified fields
 

 
17. Wildcards
 
Querying an existing database to extract data for analysis, for example devising multiple selection criteria or using simple structured query language (SQL) SELECT statements to select records and retrieve specified fields
 

 
18. Select SQL
 
Querying an existing database to extract data for analysis, for example devising multiple selection criteria or using simple structured query language (SQL) SELECT statements to select records and retrieve specified fields
 

 
19. Reports
 
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
 

 
20. Going Further
 
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