SPREADSHEET
MODELLING Unit 42
, Unit 42
Contents
Explain how spreadsheets can be used to solve complex problems – P1..............................................2
Manipulating data..............................................................................................................................2
Presentation to requirements...........................................................................................................3
Supporting decision making...............................................................................................................4
Tools to Analyse Data - D1.....................................................................................................................5
Examples of how Ria View Theatre could model their fnances........................................................5
Interpretation methods.....................................................................................................................5
Comparison of totals.........................................................................................................................5
Trend Analysis....................................................................................................................................5
How Can Information be Presented?.................................................................................................5
Colour Scheme...................................................................................................................................5
Graphs and Charts.............................................................................................................................5
Creating a complex spread sheet for ria view theatre – P2 P3 M1........................................................6
Multiple Work Sheets with Links.......................................................................................................6
Complex formula...............................................................................................................................8
Large data sets and data sorting........................................................................................................8
Cells linkage.....................................................................................................................................10
List boxes – Data validation.............................................................................................................11
Error trapping..................................................................................................................................11
VLookup...........................................................................................................................................11
IF Functions......................................................................................................................................12
Conditional Formatng....................................................................................................................12
Freeze Pane.....................................................................................................................................12
Merge and Center............................................................................................................................13
Colour Scheme.................................................................................................................................13
Cell Format......................................................................................................................................14
Analysis and Interpretation of Data (P4, M2)......................................................................................15
Graphs and Charts...........................................................................................................................16
1
MODELLING Unit 42
, Unit 42
Contents
Explain how spreadsheets can be used to solve complex problems – P1..............................................2
Manipulating data..............................................................................................................................2
Presentation to requirements...........................................................................................................3
Supporting decision making...............................................................................................................4
Tools to Analyse Data - D1.....................................................................................................................5
Examples of how Ria View Theatre could model their fnances........................................................5
Interpretation methods.....................................................................................................................5
Comparison of totals.........................................................................................................................5
Trend Analysis....................................................................................................................................5
How Can Information be Presented?.................................................................................................5
Colour Scheme...................................................................................................................................5
Graphs and Charts.............................................................................................................................5
Creating a complex spread sheet for ria view theatre – P2 P3 M1........................................................6
Multiple Work Sheets with Links.......................................................................................................6
Complex formula...............................................................................................................................8
Large data sets and data sorting........................................................................................................8
Cells linkage.....................................................................................................................................10
List boxes – Data validation.............................................................................................................11
Error trapping..................................................................................................................................11
VLookup...........................................................................................................................................11
IF Functions......................................................................................................................................12
Conditional Formatng....................................................................................................................12
Freeze Pane.....................................................................................................................................12
Merge and Center............................................................................................................................13
Colour Scheme.................................................................................................................................13
Cell Format......................................................................................................................................14
Analysis and Interpretation of Data (P4, M2)......................................................................................15
Graphs and Charts...........................................................................................................................16
1
