Develop student skills using an spreadsheet application and develop keyboarding techniques to enter data accurately.

ICT Office Application II

Aim/Goal : This module is designed to enable students to further develop their skills in effectively and efficiently work use a computer-based spreadsheet application.

General Objectives:

1. Develop student skills using an spreadsheet application and develop keyboarding techniques to enter data accurately.

Review the concept and importance of spreadsheets in modern offices. Explain the impact of accurate and quality data collection and entering using a spreadsheet software.

Explain the need of applying spreadsheets in commerce and business, and how this sort of software allow one to manipulate and present data in numbers and graphical forms.

Remind how to load (open) and main functions of Microsoft Excel.

Revise how and where place numerical table titles, what will go in each of the rows and columns, how any result will worked out, and how to change the spreadsheet looks (eg. number fonts)

Show how to insert and amend text and numerical data into the spreadsheet and how to move from one cell to another.

Explain how to correct mistakes and the difference between clear and delete.

Show how to calculate results from a spreadsheets, using data. Explain how and where to enter a formula and how to modify it. Student practice producing a basic spreadsheet including formulas.

Group students and provide case studies for them to complete spreadsheet based on real data.

Promote spreadsheets group crosschecking to discuss their accuracy, originality and creativity organising and presenting data.

Explain with a practical example, how to print spreadsheets documents, with formulae showing in full, and with data showing in full.

Demonstrate how to save and close a spreadsheet software application.

Explain the importance of charts and graphs presentations. Show what programs can be used to produce charts and graphs.