[Free help] Does anyone have any issues with IT Apps? I can (hopefully) help

[jonte]

Accessibility should always be linked to vision impaired users, which, if I remember correctly, you referred to.

According to the assessors report for that question, it went on to speak about how changing from opening up the chat room from being an intranet based (closed) feature, it was becoming open, which therefore allowed access to a wider audience.

I would ignore the second part of the response. It would be unlikely you'd get a 4 mark accessibility question again, and any 2 mark question should be answered with vision impairment first and foremost.

Thanks. Yeah I found it was easy to state the sound files could help visually impaired users but the second part was a bit ambiguous, VCAA probably realised their mistake.

[maybesortof]

Alright so I'm back again with another question. In regards to the 8 mark questions should I be looking to create a single solution that covers all of the requirements or are separate solutions that solve each okay? So far I've been splitting up the issues and providing solutions to them individually. For instance in the attached question for the second dot point I avoided the issue of dealing with the 3 months by suggesting that he just have a spreadsheet that holds the 3 months of data and no more.



Thanks for the help guys.

[ITTeacher]

Alright so I'm back again with another question. In regards to the 8 mark questions should I be looking to create a single solution that covers all of the requirements or are separate solutions that solve each okay? So far I've been splitting up the issues and providing solutions to them individually. For instance in the attached question for the second dot point I avoided the issue of dealing with the 3 months by suggesting that he just have a spreadsheet that holds the 3 months of data and no more.

(Image removed from quote.)

Thanks for the help guys.

Pretty poorly worded question, in my opinion.

Regardless, ignore the "3 month" stuff. VCAA have used it many times throughout this study design, e.g. Find the highest selling product over the last 3 months. Answer: Sort Quantity sold in Descending order. (1 mark for Sort-Descending, and 1 mark for Quantity sold)

Onto that question, your approach should not be to talk about an entire solution, rather, you should just address the specific points. Subheadings are best.

e.g.
Country of origin: Sort country of origin field in Ascending order, this will return a list of snowboarders such as, Australia, Canada, Finland etc.
Who placed first: If statement to check Placing data. IF(Placing=1,15% Bonus, No bonus)
Haven't placed highly: Sort placing data in Descending order, this will put the snowboarders with the lowest placings at the top of the list.
Graph payments: Create a column graph comparing the payments of each snowboarder for the year.

The problem with the wording of the question is that two of the points tell you what function to use.
Point 1- Sort and Point 4- Graph
Point 3 is too vague. Better wording would ask you to find the lowest (or lowest 2/3/4/5) placed racer in a particular race, in which case sorting would work nicely.
Point 2 is the best written point, but it's still quite difficult to write about how you would do it.

If you want to make another attempt at the question, here's a reworked version:

ProGo is a travel company that sponsors competitive snowboarders. They want to develop an information system that allows them to monitor the snowboarders they sponsor and their payments to them. Specifically, they want to be able to:
- find all snowboarders from Canada
- review sales trends for each snowboarder's merchandise
- find the 5 snowboarders whose merchandise has been the highest selling
- find the total attendance of the last 5 events

Further to that, show test data for each of those functions. (It would now be a 16 mark question which is not practical. But it's unlikely you'd see 8 marks assigned to only functions - test data has been included in all similar VCAA questions)

[jonte]

ProGo is a travel company that sponsors competitive snowboarders. They want to develop an information system that allows them to monitor the snowboarders they sponsor and their payments to them. Specifically, they want to be able to:
- find all snowboarders from Canada
- review sales trends for each snowboarder's merchandise
- find the 5 snowboarders whose merchandise has been the highest selling
- find the total attendance of the last 5 events

1. Filter the country column to only include "Canada".
2. Not really sure. Do you mean create a graph to represent the trends? If so, a bar chart displaying the snowboarder's name on the x axis and the total merchandise sold on the y axis.
3. Sort sales column in descending order.
4. Sort date column in descending order and use a SUM function on the first 5 attendance cells in the list. =SUM(E1:E5)

Would that be correct?

[Acez04]

Quick question,

When asked to design something like the poll on the 2014 examination, do we have to draw how it is going to look (Like Mark Kelly's response: http://vceit.com/p/postmortem-2014i.htm) or just text referring to what am I going to put? (What's shown on the examination report: "Textbox for comments" etc.)

(I can't seem to upload to photos  )

Thanks!

bump

[Orson]

My teacher marked my 2014 VCAA. I got 75/90...not looking good 

[Acid]

bump

You should draw, and it's preferable if you label how you're satisfying the criteria.

...and I still don't know what bump means

[maybesortof]

You should draw, and it's preferable if you label how you're satisfying the criteria.

...and I still don't know what bump means

It's said when someone brings back a post to gain more attention, like in a thread you might not get many replies so after the thread hits the second page in the sub forum you go to your thread and type 'bump' to bring it back to the first page where more people will see it and potentially respond.

[usernamegoeshere]

- review sales trends for each snowboarder's merchandise

What is the best way to do this in an RDBMS?
Query the total sales for each snowboarder for each month using a calculated field then create a report?
Is it necessary to write the formula in the calculated field or will a description of what it will do suffice?

[ITTeacher]

1. Filter the country column to only include "Canada".
2. Not really sure. Do you mean create a graph to represent the trends? If so, a bar chart displaying the snowboarder's name on the x axis and the total merchandise sold on the y axis.
3. Sort sales column in descending order.
4. Sort date column in descending order and use a SUM function on the first 5 attendance cells in the list. =SUM(E1:E5)

Would that be correct?

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.

[jonte]

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.

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]

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?!

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]

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.

Thank you!