Constructing pie charts by utilising technology
I can construct pie charts from data presented in a number of different ways using technology.
Constructing pie charts by utilising technology
I can construct pie charts from data presented in a number of different ways using technology.
These resources will be removed by end of Summer Term 2025.
Lesson details
Key learning points
- Pie charts can be constructed quickly using Excel.
- The angle of each part can be quickly calculated in Excel.
- Different types of pie chart can be created.
Keywords
Clockwise - Clockwise is the direction that the hands of an analogue clock travel
Pie chart - A pie chart (pie graph) is a circular graph where sectors represent different groups proportionally.
Frequency - The frequency is the number of times an event occurs; or the number of individuals (people, animals etc.) with some specific property.
Angle - An angle is a measure of turn, it is often displayed as the rotation between two line segments.
Sector - A sector is the region formed between two radii and their connecting arc.
Common misconception
1) = not necessary to put into function, 2) students type in number to calculate, not click the cell
1) the = at the start tells the spreadsheet to start a calculation, 2) clicking the cell means if input data chances, outputs auto-update
Licence
This content is © Oak National Academy Limited (2024), licensed on Open Government Licence version 3.0 except where otherwise stated. See Oak's terms & conditions (Collection 2).
Lesson video
Loading...
Starter quiz
6 Questions
a -
90
b -
360
c -
4
d -
48
e -
88
Exit quiz
6 Questions
addition -
+
subtraction -
-
multiplication -
*
division -
/
not used for any operation -
x
Spreadsheet function for S37 -
= sum(S34 : S36)
Output value for S37 -
810
Spreadsheet function for T39 -
= 360 / S37
Output value for T39 -
$$4\over9$$ or $$0.44\dot4$$
Spreadsheet function for T34 -
= S34 * T39
Output value for S34 -
124