Search

# All articles with 'teachers' Tag

## How to convert test scores to letter grades in Excel?

Published on Mar 20, 2024 in Excel Howtos

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

Continue »

## A Huge Collection of Spreadsheets for Teachers [What Excel Can Do]

Published on Feb 3, 2011 in Charts and Graphs, excel apps

Way back in November, I received this email from Tom, a senior researcher at the Center for Learning Innovation in Australia.

I’ve been developing & have published spreadsheet applications for teachers for some time now. In particular, I have animations, adventure scenarios etc that can be used to create games for the classroom. I need to promote these so teachers eventually try these and use them. … Perhaps you could post some of these on your site.

What a noble cause, I thought. So I wrote back to him and invited him to share his files along with a guest article. Tom acted quick and emailed me his article and Excel workbooks by Thanksgiving day. I was too lazy and got lost in the flow of things. But now, I am very very glad to feature his work.

There are so many valuable tricks, ideas and powerful concepts buried in his workbook. I encourage everyone to play with his file (you need to enable macros) so that you can learn a thing or two. If you are a teacher, feel free to use the files to make your classroom teaching even more awesome.

Continue »

## Which teacher inspired you most?

Published on Jul 28, 2008 in personal, Random

When I was in school we had a maths teacher named BVN. He used to teach advanced math (like trigonometry, calculus) for class 7 onwards. We used to fear him a lot because he is the strictest of them all. Finally when I got to seventh I met him as a teacher. And boy, he […]

Continue »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.