Software Skills: Spreadsheet
Level: 2
Credit Value: 4
About this course: This course forms part of the Level 2 Diploma in Progression awarded by Open College Network South East England.
Learning outcomes:
At the end of the course, students will:
1. Understand the formatting options for data in a spreadsheet (currency, percentage, decimal places, date/time).
2. Be able to use basic formulae, including add, subtract, multiply and divide in a spreadsheet.
3. Be able to use basic functions in a spreadsheet (SUM, AVERAGE, MAX, MIN, COUNT, LEN).
4. Understand the reason for using multiple worksheets, sorting and filtering.
5. Understand the purpose of graphs and charts (pie chart, line graph, bar/column chart, scattergraph).
6. Understand the formatting of graphs/charts (title, axis labels, colour, legend)