­
spreadsheet — Terry Freedman's ICT & Computing in Education blog — ICT & Computing in Education
  • Front Page
  • Search
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy
Menu

ICT & Computing in Education

Articles on education technology and related topics
  • Front Page
  • Search
  • Newsletters
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
  • Info
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy

How I reduced my marking time from 4 hours a week to 15 minutes

April 1, 2025

Reading each student’s work each week, at a rate of ten minutes each, took nearly two and a half hours. Thinking of suitable comments, adding them in to the appropriate place in Google Classroom, and updating my spreadsheet markbook took another hour and a half.

Something had to be done.

Read More
In AI, Alternatives, On the lighter side Tags marking, assessment, automation, spreadsheet

Using spreadsheets or Python to process words

October 4, 2023

A couple of people and I started to discuss how we might use technology to process a block of text.

Read More
In Research, Computing, Using and Teaching Computing & ICT Tags spreadsheet, spreadsheets, Python, synchysis

Blast from the past: the homework excuse management system revisited -- now with comments!

May 3, 2023

I have republished this post, or a version of it, on my Substack newsletter. The comments are interesting!You can use a spreadsheet to solve even relatively trivial problems — but why should you do so?

Read More
In Blast from the past, On the lighter side Tags spreadsheet, HEMS, homework

Section of an artcile records spreadsheet, by Terry Freedman

Using ChatGPT as a search engine

December 20, 2022

Although I haven’t been overly impressed with ChatGPT as a creative force, I have to say that I am impressed with it as an alternative to Google.

Read More
In Using and Teaching Computing & ICT Tags ChatGPT, spreadsheet, AI, artificial intelligence

On this day: a spreadsheet grade predictor

December 7, 2021

On December 7th, 2015, I wrote an article explaining how you could set up a spreadsheet in Excel to help you predict and analyse students’ grades.

Read More
In On this day, Leading & Managing Computing & ICT Tags spreadsheet, grade predictor

The Homework Excuse Management System, by Terry Freedman

Blast from the past: the homework excuse management system revisited

November 25, 2021

You can use a spreadsheet to solve even relatively trivial problems — but why should you do so?

Read More
In Blast from the past, On the lighter side Tags spreadsheet, HEMS, homework
Learning together. Image by Gerd Altmann from Pixabay

Learning together. Image by Gerd Altmann from Pixabay

Creating a staff IT skills audit with Google forms

August 17, 2021

You would be forgiven for thinking that every teacher in the country has spent lockdowns being so immersed in technology that they have all become experts. There is no more need for staff training in IT skills — and so no need to conduct a staff audit.

If only!

Read More
In Leading & Managing Computing & ICT, Tips for teachers Tags Google forms, Google sheets, spreadsheet, IT skills audit

Review: Portable Excel Genius

March 13, 2021

Although the book has not been written with teachers in mind, it contains information that many teachers would find useful.

Read More
In Bookshelf, Professional development, Reviews, Using and Teaching Computing & ICT Tags review, Excel, spreadsheet, Portable Excel Genius
Tick box, by Terry Freedman

Tick box, by Terry Freedman

How teachers can use the tick box in Google Sheets

June 10, 2020

Google sheets has a tick box feature. Here are some ways you can make use of it.

Read More
In Tips for teachers, Using and Teaching Computing & ICT Tags spreadsheet, spreadsheets, Google Sheets, tick box, admin
BBC Basic screen, by Terry Freedman

BBC Basic screen, by Terry Freedman

Make your own: where programming is relevant, useful and fun

April 25, 2019

To learn programming, it’s best to have some real problems which need solving. This article looks at several examples of the applications I’ve created, and why.

Read More
In Using and Teaching Computing & ICT Tags programming, Excel, spreadsheet, database, relational database, Access, Visual Basic for Applications, VBA, BASIC, BBC BASIC, project-based learning, problem-solving
The Homework Excuse Management System, by Terry Freedman

The Homework Excuse Management System, by Terry Freedman

Blast from the past: the homework excuse management system

September 25, 2018

You can use a spreadsheet to solve even relatively trivial problems — but why should you do so?

Read More
In Blast from the past, On the lighter side, Using and Teaching Computing & ICT Tags spreadsheet, HEMS, homework
Recent book reviews
Review: Next Practices - An Executive Guide for Education Decision Makers
Review: Next Practices - An Executive Guide for Education Decision Makers

Is a 2014 book on managing the computing provision in a school still worth buying?

Read More →
Still relevant (sadly): How to lie with statistics, by Darrell Huff
Still relevant (sadly): How to lie with statistics, by Darrell Huff

Although this book is over 60 years old, it is remarkably apposite for our times -- and especially in the fields of educational research and assessing pupils' understanding and progress.

Read More →
Quick looks: Bad Education: Why Our Universities Are Broken and How We Can Fix Them
Quick looks: Bad Education: Why Our Universities Are Broken and How We Can Fix Them

It was a great source of pride to me, getting hundreds of students through their A levels and encouraging them to go to university. But for some time I have asked myself a question: would I recommend this route now?

Read More →
Review: The Bright Side: Why Optimists Have the Power to Change the World
Review: The Bright Side: Why Optimists Have the Power to Change the World

At first glance, you might take this to be one of those books full of affirmations and anecdotes designed to lift your mood.

Read More →
Review: Small Habits Create Big Change: Strategies to Avoid Burnout and Thrive in Your Education Career
Review: Small Habits Create Big Change: Strategies to Avoid Burnout and Thrive in Your Education Career

My review of this for Teach Secondary magazine has just come out. Here is the published version, followed by the copy I submitted, which is slightly longer because it has a little more detail.

Read More →
Review: Productive Failure: Unlocking Deeper Learning Through the Science of Failing
Review: Productive Failure: Unlocking Deeper Learning Through the Science of Failing

My review of this for Teach Secondary magazine has just come out. Here is the published version, followed by the copy I submitted, which is slightly longer because it is a little more detailed.

Read More →
Review: AI Snake Oil: AI Snake Oil: What Artificial Intelligence Can Do, What It Can’t, and How to Tell the Difference
Review: AI Snake Oil: AI Snake Oil: What Artificial Intelligence Can Do, What It Can’t, and How to Tell the Difference

My review of this for Teach Secondary magazine has just come out. Here is the published version, followed by the copy I submitted, which is slightly longer because it has a little more detail.

Read More →
When AI can write as well as this, I'll worry! Plus a prize competition.
When AI can write as well as this, I'll worry! Plus a prize competition.

To paraphrase what Arthur C Clarke said about teachers, any writer that can be replaced by a computer probably should be.

Read More →
Review: The Shortest History of Music -- two reviews in one!
Review: The Shortest History of Music -- two reviews in one!

The music programme of study requires students to possess an understanding of the music they perform and that which they listen to, as well as a grasp of music history, and an appreciation of different musical styles.

Read More →
Review: The Art of Uncertainty (two reviews in one)
Review: The Art of Uncertainty (two reviews in one)

The Computing department would find the section on facial recognition interesting, because apart from possible ethical concerns, the fact is that even if the system has high accuracy, most of its identifications will be wrong.

Read More →
Dig+Ed+Banner.jpg

Contact us

Privacy

Cookies

Terms and conditions

This website is powered by Squarespace

(c) Terry Freedman All Rights Reserved