[Year 12 IT Apps] Hey Jason..excel files for you!

Tue Jul 24 17:04:12 EST 2007

Hey Jason, I found these useful tidbits on the VITTA site. Its what I am using with my kids right now as a lead in to the excel OC. For more resources, go to the archive area on this site and you should be able to find heaps(or is it the archive area of the IT lists...oh well, its one of the two anyway. 
Hope this helps. I'm no 'rookie' but I aint no expert either! (just another doin the best we can I guess!!)
Cheers
ps..thanks and credits to the authors of these documents attached!!!  good one guys/gals!
Where would we be if we couldnt share our stuff?

Kent Beveridge,
I.T. co-ordinator
St. Brigids Catholic Sec. College
Horsham
email.. kbeveridge at stbc.vic.edu.au

Wishes and Eggs, one you make and one you break!  A bit like promises.....

"This email and any attachments may be confidential.  You must not disclose or use the information in this email if you are not the intended recipient.  If you have received this email in error, please notify us immediately and delete the email and all copies.  The School does not guarantee that this email is virus or error free.  The attached files are provided and my only be used on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not.  The content and opinions in this email are not necessarily those of the School."

________________________________

From: itapps-bounces at edulists.com.au on behalf of Lappin, Jason M
Sent: Tue 7/24/2007 4:09 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] prac v theory content....

Antonia
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.
Your help would be appreciated.
Jason Lappin
ICT Coordinator
Rutherglen High School 

________________________________

From: itapps-bounces at edulists.com.au on behalf of Antonia Caridi
Sent: Tue 24/07/2007 1:23 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] prac v theory content....

According to my understanding, VCAA assumes that students are able to
utilise and understand the software functions identified in the
requirements list - however not all of these functions need to be
exemplified in the assessment task. For a student to receive an S he/she
must be able to demonstrate that they have satisfied the requirements
for each Area of Study as specified in the SDesign.

My students complete exercises that cover all of the functions and
skills listed in the software requirements and then the task I set
contains several of these - the completion of both of these to a
satisfactory standard constitutes an S.

Antonia

Antonia Caridi
Sacre Coeur
172 Burke Road
Glen Iris 3146
Telephone 9885 4501
Fax 9885 5936

>>> "Kent Beveridge" <kbeveridge at stbc.vic.edu.au> 24/07/2007 9:43 AM
>>>
Hi listers,
I just had a look at the list Mark created to do with spreadsheeting.
I, personally, dont use (or see the need to use!) all of the above
functions on the list and hence not only need to teach them but also
learn them before I can teach them. Having just come back this year to
VCE IT, and looking at the theory to get through, I would be interested
to hear other's thoughts on the volume of work to teach at this level..
I feel that the amount of 'useable' prac to teach is over-rated and
mostly impractical in the majority of cases and that the volume of
theory combined with the SAC work makes for us really earning our
$$$$'s. Dont know about you guys out there but I really feel it!
I sometimes wish I could just teach one thing and it didnt change every
6 months - a bit like maths!
Also..trying to teach programming to year 11's who havent got a clue as
they think IT was the 'easy option' so chose it as a subject doesnt
help! It feels a bit like throwing peanuts to monkeys and then finding
out they dont like peanuts!
Lets see now...
this year I have..
taught myself VB6, JAVASCRIPT, HTML, GAMEMAKER,CHANGED JOBS, MOVED
HOUSE TO THE COUNTRY, TRIED TO LEARN ADVANCED EXCEL, DOING POSTGRAD
ONLINE STUDIES, DOING THE TA04 COURSE,,
JEEEZ, I need a holiday!

Kent Beveridge,
I.T. co-ordinator
St. Brigids Catholic Sec. College
Horsham
email.. kbeveridge at stbc.vic.edu.au

Wishes and Eggs, one you make and one you break!  A bit like
promises.....

"This email and any attachments may be confidential.  You must not
disclose or use the information in this email if you are not the
intended recipient.  If you have received this email in error, please
notify us immediately and delete the email and all copies.  The School
does not guarantee that this email is virus or error free.  The attached
files are provided and my only be used on the basis that the user
assumes all responsibility for any loss, damage or consequence resulting
directly or indirectly from the use of the attached files, whether
caused by the negligence of the sender or not.  The content and opinions
in this email are not necessarily those of the School."

________________________________

From: itapps-bounces at edulists.com.au on behalf of Russell Edwards
Sent: Tue 7/24/2007 8:53 AM
To: Year 12 Information Technology Processing and Management
Teachers'MailingList
Subject: [Year 12 IT Apps] Re: [Year 12 IPM] Suggested spreadsheet
functionsto teach for ITA U4O1

On 30/11/2006, at 9:16 PM, Mark Kelly wrote:

> A free unofficial, personal guide about how much spreadsheeting kids
> need to know for ITA U4O1...
>
> Anything I've forgotten or screwed up?
>

Your list seems eminently sensible. It's probably also worth bearing
in mind the VCAA software functions list for spreadsheets:

* lookup tables
* conditional formatting
* conditional statements
* cell protection
* graphs
* insert notes/comments
* macros
* relative and absolute cell references
* naming a range
* electronic validation
* sheet referencing
* formatting/layout.

I take "layout" to be the link to stuff about formats and
conventions, interfaces, yadda yadda yadda....

Russell

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

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

èµ__________________________________________________________________________________
This email and any attachments may be confidential and, if you are not
the intended recipient you must not disclose or use the information in
this email. If received in error, please notify the sender immediately
and delete the email and all copies. The school does not guarantee that
this email is virus or error free. Any attached files are provided and
may only be used on the basis that the recipient assumes all
responsibility for any loss, damage or consequence resulting directly or
indirectly from the use of this email and/or attached files, whether
caused by the negligence of the sender or not. The content and opinions
in this email are not necessarily those of Sacre Coeur.
____________________________________________________________________________________
_______________________________________________
http://www.edulists.com.au <http://www.edulists.com.au/>  - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian Information Technology Teachers Association Inc

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 239175 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20070724/e74acd5b/attachment-0001.bin