Overview
Qualification Grading Type
Ungraded
Unit Learning Outcomes
1.
Know how to design and store a spreadsheet.
Assessment Criteria
-
1.1.
Design a spreadsheet appropriate to a user's requirements.
-
1.2.
Create and store the spreadsheet.
-
1.3.
Evaluate the spreadsheet in terms of meeting the user's needs.
2.
Be able to retrieve and modify an existing spreadsheet.
Assessment Criteria
-
2.1.
Modify the spreadsheet design/content in response to user feedback.
3.
Be able to print a spreadsheet.
Assessment Criteria
-
3.1.
Print or display whole or part spreadsheets/formulae with a variety of print layout options.
4.
Be able to enhance user readability
Assessment Criteria
-
4.1.
Use suitable formatting options for displaying text and numeric values.
-
4.2.
Define and use conditional formatting to limit input error and give suitable messages to users.
5.
Be able to use spreadsheet functions.
Assessment Criteria
-
5.1.
Develop a spreadsheet solution using a range of mathematical functions.
6.
Be able to use graphical facilities.
Assessment Criteria
-
6.1.
Use an appropriate graph type.
-
6.2.
Draw pie, bar, line graphs with appropriate labels attached.
7.
Know how to use additional features within the spreadsheet environment
Assessment Criteria
-
7.1.
Use advanced sorting, protecting and filtering facilities on a spreadsheet.
-
7.2.
Analyse data using pivot tables.