ATAR Notes: Forum

VCE Stuff => VCE Technology => VCE Mathematics/Science/Technology => VCE Subjects + Help => VCE Computing: Data Analytics => Topic started by: excal on November 11, 2008, 06:48:18 pm

Title: VCE IT:A 2008 Suggested Solutions
Post by: excal on November 11, 2008, 06:48:18 pm
Note that as I'm not actually doing the subject anymore, there may be inconsistencies between what VCAA prescribes for the study design and what is actually done out in the industry. Also, I'm rushing because I have things I need to do. But here goes...

1. B
2. A
3. C
4. B
5. D
6. A
7. B
8. B
9. D
10. D
11. C
12. B
13. D
14. B
15. This is a shit question. D would be the best answer IMHO.
16. D is the 'secure' option, C can be 'accessed anywhere' but may not be secure.
17. D
18. C
19. A
20. D


Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 07:01:43 pm
Question 1

a. Age and Gender (there are definitely more)
b. Due to the age of the audience, the content of the website will need to meet classification guidelines for children under 18 and moderated as such.

Question 2

(this is a full list, you would have picked only two)

W Subjects: Art, Biology, Chemistry, Drama, English, Mathematics.
X Parent Information: Fees, Parent Association, Weekly Calendar, Newsletter.
Y Visitor Information: Location Map, Fees (could reasonably belong here too), Newsletter (could reasonably belong here too).
Z Student Welfare: Medical Care, Pastoral Care.

Question 3
a.
Feature: Alternating background colouring
Explanation: This makes each row (item) distinguishable such that there is no confusion between rows when reading across the screen.

Feature: Colours/varieties appended to end of items
Explanation: This makes looking for an item easier when the list is both long and sorted alphabetically.

b.
Convention: Bolded table headers
Explanation: This creates a differentiation between table body and table header. In addition, this makes the header text stand out.

Convention: Right alignment of currency amounts
Explanation: This, as currency is of two decimals, keeps decimals aligned. This makes quick comparisons of cost easier.

Question 4
a. Health Records Act 2001 (Vic)
b. Assuming that mechanism to access the data is secured, the application should be closed when there is no further need to access the patient's data.
c. The hospital must ensure that the patient themselves gave permission for the data to be transmitted.

d.
i. How will our son/daughter's information be used by the Health Commission?
   Will they be personally identifiable?
ii. Do you know what your information will be used for?
   Can you refuse permission for your information to be used?
iii. How are you going to control access to my child's information?

e. Firewalls are designed to protect a network from external attack. This will prevent malicious users on the internet from breaking into the network and acquiring the information.

f. Having only one form of protection means that there is a single point of failure. Should the firewall fail to protect from another form of attack, the database could be compromised. For example, if someone inside the network had some malware installed onto their desktop - this could potentially create a backdoor into the network.

Question 5
Yes:
- Users are likely to be familiar with the function of this button.
- It is red, which makes it stand out from the other buttons.
- The cross hints towards the function of the button.

Question 6
a. AutoNumber (this exam seems to be Access-biased, otherwise it's technically just Number). This ensures uniqueness of the field by having the database management system automatically count up numbers, rather than using human input.
b. UnitPrice >= 10 AND UnitPrice <= 25
c. The error message gives the user a meaningful reasoning as to why the insert failed, a plain English version of the rule and, implicitly, an instruction on how to rectify the issue. This forms part of the validation process.
d.
i. Where one entity (in this case, a Category) may have many of another (a Product).
ii. If both of these were rolled into the one table, it would be difficult maintaining any given category as a change in one would have to be reflected in as many rows as there are Products.

Question 7
a. I'll do this later. But so you can visualise what is the correct answer:
- A runs from Monday - Tuesday. Links forward to E
- B runs from Monday - Thursday. Links forward to C
- C runs from Friday - Wednesday of the next week. Links back to B, forward to D
- D runs on the Thursday straight after C finishes. Links back to C, forward to E
- E (milestone) occurs between Thursday and Friday (they would probably prefer Friday - this Gantt chart is too simplistic to model time which is the normal way of doing things). Links back to A and D.
- F runs on Friday straight after D. Links back to E.

That being said, E does not seem to have any predecessors. The way it's written suggests that they forgot to add these in. Technically speaking, the milestone would sit at the very beginning of the project, looking very useless...I have a feeling they will award marks for this error.

b. A milestone is frequently used in projects to denote an important point of a project has been reached whether it be a rollout of a piece of functionality / deliverables, handover of the project to the client / another team or a transition to another phase in the SDLC (or problem solving methodology for you guys...stupid VCAA introducing terminology that's never used in the industry).

Question 8
This question is old. :P

The order should be:

7. Start
3. Enter Order Details
1. Calculate Cost
4. Is this an existing Customer?
(going right)
-> on arrow | 5. No
-> in box     | 2. Discount the total
(going down)
-> on arrow | 9. Yes
6. Print Receipt
8. Stop

Question 9
a.
i. Intranet
ii. This allows for controlled remote access to information related to their project work in Geography wherever there is an internet connection.

b. This data could potentially be intercepted by a third party.

c.
i. Statistically comparing mark distributions
ii. Effectiveness, the context of a classroom, often relates to the achievement of learning outcomes. Measuring this metric can help determine whether the website has improved upon this, particularly when compared to years where this system did not exist.

Question 10
This question is hard to demonstrate. If people remember their answer and want comment on it, feel free to send me a PM.

Question 11
a. Using the internet, coaches can use the internet to facilitate the use of web conferencing technologies to make group decisions. They can also use other virtual team-oriented technologies such as instant messaging, forums and wikis, among many other things.
b. With web-based software, access can be controlled using usernames and password and transmitting data using SSL (aka HTTPS). For emails, PKI encryption software such as PGP can be used to minimise the risk of data interception. Databases behind web-based virtual team software can also be encrypted, for the paranoid.
c. The new version of the software creates files that are incompatible with previous versions of the same software.
d. - An agreement/policy between the virtual team regarding software so that everyone is one the same page in regards to software used.
    - Ensuring that there is an adequate regression testing policy/plan in place, as correct and thorough testing will have found the issue (as opposed to ad hoc testing).

(for d, the first answer will have been best for an IT:A student as you probably will not have covered regression testing).

Question 12
a. E14
b. =IF($C2 > 40, "YES" , "")
c. =VLOOKUP($C2, $G$9:$H$11, 2) * $C2
  or =IF($C2>$G$11,$H$11,IF($C2>$G$10,$H$10,IF($C2>$G$9,$H$9)))*$C2
d. Set C3 = 38. C15 should then become 38.
I would have done a 2nd test with C3 = 36. C15 should then = 37.
e. This is a bloody open question:
- Add a text field next to saying 'highest selling drink' as the number is just sitting there at the moment.
- List which drinks are the highest selling, either by some extra formulas of conditional formatting.
- List more statistical information, such as averages, minimum, standard deviations etc.
f.
i. A properly written macro will reduce the amount of manual data processing, reducing the likelihood of human error particularly by those who may not be as proficient in the use of spreadsheet software.
ii. As a decision support system, being able to generate pictorial representations of sales data easily will help guide business decisions made by management.

Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 11, 2008, 07:07:25 pm
Good work Excalibur. :)

I put Age and Gender for 1.

2 i'm so mad that I changed the fourth topic from Student Welfare. Gah.
Title: Re: VCE IT:A Suggested Solutions
Post by: trinon on November 11, 2008, 07:09:08 pm
I think 16 is C because it says any location.
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 11, 2008, 07:11:13 pm
I think 16 is C because it says any location.

True... but it said secure as well, leading me to think it was D.
Title: Re: VCE IT:A Suggested Solutions
Post by: Tauk on November 11, 2008, 07:11:21 pm
Going by your MC solutions, i got 18/20

Got questions 19 and 20 wrong >.<

My answers for MC are;
1.B
2.A
3.C
4.B
5.D
6.A
7.B
8.B
9.D
10.D
11.C
12.B
13.D
14.B
15.D
16.D (answer is C, since it says ANY LOCATION on campus)
17.D (still confused whether its D or C)
18.C
19.B (answer is A since it says which values should be input)
20.A (answer is D, confused shortest with longest time taken)

Title: Re: VCE IT:A Suggested Solutions
Post by: sxcalexc on November 11, 2008, 07:13:30 pm
I think 16 is C because it says any location.

True... but it said secure as well, leading me to think it was D.
I used the same reasoning.
Title: Re: VCE IT:A Suggested Solutions
Post by: Kairubin on November 11, 2008, 07:13:53 pm
Well wireless can be secure. And any location could mean the middle of the school oval. So unless they have really long cat 5 cords or cat 5 ports in the middle of the field (would be a very very geeky school) that prompted me for wireless =|
Title: Re: VCE IT:A Suggested Solutions
Post by: trinon on November 11, 2008, 07:14:40 pm
I think 16 is C because it says any location.

True... but it said secure as well, leading me to think it was D.

Secure Secsmure. I can make any wireless connection secure, it isn't hard. So long as they don't use WEP, it's very unlikely they will encounter a hacker. IMHO it's more likely someone cuts a cable and plugs their own laptop in.
Title: Re: VCE IT:A Suggested Solutions
Post by: chubz90 on November 11, 2008, 07:17:53 pm
I dont think it was wireless as it is not that secure.

I think i f*cked up the Question on the chiledren and the website.  I said age which means like no adult material and culture as in the social culture of the teens... :-\ Oh well
Title: Re: VCE IT:A Suggested Solutions
Post by: jsimmo on November 11, 2008, 07:19:20 pm
I dont think it was wireless as it is not that secure.

I think i f*cked up the Question on the chiledren and the website.  I said age which means like no adult material and culture as in the social culture of the teens... :-\ Oh well

I said age and culture. I think they will accept any of the audience characteristics.

According to excals solutions I only got question 5 wrong - I put technical instead of procedural :(
Title: Re: VCE IT:A Suggested Solutions
Post by: chubz90 on November 11, 2008, 07:20:43 pm
Although i think the exam was way harder then the 07 one. But hey that could be a good thing?   I remember seing a couple of kids leaving the exam with partial blank paper.
Title: Re: VCE IT:A Suggested Solutions
Post by: chubz90 on November 11, 2008, 07:22:36 pm
What did everyone get for the school network thing and the kids with the camera phones? Did anyone put Client server network?
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 07:24:06 pm
<moved>
Title: Re: VCE IT:A Suggested Solutions
Post by: trinon on November 11, 2008, 07:24:25 pm
I dont think it was wireless as it is not that secure.

I think i f*cked up the Question on the chiledren and the website.  I said age which means like no adult material and culture as in the social culture of the teens... :-\ Oh well

If you think wireless isn't secure, then you don't know wireless. I could argue (for a very long time) that wireless is even more secure then cat5, which it is. As I said in an earlier post, it is far easier to cut a cable and patch in then hack a WPA/WPA2 network, and if, IF the hackers in question have rainbow tables, there are a MULTITUDE of measures they can take to make sure nothing can be done on or to the network.
Title: Re: VCE IT:A Suggested Solutions
Post by: DiMmY on November 11, 2008, 07:24:33 pm
I dont think it was wireless as it is not that secure.

I think i f*cked up the Question on the chiledren and the website.  I said age which means like no adult material and culture as in the social culture of the teens... :-\ Oh well

Well, CAT 5 can be unsecure too... you just need physical access. Wireless can be secure, and it did specifically mention ANYWHERE in the school - which leaves on wireless as the only option.
Title: Re: VCE IT:A Suggested Solutions
Post by: sxcalexc on November 11, 2008, 07:27:17 pm
I dont think it was wireless as it is not that secure.

I think i f*cked up the Question on the chiledren and the website.  I said age which means like no adult material and culture as in the social culture of the teens... :-\ Oh well

If you think wireless isn't secure, then you don't know wireless. I could argue (for a very long time) that wireless is even more secure then cat5, which it is. As I said in an earlier post, it is far easier to cut a cable and patch in then hack a WPA/WPA2 network, and if, IF the hackers in question have rainbow tables, there are a MULTITUDE of measures they can take to make sure nothing can be done on or to the network.
I agree with you completely. It just seemed that VCAA was trying to point us in the direction of CAT5... Which is why I chose CAT5, whilst I believed it was wireless.
Title: Re: VCE IT:A Suggested Solutions
Post by: micaa on November 11, 2008, 07:29:39 pm
What did everyone get for the school network thing and the kids with the camera phones? Did anyone put Client server network?

i said client server as well but im not sure if thats right
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 07:30:47 pm
I think 16 is C because it says any location.

That's a good point. On the same token, wireless can be insecure. I believe that's how it's taught in VCE IT:A.

LANs are only limited by the wiring installed by the school, as well as the wire from the wall socket to the station. So I guess it depends on that.

Of course, when configured properly, wireless can be a very tough nut to crack. Hacking into a CAT5e LAN requires physical access.
Title: Re: VCE IT:A Suggested Solutions
Post by: chubz90 on November 11, 2008, 07:31:23 pm
I dont think it was wireless as it is not that secure.

I think i f*cked up the Question on the chiledren and the website.  I said age which means like no adult material and culture as in the social culture of the teens... :-\ Oh well

Well, CAT 5 can be unsecure too... you just need physical access. Wireless can be secure, and it did specifically mention ANYWHERE in the school - which leaves on wireless as the only option.

Yeah i know what your thinking but i suppose it could be either. The thing that was on my mind is that wireless can never be considered very secure as it can be detected and after collecting enough packets hacked. Although  i hear you can tap an ethernet (cat5 or whatever). Mehh... probably the examiners will give both as right :)  
Title: Re: VCE IT:A Suggested Solutions
Post by: sxcalexc on November 11, 2008, 07:31:28 pm
What did everyone get for the school network thing and the kids with the camera phones? Did anyone put Client server network?

i said client server as well but im not sure if thats right
I said WAN because they were Internet-enabled; that's how they uploaded to the site, and the Internet is a WAN.
Title: Re: VCE IT:A Suggested Solutions
Post by: chubz90 on November 11, 2008, 07:33:10 pm
What did everyone get for the school network thing and the kids with the camera phones? Did anyone put Client server network?

i said client server as well but im not sure if thats right

I thought that becasue its controlled by the school.
Title: Re: VCE IT:A Suggested Solutions
Post by: trinon on November 11, 2008, 07:34:07 pm
What did everyone get for the school network thing and the kids with the camera phones? Did anyone put Client server network?

i said client server as well but im not sure if thats right
I said WAN because they were Internet-enabled; that's how they uploaded to the site, and the Internet is a WAN.

I also said a WAN, but to be fair, it was a guess.
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 11, 2008, 07:36:27 pm
Question 3
a.
Feature: Alternating background colouring
Explanation: This makes each row (item) distinguishable such that there is no confusion between rows when reading across the screen.

YAY I PUT THAT lol.

For 3b)
I put Checkboxes for one of em..... is that a format :(
Title: Re: VCE IT:A Suggested Solutions
Post by: Tauk on November 11, 2008, 07:36:56 pm
I still think that question 4 A is Privacy Act 1988...since its asking the "responsibilities for patients data"
Title: Re: VCE IT:A Suggested Solutions
Post by: jsimmo on November 11, 2008, 07:39:40 pm
I still think that question 4 A is Privacy Act 1988...since its asking the "responsibilities for patients data"

The question said 'Melbourne' (which comes under the state Victorian sector and not the commonwealth sector). The Victorian health industry is covered by the Health Records Act 2001.

Question 3
a.
Feature: Alternating background colouring
Explanation: This makes each row (item) distinguishable such that there is no confusion between rows when reading across the screen.

YAY I PUT THAT lol.

For 3b)
I put Checkboxes for one of em..... is that a format :(

I said that the checkboxes were on the left hand side of the form and the price was on the right hand side of the form - which is usually the preferred convention for setting out a customer order form. I also said that the dollar values are seperated by decimal points - ensures that the user is able to easily recognise the correct dollar values. Would this be another convention? Hopefully they accept that.
Title: Re: VCE IT:A Suggested Solutions
Post by: DiMmY on November 11, 2008, 07:42:26 pm
I still think that question 4 A is Privacy Act 1988...since its asking the "responsibilities for patients data"

The question said 'Melbourne' (which comes under the state Victorian sector and not the commonwealth sector). The Victorian health industry is covered by the Health Records Act 2001.

*shrug* Our teacher always mentioned to put Privacy Act anyway since it's the main one, and the Health Records Act is nearly a copy of it anyway.
Title: Re: VCE IT:A Suggested Solutions
Post by: trinon on November 11, 2008, 07:44:28 pm
What did people put for 6b? I immediately dismissed a formula from my mind because it's not on the course, and it said rule. I put:

10.00 <= Unit Price <= 25.00
Title: Re: VCE IT:A Suggested Solutions
Post by: jsimmo on November 11, 2008, 07:45:27 pm
What did people put for 6b? I immediately dismissed a formula from my mind because it's not on the course, and it said rule. I put:

10.00 <= Unit Price <= 25.00

That's exactly what I put.   ???
Title: Re: VCE IT:A Suggested Solutions
Post by: DiMmY on November 11, 2008, 07:46:16 pm
What did people put for 6b? I immediately dismissed a formula from my mind because it's not on the course, and it said rule. I put:

10.00 <= Unit Price <= 25.00

Ditto.

That's exactly what I put.   ???
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 08:08:21 pm
What did people put for 6b? I immediately dismissed a formula from my mind because it's not on the course, and it said rule. I put:

10.00 <= Unit Price <= 25.00

Try typing that into a database :P

I'm sure they will accept it though.
Title: Re: VCE IT:A Suggested Solutions
Post by: sxcalexc on November 11, 2008, 08:19:33 pm
I put "Between 10 and 25" which is acceptable in a database. However, that doesn't have any symbols, and in brackets the question said to include the symbols. Do you think I'll get the mark?
Title: Re: VCE IT:A Suggested Solutions
Post by: Tauk on November 11, 2008, 08:20:40 pm
reckon youll get marked down for Question 8 if you wrote the words instead of numbers?
Title: Re: VCE IT:A Suggested Solutions
Post by: ell on November 11, 2008, 08:22:29 pm
reckon youll get marked down for Question 8 if you wrote the words instead of numbers?

hmm.. probably not. How did you fit "Is this an existing customer?" into the tiny diamond? :P
Title: Re: VCE IT:A Suggested Solutions
Post by: Noblesse on November 11, 2008, 08:25:13 pm
I started writing them in, until I read we needed to use numbers. waste of time :P
Title: Re: VCE IT:A Suggested Solutions
Post by: Tauk on November 11, 2008, 08:30:36 pm
reckon youll get marked down for Question 8 if you wrote the words instead of numbers?

hmm.. probably not. How did you fit "Is this an existing customer?" into the tiny diamond? :P

All i could think off was how i was going to go home and bitch about how they didnt give enough space.
Also, was to preoccupied thinking about Mr. Kelly telling me the day before that "Chances are you will not be given an entire table to fill out" and lol'ing.

I wrote "Existing customer?" btw.
Title: Re: VCE IT:A Suggested Solutions
Post by: micaa on November 11, 2008, 08:31:56 pm
i did the exact same thing, i started writing them in the shapes and was like what the hell as if i can fit that in here!
and then read the question properly
Title: Re: VCE IT:A Suggested Solutions
Post by: micaa on November 11, 2008, 08:33:20 pm
for question three i said the exact same thing but said the feature was highlighting every second row? will that still be correct?
Title: Re: VCE IT:A Suggested Solutions
Post by: trinon on November 11, 2008, 08:33:54 pm
I didn't even read the question. I was like, fuck this is simple. If they want it in words, well TOO BAD!
Title: Re: VCE IT:A Suggested Solutions
Post by: jsimmo on November 11, 2008, 08:34:05 pm
for question three i said the exact same thing but said the feature was highlighting every second row? will that still be correct?

Yes.
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 11, 2008, 08:42:22 pm
LOL for the flowchart, I wrote START and STOP in straight away.

Then read the question.. LMAO had to change to numbers.
Title: Re: VCE IT:A Suggested Solutions
Post by: plbuck on November 11, 2008, 08:49:35 pm
Opps, Stuffed that one up.

Didn't realise you needed to put the numbers
Title: Re: VCE IT:A Suggested Solutions
Post by: Noblesse on November 11, 2008, 08:51:12 pm
Opps, Stuffed that one up.

Didn't realise you needed to put the numbers

IMO you may lose a mark just as a penalty, but most likely they will give it to you.
Title: Re: VCE IT:A Suggested Solutions
Post by: droodles on November 11, 2008, 09:09:15 pm
i got bored so i ended up drawing a picture of myself doing a rap dance

EXCALIBUR INTRANET YESSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS

DOG

according to excalibur i got 20/20 for MQ

DAWG
Title: Re: VCE IT:A Suggested Solutions
Post by: Noblesse on November 11, 2008, 09:12:54 pm
I wrote client/server for the network type.
(http://img231.imageshack.us/img231/5702/onozomg2so5.gif)
Title: Re: VCE IT:A Suggested Solutions
Post by: micaa on November 11, 2008, 09:23:03 pm
i put client/server as well,
if we backed up our reasoning to why we chose that network would we still scrap some sort of a mark?
Title: Re: VCE IT:A Suggested Solutions
Post by: TonyHem on November 11, 2008, 09:23:32 pm
I didnt see question 12... it looked like question eleven was the last question because there was a blank page.


FFS: 1 wrong multiple choice, lost 7-8 marks normally probably and now AN EXTRA 7 coz I didnt see the question.
Title: Re: VCE IT:A Suggested Solutions
Post by: Noblesse on November 11, 2008, 09:29:55 pm
I didnt see question 12... it looked like question eleven was the last question because there was a blank page.


FFS: 1 wrong multiple choice, lost 7-8 marks normally probably and now AN EXTRA 7 coz I didnt see the question.

That really sucks, I thought the blank page was rather unorthodox.

i got bored so i ended up drawing a picture of myself doing a rap dance

I wish I could dance as cool as these guys.
(http://img442.imageshack.us/img442/3193/rapdancingfh5.png)
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 09:46:51 pm
I think 16 is C because it says any location.

True... but it said secure as well, leading me to think it was D.

Secure Secsmure. I can make any wireless connection secure, it isn't hard. So long as they don't use WEP, it's very unlikely they will encounter a hacker. IMHO it's more likely someone cuts a cable and plugs their own laptop in.

WEP or WPA or WPA2, you're sharing the key with a lot of people.

I'd be using RADIUS with AES. I'm sure you didn't cover that.
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 11, 2008, 09:55:22 pm
Loving question 11. Especially d). Majority of my friends didn't mention how to prevent this in the future, but rather how to solve the current problem :D
Title: Re: VCE IT:A Suggested Solutions
Post by: fibrefood on November 11, 2008, 09:56:13 pm
For the question about the "network type" was it talking about like.. peer to peer, client server etc or was it talking about LAN and WLANs?
Title: Re: VCE IT:A Suggested Solutions
Post by: ell on November 11, 2008, 10:00:17 pm
For the question about the "network type" was it talking about like.. peer to peer, client server etc or was it talking about LAN and WLANs?

Who knows, VCAA IT exam writers are the kings of ambiguity. :P  In the past they've referred to network 'type' as LAN/WAN so I put down WAN.
Title: Re: VCE IT:A Suggested Solutions
Post by: jsimmo on November 11, 2008, 10:02:11 pm
Loving question 11. Especially d). Majority of my friends didn't mention how to prevent this in the future, but rather how to solve the current problem :D

For 11D I wrote: The two users who have the new version should convert back to the older version for the convenience of the other members. Updating everyones software will be too expensive and hence, the easiest option is just to convert back to the standard software version that everyone has.

Enough for the full marks?
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 11, 2008, 10:04:28 pm
Loving question 11. Especially d). Majority of my friends didn't mention how to prevent this in the future, but rather how to solve the current problem :D

For 11D I wrote: The two users who have the new version should convert back to the older version for the convenience of the other members. Updating everyones software will be too expensive and hence, the easiest option is just to convert back to the standard software version that everyone has.

Enough for the full marks?

I'm not sure, as I said, I think the q was about stopping from recurring in the future. That's what my (smart) friend put though.
Title: Re: VCE IT:A Suggested Solutions
Post by: RD on November 11, 2008, 10:04:36 pm
I put Age and Education for 1.

Fuck I got a few more wrong than I had hoped. Ughh.
I fucked Q4, I didn't read the question and didn't put proper answer ..GRRR!!!
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 10:07:23 pm
Done. I'll be revising the answers now.
Title: Re: VCE IT:A Suggested Solutions
Post by: Tauk on November 11, 2008, 10:08:04 pm
Quote
Question 9
a.
i. Intranet
[\quote]
I would actually say this is a Wide Area Network, seeing that the internet is fundamentally a Wide Area Network, and that they clearly ask what TYPE of network.
Dont know if VCAA will swing to WAN, VPN or Intranet though.
Quote
b. This data could potentially be intercepted by a third party.
[\quote]
Yes, because everyone wants to intercept year 10's Geography projects.
I would rather say that it would probably be the slow upload times to upload high res bulky images.
Otherwise all good.
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 10:09:23 pm
- WAN would imply a physical always on connection (like a LAN) but over a great physical distance.
- Intranet implies an internal network that is accessible from the outside.
- VPN is a technology used to secure intranet connections, inter alia.
Title: Re: VCE IT:A Suggested Solutions
Post by: ell on November 11, 2008, 10:10:17 pm
Done. I'll be revising the answers now.

yay, got exactly the same as you in Q12.

edit: hm, doesn't the VLOOKUP go to H11, not H10?
Title: Re: VCE IT:A Suggested Solutions
Post by: jsimmo on November 11, 2008, 10:13:47 pm
Done. I'll be revising the answers now.

Did you forget 12f, or are you doing it now? (sorry if you are)
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 10:15:55 pm
Done. I'll be revising the answers now.

yay, got exactly the same as you in Q12.

edit: hm, doesn't the VLOOKUP go to H11, not H10?

My bad. Bad copy+paste job into Excel.
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 11, 2008, 10:17:17 pm
Oh and for 9b), I mentioned that it may not be able to handle large amounts of incoming data from the students at the one time?

Good enough?
Title: Re: VCE IT:A Suggested Solutions
Post by: jsimmo on November 11, 2008, 10:18:13 pm
Oh and for 9b), I mentioned that it may not be able to handle large amounts of incoming data from the students at the one time?

Good enough?

That's what I said - but I also extended it and said that the uploading of files would slow the network for other users, decreasing download speed/times.
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 10:20:39 pm
Oh and for 9b), I mentioned that it may not be able to handle large amounts of incoming data from the students at the one time?

Good enough?

That's what I said - but I also extended it and said that the uploading of files would slow the network for other users, decreasing download speed/times.

Yep, that would be acceptable if you highlighted the fact that high resolution cameras are in use.
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 11, 2008, 10:21:29 pm
Oh and for 9b), I mentioned that it may not be able to handle large amounts of incoming data from the students at the one time?

Good enough?



That's what I said - but I also extended it and said that the uploading of files would slow the network for other users, decreasing download speed/times.

Cool, yeh I added extra stuff too, was just checking if that was a reasonable thing to say.

Glad it's over.... but i'm spending way too much time discussing it then studying for Legal Exam tomorrow! haha.
Title: Re: VCE IT:A Suggested Solutions
Post by: jsimmo on November 11, 2008, 10:25:24 pm
Oh and for 9b), I mentioned that it may not be able to handle large amounts of incoming data from the students at the one time?

Good enough?



That's what I said - but I also extended it and said that the uploading of files would slow the network for other users, decreasing download speed/times.

Cool, yeh I added extra stuff too, was just checking if that was a reasonable thing to say.

Glad it's over.... but i'm spending way too much time discussing it then studying for Legal Exam tomorrow! haha.

lol that's like me... (studio arts tomorrow at 9am).. it's in my bottom 2, so it doesnt matter if I get 30 or 37, it's a 0.30 difference to my enter. :P Stupid subject anyway.

thanks for the answers excal! helped me clarify quite a few things!
Title: Re: VCE IT:A Suggested Solutions
Post by: monty711 on November 11, 2008, 10:48:42 pm
On the multi-choice Q15, the wording isn't exact enough to imply exactly what they wanted. Did they want to center the data in every single cell, or put it in the center of ALL of the cells. The thing that made me think it was C was the fact that it said whenever the assigned keys are pressed, ie. it will happen more than once. Also, check excel, if you select columns and press merge and center, it will put the data at the bottom, you need to change the actual formatting before it centers the text.

Lastly, it should be CENTER not CENTRE.

Anyway I got 18 or 19/20 on the multi choice. Said accidental for the flash drive question, it sounded right and I didn't read option D :(
Title: Re: VCE IT:A Suggested Solutions
Post by: Randomperson on November 11, 2008, 10:54:54 pm
Change Q16 in MC to C. Most people would say it's C, heck even my teacher said it was C.
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 10:57:31 pm
Change Q16 in MC to C. Most people would say it's C, heck even my teacher said it was C.

It's a bit of a tricky one because no technology fits the bill perfectly. I'll add it in, however.
Title: Re: VCE IT:A Suggested Solutions
Post by: TonyHem on November 11, 2008, 10:59:04 pm
I wasnt sure how the milestone was meant to look.

I drew a star instead of a diamond... how picky do you think they'll be?
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 11, 2008, 11:00:15 pm
Change Q16 in MC to C. Most people would say it's C, heck even my teacher said it was C.

It's of his opinion that it's not.

But I think it may be C in the end :( I put D.
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 11:00:18 pm
I wasnt sure how the milestone was meant to look.

I drew a star instead of a diamond... how picky do you think they'll be?

As long as it's clear that it's a zero-length activity, you should be fine.

There are a lot of questions that are very ambiguous in this paper, I might add. It's a shame that nothing really changes.
Title: Re: VCE IT:A Suggested Solutions
Post by: ell on November 11, 2008, 11:03:46 pm
I wasnt sure how the milestone was meant to look.

I drew a star instead of a diamond... how picky do you think they'll be?

I did the standard arrows + diamond for dependencies and milestones, but I put a little legend at the bottom just in case.
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 11, 2008, 11:07:07 pm
Change Q16 in MC to C. Most people would say it's C, heck even my teacher said it was C.

It's of his opinion that it's not.

But I think it may be C in the end :( I put D.

The other problem is that what is taught in an IT class is sometimes not the case in the real world. Sometimes the difference can be hard to reconcile.

This is not limited to VCE, either.

Wireless, due to its very nature, is very difficult to be completely secure - particularly using pre-shared keys. All it takes is for someone to retrieve the key (either by social engineering, brute forcing or otherwise).

Wired networks need to be tapped. This requires physical access to a network port (degree of difficult may vary). That being said, if you're letting someone walk in and plug in anything into a network socket with full exposure to the LAN without controls/audit, you deserve anything that comes to you.
Title: Re: VCE IT:A Suggested Solutions
Post by: TonyHem on November 12, 2008, 12:15:58 am
Just to confirm something: ($) sign is a convention right? not a format?
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 12, 2008, 12:18:00 am
Depending on how it is used, it can be both.
Title: Re: VCE IT:A Suggested Solutions
Post by: TonyHem on November 12, 2008, 12:19:43 am
The fruit question in the exam?
Title: Re: VCE IT:A Suggested Solutions
Post by: Noblesse on November 12, 2008, 09:48:45 am
http://www.mckinnonsc.vic.edu.au/vceit/
Mark Kelly's Section A answers are up, he has a couple different answers to Excal, IMO I think Excal is correct.
Title: Re: VCE IT:A Suggested Solutions
Post by: RD on November 12, 2008, 09:52:03 am
The fruit question in the exam?
for format in that question I wrote that the different shades of colours would allow for easier identification of the products and I think I put the fact that they went to two decimal places as the convention..
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 12, 2008, 09:54:04 am
http://www.mckinnonsc.vic.edu.au/vceit/
Mark Kelly's Section A answers are up, he has a couple different answers to Excal, IMO I think Excal is correct.

The only difference is in question 12. I disagree with his answer because a drop down (a list of values would be a better term...) on IDs is not particularly meaningful to the user while a LOV of titles actually *can* be exhaustive and has some value.

The system that quite a few Universities use to manage their students (Callista) certainly uses a LOV/drop down list for titles.
Title: Re: VCE IT:A Suggested Solutions
Post by: Noblesse on November 12, 2008, 10:07:16 am
Bah 18/20 for MC, unless Wireless is correct than it's 19. Fairly happy.
Title: Re: VCE IT:A Suggested Solutions
Post by: bbmmzz on November 12, 2008, 10:22:02 am
Can someone tell me where I can get the questions for the exam?

Cheers  ;D
Title: Re: VCE IT:A Suggested Solutions
Post by: RD on November 12, 2008, 10:24:52 am
Can someone tell me where I can get the questions for the exam?

Cheers  ;D
http://vcenotes.com/forum/index.php/topic,7513.0.html
Title: Re: VCE IT:A Suggested Solutions
Post by: bbmmzz on November 12, 2008, 10:26:18 am
  :D Fantastic

Thanks
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 12, 2008, 10:42:36 am
http://www.mckinnonsc.vic.edu.au/vceit/
Mark Kelly's Section A answers are up, he has a couple different answers to Excal, IMO I think Excal is correct.

WHERE! lol.
Title: Re: VCE IT:A Suggested Solutions
Post by: fibrefood on November 12, 2008, 10:44:40 am
Hurah I think I got 20 for the MC and now watch me fail section b
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 12, 2008, 10:47:15 am
Hurah I think I got 20 for the MC and now watch me fail section b

:) I think I got 20 too (If it's UTP instead of Wireless).
Title: Re: VCE IT:A Suggested Solutions
Post by: Noblesse on November 12, 2008, 10:47:59 am
http://www.mckinnonsc.vic.edu.au/vceit/
Mark Kelly's Section A answers are up, he has a couple different answers to Excal, IMO I think Excal is correct.
WHERE! lol.
Under the dead feet with the ITA and SD tags on them. And across from the My IPM/ITA post mortems, under 2008 (In Progess)


Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 12, 2008, 11:04:36 am
http://www.mckinnonsc.vic.edu.au/vceit/
Mark Kelly's Section A answers are up, he has a couple different answers to Excal, IMO I think Excal is correct.
WHERE! lol.
Under the dead feet with the ITA and SD tags on them. And across from the My IPM/ITA post mortems, under 2008 (In Progess)




Yeah, I think he should be shot for using frames...but that's a personal issue I have with them :P

http://www.mckinnonsc.vic.edu.au/vceit/postmortems/2008ita/index.htm is the direct link.
Title: Re: VCE IT:A Suggested Solutions
Post by: Athomas on November 12, 2008, 11:05:24 am
http://www.mckinnonsc.vic.edu.au/vceit/
Mark Kelly's Section A answers are up, he has a couple different answers to Excal, IMO I think Excal is correct.
WHERE! lol.
Under the dead feet with the ITA and SD tags on them. And across from the My IPM/ITA post mortems, under 2008 (In Progess)


LOL yeh I saw that yesterday, but there's no real answers yeh? You were just joking haha?

EDIT: OMG FIREFOX HAS BEEN SHOWING THE OLD VERSION OF THAT LINK! WHY :S
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 12, 2008, 11:26:58 am
http://www.mckinnonsc.vic.edu.au/vceit/
Mark Kelly's Section A answers are up, he has a couple different answers to Excal, IMO I think Excal is correct.
WHERE! lol.
Under the dead feet with the ITA and SD tags on them. And across from the My IPM/ITA post mortems, under 2008 (In Progess)


LOL yeh I saw that yesterday, but there's no real answers yeh? You were just joking haha?

EDIT: OMG FIREFOX HAS BEEN SHOWING THE OLD VERSION OF THAT LINK! WHY :S

Caches.
Title: Re: VCE IT:A Suggested Solutions
Post by: jsimmo on November 12, 2008, 12:57:50 pm
http://www.mckinnonsc.vic.edu.au/vceit/
Mark Kelly's Section A answers are up, he has a couple different answers to Excal, IMO I think Excal is correct.

The only difference is in question 12. I disagree with his answer because a drop down (a list of values would be a better term...) on IDs is not particularly meaningful to the user while a LOV of titles actually *can* be exhaustive and has some value.

The system that quite a few Universities use to manage their students (Callista) certainly uses a LOV/drop down list for titles.

haha I agree.. can't believe he chose D :S:S... HEAPS of forms have drop down lists for the title field.. I got 18/20 (maybe 19 if its UTP and not wireless).
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 12, 2008, 01:36:59 pm
Yeah, I sent him an email about it.
Title: Re: VCE IT:A Suggested Solutions
Post by: Noblesse on November 12, 2008, 02:46:51 pm
Seems Kelly has changed his mind about question 16:
Quote
Answer is: C.

CAT5? That's as outdated as Britney Spears' reputation. While one would normally automatically go for CAT cable, the key words (I discovered after some rethinking) were "from any location". This implies wireless rather than cabled.

And first 4 short answer questions are up.
Gosh if we were as slow as him, we wouldn't be able to finish the paper in time :P j/k

EDIT: up to 7 are done.
Title: Re: VCE IT:A Suggested Solutions
Post by: jsimmo on November 14, 2008, 07:42:54 pm
Mark Kellys: 2008 VCAA Exam Post Mortem (http://www.mckinnonsc.vic.edu.au/vceit/postmortems/2008ita/index.htm)

All in all, a better exam than some in the past, but a bit too easy in section A.
On the other hand the dog got a few unnecessary treats this year with the ambiguous expression we've come to expect in ITA exams.
Thank you linesmen. Thank you ballboys. And thanks to everyone who provided valuable and thoughtful feedback.
You are as clever as a crate of cognoscenti,

And a shout to all at vcenotes.com. Keep up the clever chatter, guys.
I admire the mature level of discussion I have seen so far.
I lurk, from time to time, in my cloak of invisibility.



;D ;D ;D
Title: Re: VCE IT:A Suggested Solutions
Post by: Glockmeister on November 15, 2008, 12:43:51 am
Enwiabe is going to fap at this :P
Title: Re: VCE IT:A Suggested Solutions
Post by: excal on November 15, 2008, 12:07:33 pm
Oooo...shiny!

He must have a few levels in the 'Lurk' ability.
Title: Re: VCE IT:A 2008 Suggested Solutions
Post by: baha123 on November 05, 2009, 11:16:41 pm
im having trouble studying for my upcoming end of year it applications exam. im not sure which area's to focus more on???

unit 3
chapter 1 - problem solving
chapter 2 - developing a solution using database software
chapter 3 - network information systems
chapter 4 - using networks
unit 4
chapter 5 - organisation and information needs
chapter 6 - supporting information products and reviewing decisions
chapter 7 - storage, communication and disposal of data and information
chapter 8 - security measures

can someone please help?
Title: Re: VCE IT:A 2008 Suggested Solutions
Post by: ell on November 05, 2009, 11:41:58 pm
@baha123: I've answered your question here: http://vcenotes.com/forum/index.php/topic,6654.msg194748.html#msg194748

edit: should probably unsticky this seeing as it's 2009