[Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or Spreadsheets

[Mann, Warrick D]

I will be doing the same as well.

 

I am lucky I did specifically cover Swipe cards!!! J

 

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Litsa Tzelepis
Sent: Thursday, 11 November 2010 10:28 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or Spreadsheets

 

I agree - I'll be doing the same, besides its a good balance.

	----- Original Message ----- 

	From: Elliot, Mitchell E
<mailto:elliot.mitchell.e at edumail.vic.gov.au>  

	To: Year 12 IT Applications Teachers' Mailing List
<mailto:itapps at edulists.com.au>  

	Sent: Thursday, November 11, 2010 10:14 AM

	Subject: Re: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or
Spreadsheets

	 

	I was thinking of doing the same, Database unit 3 and
spreadsheets unit 4 mostly in case they can put both on the exam.

	 

	Mitch Elliot | Buckley Park College | Cooper St, Essendon 3040 |
(03) 9331 9999 | elliot.mitchell.e at edumail.vic.gov.au
<mailto:elliot.mitchell.e at edumail.vic.gov.au> 

	 

	From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Jackson Bates
	Sent: Thursday, 11 November 2010 9:59 AM
	To: 'itapps at edulists.com.au'
	Subject: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or
Spreadsheets

	 

	Hi All,

	 

	Just out of curiosity, what are you all doing for unit 4:
Databases or spreadsheets? And what is your rationale for this?

	 

	--

	 

	A reminder from VCAA about the functions to be demonstrated in
both:

	(taken from
http://www.vcaa.vic.edu.au/vcaa/correspondence/bulletins/2010/July/vce_s
tudy.html#2)

	 

	 

	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.

	 

	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

	 

	--

	 

	FWIW I'll probably run with spreadsheets, just for the sake of
building wider usable skills, but I'm open to ideas.

	 

	On a side note, I assume only the database knowledge from unit 3
can be on the exam, since there is no way for the exam to differentiate
between those students that have done Databases Unit 4 or Spreadsheets.
Does my thinking seem sound on that?

	 

	Regards,

	 

	Jackson Bates

	VCE IT Applications

	Waverley Christian College

	 

________________________________

	  

	 WCCSIG<http://www.wcc.vic.edu.au/images/WCCSig.JPG> 

	------------------------------------------
	DISCLAIMER: This email and any files transmitted with it are
confidential and intended solely for the use of the individual or entity
to whom they are addressed. If you have received this email in error
please delete it immediately and notify the system administrator on
srvadm at wcc.vic.edu.au.
	WARNING: Although the college has taken reasonable precautions
to ensure no viruses are present in this email, the college cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments.
	------------------------------------------

	Important - This email and any attachments may be confidential.
If received in error, please contact us and delete all copies. Before
opening or using attachments check them for viruses and defects.
Regardless of any loss, damage or consequence, whether caused by the
negligence of the sender or not, resulting directly or indirectly from
the use of any attached files our liability is limited to resupplying
any affected attachments. Any representations or opinions expressed are
those of the individual sender, and not necessarily those of the
Department of Education and Early Childhood Development.

________________________________

	_______________________________________________
	http://www.edulists.com.au - FAQ, resources, subscribe,
unsubscribe
	IT Applications Mailing List kindly supported by
	
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
	http://www.vitta.org.au  - VITTA Victorian Information
Technology Teachers Association Inc


Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20101111/84a0598e/attachment.html