Friday, 14 June 2013

Activity 7 - Spreadsheets as a Learning Resource

Spreadsheets can be used as part of the learning process whether with a large group of students or one-on-one.  When there is a large group of students and limited computers, teachers can use projectors to conduct lessons which require spreadsheet use; they can also include printed tutorials which help students to follow the process used and provides them with a reference document.  In a situation where there are enough computers for individual use, collaborative projects which incorporate data collection, processing and presentation can be carried out by having individuals feed data into small groups which then feed the overall project.

Activity 4 - Spreadsheets for Admin Purposes

Spreadsheets are definitely useful in helping with the administrative functions of the teacher.  This activity demonstrates how functional a spreadsheet can be for recording and computing students' grades.  With simple math equations entered into the spreadsheet, a teacher can simply enter the primary grade students receive for various assignments and have all the calculations done in the background to come up with final grades, percentages etc.  They also allow for graphical presentations (charts etc) of a variety statistics that can be gathered for a class or subject area.