[Year 12 IT Apps] advice on exam

Thu Aug 30 13:00:25 EST 2012

Hi Mark and the list

In reference to the below message about the VCAA mandated skills for the different SACs. Just having some thoughts on revision for this year.

What Microsoft Access skills do you think could be on the end of year exam? For example, in previous exams there have been questions on normalisation, relationships, data types....

Do you think there will be any in particular skills that students should focus on?

Thanks

Michael

Glenroy College

-----Original Message-----
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of itapps-request at edulists.com.au
Sent: Monday, 23 April 2012 12:49 PM
To: itapps at edulists.com.au
Subject: itapps Digest, Vol 86, Issue 28

Send itapps mailing list submissions to
	itapps at edulists.com.au

To subscribe or unsubscribe via the World Wide Web, visit
	http://www.edulists.com.au/mailman/listinfo/itapps
or, via email, send a message with subject or body 'help' to
	itapps-request at edulists.com.au

You can reach the person managing the list at
	itapps-owner at edulists.com.au

When replying, please edit your Subject line so it is more specific than "Re: Contents of itapps digest..."

Today's Topics:

   1. Re: U3O2 - Relational Databased + Access (Mark KELLY)
   2. Re: itapps Digest, Vol 86, Issue 27 (Jackson Bates)
   3. Re: U3O2 - Relational Databased + Access (Jackson Bates)

----------------------------------------------------------------------

Message: 1
Date: Mon, 23 Apr 2012 12:05:06 +1000
From: Mark KELLY <kel at mckinnonsc.vic.edu.au>
Subject: Re: [Year 12 IT Apps] U3O2 - Relational Databased + Access
To: "Year 12 IT Applications Teachers' Mailing List"
	<itapps at edulists.com.au>
Message-ID:
	<CAGLnYS6Ld98-=1DLFtK94PnC++TfSHSDjt_MfDiw_LHjOHKFRg at mail.gmail.com>
Content-Type: text/plain; charset="windows-1252"

I used Filemaker so it wasn't the same for me.
IMO, creating forms isn't too onerous, and it's a very basic and vital skill.

On 23 April 2012 10:18, Smallacombe, Kate B < smallacombe.kate.b at edumail.vic.gov.au> wrote:

>  Hi all,****
>
> ** **
>
> I?ve read the list below of what?s required for U3O2. Just wondering, 
> do you teach forms as part of this outcome or can students just enter 
> the data directly into the tables?****
>
> ** **
>
> Cheers,****
>
> ** **
>
> Kate Smallacombe****
>
> Brighton Secondary College****
>
> 120 Marriage Road****
>
> Brighton East 3187****
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au [mailto:
> itapps-bounces at edulists.com.au] *On Behalf Of *Mark KELLY
> *Sent:* Thursday, 19 April 2012 11:00 AM
>
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] U3O2 - Relational Databased +
> Access****
>
> ** **
>
> You could look at Greg Bowden's Guided computer tutorials. 
> (gct.com.au)
>
>
> As for level of difficulty, here are VCAA's mandated skills...****
>
> The following functions apply to ITA 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 ITA, 
> 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.****
>
> ** **
>
> On 19 April 2012 09:07, POLLOCK, Benn(POL) 
> <POL at wantirnacollege.vic.edu.au>
> wrote:****
>
> Currently, my students are completing some in-class tutorials on 
> creating relational databases for their SAC. We have 2010 Access at 
> our school however I can?t seem to find many good tutorials to help 
> teach them. I?m also new to access so trying to wrap my head around 
> everything at the same time has been a little daunting. I?m also not 
> sure about the complexity of the required relational database that the 
> students are required to complete. Can someone give me an insight into 
> the complexity that they?re expecting from their students?  ? Also If 
> anyone has any links to resources or wants to share some of their 
> class tutorials with me ? I would be very grateful. ****
>
>  ****
>
> Cheers****
>
>  ****
>
> Benn Pollock****
>
> Information Technology Teacher****
>
> Wantirna College****
>
> *Ph:* 9801 9700****
>
>  ****
>
>  ****
>
>
> _______________________________________________
> 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 <br> 
> http://www.vitta.org.au  - VITTA Victorian Information Technology 
> Teachers Association Inc <br> http://www.swinburne.edu.au/ict/schools
> - Swinburne University****
>
>
>
>
> --
> Mark Kelly
> Manager of ICT, Reporting, IT Learning Area McKinnon Secondary College 
> McKinnon Rd McKinnon 3204, Victoria, Australia Direct line / 
> Voicemail: +613 8520 9085, Fax +613 9578 9253 
> kel at mckinnonsc.vic.edu.au (don't use my Edumail account!) VCE IT 
> Lecture Notes: http://vceit.com
> Moderator: IT Applications Edulist
>
> --
> An E-flat, a C, and a G go into a bar. The bartender says, "I'm sorry, 
> but I can't serve minors."
>
> ****
>
> *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 <br> 
> http://www.vitta.org.au  - VITTA Victorian Information Technology 
> Teachers Association Inc <br> http://www.swinburne.edu.au/ict/schools 
> - Swinburne University
>

--
Mark Kelly
Manager of ICT, Reporting, IT Learning Area McKinnon Secondary College McKinnon Rd McKinnon 3204, Victoria, Australia Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253 kel at mckinnonsc.vic.edu.au (don't use my Edumail account!) VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist

--
An E-flat, a C, and a G go into a bar. The bartender says, "I'm sorry, but I can't serve minors."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20120423/518a208f/attachment-0001.html 

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.