[Year 12 IT Apps] DB SAC
Roland Gesthuizen
rgesthuizen at gmail.com
Fri May 27 11:38:17 EST 2011
Agreed, with rumours of move towards cloud based / mobile compatible
solutions. After a good decade, timely and powerful.
Regards Roland
On 27 May 2011 11:32, Cameron Bell <bell.cameron.p at edumail.vic.gov.au>wrote:
> One of the most important databases in our school is an Access db. Reports
> - Accelerus. ;)
> Cheers
> Cameron
>
>
>
> On 27/05/2011, at 11:21 AM, Roland Gesthuizen wrote:
>
> Good point Mark.
>
> A colleague in industry laughed when I suggested we were still teaching
> databases with Access .. they buy stuff off the shelf or if web based, use
> PHP SQL (ala kevork's work). He agreed that there was still potential left
> for spreadsheets for modelling or look-see applications and indicated that I
> should explore collaborative tools such as GoogleApps spreadsheets.
>
> Last month at GTASYD I saw some really impressive stuff when we touched
> base with GoogleApp scripts, bits of code you can load up into Google
> spreadsheets that were being used by teachers for a swag of different
> applications.
>
> http://edutraining.googleapps.com/Training-Home/module-5-sites/chapter-5/7-1
>
> There were plenty of good examples and help to get you going.
> http://code.google.com/googleapps/appsscript/index.html
>
> Best thing with this stuff is that it uses open standards, is free, cross
> platform and can even be used at home without licence issues.
>
> Regards Roland
>
> On 27 May 2011 08:44, Mark KELLY <kel at mckinnonsc.vic.edu.au> wrote:
>
>> Hi again, The Other Mark.
>>
>> The SS/dB choice will probably raise its head again once we've experienced
>> our first year of U3O2/U4O1. I doubt that I'll change from doing
>> spreadsheets for U4O1. My kids don't thrive on database tasks, and teaching
>> spreadsheet skills is a doddle in comparison; and the kids like them.
>>
>> Most kids already have spreadsheet experience, and the database skills in
>> U3O2 can be easily transferred to spreadsheets (formulas, IPO, interface
>> design, validation, lookups etc).
>>
>> Even if they had all year to practise databases, I doubt they would reach
>> the level they do with spreadsheets in a few short weeks. If nothing else, I
>> find the spreadsheet in U4O1 is a morale-lifter for them as their last
>> practical outcome.
>>
>> Their marks on spreadsheet outcomes are certainly streets better than that
>> from the database outcome, and that's good enough reason for me.
>>
>> As for employability skills... I don't assume that anything I teach them
>> will directly help them get a job. Anyway, nearly all of our cohort is
>> heading straight for uni where - I believe - they start from scratch when
>> teaching IT, so specific software skills are often not directly
>> transferable: unless you're lucky. But I might be mistaken about that.
>>
>> Cheers
>> Mark
>>
>>
>> On 26 May 2011 15:49, Mark Scott <msc at luther.vic.edu.au> wrote:
>>
>>> I am doing Spreadsheets for Unit 4 Outcome 1 this year.
>>>
>>>
>>> Next year I am thinking about doing Databases instead.
>>>
>>> It would seem logical to just extend the students skill set in one
>>> software type.
>>>
>>>
>>> Any thoughts, anybody?
>>>
>>>
>>> Mark Scott
>>>
>>> Luther College
>>>
>>> “We are what we pretend to be, so we must be careful what we pretend to
>>> be”
>>>
>>>
>>> *From:* itapps-bounces at edulists.com.au [mailto:
>>> itapps-bounces at edulists.com.au] *On Behalf Of *Mark KELLY
>>> *Sent:* Thursday, 26 May 2011 3:34 PM
>>>
>>> *To:* Year 12 IT Applications Teachers' Mailing List
>>> *Subject:* Re: [Year 12 IT Apps] DB SAC
>>>
>>>
>>>
>>> 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.
>>>
>>> _______________________________________________
>>> 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.
>>
>> _______________________________________________
>> 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
>>
>
>
>
> --
> --
> Roland Gesthuizen - eLearning Coordinator - Keysborough Secondary College
>
> "Never doubt that a small group of thoughtful, committed citizens can
> change the world; indeed it is the only thing that ever has." --Margaret
> Mead
> _______________________________________________
> 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
>
>
> *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.
>
> _______________________________________________
> 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
>
--
--
Roland Gesthuizen - eLearning Coordinator - Keysborough Secondary College
"Never doubt that a small group of thoughtful, committed citizens can change
the world; indeed it is the only thing that ever has." --Margaret Mead
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110527/7b73402f/attachment-0001.html
More information about the itapps
mailing list