Transcript Unit 3 – Data Handling

Unit 3 – Data Handling
AO4 –Analysis of Data
Summer term 2010
D Garey
Make a Test Plan
• Pass level –you need evidence of 1 test to
see if this spreadsheet will work (think
what formulae do you want to calculate,
any linked cells, conditional formatting etc)
• For merit and distinction you will need a
test plan
Summer term 2010
D Garey
Format the Sheet
• Ensure all titles, labels, headers/footers
are clear
• Format the cells according to the data
collected
• You could use conditional formatting to
see an overview of different answers
• conditional formatting tutorial
Summer term 2010
D Garey
Other Points to include:
• Macros
• Absolute cell referencing absolute cell
referencing
• Linking cells across worksheets/paste
special
• Filter/autofilter
• Hide/unhide
• Formatting styles
Summer term 2010
D Garey
Formulae
•
•
•
•
•
•
•
For each question you must calculate:
SUM
AVERAGE (mean, median, mode)
MIN
MAX
COUNT
COUNTIF*
Summer term 2010
D Garey
More complex formulae
•
•
•
•
•
•
•
Percentages
Brackets
2 step calculations
Standard deviation
T test, Correlations, Chi Squared *
* please ask!!!!
advanced stats in Excel
Summer term 2010
D Garey
Remember!!!!!
• Control and stupid button to show
formulae in screen shots
• You should justify why you’ve used all of
these operations
• Do not start discussing your results here!!!!
Summer term 2010
D Garey