Learning Through Innovation (LTI) Project Website

Learning Through Innovation (LTI) Website

Resources
Excel
Introduction
Resources
Websites
Examples by project schools


Introduction:
Excel helps you get the most out of your data. It features powerful tools that enable you to capture, analyse and share information more effectively. Simon Botton from Crossways Junior School has found it useful in creating interactive workbooks that can be displayed on your interactive whiteboards:
"Creating excel interactive workbooks is very simple and uses the 'if' command to provide instant feedback. For example to convert between grams and kilograms the following could be used: =IF(B3=A3*1000,A3=B3/1000) B3 (in this example) is the cell where the child types the answer, A3 (in this example) is the cell where the value to be converted is placed. Excel will automatically put true or false in the cell where this type of formula is written. The examples make things a bit clearer. For a closed answer, type something like: =IF(D3=400,"Correct") Where D3 (in this example) is the cell where the answer is typed and 400 is the answer (in this example). Such spreadsheets work really well for time or conversion activities. However, it is worth locking the formula cells to stop children accidentally changing them. Using a colour fill gets rid of the gridlines and helps make the sheet look less 'clinical'."



Top
Resources:




Top
Websites:
Microsoft:
Formatting Worksheets
Creating Charts
Shapes, Lines, Freeforms and Other Drawing Objects


Top
Examples from Project Schools:
Submitted by Crossways Junior School (don't forget to use the tabs at the bottom to look at the different worksheets in the spreadsheet):
Converting Between Metric Units			Sequence Machine (Teacher Tool) T1 Unit 12
Converting Currency (NNS 6 Unit 4 Day 3) - Pupil Version			Square Number Detector (T1 Unit 12)
Converting Currency (NNS 6 Unit 4 Day 3 - Teachers Version			Times Tables
Converting Metric Units - Teacher Version			Unit 10 Time Resource - Children
Metre to Centimetre			Unit 10 Timetable Resource
Ordering Comparing Large Numbers
Top

Welcome to the Learning & School Effectiveness Service Website

For Pupils, Parents, Teachers and Visitors

Resources

Excel

Introduction:

Resources:

Websites:

Examples from Project Schools:

Submitted by Crossways Junior School (don't forget to use the tabs at the bottom to look at the different worksheets in the spreadsheet):