Calculating
Residuals
This
PowerPoint presentation explains the method of calculating
residuals to determine the performance of pupils in
mathematics compared to their performance in the other
subjects they have studied.
VLookup
and Lines of Best Fit
By calculating the equation of the line of best fit it is
possible to measure the progress of pupils and to use it to
predict the performance of a later cohort.
Click
here to view or
download the full instructions
Click
here to
view or download the associated spreadsheet
Using
the Filter Option in Excel
The
Filter option allows you to look quickly through a large set
of data for certain pieces of information.
For example you might want to look at all students who
achieved a grade C or all those students who are in a certain
teaching group.
In
order to set up the filters all you do is highlight all the
columns you want to have a filter on including the row above,
then click on Data, Filter and then AutoFilter.
Click
here
to view or
download the full instructions
Click
here
to
view or download the associated spreadsheet
Using Pivot Tables in Excel
Pivot
tables allow you to check the progress made by a cohort for
example from Key Stage 3 to GCSE.
It allows you to track progress, look at the
performance of previous cohorts and to therefore project
future outcomes.
Click
here
to view or
download the full instructions
Click
here
to
view or download the associated spreadsheet
Using VLOOKUP function
Lookup
tables are used in a spreadsheet to perform such tasks as
assigning a grade to a raw exam mark. For example you
can set up a spreadsheet so that each teacher can enter their
Year 11 mock results as a percentage, with or without the
coursework, and the computer will automatically insert the
grade. In fact it could record C1 for a high C, C2 for a
middle C and C3 for a low C so that appropriate targets can be
set for the pupils.
Click
here to view or download the full instructions
Click
here to
view or download the associated spreadsheet
Analysing
Examination Data using Excel
Click
here
to download the instructions
Click
here
to download the spreadsheet
The following documents are user guides that can either be used by teachers in order to familiarise themselves with how to use some of the facilities of Excel, alternatively they could be given to students to work through with support given by teachers. They were originally written for a series of twilight sessions that I ran for parents.
Drawing a range of
Statistical Graphs and Charts using Excel -
Click
here to download the file
Using Formulas in Excel
-
Click
here to download the file
Click
here to download a Functions Checklist
Producing a Shopping List
using Excel - this covers formatting cells and using simple
formulae -
Click
here
to download the file
Looking at a range of other
uses of Excel -
Click
here
to download the file
Click
here to download the spreadsheet
Click
here to download the answer sheet
Additional worksheets can be downloaded from Mark McCourt's website by Clicking Here