ATAR Notes: Forum

VCE Stuff => VCE Technology => VCE Mathematics/Science/Technology => VCE Subjects + Help => VCE Computing: Data Analytics => Topic started by: ell on December 18, 2008, 09:17:45 pm

Title: General Advice for IT Applications
Post by: ell on December 18, 2008, 09:17:45 pm
General Advice for IT Applications

Before the year starts...

During the year...

Mnemonics
Use mnemonics - recalling key information in an exam/SAC is easy when you do.

Exam Advice...

Useful links

Feel free to add any other points, websites, resources etc. ITA is an easy subject in terms of content, which is why it is easy to neglect it in favour of other subjects. Don't neglect it - it'll pay off in the end (it did for me).
Title: Re: Tips & Advice for IT Applications
Post by: Flaming_Arrow on December 18, 2008, 09:21:26 pm
great work ell!
Title: Re: Tips & Advice for IT Applications
Post by: kurrymuncher on December 18, 2008, 09:22:01 pm
Thanks ell, your a legend :) :)
Title: Re: Tips & Advice for IT Applications
Post by: danieltennis on December 18, 2008, 09:22:26 pm
GODSPEED ELL
Title: Re: Tips & Advice for IT Applications
Post by: xox.happy1.xox on December 18, 2008, 09:24:10 pm
Wow... I've never done IT: Applications, but still wow. You've put lots of effort into it! Well done, ell. :)
Title: Re: Tips & Advice for IT Applications
Post by: danieltennis on December 18, 2008, 09:42:04 pm
Hey Ell,
do you have the link to the study design?
Thanks
Title: Re: Tips & Advice for IT Applications
Post by: ell on December 18, 2008, 09:59:53 pm
Hey Ell,
do you have the link to the study design?
Thanks

I added a link to it on the original post.
Title: Re: Tips & Advice for IT Applications
Post by: danieltennis on December 18, 2008, 10:00:38 pm
Hey Ell,
do you have the link to the study design?
Thanks
Thanks

I added link to it on the original post.

Thanks
Title: Re: Tips & Advice for IT Applications
Post by: Athomas on December 20, 2008, 07:05:56 pm
Great advice.
I would like to add: Sacs are important. Don't disregard them like I did! ;) haha.
Title: Re: Tips & Advice for IT Applications
Post by: cobby on December 20, 2008, 07:17:59 pm
Thanks a lot ell, really didnt know how to tackle i.t apps, your a legend!!
Title: Re: Tips & Advice for IT Applications
Post by: methodsboy on December 21, 2008, 12:23:47 pm
Thanks. This should get me 45+
Title: Re: Tips & Advice for IT Applications
Post by: jsimmo on December 21, 2008, 11:13:09 pm
Here are my notes that I uploaded to the site: http://notes.vcenotes.com/?step=downloader&download=190

The only advice I can give is;


Great thread ELL!  ;)
Title: Re: Tips & Advice for IT Applications
Post by: ell on December 21, 2008, 11:27:15 pm
Here are my notes that I uploaded to the site: Unit 3/4 IT:A Notes

The only advice I can give is;

  • Keep on top of your SACs! Do a lot of documentation and don't spend so much time on the actual information product (it's only worth a small proportion)!!
  • You need to try and be 'pumped' up about the course - you can get pretty bored in an IT:A class - try to be energized and full of enthusiasm - otherwise, you will just get too lazy and use the computers to do unproductive stuff!
  • Make mind maps - just familiarise yourself with all the concepts and ideas - learn acronyms (they help a lot).

Great thread ELL!  ;)

Good points! I especially agree with the first - it's very easy to get distracted with developing the solution and forget about the documentation which is where it really counts.

I'd also like to add that Mark Kelly has added state averages to his post-mortem. A particularly interesting statistic is that the state average for a simple spreadsheet formula question was 0.15 / 1 (15%), while the average for another formula question (the VLOOKUP one) was 0.05 / 1 (5%) - make sure you're in that minority (i.e learn your formulas)!
Title: Re: Tips & Advice for IT Applications
Post by: danieltennis on December 21, 2008, 11:30:04 pm
Thanks ELL and Jsimmo

Jsimmo: can you check that link again? It's not working for me. Thank you
Title: Re: Tips & Advice for IT Applications
Post by: excal on December 22, 2008, 02:26:31 am
I might add that you are expected to be able to use Excel - the exam is not technology neutral on this count (you are expected to know and apply Excel formulas as candidates did this year).

Regarding databases, the exam is supposedly technology-neutral (but not your SACs), but you'll find that there tends to be an Access-bias in the wording of the questions. In any case, you will be expected to know the theories behind database design and apply them.

For those who are keen on getting started during the summer holidays on the more technical areas of IT:A, here are some texts I would suggest hunting down:

- Parsons, Oja, Ageloff & Carey, New Perspectives on Microsoft Office Excel 2003, Comprehensive (New Perspectives (Paperback Course Technology)) 2nd Edition (Paperback)
- Adamski and Finnegan, New Perspectives on Microsoft Office Access 2003, Comprehensive (New Perspectives (Paperback Course Technology)) 2nd Edition (Paperback)

These are university-level texts, but I found them to be very easy to read (even though I never personally used them, Glockmeister derived plenty of use from them), probably because they were designed to prepare candidates for the Microsoft Office Specialist certification and thus needed to be somewhat accessible. You obviously won't need all the content, so it would be prudent if you asked your teacher what areas of both technologies you will cover (or do the lot for enrichment).
Title: Re: Tips & Advice for IT Applications
Post by: jsimmo on December 22, 2008, 11:34:36 am
Thanks ELL and Jsimmo

Jsimmo: can you check that link again? It's not working for me. Thank you

AHH sorry!

Try this: http://notes.vcenotes.com/?step=downloader&download=190
Title: Re: Tips & Advice for IT Applications
Post by: transgression on December 25, 2008, 06:09:24 pm
Great tips! Very useful advice; and well done ell for being the new moderator.
Title: Re: Tips & Advice for IT Applications
Post by: IntoTheNewWorld on January 01, 2009, 08:00:46 pm
I would say don't rely on those IPM sample exams, those things are way easier than IT Apps. Learn how to write perfect Excel formulas (not in IPM), and learn how to answer those damn ethics questions
Title: Re: Tips & Advice for IT Applications
Post by: xvce2009 on January 03, 2009, 01:39:54 pm
I would say don't rely on those IPM sample exams, those things are way easier than IT Apps. Learn how to write perfect Excel formulas (not in IPM), and learn how to answer those damn ethics questions

Agreed, don't waste your time on IPM exams when exam period is coming up. Only go through them if you have finished every other revision material you already have in your huge pile of practice exams and booklets.

Formulas, definitely. That includes: SUM, COUNT, COUNTIF, MAX, MIN, and importantly the VLOOKUP and IF formulas. It is highly unlikely that all of these will come up in the end of year exam, but there is bound to be one placed in there, as did the VLOOKUP and IF did for this year.

However, what I reckon is the most important thing for the final exams is to answer the question as required by the information problem. I cannot stress that enough. If the information problem is about a Primary School you produce an answer which will relate to a primary school. This maybe common sense, but you would be surprised how many people just write an answer which doesn't relate back to the information problem.

Finally, use common sense and sometimes don't think too much about the question. In this year's exams there were a couple dodgy questions (as with nearly ALL IT Applications exams and practice exams). There is likely to be a couple of questions where course knowledge cannot be applied, hence you must think on your feet and answer the question as appropriately as possible. For example, there was a question in this years final exam which asked you to organize web-pages into the correct categories for a school website. This is something examiners expect you to know through common sense. Personally I believe there are many ways to answer such an ambiguous question similar to this, and such questions shouldn't be included in the final exam. Nevertheless, in the end it is down to how you determine the question yourself, and of course answering it in a logical sense for examiners to credit you for the mark.

Well that's all I can think of now, I may post some more advice later. And if there's any other questions I'll be happy to help.
Title: Re: Tips & Advice for IT Applications
Post by: IntoTheNewWorld on January 03, 2009, 02:07:49 pm
I would also say IT Applications is not about who can remember the most information, because really, there isn't that much to remember. Anyone can remember all the information required, the (lack of) thickness of the textbooks shows this. What it's all about is how well you can interpret questions, and as the above post says, common sense and relating back to the case studies presented.

I remember there was a multi choice question about a school chess club, and they wanted to know what type of network they needed. They required a secure network that enabled them to put in results anywhere. Some people in my class jumped at the word secure, and instantly put down Ethernet, ignoring the fact that they wanted access anywhere, which pretty much guaranteed wireless. If you get things like this wrong you'll be so pissed afterwards.

Ethics questions are not cool. From what I see, they seem to always be weighing up the benefits to society to individual benefits.

Check out examiner reports/Mark Kelly's post mortems and learn why the state did so badly on particular questions. Don't look at your exam post mortems after you finish exams, it's seriously depressing. It's still depressing.

Title: Re: Tips & Advice for IT Applications
Post by: xvce2009 on January 03, 2009, 02:52:35 pm
100% agree with above post. How much knowledge you have is nearly irrelevant. I made the mistake of trying to learn everything possible, including all the fine details. In the end, I probably only used 30% of that knowledge. This is why I sometimes find subjects such as IT Applications a bit stressing. It's unlike maths where the more you study and practice, the more you will benefit greatly and acquire faster solving speeds and methods. And the fact in maths the answer is either wrong or right, nothing else. In IT Applications, I feel there is almost a bottleneck where learning more facts isn't going to dramatically increase your chances of a high study score. It's more a common sense based subject, and applying that knowledge to the best of your abilities. After coming out of the end of year exam, I was quite surprised of how many ambiguous and slightly irrelevant questions were included, as you will find with many of the practice exams when you come to them at the end of the year.

But of course, this is not to say that you should stop studying and not try at all. It is still important to acquire ample knowledge of the course and the study design, especially the fact that they are likely to throw in some things you may have never learned in class before. Haha yes the ethics questions in the 2008 exam were pretty random. That's the kind of concept I'm talking about.
Title: Re: Tips & Advice for IT Applications
Post by: ell on January 03, 2009, 03:42:54 pm
Great points guys - I'm a big advocate of using your common sense which, amongst all this advice, is the key to doing well ITA.

I might add those points to the original post (somewhat paraphrased) since I think they're quite important and something I overlooked while writing it.
Title: Re: Tips & Advice for IT Applications
Post by: xvce2009 on January 04, 2009, 05:31:37 pm
Thanks ell. Adding to what already is a great guide.
Title: Re: Tips & Advice for IT Applications
Post by: kurrymuncher on January 04, 2009, 05:45:35 pm
Is microsoft access a very important part of the exam. I havent done year 11 IT, so I have no idea how to use Access. Does anyone have any tutorial websites or notes.
Title: Re: Tips & Advice for IT Applications
Post by: Flaming_Arrow on January 04, 2009, 06:46:59 pm
Is microsoft access a very important part of the exam. I havent done year 11 IT, so I have no idea how to use Access. Does anyone have any tutorial websites or notes.

its self explanatory
Title: Re: Tips & Advice for IT Applications
Post by: ell on January 04, 2009, 07:02:16 pm
Is microsoft access a very important part of the exam. I havent done year 11 IT, so I have no idea how to use Access. Does anyone have any tutorial websites or notes.

Not for the exam, but for your SACs (if your school is using Access). For the exam you need to know basic database concepts common to all database software like setting up queries/rules, relationships (one to one, one to many etc), that sort of thing.

As for Microsoft Access tutorials - a Google search will give you heaps, but Access is fairly easy to use. Just use the wizard if it's the first time you're using it.
Title: Re: Tips & Advice for IT Applications
Post by: methodsboy on January 04, 2009, 07:23:04 pm
Is microsoft access a very important part of the exam. I havent done year 11 IT, so I have no idea how to use Access. Does anyone have any tutorial websites or notes.
Shouldn't be hard to learn as long as you can learn new things quickly... sers, i didnt listen that much to the doughnut butch and i got it. But MAKE SURE you learn it ! Even if it's just one SAC, it can make a huge difference in terms of ranking. If you don't get it, chill, like u said urself "ITA is probably not going in my top 4" <----> (that quote was not 100% accurate, i based it on my short -term memory)
Title: Re: General Advice for IT Applications
Post by: Glockmeister on January 19, 2009, 11:24:50 pm
I was ranked at "the bottom half" of my cohort, and ended up with the 3rd highest score.

Title: Re: General Advice for IT Applications
Post by: excal on February 08, 2009, 03:15:37 pm
I was ranked at "the bottom half" of my cohort, and ended up with the 3rd highest score.



tl;dr - all in the exam

Is microsoft access a very important part of the exam. I havent done year 11 IT, so I have no idea how to use Access. Does anyone have any tutorial websites or notes.

In the past, the exam was technology neutral (and that the SACs were the means to test your technical knowledge). With IT:A, Excel has managed to creep into the exam - but databases seem to be still fairly neutral (with an Access or Filemaker bias).



Title: Re: General Advice for IT Applications
Post by: billz1508 on October 12, 2009, 02:34:43 am
Technical, Operational, Economic, Social

these are contraints and factors.. but where are these in the ita nelson book.. :S??
Title: Re: General Advice for IT Applications
Post by: selim31 on April 30, 2010, 06:35:09 am

  • ITA SACs are probably the most draining SACs you'll ever do (I'm sure many will agree with me here). They're easy, but there's just so much to do. Don't neglect them though, they contribute 50% to your study score and the tasks required of you in your SACs will be very similar to the questions you'll get on the exam.

ITA SAC'S are a paine in the Ass lol :)
Title: Re: General Advice for IT Applications
Post by: ttn on April 30, 2010, 07:58:14 pm
Yeah, just finished the website SAC earlier this week. The last two periods was a crazy rush... fingers got so sore. Things are looking good though, my group of friends in the class which is half of the class, (we only have 11 students and 10 of them are yr 11 lol) are the only ones that managed to completely finish it and we also had the best looking/functioning site. We've got the database SAC in about 3 weeks, I heard its the hardest one out of them all?
Title: Re: General Advice for IT Applications
Post by: selim31 on May 01, 2010, 09:44:54 pm
We've got the database SAC in about 3 weeks, I heard its the hardest one out of them all?

Not really. sadly, i stuffed up my database which resulted in rushing it. I ended up getting a B. It's a lot of work......
Title: Re: General Advice for IT Applications
Post by: slothpomba on May 02, 2010, 02:05:34 am
Personally, i dont think databases are that hard.

They sort of make sense (well at least to me) and once you do enough practice, it becomes easy.
Title: Re: General Advice for IT Applications
Post by: ttn on May 02, 2010, 02:53:21 pm
Well yeah, i understand all the query commands and how databases work but it's the first time ever opened Access and with all the new stuff in the toolbar, it gets confusing as lol
Title: Re: General Advice for IT Applications
Post by: slothpomba on May 02, 2010, 04:30:24 pm
Haha i did IT 1/2 back in 2008, its been awhile since ive touched access much as well.
Title: Re: General Advice for IT Applications
Post by: schnappy on November 08, 2010, 11:59:28 pm
Just a quick question, not threadworthy and didn't want to confuse people.

Do all answers need to be in terms of a Windows XP system specifically? Like to say to remove 'read only' I could say:
-Right click the file, go to properties, and untick 'read only'.
-chmod 777 file.ext
-Grant write access to the file
Or I could take the nix-fu further:
cp file.ext file.writeable.ext && chmod 777 file.writeweable.ext