Cambridge ICT Certificate – Spreadsheets

SPREADSHEETS FOR A PURPOSE

In this module, learners use spreadsheet software to create a working spreadsheet with a clear purpose. Learners work methodically through a design and development process, being able to test, correct and modify the spreadsheet as they progress. They are able to create a final spreadsheet which suits its purpose and is presented in an appropriate way for its audience. They begin to understand how to evaluate their work, and can assess how well their spreadsheet meets its objectives.

For more information CLICK HERE.

CERTIFICATION

Learners should be able to design and create a working spreadsheet to suit a problem scenario. They should be able to test their spreadsheet to make sure that it works. In addition, learners should be able to modify their design further, to make it more user-friendly and be able to present the findings of the spreadsheet in an appropriate way. Learners should also be able to evaluate their work in relation to how well it achieves its objectives.

At the end of each module, students will be assessed by way of a test to show that they can demonstrate each of the learning objectives with no additional help from their teacher or their peers.

• Cambridge provides question papers and resource files for Cambridge ICT Starters.

At the end of each assessment test, the teacher marks the question papers and completes a record of assessment (Learning Objectives Record Sheet) for each learner. Samples of learners’ work are sent to Cambridge for external moderation. The sample will include the question papers completed by the learners, the required evidence of learners’ work and the Learning Objectives Record Sheet.

Learners will receive a Pass or Merit grade in each assessment test. A learner’s overall grade will be a combination of the results of all modules.

To achieve a Pass in a module, learners must meet all the Pass criteria specified on the Learning Objectives Record Sheet. To achieve a Merit in a module, learners must achieve all the Pass and Merit criteria within that module.

Cambridge will award a Merit grade for each level of Cambridge ICT Starters where the learner has achieved Merit grades in the majority of modules taken at each stage or level.

TARGET GROUP

Cambridge ICT modules are predominantly aimed at learners aged between 10 to 15 years. The qualifications are suitable for those in secondary education.

LEARNING OUTCOMES

• Design a spreadsheet for a particular purpose.
• Create the spreadsheet.
• Test the spreadsheet.
• Modify the spreadsheet to make it suitable for its purpose.
• Evaluate the spreadsheet.