Excel for Teachers


November 2005

Excel for Teachers

"Learn Excel through real-life classroom problems.

Bill Jelen, MrExcel

category: Spreadsheets
covers: Excel 2007

Product Details
  • 236 Pages
  • Publisher: Holy Macro! Books
  • PDF ISBN: 1-932802-20-7

Learn Excel from the context of real classroom situations!

If you try to learn Excel from an accountant, you may know how to build a financial statement but will never learn how to build a gradebook. The problems in this book were developed by real classroom teachers to address needs in their classroom.

In the course of learning how to build a gradebook, classroom library database, match fact checker and more, you will learn every major feature in Excel.

The book can be used on three levels:

  • To get an introduction to Excel, download the 25 sample files and start using them in the classroom.
  • Read the chapter to understand how the file was built so that you can develop similar workbooks.
  • Advanced readers can delve into "Excel Details" sections in some chapters to learn deep features in the product. If you master all of the Excel details sections, you are on your way to being your school's guru in Excel.

Learn from 3 Teachers and MrExcel

About the authors:

  • Colleen Conmy has been a teacher since 1993. She currently is working as the Middle School Instructional Technology Coordinator at Kent Place School in Summit, New Jersey.
  • Bill Hazlett has over 30 years of high school classroom experience. After retirement, he now teaches algebra part time at the University of Akron.
  • Adrienne Soucy has 13 years experience in a first grade classroom. She currently is the reading specialist for at-risk students at Jimtown South Elementary in Elkhart, Indiana
  • Bill Jelen is MrExcel.
  • Introduction to Excel
  • Calculation Basics
  • Multiplication Tables - Introduces the concept of Absolute & Mixed cell references
  • Calculating with Time
  • Classroom Library
  • Grade Book
  • Attendance Records
  • Lesson Plan Sheets
  • Assign Book Reports in Random Sequence
  • Randomly Call on a Student
  • Tracking Student Information
  • Student Mailing Lists
  • Sort Class List by First Name
  • Reporting Long Term Test Results
  • Reading Grade Level Test Results
  • Tracking Proficiency
  • Creating Checklists
  • Requisition Forms
  • Printing Grid Paper
  • Creating Math Exercise Sheets
  • Homework Checker
  • Recording Rubric Data
  • Organizing Vocabulary Lists
  • Reading Journal
  • Demonstrating Fractions with Pie Charts
  • Presenting Survey Results with Bar Charts

Where to Buy

MrExcel Bookstore

eBook from MrExcel