Thank ye kindly, good sir. Kevork and I produced <a href="http://www.vceit.com/studydesign/SD-sample-answers-2011.htm">answers for the SD sample questions</a>, 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.<br>
<br>Section A<br><br>1. A<br>2. B<br>3. D<br>4. A<br>5. B (a storyboard has more navigational detail than a sitemap)<br>6. C<br>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...<br>
8. C?<br>9. C<br><br>Section B<br><br>1a. Gender.<br>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.<br>
1c. Provide a privacy policy, use SSL or TLS secure connections, offer prizes.<br>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.<br>
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.<br><br>2. It would require high bandwidth capabilities to cope with video streaming.<br>
<br>3a. Gender (but it's a bad choice of field to ask that question about. It would be better as a true/false field)<br>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.<br>
3c. First normal form: divide address_suburb into separate fields. Second normal form: create a unique user ID field. <br>3d. Normalisation removes most data duplication, which makes data maintenance easier and data inconsistencies easier to find. <br>
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'.<br>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<br>
<br>4. subject = Entity. <br>supervises = Relationship. <br>Firstname = attribute. <br>MarkID = key field? (why are some attributes shaded and some are not? Does it mean white attributes are separate elements to grey ones?)<br>
But it's a dodgy ERD: no cardinality (1/many indicators) are included. <a href="http://vceit.com/slideshows/Design-Tools-ERD.ppt">More ERD info</a>.<br><br>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.<br>
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...<br>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.<br>
<br>6a. Surnames are often not unique, and the wrong members may be identified.<br>6b. A phone number could contain spaces, dashes, parentheses, + symbols etc that cannot be stored in a numeric field.<br>6c. Radio button - it forces people to enter one (and only one) valid response.<br>
<br>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.<br>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!<br>
<br>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.<br>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.<br>
<br>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 <br>
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.<br><br>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.<br>
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).<br>
<br>This brings us to the original question asked by Anthony. <br><br>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.<br>
<br>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.<br>
<br><br>Quibbles, additions, corrections are welcome.<br><br><br><br><br><br><br><br><br><br><br>On 16 October 2012 13:09, Watson, Donald R <span dir="ltr"><<a href="mailto:watson.donald.r@edumail.vic.gov.au" target="_blank">watson.donald.r@edumail.vic.gov.au</a>></span> wrote:<br>
<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-AU">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">This what you’re after?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><a href="http://www.vcaa.vic.edu.au/Documents/vce/infotech/IT-Apps-samp.pdf" target="_blank">http://www.vcaa.vic.edu.au/Documents/vce/infotech/IT-Apps-samp.pdf</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Don Watson<u></u><u></u></span></p>
<p class="MsoNormal"><a name="13a67685e70fc191__MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></a></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US"> <a href="mailto:itapps-bounces@edulists.com.au" target="_blank">itapps-bounces@edulists.com.au</a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au" target="_blank">itapps-bounces@edulists.com.au</a>]
<b>On Behalf Of </b>Mark KELLY<br>
<b>Sent:</b> Tuesday, 16 October 2012 12:42 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] 2011 VCAA Sample Exam<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hmmm. When I try to download the
<a href="http://www.vcaa.vic.edu.au/vcaa/vce/studies/infotech/it-applications/publications/IT-Apps-samp.pdf" target="_blank">
sample questions</a> from the VCAA site, I'm getting a mangled 666 byte file.<br>
<br>
But taking a rough stab at the question, I'd say: "Select the file and click 'DELETE'".
<br>
<br>
Pretty easy 3 marks...<br>
<br>
Unless it's an ambiguous question and it's referring to how the <i>cloud computing host</i> 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...)<br>
<br>
But I'd still believe that a kid would have to earn 3 marks for saying "Click Delete".<br>
<br>
<u></u><u></u></p>
<div>
<p class="MsoNormal">On 16 October 2012 11:58, Anthony Sullivan <<a href="mailto:asullivan@tps.vic.edu.au" target="_blank">asullivan@tps.vic.edu.au</a>> wrote:<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal"><b>Question 10</b><u></u><u></u></p>
<p class="MsoNormal">Outline a procedure to dispose of data stored in the cloud<u></u><u></u></p>
<p class="MsoNormal" style="margin-left:216.0pt;text-indent:36.0pt">
3 marks<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Can someone explain to me the solution to the above question?<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p style="margin-bottom:12.0pt"><b><span style="font-size:11.0pt;font-family:"Arial","sans-serif"">Anthony</span></b><span style="font-size:11.0pt;font-family:"Arial","sans-serif""> </span><span style="font-family:"Arial","sans-serif"">
</span><b><span style="font-size:11.0pt;font-family:"Arial","sans-serif"">Sullivan</span></b><span style="font-size:11.0pt;font-family:"Arial","sans-serif""><br>
</span><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#666666">Head of Information Technology</span><u></u><u></u></p>
<table style="width:900.0pt;min-height:12px" border="0" cellpadding="0" cellspacing="0" width="1200">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p style="margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#a5a5a5">T: <a href="tel:03%209788%207796" target="_blank">
03 9788 7796</a> | F: <a href="tel:03%209787%207646" target="_blank">03 9787 7646</a> | Wooralla Drive, Mt. Eliza, Vic, 3930 | <a href="mailto:asullivan@tps.vic.edu.au" target="_blank">asullivan@tps.vic.edu.au</a> | <a href="http://www.tps.vic.edu.au" target="_blank">www.tps.vic.edu.au</a></span><u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#c0504d"><img src="cid:image001.gif@01CDAB9F.6E522780" border="0" height="135" width="1000"></span><span style="font-size:10.0pt;color:#c0504d"><u></u><u></u></span></p>
<table style="width:726.0pt;min-height:12px" border="0" cellpadding="0" cellspacing="0" width="968">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p style="margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#a5a5a5">Please consider the environment before printing this email, you will save 5g of paper, 250mL of water and at least 35gm of CO</span><span style="font-size:7.0pt;font-family:"Arial","sans-serif";color:#a5a5a5">2</span><u></u><u></u></p>
<p style="margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm">
<span style="font-size:7.0pt;color:#a5a5a5">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.</span><u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="margin-bottom:12.0pt"> <br></p></div></div></div></div></blockquote></div>-- <br>Mark Kelly - <a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>Manager of ICT, Reporting, IT Learning Area<br>
McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Phone: +613 8520 9085, Fax +613 9578 9253<br>VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: <a href="http://edulists.com.au/itapps/index.htm" target="_blank">IT Applications Edulist</a><br>
Visit Diigo links for <a href="http://groups.diigo.com/group/vce-info-tech" target="_blank">ITA</a> and <a href="http://groups.diigo.com/group/vce-sd" target="_blank">SD</a><br>--<br>My personal best for the 100 metre sprint is 11.9 metres.<br>
<br><br><br>