Swinburne has uploaded their revision lecture materials on their website now.
http://www.swinburne.edu.au/ict/schools/resources/ita/Presentation slides:
http://prezi.com/1dorjkvs0ktb/it-applications-exam-2011/If you registered and opted for them to email you, you should have gotten an email with the username/password for access. Seeing as they have enabled passwords, I don't think I should post the login details here on a public forum (*coughPMmecough*) or upload the materials they have put up on the page.
I watched through the recording of the lecture today, it was pretty interesting. You might feel that it's stuff you already know etc. but I felt that it was still well worth watching if you weren't able to make it to the lecture. The lecturer was Rob Mercer and he seems to know his stuff. He said that he worked on writing the current study design. It's a pity that he wasn't able to make the subject more interesting.
A few things of interest that I noted down (most of this stuff you should already know):
- 75% of the study design is stuff from the previous study design
- What to do when you notice an error in a question. If it's short answer, point it out and then answer it. The only surefire way of getting zero marks on a question is to not write down anything at all
- The number of lines you are given is enough space answer the question
- There was this table of key terms with definitions (e.g. discuss, explain identify) in the slide. - I'm not sure how to link to the specific bit in the presentation specifically, but it's towards the end of the 'General Advice' section
- Spreadsheet/Database questions will be a bit different this year. You can clearly see this in the sample exam questions, how you get an option 'SS' or 'RDBMS'.
- Any information you are given (e.g. tables, fields, values in fields etc.) are given for a reason. VCAA doesn't put stuff on the exam just for the sake of filler content, if there's a question on it, you're expected to discuss it. (this was pointed out in a question about finding the error in a database table - one was obvious and the other wasn't so obvious).
- Mnemonic for remembering validation/testing: VITO - Validate the input and test the output.
- In the first year of a study design, VCAA will put in quite a few questions to do with brand new content, to ensure that teachers are actually teaching to the new study design.
- Never mention legislation when answering an ethics question. If you're talking about privacy, copyright related ethical issues, ensure that you phrase in a way that it implies that you understand that ethics has very little to do with legislation (though obviously they go hand in hand)
- Procedures are more than one step
Areas of interest from previous VCAA exams - this list of stuff that he talks about pretty much shows the merit of doing previous study design exams.
- Backups
- Design tools vs. Design elements
- Organisational goals/descisions
- Transmission media
- Security
- Spreadsheets/Databases
- Software functions
- Validation/Testing
- Efficiency vs. Effectiveness
- Formatting and conventions
- Ethics
- Documentation (in particular, content-sensitive help)
- Network software
- Strategies (backup, testing etc.)
On new and changed stuff, he noted that:
Entity Relationship Diagrams:
- Key fields are underlined
- Entities are your table names
- Attributes are your fields
- Ensure you get your terminology right when talking about relationships
Normalisation - the sample exam indicates the level of knowledge we need to know about it. He also explained the differences between each normal form pretty simply:
- 1NF - Fields are separated properly
- 2NF - Placing data that is reused in different area in a separate table to reduce redundancy
- 3NF - Everything is dependent on the primary key
About the extended response questions we'll be getting this year:
- Choose which option you decide to talk about wisely
- Whether you should answer in dot points is being debated. VCAA doesn't have any rules that say that you can't write in dot points though. I didn't write down what his final opinion was (missed it while I was listening to it at school) and you have to reload the whole video just to listen to one small bit at the end :/
- Count the marks and ensure you have one point per mark
- Plan your answer, read the case scenario during reading time
About reading the case scenarios, I pretty much do what he outlined in the lecture. The extended response scenario is the the first thing I read when reading time starts and I re-read it before reading time ends. Of course I read it before I do the question. I also re-read it multiple times while I am completing the question (I also do this for all the other questions, just continuously looking back at what the question states).
So yeah, that's a quick summary of the most interesting stuff that I noted down when listening to the lecture.
As well as the recording of the lecture, there's also set of practice questions, the presentation slides, an excel spreadsheet with a list of the relevant questions from past VCAA exams and a few other materials.