OER4Schools/Spreadsheet exercises - Revision history

Bjoern at 12:25, 17 November 2013

2013-11-17T12:25:00Z

← Older revision		Revision as of 12:25, 17 November 2013
Line 18:		Line 18:
	{{:OER4Schools/Spreadsheet exercises/4}}		{{:OER4Schools/Spreadsheet exercises/4}}
	{{:OER4Schools/Spreadsheet exercises/5}}		{{:OER4Schools/Spreadsheet exercises/5}}

	~~'''1. Basic Calculations'''~~

	* [http://inpics.net/tutorials/calc2/basics13.html Add]
	* [http://inpics.net/tutorials/calc2/basics21.html Subtract]
	* [http://inpics.net/tutorials/calc2/basics24.html Multiply]
	* [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]

Bjoern at 12:23, 17 November 2013

2013-11-17T12:23:49Z

← Older revision		Revision as of 12:23, 17 November 2013
Line 13:		Line 13:
	this order:		this order:

	{{:/1}}		{{:OER4Schools/Spreadsheet exercises/1}}
	{{:/2}}		{{:OER4Schools/Spreadsheet exercises/2}}
	{{:/3}}		{{:OER4Schools/Spreadsheet exercises/3}}
	{{:/4}}		{{:OER4Schools/Spreadsheet exercises/4}}
	{{:/5}}		{{:OER4Schools/Spreadsheet exercises/5}}

	'''1. Basic Calculations'''		'''1. Basic Calculations'''

Bjoern at 12:23, 17 November 2013

2013-11-17T12:23:06Z

← Older revision		Revision as of 12:23, 17 November 2013
Line 12:		Line 12:
	We suggest that you go through some of the exercises on the page in		We suggest that you go through some of the exercises on the page in
	this order:		this order:

			{{:/1}}
			{{:/2}}
			{{:/3}}
			{{:/4}}
			{{:/5}}

	'''1. Basic Calculations'''		'''1. Basic Calculations'''

Bjoern at 12:44, 15 November 2012

2012-11-15T12:44:57Z

← Older revision		Revision as of 12:44, 15 November 2012
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

Bjoern at 11:42, 15 November 2012

2012-11-15T11:42:56Z

← Older revision		Revision as of 11:42, 15 November 2012
Line 1:		Line 1:
			{{OER4SchoolsRinfo
			\|title=Spreadsheet exercises
			\|tagline=A set of basic spreadsheet exercises to get you started
			}}

	This activity will orientate you to make use of OpenOffice for creating		This activity will orientate you to make use of OpenOffice for creating
	spreadsheets and databases which can be useful for investigating maths		spreadsheets and databases which can be useful for investigating maths

Bjoern at 11:17, 15 November 2012

2012-11-15T11:17:16Z

← Older revision		Revision as of 11:17, 15 November 2012
Line 1:		Line 1:
			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'''		'''1. Basic Calculations'''

Bjoern: Bjoern moved page OER4Schools/5.1 Introduction to Enquiry Based Learning/Spreadsheet exercises to OER4Schools/Spreadsheet exercises

2012-11-15T11:16:52Z

Bjoern moved page OER4Schools/5.1 Introduction to Enquiry Based Learning/Spreadsheet exercises to OER4Schools/Spreadsheet exercises

← Older revision

Revision as of 11:16, 15 November 2012

Bjoern: Bjoern moved page /Spreadsheet exercises to OER4Schools/5.1 Introduction to Enquiry Based Learning/Spreadsheet exercises

2012-09-03T21:57:22Z

Bjoern moved page /Spreadsheet exercises to OER4Schools/5.1 Introduction to Enquiry Based Learning/Spreadsheet exercises

← Older revision

Revision as of 21:57, 3 September 2012

Bjoern: Created page with "'''1. Basic Calculations''' * [http://inpics.net/tutorials/calc2/basics13.html Add] * [http://inpics.net/tutorials/calc2/basics21.html Subtract] * [http://inpics.net/tutorial..."

2012-09-03T21:56:48Z

Created page with "'''1. Basic Calculations''' * [http://inpics.net/tutorials/calc2/basics13.html Add] * [http://inpics.net/tutorials/calc2/basics21.html Subtract] * [http://inpics.net/tutorial..."

New page

'''1. Basic Calculations'''

* [http://inpics.net/tutorials/calc2/basics13.html Add]
* [http://inpics.net/tutorials/calc2/basics21.html Subtract]
* [http://inpics.net/tutorials/calc2/basics24.html Multiply]
* [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]