For Merit standard, learners will provide evidence of designing and developing a data
model for a specified scenario that meets client requirements. They will justify how the
decisions made and processes applied throughout the design, development and testing
stages impact on the effectiveness of the final solution.
Learners will produce detailed designs for a data model that will include a range of
alternative solutions. Learners will analyse the alternatives and their impact, selecting
the alternative(s) that produce the best solution. Learners must develop their final
design using a range of advanced spreadsheet features and functions. They will carry
out testing and seek user feedback, which will be used to refine and improve their data
model. Learners will analyse the final design and provide reasoned justification of how it
fulfils its purpose and meets client requirements.
For Pass standard, learners will provide evidence of designing and developing a data
model for a specified scenario that meets client requirements, although some small
issues may persist. They will explain how the decisions made and processes applied
throughout the design, development and testing stages impact on the effectiveness
of the final solution.
Learners will produce designs for a data model that will include a range of alternative
solutions. Learners will consider the alternatives and their impact, selecting the
alternative(s) that produce the best solution. Learners must develop their final design
using a range of spreadsheet functions, carry out testing and seek user feedback. The
results of testing and user feedback can be used to refine and improve their data model.
Learners must review the extent to which the final design meets client requirements,
although the review may be unbalanced.
Links to other units This unit links to:
•
Unit 1: Information Technology Systems – Strategy, Management and
Infrastructure
•
Unit 2: Creating Systems to Manage Information
•
Unit 6: Website Development
•
Unit 11: Cyber Security and Incident Management
•
Unit 12: IT Technical Support and Management
•
Unit 14: Customising and Integrating Applications
•
Unit 15: Cloud Storage and Collaboration Tools
•
Unit 20: Business Process Modelling Tools.