VCE IT Lecture Notes by Mark Kelly

IT Applications

VCAA Exam Post Mortem

2010

VCE IT Exam Post Mortem

 

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.

Previous Post Mortems - enjoy the full collection!

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:34 PM

State average results added - 3 Feb 2011.

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.

 

And the exciting Illiteracy Award.

 

 

SECTION A - Multiple-choice questions

Go to section B

 

Victorian Certificate of Education 2010

INFORMATION TECHNOLOGY: IT APPLICATIONS
Written examination

Tuesday 9 November 2010

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

11

11

70

 

 

 

Total 90

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

Materials supplied

  • Question and answer book of 19 pages.
  • Answer sheet for multiple-choice questions.

Instructions

  • Write your student number in the space provided above on this page.
  • 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.
  • All written responses must be in English.

At the end of the examination

  • 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.

It was pleasing to see that many students were able to draw on practical exercises completed during their studies in order to demonstrate their
understanding of the key knowledge and key skills associated with the study design.
Students' ability to provide specific and technically accurate examples in a range of scenarios indicated that the study content had been covered in breadth and depth. Most students understood the key knowledge associated with formulas comprising conditional, nested and lookup statements of spreadsheets.

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


Each team member playing an online game would need at least
A.  antivirus software, a computer, camera and scanner.
B.  an operating system, scanner, browser and an Internet connection.
C.  an Internet connection, computer, browser and operating system.
D.  an operating system, antivirus software, an Internet connection and camera.

Answer is C.

Cameras are probably not necessary for most games, at least, so rule out A and D.
Can't see how a scanner is needed, so eliminate B.
Give the remaining option a check, just in case. The components look reasonable, so go for C.

State average was 92%

Question 2


When restoring from backup the least complicated backup to restore from is
A.  full.
B.  partial.
C.  differential.
D.  incremental.

Answer is A.

To restore a full backup, only one operation is required because everything was saved into it.
The other options probably require the restoration of several smaller backups since the last full backup was done.

I'm still confused about the differences between the non-full backup options. Having done a fair bit of research, all I can conclude is that hardly anyone agrees what they actually mean.

State average was 56%

A full backup is least complicated because it requires less equipment and fewer decisions and procedures.

Question 3


The best equipment to detect unauthorised access to a password-protected file would be
A.  keyboard swipe.
B.  encryption software.
C.  closed circuit television.
D.  virus protection software.

Answer is C.Keyboard swipes!

This is a strange question.
What on earth is a 'keyboard swipe', pray tell? If it's a swipe card reader mounted on a keyboard, the examiners should have made that a lot clearer. If it's not that, Dog only knows what it means. Anyway, I'll eliminate it.
Encryption does not detect anything. It makes information unreadable to unauthorised people.
Antivirus software has got nothing to do with it.
That leaves only C - and CCTV is hardly a main ICT tool. Strange. It will be fun reading the examiner's report on this question!

Intensive Googling has found nothing called "keyboard swipes"... so I made my own ;-)

State average (after my complaint to VCAA) was 100% .

The student responses (for those who are interested were: A=22%. B=43%. C=9%. D=26%.

After considerable debate amongst IT teachers, noone has any real clue about what the answer is.

  • "Keyboard swipe" does not exist. A keyboard-mounted swipe card reader might exist, but the question did not say that.
  • The question could have meant "prevent" instead of "access", but it didn't say that.
  • None of the options would detect access to a file (authorised or not). Audit trails would, but they are not an option.

Good News - 2 December 2010. A letter arrived from VCAA which said in part:

"In relation to VCE IT: IT Applications, Section A Question 3: Following consultation with the examination panel and study specialists, we have decided this item should not be used for differentiating student performance on the examination. Consequently, all students have received full marks for the question."

Woohoo!

Question 4


The best conventions for a financial report include
A.  titles, column headings, right-aligned text.
B.  titles, left-aligned text and bold for date.
C.  column headings, left-aligned numeric data and date.
D.  right-aligned numeric data, date and bold for totals.

Answer is D.

You rarely right-align text <A>. Rule it out.
<B> is reasonable. Question-mark it.
You right-align numeric data (or centre on the decimal), so rule out <C>.
<D> is all reasonable, and has more relevant information than <B>, so <D> is a better answer.

State average was 57%

 

Question 5


What transmission media gives the fastest speed in a network?
A.  wireless
B.  fibre optic
C.  microwave
D.  unshielded twisted pair (UTP)

Answer is B.

Fibre optic cable speed is (to use a technical expression) MEGAHUGE: submarine cables manage 2.56 Terabits per second (2.56 thousand gigabits = 256,000 times faster than a Gigabit network card!)
Microwave is high bandwidth, but not as fast as FOC.
Wireless, if you want to be pedantic (who, me?) includes microwave, but if you mean 802.11 wi-fi, it's only 54Mbps (theoretical maximum.)
UTP is generally gigabit nowadays.

State average was 80%



The spreadsheet below relates to Questions 6, 7, 8 and 9.

spreadsheet

A plant nursery keeps track of its tree sales and discounts using the spreadsheet shown below. Tree sale discount percentages are automatically returned from the Bulk Discount cells.

 

Question 6

When the Quantity of Iron Bark trees shown in cell D5 changes to 300 the value in cell F5 changes automatically to
A.     0
B.  10
C.  25
D.  50

Answer is D.

It's using a VLOOKUP - the original quantity of 60 has a matching discount of 10. Quantity 300 has a discount of 50.

State average was 85%

 

Question 7

The plant nursery needs to know the lowest unit cost per tree. The most appropriate formula to calculate and cell to display this is
A.  =MIN(C1:C8) in cell C2
B.  =MIN(C2:C8) in cell C2
C.  =MIN(C2:C8) in cell Cll
D.  =MIN(C2:C12) in cell Cll

Answer is C.

To start with, it can't be <A> or <B> because each would wipe out data in C2. Cross those off.
Unit costs are in cells C2 to C8, so <C> makes sense.

<D> is basically the same as <C> but it includes itself (C11) in its range of data (C2:C12), causing a self-referential error.

State average was 82%


Question 8

The best formula to return the correct discount % rate in cell F2 which can also be filled down or replicated in cells F3 to F8 is
A.  =VLOOKUP(D2,I$5:J$8,l)
B.  =VLOOKUP(D2,$I$5:$J$8,2)
C.  =HLOOKUP(D2,$I$5:$J$8,2)
D.  =VLOOKUP(D2,$I5:$J8,2) *D2

Answer is B.

Be careful with these questions. Miss that "H" in <C> and you'd be misled. It is VLOOKUP (looking up vertically) so <B> is out.
Multiplying by D2 makes no sense in giving a discount rate, so rule out <D>.
When filling formulas down, parts of cell references prefixed by $ are locked so they stay the same as the formula is copied to new locations. We want references to I5 and J8 to stay like that regardless of where the formulas are copied to, so it points to the right range of cells containing the table. So both the rows (5,8) and columns (I,J) need the dollar signs.

Which brings me neatly to one of my hobby horses. The dumb dollar signs that make life so unpleasant are not necessary most (if not all) of the time.
Anyone with a brain bigger than a bandicoot's will name the range I5:J8 something like TABLE and change the formula to =VLOOKUP(D2,TABLE,2)

Isn't that far better?

State average was 74%


Question 9

Data to test the formulas in the spreadsheet would be entered in cells
A.  D2:D8
B.  G2:G8
C.  I5:I8
D.  J5:J8

Answer is A.

Pretty easy one. Changing values in the range in <A> adjust the quantities, which lets you test the looked up discount values.
<B> contains formulas, so no data can be entered there. Knock that on the head.
<C> and <D> would change the values returned by a lookup worked, but would not test that the right value was being returned.

State average was 68% ... 19% went for B.

 

Question 10

The best software solution to protect a file from unauthorised access while being communicated over a wireless network is
A.  firewall.
B.  encryption.
C.  read only attribute.
D.  password on the file.

Answer is B.

<A> protects computers from attack, but not files being transferred.
<B> would make the transmission unreadable (see note below)
<C> is irrelevant during transmission.
<D> would not stop it being accessed in transit.

Choosing <B> assumes the question means that the communication and not the file is encrypted: it's ambiguous and not well written.

State average was 60%... 28% chose A

 

Question 11

Mark has decided to keep all his picture files in one folder on his computer. Which list of file formats should be grouped in the picture folder?
A.     gif, pdf, doc, jpg
B.     bmp, xls, gif, tif
C.     jpg, bmp, gif, tif
D.     tif, gif, jpg, pdf

Answer is C.

doc <A> and pdf <D> are not a picture file formats. Yes, both can contain pictures, but they are not picture formats.
Otherwise you could call a wardrobe a type of clothing because it has shirts in it.

State average was 85%

 

Question 12

The efficiency of the automated matching process of an online dating agency can best be evaluated by checking
A.  accuracy of information returned about clients.
B.  time required to match two clients.
C.  suitability of possible matches.
D.  how long the match lasted.

Answer is B.

Paying attention to the word "efficiency" makes it easy: time taken to process is an efficiency issue.
Rule out <A> because accuracy is an effectiveness criterion.
<C> is also a quality criterion.
How long the match lasts is a human and not an ICT issue.

State average was 70%


Question 13

The best procedure to prevent data loss when files are edited in an online application such as a wiki is
A.  autosave.
B.  a swipe card.
C.  biometric login.
D.  magnetic storage.

Answer is A.

A swipe card and magnetic storage are not procedures.
Biometric login protects information from unauthorised access, but does not protect the data after access is gained.

State average was 81%

 

Question 14

A company expects its new website to increase its market share by 20% over the next six years. This is an example of an organisational
A.  goal at a tactical level.
B.  goal at a strategic level.
C.  objective at a tactical level.
D.  objective at a strategic level.

Answer is D.

This is new one to me. We've always handed goals and objectives, and strategic/tactical timeframes, but I've not seen them combined like this. The better students probably managed to think it through.
The 20% indicates a specific objective, so rule out <A> and <B>. The long timeframe smells like a big strategic ambition. The only matching combination is <D>.

State average was 39%

A plan to increase market share by 20% is an objective as it can be measured. Planning six years ahead is long term and made at the strategic level.

Question 15

IT trainers are paid by Wendy. They email their invoices for payment to Wendy and they are paid after Wendy has completed the administrative process.
Wendy is taking leave and she needs to provide a flowchart of the process for her replacement. Which flowchart best represents the process?

flowcharts

Answer is A.

You need to be calm and logical with these scary looking decision trees. Once again, ruling out dumb options is an easy strategy.
In <C> we have a decision arrow not branching from a decision. That does not happen in proper flowcharts.
In <B>, you would not loop back if the process were finished!
Similarly in <D> you would not loop to the end if the process were unfinished. You'd loop back to do more processing.

State average was 84%

 

The solution design below relates to Questions 16 and 17.

The solution design below shows the relationships between four tables in a relational database created for a group of music teachers who work in different schools.

ERD

Question 16

The relationships A, B and C all create links between
A.  primary keys in different tables.
B.  common fields in different tables.
C.  calculated fields in different tables.
D.  archived records in different tables.

Answer is B.

Common and archived records are irrelevant. Calculated fields can't be used as key fields (in Filemaker anyway). And all of the linked fields are marked as key fields in their "home" table.

I said 'A' for this one. I have never heard of "common fields" as a defining type of field. I missed the tiny keys beside the field names, which explains why I went for A instead of B. I pity kids with less than 100% vision reading that question!

State average was 71%

 

Question 17

If each music teacher can be in more than one school then relationship B is
A.  one-to-one.
B.  one-to-many.
C.  many-to-one.
D.  many-to-many.

Answer is B.

A teacher can appear only once in the teacher table, but can appear many times in the schools table.

I don't know why they put the "(B)" in the phone fieldname. It contributes nothing and is just distracting for students.

State average was 73%

 

Question 18

When evaluating the effectiveness of a timeline in monitoring the development of a solution, you should consider
A.  time and effort needed to complete the Gantt chart.
B.  cost and effort needed to test the solution.
C.  clarity of the layout diagrams of the solution.
D.  accuracy of the estimated time needed to develop the solution.

Answer is D.


It's another effectiveness/efficiency question.
<A> is efficiency.
<B> is irrelevant because it's talking about testing the solution, and it's an efficiency measure anyway.
<C> is effectiveness, but it's irrelevant because it relates to layout diagrams, not the timeline.

State average was 60%

Effective monitoring of the development of a solution relies on an accurate estimate of development time.


Question 19

The best preventative strategy to minimise loss of data during electrical storms is
A.  updating printer software.
B.  replacing network cables.
C.  listening to weather reports.
D.  testing the Uninterrupted Power Supply (UPS).

Answer is D.

The filters in a UPS can protect computers against power surges. Testing the UPS can ensure it's working and being protective.

State average was 93%

 

Question 20

Security staff must pass every test in a training course with a score of 50% or more. The course has three tests: Safety, Rules and Crowd Control. Test scores are kept on the spreadsheet shown below.

training tests

Which formula entered in F3 and filled down or replicated in column F would most efficiently indicate a correct P (Pass) or N (Fail) result?
A.  =AVERAGE(B3:D3,"P","N")
B.  =AVERAGE(B3:E3,"P","N")
C.  =IF(B3>=50,IF(C3>=50,IF(D3>=50,"P","N"),"N"),"N")
D.  =IF(B3>=50,IF(C3>=50,IF(D3>=50,"P","N"),"P"),"P")

Answer is C.

For a start, <A> and <B> make no syntactical sense. The average function does not have IF superpowers.
Read through <C> like this: if test1 is a pass, then if test2 is a pass, then if test3 is a pass, then you pass overall. All other options are fails.
<D> has way too many ways to pass.

It's hard to tell if the examiners have goofed with options A and B - after last year's performance, it's a toss up. Why have 2 options that are equally idiotic? Did the examiners mean to say =IF(AVERAGE(B3:D3)>=50,"P","N") or something similar? We'll never know.

Anyway, the use of nested IFs is certainly a dumb way to solve the problem. Anyone with reasonable skill would have used this:
=IF(AND(B3>=50,C3>=50,D3>=50),"P","F")

If the examiners want to model efficient data processing practices, why do they use such unskilled techniques like $ signs in cell references and nested IF statements? Why spend such a lot of time and effort learning such complex and arcane skills when it's just not necessary because there are quicker and easier methods?

State average was 56%. 29% chose D.

All three cells – B3, C3 and D3 – must be greater than or equal to 50 for a pass.

END OF SECTION A
 
Overall - not bad!
Tougher than last year.
A nice challenge for good students.
No questions that could've been easily answered by a retarded cockroach.
A couple of WTF...? moments but nothing fatal.
The best Section A for many years.

Good dog

Good dog!

 

 

SECTION B - Short answer questions

Go up to section A
 
Instructions for Section B

Answer all questions in the spaces provided.

Question 1

For the directory path HardDrive C:\Staff\Reports2009\Absences.doc, describe the relationship between Reports2009 and Absences.doc. 1 mark. 2 lines. State average was 0.7.

Reports2009 is a folder/directory that contains Absences.doc.

Most students recognised that Absences.doc was a file in the 2009 Reports folder.

Question 2

David is the manager at Iceland Golf Club. He is creating a database of all members, their contact details and membership cost and is preparing a data structure table as part of his design.
Complete the three entries in the Data Type column of the data structure table below. 3 marks.

Field Name

Data Type

Description

Member ID

Text

First three letters of last name and a four digit integer

Last name

Text

Last name of member

First name

Text

First name of member

Home phone

TEXT

(03) 9 4 1 6   8 5 1 2

Date of birth

Date

Date of birth of member

Membership cost

NUMBER,
CURRENCY,
SINGLE PRECISION

Membership cost Adult $500, Junior $150

Is membership paid?

BOOLEAN

Financial status of member Paid or Not Paid

 

No, phone numbers should never be stored as numbers. Numbers cannot contain the parentheses and spaces shown in the description.

I'm not too sure why the digits were underlined. Maybe it was suggesting an input mask or something else that Filemaker users don't have.

State average was 1.9

Question 3

The owner of a company with its head office in Melbourne and five other offices in country towns wants to upgrade the network operating system (NOS) and the application software used on the company's network.

a.    State one function of a network operating system in this company.1 mark

It authenticates users as they login.
It allocates resources based on users' privileges, such as IP addresses, home directories, printer access.
It runs community service software such as backups, virus scans, download caching etc.

At each office the technicians want both an instruction manual and online content sensitive help for the new software.

State average was 0.3

Responses needed to mention the controlling or monitoring function of a network operating system and what it controls
or monitors, such as files, passwords or peripherals.

b.   Explain why the technicians would want staff to have both types of user documentation. 2 marks

They serve different purposes.
Instruction manuals are detailed reference sources explaining how the entire application works.
Content sensitive offers help related to users' current activities, so it's relevant to their active needs.

State average was 1.1

Accepted responses referred to a booklet 'helping staff to solve easy problems without having to go online' or 'contact
the help desk'. Other students correctly indicated that a booklet 'is available when a network or telephone connection is
unavailable'.

c.    Explain how online content sensitive help works. Give an example to support your answer. 2 marks

Help is offered based on what objects the user is currently using or places the user is currently in.
Examples include:

  • tooltips that appear to explain what a control does;
  • right-clicking in a table to bring up a menu with items like add rows, cell shading, border width.
  • something as simple as "DD/MM/YYYY" next to a date field to indicate what data format is expected.

State average was 0.7

Many accepted responses described users activating help by hovering over or clicking an item to obtain assistance with
a specific problem. Full marks required the inclusion of a suitable example.

The owner decides to compare the efficiency of the instruction manual and online content sensitive help,

d.   Recommend a strategy the owner could use to test the two options. 3 marks

Tell a typical user to use each source of help to find out how to perform some software function. Time the user and find which help source gave the right information faster and/or with less effort.

State average was 1.2

Strategies that included a plan to set up two situations derived from the scenario and that measured and compared the
results received full marks. For example, divide the users into two groups and for six months let one group use both the
booklet and the online content sensitive help. Let the other group use only the online content sensitive help. Measure the
time it takes for each group to solve similar problems and compare the results.

Question 4

City Secondary College's school concert is being held on Thursday, Friday and Saturday nights at the school hall which holds 300 people. Families can book up to eight tickets for any one night at a time. All tickets cost $10. A section of the online booking form design is shown below.

booking form

a.    Recommend an electronic technique for the Night field to enhance the likelihood of inputting accurate data. Justify your choice. 2 marks

Use either a drop-down menu control, or a set of three radio buttons (one button for each night). In either case, a night must be entered, and not more than one night can be entered at a time.

State average was 1.4

A drop list or a combo box listing the three nights was accepted as an electronic validation technique. Many students explained that this reduced errors because it listed only the available options or that the options were spelt correctly..


b.   State two types of tests for checking the online booking form. 2 marks

Night must be filled in.
Number of tickets must be between 1 and 8.

This is a badly, badly written question.

It does not say what aspect of the form should be tested. Does it mean validation checks (as given above), or tests of the accuracy of the information?

In the latter case, one could say:

Manually calculate the total cost and compare it with the value calculated by the form.
Enter 0 or 9 for the number of tickets and see if the validation rule acts correctly.

Ambiguous and bad.

State average was 0.8

A number of tests for checking the online booking form were accepted, including:
• check the calculation with test data; for example, four tickets at $10 – expected outcome: $40
• check that the data has been entered in the No. of Tickets field
• check that the maximum number of tickets on one order for one night does not exceed eight
• check that the total number of tickets sold for any one night does not exceed 300.
It was disappointing that many students did not score a mark on this question. Validation and testing are key topics in
both units of this study; it is important that students understand the theory associated with each and are able to apply
their knowledge of these topics to given situations


c. If the No. of Tickets field is set as a Text data type, explain how this error could cause a problem when the first booking is entered. Give an example to support your answer. 2 marks

It would not be able to calculate the total cost since it would not be able to interpret the string of numerals as a number. It also would not be able to count the total number of tickets sold for the night without converting the text field to a number first.

Is there some significance to the first booking? Why single out the first booking if the fault will apply to any booking?
Redundant and distracting information - again.

And yes, I realise that students should be able to select and use relevant supplied information, and identify and ignore supplied data that is not necessary for a solution, but this "first booking" information is just unnecessary.

State average was 0.7

Many students recognised that setting the No. of Tickets field to a text data type could cause a problem when the data
entered was multiplied. For example:
• the ticket number needs to be an integer such as 5, not five. It will not calculate a Total Cost $ because it
cannot multiply text data
• it will give an error because 5 is treated as text.

Question 5

A section of a PERT chart used to monitor a project is shown below.

PERT

a.      List the tasks on the critical path. 1 mark

A, C, E, F

This series of tasks is the longest at 11 days. The other paths (A,C,D and B,E,F) are 8 days each.

State average was 0.8

B.  Use the PERT chart shown above to complete the Gantt chart below.
Note: work takes place seven days a week. 4 marks.

 

Task

Duration (Days)

Predecessor

WEEK 1

WEEK 2

M

T

W

Th

F

Sat

Sun

M

T

W

Th

F

Sat

Sun

A

3

none

 

 

 

 

 

 

 

 

 

 

 

 

 

 

B

2

none

 

 

 

 

 

 

 

 

 

 

 

 

 

 

C

2

A

 

 

 

 

 

 

 

 

 

 

 

 

 

 

D

3

C, B

 

 

 

 

 

 

 

 

 

 

 

 

 

 

E

2

C,B

 

 

 

 

 

 

 

 

 

 

 

 

 

 

F

4

E

 

 

 

 

 

 

 

 

 

 

 

 

 

 

There should be dependency arrows from A to C, B to E and D, C to D and E, E to F.

Interesting to see dummy tasks (indicating that the task following the dotted line is dependent on the task before the dotted line even though no work need to be done.)

We won't be seeing Gantt and PERT in the new course.

State average was 2.2

To score full marks, students had to correctly indicate all tasks, the duration and predecessors.

 

Added 19 May 2011 - The official solution in the 2010 ITA Assessment Report was this:

I've got a major problem with this because it's obvious in the PERT that tasks A and B are concurrent

B is not dependent on A
Yet in their Gantt, they've clearly shown task B as being dependent on A.

Then, they went on to leave out fact that that tasks E and D were also dependent on task B through the dummy task.

I hate to think that my kids lost up to 4 marks because of these errors by the examiners.

It's too late to re-mark exams, but it really makes me worry that markers can be given such dodgy official answers when grading papers.

Grrrrr!

A dog's breakfast - but this time it was the answer and not the question that was shocking.

Question 6

Small Creek Fisheries raises fish in ponds. A database manages the information for the feeding of fish and the ordering of fish food. Part of the database is shown in the table below.

Pond ID

Fish type

Number in pond

Food

Food supplier

Feeds per week

Food per fish per
feed
(kg)

Weekly food per
pond
(kg)

1

Trout

1000

Fish pellets

ACME

7

1

7000

2

Murray cod

500

Young fish

TOP

1

2

1000

3

Carp

500

Vegetable pellets

BEST

5

2

5000

4

Salmon

2000

Fish pellets

ACME

7

1

14000

5

Barramundi

500

Young fish

TOP

7

2

7000

6

Yellowbelly

3000

Fish pellets

ACME

3

1

9000

7

Redfin

4000

Fish pellets

ACME

4

1

16000

a.    If the following query was designed

Food supplier = "TOP"   OR  Feeds per week = 7

list the records that would be selected. 1 mark

1, 2, 4, 5

2 and 5 are selected by Food supplier = "TOP"
1 and 4 (and 5 again) are selected by Feeds per week = 7

State average was 0.6

For the datasheet shown, the query Food supplier = 'TOP' OR Feeds per week = 7 would return the records 1, 2, 4, 5, or
Trout, Murray cod, Salmon, Barramundi.

b.   Explain how you could modify the database to keep track of food costs. 3 marks

First, normalise it:

  • Strip all data that is related to food supplies from the ponds table to a second table called "suppliers".
  • In the ponds table, create a new field (Food ID) to identify which food to fetch from the suppliers table.
  • Relate the tables with that field.

Then...

  • In the ponds table, change the Weekly Food Per Pond to a calculated field (number in pond * food per fish per feed).
  • In the ponds table, create a new calculated field, Cost Per Week (ponds::weekly food per pond * suppliers::food cost)

It might look like this

Ponds table...

ponds table

Suppliers table...

You would need to source extra data for the food costs field.

suppliers table

And the data structure diagram...

ERD

Quite a bit of thinking for 3 marks!

State average was 1.3

Most students could explain how to add a cost field to the database and multiply the data in that field by a food per week field to calculate a weekly food cost. Only a small number of students completed the answer with a description of how to present the output from that calculation. For example, 'add a field such as FoodCost per Kg then calculate FoodCost perWeek for each pond and finally generate a weekly report'.

Question 7

A team of young chefs works with students to develop healthy cooking habits as part of the Remote Education Program. The chefs complete progress reports about student skills after each visit to a school. This data is collected and forwarded on to program officials. The young chefs have a Virtual Private Network (VPN) which is accessed through the Remote Education Program website.

website

a.   Identify one feature on the website that the young chefs could use to collaborate on important issues. Describe how it would be used. 2 marks

Feature

The team portal.

The other links are to public information (e.g. publications) that anyone can access.

Description.

It would let only the chefs enter that part of the site so they could collaborate using appropriate tools.

It has to be said that the portal itself does not help them collaborate. It only is a secure gateway to tools that will let them collaborate.

State average was 1.3

Most responses identified the Team Portal link as a feature that the young chefs could use to take them to a login screen
for the Virtual Private Network (VPN). Those who described the steps of clicking the link and completing the login
procedure received full marks

b.   State one design element and explain how it has been applied to improve the effectiveness of the website. 2 marks

Contrast: Strong difference between text and background colours

Proportion: hierarchical heading size makes it clearer what is more important than what.

Clarity & consistency: all headings have inverted colours (white on black)

Usability: easy-to-find links for each type of user.

Orientation: the use of columns for the map and site text prevents the text spreading too widely

State average was 0.9

Accepted design elements included proportion (visual hierarchy), orientation (direction/aspect), clarity and consistency, colour and contrast, usability and accessibility, appropriateness and relevance. Accepted responses included a range of these design elements. Most students could identify a design element but only a minority could explain how it improved the effectiveness of the website.

c.    Design a screen that should appear when the Team Portal link is clicked. 2 marks [half page box]

You'd be expecting a login screen.

There would be a statement about who was entitled to enter.

There would be a username textbox and password textbox adn a submit button.

There should also be a "Cancel" button and/or a link back to the index page for people who got to this page in error.

State average was 1.4

Most students designed a screen with the site title 'Remote Education Program', the page title 'Young Chefs' and a login/password feature for users who clicked on the Team Portal link. Many students forgot to include the main site title 'Remote Education Program'. Other reasonable designs were also awarded marks.

d.   Explain one disadvantage for team members using the VPN to communicate.2 marks

They need an internet connection and computer and sufficient skills to use both.

They have to remember usernames and passwords.

Collaborating virtually often lacks face-to-face contact such as body language, facial expressions, handshakes etc.

They can't taste each other's foods!

State average was 0.8

Students identified a number of disadvantages for team members using the VPN to communicate. These included:
• the program is remote and team members rely on the Internet to communicate
• there could often be connection difficulties
• connection may be slow, difficult to achieve when needed, or there may not be enough bandwidth for video or images when required.


The team members want to collaborate on the development of a team report.

e.    State two rules the team members should follow when developing their report if no moderator is appointed.2 marks

Don't delete other people's contributions without their permission.

No offensive language.

No rude remarks about other collaborators.

Don't hog the resource storage facility with excessively large items.

State average was 1.2

Rules the team should follow when developing their report if no moderator was appointed, included (two of):
• agreed formatting
• no insulting comments about other team members or their reports
• protect the privacy of individual students who are mentioned in reports.

Some members believe the VPN should have a moderator to check that the rules agreed to by members are followed.

f.    Do you agree? Give an example to support your answer.

It's unlikely that a small team dedicated to the same goal would need to be mothered by a moderator. If anyone stepped out of line - e.g. making a mocking comment about another chef's recipe - then their peers would be able to make the offender change his or her ways.

If the team of chefs is large (the case study does not say, so you are within your rights to explain your thinking) then a moderator may be useful in monitoring the use of the site and arbitrating impartially if someone contravenes the team's etiquette.

The request for "an example to support yout answer" suggested to me that the examiners wanted students to say a moderator was a good idea and give an example of behaviour that would make the moderator useful.

It's pretty hard to give an example of why a moderator is not needed!

State average was 1.3

Answers that either agreed or disagreed with the statement and included an example were accepted. Students who agreed, for example, stated 'Yes, because some of the rules have legal implications and the moderator needs to check that student privacy is protected', and those who disagreed stated 'No, because the chefs are professionals and it's a lot of extra work for the moderator'.

 

Question 8

BandicootPhones sells applications (apps) for a small mobile computer which includes a mobile phone that provides voice, text messages and the Internet.
BandicootPhones keeps details of the staff, the phones and personal information about customers. The apps are sold online and a database is used by BandicootPhones to organise the online sales.

Most students were able to read the complex scenario in Question 8 and provide a coherent extended response. When asked to recommend backup media for a company using an online database, many students considered all three areas of concern systematically and justified three recommendations with specific examples.

a.   Would you expect BandicootPhones to use a flat file database or a relational database?

It would have to be relational.

 

Give an example to justify your answer.2 marks

They have different collections of data - e.g. staff, phones, customers, sales - that could not all be stored in a single flatfile database.

State average was 1.1

Students who stated that BandicootPhones should use a relational database and justified their decision with reasons specific to the company were awarded full marks. For example, a relational database of linked tables because the staff, apps and customers' data can be grouped into tables and processed more quickly.

BandicootPhones' sales have increased quickly and it is updating its backup strategy. It has to decide whether to have

  1. removable hard drives or online backup (media)
  2. incremental or full backup (schedule)
  3. close or remote location of backup files (location).

b.   Recommend and justify an appropriate media, schedule and location for its backup strategy. 6 marks

Media

Removable drives are very cheap and have huge capacity. They can be easily taken offsite for data security. Online backups will be quite slow compared to a local hard disk. Can you guarantee the reliability or security of outsourced backup locations?

or

Online backup can be accessed from any location; it's offsite. Portable hard disks are prone to fail.

Media
Removable hard drives, for example, because they are:
• cheap and can hold a lot of data from the online sales
• easy to connect and store
• still available if the Internet is down.

Schedule

It's not a matter of one or the other, it's both. Full backups should be done weekly, with small and quick incremental backups happening each night.

Were the examiner's seriously suggesting that students decide between full and incremental as their only backup strategy? Madness, if they were.

Schedule
Daily incremental backup and weekly full backup, for example, because:
• if sales are increasing over 24 hours they need to update backup data daily
• a daily full backup would be too time-consuming.

Location

Close - quick to retrieve the backups in case of data disaster.

Remote - increased chance that a disaster that killed the primary data would also destroy the backups (e.g. bushfire)

Didn't like the wording of this: what is "close"? The next room?? The next building? The next suburb?

If the examiners trying just to get students to say "don't store backups onsite", how can they tell what a student knows if the student said "Close" meaning "in the next suburb", as opposed to "remote" meaning " in a different city altogether."

Bad, vague wording!

State average was 3.8

Location
• in a close secure/fireproof location where they can be easily used as part of the regular backup
• in an offsite location where they can be retrieved quickly but not damaged if a fire occurs in the building
A range of other reasonable responses were accepted. In general, responses to this question were pleasingly comprehensive and coherent. Most answers discussed backup media, a backup schedule and a location for the storage of backup files. Many students referred to the rapid increase in sales or online sales when justifying recommendations for BandicootPhones.

Question 9

A company sells fashion items online to customers who sign up and login to its website with a FashionUserlD. As part of the sign-up process customers complete an online form that includes their email address, mailing address, favourite colours and annual salary.
Cheryl manages the database of customer details and the web pages where the images and prices of fashion items are displayed.
Cheryl's boss has asked her to create a second set of web pages so that customers who earn more than $50 000 a year see web pages with prices 20% higher than normal.

Huh? Who in their right mind would supply their annual salary to a shopping website? This is just silly.

a.    Describe how Cheryl can use the database to decide what web page should be shown to each customer. 2 marks

'Use a script.'

Damned if I know. What is this question getting at? I can only assume it's a CMS if it contains customer information AND webpages. There must be some scripting available (I've played with Joomla and have not found any scripting - yet) which selects a page based on some field value in the customer database.

Dog only knows what students made of this. How many of them have worked with CMS websites, or know how they work? Were the examiners just expecting a uselessly-vague answer like "use a script". I bet that's the best they will get from most students, and they'd better be happy giving marks for it.

In last year's infamous spreadsheet question they expected "Use a macro" even though it was patently an absurd solution. Have the examiners drifted off into unrealistic fairy technology land again?

Don't like that question at all.

State average was 1.0

Responses that described a technique which could be used to identify customers who would be directed to the website with higher prices received full marks. Examples included:
• filter/sort the customer salary field into those who earn over $50 000 and show them the higher prices
• use an IF statement to direct higher earners to a second web page or where normal prices are replaced by higher prices.

b. What question would you ask Cheryl about the ethics of creating a second set of web pages for customers who earn more than $50 000 per year? 1 mark

  • Do you feel comfortable using information that customers supplied in good faith to rip them off?
  • Why don't you tell your boss you won't do it?
  • Do you see how this is an unethical thing to do?

Again, I can't see the point of this question. Why would you question Cheryl at all - it's not her fault what her boss orders. I know that these ethics questions are always difficult to think up - and this one is not a good one.

State average was 0.5

Responses that asked the Cheryl a question about deception or dishonesty were awarded a mark. For example, 'Do you think it's right to make people secretly pay more just because they work hard to make more money?'.


c. What question would you ask Cheryl's boss about the ethics of asking Cheryl to create the second set of web pages? 2 marks

  • How dare you use customer information to rip them off?
  • What sort of pea-brained moronic half-wit are you?
  • Don't you see that using customer-supplied information against them is immoral?
  • Hey, I like the way you don't let morality stand in the way of profit. Can I buy shares in your company?

State average was 0.6

Responses that asked the boss a question about the fairness of ordering or bullying an employee to create a hidden link to a second set of 'rip-off' web pages were awarded full marks. For example, 'Do you think it's right to make a junior employee do something that is morally wrong when you are in the position to fire her?'.
It was of concern that many students either did not attempt to answer this question or provided an incorrect answer. This indicated that students had limited understanding about ethics and strategies for handling ethics and IT, and more focus should be placed on these areas.

d.   Recommend a strategy IT staff could follow when they are not sure if their work is ethical. 2 marks

  • Talk to their boss about their concerns.
  • Ask their mothers.
  • Set up an ethics committee.
  • Google "IT ethics".
  • Ask themselves, "What would Bill Gates do in a case like this"?
  • Refer to their preferred holy book and do whatever it says.
  • Ask a passing priest.
  • Phone a philosopher.
  • Ask themselves if they are feeling uncomfortable because of an ethical quandary, or whether it was just the curry they had for lunch.

O, I don't know or care any more. Too many marks given to damned ethical questions for one exam!

State average was 0.7

The poor performance of students in these 4 questions says more about the quality of the questions than the ability of the students, I reckon.

Suggested strategies that IT staff could follow when they are not sure if their work is ethical, included:
• ask for guidelines about customers' rights to privacy to be posted on the office noticeboard
• have regular specialist training sessions for IT staff about privacy
• post a written procedure on the company Intranet for staff to follow if they think they are being asked to invade privacy.
Responses that included an action and a means of communicating with the IT group were awarded full marks.

Question 10

SmallMart is evaluating the security of its information system.
Jack has to test the hard disk that stores backup data and the procedure to shut down hardware.

a.   Describe a procedure Jack could use to test that the hard disk effectively completes a weekly full backup. 2 marks

Restore the full backup onto a second computer and compare the accuracy of the contents of the original and the restored files.

Note the question is about effectiveness, not efficiency.
Don't suggest backing up some test data, deleting it, and trying to restore it because that would only test part of a full backup
, not the whole thing.

State average was 0.8

Responses which received full marks outlined two main steps of a procedure to test that the hard drive completed a weekly full backup effectively. For example, record data changes for one week on a second hard drive and then compare the data to see if it was the same/complete/accurate. A range of other reasonable two-step procedures were also awarded marks.

b.   Describe how Jack could test the procedure to shut down hardware without risking the transaction data. Give an example to support your answer. 2 marks

Replace the real data on the system with sample data and then try shutting the system down.

or

Mirror the real system onto a second system and try the shutdown on the mirrored system.

State average was 0.7

Responses which outlined reasonable steps to test the hardware shutdown procedure without risking the transaction data were awarded full marks. Examples included:
• Jack could plan for a time when business was slow then shut down, restart and compare the transaction files
• tell all users about a test in time for them to back up data, then shut down, start up and check all files are undamaged.

In the previous year there were 25 illegal logins to the company's information system. A new procedure, where the 300 staff have to change their passwords every three months, has been introduced.


c.    Recommend a criterion Jack could use to evaluate the effectiveness of this procedure for the security of the company's data. Justify your recommendation.2 marks

Criterion

The number of illegal logins that happened per month after the new procedure was introduced.

Justification

The whole point of the new procedure was to reduce the number of illegal logins. Logically, that is the criterion that must be used to see if the new procedure has been effective.

State average was 0.8

The most successful students responded in the form of a question; for example, 'Have there been fewer than 25 illegal logins in the 12 months since the new procedure was introduced?'. Students who clearly justified why you would compare the number of illegal logins in a particular period of time were awarded full marks. For example:
• after 12 months, staff would have changed passwords four times
• there would be time to see if the three-month period was long enough in order to reduce the number illegal logins
• there must be fewer than 25 illegal logins in three months for the new procedure to be effective.

The company owner asks Jack if regularly updating the firewall software is worth the cost.

d. Suggest an answer Jack could give to the owner. Justify your suggestion.2 marks

Suggestion

Yes. Of course it is, you moron.

Justification

All security software must be regularly updated as new system security weakness are discovered and new exploits and dangerous technologies are developed. Relying on old technology (like old antivirus definitions) leaves you vulnerable to new threats.

State average was 1.0

Another set of questions for which the state average never hit 50%. Can't blame the questions this time, however.

Full marks were awarded to responses that provided good financial reasons for regularly updating firewall software, including:
• hackers are always finding new ways to get around security
• firewalls help to protect our customer data
• saves us money from lost sales or lawsuits
• we sell online so we need to advise customers that we use an up-to-date firewall.

Question 11

Frank uses a small spreadsheet to record findings for his school science project. He is recording the heights of six different bean plants.
On school days Frank records the height of each bean plant. The project will last for eight weeks.

B11

a.   Write a formula to accurately return the Week's Growth to cell H6. 1 mark

=G6-B6

Let's hope the examiner's report gets it right too! Last year, they didn't.
This was a bit too easy for the sharp end of the examination, I thought.

State average was 0.5

=G6-B6 was the most common accepted formula. Other correct formulas were also accepted.


b.   List the cells which Frank should not protect. Justify your choices.2 marks

  • The daily heights need to be typed in to C6:G11 so they should not be locked.
  • The other cells are either formulas (which should be protected against data entry) or labels (which do not need to be changed each week).
  • Last Friday's heights can be fetched from the previous week's sheet with a formula, so that does not to be unlocked either.

State average was 1.1

Frank should not protect C6 to G11 because these are the cells where Frank needs to enter data.


c.    Identify a convention Frank has used in his spreadsheet. Explain how using this convention helps to communicate the information to other users.1 + 1=2 marks

Convention / Explanation

  • Merged and centred heading above the daily figures - makes it clear that the heading applies to all of the data below it.
  • Shaded data input cells, to make it clearer which cells a user is able to modify.
  • Bold headings, to make them stand out.
  • Putting the units (mm) in the heading rather than next to each datum.
  • Summary stats (week's growth) on the edge if the detailed data.
  • Using worksheets to encapsulate/separate related (weekly) data.

I was hoping they'd do a nice 3D spreadsheet reference question, burrowing through the 8 weeks' worksheets to get grand totals. No such luck.

State average was 1.0

Many students correctly identified a convention used in the spreadsheet and explained how it enhanced communication to other users. Examples included:
• centered headings are clearer and easier to read quickly because there is white space around the text
• right-justified numeric data, as numbers that are greatly different from the rest can be seen quickly.

d. Frank has presented his findings from the spreadsheet for the week 13Sep10 in the graph shown. Add three features to complete the graph and enhance its effectiveness. 3 marks.

graph

  • Chart title.
  • The use of colour - curse this black and white exam paper! Was the chart coloured?
  • Labels for the plant identifiers on the X axis.
  • Labels for Y axis units (mm) - does this count as a separate feature?

State average was 1.9

Three features needed to enhance the effectiveness of the graph were:
• title
• label for the x-axis
• label for the y-axis.

End of section B

 

Overall -

A couple of badly worded questions that did affect the quality of answers:

  • near/remote backups?
  • "State two types of tests for checking the online booking form". Yuk.

The database/website CMS question was a bit of a dog.

Some really dodgy ethics questions - and too many of them. One is more than enough, I reckon.

The answer to 5B was a defininite bad error.

It felt like a comfortable exam: challenging enough to pay attention to, not too easy, not too hard, a good balance of hard/soft questions.

 

Back to the IT Lecture Notes index

Back to the last page you visited

Created 10 November 2010

Last changed: November 19, 2014 1:34 PM

VCE IT Lecture notes © Mark Kelly 2001-

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