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 Extended – aspects 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 Extended – aspects 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: