[Year 12 IT Apps] DB SAC

[Adric Gardner]

Hey Mark,

 

I think it makes a great deal of sense.  I also believe that it provides
students with genuinely more employability skills.  That said, I've had to
revert back to the spreadsheet task for U401.

 

The distinctions that you can make between U3O2 and U4O1 is the use of forms
to collect data, reports to present data an increased focus on validation.
This is in addition to the obvious on screen user documentation.  

 

I based the U302 on the MYSQL workbench (which includes an EER diagram
component that can be forward engineered).  This exposes them to the
"SELECT" SQL query statements which is the only 'coding' they need to do.  I
required them to design the forms and reports on paper identifying the
validation requirements and the fields (including calculated fields) that
were needed for each report. This allows you to create a relatively simple
(short - 5 periods is all I'm spending) U3O2 while testing all of the Key
skills and knowledge.

 

My intention was to use link the database using Dreamweaver with php pages
to do U4O1.  Given the database tools and creation of recordsets, insert,
update and dynamic data sets there is no need for coding knowledge, but
those students who do have that experience can benefit. 

 

The only reason that I had to back out from it was that the version of
Dreamweaver that the school (Macromedia Dreamweaver 8) had didn't have the
spry form functions which I had assumed when I planned at the beginning of
the year.  This would have meant that the kids would have had to learn some
coding (which I dearly wanted to avoid).

 

I feel that I'm starting to ramble now,  I hope that my thoughts are useful
and that they're not too ignorant.

 

Cheers,

 

Adric

 

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Mark Scott
Sent: Thursday, 26 May 2011 3:50 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] DB SAC

 

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.


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110526/f0603fc5/attachment-0001.html