|
Saving
Files to Prevent Changes
This flash viewlet
demonstrates how to save files so that they cannot
be accidentally changed. This technique is a simple but effective way
of giving access to documents, exercises and assi…
|
|
Adding
Comments to Microsoft Excel spreadsheets
This flash viewlet
demonstrates how to add comments to Microsoft Excel
spreadsheets. Comments can be a good way of providing additional
information or explanations to documents.
Please no…
|
|
Adding
interactive graphs to Microsoft Excel spreadsheets
This flash viewlet
demonstrates how to create an interactive graph
which builds as data is entered into a table in Microsoft Excel. Please
note that this file requires the Macromedia Fla…
|
|
Drop-down
list boxes for Microsoft Excel
This flash viewlet
demonstrates how to add drop down boxes (combo
boxes) to a Microsoft Excel spreadsheet to create an interactive quiz.
Please note that this file requires the Macromedia…
|
|
Scoring
a quiz in Microsoft Excel
Following on from
the first how to, Drop-down list boxes for Microsoft
Excel (see related resources), this viewlet demonstrates adding scoring
functionality to your spreadsheet to create a s…
|
|
Office
Tutorials
An indispensable
bookmark for staff ICT development practitioners,
these excellent handout-based tutorials covering the whole gamut of MS
Office applications and extending back to earlier ve…
|
|
Sliding
& Toppling Interactive Excel Spreadsheet
This case study,
available on the Peter Symonds College website, is an
in-depth explanation of the Excel spreadsheet developed by David Lynch
on Sliding and Toppling. This resource is avail…
|
|
Formatting
a Microsoft Excel Spreadsheet
The default Excel
look is bland and can pose some access problems.
Kirsty McNaught’s extremely clear set of sample Excel sheets come with
instructions on adapting colours, borders and the a…
|
|
Understanding
& Working with Graphs in Microsoft Excel
Clear step-by-step
tutorial of how to create and manipulate a graph by
using the chart wizard function in the Excel program. Images of
commands and functions are provided and the final shee…
|
|
Geometric
progression: Interactive modelling graph
Use the interactive
Excel spreadsheet to model the graphical and
numerical representation of the geometric progression by altering the
first term and the common ratio.
|
|
AskIT
for MS Office
These trouble
shooting tips from the University of Queensland provide easy to follow
assistance with MS packages.
|
|
How
to create an interactive Excel demo of power transmission
A guide to creating
a transformer simulator using Excel. This includes hints and tips on
creating similar resources.
|
|
5
minute tips for software
This is a short
collection of tips on using MS applications.
|
|
Qwik
& Dirty Help with MS Excel
Practical ‘how to’
solutions for users of Microsoft Excel. Tutorials
take you through multi-step tasks in a sequence of screens. There is
also an option to request tasks not already avai…
|
|
Using
Formulae in Microsoft Excel
This video tutorial
demonstrates how to use formulae in Excel. This
tutorial has been created by Alistair McNaught of the Ferl team and
featured on the 16-19 Conference 2002 delegate CD.
…
|
|
Creating
Graphs in Microsoft Excel
This video tutorial
demonstrates how to use create graphs in Excel.
This tutorial has been created by Alistair McNaught of the Ferl team
and featured on the 16-19 Conference 2002 delegate C…
|
|
Using
Scroll Bars and Drop Downs in MS Excel
This video tutorial
demonstrates how to create scroll bars in Excel.
This tutorial has been created by Alistair McNaught of the Ferl team
and featured on the 16-19 Conference 2002 delegate …
|
|
Simple
Formatting in Microsoft Excel
This video tutorial
has been designed to develop initial skills for new
users in Excel. This tutorial has been created by Alistair McNaught of
the Ferl team and featured on the 16-19 Confer…
|
|
Inserting
Comments and Using the Copy Function in MS Excel
This video tutorial
has been designed to develop initial skills for new
users in Excel. This tutorial has been created by Alistair McNaught of
the Ferl team and featured on the 16-19 Confer…
|
|
Conditional
Formatting in Microsoft Excel
This video tutorial
has been designed to develop initial skills for new
users in Excel. This tutorial has been created by Alistair McNaught of
the Ferl team and featured on the 16-19 Confer…
|
|
Validating
Data in Microsoft Excel
This video tutorial
has been designed to develop initial skills for new
users in Excel. This tutorial has been created by Alistair McNaught of
the Ferl team and featured on the 16-19 Confer…
|
|
Protecting
Spreadsheets in Microsoft Excel
This video tutorial
has been designed to develop initial skills for new
users in Excel. This tutorial enables users to create ‘read-only’ type
cells. This tutorial has been created by Alista…
|
|
Creating
Interactive Lists with Microsoft Excel
This MS PowerPoint
presentation is an interactive tutorial explaining
how to use combo boxes, lookup and index functions to make interactive
materials with Excel.
|
|
The
Calculator: Basic calculator using control buttons on Excel
This interactive
spreadsheet enables users to calculate simple
addition, subtraction, multiplication and division calculations using
spinner buttons. The resource is designed to be used wit…
|
|
Using
Excel Spreadsheets to model Equilibria within A Level Chemistry
This article
describes how John Chamberlain of St Dominics Sixth Form
College used Excel spreadsheets to model all six different examples
relating to equilibria in A level Chemistry.
|
|
Generating
Random Numbers Using Macros in Microsoft Excel
This Excel
spreadsheet has been built as an example of how random
numbers can be generated using Macros. The spreadsheet also enables the
users to explore how the spreadsheet has been writt…
|
|
Using
Excel Worksheets to Aid Learning in Decision and Discrete Mathematics
Debi Hand from Peter
Symonds College focuses on the use of Excel
worksheets to aid the learning process in AS Decision and Discrete
Mathematics. In some cases this means a simple use of a sh…
|
|
Setting
Random Numbers using a Macro in Excel
When generating
random numbers in Excel, the values are changed every
time return is pressed. This article explains how to use Macros in
Excel to produce the random numbers and then use them…
|
|
Simulation
Sheet in Microsoft Excel
This interactive
resource has been created in Excel as a simulation
tool to assist students answering sample exam questions in Decision and
Discrete Mathematics.
|
|
Monitoring
Advanced Level Student Progress with an MS Excel Spreadsheet
The article
describes the use of spreadsheets as a management tool to
record and monitor progress, outcomes and added value for students on
Advanced Level programmes. GCSE qualifications are…
|
|
Monitoring
A Level Student Progress with a Spreadsheet
The downloadable
Excel sheet is part of an article which describes the
use of spreadsheets as a management tool to record and monitor
progress, outcomes and added value for students on Advan…
|
|
Microsoft
Excel Made Simple and Easy
Mark Hitch takes us
through a few simple functions to convince novice
users that Microsoft Excel is much more than a table in which to write
students names and test scores.
Screenshots ar…
|
|
Creating
Multiple Choice Questions in Microsoft Excel
This how to contains
both an example of the use of multiple choice
questions in Microsoft Excel and step-by-step instructions for creating
the example.
|
|
Using
Excel forms to produce an interactive exercise
This lesson plan
demonstrates how Excel forms can produce interactive exercises to be
used as teaching resources.
|
|
Using
Excel for equilibrium reactions
Aimed to help
students interpret graphical representations in a dynamic
way, this chemistry lesson plan, containing downloadable Excel
spreadsheet, reinforces and integrates the concepts enc…
|
|
Animating
Formula with Variable Inputs on MS Excel Slider Bars
This is an excel
spreadsheet demonstrating how slider bars can be used to animate
formula.
|
|
Adding
Scroll Bars to a Spreadsheet
A step-by-step guide
to creating an interactive graph in MS Excel,
controlled by scroll bars. This can be used to see the effect of
changing a variable. Examples would include plotting traje…
|
|
Using
Spreadsheets in the Chemistry Lab for A Level and Advanced GNVQ Science
Steve Lewis of
Shrewsbury Sixth Form College highlights the benefits -
to both tutor and students – of using a Microsoft Excel spreadsheet as
a calculation tool for experiments.
|
|
Introduction
to Spreadsheets Using Microsoft Excel
This is a staff
development ‘how to’ which provides beginners with an
introduction to spreadsheets. It should be used as an activity rather
than a hand-out.
|
|
Importing
Spreadsheets and Graphs from MS Excel into MS Word.
This is a staff
development ‘how to’ which provides a step by step guide on importing
spreadsheets and graphs into Word.
|
|
Importing
Spreadsheets and Graphs into Microsoft Word
This is a staff
development booklet which provides information on how to use
spreadsheets and graphs in Word.
|
|
How
to: An Introduction to Spreadsheets
This is a staff
development ‘how to’ which introduces you to spreadsheets using Excel.
|
|
How
to: Common Formulae using Excel
This is a staff
development article.
|
|
Using
Excel as a Tool for Teaching Advanced Mathematics
Most computer users
are familiar with at least the basic functions of
Microsoft’s “Excel” spreadsheet program. However it is not
generally
appreciated that Excel can be employed for a variet…
|
|
Common
Formulae in Microsoft Excel
This downloadable
how to provides you with information and examples of common formulae in
Excel.
|
|
How
Much Do You Know About Spreadsheets?
This sites contains
a number of quizzes on the use of spreadsheets.
There are a number of quizzes which test formulae, the use of and
structure of spreadsheets.
|