Previous post: Phase 2 Excel analysis
This section of work relies entirely on the quality of the analysis that you performed on your questionnaire data. Simply selecting some unprocessed data such as the Gender data and creating a pie chart is meaningless.
In this post:
1. The requirements
SPREADSHEET – GRAPHSThe 2020 Grade 12 Marking Rubric
At least TWO graphs that are relevant, meaningful and serve a purpose, are of the correct type and formatted to be easy to interpret (headings, labels, legends, et cetera). The graphs will help to answer questions and contribute to the solution/explain aspects of the problem/solution.
The rubric goes on to award marks for:
- At least one relevant, meaningful graph present, that will contribute to the solution
- A second relevant meaningful graph that will contribute to the solution
- Appropriate types of graph(s) and options used
- Graph(s) easy to read and interpret
The processed data — the information — that represents synthesized knowledge is what you must aim to chart!
2. Relevant Charts
Many learners create a Chart like the one below left. That Chart does not “contribute to the solution/explain aspects of the problem” and is, in fact, incorrect. The correct Chart is the one on the left.
If you take a step back to my previous post, Phase 2 Excel analysis, you will see why the above Chart is incorrect.
3. Appropriate Charts
You must look carefully at the data that you wish to chart: not all charts will be appropriate (or even work) for all datasets.
See the following post for an example: Excel Sunburst Chart.
Next up: the Access Database