Shared spreadsheet. Used here as a live class scoreboard and sortable data surface for thirty-pupil aggregation.
Creative Transform (CT)
Real climate data dashboard with interactive charts
Each student builds an interactive dashboard analysing real climate data (drawing from publicly available temperature, sea-level or carbon dioxide records over the past 50 years). The dashboard must include at least three interactive charts (one with a time slider, one with category filter, one with regression overlay) and a short interpretation panel. They publish to a class showcase.
Tools: Google Sheets
Interactive Amplify (IA)
Climate data analysis for two cities
Each student receives a shared spreadsheet with monthly mean temperature and rainfall data for two cities at similar latitudes (e.g. Lisbon and Boston, or Cape Town and Buenos Aires). They produce a comparison chart, identify three differences, and post the differences to a class Padlet column. The class discusses why two cities at the same latitude can have very different climates.
Tools: Google Sheets, Padlet
Live fieldwork data analysis across class
Each student brings their A-Level NEA fieldwork data to a shared class spreadsheet. The class collectively scrolls all data sets, with the teacher highlighting students whose data shows interesting patterns and asking them to explain. Pairs then write a one-line interpretation of one classmate's data.
Tools: Google Sheets
Times-tables timed challenge with shared scoreboard
Each student answers rounds of three random times-tables questions. After each round, the live class scoreboard updates automatically. The class watches the scoreboard between rounds, with the teacher pointing out which students are improving and which tables tend to slow the class down. After five rounds, the class identifies the two times-tables to drill again next week.
Tools: Google Sheets, Quizizz
Algebra equation race with class scoreboard
Students answer randomly-generated linear equations at their own pace through a Quizizz set. The class scoreboard projects on the front display, updating live. Every five minutes the teacher pauses, points out the two equation types causing the most class-wide misses, and asks two students to walk through their reasoning out loud.
Tools: Quizizz, Google Sheets
Real-data statistical investigation on shared sheet
Each student picks a question from a posted list (e.g. is there a relationship between hours of homework and exam grade in our cohort?), and records their three closest classmates' values into a shared class spreadsheet. The class scrolls all rows; the teacher highlights distributions, anomalies and surface correlations; pairs then write a one-line interpretation.
Tools: Google Sheets
Hypothesis test interpretation lab
The teacher posts a real-world hypothesis test scenario (e.g. is a coin biased?, is the mean grade in this cohort different from the national average?). Students vote on Mentimeter for the strongest interpretation of the test result among three options. The class sees the spread, then in pairs writes a defence on a shared Sheet. The teacher calls pairs to argue and the class re-votes.
Tools: Mentimeter, Google Sheets
Pulse-rate data collection across class
Each student records their resting pulse rate, then their pulse after 30 seconds of jumping jacks, then again after one minute of recovery. They post all three values to a shared class spreadsheet. The class scrolls and the teacher discusses class-wide patterns (range of resting rates, recovery rate variability).
Tools: Google Sheets
Class plant growth measurements on shared sheet
Each pair plants two seeds (one in dark, one in light) and measures shoot height daily. Pairs enter measurements into a shared class spreadsheet. After two weeks, the class scrolls all pairs' data and identifies fastest-growing plants, slowest, and discusses likely reasons (tied to the dark/light condition).
Tools: Google Sheets
Forces investigation with shared spreadsheet
Students conduct a basic spring extension experiment at their bench. Each student enters their three measurements into a shared class spreadsheet. The class scrolls all thirty rows; the teacher highlights outliers and asks the contributing student to explain whether the outlier reveals a measurement error or a real effect. Pairs then plot the class average against load.
Tools: Google Sheets
Virtual circuit lab with shared results
Each student designs and tests three circuits in a PhET circuit simulator (a series circuit with two bulbs, a parallel circuit with two bulbs, a circuit with mixed series and parallel). They post current and voltage readings into a shared class spreadsheet. The class scrolls all rows and the teacher highlights anomalies, asking the contributing student to debug their circuit.
Tools: PhET Simulations, Google Sheets
Required-practical method crowd-sourcing
The teacher names an A-Level required practical (e.g. determining specific heat capacity, investigating enzyme kinetics). Each student posts to a shared spreadsheet one method choice they would optimise (variable to control more tightly, repetition strategy, equipment substitution) with a one-line justification. The class scrolls the spreadsheet and the teacher pulls out the three most defensible optimisations for whole-class discussion.
Tools: Google Sheets
Interactive Transform (IT)
Live global-data collaboration with partner school
A class partners with a school in a different climate zone (e.g. UK paired with a school in southern Australia, the US Southwest, or Singapore). Both classes record local rainfall, temperature and humidity data into a shared spreadsheet for two weeks. They then video-call to compare patterns and discuss what the climate difference reveals about geographic processes.
Tools: Google Sheets, Microsoft Teams
Real-time fieldwork data sharing across countries
Two classes (UK and a partner country) conduct similar fieldwork (e.g. high-street pedestrian counts, river-channel measurements at equivalent sites) and share data live to a joint spreadsheet over a video call. Both classes interpret the cross-country data together; each team writes a one-line interpretation of the other team's findings.
Tools: Google Sheets, Microsoft Teams
This page is one of a growing set of PICRAT examples by cell, subject and key stage. Page maintained by Andy Perryer.