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.

Review how to produce quality chart and graph using Microsoft Excel function: how to enter data and editing data; change the appearance of a chart or graph, and print the chart or graph to an appropriate quality standard of presentation.

Set individual and group task to produce quality and impacting/creative graphs and charts based on real data.

Ask students to produce individual portfolio including spreadsheets with graphs and chart representations, based on casestudies and real data.

Promote discussion and self-assessment of portfolio, as well as peer-assessments.

Select the best approach to present data and charts, from the students work/portfolio.