ATAR Notes: Forum
VCE Stuff => VCE Technology => VCE Mathematics/Science/Technology => VCE Subjects + Help => VCE Computing: Data Analytics => Topic started by: Acid on October 16, 2015, 05:30:21 pm
-
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!
-
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.
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.
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
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
Based on what I've seen, you should be able to solve any similar problem with any of Sorting, Filtering or Graphing.
Good luck!
-
Thank you! :)