End of term excel activity

This activity takes students through some commonly used excel functions that I used all the time in business. It isn’t colourful or flashy, but students remained engaged, using a small amount of demo from the front and mostly self guided learning.

I wrote it for my Y9 who have not opted for GCSE Computer Science as an assessed piece of work, but then reused it with Y7 as it worked so well. Students work through the worksheets at their own pace. Using the marking grid allows for rapid marking if you choose to take the file in, especially if you have 2 screens.

I used it for 25 minutes per lesson over 3 lessons. The rest of the lesson set aside for the free and very good iDEA.org.uk.

I hope you find it useful.

Save for later
  • Using-Excel-Lesson-v1.2.xlsx
  • Using-Excel-Marking-Grid.xlsx

About this resource


Created: Jun 9, 2019


xlsx, 25 KB



xlsx, 13 KB


Report a problem

Tes Paid Licence

How can I re-use this?