OER4Schools/ICT/Robots and spreadsheets part 2

Educator note

Facilitator distributes robots/traffic lights.

Introduction (5 min) to Robots (Traffic lights)^(a). Robots/traffic lights have three lights - red, orange and green. These lights signal to drivers what action they should take on the road with each coloured light having a different meaning associated with it: Red means STOP; Orange means GET READY TO GO and Green means GO. Their meanings for classroom application are:

• RED means “I’m stuck. I need some extra help. I don’t feel I have progressed.”
• ORANGE means “I’m not quite sure. I need a little help. I feel I have made some progress.”
• GREEN means “I understand fully. I’m okay without help. I feel I have progressed a lot.”

While you do practical work in groups, make a stack of your three cards near your groups. Place the colour on top which shows how you are progressing as a group. The facilitator will see the colour and help you appropriately.

Different-tasks group work (15 min) with ICT on various topics. You now have 15 minutes to do ICT practice, and we return to working with spreadsheets. Below are the two sets of exercises with spreadsheets: one you have already encountered in a previous session, and the other is new. Revisit what you have done, and then work on some new things. Remember, that many of the applications you are using are pretty open ended, so explore additional things that interest you.

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.

2. Formatting Worksheets

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

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