Spreadsheets for Physical Educators

Registration Form / Online Registration

 

Welcome

This is the official site for Spreadsheets for Physical Educators via the Internet sponsored by Bonnie's Fitware, Inc.


Course Description

This course is designed to introduce physical educators to the use of spreadsheets for teacher productivity and instruction. Participants will complete the course with intermediate skills in the use spreadsheets. They also will learn practical applications for desktop spreadsheets as well as handheld spreadsheets in physical education.


Course Objectives

Participants will be able to:

-Design an electronic budget using a spreadsheet

-Design an electronic inventory using a spreadsheet

-Design an electronic grade book using a spreadsheet

-Design an electronic fitness report using a spreadsheet

-Design an electronic mileage chart using a spreadsheet

-Describe the use of spreadsheets in the instructional process

-Create and design a spreadsheet for a professional use

 
Textbooks and/or Other Materials

Mohnsen, B.S. (2012). Using technology in physical education, 8th edition. Big Bear, CA: Bonnie's Fitware Inc.

 


Course Sessions

To complete the requirements for the session click on the module (available once you register for the course), then read the presentation and complete the learning activities.

I.

Introduction to spreadsheet programs for desktop and handheld computers

II.

Learning the basic layout and operations in spreadsheets; inventory and budgets

III.

Learning to use basic functions in spreadsheets: average, sum; making charts;mileage summary

IV.

Learning to use intermediate functions in spreadsheets: count, max, min; grade book

V.

Learning to use intermediate functions in spreadsheets: lookup, if; fitness reports

VI.

Creating a practical spreadsheet for your own use

 


Methods of Evaluation

For those taking the class for any type of credit - specifics will be explained as we progress through the course.

1. Completion of   6 online modules.

2. Create the following assigned spreadsheets: inventory, budget, mileage charts, grade books, and fitness reports.

3. Describe the use of spreadsheets in the instructional process.

4. Create a spreadsheet based on a professional need.

 


For additional information, contact: Bonnie Mohnsen, Ph.D.