Information Systems & databases

     table of content
  1. How to use this page
  2. Class site
  3. Introduction
  4. Key Database terms
  5. Folio
  6. Homework
  7. Videos to view
  8. Assessment Tasks
  9. Scope and sequence
  10. Relevant Links
  11. Copyright requirements
  12. Home

How to use this page

This page has all the syllabus topic content that you will need to complete the required study for IPT. You will find a range of activities called a “folio”. You are required to complete all of these tasks, as they prepare you for the HSC. You are also expected to present your completed work clearly labelled and written up in a workbook to your teacher.

There are due dates displayed with folios. The Assessments details may be found here.

Your work will be completed within the Cloudshare environment, however, an important security issue exists and you are required to ONLY use your school credentials for all online use within Cloudshare or external for example Voki.

The series of YouTubes are important to view as these will present to you visual detail that you may not see in the text. Important additional content is found at the Senior Study site found here

The Key Databases terms explained

 


The Folio Tasks.

Folio 1

Read Visit Complete
1a) Information Systems & Databases Unit Overview Complete this Form View
Please use the Form to work through task. Your responses will be collected
Read for an overview understanding section 2.1 pages 36 and 37.
1b) Information Systems Wikibooks Information Systems
Read the points 1 to 1.2 for understanding an overview
1c) Main Presentation Main Presentation Make series of notes on each slide Information Systems
1d) Examples of database Information Systems. HSC IPT by G.K. Powers Overview reading of here
Read for an overview understanding section Examples of database and Information systems pages 38 and 40.
1e) Information System explaining a school timetable system p 108-112. IPT The HSC Course by S. Davis Draw this as an Information System diagram.
Read the Video Store example p 116-117. How is this different from the school timetable?
1f) Set 2A p118 IPT The HSC Course by S. Davis Complete ALL Questions.
Suggested answers will be placed on the hsc group.
1a) The Advantages & Disadvantages of Non computer and Computer Based Organisational Methods Complete this Form View
Please use the Form to work through task. Your responses will be collected
Read or complete for understanding of this section of database and Information systems pages 41 and 42.
1h) Overview of Database Information Systems Wikibooks Database Information Systems
Read the points 2.1 through to 12.3.1 for understanding an overview of this area of study.
1i) Overview of the Organisation methods HSC IPT by G.K. Powers Overview reading of here
Read for an overview understanding section 2.2 pages 42 and 52.
1j) Revision Exercises HSC IPT by G.K. Powers Exercise 2.2 here
Read or complete for understanding of this section of database and Information systems pages 52 and 53.
1k) Organising Methods p119. IPT The HSC Course by S. Davis Summarise the page creating a set of notes.
1l) Organisation of flat-file databases p120-124. IPT The HSC Course by S. Davis Summarise the page creating a set of notes.
1m) Non -computer examples of flat-files p125. IPT The HSC Course by S. Davis Summarise the page creating a set of notes.
1n) Set 2B p126 IPT The HSC Course by S. Davis Complete ALL Questions.
Suggested answers will be placed on the hsc group.
1o) Databases Terms Click here Database Terminology
View video in particular for understanding of the key terms.
1p) The Key Databases terms explained Key terms Key Terms palm study cards.
Print the definition sheet and cut up into study palm cards to refer to in your spare time.
1q) Data Relationships Video Click here Relational Databases
1r) Hypermedia Systems  Woo Video  View.
View video for understanding of Relational Databases.
1s) Database Fundamentals IPT The HSC Course by S. Davis. & YoutubeClick here Read Relational Databases p127-137.
View the video and then read Relational Databases and complete HSC style question a & b p136-137.
1t) Set 2C p138 IPT The HSC Course by S. Davis Complete ALL Questions.
Suggested answers will be placed on the hsc wiki.
1u) Normalising Databases. IPT The HSC Course by S. Davis & Youtube. Read Normalising Databases p139-146.Click here Click here
View the videos and then read Normalising Databases p139-146. Write a definition for “Normalisation” and complete HSC style question a & b p147.
1v) Database Normalisation  Woo Video  View.
HSC IS&D Q 23 BOS Question;BOS Answer;BOS Criteria; read and respond to the HSC question.
Use the answer & criteria to check your response.
1x) Set 2D p149 IPT The HSC Course by S. Davis Complete ALL Questions.
Suggested answers will be placed on the hsc wiki.
1y) Hypertext and Hypermedia. IPT The HSC Course by S. Davis Summarise the terms.
1z) Hypermedia Systems  Woo Video  View.
Read Hypertext and Hypermedia p150-151. Write an explanation for “Hypertext and Hypermedia ” and provide an example of each.
1za) Storyboards. IPT The HSC Course by S. Davis Examine the term.
Read Storyboards p151-153. Summarise the term and draw fig 2.35.
1zb) Hypertext Markup Language (HTML) IPT The HSC Course by S. Davis Read these pages 154-160.
1zc) Set 2E p161 IPT The HSC Course by S. Davis Complete ALL Questions.
Suggested answers will be placed on the hsc wiki.
1zd) Data modelling: Data dictionaries. HSC Online Complete Activity and Questions.
1ze) Decision Trees & Tables | 2011 Q21 HSC paper  Chahine Video  View.
1zf) Answers to all G.K. Powers Sets. G.K. Powers Answers Complete Activity and Questions.
1z1) Data modelling: Schematic Diagrams  HSC Online Video  Complete Activity and Questions.

Folio 2 To be completed by Week 4 of Term 1 2018

 Read  Visit  Complete
2a) Database modelling. HSC Online Make headings and notes Scenario to Designing.
2b) Database design. HSC Online Make headings and notes Implementing on.
2bv) Database Schema  Woo Video  View.
2bv2) size of a database  Woo Video  View.
HSC IS&D Q 24 BOS Question;BOS Answer & criteria; read and respond to the HSC question.
Use the answer & criteria to check your response.
2c) Overview of Storage and retrieval HSC IPT by G.K. Powers Overview reading of here
Read for an overview understanding section 2.3 pages 53 to 62.
2d) Revision Exercises HSC IPT by G.K. Powers Exercise 2.3 here
Read or complete for understanding of this section of database and Information systems pages 62 and 63.
2e) Storage and Retrieval IPT The HSC Course by S. Davis Use the heading to summarise key points on pages 162-176.
2f) Other information processes HSC IPT by G.K. Powers Overview reading of here
Read for an overview understanding section 2.4 pages 64 and 67.
2g) Revision Exercises HSC IPT by G.K. Powers Exercise 2.4 here
Read or complete for understanding of this section of database and Information systems pages 68.
2h) DFD and processes performed by a web server p 163. IPT The HSC Course by S. Davis Complete Group Activity.
2i) Issues related to information systems and databases HSC IPT by G.K. Powers Overview reading of here
Read for an overview understanding section 2.5 pages 69 and 71.
2j) Revision Exercises HSC IPT by G.K. Powers Exercise 2.5 here
Read or complete for understanding of this section of database and Information systems pages 72.
An expectation exists that you read the content on the pages prior to the items 2k to 2o
2k) Set 2F p177 IPT The HSC Course by S. Davis Complete the Questions 1 to 14.
2l) Set 2G p191 IPT The HSC Course by S. Davis Complete the Questions 1 to 15.
2m) Set 2H p202 IPT The HSC Course by S. Davis Complete the Questions 1 to 15.
2n) Set 2I p214 IPT The HSC Course by S. Davis Complete the Questions 1 to 15.
2o) Set 2J p225 IPT The HSC Course by S. Davis Complete the Questions 1 to 15.

 

Videos to view

System Data Modelling Tools from Liam Dunphy

SQL

QBE’s Relationship To SQL

QBE: Why “Query By Example” Was Developed

QBE: A Concrete Example

QBE’s Design Principles


Relationship database concepts


Entity Relationship Modeling

What is Data Mining?

SQL Introduction

Introduction to SQL

Homework


Download this task here

Assessment Task

This will be the Semester One Examination.

Relevant Links

Information Systems and Databases overview here

Data Dictionaries and Schematic diagrams are here

Database modelling is here

Database design is here

Practical task is here

Ownership and control of data are here

E-crime is here

Information Systems and Databases on Wikibooks an opensource community details are here

Heinemann Chapter 2 IPT text by G.K. Powers here

Copyright Requirements

Creative Commons 2.0 Attribution Licence here

The personal or classroom educational use, provided there is a link to TeacherTube here TeacherTube terms and conditions state that videos may be downloaded for

The YouTube terms and conditions state that videos may be embedded in the media, provided there is a link to YouTube and that the appropriate non commercial use is made here

Reference to the text, Information, Processing and Technology- The HSC Course , author Samual Davis. ISBN 9780957891036 is made as students are expected to purchase both items. this can be purchased from here

Reference to the NSW Board of Studies HSC Documentation & Syllabus documentations are made, with documentations available from here