[Year 12 IT Apps] NINE mark question??
Jackson Bates
bates.j at wcc.vic.edu.au
Wed Nov 14 17:43:00 EST 2012
Thanks, Mark.
Are you sure about:
Question 16
Determining the scope of a solution includes
A. identifying the functions the solution has to provide.
B. determining what the solution can and cannot do.
C. identifying the constraints of the solution.
D. planning the appearance of the solution.
Answer is A. That's what scope means.
The study design states that scope includes "What can the solution do? What can't the solution do? What are the benefits of the solution to the user? The scope states the boundaries or parameters of the solution. Benefits can be stated in terms of their efficiency and effectiveness." So I think the answer is B.
The study design also states that determining solution requirements includes "What information does the solution have to provide? What data is needed to produce the information? What functions does the solution have to provide? These requirements can be classified as being functional, namely what the solution is required to do, and non-functional, which describes the attributes the solution should possess, such as user-friendliness, reliability, portability, robustness, maintainability. Tools to assist in determining the solution requirements include context diagrams, data flow diagrams and use cases."
So A, according to the SD, would fall under determining solution requirements.
Sorry to nit-pick, and thanks for all your hard work. Truth be told, I wouldn't be half the IT teacher I am without you!
Regards,
Jackson Bates
Waverley Christian College
On 14/11/2012, at 4:30 PM, "itapps-request at edulists.com.au<mailto:itapps-request at edulists.com.au>" <itapps-request at edulists.com.au<mailto:itapps-request at edulists.com.au>> wrote:
Send itapps mailing list submissions to
itapps at edulists.com.au<mailto: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<mailto:itapps-request at edulists.com.au>
You can reach the person managing the list at
itapps-owner at edulists.com.au<mailto: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. Re: NINE mark question?? (Mark KELLY)
----------------------------------------------------------------------
Message: 1
Date: Wed, 14 Nov 2012 16:23:54 +1100
From: Mark KELLY <kel at mckinnonsc.vic.edu.au<mailto:kel at mckinnonsc.vic.edu.au>>
Subject: Re: [Year 12 IT Apps] NINE mark question??
To: "Year 12 IT Applications Teachers' Mailing List"
<itapps at edulists.com.au<mailto:itapps at edulists.com.au>>
Message-ID:
<CAGLnYS5S4XvmA47-+SeGG+vkR=u9qhPdfpKEkrTH4ZqknK37_A at mail.gmail.com<mailto:CAGLnYS5S4XvmA47-+SeGG+vkR=u9qhPdfpKEkrTH4ZqknK37_A at mail.gmail.com>>
Content-Type: text/plain; charset="iso-8859-1"
I've normalised myself with a jolly nice Chardonnay, and my solution to the
question is at http://www.vceit.com/postmortems/2012ita/ita2012.htm
I've yet to proofread it for howlers, but it's basically finished.
And the normalisation question was a pig to work on. It took me 30 minutes,
with one or two false starts, to explain it halfway clearly. And I fear
even now it's not strictly accurate.
Dog only know how even the best kids coped.
On 14 November 2012 10:35, Mark Scott <msc at luther.vic.edu.au<mailto:msc at luther.vic.edu.au>> wrote:
** **
** **
Peter ****
** **
I would have separated the DB into three tables as part of 2NF and then
got rid of the Total fee calculation field as 3NF****
** **
And students should at least show the completed Relationship Diagram.****
** **
Tricky part is explaining how each (do they mean separately?) normal form
ensures the integrity of data.****
** **
But I will wait and see what the gurus have to say (you out there Mark K?)
****
** **
thanks****
Mark Scott****
Luther College****
** **
*From:* itapps-bounces at edulists.com.au<mailto:itapps-bounces at edulists.com.au> [mailto:
itapps-bounces at edulists.com.au<mailto:itapps-bounces at edulists.com.au>] *On Behalf Of *Peter Langham
*Sent:* Wednesday, 14 November 2012 10:05 AM
*To:* Year 12 IT Applications Teachers' Mailing List
*Subject:* Re: [Year 12 IT Apps] NINE mark question??****
** **
Here's my attempt at the normalisation question****
****
1NF - No lists of data in any cell. ****
Divide the data in any of the memberName, memberAddress, driverName
fields. ****
memberAddress becomes: memberAddress becomes memberAddress and
memberPostcode****
E.g. ****
memberAddress : 2 Hill St****
memberSuburb : Richmond****
This allows for more specific queries. E.g. Filtering data by Suburb.****
****
2NF - each non-key field must be fully dependent on the key****
yearsWorked is dependent on driverName. Make a seperate table where
driverName is the Primary Key and it is a Foreign Key in the memberName
table.****
Table 1: memberName, memberAddress, driverName (foreign key), carRate($),
totalFee($)****
Table 2: driverName (primary key), yearsWorked****
This ensures data integrity as the yearsWorked data would only need to be
updated in the one cell now instead of multiple cells.****
****
3NF - every field in a table must relate directly to the primary key
carRate($) is dependent on the size of the car. I'd add a foreign key
field to table1 carSize which would become a primary key field in the third
table.****
Table 1: memberName, memberAddress, driverName (foreign key), carSize
(foreign key) ****
Table 2: driverName (primary key), yearsWorked****
Table 3: carSize, carRate($)****
****
This leaves us with what I beleive should be a calculated field,
totalFee($).****
totalFee($): [yearsWorked]*[carRate($)]****
****
I may have 2NF and 3NF in the wrong order.****
****
Unfortunately, I didn't go over this in a lot of depth with my students, I
expected that they would have the choice of which Normal Form they solved
for, like the VCAA sample exam so we focused on 1NF more heavily than the
other two normal forms.****
****
Peter Langham****
Narre Warren South P-12****
****
On Wed, Nov 14, 2012 at 9:30 AM, Mark Scott <msc at luther.vic.edu.au<mailto:msc at luther.vic.edu.au>> wrote:
****
****
Mark****
****
It will be Q9 (the Normalisation one) that will be the one most poorly
answered.****
****
I am looking forward to seeing your solution for that one.****
****
J****
****
Mark Scott
Luther College****
****
*Mark Scott **
*Daily Administrator
Luther****
Plymouth Road
Croydon Hills Victoria 3136****
Luther****
Telephone (03) 9724 2000
Direct Line (03) 9724 2023 ****
www.luther.vic.edu.au<http://www.luther.vic.edu.au> ****
[image: Luther College] <http://www.luther.vic.edu.au/>****
*Please consider the environment before printing this email.*****
This email and any attachments may contain privileged and confidential
information.
If you are not the intended recipient you may not distribute or reproduce
this email
or attachments. If you have received this message in error please notify
us by return mail.****
****
** **
*From:* itapps-bounces at edulists.com.au<mailto:itapps-bounces at edulists.com.au> [mailto:
itapps-bounces at edulists.com.au<mailto:itapps-bounces at edulists.com.au>] *On Behalf Of *Mark KELLY
*Sent:* Wednesday, 14 November 2012 9:15 AM
*To:* Year 12 IT Applications Teachers' Mailing List
*Subject:* [Year 12 IT Apps] NINE mark question??****
****
I wonder what the logic was behind changing the eight mark question into a
nine mark question.****
****
Was it something like, "Let's take the question that was most poorly
answered last year and make it even more difficult." ?
****
****
--
Mark Kelly - kel at mckinnonsc.vic.edu.au<mailto:kel at mckinnonsc.vic.edu.au>
Manager of ICT, Reporting, IT Learning Area
McKinnon Secondary College, McKinnon Rd, McKinnon 3204, Victoria, Australia
Phone: +613 8520 9085, Fax +613 9578 9253
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist<http://edulists.com.au/itapps/index.htm>
Visit Diigo links for ITA <http://groups.diigo.com/group/vce-info-tech>and
SD <http://groups.diigo.com/group/vce-sd>
--
My personal best for the 100 metre sprint is 11.9 metres.
****
_______________________________________________
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****
** **
_______________________________________________
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 - kel at mckinnonsc.vic.edu.au<mailto:kel at mckinnonsc.vic.edu.au>
Manager of ICT, Reporting, IT Learning Area
McKinnon Secondary College, McKinnon Rd, McKinnon 3204, Victoria, Australia
Phone: +613 8520 9085, Fax +613 9578 9253
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist <http://edulists.com.au/itapps/index.htm>
Visit Diigo links for ITA <http://groups.diigo.com/group/vce-info-tech> and
SD <http://groups.diigo.com/group/vce-sd>
--
My personal best for the 100 metre sprint is 11.9 metres.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20121114/67791260/attachment.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 12076 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20121114/67791260/attachment.png
------------------------------
_______________________________________________
itapps mailing list
itapps at edulists.com.au<mailto:itapps at edulists.com.au>
http://www.edulists.com.au/mailman/listinfo/itapps
End of itapps Digest, Vol 93, Issue 35
**************************************
Scanned by the Netbox from Netbox Blue
(http://netboxblue.com/)
________________________________
------------------------------------------
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.
------------------------------------------
Scanned by the Netbox from Netbox Blue
(http://netboxblue.com/)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20121114/543eef06/attachment-0001.html
More information about the itapps
mailing list