Excel For Teachers (with source code)

Author(s) : Colleen Conmy, Bill Hazlett, Bill Jelen, Adrienne Soucy
Publisher : Holy Macro Books
Year : Jan 2006
ISBN 10 : 1932802118
ISBN 13 : 9781932802115
Language : English
Pages : 236
File type : PDF
Size : 20.7 MB (book + source code)

There are endless tasks that can be made easier with Excel. Excel can
be used to track classroom management from grade books, class rosters,
attendance, testing results, assessment measurement charts, and more.
Excel can be used as an aide in teaching. Use Excel to generate random
fact worksheets. Use Excel to create graphs to help teach math
standards. Finally, your students can use Excel to develop models and
homework.

The concepts in this book apply equally well to every version of Excel
from Excel 97 through Excel 2003. As this book goes to press, pre-beta
copies of Excel 12 are available. I’ve reviewed these and many
concepts will be different in Excel 12. While Excel 12 threatens to
make every Excel book obsolete, most public school districts are in
financial trouble and will not be upgrading to Excel 12 soon. If you
happen to live in a district that upgrades to Excel 12, check the
aforementioned web page for information about an e-book upgrade for
Excel 12 users.

We will assume that you have Excel 97 or newer running on Windows or
Macintosh. You should know how to start Excel and navigate from cell
to cell.

TABLE OF CONTENT:
Chapter 01 – Calculation Basics
Chapter 02 – Multiplication Tables
Chapter 03 – Calculating with Times
Chapter 04 - Classroom Libraries
Chapter 05 – Grade Books
Chapter 06 – Attendance Records
Chapter 07 – Lesson Plan Sheets
Chapter 08 – Random Sequence for Book Reports
Chapter 09 – Randomly Calling on a Student
Chapter 10 – Tracking Student Information
Chapter 11 – Student Mailing Lists
Chapter 12 – Sorting Class Lists by First Name
Chapter 13 – Reporting Long Term Testing Results
Chapter 14 – Reading Grade Level Test Results
Chapter 15 – Tracking Proficiency
Chapter 16 – Creating Checklists
Chapter 17 – Requisition Forms
Chapter 18 – Printing Grid Paper
Chapter 19 – Math Exercise Sheets
Chapter 20 – Homework Checker
Chapter 21 – Recording Rubric Data
Chapter 22 – Organizing Vocabulary Lists
Chapter 23 – Reading Journal
Chapter 24 – Demonstrating Fractions with Charts
Chapter 25 – Bar Charts

Code:
http://rapidshare.com/files/116456846/exceforteac.rar

password:ganelon