KS3/4 ICT. The formula for success. Spreadsheets. 2
Description
Regarded as one of the most dry and difficult to teach areas of ICT, this programme explores how Mat Little, an ICT teacher at Parrs Wood High School in Manchester, develops pupils' understanding of spreadsheets through a series of visual and kinaesthetic teaching activities, and by making the topic relevant. The year 10 students are initially tasked to define what a mean, mode, median and range are using a visual numbers game. Pupils then move on to create a formula, with students holding specific components at the front of the class being directed by peers into their correct position within the "human" formula. Students are then tasked to work on computers to identify a variety of components within spreadsheets, with the lesson plenary involving an activity demonstrating the effectiveness of spreadsheets. The data-set they work with is based on the use and cost of mobile phones.
Runtime
14 min
Series
Subjects
Genre
Date of Publication
2006
Database
Alexander Street
Direct Link
Similar Films
Teaching e-safety
Excel 2013 for dummies analyzing & charting data course. Sorting and filtering pivot table data
Voting technology used for KS2 numeracy
Excel 2016 for dummies enhancing & sharing data course. Adding records to tables in Excel 2016
ICT delivery
Excel 2013 for dummies automating course. The AutoSum and Quick Analysis tools
David Puttnam
Excel 2013 for dummies user basics course. Using the Excel ribbon
Cloud-based presentation & spreadsheet tools for dummies slideshare and smartsheet course. Running a report in smartsheet
Learning platforms
Google Sheets. Sorting, filtering, formatting
How to add audio to an animation
Opening doors to technology literacy. Bringing the web to your classroom
Excel 2016 for dummies user basics course. Entering numbers in an Excel 2016 worksheet
Excel 2016 for dummies formulas & tools course. Completing a series with AutoFill in Excel 2016