[Year 12 IT Apps] U3O2 - Relational Databased + Access

[Smallacombe, Kate B]

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<http://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<mailto: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<mailto: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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20120423/1866f42c/attachment.html