<HTML>
<HEAD>
<TITLE>Re: [Year 12 IT Apps] prac v theory content....</TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>You’ll find heaps at <BR>
<a href="http://www.vitta.org.au/resources/">http://www.vitta.org.au/resources/</a><BR>
<BR>
Cheers<BR>
<BR>
Jock<BR>
<BR>
<BR>
On 24/7/07 4:09 PM, "Lappin, Jason M" <lappin.jason.m@edumail.vic.gov.au> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><SPAN STYLE='font-size:12.0px'><FONT FACE="Arial">Antonia<BR>
Do you know where I could find some exercises that cover the functions required for the task for U4O1. I am struggling to find enough activities to cover all of the functions required for the SAC, and I am a bit of an excel rookie myself.<BR>
Your help would be appreciated.<BR>
Jason Lappin<BR>
ICT Coordinator<BR>
Rutherglen High School</FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="100%"></FONT><FONT FACE="Tahoma"><B>From:</B> itapps-bounces@edulists.com.au on behalf of Antonia Caridi<BR>
<B>Sent:</B> Tue 24/07/2007 1:23 PM<BR>
<B>To:</B> Year 12 IT Applications Teachers' Mailing List<BR>
<B>Subject:</B> Re: [Year 12 IT Apps] prac v theory content....<BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"><BR>
According to my understanding, VCAA assumes that students are able to<BR>
utilise and understand the software functions identified in the<BR>
requirements list - however not all of these functions need to be<BR>
exemplified in the assessment task. For a student to receive an S he/she<BR>
must be able to demonstrate that they have satisfied the requirements<BR>
for each Area of Study as specified in the SDesign.<BR>
<BR>
My students complete exercises that cover all of the functions and<BR>
skills listed in the software requirements and then the task I set<BR>
contains several of these - the completion of both of these to a<BR>
satisfactory standard constitutes an S.<BR>
<BR>
Antonia<BR>
<BR>
Antonia Caridi<BR>
Sacre Coeur<BR>
172 Burke Road<BR>
Glen Iris 3146<BR>
Telephone 9885 4501<BR>
Fax 9885 5936<BR>
<BR>
<BR>
>>> "Kent Beveridge" <kbeveridge@stbc.vic.edu.au> 24/07/2007 9:43 AM<BR>
>>><BR>
Hi listers,<BR>
I just had a look at the list Mark created to do with spreadsheeting.<BR>
I, personally, dont use (or see the need to use!) all of the above<BR>
functions on the list and hence not only need to teach them but also<BR>
learn them before I can teach them. Having just come back this year to<BR>
VCE IT, and looking at the theory to get through, I would be interested<BR>
to hear other's thoughts on the volume of work to teach at this level..<BR>
I feel that the amount of 'useable' prac to teach is over-rated and<BR>
mostly impractical in the majority of cases and that the volume of<BR>
theory combined with the SAC work makes for us really earning our<BR>
$$$$'s. Dont know about you guys out there but I really feel it!<BR>
I sometimes wish I could just teach one thing and it didnt change every<BR>
6 months - a bit like maths!<BR>
Also..trying to teach programming to year 11's who havent got a clue as<BR>
they think IT was the 'easy option' so chose it as a subject doesnt<BR>
help! It feels a bit like throwing peanuts to monkeys and then finding<BR>
out they dont like peanuts!<BR>
Lets see now...<BR>
this year I have..<BR>
taught myself VB6, JAVASCRIPT, HTML, GAMEMAKER,CHANGED JOBS, MOVED<BR>
HOUSE TO THE COUNTRY, TRIED TO LEARN ADVANCED EXCEL, DOING POSTGRAD<BR>
ONLINE STUDIES, DOING THE TA04 COURSE,,<BR>
JEEEZ, I need a holiday!<BR>
<BR>
Kent Beveridge,<BR>
I.T. co-ordinator<BR>
St. Brigids Catholic Sec. College<BR>
Horsham<BR>
email.. kbeveridge@stbc.vic.edu.au<BR>
<BR>
Wishes and Eggs, one you make and one you break! A bit like<BR>
promises.....<BR>
<BR>
"This email and any attachments may be confidential. You must not<BR>
disclose or use the information in this email if you are not the<BR>
intended recipient. If you have received this email in error, please<BR>
notify us immediately and delete the email and all copies. The School<BR>
does not guarantee that this email is virus or error free. The attached<BR>
files are provided and my only be used on the basis that the user<BR>
assumes all responsibility for any loss, damage or consequence resulting<BR>
directly or indirectly from the use of the attached files, whether<BR>
caused by the negligence of the sender or not. The content and opinions<BR>
in this email are not necessarily those of the School."<BR>
<BR>
________________________________<BR>
<BR>
From: itapps-bounces@edulists.com.au on behalf of Russell Edwards<BR>
Sent: Tue 7/24/2007 8:53 AM<BR>
To: Year 12 Information Technology Processing and Management<BR>
Teachers'MailingList<BR>
Subject: [Year 12 IT Apps] Re: [Year 12 IPM] Suggested spreadsheet<BR>
functionsto teach for ITA U4O1<BR>
<BR>
<BR>
<BR>
<BR>
On 30/11/2006, at 9:16 PM, Mark Kelly wrote:<BR>
<BR>
> A free unofficial, personal guide about how much spreadsheeting kids<BR>
> need to know for ITA U4O1...<BR>
><BR>
> Anything I've forgotten or screwed up?<BR>
><BR>
<BR>
Your list seems eminently sensible. It's probably also worth bearing<BR>
in mind the VCAA software functions list for spreadsheets:<BR>
<BR>
* lookup tables<BR>
* conditional formatting<BR>
* conditional statements<BR>
* cell protection<BR>
* graphs<BR>
* insert notes/comments<BR>
* macros<BR>
* relative and absolute cell references<BR>
* naming a range<BR>
* electronic validation<BR>
* sheet referencing<BR>
* formatting/layout.<BR>
<BR>
I take "layout" to be the link to stuff about formats and<BR>
conventions, interfaces, yadda yadda yadda....<BR>
<BR>
Russell<BR>
<BR>
<BR>
<BR>
Important - This email and any attachments may be confidential. If<BR>
received in error, please contact us and delete all copies. Before<BR>
opening or using attachments check them for viruses and defects.<BR>
Regardless of any loss, damage or consequence, whether caused by the<BR>
negligence of the sender or not, resulting directly or indirectly from<BR>
the use of any attached files our liability is limited to resupplying<BR>
any affected attachments. Any representations or opinions expressed are<BR>
those of the individual sender, and not necessarily those of the<BR>
Department of Education.<BR>
_______________________________________________<BR>
<a href="http://www.edulists.com.au">http://www.edulists.com.au</a> <a href="http://www.edulists.com.au/"><http://www.edulists.com.au/></a> <a href="http://www.edulists.com.au/"><http://www.edulists.com.au/></a> - FAQ,<BR>
resources, subscribe, unsubscribe<BR>
IT Applications Mailing List kindly supported by<BR>
<a href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</a> -<BR>
Victorian Curriculum and Assessment Authority and<BR>
<a href="http://www.vitta.org.au">http://www.vitta.org.au</a> <a href="http://www.vitta.org.au/"><http://www.vitta.org.au/></a> <a href="http://www.vitta.org.au/"><http://www.vitta.org.au/></a> - VITTA Victorian<BR>
Information Technology Teachers Association Inc<BR>
<BR>
<BR>
<BR>
_______________________________________________<BR>
<a href="http://www.edulists.com.au">http://www.edulists.com.au</a> <a href="http://www.edulists.com.au/"><http://www.edulists.com.au/></a> - FAQ, resources, subscribe, unsubscribe<BR>
IT Applications Mailing List kindly supported by<BR>
<a href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</a> -<BR>
Victorian Curriculum and Assessment Authority and<BR>
<a href="http://www.vitta.org.au">http://www.vitta.org.au</a> <a href="http://www.vitta.org.au/"><http://www.vitta.org.au/></a> - VITTA Victorian Information Technology<BR>
Teachers Association Inc<BR>
<BR>
èµ__________________________________________________________________________________<BR>
This email and any attachments may be confidential and, if you are not<BR>
the intended recipient you must not disclose or use the information in<BR>
this email. If received in error, please notify the sender immediately<BR>
and delete the email and all copies. The school does not guarantee that<BR>
this email is virus or error free. Any attached files are provided and<BR>
may only be used on the basis that the recipient assumes all<BR>
responsibility for any loss, damage or consequence resulting directly or<BR>
indirectly from the use of this email and/or attached files, whether<BR>
caused by the negligence of the sender or not. The content and opinions<BR>
in this email are not necessarily those of Sacre Coeur.<BR>
____________________________________________________________________________________<BR>
_______________________________________________<BR>
<a href="http://www.edulists.com.au">http://www.edulists.com.au</a> <a href="http://www.edulists.com.au/"><http://www.edulists.com.au/></a> - FAQ, resources, subscribe, unsubscribe<BR>
IT Applications Mailing List kindly supported by<BR>
<a href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority and<BR>
<a href="http://www.vitta.org.au">http://www.vitta.org.au</a> <a href="http://www.vitta.org.au/"><http://www.vitta.org.au/></a> - VITTA Victorian Information Technology Teachers Association Inc<BR>
<BR>
</FONT></SPAN></BLOCKQUOTE><SPAN STYLE='font-size:12.0px'><FONT FACE="Verdana, Helvetica, Arial"><BR>
<BR>
Cheers,<BR>
<BR>
Jock<BR>
__________________________<BR>
Jock Garnsworthy<BR>
Pasco St. <BR>
Williamstown High School<BR>
(03)93971899<BR>
</FONT></SPAN>
</BODY>
</HTML>