Course Code:02.04
Course Subject:Module 4 Spreadsheets
Course Title:ECDL (5v0) Module 4 Spreadsheets
Aims:The student shall understand the concept of spreadsheets and be able to demonstrate their ability to use a spreadsheet application on a computer.
Introduction:On completion of the course, the student shall be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet of limited scope ready for distribution. He or she shall also be able to generate and apply standard mathematical and logical formulas using standard formulas and functions. The student shall demonstrate competence in creating and formatting graphs/charts.
  

Objectives

The learner will be able to:

Assessment Criteria

The learner has achieved this objective because he/she can:

1. Use the Application - work with Spreadsheets

  1. Open, close a spreadsheet application. Open, close spreadsheets.

  2. Create a new spreadsheet based on default template.

  3. Save a spreadsheet to a location on a drive. Save a spreadsheet under another name to a location on a drive.

  4. Save a spreadsheet as another file type like: template, text file, software specific file extension, version number.

  5. Switch between open spreadsheets.

2. Use and Application and Enhance Productivity

  1. Set basic options/preferences in the application: user name, default folder to open, save spreadsheets.

  2. Use available Help functions.

  3. Use magnification/zoom tools.

  4. Display, hide built-in toolbars. Restore, minimize the ribbon.

3. Work with Cells (Insert and Select)

  1. Understand that a cell in a worksheet should contain only one element of data, (for example, first name detail in one cell, surname detail in adjacent cell).

  2. Recognize good practice in creating lists: avoid blank rows and columns in the main body of list, insert blank row before Total row, ensure cells bordering list are blank.

  3. Enter a number, date, text in a cell.

  4. Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet.

4. Work with Cells (Edit and Sort)

  1. Edit cell content, modify existing cell content.

  2. Use the undo, redo command.

  3. Use the search command for specific content in a worksheet.

  5. Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic order.

5. Work with Cells (Copy, Move and Delete)

  1. Copy the content of a cell, cell range within a worksheet, between sheets, between open spreadsheets.

  2. Use the autofill tool/copy handle tool to copy, increment data entries.

  3. Move the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.

  4. Delete cell contents.

6. Manage Worksheets (Rows and Columns)

  1. Select a row, range of adjacent rows, range of non-adjacent rows.

  2. Select a column, range of adjacent columns, range of non-adjacent columns.

  3. Insert, delete rows and columns.

  4. Modify column widths, row heights to a specified value, to optimal width or height.

  5. Freeze, unfreeze row and/or column titles.

7. Use Formulas (Arithmetic)

  1. Recognize good practice in formula creation: refer to cell references rather than type numbers into formulas.

  2. Create formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division).

  3. Identify and understand standard error values associated with using formulas: #NAME?, #DIV/0!, #REF!.

  4. Understand and use relative, absolute cell referencing in formulas.

8. Use Functions

  1. Use sum, average, minimum, maximum, count, counta, round functions.

  2. Use the logical function if (yielding one of two specific values) with comparison operator: =, >, <.

9. Format Numbers and Dates

  1. Format cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands.

  2. Format cells to display a date style, to display a currency symbol.

  3. Format cells to display numbers as percentages.

10. Format Contents

  1. Change cell content appearance: font sizes, font types.

  2. Apply formatting to cell contents: bold, italic, underline, double underline.

  3. Apply different colours to cell content, cell background.

  4. Copy the formatting from a cell, cell range to another cell, cell range.

11. Format Alignment and Border Effects

  4. Add border effects to a cell, cell range: lines, colours.

12. Create Charts

  1. Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart.

  2. Select a chart.

  3. Change the chart type.

  4. Move, resize, delete a chart.

13. Edit Charts

  1. Add, remove, edit a chart title.

  2. Add data labels to a chart: values/numbers, percentages.

  3. Change chart area background colour, legend fill colour.

  4. Change the column, bar, line, pie slice colours in the chart.

  5. Change font size and colour of chart title, chart axes, chart legend text.

14. Prepare Outputs (Setup)

  1. Change worksheet margins: top, bottom, left, right.

  2. Change worksheet orientation: portrait, landscape. Change paper size.

  3. Adjust page setup to fit worksheet contents on a specified number of pages.

  4. Add, edit, delete text in headers, footers in a worksheet.

  5. Insert and delete fields: page numbering information, date, time, file name, worksheet name into headers, footers.

15. Prepare Outputs (Check and Print)

  1. Check and correct spreadsheet calculations and text.

  2. Turn on, off display of gridlines, display of row and column headings for printing purposes.

  3. Apply automatic title row(s) printing on every page of a printed worksheet.

  4. Preview a worksheet.

  5. Print a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart.