Post Mortem Notes This is not a VCAA publication.
I do not speak for the VCAA, the IT examiners, or exam markers. I was not involved in the writing or marking of this examination. Extracts from exams are all Copyright © VCAA, and are used with permission. Use these post mortems at your own risk. I reserve the right to change my mind completely, at short notice, about anything I've said here. Suggestions, discussions and corrections are welcome. Questions look like this. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Other VCE IT Exam Post Mortems to enjoy IPM / ITA / Informatics / Data Analytics - 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2023
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SECTION A - Multiple-choice questions* in multiple choice marks my answers Across the state: average multiple choice question accuracy = |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Instructions for Section A Answer all questions in pencil on the answer sheet provided for multiple-choice questions. Choose the response that is correct or that best answers the question. And let's hope this year's exam won't be a dog's breakfast... |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 1 The main reason for evaluating a new website is to Answer is: B If you thought "A", that is testing, not evaluation. 75% of the state got this question right. This question assessed students’ knowledge of the evaluation step of a problem solving methodology. It was pleasing to see a large majority of students recognised that the main reason for evaluating a website was to check that stated goals and objectives had been achieved |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 2 In Australia, digitally altering the background and colours of an artist's work and then selling it as your own is illegal according to the Answer is: A Obviously. 92% of the state got this question right. Most students recognised the Australian Copyright Act 1968 (option A) as the appropriate law covering the scenario described. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 3 Incremental backup Answer is: C Obviously. 78% of the state got this question right. A large majority of students correctly recognised that an incremental backup, which only backs up changes made since the last full backup, saves time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 4 The owner of a large retail organisation wants to improve customer service over the next three years. This is an example of an organisational Answer is: B The owner would obviously be making strategic decisions, and the broad, vague nature of the target indicates it's a goal rather than a more specific objective. 53% of the state got this question right. A small majority of students correctly identified ‘goal at a strategic level of decision making’ (option B) as the
correct response. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 5 Joe is in a hurry to save his mathematics homework and get to school. He removes a flash disk/memory stick before the screen prompt indicates it is safe to do so. When Joe opens the flash disk/memory stick at school he finds his mathematics homework file is missing. This is due to Answer is: D The corrent procedure was not followed, which caused the error. Option B is as dumb as a retarded custard pie. 88% of the state got this question right. It was very pleasing to see that most students recognised that the procedural failure was Joe removing the flash disk before the screen prompt indicated it was safe to do so (option D). |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 6 The Input-Process-Output (IPO) chart below is set up to represent part of a solution to an information problem.
The solution design should include a plan to Answer is: A You validate input data and test output information. 55% of the state got this question right. This question assessed students’ understanding of validation and testing when preparing a design for an information product. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 7 Below is a section of a database used to effectively manage data at the Health First Clinic.
Identify the patients form that best meets the description. Answer is: B <D> is an employees' form so rule that dumb option out. <C> leaves out the patient ID, which is important. Choosing between <A> and <B>... <B> has a print button and <A> does not, so it's a little more functional. But deary me - they did use Access-specific terminology ("form") which Filemaker users would not be familiar with. Bad examiners. Bad! 90% of the state got this question right. Most students were able to read the description of the patients form and identify option B as the best fit. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Use the following information to answer Questions 8-10. The design for a spreadsheet to record cash sales during February 2008 is shown below.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 8 The formula to calculate the Total in cell G13 is Answer is: B. My mother's geranium - which is considered to be stupid even by fellow geraniums - could have worked that one out. 88% of the state got this question right. Most students chose the correct formula to calculate the total shown in the design for a spreadsheet. It was pleasing to see that most students understood the importance of avoiding circular references in spreadsheet formulas. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 9 The most effective formula for B15 to show the difference between cash sales on the best and worst days of Week 1 is Answer is: D If nothing else, ruling out dumb options <A> to <C> would lead to the right answer. 83% of the state got this question right. Again, it was pleasing to see that most students correctly chose the more complex formula to calculate the difference between cash sales on the worst and best days. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 10 To show changes over a 4-week period in the total cash taken each Friday the most effective chart type would be Answer is: D Again, eliminating the unlikely answers helps a lot. It's not a pie (which shows how much the components contribute to a whole). I'm not familiar with area chart, since my experiences with mathematics at school were not happy ones. I doubt it's a scatter graph, which has dots all over it showing individual values. Column seems right. 71% of the state got this question right. The majority of students correctly identified the column chart as the most effective chart to represent changes in cash taken on four consecutive Fridays. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Use the following information to answer Questions 11-13. Customers CustomerlD -SMA0623
Company Name - SMARTICONS
Title - Mr
Contact Name -Kim Jones
Address - 28 High Street
City -SYDNEY
Postcode - 2003
Phone - 0200245678
Fax - 0234567892 Last Order $ - 674.89 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 11 The CustomerlD field Answer is: C Key fields (a.k.a. primary keys) must be unique: we all know that. Without an entry they are useless. Sorting is irrelevant. Key fields are sometimes automatically generated with something like autonumber, but it ain't compulsory. 79% of the state got this question right. This question asked students to identify two necessary features of a primary key. It was pleasing to see that the majority of students correctly chose option C. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
A drop list or combo box in this form would be an efficient validation technique for the field labelled Answer is a very reluctant : B. After a lot of pondering and correspondence I've changed from D to B. I had been interpreting the purpose of the form differently to other people - the question is not clear on that score. "Drop list"? That's a new one to me. Anyway, a dropdown list or combo box is only good for a limited list. Drop-down lists should only be used when the items in it can be exhaustively listed - and titles are not.
Yes, you can add Mr, Mrs, Ms, Dr, Professor etc but there will always be titles you have never heard of that will need adding. It will be an endless job. Alas, I agree that B is the best of a bad bunch of options. But I'm not happy, Jan. 85% of the state got this question right. It was pleasing to see that most students understood the concept of an efficient validation technique and could successfully apply it to the design of a database form. In choosing the title field, most students recognised that the combo box or drop list is best used in a field where there is a limited and known range of values from which users can select. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 13
Answer is: D "< >" means not equal to. ">" is greater than. "<" is less than. This exam is far from challenging for a skilled student so far... 84% of the state got this question right. Most students correctly identified option D, the query which directly represented the conditions ‘customers based in Adelaide and less than $1000’ as a better option than option C, which would include customers based in Adelaide but also those based in others cities such as Sydney, Brisbane or Perth. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 14
Answer is: B Efficiency relates to saving time, money or labour. All of the other options were related to accuracy and ease of use, which are related to effectiveness. 56% of the state got this question right. This question asked students to select the best means of evaluating the efficiency of online help provided for users. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 15 The IT Help Desk has been asked to create a macro that will centre the company name 'Sell Quickly Online With Us' in cells Al to A8 whenever the assigned keys are pressed. Answer is: D This is a strange one. Obviously it has to be B or D - merging cells creates the centred heading over the cells. But as for "including formatting"? What does that mean? That the macro formats the text (e.g. large font size, sans serif typeface)? Rather odd. 64% of the state got this question right. A macro executes a set of pre-arranged steps when an assigned key or button is pressed. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 16
Answer is: C. CAT5? That's as outdated as Britney Spears' reputation. While one would normally automatically go for CAT cable, the key words (I discovered after some rethinking) were "from any location". This implies wireless rather than cabled. 58% of the state got this question right. The majority of students selected wireless (option C) as the correct response. The chess players needed access from any location on the school’s single campus. Wireless access points provide this and security is available with encryption. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 17
Answer is: D Prototype = demonstration model. Yep. 78% of the state got this question right. Most students correctly identified option D as the best description of a prototype website. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 18
Answer is: C Does anyone else think many of this exam's distractor options are as dumb as a doorknob? 91% of the state got this question right. It was very pleasing to see that most students understood the basic principles associated with the use of a virtual private network to solve a problem collaboratively. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 19
Answer is: A I mean to say, my cat died two years ago, but even he could have answered that correctly. 63% of the state got this question right. This question assessed students’ understanding of how the formulas created in a database query are tested. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 20 The critical path on the PERT chart shown above is Answer is: D An odd sort of PERT. Not quite 'Activity on Arrow'. Not quite 'Activity on Node'. Anyway, there are four paths in the chart: Start > F G C > End (6+12+4+6 = 28) Start > A B C > End (6+4+5+6=21) Start > D B C > End (7+5+5+6=23) Start > D E > End (7+3+8=18) So the longest path is 28 time units. 47% of the state got this question right. In this question students were asked to identify the critical path on a PERT chart.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
To me, the state averages show that section A was far too easy. Only one question managed to outwit more than half of the students. The average success rate for the state for section A was 74% - rather too high, if you ask me. |
SECTION B - Short answer questions |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Answer all questions in the spaces provided. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 1 - 2 + 2 marks, 2 lines each. Market research indicates that teenagers make up most of the audience for an online chat room about spy movies. a. List two audience characteristics that need to be considered when developing this chat room. Their: reading level; attention span; maturity; vocabulary; lack of credit cards. Others? b. Explain how one of these characteristics should influence the content of the site's home page. Give an example to support your answer.
State average was 1.75 / 4 (43%) Question 1a. Students were asked to identify two characteristics of an audience for a chatroom home page. The question stated that the audience was made up of teenagers and that the chat site was about spy movies. It was pleasing to see that many students identified a range of characteristics which included age, gender, level of education and literacy or language and culture. Question 1b. Only a small number of students was able to explain how one of these characteristics should influence the content of the site’s home page and achieve full marks. Many successful students explained that younger teenagers need lots of colour and simple language or images to keep them coming back to the site.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 2 - 4 marks The following 17 links are needed on the home page of a school website. Art, Biology, Chemistry, Drama, English, Fees, Location Map, Mathematics, Medical Care, Parent Association, Parent Information, Pastoral Care, Student Welfare, Subjects, Visitor Information, Weekly Calendar, Newsletter. Select four links as headings on the opening page and insert them in the boxes labelled W, X, Y, Z. Select two other appropriate links to be placed under each heading.
It's not really an IT question. It's more about general categorisation skills. Only 2 items were required for each heading, but I've put all the items in place. One could argue that the calendar might be more aimed at parents, but I'd say it's not wholly meant for parents. Other stakeholders, such as students and teachers, would make use of it. Also, as one of my students said, "What's pastoral care?" I imagine many students were equally confused by this requirement for non-IT vocabulary. I wonder what the ESL exam testers said about that expression. State average was 2.7 / 4 (68%) The majority of students chose Subjects, Student Welfare, Parent Information and Visitor Information as the most appropriate headings for boxes W, X, Y and Z – the main categories of the links on a school website’s home page. It was pleasing to see that most students selected appropriate links to be placed under the headings chosen. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 3 FreshFood is a company that delivers food to online customers. The screen shown below is used to order fruit.
a. 2 marks, 2 lines for the feature and 2 lines for the explanation. a. Select one formatting feature of the table shown above and explain how it adds to the clarity of the information.
State average was 1.15 / 2 (58%) b. 4 marks. 1 line for each convention, 2 lines for each explanation. b. Identify two conventions and explain how each adds to the usability of the information product.
The challenge, I found, was discriminating between "formatting feature" and "convention". When answering 3A, if I had not read ahead to find the question about conventions, I might have starting discussing conventions in 3A. The moral: read all the questions before you answer any of them. And yet, I wonder what on earth the "Buy" column and its cute boxes are for. Is one supposed to tick it? Surely entering a Quantity would equally well indicate that one wanted to buy an item. Unclear, unnecessary. State average was 1.05 / 4 (26%) 3a. Students were asked to identify a formatting feature that added clarity to the information presented in a table. Successful responses included formatting features such as bold headings, centred headings and the shading of alternating rows. Most students explained that these formatting features added clarity because they allowed users to distinguish between the visual elements. For example, bolding makes ‘important text stand out’, shading rows ‘leads the eye’ to the correct information and left justify ‘stops confusion and crowding on the screen’ for the user. 3b. In the second part of the question students were asked to identify two conventions and explain how each convention added to the usability of the information product. Many responses did not receive full marks for this part of the question because the conventions identified and the explanations given were not clear. Successful explanations typically conveyed the idea that the convention made the information more easily accessible to the users because it was a widely accepted and established way of presenting the particular type of information. Setting two decimal places for the money |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 4 Gina manages the medical records database for a hospital in Melbourne, Australia with 15 000 patients a. Name the law which covers Gina's responsibilities for patients' data. (1 mark, 2 lines) Health Records Act (Vic) 2001. But I hope that "Privacy Act 1988" would also earn a mark, since that law would also apply to such an organisation that held medical information on its customers. Hmmm. This is the first time a Victorian law has been tested. Interesting! State average was 0.65 / 1 (65%) Most students correctly listed the Health Records Act 2001 as the law covering Gina’s responsibilities for patient data. b. Describe a security procedure the doctors should follow after finishing accessing patient data from the hospital's network. (1 mark, 2 lines) They would need to shut down the database and/or log out of the network. State average was 0.55 / 1 (55%) Most students recommended that doctors should log off from the network when they left the terminal. Other answers were accepted provided the actions described indicated that access to the network was terminated. c. A patient has a new doctor in another clinic who requests the patient's records from the hospital. Identify one legal obligation the hospital has when sending the records. (1 mark, 2 lines) They would need to take reasonable steps to ensure the transmitted data was protected from misuse, damage or loss. (Data Security Privacy Principle). Also, possibly: If the new clinic were overseas, the Transborder data flow NPP might apply: the hospital should not transfer the records without the consent of the individual. State average was 0.6 / 1 (60%) The responses to this question included a range of the legal obligations found in Schedule 1 of the Health Records Act 2001. The most frequent legal obligation was ‘ask permission from the patient’. d. Doctors have been asked to send complete patient records of all 18 year olds to the Australian Government Health Commission. For each of the following, write a question the parents could ask to identify these ethical dilemmas. (3 marks, 3 x 2 lines) i. Doctor ii. Patient iii. Health Commissioner This was a bit of a bugger. Not easy to understand what the examiners really wanted to hear. This, I imagine will turn out to be the lowest-scoring question of the paper so far. i. Doctor
ii. Patient
iii. Health Commissioner
Nope. Didn't like this question at all. Ethical questions are always murky. State average was 0.35 / 3 (11%) - A shocking result! When asked to compose questions that parents of a patient would ask the doctor, the patient and the Australian Health Commission, many students responded by providing a question that would help the patient’s parents understand a legal position rather than an ethical dilemma. A dilemma is a choice between two equally undesirable choices. In most instances the responses that received full marks made it clear that the parents were weighing up their child’s right to privacy against the benefits to society. The following examples are from successful responses. Question 4di.-
Parents to doctor:
Do you benefit from sending my child’s medical records? e. The hospital has implemented a firewall to ensure that the medical records database is not accessed by unauthorised users. Describe one advantage of a firewall for the hospital. Give an example to support your answer. The firewall prevents hackers detecting the computer and possibly activating trojan horses that might send files, log keystrokes, or force the computer to become a "zombie" in a spam flood or Distributed Denial of Service attack. For example, if a hacker tried to make the computer send its keystroke log, the firewall would prevent the trojan transmitting through the firewall. An odd sort of question. The question tells us what the firewall does, and then asks why it's an advantage. Pretty basic sort of stuff. State average was 1 / 2 (50%) Most students recognised that a firewall prevents access to the network from users outside the network. Many students were able to obtain full marks by describing a situation where the hospital firewall checked the identity of users or the content of information trying to enter the hospital network. f. Describe one disadvantage of the firewall being the only way of preventing unauthorised access to the medical records database. Give an example to support your answer. The firewall only protects from people outside the LAN. It does not protect against people inside the LAN, and it does not protect the database from unauthorised access. For example, any person within the hospital could enter the database and change, steal or delete information. Appropriate protection would be password protection of the database, preferably with hierarchical levels of access depending on people's needs. State average was 0.95 / 2 (48%) Fewer students could identify the limitations of the firewall and describe situations where users inside the network gained illegal access to records. Many students successfully recommended that antivirus software and physical barriers should stand alongside firewalls as part of a security strategy. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 5 - 2 marks
The close icon (which is red) on the screen shown above is described by a graphic designer as intuitive. Do you agree with the graphic designer? Justify your answer. I agree with the designer. Red is associated by Western cultures with danger, threat, alert, so most of us would recognise that a red button demands respect. This assumption might not apply in other cultures where (for example) the funereal colour is white and wedding dresses are not white. But as a student of mine, who is smarter than a sack of spanners, said: "What does intuitive mean?" Once again, it's a term we grown-ups in long trousers might be familiar with, but how many students had to guess the meaning of the question? State average was 1.1 / 2 (55%) Students were asked to comment on the notion that a given icon was intuitive, that is, resulting from direct knowledge or awareness without conscious attention or reasoning. Responses that conveyed a notion of an intuitive icon allowing users to confidently navigate the information product without needing words were successful. Typically these responses included the phrases ‘yes, the colour red means stop or danger in nature and many situations in society’ and ‘the cross means stop or not’ when used with ‘other symbols’.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 6 MusicWarehouse is a company that sells CDs by mail order. Sue, who owns the company, has used database management software to create the Category and Product tables for the stock records. Category Table (CategorylD is the primary key)
Product Table (ProductID is the primary key)
a. Recommend a data type for the ProductID field. Justify your answer. a. 2 marks, 3 lines. Number, integer. The field's contents are purely numeric so it will hold numbers well. Specifying a number type can make data storage more efficient. And before we get to part b, let me wish the examiners luck marking this one. They will have to accept ANY DBMS validation syntax - or lack of syntax in the case of Filemaker, which let you enter a validation range in two boxes - no syntax required. I would love to see an offering that the examiners could definitely say is incorrect, since students were not instructed to nominate the DBMS for which the validation rule applies! State average was 0.85 / 2 (43%) Most students could recommend a data type for the ProductID field but fewer could successfully justify their choice. The following are examples of successful responses. The following error message is displayed when 31.00 is entered in the Unit Price field. 'The Unit Price must be between and including $10 and $25' b. Write the rule for this message (including symbols) (1 mark, 1 line) 10 >= UnitPrice <= 25 Unitprice >=10 and unitprice <=25 AND(Unitprice >9, Unitprice<26) Take your pick! State average was 0.25 / 1 (25%) $10<= ‘Unit Price’<= $25 Few students could write the rule for the message using the symbols.
c. Explain the role of the error message in enhancing the quality of the information. (2 marks, 3 lines) The role of the error message is to alert the data entry operator to the entry of unreasonable data. Once the unreasonable data is removed, the resultant information will be more accurate and valuable. State average was 1.05 / 2 (53%) Successful responses to this question identified the two components of an error message as ‘telling users in plain language that they have made a mistake’ and ‘explaining how to fix it.’ Most students could identify one of these components of the role an effective error message plays in an information system. Sue has created a one-to-many relationship between the CategorylD fields in these tables. d. i. Define a one-to-many relationship. (2 marks, 4 lines. Interestingly, the mark allocation for parts i and ii is not given in several questions) A one-to-many relationship is where a key field in one table can match more than one record in a related table. ii. Explain one advantage of this one-to-many relationship. It allows Sue to easily find all albums in a given category. Oh dear. I was hoping the examiners could do better than a "Define this term" type question. They're way low down in Bloom's taxonomy and encourage students to memorise rather than understand. In future, please avoid them, guys! State average was 0.4 / 2 (20%) Few students could clearly state that in a one-to-many relationship, one record in the first table is related to many records in the second table or give an example such as ‘one record in the Category table is related to many records in the Product table.’ |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 7
a. Complete the Gantt chart above by
(2 for calendar), 2 for dependencies), 1 for milestone
But what's this? Task 5, the milestone has no predecessor, so it strictly speaking should happen on the first Monday! We have to assume that it comes after task 4 because it appears after it in the task list. And since the tasks have no real identities, we can't logically assume that this task follows that one. Not good. Bad, bad examiner! State average was 2 / 5 (40%) Many students were able to shade in the tasks on the calendar correctly but most were unable to obtain full marks because they could not correctly place a Milestone symbol and the Predecessor arrows. b. Explain the purpose of the milestone (1 mark, 2 lines) The milestone shows an event (of zero duration) rather than a task (which requires something to be done by someone). Milestones show progress points to let project managers see if the project is on schedule or not. State average was 0.45 / 1 (45%) Only 43 per cent of students correctly defined the function of a milestone as, for example, ‘the date when a group of tasks is completed’ or ‘the end of a significant point in the project’. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 8 - 3 marks Stefano runs an online book selling business. To increase his business, Stefano wants to introduce a 10% discount for new customers paying by credit card. He designs a macro so that when an order is processed, new customers get a 10% discount.
Not very hard. Thanks to Andrew for pointing out the glitch with my "yes/no" labels. State average was 1.3 / 3 (43%) A majority of students placed the correct action in the sections of the flow chart that did not involve the decision box and yes and no branches. Many students did not recognise the statement ‘Is this an existing customer?’ as the reverse of the statement that Stefano wanted to ‘introduce a 10% discount for new customers’ and placed the yes and no actions on the wrong branches. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 9 (2 marks) Geography teachers at Seaside Secondary College have created a prototype website that will allow Year 10 students to access class notes, project instructions and local maps. Students will be able to upload data to the website to assist with the preparation of their projects. It is proposed that teams of students be allocated Internet-enabled mobile phones, with high resolution cameras, for their first project. a. i. Name the type of network these teams are using. Hmmm. Let's see why the doggies will love this breakfast. The question is ambiguous: "type" of network could refer to :
Student who stated any of these should get a mark. This type of poor question has floated around before. The examiners should have been more careful. 9ai. PROBABLY BECAUSE THE QUESTION WAS VERY BADLY WRITTEN! ii. Describe one advantage of this type of network for the students studying geography. They could access network documents and upload new documents from remote locations while on site. State average was 0.55 / 1 (55%) 9aii. b. Identify a potential problem for the school when these teams transmit data to the website. Data could be coming from unauthorised people (?) Incoming data could contain malicious content (e.g. trojans) (?) Not easy to come up with something convincing. State average was 0.65 / 1 (65%) Most students identified a potential problem if teams sent data directly to the website. Examples included ‘inappropriate images or sent text directly to website which embarrass the school’, ‘outsiders intercepting data or sending data to embarrass the school’, ‘the school would need a teacher to check content or anti virus software or spyware’. c. The geography teachers have been asked to evaluate the effectiveness of this prototype website. (2 marks) i. Recommend one criterion which could be used for this evaluation. (1 line)
Remember that the question asks for effectiveness of the site, rather than its efficiency. ii. Explain why you chose this criterion. (2 lines)
State average was 0.55 / 2 (28%) This question asked students to provide one criterion to measure the effectiveness of the school website and most correct responses posed questions in terms of accessibility, usability, accuracy or timeliness. Typical examples included: In the second dotpoint, the examiners have it wrong. "Quickly" relates to efficiency rather than effectiveness. 9cii.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question 10 - 5 marks ToysOnline advertise and sell toys online. Two screen mock-ups for a new home page are shown below. The owner of ToysOnline does not like either screen mock-up. a. Hand draw a new design that is complete and appropriate for the content. Indicate fonts, colours, links and layout. (5 marks, 3/4 page empty box) It's interesting that the exam sets such a large job. In the past, questions have been rarely worth more than 3 marks. Some of my McKinnon students were taken aback because I'd told them during the year that it would be unlikely that the exam would entail a complete task (e.g. an entire Gantt/PERT chart, flowchart). Anyway, it's actually good to see a more challenging task that requires kids to plan and think. Students should have included:
State average was 4.05 / 5 (81%) - a surprisingly good result by the cohort! It was very pleasing to see that the majority of students received full marks for their hand drawn and annotated design of a new website for ToysOnline.
b. Choose two design elements from the list shown and explain how each has been considered in your design. (4 marks) Answering this depends on the student's design. They should be able to show deliberate use of features that help accomplish two of the design elements. e.g. Colour and Contrast - I used black or dark blue text on a white background to ensure the text was easily readable. State average was 2.8 / 4 (70%) Students who could explain how they had used two design elements with specific reference to their design and annotations received full marks for the second part of the question. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
'Acme Office' - hehehehe a. Describe how the coaches could use the Internet to make group decisions. (2) They can use a Wiki to gather and share information. State average was 1.35 / 2 (68%) It was clear that most students understood the concepts associated with the agreements and security issues associated with setting up and participating in a virtual private network (VPN). Successful responses included a variety of examples directly related to the activities of the sports coaches. 11a. Students who described both a network feature and the type of collaboration it supported were awarded full marks for their response. Common examples were ‘coaches can use email to share files about game tactics’ and ‘coaches use electronic polling about decisions or new rules’. b. Discuss how the coaches can avoid journalists gaining access to their discussions before any decisions are released officially. Give an example to support your answer. (2)
State average was 1.3 / 2 (65%) Examples provided included ‘secure login or encryption or headcount procedures for a network meeting, Wiki or MSN Messenger’. Two coaches recently installed the latest Acme Office 2008 suite on their computers. The other eleven coaches complain that now they cannot open attached files from these two coaches. c. Explain why this problem has occurred. (1) Acme Office 2008, invented by maniacal mogul Gil Bates, adopted a new XML based file format which is not compatible with previous document file formats, which royally annoys the hell out of people living in Acmeland. State average was 0.7 / 1 (70%) Most students identified the problem of an old version of software not being compatible with a new version. This was typically described as ‘not backward compatible’ or ‘they have different file extensions’. d. Recommend a strategy to stop this type of problem. Justify your answer. (2) Either upgrade all team members to the same vile version of Acme Office, or require all 2008 users to save their documents back to the previous 2004 format. Or give up on Gil Bates, and replace Acme Windows with Acme Linux and use Acme Open Office. State average was 1.15 / 2 (58%) Most students described and justified a strategy that included a procedure for agreement between coaches or a technical solution for the incompatible files. Strategies that justified the need for both were awarded full marks. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Note that the two tables that follow were laid out on facing pages through the insertion of a blank page 19. This was to make it possible to see both tables simultaneously. A pat on the back, VCAA! | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The spreadsheet below is used by AutoFresh to manage the cash and stock in automatic drink and food machines in school canteens. Each machine can dispense 100 drinks of each type.
a. Which cell indicates the total amount of cash in the machine? (1) E14 State average was 0.85 / 1 (85%) Most students correctly identified cell E14. The Re-order column indicates YES if sales are over 40. b. Write the formula for cell D2 that returns the correct answer. (1) =IF(C2 > 40, "YES", "") Note the empty quotes for the 'False' condition. If this were omitted, Acme Office 2004 would show 'False' rather than having no entry, as required. I hope the examiners accept syntax from other Non-Acme spreadsheets. State average was 0.15 / 1 (15%) - youch! Few students could correctly write the formula for the IF statement =IF(C2>40, ‘YES’,’ ‘). Neither could the examiners: double quotes are needed, not single quotes. AutoFresh pays the school a share of the money based on the number of sales per month of each hot drink type. They are calculated c. Write the formula for cell F2 that will calculate the school share of sales and which can be dragged or replicated in cells F3 to F12. (1) The ugly answer they probably want is =VLOOKUP(C2, $G9:$H11,2) * C2 But I hope my kids said... "Name G9:H11 as TABLE and use the nice formula =VLOOKUP(C2, TABLE,2) * C2 Even nicer, name the range C2:C12 as NUMSOLD and use the formula =VLOOKUP(NUMSOLD, TABLE,2) * C2 For we all know that Acme Office 2004 lets you name a range and then a formula referring to that range uses the value in the range in that row. Neat, huh? And if the markers penalise students for using named ranges in their answer, I hope their hubcaps fall off. State average was 0.05 / 1 (5%)- a terrible result. The question was fair, but obviously students really SUCK with formulae. Teachers will really need to push basic Excel skills. Very few students could correctly write the formula for the VLOOKUP statement "Nested loops"?? Do the examiners mean nested IFs?? O dear... The spreadsheet designer has been asked by AutoFresh managers to provide a formula that returns the highest sales of all the types each month in cell C15.
The formula = Max(C2:C12) is entered in cell C15. d. Provide test data for cell C3 to test the formula. (1)
Huh? A big too easy. Have I missed something here? State average was 0.3 / 1 (30%) Successful responses to this question provided test data that would trigger a change to the existing maximum number in cell C6, which was 37. e. Suggest how the spreadsheet could be altered to enhance the meaning of the information shown in C15. (1) Change the label in A15 to "Maximum sale quantity"? To be a tricky little devil, you could go further (as, in fact, I think the examiners were fishing for). For example, replace A15 with this modest formula... ="The biggest sales were for " & INDEX(A2:C12,MATCH(MAX(C2:C12),C2:C12,0),1) & " which sold " & MAX(C2:C12) This would display (for example) "The biggest sales were for Cappuccino which sold 38." Pretty basic, I know, but I can't think of anything else. Download a sample spreadsheet (Acme Excel 2003) if you're curious about INDEX and MATCH. State average was 0.4 / 1 (40%) The successful responses to this question suggested ways to make the spreadsheet more user-friendly. Examples included ‘add a label to the A15 cell’, ‘add a macro or coding or a program that highlights the name of the maximum sale – cappuccino’ and ‘insert a new column to highlight the name of the maximum sale – cappuccino’. The AutoFresh managers currently receive reports containing pie graphs/charts of sales figures at the end of each month. AutoFresh managers want to print pie graphs or charts of the Sales at other times in the month. The Help Desk creates a macro to complete this task. f. 2 marks i. Explain why the Help Desk chose a macro. A macro makes a complex task simple. It is especially useful for unskilled operators, or for functions that are rarely carried out and easily forgotten. Even for skilled operators, macros are often faster than performing tasks manually. ii. Describe how this helps to meet the managers' information needs. It provides the information in an easily-interpreted format and in a timely fashion. State average was 0.75 / 2 (38%) Most students understood, in general terms, the reason for choosing a macro to solve the manager’s information problems. 12fi. 12fii. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
State average for all of section B was 48% - quite a bit different to the 74% in section A. I think the balancing of the difficulty of questions went badly out of the window in 2008. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
All in all, a better exam than some in the past, but a bit too easy in section A.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
End of question and answer booklet Original Content © Mark Kelly 2008 |
Back to the IT Lecture Notes index
Back to the last page you visited
Created 15 October 2008
Last changed: March 9, 2022 11:34 AM
VCE Applied Computing Notes © Mark Kelly 2001-