a circular chart where sectors represent different groups in proportion to each other

Creating a pie chart on a spreadsheet

British English CC

Presenting data using charts

Computing

Collecting data

Formatting a spreadsheet

Spreadsheet formulas

Using formulas in a spreadsheet

Event planning using a spreadsheet

This unit introduces pupils to how spreadsheets can be used to organise data and create their own data sets. They will discover the importance of formatting data to support calculations, while also examining how formulas can be used to produce calculated data and how graphs can present this data.

Introduction to spreadsheets

a graphical representation of data values

a circular chart showing percentages of a total

a chart that uses rectangles to compare different data values

a structured way of showing exact data values

What type of chart uses rectangles to compare different data values?

Charts are not suitable for showing exact values.

Tables are always harder to understand than charts.

Tables are better for spotting patterns in data.

Which of the following is true about charts and tables?

an electronic document for organising data

a ready-made instruction for a calculation

What is the cell reference for the first cell in a spreadsheet?

If we wanted to add up all the cells between B2 to B10 using a function, what would we type in?

Starter Quiz

Why is it important to organise data?