Request a callback

We'll call during UK business hours

0207 987 3777

previousPrevious article   Next articlenext back to categoryExcel articles

article How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom

Computers help teachers manage grades and create exciting activities for the students. The capabilities of Excel go beyond just crunching numbers and many teachers are attending Excel XP training to get everything they can out of the software.

Excel As A Grade Book

Calculating student grades is a basic activity in many Excel XP training courses, even ones without teachers attending. A grade book is an easy way to demonstrate averages, medians and other analytical formulas. However a teacher can do more than just average a student's grade.

Grades can be placed into categories that are weighted differently, for example having homework affect the final grade less than exams. Even individual grades can be weighted like this so a short homework counts for less than a long one.

A teacher can quickly spot trends as a student's grade changes over the term, singling out struggling students for extra help. Class averages help a teacher evaluate whether the coursework is too easy or difficult.

Excel For Lessons

Techniques teachers learn in Excel XP training can be used to create worksheets the students can use on the computer. These can be for individual or group projects, giving them an easy form to enter and analyse data.

For example, a class project might track temperature and barometric pressure over several days to see how it relates to weather patterns. A reading workbook could be created with a separate sheet for each student allowing them to track their progress on the reading assignments throughout the term. The data could be plotted on a bar graph so that students can easily see their progress.

A nutrition lesson can have a sheet where students could enter what they eat each day. The sheet can pull information on nutrition, calories, fat content and so on, from a database on another page to let students see how different food choices affect the totals.

Excel As A Non-Mathematical Tool

Although Excel XP training focuses mostly on the mathematical aspects of the spreadsheet application, many teachers have found creative ways to use the software that have nothing to do with numbers.

Rather than the same old chemistry quiz, try creating an Excel crossword puzzle. The clues would all be chemistry questions and the grid could automatically check student answers as they enter them. Students have fun and learn at the same time.

The grid format is ideal for creating historical timelines that are easier to visualize than lists of dates. These can be printed out for student reference or turned into a game where students drag events into the timeline presented, sorting them in order.

Excel is a tool with a broad range of uses that go beyond simply calculating averages. Teachers who take a creative approach to a spreadsheet discover new ways to use Excel to enrich their lessons.

Author is a freelance copywriter. For more information on excel-xp-training, please visit

Original article appears here:

Back to article list

Distribution notes


  • You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
  • Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
  • Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
  • If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
  • Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
  • If you do not agree to these terms, please do not use this article.

Microsoft Office courses London
Course rating
4.6 stars - based on 1111 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom