Slides badge

Charts

Learning Intentions

  • Using numerical data in a spreadsheet create some charts to be able to analyse the data visually.

Success Criteria

  • Listening carefully to others views and ideas.

  • Supporting each other to complete the task

  • Create a range of charts:

    • Bar Chart

    • Pie Chart

    • Correctly label a chart

Starter task - describe each word

Sales Revenue

Expenses

Profit

Spreadsheet

Formula

Chart

1

3

5

2

4

6

Activity 1 - setup your spreadsheet

  • Open Microsoft Excel on your computer.
  • You are now going to begin listing some items from a shop website such as Amazon.
  • Total up the cost of all of these items added together.

Charts

  • A chart is a visual representation of data. Spreadsheets are often used simply for the charting functionalities built in to them.

  • There are several types of charts available in Microsoft Excel. 

  • What type of chart is displayed on the right?

Demo

Activity 2 - add your chart

  • We will now look at how to create different charts using Microsoft Excel using the Sales and Expenses figures from the previous task.
  • Remember:
    • Label your chart (heading, axis, legend)
    • Move to a new worksheet
    • Select non-adjacent cells
    • Use data labels

Activity 3 - Top Tips

With a partner come up with 3 Top Tips on how to create a chart or what should be included.

Activity 4 - a shopping list

The following table is for a shopping list. It does not have completed information. The maximum budget is £25. Using a website such as tesco.com, add and complete the information in a spreadsheet:

Item Quantity Individual price Total price
Oranges 2
Cooking Apples 4
Sausages 1
Multipack crisps 2
Milk (2 pints) 1
Burgers 4

Once you have done that, create a pie chart to show how the budget is distributed.

Presentation Overview
Close
JB
Charts
© 2020 - 2024 J Balfour
17:07 | 23-05-2024
Join Live Session
Start Remote
Save Progress
Slideshow Outline
Presenter Mode
Widget Screen
Canvas Controls
Random Selector
Timer
Volume Meter
Binary Converter
Python Editor
Show Knox 90
Provide Feedback
Help
!
Keywords
    DragonDocs Management
    Random selector
    Sections
      Binary conversion
      Denary to binary conversion
      Binary to denary conversion
      Feedback 👍
      Accessibility

      Apply a filter:

      ×
      All slideshow files