OER4Schools/Spreadsheet exercises

A set of basic spreadsheet exercises to get you started

Resource details
Title	Spreadsheet exercises
Topic	[[Topics/OER4Schools|OER4Schools]],  [[Topics/Teacher Education Resources for Sub-Saharan Africa|Teacher Education Resources for Sub-Saharan Africa]]
Teaching approach	[[Teaching Approaches/|]]
Subject	[[Resources/Teacher Education|Teacher Education]]
Age of students / grade	[[Resources/|]]
Acknowledgement	This resource is part of the OER4Schools programme.

This activity will orientate you to make use of OpenOffice for creating spreadsheets and databases which can be useful for investigating maths and science problems. You will need to access a computer/laptop/netbook and internet. Access a web browser and navigate to this page: http://inpics.net/calc.html

We suggest that you go through some of the exercises on the page in this order:

1. Basic Calculations

• Add
• Subtract
• Multiply
• Divide
• Calculate averages
• Find the maximum value

2. Formatting Worksheets

• Format text
• Format cells
• Adjust columns and rows
• Print worksheets

3. Manipulating Data

• Move, copy, and paste
• Add / delete columns
• Add / delete rows
• Employ multiple worksheets
• Employ AutoFill
• Insert / delete worksheets

4. Advanced Calculations

• Create formulas across worksheets
• Employ absolute references
• Employ the function wizard

5. Making Data Visible

• Add notes
• Freeze panes
• Create charts