Spreadsheet Practical Without Internet
A JHS in a rural district has 12 working computers for 45 JHS 2 students. The ICT teacher has one 40-minute period per week with each class and must prepare students for a BECE practical task on spreadsheets: entering data, using simple formulas such as =SUM and =AVERAGE, and creating a bar chart. There is no internet connection. Power cuts are frequent and unscheduled. The projector is broken. The school has three USB flash drives, one printer, and no UPS. Students currently share computers in groups of four, and some spend most of the lesson watching. Only six computers have the spreadsheet program installed; the others have an older word-processing package. The teacher wants every student to have hands-on practice and a fair assessment record before the end of the eight-week term.
1. Design a practical plan for the eight weeks that gives each student meaningful hands-on time despite 12 computers and 45 students.
Read the worked answer
Use a two-station rotation within each 40-minute period. With 12 computers, pair students so 24 students can work at once; split 45 into two groups of 22 and 23. Group A does 18 minutes hands-on, then swaps with Group B, which uses printed spreadsheet grids and formula cards. That gives every student about 18–20 minutes of direct keyboard time weekly. Preload a template on each computer from one USB drive before the lesson: columns for names, scores, =SUM and =AVERAGE, and a bar chart. Assign computer numbers to pairs and rotate roles (driver/keyboard, recorder/checker) halfway so one student does not dominate. In weeks 1–2, practise data entry; weeks 3–4, formulas; weeks 5–6, charts; weeks 7–8, a timed practice task. Keep a paper backup for power cuts: students complete the same table and formula steps on paper, then transfer when power returns.
2. Explain how you would manage file storage and assessment with only three USB drives, frequent power cuts and one printer.
Read the worked answer
Storage: create a folder on each computer named by computer number; pairs save as C01_pairA.xlsx. At the end of each lesson, the teacher copies each computer's folder to one USB drive, using a rotating naming system (week and group) and keeps a second USB as backup. Assessment: use a one-page checklist per pair with criteria: correct headings, =SUM, =AVERAGE, chart type, labels. Print only the final checklist or one summary sheet per group, not every file. Power cuts: teach Ctrl+S every few minutes; keep a paper log of each pair's progress; if a cut occurs, students finish on paper and transfer next lesson. Fairness: the checklist records individual contribution through role notes and a short oral question to each student, so the assessment is not based only on the pair's file.
3. Identify one equity problem in your plan and explain how you would reduce it.
Read the worked answer
One equity problem is that confident students dominate the keyboard, while weaker or absent students fall behind. Reduce it by rotating driver/recorder roles, giving each student a short individual exit task (for example, write the formula for a total and explain it), and keeping a simple progress tick sheet. Students who miss a lesson can join a 10-minute catch-up at break using a preloaded practice file. Also check that girls and students without home computer access are not always assigned the recorder role. The aim is equal hands-on time, not just equal group membership.