OER4Schools/ICT/Spreadsheets part 3: Difference between revisions

From OER in Education
No edit summary
No edit summary
Line 1: Line 1:
{{todo|group work with images (for talking points)}}
{{activity|dtgw| with ICT on spreadsheets.|20}} As usual, you now have an opportunity to work on your own ICT skills. In this session, we continue with spreadsheets in OpenOffice Calc or GeoGebra. We have done some of the earlier spreadsheet exercises from the list below already. See which ones you have mastered, and which ones require further work. Also try out some new ones. As before, work in pairs, and help each other and other groups.


{{activity|dtgw| with ICT on various topics.|20}} As usual, you now have an opportunity to work on your own ICT skills. In this session, we introduce Spreadsheets with OpenOffice Calc.
{{oinc|OER4Schools/Spreadsheet exercises}}


As you work on your ICT skills, you should think about planning another lesson with ICT (involving spreadsheets, Geogebra, slideshows, concept mapping). Remember to keep up the '''typing tutor''' practice too!
As you work on your ICT skills, you should think about planning another lesson with ICT (involving spreadsheets, Geogebra, slideshows, concept mapping). Remember to keep up the '''typing tutor''' practice too!
Here are some exercises for spreadsheets to get you started. In this session, you might only try to do the first few of these exercises. You will have an opportunity to continue this in your own time and in the next session.
{{oinc|OER4Schools/Spreadsheet exercises}}

Revision as of 20:12, 17 November 2013

Activity icon.png Different-tasks group work (20 min) with ICT on spreadsheets. As usual, you now have an opportunity to work on your own ICT skills. In this session, we continue with spreadsheets in OpenOffice Calc or GeoGebra. We have done some of the earlier spreadsheet exercises from the list below already. See which ones you have mastered, and which ones require further work. Also try out some new ones. As before, work in pairs, and help each other and other groups.


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

2. Formatting Worksheets

3. Manipulating Data

4. Advanced Calculations

5. Making Data Visible

You can print this content on a separate sheet here: OER4Schools/Spreadsheet exercises.


As you work on your ICT skills, you should think about planning another lesson with ICT (involving spreadsheets, Geogebra, slideshows, concept mapping). Remember to keep up the typing tutor practice too!