[Year 12 IT Apps] Software for outcomes?

[Mark]

Hi Daryl

If you just need to know the VCAA-mandated RDBMS functions for 2016+
<http://www.vcaa.vic.edu.au/Documents/vce/computing/InformaticsSoftwareToolsFunctions.docx>,
they are:


   - create tables
   - create relationships between tables
   - use a range of data types
   - electronically validate data
   - create, edit and use queries
   - search and filter records
   - perform calculations
   - create and edit formatted reports
   - sort records or index on different fields.

That would include (IMHO)


   - MS Access,
   - Filemaker Pro (but be conscious of examiners' inbuilt antipathy
to Filemaker's
   calculated fields and - maybe - lack of a "maintain referential integrity"
   option, and lack of input masks [which may have been implied in the 2015
   ITA exam]),
   - MySQL with a GUI front-end, and
   - OpenOffice or LibreOffice (have not tried them in recent years. Can't
   speak for their functionality or ease of use)
   - KellyBase (a new and exciting RDBMS written in 'Scratch' and available
   sometime in 2020 for only $600,000 per seat. Order NOW! Pre-payment is
   *mandatory*. Delivery is *not* guaranteed.)

Cheers

Mark

On 18 November 2015 at 13:21, Croke, Daryl D <
croke.daryl.d at edumail.vic.gov.au> wrote:

> Hi all
>
> We are running Informatics in 2016 for the first time.
>
> Needs some advice on software requirement for databases. What options are
> there? Class will run in a PC lab.
>
> Cheers
>
> Daryl Croke
>
> Senior School eLearning Leader
> Mount Ridley College
> 8338 3600
> http://mountridleycollege.vic.edu.au/
>
> *keep on coding*
>
> *http://geekstuff.global2.vic.edu.au/
> <http://geekstuff.global2.vic.edu.au/>
> http://physicalcomputing.global2.vic.edu.au/
> <http://physicalcomputing.global2.vic.edu.au/>*
>
>
> *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 Training.
>
> _______________________________________________
> 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 <br>
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools - Swinburne University
>



-- 

Mark Kelly

mark at vceit.com
http://vceit.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20151118/c410dac4/attachment.html