Google's spreadsheet. A class can enter data into one shared sheet and chart it live.
Creative Amplify
After a river fieldwork day, students build a CoSpaces Edu tour from 360 photos of four sites, with their width, depth and velocity data and a recorded commentary at each.
Students build a web page comparing a tropical rainforest and a hot desert, with climate graphs embedded from Google Sheets and collapsible explanations beside each.
Creative Transform
Students take the Met Office monthly rainfall series for their region since 1836, write p5.js rules that turn every month into a mark, and print the generated design onto fabric.
Students count sentences carrying two semantic fields of their choice across the whole of A Christmas Carol in Google Sheets, chart the results stave by stave and build an argument from them.
Over three lessons, groups build a corpus of 20 Gemini-written film review openings, code it against 20 published openings, and write up what the data shows about machine-written reviews.
Students measure the cliff edge at Happisburgh on dated satellite images in Google Earth, pool their readings in a class sheet to calculate rates of retreat, and build a mapped judgement on the shoreline policy.
Students pull four weeks of 15-minute river level and rainfall readings from the Environment Agency into Google Sheets, build their own storm hydrograph and write a flood briefing for Bewdley.
Students trace every name on the town's war memorial in the Commonwealth War Graves Commission database, pool the records in one sheet, chart what they show and publish a school-only memorial site.
Students turn NOAA's full monthly carbon dioxide record from Mauna Loa into a Google Sheets dashboard, with a filter by decade, a trendline and a seasonal-cycle chart.
Students work with the census population of all 183 municipalities in the province of Soria since 1900, sort and chart the losses, and write a data-led article in Spanish around what they find.
Students count note-to-note moves in Bach chorale melodies to build a simple statistical model, code it in Sonic Pi to generate new melodies, and critique what it captures and misses.
Interactive Amplify
Students vote on which of three search algorithms is most efficient, test each in Scratch on growing lists, chart the class's comparison counts and vote again.
Groups load four glued pine joints until they fail, enter each breaking load into one shared sheet, and the teacher uses the live chart to question the results that do not fit.
After both schools have measured a local river, a Grade 10 class pools its channel data with a partner school's in one sheet, tests both rivers against the Bradshaw model and questions the other class's methods.
Students predict three probability outcomes on Mentimeter, run 1,000 trials of each in a Google Sheets simulator, and pool the class's results to see which predictions held up.
Students each draw a random sample from 200 anonymised CensusAtSchool records in Google Sheets, and a class chart of everyone's sample means shows sampling variation.
Students build three specified circuits in PhET, enter their current and potential difference readings in a shared Google Sheet, and use the pooled table to state the series and parallel rules.
Each student adds one method change for the free-fall practical to a shared sheet with its estimated effect on uncertainty, and the teacher sorts and challenges the estimates live.
Interactive Transform
Students each ask Microsoft 365 Copilot Chat for five short character sketches of someone in an assigned job, log the names and pronouns in a class sheet, and compare the pooled results with published UK workforce figures.
Students judge twelve teacher-written emails as phishing or genuine, ask Gemini for its verdict and reasons, and test every reason against what the email actually shows.
Pairs search a Google Sheet holding every line of Blake's Songs of Innocence and of Experience, counting and reading the matches to find out how far 'The Tyger' is typical of the book it comes from.
Students at a UK school and a partner school in Accra log the labels of their own clothes in one shared sheet and each describe their own end of the second-hand clothing chain, so both classes can trace where clothes are made, worn and resold.
For the last two weeks of January, a UK class and a partner class in Cape Town take the same noon shadow and temperature readings into one shared sheet, then use the data to explain opposite seasons.
Pairs compare what Flightradar24's live map shows over Africa with the departure boards of eight airports, to decide whether empty patches of map mean no flights or no receivers, and test the claim that Africa is 'switched off'.
Pairs filter and count a Google Sheet of about 6,000 people from their own town's 1851 census to test a textbook claim about industrial towns, then put a question of their own to the same records.
Pairs filter and count 1,500 Old Bailey trial records from 1780 to 1800 in Google Sheets to test the claim that most people convicted of theft were sentenced to hang.
Pairs question Gemini about three historians of the English Reformation, try it with repeated and leading questions, and check every claim and quotation against extracts in a shared reliability log.
Pairs work through a week of micro:bit light readings from three places the class chose, find what fraction of each day each place was lit, and group the hours to build fraction families.
Pairs walk assigned shopping streets in Montreal and Paris on Google Earth Street View, logging every shop sign into a shared sheet to test whether French speakers really borrow English words everywhere.
A sports scientist runs a treadmill test on a volunteer athlete in a university lab over a staff-hosted Teams call, and Grade 7 decide when the speed rises and predict each heart-rate and breathing reading before it is read out.
Pairs interrogate the 2011 and 2021 Census religion figures for every local authority in England and Wales in Google Sheets, to test whether Christian decline is as even as the secularisation thesis suggests.
Over two weeks, Grade 7 read the carbon dioxide and light curves from a sealed plant box at the start of each lesson and choose the next condition to test, building a chain of tests the sensors record day and night.
This page is one of a growing set of PICRAT examples by cell, subject and grade. Page maintained by Andy Perryer.