[Year 12 IT Apps] DB SAC

Thu May 26 15:15:46 EST 2011

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.
------------------------------------------