CMP-5059-1 – Spreadsheets 2

This learning guide prepares learners to further develop their ability to use the spreadsheet program of their choice. The learners learn to modify existing worksheets, to prepare models, to use graphic commands and to print their work using more complex layouts. The approach focuses on the underlying logic common to most spreadsheet software and the activities support learners in developing spreadsheet skills with their software.

Duration: 25 hours (1 unit)

Content:

Each chapter includes a description of concepts, an explanation of the associated commands, where they can be found and how they work, practice exercises, a suggested work method, a review activity and a self-check quiz.

• Introduction and basic concepts;

• Editing and sorting worksheet data;

• Copying data and creating a model;

• Charts;

• Conclusion and review.

Evaluation:

Course passing grade: 60%

Examination passing grade (local exam under supervision): 60%

The software used for the final exam should be the same that was used by the learner during the course. Otherwise a period of time for the learner to get used to the exam software should be granted.