Computer and IT skills. Contents Master File ICT, Spreadsheets and Data Hanlding, Key Stage 3

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 KS3

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. It continues the
work already covered in the Key Stage 2 book
dealing with and developing more difficult material. The diagrams are large so that the pupils can
easily compare them with what is on the computer screen.
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. Examples are based on everyday situations. 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 164 0
PRICE £20

VIEW
SAMPLE
PAGES
1 2 3

CONTENTS- PupilS' Resources/Worksheets

A Spreadsheet

Mathematical Operators

Out To Lunch

The Quick Snack Bar

Exam Results

Exam Results Sorted

Table Tennis Matches

Table Tennis Matches Points Table

Gifts Just For You

Parts For Boats

Phone Book

Phone Book Data Form

Phone Book Sorting

The Euro Exchange

Imperial to Metric Units

At The Funfair

Entering Data

Checking the Stock

Jane's Budget

The Fashion Workshop

The Big Screen Experience

Rent a DVD

Using A One-Variable Data Table In Columns

Using A One-Variable Data Table In Rows

Using A Two-Variable Data Table

What If Scenarios With DVDs

More Scenarios With DVDs

The Estate Agent

The Estate Agent Pivot Table

Gifts Just For You Again

Parts For Boats Again

Student Loan

Buying A Flat

Sports Weekend

The Estate Agent Column Chart

The Estate Agent Line Chart

The Estate Agent Pie Chart

Review Papers 1 to 11, More Practice and Examples

CONTENTS- Teachers' Notes/Resources

About Spreadsheets and Databases

Spreadsheets and Cells

Basic Rules of Arithmetic in a Spreadsheet

Entering Formulae into a Spreadsheet

Practice in Using Basic Skills in a Spreadsheet

Formatting

Ordering and Using Arithmetical Functions

Using Paste Special

Using Subtotals Function

Managing and Using a Database

Changing Units

Use of the IF Function

Using a Spreadsheet to Analyse the Running of a Business

Using Goal Seek

One-Variable Data Tables

Two-Variable Data Tables

What IF Scenarios

Pivot Tables

PMT Function

Charts

Column Charts

Bar Charts

Pie Charts

Line Charts

Basic Skills - Review Papers 1 and 2

Using a Spreadsheet - Review Paper 3

Using a Database - Review Paper 4

Production Costs - Review Paper 5

Mortgage Repayments - Review Paper 6

2-Variable Table and Mortgage Repayments - Review Paper 7

Goal Seek - Review Paper 8

IF Function - Review Paper 9

Different Kinds of Charts - Review Paper 10

Break Even Analysis - Review Paper 11

APPENDIX

Shape of Pointer in Excel

Tools on Standard Bar

Tools on Formatting Bars

ANSWERS

View Sample Pages 1 2 3

Information Technology skills for Key Stage 3. Detailed contents of the skills
needed in creating and usins spreading and handling data at this level.
From Master File IC Skills, Spreadsheets and Hanling Data, Key Stage 3 for
11-14 year olds.