[Year 12 IT Apps] DB SAC

[Mark KELLY]

You wouldn't *lose* marks for adding formatting, forms, controls etc, but
you wouldn't be getting marks for them.  And spending too much time on these
things may distract students from spending time on things that *do* get
marks.

Some primitive form of input/output is necessary to get the data into the
tables and get printouts of answers produced (I get kids to print output
rather than assessing onscreen).  It's just that I/O is not much important
in U3O2.  Anyway, it's not as if it takes hours of work or masses of skill
to produce basic output !

I wouldn't panic about *adding* features, just about leaving out necessary
features.

Regards
Mark

On 26 May 2011 11:08, Mark KELLY <kel at mckinnonsc.vic.edu.au> wrote:

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



-- 
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/b4014107/attachment.html