Spreadsheets for Physical Educators
This is the official site for Spreadsheets for Physical Educators via the Internet sponsored by Bonnie's Fitware, Inc.
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.
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
-Create and design a spreadsheet for a professional use
Mohnsen, B.S. (2008). Using technology in physical education, 6th edition. Cerritos, CA: Bonnie's Fitware.
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. Lessons will be posted on the date noted.
|
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 |
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.