ATAR Notes: Forum
VCE Stuff => VCE Technology => VCE Mathematics/Science/Technology => VCE Subjects + Help => VCE Computing: Data Analytics => Topic started by: Plan-B on November 08, 2010, 09:58:10 am
-
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 :D
;D ;D ;D ;D ;D ;D ;D
Good Luck!
-
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?
-
I really hope I can.. :D 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!
-
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 think the real challenge of IT is getting a score that's still good after scaling.
-
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.
-
OH, i just realised, this could come up, i've never seen it come up though.
What is an IIF statement?
-
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.
-
Nope, bludged SACs comepletely i think i got 38/50 for all my SACs as i never used textbook and teacher never taught us! :D
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
-
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?
-
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.
-
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.
-
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.
-
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?
-
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?
-
Information privacy principles.
I'm not sure if these are even in my textbook... can anyone tell me a bit about them?
-
I use the following to remember them:
COATS
DUD
AI
Off the top of my head, they are:
C = collection
O = openness
A = access and correction
T = transborder data flow
S = sensitive information
D = data quality
U = use and disclosure
D = data security
A = anonymity
I = identifiers,
Note: "O" may be wrong, i forgot. :D
BRB gonna eat something, there are in the text book, look for the laws chapter, "storage and communication impacts" or something, chapter 7 i think.
-
11 national privacy principles come under the privacy act 1988. YOU MUST KNOW AT LEAST SOME OF THESE FOR THE EXAM.
1. manner and purpose of collection of personal info'. (any info collected must be for a lawful purpose)
2. Solicitation of personal info from the individual concerned. (collector of info must disclose why the info has been collected and that it is lawful or required under the law)
3. Solicitation of personal info generally. (collected info must be relevant to the purpose for which it was needed/collected, and up to date and complete. Collection should not intrude on the individual)
4. Storage and security of personal info'. (proper security measures must be taken to protect collected info' from loss, damage, unauthorised access, use and modification or disclosure/release)
5. Info relating to records kept by record keeper. (record keepers must control the records containing personal info and make it clear what info is stored, its purpose and how people can access it)
6. Access of records containing personal info. (individuals are entitled to see their info)
7. alteration of records containing personal info. (records are to be accurate and up to date but can be amended if they contain errors)
8. Record keeper must check accuracy etc. of personal info before use. (info must not be used unless it has been checked for accuracy, timeliness, completeness, and its relevant to the purpose for which it was collected for)
9. Personal info to be used only for relevant purposes. ( info may not be kept unless its relevant to the purpose for which it was collected)
10. limits on use of personal info. ( personal info may not be used for any purpose except that for which it was collected)
11. Limits on disclosure of personal info. ( personal info may not be disclosed to anyone without the individuals consent)
NOTE: THE STUFF IN BRACKETS IS JUST A DESCRIPTION NOT PART OF THE ACTUAL PRINCIPLE ITSELF BUT ARE GOOD BACKGROUND INFO FOR EACH PRINCIPLE
Hope it helps. :)
-
Plan-B you legend,
Can you define these? :
* maintainability
* reliability
* user acceptance
* ease of use
-
GOOD LUCK GUYS, HOPE U ALL GET A+++++
:)
-
Plan-B you legend,
Can you define these? :
* maintainability
* reliability
* user acceptance
* ease of use
Maintainability I guess refers to how well something is to maintain, run? When considering maintainibility, you might take into account the cost of running, time required for repair, etc?
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.
I thought this covers it pretty well for reliability.
User acceptance is a type of testing performed where the solution is tested to confirm whether it meets the users expectations and needs. This is usually tested through surveys and/or interviews with clients, customers or whoever is using the newly designed system. It's similar to evaluation, but it occurs during testing in which questions such as 'how do you perform this specific function? or Can you do this easily' etc.. is asked, and then feedback recieved.
Ease of use refers to how easy it is to perform or use the specific tool/solution. I believe it relates directly to usability as in if usability is good, then it is easy to use. Ease of use is also achieved through redundancy (which improves accessibility) by providing users with additional ways to perform a specific task (e.g providing a link to the home page at the bottom of the website along with its normal navigation at the top). Its generally evaluated under effectiveness though criteria such as "Complication of site's navigation", etc...
Hope that kinda helps :D
-
Plan-B, take the exam under my name and i'll take it under yours?
Btw, have you done all the 'Test your knowledge' questions from the book? Those are pretty helpful :O Fml, i find these things out now..
-
Dude... You'll do well man, you've just been marking yourself really harshly.
Plus, when exam comes, I'd probably choke and screw up heaps as that was what happened in some of my Year 11 exams. You wouldn't want that.
-
Hopefully everyone gets a 46+ :D
Year 11 exams? You're in year 12?
BTW
Was it HB pencils that we must bring?
-
Haha nah I'm in year 11, my year 11 exams were last week and I screwed two of them up.
I think it's 2B?
-
Logical and physical design.
Logical Design is created in the analysis step and describes what the solution will solve? ( I think the last part is wrong??)
Physical Design is created in the design step and .......................???
-
Good luck folks, not that you guys need it.
Logical design: what needs to be achieved? (analysis stage)
Logical design tools: context diagrams, data flow diagrams, data dictionaries.
Physical design: how will these needs be achieved? (design stage)
Physical design tools: storyboards, flow charts, N-S charts, structure charts, IPO charts, layout diagrams, pseudocode
Edit: seeing double.
-
"seeing double." ?
Ell, seeing your quite the IT legend (49 SS :o)
Could you help me understand how to answer questions on design elements?
I compiled a list of questions i am never able to do, i'll attach them
VITTA 2009 Exam 1, Section B, Question 1.
Swinburne Exam prep Question 7 (under practice questions)
Swinburne Exam prep Question 2a,2b (section b)
I just don't get design elements, for the swinburne one, 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."
Which was significantly different from the answers.
-
Ha, I'd accidentally written a logical design tool twice.
What did the answers say? Honestly, that answer seems okay, just make sure you (very obviously) relate it to the actual material - reference actual parts of the website like the 'welcome text' or 'Latest News' instead of saying 'text'.
VITTA 2009 Exam 1, Section B, Question 1.
Just go through the characteristics and see if they apply. Some examples:
- Clarity: bit confusing the way the 'Last name:' label is aligned - move the labels right next to the correct text boxes so there is no ambiguity, add some colour to help distinguish different parts of the interface, etc.
- Ease of use: add keyboard shortcuts, move Save/Add/New buttons to a more logical position (e.g. right above 'Search Student') instead of in a corner next to the search button, etc.
- Appearance: it's not pleasant to look at, especially the big blank space. You could align the text boxes so that there is less unused space, move the Last Name textbox under the First Name textbox, etc.
-
Oh, thanks.
Just a last question, do examiners still mark you if you write off the lines? like down to the side, or below - if you're a few words short of space.
-
As long as it's readable, it should be good. However, you really don't need to write that much to get full marks.
Quality over quantity :)
-
IT is my worst subject, even though it's my only year 12 :D
gl for tomorrow guys, epic study sesh till 12:30.
-
It's my only year 12, too :)
What happens after 12:30? Meditation, nap, COD?
I'll have to study til 3pm or I'll feel guilty :P
-
12:30 AM i mean, so yea, nap.
After that, wake up 8:30 (8 hours sleep)
normal routine, study till 1pm maybe, then for 90 minutes, chillax, keep my mind off the exam
Crap, ONE LAST QUESTION.
VCAA 2009 (78/90 :D)
Question 20 from MC.
Question 20
Task X has 20 days duration and Task Y has 15 days duration. Task X is a predecessor of Task Y. Task Y cannot
start until 10 days after Task X has finished.
If Tasks X and Y are on the critical path, the 10 days of delay for Task Y is called
A. lag.
B. lead.
C. start to start time out.
D. finish to finish time out.
I put B, answers says A.
I'm almost positive it's still B?
The 10 days leading up to task Y (as it must wait 10 days before it can start) is lead time?
10 days of delay for task Y ??? Where'd they even get this from, are they proposing task Y can go over board by 10 days without affecting the critical path?
Something's wrong, i don't understand...
-
Question 20
Task X has 20 days duration and Task Y has 15 days duration. Task X is a predecessor of Task Y. Task Y cannot
start until 10 days after Task X has finished.
If Tasks X and Y are on the critical path, the 10 days of delay for Task Y is called
A. lag.
B. lead.
C. start to start time out.
D. finish to finish time out
I put B, answers says A.
I'm almost positive it's still B?
The 10 days leading up to task Y (as it must wait 10 days before it can start) is lead time?
10 days of delay for task Y ??? Where'd they even get this from, are they proposing task Y can go over board by 10 days without affecting the critical path?
Something's wrong, i don't understand...
lag time refers to time between tasks.
-
oh that's right.
I always thought the definiton was the amount of time a task may run overboard without affecting the critical path?
-
lol that's slack time.
-
i thought lag time and slack time were the same thing?
-
Yeah I thought so too..
Definition page 30 Potts, "Lag time, or slack time, relates to the amount of time there is between tasks. The lag time for an event is the amount of time by which the event can run over time without delaying the project".
Mark Kelly has a slight variation:
http://vceit.com/ganttpert/projmanterms.htm
But they both essentially apply to the same thing I guess.
Lead time is the time leading up too or before a task. In the case of that question, it would be 30 days lead time for Task Y.
-
The Potts definition is pretty horrible :|
Would this definition be okay? "Lag time is the amount of time a task must wait even though its predecessor has finished. (e.g. drying concrete)"
-
Great, now im confused LOL so bad.
This is what i gather now.
Lag team : Time inbetween tasks
Slack time: DIFFERENT FROM Lag time, time a task can go overtime without affecting the end date of the project
Lead time: Time leading up to a task,
Eg task A = 5 Days
task B = 2 days
Task C canonly start after both task A and B are finished plus two days, so:
Task C has a lead time of 7 days.
Task B has a slack time of 2 days.
Task C has a lag time of 2 days?
-
They said task Y cannot start until 10 days after task X has finished. So it's definitely not slack, as that would instead mean Task X has an extra 10 days to finish or Task Y wouldn't have to wait 10 days after task X.
And lead time refers to the amount of time leading up to the task from the start of the project.
-
Is my example correct?
-
Eg task A = 5 Days
task B = 2 days
Task C canonly start after both task A and B are finished plus two days, so:
Task C has a lead time of 5 days.
Task B has a slack time of 3?? days.
Task C has a lag time of 3 days from task B
Task A and B start at same time right? If so, thats what I think it is.
-
Umm and assuming task a and b start at the same time,
I think
Task C has 5 days lead time (By definition)
Task B has 3 days slack time (Task B can run over 3 days, meaning it finishes at the same time as Task A, thus not effecting the deadline)
Task B also has 3 days lag time (If the project runs accordingly, Task C begins immediately after Task A (because longest task), and Task A is 3 days longer then Task B, meaning the lag time is also 3 days)
Therefore, Slack Time = Lag Time?
Remember, lag time is the amount of time a task can run over time without affecting the critical path. Task B can run over time, not Task C
Thats my understanding of it, but I may be wrong.
-
Yea but the lead time should be 7 days because:
Task A takes 5 days
in which task B will start at the same time taking only 2 days.
BUT, you have to wait an extra two days after task A is complete, therefore Task C can only start 7 Days after the project begins? Therefore lead time = 7 days?
Slack time = 3, sorry typo.
Task C has a lag time of 2 days? as it must wait those 2 days extra days?
Umm and assuming task a and b start at the same time,
I think
Task C has 5 days lead time (By definition)
Task B has 3 days slack time (Task B can run over 3 days, meaning it finishes at the same time as Task A, thus not effecting the deadline)
Task B also has 3 days lag time (If the project runs accordingly, Task C begins immediately after Task A (because longest task), and Task A is 3 days longer then Task B, meaning the lag time is also 3 days)
Therefore, Slack Time = Lag Time?
Remember, lag time is the amount of time a task can run over time without affecting the critical path. Task B can run over time, not Task C
Thats my understanding of it, but I may be wrong.
No, task C must wait an extra 2 days as specified. So would the lag time become 7 days?
Edit: this is literally the worst thing that could happen 16 hours before an exam..
-
Great, now im confused LOL so bad.
This is what i gather now.
Lag team : Time inbetween tasks
Slack time: DIFFERENT FROM Lag time, time a task can go overtime without affecting the end date of the project
Lead time: Time leading up to a task,
Eg task A = 5 Days
task B = 2 days
Task C canonly start after both task A and B are finished plus two days, so:
Task C has a lead time of 7 days.
Task B has a slack time of 2 days.
Task C has a lag time of 2 days?
Damn missed that part
So, yeah you were correct, besides the typo.
Task C has a lead time of 7 days.
Task B has a slack time of 3 days.
Task C has a lag time of 2 days.
-
So in the end, it's
Task C has a lead time of 7 days
Task B has a slack time of 3 days
Task C has a lag time of 2 days?
-
yeap
-
Oh yeah, lead time should be 7... Sorry didn't see the plus two days too. :( << Hopefully i don't do this in exam
-
Ok, now i'm only confused because the potts text book says they are the same thing?
"Lag/slack time is the time between tasks"
-
They aren't. I did a practice exam that asked the difference.
-
I think lag time is more for tasks that are on the same path? while slack time are tasks on different paths and therefore can change the critical path.
lol I dunno.
-
ahwell guys, screw it!
As if they'd ask this question anyway,they used it for 07 :D
-
They aren't. I did a practice exam that asked the difference.
Yeah, wasn't that the Kilbaha 2010 one? Alot of these practice exams are really dodgy, you can't fully trust the answers and questions provided. : D
I'm more inclined to trust the textbooks and Mark Kelly. Although right now there is a discrepancies between the two.
ahwell guys, screw it!
As if they'd ask this question anyway,they used it for 07 :D
Yup, I'm going with Potts definition. Unless, they specifically have a question that asks for it's lag time, and then the slack time, then I'll go with Mark Kelly.
-
ahwell guys, screw it!
As if they'd ask this question anyway,they used it for 09 :D
lol
-
True! And Potts is more current than Mark Kelly's information on project management, so yeah.
At least we kind of know the gist of it now, just incase :)
Hahaa, nacho :P
-
Alright, I'm off to bed. Good luck everyone.
-
you to mate. sleep well.
-
What's lead time?
-
Lead time: Amount of time before a task begins