Excel For Teachers (with 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

Download here

Password:knowfree.net