How to save and close a spreadsheet software application

Assignment Help Other Subject

Reference no: EM132337454

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.

Reference no: EM132337454

Questions Cloud

What amounts to an automatic pay raise : What amounts to an automatic pay raise with no state income tax deducted from their paychecks - What does that really accomplish

Print it with a python program : How to find a sum of all odd digits in a positive integer number and print it with a Python program?

Identify a specific evidence-based practice proposal topic : Consider the clinical environment in which you are currently working or have recently worked. The capstone project topic can be a clinical practice problem, an.

In what ways has informatics impacted public health : The Future of Healthcare Informatics. In what ways has informatics impacted public health - please provide at least three examples.

How to save and close a spreadsheet software application : ICT Office Application II -HND Office Technology and Management-OTM 323-Develop student skills using an spreadsheet application and develop keyboarding.

What were the components that impacted your practice : NUR 4945C Journaling a "critical" incident analysis is a specific technique in reflection that asks the student to describe and analyze a particularly.

Is houston more individualistic or traditionalistic : Is Houston more individualistic or traditionalistic? Or is it something else entirely? Does it fit into any of Dr. Elazars categories

What techniques you were able to incorporate into interview : Be prepared to conduct an interview of someone you choose. It can be a family member or a friend . Review "Techniques of Communication" in the textbook reading.

Informative poster and present it at academic showcase : Create an interesting, informative poster and present it at the Academic Showcase. Learn about notable scientist and the physics ideas they contributed to the

User Account

All Pages