|
Domino
Books (Wales) Ltd
P O Box 32 Swansea United Kingdom SA1 4QN Tel. 01792 459378 Fax. 01792 466337 International Tel. +44 (0) 1792 459378 email: sales@dominobooks.co.uk |
 |
|
 |
|
|
||||||
|
|
|
||||||
|
LITERACY | |
NUMERACY | |||||
| View Shopping Basket | ||||||||
 |
SAMPLE PAGE KS3 ICT SPREADSHEETS AND DATA HANDLING |
|
Sports
Weekend continued
|
|
| A group
of students attended a sports weekend at a leisure centre. This spreadsheet shows the favourite sport for each student. Create a Pie Chart using the Chart Wizard. |
|
 |
|
|
Click on A1 and drag to B7 to select the cells to be charted. |
| Click on the Chart Wizard | |
| Step 1 Click on Pie Chart in the menu in the box. Leave the first Chart sub type selected Click Next |
|
| Step 2 Click Next |
|
| Step 3 Title box, type SPORTS in title box. Click legend tab and decide where to put the legend box. Click Next. |
|
| Step 4 Leave Chart as Object in Sheet 1. Click Finish. |
|
| Select Chart>Chart
options. Choose Data Labels tab and selcet show label and percent in dialogue box. |
|
| Save and print your work. | |
|
|
|
Copyright
© Domino Books (Wales) Ltd. All Rights Reserved.
|
|
| ICT
skills. Creation of a Pie Chart using the Chart Wizard based on data for a Sports Weekend. From Master File ICT, Spreadsheets and Data Handling, Key Stage 3 for 11-14 year olds. |