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
Starter quiz
6 Questions
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1698136994%2Fbrzpoe4asq7luzry4y61.png&w=1080&q=75)
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1698136994%2Fbrzpoe4asq7luzry4y61.png&w=1080&q=75)
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1698136995%2Fx1lghblxoawcacuhvcbi.png&w=640&q=75)
a -
90
b -
360
c -
4
d -
48
e -
88
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1698136987%2Fwv2h4vl71oni0n8zckwh.png&w=640&q=75)
Exit quiz
6 Questions
addition -
+
subtraction -
-
multiplication -
*
division -
/
not used for any operation -
x
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1698136993%2Fnnvia4wsinaejkcahgwb.png&w=1080&q=75)
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1698136983%2Fmtkmtskyyf1o23wrtjjr.png&w=640&q=75)
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1698136996%2Fdmnuy74puizwykaqiz9r.png&w=640&q=75)
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1698136981%2Feemandzmobzaomgeilmb.png&w=828&q=75)
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