70 likes | 90 Views
Develop a comprehensive test plan for an Excel spreadsheet, ensuring formulas, formatting, and advanced features are functional. Include analysis criteria for pass, merit, and distinction levels. Implement macros, cell linking, and statistical calculations.
E N D
Unit 3 – Data Handling AO4 –Analysis of Data 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 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 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 D Garey
Formulae • For each question you must calculate: • SUM • AVERAGE (mean, median, mode) • MIN • MAX • COUNT • COUNTIF* D Garey
More complex formulae • Percentages • Brackets • 2 step calculations • Standard deviation • T test, Correlations, Chi Squared * • * please ask!!!! • advanced stats in Excel 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!!!! D Garey