[Year 12 IT Apps] DB SAC

Litsa Tzelepis htzelepis at msj.vic.edu.au
Thu May 26 21:50:45 EST 2011 

Hello.

Maybe I missed something but, when I look at the RDMS functions to teach for 
U3-O2, there is no mention of forms.
So when it says "electronic validation", I taught ranges, list boxes, input 
masks, etc.
If we don't have to use forms, is it unreasonable to enter data into tables 
and create the queries from there?
I showed my students how to create forms and generate reports, to give them 
a complete look at databases (some students have not studied dB's before), 
but clarified they only utilise tables and queries for the SAC.

Is this ok?
Thank-you, Litsa

----- Original Message ----- 
From: "Jackson Bates" <bates.j at wcc.vic.edu.au>
To: <itapps at edulists.com.au>
Sent: Thursday, May 26, 2011 3:15 PM
Subject: Re: [Year 12 IT Apps] DB SAC


> Hi All,
>
> Could someone address Mark Scott's other comment that drop down lists are 
> inappropriate in tables?
>
> I'd assumed we could credit drop down lists in tables for validation 
> purposes, since forms are not mandated in this study for unit 3.
>
> Please correct me if I'm wrong, since I've been merrily showing my kids 
> how to do that and would hate to have to penalise them now :)
>
> Thanks,
>
> Jackson Bates
> Waverley Christian 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: Thursday, 26 May 2011 11:36 AM
> To: itapps at edulists.com.au
> Subject: itapps Digest, Vol 75, Issue 49
>
> 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. DB SAC (Mark Scott)
>   2. Re: DB SAC (Mark KELLY)
>   3. Assessment handbook ambiguity (Mark KELLY)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 26 May 2011 10:47:19 +1000
> From: Mark Scott <msc at luther.vic.edu.au>
> Subject: [Year 12 IT Apps] DB SAC
> To: "Year 12 IT Applications Teachers' Mailing List"
>        <itapps at edulists.com.au>
> Message-ID:
>        <8EB7758DBE426346943A36370038F9B9EB3DB203E4 at lcexch02.luther.local>
> Content-Type: text/plain; charset="us-ascii"
>
>
> HELP!!!!!!!!
>
>>From VCAA
> 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.
>
> Can someone confirm that:
>
>
> *        formatting (apart from sorting) is not a part of this SAC?
>
>
> *        drop down lists are not appropriate for tables (only forms)
>
> Mark Scott
> Luther College
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: 
> http://www.edulists.com.au/pipermail/itapps/attachments/20110526/f361ff88/attachment-0001.html
>
> ------------------------------
>
> Message: 2
> Date: Thu, 26 May 2011 11:08:56 +1000
> From: Mark KELLY <kel at mckinnonsc.vic.edu.au>
> Subject: Re: [Year 12 IT Apps] DB SAC
> To: "Year 12 IT Applications Teachers' Mailing List"
>        <itapps at edulists.com.au>
> Message-ID: <BANLkTin+B1RJy4xd02r50tTVUiL5d-uAHQ at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi, OtherMark
>
> Formatting is not important to this outcome, but it is assessable if RDBMS 
> is used for U4O1...
>
> *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.*
>
>
>
> On 26 May 2011 10:47, Mark Scott <msc at luther.vic.edu.au> wrote:
>
>>
>>
>> HELP!!!!!!!!
>>
>>
>>
>> From VCAA
>>
>> *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.*
>>
>>
>>
>> Can someone confirm that:
>>
>>
>>
>> ?        formatting (apart from sorting) is not a part of this SAC?
>>
>> ?        drop down lists are not appropriate for tables (only forms)
>>
>>
>>
>> Mark Scott
>>
>> Luther College
>>
>> _______________________________________________
>> 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
>>
>
>
>
> --
> 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 VCE IT 
> Lecture Notes: http://vceit.com
> Moderator: IT Applications Edulist
>
> Want a good time? Call 0112358. Ask for Mr Fibonacci.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: 
> http://www.edulists.com.au/pipermail/itapps/attachments/20110526/c25f9190/attachment-0001.html
>
> ------------------------------
>
> Message: 3
> Date: Thu, 26 May 2011 11:34:39 +1000
> From: Mark KELLY <kel at mckinnonsc.vic.edu.au>
> Subject: [Year 12 IT Apps] Assessment handbook ambiguity
> To: "Year 12 IT Applications Teachers' Mailing List"
>        <itapps at edulists.com.au>
> Message-ID: <BANLkTi=Yf+u4MSm7Djx0YpSeyPMr46RWdw at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi all.  A minor quibble or two about the wording in the Assessment 
> Handbook for ITA U3O2 task 2 (page 15):  "Techniques for acquiring data 
> via websites are technically feasible..."
>
> It could mean techniques used by the *public* to acquire data from 
> websites, or it could mean techniques used by the *website operator* to 
> acquire data by using their website.
>
> I've been assuming it meant the latter, because one of the KK is 
> "techniques used *by organisations* to acquire data on websites".
>
> Also the use of "individuals" to mean "website visitors" and 
> "organisations"
> to mean "website operators" can be unclear.  Many individuals have 
> websites.  It would be better to identify them as visitors and operators 
> respectively.
>
> Cheers
>
> --
> 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 VCE IT 
> Lecture Notes: http://vceit.com
> Moderator: IT Applications Edulist
>
> Want a good time? Call 0112358. Ask for Mr Fibonacci.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: 
> http://www.edulists.com.au/pipermail/itapps/attachments/20110526/29899b8a/attachment.html
>
> ------------------------------
>
> _______________________________________________
> itapps mailing list
> itapps at edulists.com.au
> http://www.edulists.com.au/mailman/listinfo/itapps
>
>
> End of itapps Digest, Vol 75, Issue 49
> **************************************
>
> ________________________________
>
> [WCCSIG]
>
> ------------------------------------------
> 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.
> ------------------------------------------
>
> _______________________________________________
> 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

More information about the itapps mailing list