VCE IT Lecture Notes by Mark Kelly

VCAA IT Applications Exam

Post Mortem 2013

Examiners' report comments added 23 June 2014 - it took VCAA a l-o-n-g time to publish these!
View the original document.

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 setting or marking of this examination.
Extracts from exams are all Copyright © VCAA, and are used with permission. Thanks, VCAA!
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.
If any third-party copyrighted material has inadvertently been used, please let me know

Questions are in black.
My suggested answers are in blue.
My editorial ramblings about the exam are in blue italics.
Examiners' report comments are in red italics.
Purple shows the explanation of an answer.

Other VCE IT Post Mortems to enjoy

ITA/Informatics - 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017


SD - 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017

Last changed: November 19, 2014 1:02 PM

The Post Mortem Awards

The SCHMACKOS award is given to questions that are a complete dog's breakfast.

The Questions That Make You Sick As A Dog Award Questions that are not totally wrong, but are just dumb or are wrong in a way that does not jeopardise the answer.

 

The exciting Illiteracy Award.

Stamp of Approval

New in 2013, the Post Mortem Stamp of Approval, for questions I like

 

Section A | Section B | Mark Breakdown | Student Feedback

INFORMATION TECHNOLOGY:
IT APPLICATIONS

Written examination

Monday 4 November 2013

Reading time: 3.00 pm to 3.15 pm (15 minutes)
Writing time: 3.15 pm to 5.15 pm (2 hours)

QUESTION AND ANSWER BOOK

Structure of book


Section

Number of questions

Number of questions to be answered

Number of marks

A

20

20

20

B

12

12

70

 

 

 

Total 90

  1. Students are permitted to bring into the examination room: pens, pencils, highlighters, erasers, sharpeners and rulers.
  2. Students are NOT permitted to bring into the examination room: blank sheets of paper and/or white out liquid/tape.
  3. No calculator is allowed in this examination.

Materials supplied

  1. Question and answer book of 20 pages.
  2. Answer sheet for multiple-choice questions.

Instructions

  1.  Write your student number in the space provided above on this page.
  2.  Check that your name and student number as printed on your answer sheet for multiple-choice questions are correct, and sign your name in the space provided to verify this.
  3. All written responses must be in English.

At the end of the examination

  1. Place the answer sheet for multiple-choice questions inside the front cover of this book.

Students are NOT permitted to bring mobile phones and/or any other unauthorised electronic devices into the examination room.

General Comments

Generally, responses drawing on knowledge gained from completing practical activities during the learning process were the most successful. High-scoring students had, for example, a clear understanding of the influence of design elements on the appearance of websites, and the ability to select and apply test data when developing solutions for information problems. They could also choose appropriate data types when creating tables for a relational database management system and design queries and formulas using logical conditions that returned information for specified purposes.

Where questions required extended responses, many students completed most of the task but did not address all parts of the task. For example, some students provided accurate descriptions of either a database or spreadsheet solution but failed to provide test data for the second requirement. For example, many successful responses had been divided into sections, with detailed answers set out under headings for each part of the question.

While the majority of students could design a website and annotate their design to explain the relationships between the features of their design and the requirements of the design brief (Section B, Question 11), a significant number mistakenly used their annotations to simply describe fonts, sizes and colours without explaining their purpose. With the exception of navigation, few students were able to recommend a design element related to the functionality of a website (Section B, Question 9b.).

Students and teachers are reminded that a number of key knowledge points are expressed in terms of efficiency and effectiveness. For example, they require an understanding of how particular functions or techniques increase the efficiency of collecting data (Unit 3, Outcome 2) or the ability to create criteria for evaluating the effectiveness of information management strategies (Unit 4, Outcome 2). Demonstrating an understanding of these key knowledge points involves explaining how the function or technique reduces time, cost or effort in the case of efficiency, or how a management strategy improves data integrity, security, ease of retrieval and currency of files in the case of effectiveness. It is not sufficient to simply use the words ‘efficient’ or ‘effective’.

In general, responses that provided examples taken from the context of the scenarios were the most successful.

SECTION A - Multiple-choice questions

Go to section B

 

SECTION A - Multiple-choice questions

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.
A correct answer scores 1, an incorrect answer scores 0.
marks will not be deducted for incorrect answers.
No marks will be given if more than one answer is completed for any question.

Question 1

When Old Time Gardeners decides to re-landscape a suburban parkland, it sets up a website so that local residents can view each stage of the construction.
This type of online community is best described as

A. social.
B. collaboration.
C. project-based.
D. knowledge-sharing.

Answer is C. But I don't like it.

Not an easy starter for 2013's exam.
The study design mentions 3 types of online communities - social, work-based and project/interest-based.

(A) is true insofar as the gardeners are communicating with society, but it's not a "get together and meet people" sort of "social" website.
(B) is not one of the 3 designated types.
(C) is a designated type, and closer to the truth than (A).
(D) is accurate in that the OTGs are sharing knowledge with local residents, but it's not one of the official 3 types.

I originally went for (D), forgetting the study design had listed the 3 official types. Sigh.

OFFICIAL RANT BEGINS

But just because the study design lists 3 types after the word "including", that does not mean that there is no such thing as a knowledge-sharing website.
What on earth is this site?

Can the OTG site not be described as 'knowledge sharing'? Is that not true? Of course it is.
Is the VCAA official answer more true just because only 3 types (out of an infinite number) are listed in the study design? I don't think so.
A project-based online community is meant to serve the people on the project - not outsiders like the local residents! Option D is actually better.

So since the aim of section A is to "Choose the response that is correct or that best answers the question.", (D) is most correct.
Perhaps the question should have been, "Of the 3 types of online community named in the study design, which most closely matches the OTG online community?"
That way, students would not accidentally choose an option that is true and accurate and get the answer totally wrong! Grrr.

But when choosing answers, kiddies, remember Mr Kelly's Golden Rule - The study design is always right.

But let's not get bogged down now in petty criticism of VCAA.
This is only question 1 ... there's plenty of time left.

Rainbows and Unicorns

No. Must relax. Rainbows and unicorns. Peace and harmony. VCAA is not the enemy...
Britney Spears and Adam Sandler are.

76% of the state got this right.

Question 2

Evaluating a solution involves
A. determining the evaluation criteria.
B. testing whether the solution does what it was intended to do.
C. reporting on the extent to which the solution meets the requirements of the user.
D. determining what information the solution has to provide and what data is needed to produce it.

Answer is C.

(A) is done during design, and is a prelude to evaluation.
(B) is done during development.
(D) is done during analysis.
(C) is the only one that requires the solution to be finished before it can take place, which is when evaluation happens.

68% of the state got this right. 20% went for B.

Question 3

A local library wants to update its website so that new users can easily access the online catalogue. The most suitable form of user documentation would be a
A. quick start guide.
B. table of contents.
C. technical manual.
D. Help Desk email contact.

Answer is A.

The quick start quide is appropriate for new users since they would only need enough information to get them started.
The other options are not listed in the study design (p.36) as being required, which is a clue that they would not be right, but still look them over...
A table of contents (B) does not actually give useful information... it only tells you where the information can be found.
A technical manual (C) is irrelevant to users' needs.
An email contact (D) might be handy, but as the sole source of documentation it would be inconvenient for staff, and slow for users to get supplied with information.

71% of the state got this right. Nearly everyone else chose B.

Question 4

A physical device that can help prevent unauthorised access to data and information on a network is
A. a PIN.
B. a swipe card.
C. a thumb print.
D. an encryption key.

Answer is B.

Ha! They got it right this year (considering the dog's breakfast they made of it in 2010.)

A PIN - Personal Identification Number - is data, not a physical device, as is an encryption key. A thumb print is biometric data, and while it is physical, you don't usually refer to your fingers as 'devices.'
Well, I don't anyway. My toes, however, are a different matter.

I'll give the examiners a Stamp Of Approval as an cheery encouragement award.

Stamp of Approval

65% of the state got this right.

Question 5

A solution developer wants to test the efficiency of using the date convention of mm/dd/yyyy for an online sales form to be used in a global market. He tracks the results of 100 users who were required to enter the current date using this convention. The best measure to indicate the efficiency of using this convention is
A. how quickly each user enters the date.
B. the percentage of users who enter complete dates.
C. the number of users who accurately enter the current date.
D. the number of error messages received by users to indicate incorrect date order.

Answer is A.

When you get a question with the words "efficiency" or "effectiveness" in them, it can be easy to eliminate options. To measure efficiency, the only option that refers to time, money, labour or ease-of-use is the issue of time/speed implied in (A).
The number of people entering complete dates is a matter of accuracy, which is an effectiveness measure.
(C) is also obviously an accuracy measure, and even uses the word "accurately".
The error messages in (D) is also a clear indicator of accuracy, so it can be also ruled out quickly.

55% of the state got this right.

Question 6

Sunny Tennis Club is updating its website to attract new members. It is making decisions about what information will be available for the general public (open) and what will be for members only (closed). Which diagram represents the best decision for the club?

A6

Answer is B.

Rule out (C) and (D) immediately because it's silly to have members' financial or personal data open to the public.
That leaves the question of whether "login & password" should be open to the public.

But I'm wondering what "login and password information" means in terms of a website. Does it mean that lists of users' login names and passwords are open to the public? That would be silly.

Or does it mean that a login page is open to the public - which makes sense since it has to be public so members can get into the 'closed' area of the site. I'd have to assume this one, since the alternative is dumber than a sackful of senile spaniels.

I really don't like the ambiguity of this question. Students should be assessed on their knowledge of ITA, not how well they can work out what the examiners probably meant to say.

Bad dog

80% of the state got this right. Nearly everyone else went for A.

Question 7

Which one of the following would be a non-technical constraint on the design of a school's new website?
A. It must run on the existing classroom laptops.
B. New and existing file formats must be compatible.
C. Students' examination results and attendance reports must be kept private.
D. The size of video files used by teachers for online class presentations must be limited.

Answer is C.

That's the only option that has nothing to do with hardware or software (technical) issues.
Compatibility (A&B) and capacity (D) are technical constraints.

75% of the state got this right.

Question 8

The appearance of a website can be enhanced by having
A. consistent font types.
B. important information underlined.
C. navigation buttons of different sizes.
D. minimum contrast between font and background colours.

Answer is A.

An easy one. Underlining important information on a webpage (A) is bad, since it would be confused with a hyperlink. (C) is the opposite of what you'd want. With contrast, you want the maximum, not the minimum.

66% of the state got this right.

Use the following information to answer Questions 9–11.

The design for an online form to collect financial data from customers is shown below.

A9-A11

Question 9

What is the best data type for the box labelled 'I have read and accept the conditions of purchase'?
A. text
B. image
C. number
D. Boolean

Answer is D.

Again, pretty easy - assuming you know that Boolean fields can only store true/false data.

86% of the state got this right.

Question 10

A security protocol to protect the privacy of individuals entering their data on this form would be
A. stating a shipping and returns policy.
B. encrypting all data before it is communicated.
C. banning users who exceed their purchase limit.
D. accepting orders only from customers who tick the acceptance box.

Answer is B.

Another easy one. Encryption is the only option that actually protects data from misuse.

And since when does any payment form ask users to enter their purchase limit? This is off-world logic.

75% of the state got this right.

Question 11

Which one of the following is the best validation technique for the Country field?
A. a range check
B. an input mask
C. a required field
D. a dropdown box

Answer is D.

I really don't know about this one.

To start off by eliminating the obvious, an input mask (B) is used to ensure the formatting of input data (e.g. of a credit card number) is correct - the dashes are in the right places, characters are text/numeric where they should be, et cetera. This is inappropriate for a text field such as Country.

A range check (A) usually applies to a numeric datum to check that it is within acceptable limits. But a range check could also mean that data is contained within a limited list of options, so it could apply in this case.

(C) is a bit odd. "A required field" is hardly a 'technique', but let's ignore poor expression for a minute. Making the Country field required would make sense if the organisation had foreign customers: the question does not specify whether it does or not. Making it a required field, would ensure a value was entered, but it would not check that it was a legitimate country. So it's not as valuable as A or D, which do force users to enter a valid item.

In (D), a "dropdown box" is another rather quaint examiner term, like the "drop list" they used in the in question A12 in 2008. Most people talk about dropdown lists or menus, not boxes. But let's assume they meant one of those... A dropdown list or menu is a way of enforcing selection from a limited list of acceptable options (see above), even though choosing a country from a list of approximately 200 items is rather frustrating. (You can see it in action in eBay's 'Advanced Search' page, under 'Location'.)

So, in brief, it could be (A) because it could restrict input data to those that match an item existing in a limited list.
It won't be (B), so cross that out.
(C) is a validation technique, but options A and D provide the same service, but offer more value.
(D) is a control that enforces option (A) and additionally stops the user free-typing, which is always a good idea.

So let's say (D).

I wish the examiners would stick to standard names for input controls!

70% of the state got this right. 21% chose C.

Use the following information to answer Questions 12 and 13.

The local cinema holds a monthly mini-festival, where the owner chooses a famous director and screens a selection of their movies. To assist with matching directors and movies, the owner has decided to create a relational database management system (RDBMS) based on the following tables.

A12-A13

Question 12

The primary key in the Movie table ensures that
A. a movie has a unique identity.
B. a director has a unique identity.
C. two directors cannot have the same LastName.
D. a director cannot be credited with the wrong movie.

Answer is A.

Students would need to recognise that after the names "DirectorID" and "MovieID" was this symbol...

primary key zoomed

means that the field is a primary key for that table. However, when printed at about 11 points in an exam the symbol is very obscure. The version shown above was only obtained after zooming the PDF of the exam in to 800% !

The primary key field (or fields) of a table is used to uniquely distinguish each record in that table from all of the other records in that table. This is why your parents gave their children different names, unlike in the Newhart TV show, where one character always introduced himself with "Hi, I'm Larry; this is my brother Darryl, and this is my other brother Darryl."

The primary key is usually an account number or arbitrary ID that can be generated by the organisation and guaranteed to be unique, unlike names or other real personal data.

Let's walk through the answer.
- Option (B) relates to the Director table, not the Movie table referred to in the question. However it is true that the DirectorID field uniquely identifies each director in the Director table.
- It would be unreasonable to expect that no two directors in the history of cinema can have the same LastName, so (C) can be eliminated without knowing anything about primary keys. Thank Dog for common sense.
- It would be beyond the scope of a database to prevent a data entry person crediting a director with the wrong movie. I could tell a database that Fred Smith directed Spongebob Squarepants Goes Mental - and how could the database challenge me unless it was equipped with artificial intelligence and a link to IMDB? So common sense eliminates another option!

And yes, I do hope they make Spongebob Squarepants Goes Mental. I really do.

Mental Spongebob

75% of the state got this right.

Question 13

The relationship the owner has created between the primary key in the Director table and the foreign key in the Movie table is needed if fans using the website want to
A. sort the movies in order of release date.
B. search for all directors born in the 20th century.
C. sort the directors' last names in alphabetical order.
D. search for movies in a particular language by a director.

Answer is D.

A relationship between tables allows the looking up of related data: in this case, the connection between a particular director and a list of movies. A single table gives information about one topic, such as directors, without reference to related information, such as their movies. So, you can find their last names (C) and dates of birth (B) without a relationship to another table.
To sort movies by name (A), you don't need related information about their directors, so that's not it.
The only option that draws data from both tables is (D)... you need the Director table to get the director's name, and the Movie table to find the language of the director's movies.

58% of the state got this right. 27% chose C.

Question 14

Analysing the needs of an online community involves
A. determining what results are expected from test data.
B. monitoring users' complaints about the existing system.
C. observing the results of sample data used to test the new system.
D. interviewing community members to determine evaluation criteria.

Answer is B.

I nearly said (D) because common sense says that interviewing members directly focuses on finding out what the community believes would make their site successful.

But, determining evaluation criteria - according to VCAA's definition in the study design, page 16 - occurs during the design phase of the Problem Solving Methodology, not during analysis - the phase specified in the stem of the question - so we have to rule out the superior method of conducting interviews.

We can eliminate Options (A) and (C), which are about testing, which comes well after analysis. This leaves (B).

I've said it before and I'll say it again - why can't evaluation criteria be determined during analysis where solution requirements are determined?

53% of the state got this right. 28% chose D.

Question 15

New employees use photocopy USER IDENTITIES from 999 to 1999. Test data to display an 'INVALID USER IDENTITY' message would be
A. 998 and 2000
B. 1000 and 1998
C. 999 and 1999
D. 999 and 1998

Answer is A.

998 and 2000 are both invalid data, so they would test both ends of the 'invalid spectrum'.
The other options do not test any invalid data: all of those values are valid

91% of the state got this right.

Question 16

The primary purpose of a proxy server is to
A. keep an organisation's network secure.
B. forward data between computer networks.
C. connect multiple devices together to act as a single network.
D. accept requests from clients seeking resources from other servers.

Answer is D.

Most home users think of a proxy server as a cache for recently-downloaded web files, but to be technically accurate, a proxy acts as a go-between when clients seek resources from other servers. Most proxies are now web proxies.

Proxies have several other functions, including caching of files, keeping clients anonymous, auditing user requests, scanning traffic for malware, blocking undesired sites etc.

42% of the state got this right. 32% chose A.

The primary purpose of a proxy server is to accept requests from clients seeking resources from other servers. This statement describes the relationship between servers. The proxy server is smart; its primary purpose is to identify and send requested resources to other servers.

Question 17

A business with more than 100 employees tests its disaster recovery strategy by simulating a fire and power failure. A criterion to evaluate the effectiveness of the strategy to protect the integrity of customer data would be to ask
A. can the back-up copies of customer data be quickly accessed?
B. is the customer data restored within 30 minutes of power returning?
C. are all back-up copies of customer records up-to-date and complete?
D. are all appropriate software companies contacted within 60 minutes?

Answer is C.

This is the twin sister of question 5 above. The key word is 'effectiveness', so you should know what to look for in the options.
Options (A) (B) and (D) are all about speed, which is an efficiency measure.
Only (C) refers to effectiveness measures - quality, accuracy etc.

You can answer this question with no knowledge of disaster recovery.

81% of the state got this right.

Question 18

When a medical clinic in country Victoria implements its new information system, the managers select and delete all the patient files from the hard disks before donating the old computers to the local primary school. In doing this, the managers have
A. done all that is required under the Health Records Act 2001.
B. prevented a threat to confidential data by unauthorised users.
C. not met their legal obligations under the Health Records Act 2001.
D. followed the correct procedure for the disposal of data under the Information Privacy Act 2000.

Answer is C - but a judge could rule against me. I don't like it.

The IPA only applies to Victorian state government departments and agencies, so rule out (D).
(B) probably really should refer to people damaging original data rather than seeing copies of the data.

They are subject to the HRA, so, it comes down to the requirements of the Health Records Act.
Have they met their legal obligations or not?

Section C, part A says an object of the act is to "require responsible handling of health information in the public and private sectors". In the Health Privacy Principles, Principle 4, "Data Security and Data Retention", it requires that "An organisation must take reasonable steps to protect the health information it holds from misuse and loss and from unauthorised access, modification or disclosure."

This is where it gets argumentative. The clinic "deleted all the patient files from the hard disks before donating the old computers."

So choose one of the following:
a. Deleting the data was Good. That's reasonable. Choose option (A).
c. They failed to wipe the disks, so deleted files could be undeleted. That's unreasonable. Choose option (C).

What are "reasonable steps" in this case? My opinion is that it would be reasonable to expect a competent medical clinic to be aware of the risks of simply deleting files without wiping them. So I go for (C).

This question, I believe, is unreasonable. This should not have been a Multiple Choice question, since it requires justification of the answer, and more than one option could be rationally argued for. It would take a judge to listen to arguments from counsel about what is 'reasonable' in this case.

46% of the state got this right. Everyone else went nearly equally for the 3 other options.

The managers have not met their legal obligations under the Health Records Act 2001 when disposing of patient data. Selecting and deleting the patient files from a hard disk does not ensure the data cannot be recovered. The managers should have overwritten the data in the files before donating the computers to a school. They could have used software designed to do this.

Use the following information to answer Questions 19 and 20.

A designer setting up an RDBMS for a medical clinic prepares the following entity-relationship (ER) diagram to represent the relationships between a Patient, Doctor, Diagnosis, Medication and Appointment.

A19-A20

Question 19

In which position would PatientID be best represented?
A. u
B. v
C. w
D. z

Answer is C.

This is really getting on my wick. This format of a Chen-style ERD is solely based on an example given in VCAA's sample ITA questions published in 2010. Nowhere are the colour codings explained. What does the grey shading mean exactly? We have to interpret that it indicates a key field. Why? Because the sample ERD has ID fields in its white elipses. Where is this explained? How are students meant to deduce that key knowledge from the 2010 sample question?

And if the colour coding is in fact some sort of official rule mandated by the precedent of the sample question, the exam question itself has violated it because in the sample questions, entities are black with white text: in the exam question, entities are white. Is that significant in some mysterious way?

These VCAA ERDs are home-grown interpretations of Chen-style ERDs, with no industry-standard authority to them that I can find. Even if they appear in a textbook, it's inadequate: texts are non-canon, and non-compulsory - and not always correct, come to think of it.
Asking specific questions about an arbitrary format is, I think, unfair.

So... students have to decide that position W is correct because (compared to U and V) its colouring is special, so it must be a special sort of field, which means it is probably a key field. Not sensible.

Now curious about ERD formats, I noticed that the sample 2010 question had a credit to conceptdraw.com, so I went there to find what wisdom they have about ERD symbols and meanings... there was no indication there about the meanings of shadings, but they did show various cardinality indicators which VCAA ERDs completely and sadly lack.

So let's compare VCAA's sample ERD...

VCAA ERD

with the one from conceptdraw.com, using Chen's notation...

ERD

Nope. No special colour coding of key fields in there... key fields are underlined. They also provided a handy legend to explain the formatting conventions used, which VCAA should have done in their 2010 example. But they can't spell "refers". Never mind.

So let's visit Wikipedia's page on ERDs... where we also find that Chen-style primary key attributes are underlined, not colour coded.

So I'm wondering what industry-standard source of knowledge gives VCAA the confidence to ask questions about the colour scheme of a home-made diagram type that has not been explained anywhere that I can discover in IT Applications documentation or in The Real World ™?

VCAA can reply here... I'm very curious to know, because all of this bolding is hurting my CTRL+B fingers.

64% of the state got this right. 21% went for D.

Question 20

What does position 'y' represent?
A. MedicationID
B. doctor gives patient medication
C. doctor diagnoses patient's condition
D. name of medication given to patient

Answer is B.

It's not an attribute - at least VCAA obeys that shape rule. So it's not (A).
Diagnosis (C) is shown at the top-left corner of the diagram, so this section won't be related to diagnosis.
The name of the medication (D) would be one of the attributes stemming from the Medication entity.

64% of the state got this right.

END OF SECTION A

Overall - not really happy with the fairness of several questions.
 

 

 

SECTION B - Short answer questions

Go up to section A

[x lines] indicates how many ruled lines were provided on the paper for the answer

 
Instructions for Section B

Answer all questions in the spaces provided.

Question 1

(3 marks)

Question 1 (3 marks)

a. State one purpose of the Spam Act 2003. 1 mark [2 lines]

Any of these will do:

  • To regulate the sending of commercial emails and other types of commercial electronic messages.
  • To prohibit the sending of unsolicited commercial electronic messages.
  • To prevent the use of address-harvesting software.
  • To force commercial email senders to provide a working unsubscribe link and information about who the sender is.

Average mark 0.6/1. (60%)

Successful responses indicated that the Spam Act 2003 aimed to stop unwanted emails sent by a business. Examples included ‘to prevent unsolicited commercial emails’, ‘to stop companies sending emails to people who don’t want them’, ‘make businesses provide an unsubscribe button for people on their email list’ or ‘prevent businesses using address-harvesting software to send bulk emails’.

b. Give one example of an online social protocol. Explain its purpose. 2 marks [3 lines]

Any of these...

  • No flaming (personally abusing someone) - protects members' feelings and maintains a friendly atmosphere.
  • No swearing - so people are not offended; keeps a site child-friendly.
  • No uploading of copyrighted materials - so the site doesn't get into trouble.
  • NO SHOUTING - because it's annoying and rude.
  • Stay on-topic - so people are not flooded with material that is irrelevant to them
  • No flooding (of messages, pictures etc) - to prevent overwhelming other people's inboxes or download bandwidth
  • Obey the moderators - So law and order prevails and the site doesn't go feral and uncontrolled.
  • Do not discuss the existence of the site anywhere else - to protect an underground site's anonymity
  • No use of fraudulent identity - to prevent people's reputations being attacked if they are impersonated
  • No cyberbullying or harassment - because it can have horrible effects on people
  • No posting of inappropriate information - again, to protect sensitive souls and children.

There are hundreds of others. Just be sure to explain its purpose if you expect both marks.

Average mark 1/2. (50%)

Most students could identify an online social protocol; for example, ‘You must not use capital letters (uppercase text) because it’s considered to be shouting’. However, many students did not explain the purpose of the protocol; for example, ‘Shouting will frighten some users and stop them from giving their point of view’.

Question 2

(4 marks)

Question 2 (4 marks)

A wedding photographer wants to place the images from each couple's wedding on his website so that the couples can select the images they want for their albums. The photographer wants to ensure that the images cannot be viewed or stolen by unauthorised users, or accidentally deleted by his staff.
In the table below, recommend equipment or a procedure that could be used to address each problem listed. Provide a reason for each recommendation.

Problem

Equipment or procedure

Reason

images stolen by unauthorised users

Usernames and passwords required to view pictures

Only authorised people can enter the picture area.

images accidentally deleted by authorised users

Regular backups of pictures

Deleted pictures can be restored if necessary.

Suggesting the setting up of a VPN would probably be over-the-top in this case.

Average mark 3.3/4. (83%)
This question was very well answered.

Problem

Equipment or procedure

Reason

images stolen by unauthorised users

Have a closed section of the website that only couples with the correct password can access.

Creating a closed section where each couple has a password that allows them to access their images will prevent others from stealing or viewing the images.

images accidentally deleted by authorised users

Regular backup procedure for the images on the website.

This means there will always be copies that can be restored if they are lost.

 

Question 3

(5 marks)

Question 3 (5 marks)

The owner of a business that sells flower seeds to plant nurseries has decided to create a website with an online order form, believing it will improve her business.

a. Explain two ways in which the decision could increase sales. 4 marks [8 lines]

  • The website would have a global reach and greatly increase the business' potential customer base.
  • The website can provide a lot of promotional information about the seeds and the business to encourage people to buy.
  • The website can provide live data about seed stock levels so buyers don't get annoyed to find their order will take weeks to be filled.
  • People can buy at any time of day or night, even when the business is unattended.
  • People from anywhere in the world could order quickly and easily.
  • When buyers enter their own data, this would decrease data-entry effort for the organisation.
  • Quick transactions will boost the business' reputation for quality service, and encourage buyers to return.
  • Fewer staff will be required to man the sales desk or handle telephone enquiries since the sales and information will be online. This will save wages money for the business.

Average mark 2.8/4. (70%)
Responses to this question most frequently covered the 24/7 access and geographic reach of the internet.
Online order forms have 24/7 access so that ‘customers can order at any time’. This increases the hours available for business, leading to the possibility of increased sales.
They can also be ‘accessed immediately by people browsing’ or ‘using search engines’, which ‘increases the number of locations the business can reach’ and ‘leads to increased sales’.

b. Identify one benefit of direct data entry by customers. 1 mark [2 lines]

  • If buyers enter their own data, there is less need for data-entry effort for the organisation, so staff can either be reduced to save on wages, or the staff could be used for more profitable tasks.
  • There will be less chance of data transcription errors when re-typing data provided by customers (e.g. a customer might have a thick accent that makes it hard to understand them.)

Just be sure not to say the same thing for (a) and (b). If you ever find you are repeating yourself, something is probably wrong.

Average mark 0.7/1. (70%)
Most students gave one of the following two responses to this question.
Direct data entry is more accurate because
 details are only entered into the system once, hence reducing the possibility of further entry errors
 the person ordering is more likely to spell their own name and address correctly.

Question 4

(2 marks)

Question 4 (2 marks)

A large game development company is creating a multi-player online game to meet the needs of online gamers. The company wants its website to have a members-only section to support its collective identity.
Select two functionality factors from those listed below.

accessibility - navigation - structure - usability

Explain how each would suit the needs of online gamers. [Each explanation got 2 lines of writing space.]

Accessibility

Players with disabilities, such as colour-blindness, poor muscular coordination, poor vision etc would find the site easier to use.

Navigation

Being able to go to different parts of the site with minimal confusion. clicking and page-loading will save members time and increase their visiting pleasure because they won't get lost as much or have to click as often. A simple example is having the site logo always being a link to the homepage; and having a "Back to the top" link at the bottom of each page.

Structure

Organising a site logically makes it easier for members to intuit where they should go to find desired resources, for example having the site divided principally by the different games on offer lets a player easily choose where to go to find information relevant to the game he/she plays.

Usability

A site that is easy to use saves the user time and frustration when seeking particular resources. For example, one site might require a click on an item to go to a download page where another click is required to start the download. Another more usable site would create a direct download link on the first page where the item appears.

The word "two" in the instructions was not bolded, which is odd.

Average mark 1.2/2. (60%)
Many students chose navigation and accessibility as the design elements for discussion.
 Navigation: To feel comfortable in the virtual scenario, online gamers ‘need to find information easily and move quickly to what they want’.
 Accessibility: Gamers need text, audio and video modes to provide information quickly in a game situation because individuals respond differently to different media. Some get more details from audio, others from text and others from images.
 Structure: Gamers want their website organised into secured and non-secured sections so that members can privately reward and celebrate gaming achievements and build their collective identity.
 Usability: A gaming website must allow gamers to confidently, easily and accurately issue game instructions, or else they will leave.

Question 5

(5 marks)

Question 5 (5 marks)

A travel firm has upgraded to a new, networked, online sales system in each of its three offices.
It is considering what type of user documentation is most appropriate. Some staff want an online tutorial, but the manager believes content-sensitive help is the best option.

a. Describe how an online tutorial and content-sensitive help would each assist a staff member with using the new system. 2 marks

• online tutorial [5 lines]

A tutorial is a self-paced, step-by-step teaching tool which explains operations and demonstrates how they are done, often providing quizzes or revision to test learning. A tutorial would help staff members who are beginners and need to learn the system from the basics.

• content-sensitive help [5 lines]

This provides information based on the user's current behaviour and status. For example if they have a picture selected, the content-sensitive help would offer help on working with pictures. This type of help is useful for trained users who need relevant help as they use the system.

Average mark 1.4/2. (70%)
Most students could describe how online tutorials would help staff who are learning to use a new online sales system. They were less able to describe how content-sensitive help would be beneficial in this scenario.
Typically, correct responses described online tutorials as providing ‘step-by-step instructions on how to use all the features of the software’ and content-sensitive help as ‘providing help for a particular/specific problem at the time when it is needed’.

b. Justify your preferred user documentation on the basis of efficiency. 3 marks [8 lines]

There are arguments for providing both help systems; choosing between them is silly since they are meant to provide very different services. It's like asking a gardener whether she would want a shovel or a rake.
Effective tutorials will create users who are knowledgeable and skilled and who will work faster and with less effort than those who have no pre-training and must rely on the content-sensitive help alone.
The content-sensitive help would help people quickly find the help they need when they need it, thus saving time for them and saving money for the firm.
If I can only choose one form of documentation, I'd choose the tutorials, since completely untrained users would not know how to even begin, and they would be very slow, put in a lot of wasted effort and cost the firm lots of money in wages and lost sales.

The key to this question is to discuss only time (speed), cost, labour, and ease of use. Anything else is effectiveness and therefore irrelevant.

The very possibility that only one type of documentation is required is unrealistic.

Average mark 1.6/3. (53%)
Students who chose content-sensitive help, arguing that it is ‘used only when needed’ and that users do not have to waste time working on ‘features they will never need’, received marks.
Many students chose an online tutorial as the more efficient type of documentation, arguing that by learning the ‘whole package up front, users are less likely to stop for lots of little problems’, and that having the ‘big picture’ means users are more able to solve little problems themselves. These responses were awarded marks. The few students who argued coherently for other types of user documentation also received marks.

Question 6

(5 marks)

Question 6 (5 marks)

The receipt shown below is provided by BestFood supermarket as a transaction record.

B6-receipt

A number of formats have been used to enhance the effectiveness of this receipt.

a. Identify one format and explain how it has been used to enhance the receipt's effectiveness. 2 marks [3 lines]

  • The bold, large typesize of the supermarket's name makes it stand out and easy to find.
  • The decimal point-justification of the prices makes their values easier to interpret.
  • The left-justification of the products and the right-justification of the prices makes each item's data clear and uncluttered.
  • The full justification of the EFTPOS data makes the data visually attractive.
  • The white spacing and ruled lines between vertical sections of the receipt separates the data into related segments.
  • The formatting of the date in standard Australian dd/mm/yy format makes it easy to understand.
  • The use of 24 hour format for the time makes the time unambiguous.
  • The bolding of the receipt rewards text makes it easier for the customer to notice since it may be of value to them.
  • The leading (line spacing) between lines has been increased to prevent text forming hard-to-read clumps.
  • Capitalising "SUBTOTAL" makes the important information stand out.
  • Adding the number of items bought before the word "subtotal" makes it easy to see if the dirty, lying, no-good lousy rotten customer has tried to sneak excessive number of items through the "8 items or fewer" lane, thereby deserving a good remedial slapping by the manager.

Average mark 1.5/2. (75%)
This question was well answered. Examples of common responses include ‘bolding title font’, ‘separating the sections with spaces or lines’ and ‘using a table format to present purchases and prices’.

b. State three steps the developer could follow to test that the receipt provides accurate information. 3 marks [5 lines]

  • Manually calculate the cost of goods and compare them to the receipt's total.
  • Choose items that include or do not include tax to verify that the tax is only being added when necessary.
  • Compare the time and date of the text with the time/date recorded on the receipt to make sure they are accurate.
  • Manually calculate the number of reward points to confirm that the reciept's statement is accurate.
  • Make sure that Boz was actually the manager when the receipt was produced.
  • Ring the phone number on the receipt to see if the supermarket answers.
  • Manually compare the ABN number with the number in company records to see that it is typed correctly.
  • Eat the chicken and determine whether it really is worth nearly $13. Damn, that's an expensive bird.

Average mark 2/3. (67%)
This question was answered in two different ways. Both received marks.
Many students chose three different items on the receipt and suggested how to test each. For example, ‘scan a whole hot chicken and see if the amount is correct, manually calculate receipt rewards and check with receipt total and see if it is in the store, and hand calculate the items and check the total’.
Other students described a three-step testing procedure to check the accuracy of the calculation. For example, ‘determine test data for five random grocery items, manually calculate the total and compare the expected total to the automatic total of the scanned items’.

Question 7

(6 marks)

Question 7 (6 marks)

Harry manages a business that hires out fishing boats. The business has eight boats. Harry keeps records of the number of hours that each boat is hired. Each boat has a captain who is paid an hourly rate of $20 for a four-person boat and $30 for a six-person boat. A sample of the records and the data table that Harry keeps is shown below.

Boat and Captain data table

B7

Harry has normalised the data so that each field cannot be divided any further. This is shown below.

Boat and Captain data table revised

B7

a. Normalise this data into two tables so that each non-key field is fully dependent on a key field (2NF). 4 marks [33% of a page was given for the answer]

Just to show my working, I started with Version 1, the logical solution...

ERD2

Then I thought that adding the CaptainID field would be unnecessary if each boat had only one captain, so I thought of Version 2, which avoided the creation of the new CaptainID field...

Normalised table

But the Captain_Table now has no single key field - the CaptainLastName+CaptainFirstName together would have to act as a key. And since the question said that "each non-key field is fully dependent on a key field" (not "a key" which could comprise more than one field) I decided to settle on Version 1 after all. Maybe I was reading too much into the question?

This solution assumes that each captain only has one boat, since the question says that "Each boat has a captain". If not, the schema would get a lot messier!

Also note that each boat only appears once in the sample data, suggesting that the "Boat Hours" figure is a running total, rather than the number of hours of a single voyage. This implies to me that you do not need a "Voyages" table to record multiple voyages and that the total hours are just updated in that single field.

Average mark 1.6/4. (40%)
Most students could separate the data into two data tables as part of completing the second normalisation of the data table. However, many did not give titles to the new tables or create primary keys. Those students who did typically used Captain Table and Boat Table for the table names and CaptainID and BoatID for the primary keys.
Very few students addressed the problem of where the BoatHours field should be placed. Each captain’s pay depends on data collected from the hiring transaction point being entered into this field. Those who placed the field in the Captain Table received marks. Others who correctly used design diagrams to represent two complete tables, their fields and primary keys also received marks.

b. Explain why this process would be important to Harry's boat-hire business. [3 lines] 2 marks

Actually, since there is a simple 1:1 relationship between boats and captains, the 2NF normalisation is actually of minimal value - actually, it's unnecessary. However, if a captain could work on several boats, the benefit would be greater since changes to boat or captain information could be done once in only one table rather than in several different places. Or if each individual booking of a boat needed to be recorded, a relational database would be needed.

With refernce to Harry, it would be important because it would make the management and future development of his database easier, and (if it actually needed more than a 1:1 relationship) the database would be faster and smaller.

Normalisation is important because it

  • groups related data to make data management tidier
  • allows data to related data that could not be accessed before
  • reduces data repetition
  • avoids errors where data is not updated consistently in several places
  • keeps the size of the database down and speeds up data retrieval
  • ensures the database can grow in future without hitting a brick wall imposed by poor early design
  • allows easy reporting on single tables, such as searching/sorting/printing lists
  • can prevent the accidental deletion of key data (e.g. key fields) that are needed by other tables (referential integrity)

I can appreciate that the examiners were trying to make the normalisation question easier this year, for which they get the Stamp Of Approval.

Stamp of Approval

The problem is that by making the schema so simple that it did not need a 1 to many relationship, it scuttled the value of normalisation, which was the whole point of the exercise.

Average mark 0.9/2. (45%)
Many students stated that the process of normalising one large flat file improves the accuracy of the information Harry can produce. These students received one mark. Those who completed their answer with an explanation of why this is the case received full marks. For example, ‘creating two tables with primary keys reduces data redundancy’ and ‘allows only a single point to update data’. Some students explained that creating two tables with primary keys ‘makes it possible to create relationships and simple queries’. These students also received marks.

Question 8
(6 marks)

Question 8 (6 marks)

Nancy is the administrator at Melbourne City Secondary College, a government school. She has been asked to sell archived students' details to a marketing company. If Nancy does sell these details, she intends to use the money to buy sports equipment for the school.

a. Identify key legislation that must be considered before Nancy decides whether or not to pass on the students' details. 1 mark [2 lines]

  • The Information Privacy Act 2000.

This is a tricky one. I am not at all sure whether Victorian government schools are classified as being part of the Victorian Public Service, which would invoke the IPA. I've checked the IPA Act and am none the wiser because schools are not mentioned. Is a state school "a body established or appointed for a public purpose by or under an Act" or "a public sector agency"? I sure as hell don't know, and I doubt that ITA kids would or should know either.

I'm pretty sure Victorian state schools would not be subject to the Privacy Act, but I imagine many big ones could turn over more than $3 million a year. So they might be. How big is Melbourne City SC?

I've written to the Privacy Commissioner to get some clarification on this one.

11 November - the Privacy Commissioner's office has replied and confirmed that state schools ARE subject to the IPA. This greatly affects part (c).

I wish the examiners would choose an organisation whose legal status was very, very clear and stay away from these murky special cases.

Average mark 0.5/1.. (50%)
Information Privacy Act

b. Explain Nancy's ethical responsibilities to the students and Melbourne City Secondary College. 2 marks [6 lines]

To Students - protect their physical and emotional wellbeing, and protect their personal information from disclosure or misuse.
To the College - to take reasonable steps to protect student data from misuse, damage, loss or unauthorised access.

The question does not focus on her responsibilities regarding student data. To list her ethical responsibilities in general would be irrelevant and very verbose. It needed more precise wording.

Students here need to notice the question has two parts, and they should address both the students and the college.

Average mark 1.2/2. (60%)
Students needed to consider Nancy’s ethical responsibilities towards two stakeholders: the students and the school. For example, Nancy has a responsibility to make sure past students’ details are kept private and she has a responsibility to her employer, the school, to follow all school procedures when conducting school business.

c. Recommend a strategy to help Nancy resolve the ethical dilemma. 3 marks [7 lines]

What ethical dilemma?
Who said she has an ethical dilemma?
Students were not asked to identify any ethical dilemma!
It's just assumed she has one.

She is bound by the IPA (according to the Privacy Commissioner's Office), so she has a legal responsibility not to sell student data, so there is no ethical issue. It's like asking whether it's ethical to murder someone: you have no choice in the matter. The law dictates what is right and wrong. Ethics don't enter into it!

This question causes more of a dilemma than Nancy ever faced.
I keep telling kids not to turn an ethical dilemma into a legal one, but it seems the examiners are making it very hard for them to do that.

Let's assume for a moment that the question is bad, and they examiners want students to talk about Nancy having to decide whether to sell student data for the sake of money for sports gear. In that case, you'd compensate for the bad question and go on about...

- Nancy must decide which is better: to sell student data and possibly adversely affect students' privacy; or to not sell the data and not be able to buy the sports equipment which would benefit the students.
- Nancy could use a decision support framework (e.g. college policies) to see what administrators should do in such cases.
- She could refer to the college's code of ethics to decide what to do.

Dare I suggest that she impose sanctions upon herself to teach herself a lesson?

This is not a good question.

Average mark 1.4/3. (47%)
Responses that coherently outlined a strategy Nancy could follow were awarded marks. Most frequently, strategies included consulting with stakeholders, locating relevant information, evaluating the options, applying a process for making decisions and recording (or publishing) decisions.

Question 9

(8 marks)

Question 9 (8 marks)

Pine Industries, a timber company, is considering two different designs for its new website. The home page must contain the title, a logo, links to five major sections, a copyright statement and options for a range of other languages. Pine Industries hopes to raise community awareness of its environmental projects. The two designs have been prepared and are shown below.

design 1

B9

design 2

B9

a. Select one design element related to appearance from those listed below.

consistency orientation contrast

Explain how this design element has been used in each design to enhance the appearance of the Pine Industries website. 4 marks

Again, the number "one" in the question was not bolded on the paper.

selected design element: consistency

use in design 1 [4 lines]

  • Each link has its text followed by an icon - the icon makes it quicker to identify the link at a glance without having to read the text.
  • Each link is in uppercase - this makes the links stand out from other text on the page.

use in design 2 [4 lines]

  • Each of the links is shown as white text on a black background - this groups the links and makes them visually stand out from other items on the page.
  • Each link is in uppercase, which again makes them visually stand out.

selected design element: orientation

use in design 1 [4 lines]

  • The links are oriented vertically so they stand out on the left of the page.
  • The title is vertical, which makes it stand tall, like a subliminal tree without branches.

use in design 2 [4 lines]

  • The links are grouped horizontally, which... makes them easier to read (?)

selected design element: contrast

use in design 1 [4 lines]

  • The "Feature of the week" box and text are black upon the grey tree logo, so the text is not obscured by the logo.
  • The white icon image stands out from the dark grey icon background.
  • Overall, the page features black text on a white background, which makes it easy to read.

use in design 2 [4 lines]

  • The links' white text on black background is very readable.
  • The other text is black on a white background, which is also very readable.

Average mark 2.9/4. (73%)
Complete answers provided an example of the chosen design element and an explanation of how it was used to enhance the appearance of each website. For example, ‘contrast is seen in design 1 with the logo – a grey tree on a white background. This catches the reader’s eye and gives an underlying idea of what the site represents’.

In design 2, reverse blocking in the navigation bar (white text with black background) contrasts with the black text on white background for the remainder of the website.

Accepted answers for the design element of orientation included the use of either vertical (design 1) or horizontal (design 2) navigation links that complemented other design features. For consistency, students typically referred to font type and size, explaining that changes in font size appropriately matched the hierarchy of information; for example, the largest font size was allocated to the name of the organisation, with the copyright statement being in the smallest font size.

b. Recommend and justify your preferred home page design based only on functionality. Your response must make reference to two design elements that are related to functionality. 4 marks [8 lines]

  • I prefer design 2.
  • It does not have overlapping information (e.g. the text on the logo in design 1) which still tend to obscure the text even if the contrast is not so bad.
  • Its links are grouped well, and near the top of the page where they are quickly found.
  • There are links to copyright and further information that are easy to find, but don't get in the way.
  • All of its contents are appropriate and relevant to the Pines mission.

Note how I used dotpoints for the answer - it makes life easier for you and the exam marker because you are well aware of where different points beginning and end, and the marker can see you can differentiate between ideas.

The study design's glossary defines functionality design elements as "structure, usability and accessibility, including navigation and load time, appropriateness and relevance."

Did anyone prefer design 1?

I predict that most students did not know what the functionality design elements were, and just repeated what they said in part A of the question.

Average mark 1.7/4. (43%)
Students who began by stating a preferred design and identifying two design elements associated with functionality established the foundations for a good answer. For example, ‘design 2 is my preferred homepage. In relation to functionality it provides better accessibility and navigation’. Students who went on to explain how features in their preferred homepage influenced each design element received marks. For example, ‘Accessibility is improved with larger and bolder links and black writing on a white background’ or ‘it makes it easier for older people to read’. Navigation is easier due to ‘the consistency of the menu placement’ or ‘navigation bar at the top and the logo’.

Question 10

(10 marks)

Question 10 (10 marks)

Fruit First wants to take orders online and manage its sales effectively. Examples of Worksheet and Data table designs that the manager can use are shown below.

Worksheet

 

A

B

C

D

1

FruitName

QuantitySoldPerKg

PricePerKg

Total

2

Apple

 

 

 

3

Cherry

 

 

 

4

Peach

 

 

 

5

Raspberry

 

 

 

 

Data table

FruitName

QuantitySoldPerKg

PricePerKg

Total

Apple

 

 

 

Cherry

 

 

 

Peach

 

 

 

Raspberry

 

 

 


Hang on a spaniel-slapping minute - what does "QuantitySoldPerKg" mean? Does it mean the number of kilograms sold of each fruit, or the number or each fruit that constitute a kilogram?
I can only assume the meant to say "KgSold" or "QuantitySoldInKg" or somesuch. An opportunity to award the first Illiteracy Award for the year.

Indicate with a tick one software type that your answers will refer to.

spreadsheet (SS) tickbox relational database management system (RDBMS) tickbox

a. Explain how the manager could
• report on sales trends for each fruit
• identify the fruits that have had more than 500 kg in sales
• test that the solution operates as intended. 6 marks. [1.5 blank pages for the answer]

SPREADSHEET OPTION

• report on sales trends for each fruit

  • Create a bar chart of QuantitySoldPerKg (or Total, depending on what 'Sales trends' means) showing all 4 fruits.

But 'sales trends' usually refer to sales over time. The data has only one data point for each fruit. How can you show trends with a single data point? That's why I answered 'bar chart' instead of 'line graph'. It does not make much sense to me, unless the examiners meant to say "Sales figures" instead of "Sales trends."

Confused

• identify the fruits that have had more than 500 kg in sales

OK. What does "identify" mean in this context? "Find and Isolate"? "Highlight"? The question is too vague to mandate a strict answer.

  • Use conditional formatting to highlight cells in row B with a value >500.
  • In row E, use a formula like =IF( B2 > 500 , "Over 500kg!" , "" )
  • Use a filter to find values in row B over 500.

• test that the solution operates as intended.

  • For each fruit, enter valid values for QuantitySoldPerKg, PricePerKg and compare the spreadsheet's Total value with a manually-calculated answer.

RDBMS OPTION

• report on sales trends for each fruit

Well, this is a problem. Does MS Access do charts? I have no idea. I know that Filemaker didn't create charts up until very recently. Perhaps student could cheat and say "Create a chart..." and dare the examiner to guess what make and model of RDBMS they used for their SACs.

Without chart functionality (as my kids last year would have been), you'd have to say something like...

  • Create a report listing each fruit and its corresponding QuantitySoldPerKg.

Any other suggestions?

Confused

• identify the fruits that have had more than 500 kg in sales

Well, again we have fun. Filemaker has had conditional formatting functionality for a couple of versions now. I can't speak for MS Access. Again, kids could just repeat the spreadsheet answer and dare the examiner to prove them wrong. The only alternative would be...

  • Create a query/find (Filemaker) like "QuantitySoldPerKg > 500" and display the found records.

• test that the solution operates as intended.

  • For each fruit's record, enter valid values for QuantitySoldPerKg, PricePerKg and compare the database's Total value with a manually-calculated answer.

Average mark 2.8/6. (47%)
Many successful explanations of how the manager could perform the three tasks were set out under the three subheadings shown below.
Report on sales
Many students explained that the manager could use a graph to report on sales trends for each fruit. Some drew graphs to represent a trend calculated from the QuantitySoldPerKg or Total columns. Others explained how a trend graph or table could be created. For example, ‘calculate the QuantitySoldPerKg for apples in Jan, Feb and March and make a graph to see if sales are going up or down’ and ‘Use the Total column/field to compare the sales of each fruit for three weeks and report it in a table.’
Identify fruits with sales greater than 500 kg
Successful responses included a conditional statement or formula QuantitySoldPerKg > 500. Those who chose spreadsheet software explained how this statement could be entered into the column and return a message of ‘Yes’ or ‘sales above 500 kg’ or ‘font colour change’ if the condition were true. Those who chose RDBMS software explained how the statement could be used in a query or filter to return a list of fruits whose sales were above 500 kg.
Test the solution
Data to test the report of fruit sales typically included varying values for QuantitySoldPerKg so that the trend was altered as expected. For example, ‘change the data from increasing to decreasing and see if the graph changes in the same way.’
Data to test the fruits with sales greater than 500 kg were most commonly 499, 500 and 501. Statements such as ‘below the boundary, at the boundary and above the boundary’ also received marks.

b. Using the software that you selected in part a., answer the following questions.

i. Describe how the manager can identify and display on a web page the cheapest fruit available. 2 marks [5 lines]

"display on a web page"? Do the examiners want students to come out with something as trite as "Open a web page editor, create or load the web page, type in the number, save the page and upload it with FTP"? That really would be a waste of a year of study.

Or do the examiners expect student to explain how to extract the data from a spreadsheet or database, feed it into a webpage with PHP, SQL, Cold Fusion or whatever and display it? I'll be spanked with a saucy sausage dog if I could explain how to do it.

Either way, the answer will either be trivially simple, or monstrously difficult.
I think the examiners need to go and sit on the naughty step and think about what they've done.

To identify the cheapest fruit is a different matter, but not much easier if you think about it.
To find the mininum price is easy with the MIN( ) function, but the question asks for the "cheapest fruit" (i.e. its name) fruit to be displayed. This is very hard to do in Excel.
Refer to the ITA paper for 2008 question B12e which asked a similar question. The answer then would have to have been
="The biggest sales were for " & INDEX( A2:C12 , MATCH( MAX( C2:C12 ) , C2:C12 , 0 ) , 1 ) & " which sold " & MAX( C2:C12 )


FEEDBACK

Laurie suggested using VLOOKUP, which was a good idea. This would work...
=VLOOKUP( MIN(C2:C5) , price_table , name_column, FALSE ) 
But you'd need the prices in the first column of the table, and you need FALSE for the range lookup if the fruits are sorted by name rather than by price. I wonder how many kids would be capable of such a formula, however.

Roland suggested GoogleDocs spreadsheet with the security pegged at a public view setting for putting the value on a web page.


SPREADSHEET

The dumbest, but probably expected answer is:

The manager should:
- put the formula =MIN(C2:C5) in the cell where the minimum price should be shown.
- look at the answer very carefully with his/her eyes, open a web page editor such as Adobe Dreamweaver, create or load the webpage in question, type the value into the page using a QWERTY keyboard and managerial fingers, carefully save the page, and upload the HTML file to the web server using FTP.

Is that really what the examiners were after? Or did they want something like...

- Sort the fruits in acending order by the PricePerKg column so the cheapest fruit appears at the top.
- Look at the answer very carefully... (etc)

I only hope they accept variations of answers for their vague and impossible question.

RDBMS

- Create a calculated field (Filemaker) or an expression in a query with the formula MIN(PricePerKg) and display the value in a report.
- Look at the answer... (etc)

Average mark 0.9/2. (45%)
To gain full marks students had to clearly state the technique for identifying the cheapest fruit as well as a way of presenting this information on a web page. Accepted answers included sorting the price per kg column or field from lowest to highest (technique) and either displaying the cheapest fruit name in a text box or bolding it.

ii. Recommend a format or convention that the manager could apply when displaying the cheapest fruit to the user. 2 marks [5 lines]

Use a leading dollar sign, then the price with 2 decimal places.
O, and use comma separators to separate the thousands if the cheapest fruit is over $999.99.

Really - they gave 5 lines of writing for that? What else could one say? Black Arial 12 point?

Average mark 1/2. (50%)
There is still some confusion regarding the difference between a format and a convention. A convention is a generally acceptable rule governing the layout or presentation of a format – for example, a receipt has a date; however, the way in which the date is presented or arranged is a formatting decision. There are a variety of date formats such as 28 February 2013; February 28, 2013; 28/02/13; 28-02-2013.
Examples of accepted formats and conventions included a title (convention) or the title being in bold or in all capitals (format) or a title (convention) with an image (format) of the cheapest fruit.

Question 11

(9 marks)

Question 11 (9 marks)

Healthy Cooking is an online community where users can share information about cooking for a healthy lifestyle.

a. Design a screen mock-up for a new forum page that meets Healthy Cooking's need to

• provide an identity for the site
• offer recipe books for sale under food categories and allow users to proceed to a secure check-out
• allow users to communicate safely. 6 marks.

 

b. Annotate your design with explanations to show how it has met these three user needs. 3 marks [Half a page blank for the answer to parts a and b]

There are many approaches to achieving this - here is one attempt. Yours would probably want to be less frivolous, 'cos the examiners tend to be Very Serious People who don't seem to appreciate levity.

B11

The main thing is that you try to provide something that looks like a standard webpage, with conventional adornments such as logos, large heading, underlined links, login/password combinations, Privacy policy/Contact links etc.
Then you need to address the specific needs of the question and show where those needs have been met.
I don't think most students would have any trouble with this question.

11a - Average mark 3.9/6. (65%)
Successful designs included words and/or icons to represent each of the following requirements specified in the design brief.
 a title and logo
 forum
 indication that the forum is reached by login/password
 link to recipes with three clear food categories
 link to a checkout
 some indication that the checkout is secure.

The design below is a compilation of examples taken from many successful responses. The design shown features a padlock symbol next to the ‘Shop’ link, indicating a secure payment process. There were many other successful responses. Some, for example, included a shopping trolley symbol and/or the word ‘PayPal’ in their design.

11A answer

11b - average mark 1.7/3. (57%)
Annotations that made clear statements about how links/fonts/images met users’ needs received full marks. In the examples above, the design feature being discussed is clearly identified at the beginning of each explanation.

Question 12

(7 marks)

Question 12 (7 marks)

Kelly is a writer who keeps a data table of the images that she uses in each of the 12 chapters of her new book. The table has the following field names.

FileName, Chapter, FileFormat, Description, FileSize

When she sorts the Chapter field of her data table, she gets the following result.
Chapter1
Chapter10
Chapter11
Chapter12
Chapter2
Chapter3
Chapter4
Chapter5
Chapter6
Chapter7
Chapter8
Chapter9

a. Explain why this happens. 2 marks [3 lines]

Because she has defined the Chapter field as being of type TEXT, the chapter names are being sorted purely as text with no recognition of the value of the position of the numerical digits. In that way, "12" comes before "2" because the digit 1 is alphabetically before the digit "2".

This is the same knowledge as was tested in ITA 2011, question A13. I still think its domain is more SD than ITA. Only 13% of kids got it right in 2011. I wonder how many will get it right this time...

Average mark 1/2. (50%)
Many students explained that the data type was text and as such 10, 11 and 12 ‘have no place value’. This means only the ‘1 is compared to 2, 3 and 4’. These students received full marks. Others who stated that the problem arose because the numbers were sorted as text received one mark.

b. Recommend a procedure that Kelly could follow to ensure chapters are displayed in the correct numerical order. Explain how she could test the procedure. 3 marks [6 lines]

Fixing: Insert leading zeroes as place-holders, such as Chapter01.
Testing: After inserting the leading zeroes, sort the chapters again by the Chapter field and check that they are now in the correct order.

Notice how the question had two parts to it and my answer was very clearly divided into two parts as well. Don't mix one answer up in another as a large amorphous blob and give the impression you can't tell the difference between them.

B11b was a very trivial question, in my opinion. A bloke off the street could have guessed that one without a year's intensive study IT.

Average mark 1.4/3. (47%)
Many students suggested that Kelly remove the word ‘Chapter’ from the list and use it as a heading or label. She could then ‘change the data type to number and sort the list’.
Other students suggested Kelly add a leading or spacing zero or format mask so that all the ‘number’ parts of the data have the same number of characters; for example, ‘Chapter01, Chapter02, etc’. Then when Kelly sorted the text data, ‘Chapter02 is less than Chapter11’.
Those students who went on to recommend that Kelly should then test her solution by sorting the list and checking that the output was as expected, received full marks.

c. Kelly wants to list all of the GIF-formatted images (.gif) that are less than 50 KB.
Explain how she could efficiently create this list. 2 marks [3 lines]

She should create a query/find of this sort:
FileFormat = "gif" AND FileSize < 50

Average mark 0.9/2. (45%)
Students who stated that a query needed to be created and correctly wrote the query were awarded full marks. The commonly provided correct answer was: FileFormat = GIF AND FileSize <50

 

END OF QUESTION AND ANSWER BOOK

 

Overall - some unfair and unclear questions, in my opinion. My self-appointed Board of Review recommends:

  • A1 - if a key knowledge dotpoint says "including A,B and C" and there is a question about that dotpoint, do not include 'incorrect' options that are in fact true and accurate, but are not A, B or C. The word "including" means that A, B and C must be taught, not that only A, B and C exist.
  • the official ERD format (A19, A20) needs to be formalised according to the conventions of The Real World ™. There should be no more home-baked standards that noone else uses. Students are supposed to be able to interpret these 'standards' with nothing more than one sample question in 2010. If the ERD was meant to be of Chen style, do it properly, with underlined key field names in attributes. It is no harder for students to learn, and actually reflects what real people do in the industry.
  • The 'Cheapest Fruit' question (B10) was a mess. Achieving the goal properly (showing the name of the cheapest fruit) would be effectively impossible for secondary students. Showing it on a web page would either be trivially inane (typing it in) or basically impossible (using code to extract the value and insert it into dynamic HTML.)
  • The legislation question involving a school (B8) was also nasty. It is not at all clear (to me at least) whether a school falls under the IPA. If it does, there is no moral dilemma as claimed by B8c because the administrator's planned actions would be illegal rather than immoral.
    Since question B8c insists that there is a moral dilemma, it follows that Nancy has freedom of choice because there are no legal impediments, so the answer to B8a must be "No law applies." Very messy indeed.
    B8c should not have insisted that there was a moral dilemma. Students should have been asked whether there were a moral dilemma or not, and if so what it was. In this way if a student believed that schools were not subject to the IPA and said "No law applies" to B8a, he/she could then roll out the moral dilemma consequence in B8c.
    Recommendation: organisations used in Privacy legislation questions should have their nature very clearly obvious to students who lack a degree in law. i.e. stick to the classic categories, e.g. a private org turning over > $3m, any org holding health info.
  • The other legislation question (A18) about what is "reasonable" when disposing of computers is also, I think, unfair for a section A question. It requires an argument because the answer is really a judgement call, an opinion based on known ITA facts. Students could argue that simply deleting files might be reasonable in this case because the chance of primary school kids undeleting files and misusing data is minuscule. Others could argue that stricter deletion protocols are reasonable. The problem that in Section A, there is no way for students to make such arguments in support of their answers.
    Recommendation: Section A questions should contain only issues that are a matter of fact rather than of opinion and judgement, which should be in section B where students can justify their answers.
  • The information in A6 about where the login/password information goes was unclear. What does "login and password" "information" actually refer to? Is it the actual list of login names and passwords that the wording implies? Or does it refer to login and password facilities used when logging in? The distinction between the two materially affects the choice of answer. Such ambiguity is an unfair burden on students who are trying to show their understanding of ITA.
  • Way too many marks went to peripheral issues like sorting text, and design elements. The weight of websites was also overpowering.

MARK BREAKDOWN

For the first time ever in an IT Post Mortem, I did a rough survey of where the marks went in terms of key knowledge.
The topic was assigned according to the real main focus of a question, so while A17 was talking about security issues, it needed to be answered with knowledge of efficiency/effectiveness and required no understanding of security at all.

The main results were:

Main topic Marks
Databases
10 (if spreadsheets used in B10)
20 (if databases used in B10)
Websites 22
Design Elements 8 whoa!
Data Security 7
Documentation 6
Ethics 5
Sorting text 5 !
Testing 4
Efficiency vs effectiveness 3 (including A17)
Laws 3
ERD 2
Formatting 2
PSM 2
Data types
Validation
Hardware (proxies)
1 each

 

Student Feedback

Hu - I'm a Year 12 student who completed the ITA exam a few days back, and......kind of annoyed with it, to be honest. I'm not sure what the official makeup of the exam is meant to be, but we were taught about different types of cabling, what routers and network cards do, what type of network was best for a certain business (bus, star, etc.). I just find it strange that there was nothing on the exam relating to what we were taught in the first term of Year 12 in ITA.

Top of page

Back to the IT Lecture Notes index

Back to the last page you visited

Created 5 November 2013

Last changed: November 19, 2014 1:02 PM

VCE IT Lecture notes © Mark Kelly 2001-

Original Content © Mark Kelly 2013
Images and questions © Victorian Curriculum and Assessment Authority 2013.
Reproduced here with permission.