Spreadsheets and Data Handling Key Stage 2 Master File

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

	HOME	FIRST STEPS	MASTER FILES
	DYLAN THOMAS CORNER	ACTIVITY PACKS	HERITAGE/TOURIST BOOKS
	LITERACY	NUMERACY
*View Shopping Basket*

MASTER FILE KS2

ICT SKILLS
SPREADSHEETS AND HANDLING DATA

This book follows the guidelines of the National Curriculum. It is produced with the specialist and
non-specialist teacher in mind. The diagrams are
large so that the pupils can easily compare them with what is on the computer screen.
The work is carefully graduated from very simple material to much harder work.
There are very full answers and diagrams at the end of the teachers' notes.
The teachers' notes are planned to provide strategies for teaching the work. The book is an ideas bank and many of the exercises can be used in different ways.

A4 with 97 pages. PHOTOCOPIABLE

ISBN 1 85772 165 9
PRICE £20

VIEW SAMPLE
PAGES
1 2 3

TO BUY

CONTENTS- PupilS' Resources/Worksheets

A Spreadsheet; Cells in a Spreadsheet

Cell Addresses

Borders

Pets

Computers in Your School

Entering Data in a Spreadsheet

The Address Book

Records Cards/Database

The Race

Sports

Addition, Subtraction, Multiplication and Division in a Spreadsheet

Click to enter Formulae

Using the Autosum Button

Books from the Library

Using Rows in a Spreadsheet

The Queen of Hearts

The Sandwich Kiosk

Using Information in a Spreadsheet

Raffle Tickets

Money Collected

Multiplication Tables

Copying and Pasting Text

Moving Text

Deleting and Correcting Text

Inserting Rows and Columns

Using the Increase and Decrease Buttons

Changing Inches to Centimetres

Functions - Maximum, Minimum and Average

Pocket Money

Bar Chart

The Dragon Maker

Perimeters and Areas

Bar Charts

The Garden Fence

Sunny Hours Bar Chart

Favourite Crisps

Making Cakes

Mini-Beasts Habitats (Spreadsheet, Bar and Pie Charts)

Bicycle Sales (Max/Min/Average and Bar Charts); Mini Marathon

Temperatures

Sports Shop

Imperial to Metric Units

The Euro

Review Papers 1 to 7

CONTENTS- Teachers' Notes/Resources

The Excel Screen

Spreadsheets

Cells and Entering Data

Databases

Using Information in a Spreadsheet

Basic Rules of Arithmetic in a Spreadsheet

Entering Formulae

Multiplication Tables

Copying

Cutting

Pasting

Moving Text

Deleting and Correcting Text

Decimal Buttons

Changing Units

Functions

Spreadsheets and Charts

Perimeters and Areas

Calendar Function

Pie Charts

Different Ways of Representing Data

Formulating a Bill

Changing Units

APPENDIX

Shape of Pointer in Excel;

Tools on Standard and Formatting Bars

ANSWERS

View Sample Pages 1 2 3

ICT Skills, Key Stage 2. Calculating and using Spreadsheets.
Detailed contents of Master File, IC Skills, Spreadsheets and Data Handling,
Key Stage 2 for 7 - 11 year olds.