[Year 12 IT Apps] DB SAC
Paul Golub
golupau at santamaria.vic.edu.au
Thu May 26 15:34:26 EST 2011
Hi Jackson,
I'm in the same boat. I showed my kids drop down lists in tables as a form of validation.
I actually thought this was a good way to validate data such as Australian States.
Paul Golub
Santa Maria College
50 Separation Street
Northcote 3070
Ph: 9488 1674
-----Original message-----
From: Jackson Bates bates.j at wcc.vic.edu.au
Date: Thu, 26 May 2011 15:15:46 +1000
To: "itapps at edulists.com.au" itapps at edulists.com.au
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
_____________________________________________________________________________
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 College does not guarantee that this
email is virus or error free. The attached files are provided and may 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 College
____________________________________________________________________________
More information about the itapps
mailing list