!
Using numerical data in a spreadsheet create some charts to be able to analyse the data visually.
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
Sales Revenue
Expenses
Profit
Spreadsheet
Formula
Chart
1
3
5
2
4
6
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
With a partner come up with 3 Top Tips on how to create a chart or what should be included.
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.
The following are key shortcuts for using DragonSlides and reveal.js.
| Key combination | Action |
|---|---|
| →, PAGE DOWN, SPACE | Next slide |
| ←, PAGE UP | Previous slide |
| SHIFT + → | Last Slide |
| SHIFT + ← | First slide |
| B | Whiteboard |
| W | Widget Board/White Screen |
| C | Toggle Notes Canvas |
| DEL | Clears Whiteboard/Notes Canvas |
| S | Show Presenter Mode |
| SHIFT + D | Toggle Dark Mode |
| H | Goes to the Home Slide |
| META + P | Show Print options window |
In order to use the 'Start Remote' feature, you'll need to download JB Slide Controls from the Apple App Store. Once you have this you'll be able to control the slides using the app from you Apple Watch.
DragonSlides and jamiebalfour.scot are copyright © Jamie B Balfour 2017 - 2024, 2010 - 2024. Content is copyright © Jamie B Balfour