Information Technology and Systems - Support Site

Teaching and Learning Guide/Resources

Applied Tasks (Software)

* This section of the course is allocated 25 hours

In this section, students are expected to learn and apply skills and techniques which contribute to the prototyping of information systems, or part thereof.

There is a role in the syllabus for both working examples of smaller tasks, eg. suited to an individual user’s needs, and models of parts of larger, real-world systems.

Specific ‘skills’ are not stated, but the approximate hierarchy of capabilities below should give guidance on breadth and depth of areas which students could cover.

Where stated, terms refer to Microsoft Office software, but any appropriate software is suitable

Database Basics
  • Concept of fields, records, tables, file, data types

  • Data dictionary, primary keys, integrity constraints

  • Relationships between tables (one to one, one to many, many to many)

  • Selection filters / query by example (‘query’) – incl. on multiple tables

  • Display of output – report generation (‘forms’, ‘report’, ‘pages’)

  • Importing/exporting data

  • Mail merge

Databases Extendedaspects might include:
  • Advanced queries (‘update’, ‘append’, etc)

  • Statistics in reporting

  • SQL

  • Navigation buttons, scripting

  • Macros

  • Front end menus / user interface (‘Switchboards’)

  • Validation / control of data entry

  • Database security, protection

  • VBA

  • Other data storage models, eg. object –oriented

  • Data warehouses / data mining

Spreadsheet Basics
  • Comparison of tables (use of formulas in MS Word tables, spreadsheets, databases?)

  • Basic arithmetic operations, formulae, data

  • Filtering, sorting

  • Absolute and relative  cell referencing, replication

  • Importing and exporting data – file types

  • Charting

  • ‘What if …’ scenarios

  • Auto formatting, conditional formatting, data validation

  • Mail merge

* This section of the course is allocated 25 hours

Spreadsheets Extendedaspects might include:
  • Sorting techniques

  • Pivot table/chart

  • Subtotals

  • Lookup tables

  • Naming cells, ranges

  • Calculations between sheets

  • Basic recording and analysis of data (Macro recording)

  • Security / protection

Application Programming

Some suggestions:

  • Crocodile Technology

  • VBA – eg. using Excel

  • HTML, Java programming

Multimedia programming
  • Flash Action script

  • Powerpoint VBA

Website design and development
  • Planning, design and structure

  • Page/site creation

  • Working with images, lists, frames, tables, layers

  • Linking pages, websites, files

  • web forms

  • Cascading style sheets

  • Publishing to server

  • Dynamic web pages, server-side software (eg. ASP, Java Servlets), XHTML

Some examples of database/spreadsheet structures which could be developed and/or examined might include:
  • Library circulation system
  • Appointment booking system
  • Airline flight bookings
  • Sports carnival database
  • Stock control database, eg. for a shop, car yard.
  • Membership database, eg. sporting club, magazine subscriptions
  • Payment collection
  • Billing, eg. for work done
This could include active websites, where web pages access data stores and generate pages ‘on the fly’. 
Examples include:  Amazon, JetStar/Virgin Blue/Webjet, eBay

Examples of resources:

Recommended/'peer reviewed': Other submitted:
  Excel Instruction Set - how to use Excel
  Websites Tutorial2 - using WYSIWYGWebBuilder, Microsoft OfficeLive web building tools
  Australian Archives - a database evaluation task
  First Fleet database - assignment - converting First Fleet database into a relational database. Related files: 1 2 3 4 5