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.<br>
<br>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.<br><br><div class="gmail_quote">On 16 October 2012 19:17, Joyce Tabone <span dir="ltr"><<a href="mailto:jtabone@aitkencollege.edu.au" target="_blank">jtabone@aitkencollege.edu.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Gary<br>
<br>
Just adding my two cents worth ....<br>
<br>
I agree with both of your answers<br>
<br>
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.<br>
<br>
The book Id in the customer table links the two tables together. The customer Id in the customer table would be the primary key.<br>
<br>
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 ....<br>
<br>
<br>
Joyce<br>
________________________________________<br>
From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>] on behalf of Vear, Gary D [<a href="mailto:vear.gary.d@edumail.vic.gov.au">vear.gary.d@edumail.vic.gov.au</a>]<br>
Sent: Tuesday, October 16, 2012 6:06 PM<br>
To: Year 12 IT Applications Teachers' Mailing List<br>
Subject: Re: [Year 12 IT Apps] 2011 VCAA Sample Exam<br>
<br>
Hi all,<br>
<br>
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.<br>
<br>
For example, if you go to the following webpage, you will find "ease of use" listed under the definition for effectiveness: <a href="http://vels.vcaa.vic.edu.au/ict/glossary.html" target="_blank">http://vels.vcaa.vic.edu.au/ict/glossary.html</a><br>
<br>
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: <a href="http://www.vcaa.vic.edu.au/Documents/vce/infotech/infotechsd2011-2014.pdf" target="_blank">http://www.vcaa.vic.edu.au/Documents/vce/infotech/infotechsd2011-2014.pdf</a>).<br>
<br>
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.<br>
<br>
**********<br>
<br>
For a couple of other questions in Section A, I felt that other answers were "more correct" (sorry to disagree, Mark):<br>
<br>
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<br>
<br>
Q9 = B. foreign key (unless I have COMPLETELY misunderstood relational databases).<br>
<br>
I'd appreciate learning what others think about these questions in particular.<br>
<br>
Thanks,<br>
Gary<br>
<br>
<br>
________________________________<br>
From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>] on behalf of Mark KELLY [<a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au</a>]<br>
Sent: Tuesday, 16 October 2012 3:05 PM<br>
To: Year 12 IT Applications Teachers' Mailing List<br>
Subject: Re: [Year 12 IT Apps] 2011 VCAA Sample Exam<br>
<br>
Thank ye kindly, good sir. Kevork and I produced answers for the SD sample questions<<a href="http://www.vceit.com/studydesign/SD-sample-answers-2011.htm" target="_blank">http://www.vceit.com/studydesign/SD-sample-answers-2011.htm</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. More ERD info<<a href="http://vceit.com/slideshows/Design-Tools-ERD.ppt" target="_blank">http://vceit.com/slideshows/Design-Tools-ERD.ppt</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 <<a href="mailto:watson.donald.r@edumail.vic.gov.au">watson.donald.r@edumail.vic.gov.au</a><mailto:<a href="mailto:watson.donald.r@edumail.vic.gov.au">watson.donald.r@edumail.vic.gov.au</a>>> wrote:<br>
This what you’re after?<br>
<br>
<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><br>
<br>
Don Watson<br>
<br>
From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a><mailto:<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>> [mailto:<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a><mailto:<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>>] On Behalf Of Mark KELLY<br>
Sent: Tuesday, 16 October 2012 12:42 PM<br>
To: Year 12 IT Applications Teachers' Mailing List<br>
Subject: Re: [Year 12 IT Apps] 2011 VCAA Sample Exam<br>
<br>
Hmmm. When I try to download the sample questions<<a href="http://www.vcaa.vic.edu.au/vcaa/vce/studies/infotech/it-applications/publications/IT-Apps-samp.pdf" target="_blank">http://www.vcaa.vic.edu.au/vcaa/vce/studies/infotech/it-applications/publications/IT-Apps-samp.pdf</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 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...)<br>
<br>
But I'd still believe that a kid would have to earn 3 marks for saying "Click Delete".<br>
<br>
On 16 October 2012 11:58, Anthony Sullivan <<a href="mailto:asullivan@tps.vic.edu.au">asullivan@tps.vic.edu.au</a><mailto:<a href="mailto:asullivan@tps.vic.edu.au">asullivan@tps.vic.edu.au</a>>> wrote:<br>
Question 10<br>
Outline a procedure to dispose of data stored in the cloud<br>
3 marks<br>
<br>
Can someone explain to me the solution to the above question?<br>
<br>
<br>
<br>
Anthony Sullivan<br>
Head of Information Technology<br>
<br>
T: <a href="tel:03%209788%207796" value="+61397887796">03 9788 7796</a><tel:03%209788%207796> | F: <a href="tel:03%209787%207646" value="+61397877646">03 9787 7646</a><tel:03%209787%207646> | Wooralla Drive, Mt. Eliza, Vic, 3930 | <a href="mailto:asullivan@tps.vic.edu.au">asullivan@tps.vic.edu.au</a><mailto:<a href="mailto:asullivan@tps.vic.edu.au">asullivan@tps.vic.edu.au</a>> | <a href="http://www.tps.vic.edu.au" target="_blank">www.tps.vic.edu.au</a><<a href="http://www.tps.vic.edu.au" target="_blank">http://www.tps.vic.edu.au</a>><br>
<br>
[cid:image001.gif@01CDAB9F.6E522780]<br>
<br>
Please consider the environment before printing this email, you will save 5g of paper, 250mL of water and at least 35gm of CO2<br>
<br>
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.<br>
<br>
<br>
--<br>
Mark Kelly - <a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au</a><mailto:<a href="mailto:kel@mckinnonsc.vic.edu.au">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: <a href="tel:%2B613%208520%209085" value="+61385209085">+613 8520 9085</a>, Fax <a href="tel:%2B613%209578%209253" value="+61395789253">+613 9578 9253</a><br>
VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>
Moderator: IT Applications Edulist<<a href="http://edulists.com.au/itapps/index.htm" target="_blank">http://edulists.com.au/itapps/index.htm</a>><br>
Visit Diigo links for ITA<<a href="http://groups.diigo.com/group/vce-info-tech" target="_blank">http://groups.diigo.com/group/vce-info-tech</a>> and SD<<a href="http://groups.diigo.com/group/vce-sd" target="_blank">http://groups.diigo.com/group/vce-sd</a>><br>
--<br>
My personal best for the 100 metre sprint is 11.9 metres.<br>
<br>
<br>
<br>
<br>
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.<br>
<br>
<br>_______________________________________________<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>
IT Applications Mailing List kindly supported by<br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br><br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br>
<a href="http://www.swinburne.edu.au/ict/schools" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<br></blockquote></div><br><br clear="all"><br>-- <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>