Microsoft Excel for Teachers (Part I)

Learn how useful spreadsheet programs like Microsoft Excel can be in your classroom. This program can help you perform calculations and create charts and graphs based on your data. Teachers can use Excel to calculate student averages and automatically assign letter grades.

By the end of this activity, you will have learned:

  • how to input/format/organize data into a spreadsheet
  • how Excel can perform basic calculations and functions (averages, sums, and more)

Agenda/Directions:

Learn basic Excel terminology

Formatting cells

Adjusting column width

Functions and formulas (sum, average)

Sorting data

Shortcuts: Automatic Fills

Activity: Create an electronic grade book using Excel

Activity: Create a budget