Running a Spreadsheet Practical with 42 Students and 15 Working Computers
The school computer lab has 20 desktops, but only 15 are working; five are awaiting repair. Class 9 has 42 students and one 40-minute period per week. The syllabus requires a practical file with 10 spreadsheet tasks, including SUM, AVERAGE, cell references, and a simple chart. There is one projector, no internet, and templates in a shared folder. Last week nine students saved over the master template, six pairs completed only two tasks, and two students at a broken machine sat idle for most of the period. The teacher must plan the next period so that all 42 students use a working machine, complete at least three tasks, and leave evidence of individual understanding, while protecting the templates and keeping the practical syllabus on schedule.
1. How should the teacher organise 42 students on 15 working machines in a 40-minute period?
Read the worked answer
Use the arithmetic first: 15 working machines and 42 students means three students per machine on 14 machines, with one machine kept as a spare or teacher station. Do not plan pairs; 21 pairs would leave seven students without a machine.
Time plan (40 minutes):
- 0–6 min: Projector demonstration of the day's three tasks: entering data, using SUM, and using AVERAGE. Students watch with hands off keyboards.
- 6–10 min: Assign triads and roles. Each triad has an operator, a recorder, and a checker. The recorder writes results in the practical file; the checker verifies the formula and reads the task card aloud.
- 10–30 min: Task work. Roles rotate every 6–7 minutes so that every student operates the keyboard at least once. The teacher circulates with a checklist, not a queue at one desk.
- 30–36 min: Whole-class check of two formulas on the projector; triads compare results.
- 36–40 min: Individual exit slip on paper: write the formula for the total of cells B2:B6 and explain what AVERAGE does.
Keep the spare machine for a student whose machine fails, and post the task card at each station so triads do not wait for oral instructions.
2. How can the teacher ensure individual accountability and protect the master templates?
Read the worked answer
Accountability and file protection need separate routines.
Individual accountability:
- The practical file is individual even though the machine is shared. Each student writes the formula and the result in their own file, not just the group's answer.
- The exit slip is completed without help and collected. It tests formula writing, which is the actual syllabus skill.
- The teacher randomly asks one student per triad to explain a formula aloud. The group cannot answer for that student.
- Role rotation is recorded on a small group sheet so the teacher can see who operated the computer and who only watched.
Template protection:
- Put the master templates in a read-only shared folder. If the system allows, make student copies in a separate 'submit' folder.
- Teach a naming convention: 'Class9_RollNo_Task3.xlsx'. Nine students overwrote the master because no naming rule existed.
- Keep one clean backup on the teacher station. Restore rather than punish the whole class.
- For the nine students who overwrote the template, use the incident as a five-minute lesson on 'Save As' versus 'Save' and on versioning. Do not remove them from the practical; they need the practice.
This keeps the syllabus moving while producing evidence that each student, not just each group, can use the formulas.