OER4Schools/ICT/Introduction to spreadsheets

Different-tasks group work (20 min) with ICT on various topics.

Educator note

You may want to limit the time spent on these tasks spent within the workshop. You could interrupt, say after 20 minutes, to discuss the homework. However, if there is time after the workshops, participants could always return to these activities. It is essential to allow time to introduce the homework before the session ends.

To use ICT in an investigative way requires that both teachers and learners are sufficiently familiar with the technology and software, or the teacher spends the whole time troubleshooting problems of using the technology and software instead of addressing the more important enquiry skills and learning objectives. Developing this familiarity through progressively more complex use of ICT needs careful thought. For a starter, addressing the whole class to demonstrate features/procedures of using ICT can be most efficient rather than speaking to groups in turn.

In this session, we suggest that you familiarise yourself with the use of the spreadsheet function in OpenOffice and/or with GeoGebra. It is likely that you may need to complete the activity as homework.

>

1. Basic Calculations

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

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

If you are done, help others!

(In the Zambian context, these may be suitable for Grade 5 upwards.)