[Year 12 IT Apps] 2011 VCAA Sample Exam

Wed Oct 17 07:54:20 EST 2012

Hi folks. As I read it, a storyboard is not the same as a mockup. It's like
a sitemap, but it shows navigational controls within pages. So I still
would say a storyboard contains more navigational information than a
sitemap does.

And for Q9 yes - I misread the question (d'oh!) and missed the reference to
"in the customer table". I merrily assumed it was the Book Table.

On 16 October 2012 19:17, Joyce Tabone <jtabone at aitkencollege.edu.au> wrote:

> Hi Gary
>
> Just adding my two cents worth ....
>
> I agree with both of your answers
>
> A Sitemap shows the relationship between pages in a website, so would be
> more useful as a navigational tool than a storyboard which is a visual
> representation of an actual web page.
>
> The book Id in the customer table links the two tables together. The
> customer Id in the customer table would be the primary key.
>
> It was great that VCAA gave as a sample exam, but it would have been more
> helpful to have also supplied their answers to do away with this sort of
> discussion ....
>
>
> Joyce
> ________________________________________
> From: itapps-bounces at edulists.com.au [itapps-bounces at edulists.com.au] on
> behalf of Vear, Gary D [vear.gary.d at edumail.vic.gov.au]
> Sent: Tuesday, October 16, 2012 6:06 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] 2011 VCAA Sample Exam
>
> Hi all,
>
> I share Mark's view with respect to Q7 in Section A in that "ease of use"
> should be considered a measure of effectiveness rather than efficiency, but
> unless I've misread the situation then it appears that the VCAA has
> published some very confusing documentation on this point.
>
> For example, if you go to the following webpage, you will find "ease of
> use" listed under the definition for effectiveness:
> http://vels.vcaa.vic.edu.au/ict/glossary.html
>
> And yet, if you look in the Glossary section of the current Study Design
> you will find written under the definition for efficiency the claim that
> "measures of an efficient solution include...the ease of use of the
> solution..." (see page 13 of the following document:
> http://www.vcaa.vic.edu.au/Documents/vce/infotech/infotechsd2011-2014.pdf
> ).
>
> Okay, so which is which?  Please bear in mind that I have not taught IT
> Applications prior to this year, so I have no prior knowledge of any prior
> debates over these definitions that may exist.  In either case, it seems
> that one of the two definitions referenced above should be removed to avoid
> potential future confusion.
>
> **********
>
> For a couple of other questions in Section A, I felt that other answers
> were "more correct" (sorry to disagree, Mark):
>
> Q5 = A. sitemap (though I understand Mark's reasoning, I have suggested
> this answer to my students as being the best choice based on the textbook)
> and
>
> Q9 = B. foreign key (unless I have COMPLETELY misunderstood relational
> databases).
>
> I'd appreciate learning what others think about these questions in
> particular.
>
> Thanks,
> Gary
>
>
> ________________________________
> From: itapps-bounces at edulists.com.au [itapps-bounces at edulists.com.au] on
> behalf of Mark KELLY [kel at mckinnonsc.vic.edu.au]
> Sent: Tuesday, 16 October 2012 3:05 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] 2011 VCAA Sample Exam
>
> Thank ye kindly, good sir.  Kevork and I produced answers for the SD
> sample questions<
> http://www.vceit.com/studydesign/SD-sample-answers-2011.htm>, but I
> haven't had much of a look at the ITA questions before, but here are some
> sample answers for the sample questions...  For those impatient to find my
> answer to Anthony's question, jump to the end.
>
> Section A
>
> 1. A
> 2. B
> 3. D
> 4. A
> 5. B (a storyboard has more navigational detail than a sitemap)
> 6. C
> 7. A (I still argue that 'ease of use' should be an effectiveness
> criterion rather than being put efficiency. I think 'ease of use' has been
> confused with 'amount of labour' (e.g. manhours). Anyway...
> 8. C?
> 9. C
>
> Section B
>
> 1a. Gender.
> 1b. It could show years of birth rather than ages, since people tend to
> remember a YOB even if their arithmetic is so bad that they can't calculate
> their current age.
> 1c. Provide a privacy policy, use SSL or TLS secure connections, offer
> prizes.
> 1d. They can receive information that may be useful or valuable to them.
> e.g.  they can find that a pain in the leg could mean the leg is broken.
> 1e. If one table lists all the drugs, another table could consist of pairs
> of drug IDs and corresponding descriptions of risks that may exist when the
> 2 drugs are taken together.
>
> 2. It would require high bandwidth capabilities to cope with video
> streaming.
>
> 3a. Gender (but it's a bad choice of field to ask that question about. It
> would be better as a true/false field)
> 3b. CamelCase - so multi-word names are more readable. Hungarian Notation
> - to identify variable/object types as well as naming them, so they are not
> accidentally treated as a different type of data or object.
> 3c. First normal form: divide address_suburb into separate fields. Second
> normal form: create a unique user ID field.
> 3d. Normalisation removes most data duplication, which makes data
> maintenance easier and data inconsistencies easier to find.
> Having links between related fields allows you to enforce referential
> integrity so key fields cannot be deleted if they have related fields that
> would be made 'orphans'.
> Having tables that contain all allowable values of a field (e.g. states of
> Australia, product codes) let you enforce validation so data input has to
> exist in the limited list of the values present in that table
>
> 4. subject = Entity.
> supervises = Relationship.
> Firstname = attribute.
> MarkID = key field? (why are some attributes shaded and some are not? Does
> it mean white attributes are separate elements to grey ones?)
> But it's a dodgy ERD: no cardinality (1/many indicators) are included.
> More ERD info<http://vceit.com/slideshows/Design-Tools-ERD.ppt>.
>
> 5a. This is a vague one - what is it after? The webpage order form mails
> the data in the form's fields to the organisation? The webpage uses some
> PHP or similar coding to process the data in the order form and store it in
> a MySQL database?  Such vague question annoy me.
> 5b. So they can sell products and make a profit.  So they know what the
> customer wants to buy, where to send the goods, and how to charge the
> purchaser. A silly question unless I've missed something...
> 5c. Post a privacy policy saying how the collected data will be used.
> Encrypt the web communications so personal/financial data cannot be
> intercepted. Protect the stored data from unauthorised use.
>
> 6a. Surnames are often not unique, and the wrong members may be identified.
> 6b. A phone number could contain spaces, dashes, parentheses, + symbols
> etc that cannot be stored in a numeric field.
> 6c. Radio button - it forces people to enter one (and only one) valid
> response.
>
> 7. SS - sort products by sales quantities, graph products' sales, use
> conditional formatting to highlight sales below average.  Do the same
> things by suburb instead of products.
> RDBMS - create a summary field [Filemaker Pro] that sums a product's sales
> across all suburbs. Create a find (query) to select suburbs/products that
> fall below a target value. Use a layout (report) to display/print the
> products and/or suburbs. Last year the average mark for the 8 mark question
> was 2... not a happy first time out for the ambitious 8-marker!
>
> 8a. Usernames & passwords. She'd need to password-protect a folder on the
> site that requires a valid username/password before a visitor can enter the
> folder.
> 8b.Once again, the case study does not give enough information to decide
> if the Privacy Act applies.  Kids would have to explain their reasoning...
> If NowKitchens turns over more than $3 per annum, it would be subject to
> the Privacy Act 1988 which requires holders of personal information to
> protect the information from unauthorised access (e.g. by other customers).
> It also prevents NowKitchens from using the information for a purpose other
> than for which it was originally collected.
>
> 9. Antivirus scanners up to date and running; firewall to prevent hackers
> getting in; encryption of sensitive or personal information being stored
> (e.g. PGP) or communicated (TLS on the web, WPA2 on Wifi); physical
> security of computer resources; regular, tested backups of data stored
> offsite; training of staff to prevent them falling prey to social
> engineering (e.g. phishing, opening attachments, giving passwords over the
> phone). An org should protect customer data carefully whether or not it's
> subject to the Privacy Act, Health Records Act, or Info Privacy Act (go on
> about the things that makes an org
> subject to these acts); conduct penetration tests and/or software audits
> to find holes in security; use passwords to protect equipment, documents,
> data from misuse.  etc.
>
> 10a.  They can all access and share the same data at the same time, so
> they always get up-to-date information. They can collaborate easily, e.g.
> joint simultaneous editing of a document.
> 10b. Cloud backup is slow, e.g. to copy a 100M document would take many
> minutes even with a fast internet connection, compared to seconds to save
> it to hard disk. The cloud service provide may not be reliable: they may
> misuse backed-up data, go out of business suddenly (e.g. MegaUpload), or
> suddenly cancel the company's account and lock them out of their data (e.g.
> Google).
>
> This brings us to the original question asked by Anthony.
>
> The actual full question is, "Outline a procedure for the disposal of
> client data that Stratospheric Solutions could follow when using cloud
> computing." which gives clue or two more. It is not referring to a
> procedure used by the cloud service provider.
>
> But the answer is still "just delete the client data": they would not be
> able to wipe/overwrite it since the storage device upon which the data are
> stored on is beyond their control.  I don't see what else a kid could offer
> to earn 3 marks.
>
>
> Quibbles, additions, corrections are welcome.
>
>
>
>
>
>
>
>
>
>
> On 16 October 2012 13:09, Watson, Donald R <
> watson.donald.r at edumail.vic.gov.au<mailto:
> watson.donald.r at edumail.vic.gov.au>> wrote:
> This what you’re after?
>
> http://www.vcaa.vic.edu.au/Documents/vce/infotech/IT-Apps-samp.pdf
>
> Don Watson
>
> 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: Tuesday, 16 October 2012 12:42 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] 2011 VCAA Sample Exam
>
> Hmmm. When I try to download the sample questions<
> http://www.vcaa.vic.edu.au/vcaa/vce/studies/infotech/it-applications/publications/IT-Apps-samp.pdf>
> from the VCAA site, I'm getting a mangled 666 byte file.
>
> But taking a rough stab at the question, I'd say: "Select the file and
> click 'DELETE'".
>
> Pretty easy 3 marks...
>
> Unless it's an ambiguous question and it's referring to how the cloud
> computing host would dispose of deleted data (e.g. flushing all duplicates
> on all their servers, clearing the cache, wiping the file from hard disks,
> erasing the file from archives...)
>
> But I'd still believe that a kid would have to earn 3 marks for saying
> "Click Delete".
>
> On 16 October 2012 11:58, Anthony Sullivan <asullivan at tps.vic.edu.au
> <mailto:asullivan at tps.vic.edu.au>> wrote:
> Question 10
> Outline a procedure to dispose of data stored in the cloud
> 3 marks
>
> Can someone explain to me the solution to the above question?
>
>
>
> Anthony  Sullivan
> Head of Information Technology
>
> T: 03 9788 7796<tel:03%209788%207796> | F: 03 9787 7646<tel:03%209787%207646>
> | Wooralla Drive, Mt. Eliza, Vic, 3930 | asullivan at tps.vic.edu.au<mailto:
> asullivan at tps.vic.edu.au> | www.tps.vic.edu.au<http://www.tps.vic.edu.au>
>
> [cid:image001.gif at 01CDAB9F.6E522780]
>
> Please consider the environment before printing this email, you will save
> 5g of paper, 250mL of water and at least 35gm of CO2
>
> This message, including any attachments, is provided without
> responsibility in law for its accuracy or otherwise and without assumption
> of a duty of care by the school. Whilst every attempt has been made to
> ensure material in this e-mail message is free from computer viruses or
> other defects, the attached files are provided, and may only be used, on
> the basis that the user assumes responsibility for the use of the material
> transmitted. This e-mail is intended for the use of the named individual or
> entity and may contain confidential and privileged information. Any
> dissemination, distribution or copying by anyone other than the intended
> recipient of this e-mail is strictly prohibited. If this e-mail has been
> received in error then please notify The Peninsula School immediately and
> destroy the original message.
>
>
> --
> 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.
>
>
>
>
> 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 <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
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/20121017/1e3bf345/attachment-0001.html 