Goodluck O-10 IT-Appers

[Plan-B]

Good luck guys!
It's been a long year and it will finish tommorow...
Excited? haha

Hope you guys destroy the exams!
So lets go out tommorow and kick some ass

 

Good Luck!

[nacho]

Long term more like it! IT was bludge.
Good luck to everyone, I know people on this site are all going to get  mid-high A+
Plan-B probably going to ace?
GL HF Epic study sesh.
What time's the exam again?

[Plan-B]

I really hope I can.. I'm sure you'll ace it too!

Exam timetabe: http://www.vcaa.vic.edu.au/vce/exams/timetable.html
November 9th, Tuesday: 3.00pm to 5.15 pm.
Get there early though!

[nacho]

I do IT is an anagram for "Idiot"  - just putting it out there.

Also, just HAVE to clarify this because it will definitely 300%^9001 be on the exam.
Validation rule for phone numbers = input mask?
What about for suburb? " Between 3000 and 3999" should be sufficient? (Assuming say, it's a local school)
OR >=3000 and <=3999 ?

I still don't know whether input masks are counted as validation rules.. they control how data is entered
validation checks to see if data entered is reasonable

[ben92]

I think the real challenge of IT is getting a score that's still good after scaling.

[Plan-B]

I do IT is an anagram for "Idiot"  - just putting it out there.

Also, just HAVE to clarify this because it will definitely 300%^9001 be on the exam.
Validation rule for phone numbers = input mask?
What about for suburb? " Between 3000 and 3999" should be sufficient? (Assuming say, it's a local school)
OR >=3000 and <=3999 ?

I still don't know whether input masks are counted as validation rules.. they control how data is entered
validation checks to see if data entered is reasonable

I'm not 100% sure myself, but I'm pretty sure it is a validation rule. And I can't think of any way else of validation phone numbers. So it has to be.

For suburb Between 3000 and 3999 would be the best, as it is a data type check and a range check, which would be better then an input mask.  >=3000 and <=3999 basically does the same thing, so it's your preference I guess.

[nacho]

OH, i just realised, this could come up, i've never seen it come up though.
What is an IIF statement?

[Plan-B]

From my notes, taken from Potts book...
IIF() statement can be used to set the upper and lower limits of valid data for a particular field in a database. IIF stands for Inline IF. The IIF() statement can be prepared to display an error message if data falls outside the allowed range, or proceed with calculations if the data is valid. E.g. =IIF([Total_Cost]>3500, ”Premium Customer”,””)

So in other words, basically an if statement for Databases. I think it's used in Query searches, you know how in SACS where we would make additional fields in that query box, and applied formulas such as =SUM([Cost]*[Product_Quantity]) or something like that.

[nacho]

Nope, bludged SACs comepletely i think i got 38/50 for all my SACs as i never used textbook and teacher never taught us!
ohwell it makes sense now though.

Can someone briefly explain the relationships in database.
One-to-many (one record in a table will appear many times in another table?) Example =
many-to-many (many records in a table will appear many times in another?) Example = ? (don't use phone extensions, i dont get that one)
many-to-one

[Plan-B]

One to many: A soccer team can have many players, but a player can only play for one soccer team. Assuming players only play for one team at a time.
Many-to-one: Just basically one to many, but backwards. Therfore, many players play for one team, and one team has many players.
Many to many: A student can have many subjects, but a subject can have many students.

Hope it's kinda understandable?

[Scoota.]

is field size a validation RULE?
it restricts data entry in terms of like a range check, but is it a rule?
Also, do you think implementation strategies for solutions will be on the exam like Pilot, phased, direct, and parallel? coz i just ran into a question like that on an insight exam and i had no idea wat it was on about.

[nacho]

Field size is a method of validation, and i THINK it can be a rule? Like : "Must be 10 characters" for phone number.

Implementation strategies may be part of a mc question, unlikely for short answer.
They are very straight forward though, read up on them.

Question :
Can someone define : "Accuracy" (say of a website? Don't say 'is the information accurate?') i get mixed up with accuracy and reliability as you can't have one without the other.
"Meaningful"
and
"Usability"
Thanks.

[Scoota.]

Accuracy is whether the information displayed is correct such as a figure calculated from a formula eg. 2+2=5 is obviously wrong.
For a website dealing with ancient history for example, if important dates aren't correct like the end of the world war in 1945, if it said 1432 then obviously its wrong and this is INaccurate and will MISLEAD users.

Reliability is whether the info' is free from bias and accurate. For example a reporter who hates a celebrity writes an article on them and only points out the celebrities faults rather than writing a well reasoned argument. Thus the info'/ article is UNreliable as it only gives readers one side of the story.
So yeah i think accuracy is incorporated into reliability but there are other factors such as freedom from bias.

As for meaningful i have no idea, but usability is really straight forward, it just means how easy a solution, such as a website, is to use and how much effort a user has to put in to successfully use the solution or navigate through the website.

[nacho]

Can anyone do that question frmo Swinburne exam? Question 7 under practice questions.

I put: "Clarity - text displayed on the website is aligned and is not cluttered, making it clear and easy to read, thus the purpose of the website, to inform, is achieved as users can easily interpret information being communicated to them.

The solutions say:
Clarity/Consistency: The use of the navigation buttons on the left hand side of the screen and the top of the page mean that users will always be able to find them as they navigate to different parts of the site.
Proportion: The heading at the top of the page is larger and hence stands out more. Also could have said:
Orientation: The juxtaposition of the different screen elements such as the navigation, prospective students, general information and latest news allow the user to easily understand what the different elements of the page are.
Colour/Contrast: The contrast of the heading of dark on light emphaises it. The choice of colours on the site ensure readability and balanced use of White Space and text make the page visually appealing.

But i feel these are lacking? They don't say how it helps achieve the purpose of the website?
In questions such as these how would we approach it? "Purpose of website..?"
Also, would i be awarded marks or was i completely off? I do these types of responses quite often and give myself 0.

EDIT: ONE LAST mega clarification.
Sans-serif is for body text, Serif is for headings. Correct?

[Plan-B]

Can anyone do that question frmo Swinburne exam? Question 7 under practice questions.

I put: "Clarity - text displayed on the website is aligned and is not cluttered, making it clear and easy to read, thus the purpose of the website, to inform, is achieved as users can easily interpret information being communicated to them.

The solutions say:
Clarity/Consistency: The use of the navigation buttons on the left hand side of the screen and the top of the page mean that users will always be able to find them as they navigate to different parts of the site.
Proportion: The heading at the top of the page is larger and hence stands out more. Also could have said:
Orientation: The juxtaposition of the different screen elements such as the navigation, prospective students, general information and latest news allow the user to easily understand what the different elements of the page are.
Colour/Contrast: The contrast of the heading of dark on light emphaises it. The choice of colours on the site ensure readability and balanced use of White Space and text make the page visually appealing.

But i feel these are lacking? They don't say how it helps achieve the purpose of the website?
In questions such as these how would we approach it? "Purpose of website..?"
Also, would i be awarded marks or was i completely off? I do these types of responses quite often and give myself 0.

EDIT: ONE LAST mega clarification.
Sans-serif is for body text, Serif is for headings. Correct?

0?, I thought you would of got the mark.

Mark Kelly, doesn't give a specific defintion to sans/serif use, as he believes it's your preference.
But Potts says that:
Serifs which have tails should be used to make it easier for the viewer to read large amounts of text on the screen. It can help guide the eye and reduce eystrain when reading large blocks of text. Sans Serif can be harder to read and comprehend.  << Page 185

No straight answer but the consensus appears to be that san serif should be used for headers at most, and serif for main text?