VCE Stuff > VCE Computing: Data Analytics

8 mark question: Should we anticipate this question style in the VCAA ITA exam?

(1/1)

Acid:
This questions seems a bit dodgy... never seen something like this in the actual vcaa past papers, so should I anticipate something like this? See attached pl.
Also, how would you go about solving it? Like idk how to find the top 20% of the customers or the sales, I feel either this is out of the scope of vce ITA, or my teacher has taught us insufficiently... any help would be great, thanks!

ITTeacher:
You could potentially see a question in similar structure to this, but you wouldn't see a question that asked you to show the same function (top 20%) twice.

VCAA have asked a similar question before, Q12 2012.


--- Quote ---Fast Wheels sells eight models of sports bicycles. The manager wants to increase bicycle sales in the new
year and reduce costs. He has decided to
• review the sales trends of all models after the first three months
• drop the two models that have sold the least in the first three months
• reward sales staff who sell more than 20 bicycles in the first three months.
Describe how you would use a spreadsheet or a relational database management system to provide the
information the manager needs. For each information requirement, make reference to
• data required
• functions to be used
• data to test the solution.

--- End quote ---

Finding the bottom/top anything can be done by either sorting or conditional formatting.

To answer your original question of top 20% customers:
option 1) Sort the customers total sales ($) in descending order to identify the top 20% of customers (e.g. the first 20 from 100)
option 2) Use conditional formatting on the customers total sales ($) to identify the top 20% of customers, highlighting the data by changing the cell colour to a light shade of green.

Practically speaking, combining the two would be both more efficient and effective as the data would be ordered and top 20% highlighted, but your marks would come from one function or the other.

Testing is straight forward, have 10 customers who have sold varied total sales ($),  after applying the sort, they will be in order of highest to lowest total sales, after applying the conditional formatting the top 2 (2/10) will be highlighted.

If your teacher hasn't gone through conditional formatting with you, he/she should have as it's on the list of mandated functions.

http://www.vcaa.vic.edu.au/Pages/correspondence/bulletins/2010/July/vce_study.aspx#2

--- Quote ---Spreadsheets

conditional formatting
formulae including simple functions (SUM, average, maximum, minimum, count), conditional statements and lookup tables
cell protection
graphs
insert notes/comments
macros
relative and absolute cell references
naming a range
electronic validation
sheet referencing
formatting/layout
--- End quote ---

Based on what I've seen, you should be able to solve any similar problem with any of Sorting, Filtering or Graphing.

Good luck!

Acid:
Thank you!  :)

Navigation

[0] Message Index