VCE Stuff > VCE Computing: Data Analytics
[Free help] Does anyone have any issues with IT Apps? I can (hopefully) help
jonte:
--- Quote from: ITTeacher on November 09, 2015, 06:11:16 pm ---1. Perfect. (although use the word Field instead of Column)
2. Review sales trends was included on the 2013 (?) exam. Review sales trends of Bike Models. The best answer is a Line Graph (which will show data trends). Pie graph will compare percentages of a total. A bar graph will compare totals. However, any of these would likely get you marks. VCAA are in the business of giving marks, not taking them away.
3. Good. Justify why.
4. Great. I hadn't considered the need to sort the dates. But you're absolutely right. Sum was the function I was interested in.
--- End quote ---
Thanks for marking those. I just realised that in excel if you sort the fields in descending order (A-Z) then the numbers are actually sorted in ascending order (because A=1, B=2). Would that matter on the exam, or would just saying descending suffice for numbers ordered going from 10-1 for example?
Thanks again.
thebelljar09:
For spreadsheet, does anyone know if Smart Filter is accepted as a function? There have been numerous occasions where the problem could be easily solved by using Smart Filter (Excel), which does similar things to a database query, but the official VCAA answer uses the long method of conditional formatting.
As an example, they want to find the item that has sold more than $500 that week. Smart Filter can easily do this by setting the criteria for the Sales column to be >500. But no, I have to use conditional highlight?
Could anyone give me some insights or advice on what I should do? Don't want to risk anything on Thursday.
Thanks so much!
Acid:
Could someone help me with 1b please
I wrote the option to choose the user's exact age should be provided as it increases the accuracy, however I feel sceptical about my response...
Also, does anyone have the solution to IT Apps sample exam?!
ITTeacher:
--- Quote from: Acid on November 11, 2015, 12:25:24 am ---Could someone help me with 1b please
I wrote the option to choose the user's exact age should be provided as it increases the accuracy, however I feel sceptical about my response...
Also, does anyone have the solution to IT Apps sample exam?!
--- End quote ---
Poorly worded question - in the sense that there's no obviously correct answer.
In my opinion, Accuracy is the right effectiveness measure to discuss, however, I'd expand the scope of the question to change from a dropdown list to a calendar function and allow users to enter their Date of birth.
Within the confines of the question, I think your answer is spot on.
Acid:
--- Quote from: ITTeacher on November 11, 2015, 12:54:52 am ---Poorly worded question - in the sense that there's no obviously correct answer.
In my opinion, Accuracy is the right effectiveness measure to discuss, however, I'd expand the scope of the question to change from a dropdown list to a calendar function and allow users to enter their Date of birth.
Within the confines of the question, I think your answer is spot on.
--- End quote ---
Thank you!
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version