OER4Schools/Spreadsheet exercises: Difference between revisions

From OER in Education
No edit summary
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{OER4SchoolsRinfo
<noinclude>{{OER4SchoolsRinfo
|title=Spreadsheet exercises
|title=Spreadsheet exercises
|tagline=A set of basic spreadsheet exercises to get you started
|tagline=A set of basic spreadsheet exercises to get you started
}}
}}</noinclude>


This activity will orientate you to make use of OpenOffice for creating
This activity will orientate you to make use of OpenOffice for creating
Line 13: Line 13:
this order:
this order:


'''1. Basic Calculations'''
{{:OER4Schools/Spreadsheet exercises/1}}
 
{{:OER4Schools/Spreadsheet exercises/2}}
* [http://inpics.net/tutorials/calc2/basics13.html Add]
{{:OER4Schools/Spreadsheet exercises/3}}
* [http://inpics.net/tutorials/calc2/basics21.html Subtract]
{{:OER4Schools/Spreadsheet exercises/4}}
* [http://inpics.net/tutorials/calc2/basics24.html Multiply]
{{:OER4Schools/Spreadsheet exercises/5}}
* [http://inpics.net/tutorials/calc2/basics28.html Divide]
* [http://inpics.net/tutorials/calc2/basics31.html Calculate averages]
* [http://inpics.net/tutorials/calc2/basics35.html Find the maximum value]
 
'''2. Formatting Worksheets'''
 
* [http://inpics.net/tutorials/calc2/format2.html Format text]
* [http://inpics.net/tutorials/calc2/format11.html Format cells]
* [http://inpics.net/tutorials/calc2/format23.html Adjust columns and rows]
* [http://inpics.net/tutorials/calc2/format28.html Print worksheets]
 
'''3. Manipulating Data'''
 
* [http://inpics.net/tutorials/calc2/data2.html Move, copy, and paste]
* [http://inpics.net/tutorials/calc2/data12.html Add / delete columns]
* [http://inpics.net/tutorials/calc2/data18.html Add / delete rows]
* [http://inpics.net/tutorials/calc2/data23.html Employ multiple worksheets]
* [http://inpics.net/tutorials/calc2/data26.html Employ AutoFill]
* [http://inpics.net/tutorials/calc2/data32.html Insert / delete worksheets]
 
'''4. Advanced Calculations'''
 
* [http://inpics.net/tutorials/calc2/calc2.html Create formulas across worksheets]
* [http://inpics.net/tutorials/calc2/calc8.html Employ absolute references]
* [http://inpics.net/tutorials/calc2/calc17.html Employ the function wizard]
 
'''5. Making Data Visible'''
 
* [http://inpics.net/tutorials/calc2/vis2.html Add notes]
* [http://inpics.net/tutorials/calc2/vis5.html Freeze panes]
* [http://inpics.net/tutorials/calc2/vis9.html Create charts]

Latest revision as of 12:25, 17 November 2013


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

Eness IMG 0785 square.jpg
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.

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

1. Basic Calculations

2. Formatting Worksheets

3. Manipulating Data

4. Advanced Calculations

5. Making Data Visible

Retrieved from "https://oer.opendeved.net/index.php?title=OER4Schools/Spreadsheet_exercises&oldid=20242"