5N1977 Spreadsheet Methods QQI Level 5
Please note that these documents have not been updated since 2015. The documents were created originally for Monaghan Institute students and now have been made available for all to use.
Rynagh Learning OutcomesLearning Outcome 1: Investigate Common Uses for Spreadsheets
Learning Outcome 2: Explore Key Spreadsheet Elements
Learning Outcome 3: Common Spreadsheet Usability Features
Learning Outcome 4: Spreadsheet Design Features
Learning Outcome 5: Macros
Learning Outcome 6: Explore Printing Methods
Learning Outcome 7: Features and Functions
Learning Outcome 8: Generate Spreadsheet Graphs
Learning Outcome 9: Produce a Spreadsheet with Minimal Supervision
Learning Outcome 10: Editing and Amending for Purpose
|
Useful Websites
Excel is Fun a YouTube Channel by Mike Girvin, an excellent set of comprehensive videos with an endless list of topics.
GCF Learn Free excellent learning resources organised by software version. Microsoft Excel Help Center published by the creators of the software, the language on this website can be quite technical, but the information is comprehensive. Exam Preparation Past Papers2015 Examination with Solution and Marks Scheme
2014 Examination with Solution and Marks Scheme
2013 Examination with Solution and Marks Scheme
|
Learning Outcomes of Level 5 Spreadsheet Methods
Learners will be able to:
1. Investigate a range of common uses for spreadsheets.
2. Explore key spreadsheet elements including cells, cell references, numeric, alpha, and alphanumeric data, formulae, functions, graphs and macros.
3. Demonstrate common spreadsheet usability features to include use of toolbars, window management, sorting, and filtering.
4. Use spreadsheet design features involving data and cell formatting techniques which enhance understanding and legibility.
5. Automate routine multi-step tasks through the creation, execution, and management of simple macros.
6. Print complete or partial sections of a spreadsheet, formatted fit for presentation.
7. Use advanced spreadsheet features including absolute and relative cell references, conditional IF statements, statistical, financial, and date and time functions.
8. Generate a variety of types of graphs, with appropriate titles and labels, from Spreadsheet data.
9. Produce a spreadsheet, with minimal supervision, that meets a simple design specification and is fit for purpose.
10. Demonstrate personal initiative and resourcefulness in editing and amending spreadsheets to ensure they are fit for purpose.
1. Investigate a range of common uses for spreadsheets.
2. Explore key spreadsheet elements including cells, cell references, numeric, alpha, and alphanumeric data, formulae, functions, graphs and macros.
3. Demonstrate common spreadsheet usability features to include use of toolbars, window management, sorting, and filtering.
4. Use spreadsheet design features involving data and cell formatting techniques which enhance understanding and legibility.
5. Automate routine multi-step tasks through the creation, execution, and management of simple macros.
6. Print complete or partial sections of a spreadsheet, formatted fit for presentation.
7. Use advanced spreadsheet features including absolute and relative cell references, conditional IF statements, statistical, financial, and date and time functions.
8. Generate a variety of types of graphs, with appropriate titles and labels, from Spreadsheet data.
9. Produce a spreadsheet, with minimal supervision, that meets a simple design specification and is fit for purpose.
10. Demonstrate personal initiative and resourcefulness in editing and amending spreadsheets to ensure they are fit for purpose.