Mark Rastin

IT Help, Support and Training

Course

Specification

Course Code:

20.04

Course Subject:

ECDL Module 4

Course Title:

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

1. Open (and close) a spreadsheet application.
   Open one or several spreadsheets.
   Create a new spreadsheet (default template).
   Save a spreadsheet to a location on a drive.
   Save a spreadsheet under another name.
   Save a spreadsheet in another file type such as: text file, HTML, template, software specific file extension, version number.
   Switch between worksheets, open spreadsheets.
   Use available Help functions.
   Close a spreadsheet.

2. Use magnification/zoom tools.
   Display, hide built-in toolbars.
   Freeze, unfreeze row and/or column titles.
   Modify basic options/preferences in the application: user name, default directory/ folder to open, save spreadsheets.

2. Manage Cells

1. Enter a number, date, text in a cell.
   Insert special characters, symbols.

2. Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet.
   Select a row, range of adjacent rows, range of non-adjacent rows.
   Select a column, range of adjacent columns, range of non-adjacent columns.

3. Insert rows, columns in a worksheet.
   Delete rows, columns in a worksheet.
   Modify column widths, row heights.

4. Insert additional cell content, replace existing cell content.
   Use the undo, redo command.

5. Duplicate (copy/paste) the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.
   Use the autofill tool/copy handle tool to copy, increment data entries.
   Move (Cut/Paste) the contents of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.
   Delete cell contents.

6. Use the search command for specific content in a worksheet.
   Use the replace command for specific content in a worksheet.

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

3. Manage Worksheets

1. Insert a new worksheet.
   Rename a worksheet.
   Delete a worksheet.
   Duplicate a worksheet within a spreadsheet and between open spreadsheets.
   Move a worksheet within a spreadsheet and between open spreadsheets.

4. Use Formulas and Functions

1. Generate formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division).
   Recognize and understand standard error values associated with using formulas.
   Use Cell Referencing

2. Understand and use relative, mixed, absolute cell referencing in formulas.

3. Generate formulas using sum, average, minimum, maximum, count, functions.
   Generate formulas using the logical function if (yielding one of two specific values).

5. Apply Formatting

1. Format cells to display numbers to a specific number of decimal places, to display numbers with, without commas to indicate thousands.
   Format cells to display a date style.
   Format cells to display a currency symbol.
   Format cells to display numbers as percentages.

2. Change cell content appearance: font sizes, font types.
   Apply formatting to cell contents such as: bold, italic, underline, double underline.
   Apply different colours to cell content, cell background.
   Copy the formatting from a cell, cell range to another cell, cell range.
   Apply text wrapping to contents within a cell.

3. Align contents in a cell, cell range: left, centre, right, top and bottom.
   Centre a title over a cell range.
   Adjust cell content orientation.
   Add border effects to a cell and cell range.

6. Use Charts/Graphs

1. Create different types of charts/graphs from spreadsheet data: column chart, bar chart, line chart, pie chart.
   Add a title, label to the chart/graph. Remove a title, label from the chart/graph.
   Change the background colour in a chart/graph.
   Change the column, bar, line, pie slice colours in the chart/graph.
   Change the chart/graph type.
   Duplicate, move charts/graphs within a worksheet, between open spreadsheets.
   Resize, delete charts/graphs.

7. Prepare Outputs

1. Change worksheet margins: top, bottom, left, right.
   Change worksheet orientation: portrait, landscape. Change paper size.
   Adjust page setup to fit worksheet contents on one page, on a specific number of pages.
   Add, modify text in Headers, Footers in a worksheet.
   Insert fields: page numbering information, date, time, file name, worksheet name into Headers, Footers.

2. Understand the importance of checking spreadsheet calculations and text before distribution.
   Preview a worksheet.
   Turn on, off display of gridlines, display of row and column headings for printing purposes.
   Apply automatic title row(s) printing on every page of a printed worksheet.

3. Print a cell range from a worksheet (Print to File functionality if printer not available) an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart.