VCE IT Lecture Notes by Mark Kelly
McKinnon Secondary College
Victoria, Australia.

Lecture Notes is a long and occasionally-accurate treatise on VCE (Victorian Certificate of Education)
IT Applications (ITA)
Software Development (SD)
IT Units 1 & 2

• IT Apps
  • Course Summary
  • Study Design
  • Exam Post Mortems
    • 2007
    • 2008
    • 2009
    • 2010
    • 2011
  • Spreadsheet practice tasks
• Sof Dev
  • Course Summary
  • Study Design
  • Exam Post Mortems
    • 2007
    • 2008
    • 2009
    • 2010
  • The SD Grotto
• IT Exams
  • Exam Tips
• Units 1 &2
  • Course Summary
    • Item 3.1.1
    • Item 3.1.2
  • Study Design
• Extras
  • VCAA's Problem Solving Methodology definition
  • VCAA Glossary
  • Scaling report
  • Gantt and PERT
  • Organisation Types
  • Resources
  • Nested IF challenge

Search the vceit.com site

Study design outlines for ITA and SD and Units 1+2

A Software Development Grotto

Are you man/woman/undecided enough to accept the popular Excel Nested IF Challenge?

Do you want to find out how to do stuff - like using dropdown lists in Excel?

McKinnon ITA class site | McKinnon SD class site

• VCAA IT site - VCAA ITA - VCAA SD
• VCE IT Frequently Asked Questions - VCAA Bulletin #85, November 2010
• VCE IT Study Design 2011-2014
• Study Design Erratum (SD U4O2 "error logs")
• Study Design Erratum (ITA U3O2 data types)
• Check last year's VTAC scaling report
• VCAA's sample SD exam questions (2011) and answers by Mark Kelly and Kevork Krozian
• VCAA's sample ITA exam questions (2011)
• IT Implementation Workshop handout (PDF)
• Examiners' reports - ITA and SD
• Assessment Handbook (updated around July)
• A report on the SD SAC Outcomes Audit
• Approved SD programming languages
• 2011 Grade distributions for SD
• 2011 Grade distributions for ITA

Thanks to VCAA for permission to use information from the VCE IT study design and VCE IT exams.

VCAA pronouncements

Approved types of websites for ITA U3O1 are

• blogs
• chat rooms
• forums
• social networking
• wikis.

The following software tools and functions info comes from the July 2010 Bulletin

Listed below for each software tool are the software functions that students are expected to acquire. Note that this list is not exhaustive; learning does not have to be confined to the functions listed.

For School-assessed Coursework, the assessment tasks set by teachers should be realistic and allow discrimination between student performances. When designing assessment tasks for those outcomes that require the use of software tools, not all of the listed functions need to be demonstrated when solving problems.

For examination purposes, students must be familiar with all of the listed functions for the selected software tools.

Relational database management system
The following functions apply to Unit 3:

• create tables
• create relationships between tables
• use a range of data types
• electronic validation
• create, edit and use queries
• use of calculated fields
• sort records or index on different fields.

If students use a relational database management system in Unit 4, the following additional functions apply:

• import/export of data
• format data for display
• create and edit a range of forms, including different data types and controls
• create and edit a range of formatted reports.

Web authoring software

• cascading style sheet
• edit and format content
• links (relative and absolute links, internal and external links)
• navigation
• buttons
• screen layout
• tagging (metadata tags, alt tags)
• forms
• incorporate images/sound

Multimedia authoring software

• edit and format content
• links
• navigation
• buttons
• screen layout
• incorporate images/sound

Spreadsheets

• conditional formatting
• formulae including simple functions (SUM, average, maximum, minimum, count), conditional statements and lookup tables
• cell protection
• graphs
• insert notes/comments
• macros
• relative and absolute cell references
• naming a range
• electronic validation
• sheet referencing
• formatting/layout

08

09

10

08

Copyright © Mark Kelly

Site created: 7 November 2001 in the McKinnon Secondary College website
Moved to vceit.com 8 June 2010
Last changed - Monday 20 February, 2012 2:32 PM

Visit McKinnon Secondary College

Go to the top