Primary tabs

Short Course
on
Working with Spread Sheets using MS Excel
Computer literacy has become a prerequisite for almost any job in the modern office environment, and as such, it is more important than ever before to ensure that people have the knowledge and skills to utilise the latest technology effectively and efficiently, not only for their own benefit, but also for the benefit of their businesses.

Purpose of the course:

The purpose of this 3-day course is to introduce attendees to the best practices in working with spread sheets and then build their skills to use spread sheets effectively and appropriately in their day-to-day work.

Admission requirements:

Admission requirements: 
Grade 12 Or Grade 10 and 2 years working experience
Learning assumed to be in place: 
Working knowledge of WINDOWS operating system

Course outcomes and assessment criteria :

Course outcomes and the associated assessment criteria: 

Specific Outcomes

 

Assessment Criteria

How it will be assessed

Understand the basic elements of using spreadsheets.
  • Define spreadsheets in terms of its purpose and use.
  • Explain and understand the spread sheet terminology.
  • Launch the application launched from the task bar, list of programmes or clicking on the icon on the desktop.
  • Explain the benefits of using spread sheets.
  • Explain and understand the ribbon concept.
  • Work with workbooks.
  • Describe the parts of the spreadsheet window in terms of their features and use.
  •  Create a new worksheet and workbook.
  •  Save the document with a specific name in a specific folder.
  • Open an existing workbook.
  • Save a worksheet in a different format.
Format various aspects of a worksheet.
  • Use the commands in the Font group to change the appearance of the font of a single cell, a range of cells, a column, a row, or the entire worksheet.
  •  Change font types, sizes and colours.
  •   Add or change alignment.
  • Use bold, Italic and underline to enhance the appearance of text.
  • Insert/delete/move/hide cells/rows/columns.
  • Replicate formatting efficiently by using the Format painter.
  • Use Find and Replace is to make changes to an existing worksheet
Manage data in a workbook.
  • Data is entered in a worksheet.
  • Format cells/rows/columns for specific types of data.
  • Define cells/rows/columns in such a manner that only specific data can be entered.
  • Use Conditional Formatting to identify cells containing specific data elements.
  • Sort data. 
Use functions and formulae.
  • Explain the different libraries of functions.
  •   Select specific libraries from the toolbar
  • Create own formulas.
  • Explain the difference between relative and absolute addresses
  • Check and correct the order of precedence in mathematical operations to avoid miscalculations. 
  • Use functions and formulae.
  • Explain functions in terms of their purpose, use and syntax.
  • Select and use the appropriate function to do calculations.
  • Apply simple Mathematical functions to a given problem.
  • Use appropriate.
  • Text formulae to manipulate text data.
Insert an object in a document.
  • Insert and format a chart in a workbook.
  • Select the most appropriate chart type.
  • Enhance the chart by adding titles, labels, changing the font, adding shapes.
  • Insert and format all of the following objects:
  • Pictures.
  • Clip art.
  • Various shapes.
  • Smart Art.
  • Use the context specific menu tab to format the object.
Prepare the final version of a workbook.
  • Print a worksheet/workbook or part thereof.
  • Select the print area.
  • Change the printing options.
  • Add headers/footers.
  • Protect the workbook.
  • Mark a workbook as final.
  • Use a password to prevent unauthorised opening or modifying of a workbook.
  • Protect specific cells to ensure the integrity of the formulae.
Customise the view and preferences of the spreadsheet application.
  • Use the Options command on the File tab to customise various settings.
  • Change the direction of entering data.
  • Switch toolbar menus off and on.
  • Freeze cells to prevent scrolling.
  • Change the default file location.

 

Assessment: 
Summative assessment: Small practical self-evaluated tests on completion of each section. Formal assessment: Attendees have to complete a practical skills test.
Method of assessment: 
A 1 hour practical on-line skills test.

Additional information

Mode of delivery: 
Contact
Target group: 
All people in need of knowledge to perform their duties using spreadsheets more effectively on a computer.
Contact us
Name: 
UCE
E-mail: 
Telephone number: 
018 285 2821