There are other courses out there that will help people in business figure out how to use Microsoft Office applications.

FRESH PERSPECTIVES offers these courses for you in your role as a classroom teacher.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Introduction to Microsoft Excel for the Classroom Teacher                 

This course is designed for the teacher who has had limited or absolutely no experience using a computer-based spreadsheet program. It’s time to get over any “spreadsheet-phobia” you may be harboring.

During this course, you will:

Learn how to create a new Excel spreadsheet, format, edit, save it AND remember where you saved it so you can get back to it again.

To accomplish that, you will …

Be invited to get comfortable in the Excel environment to explore ribbons and tabs OR menus, toolbars, keyboard and RIGHT CLICK options, headers and footers, as well as to understand defaults and how to change them – this includes learning the language and vocabulary of Excel

Create several documents that you can use in your own classroom or teaching situation (such as inventories, class lists, grade sheets, seating charts, rubrics, etc.) to help you learn how to collect, organize, analyze and present both text and numeric data

Learn to use formulas and functions to automatically update mathematical calculations

Learn to apply formatting to data cells, rows and columns to help turn “data” into useful “information”

Learn to create charts that will help you capture and communicate the key relevant information contained in the data

Learn a variety of printing options

 

There are no prerequisites for this course, but you will need to have Microsoft Excel 2007 or 2003, Microsoft Word 2007 or 2003 and Adobe Acrobat Reader on your computer.

This course targets NETS-T 1, NETS-T 4, and NETS-T 5.

 

 

This Excel class has been great.  The pictures that were provided made it very easy to follow.  I feel very comfortable using the formulas and inserting a graph or chart.  These are two things that I had never done before.  I now know how large one spreadsheet can be and that many different tabs can be added to help organize the material.  I can’t wait to get started on creating my grade book and using all of the new skills that I have learned.

Shannon K

 

 

Intermediate Excel for the Classroom Teacher            

This course is designed for the teacher who has had some experience using the Excel spreadsheet program.

During this course, you will …

Learn the following: additional work with functions (e.g. IF, COUNTIF, ANDIF), arguments, inserting comments, AutoFormat and Format Painter, header footer, additional chart features and lines, AutoComplete, Auto Insert, style shortcuts, row/column conversions,  outlining a worksheet,  additional options with graphics,  creating and formatting professional looking charts, calculating and  analyzing data, working with multiple worksheets, finding sorting and filtering data, advanced formatting, working with text boxes and WordArt, etc.

Learn to create additional spreadsheets relevant for your grade level (elementary, middle level or senior high), incorporating pictograms, clipart, photos, diagrams, budgets and other samples for classroom usage, such as a rubric to guide the development of and evaluation of student-created spreadsheets and charts.

Learn a variety of spreadsheet activities that you can have your students create as part of your core instruction

Learn strategies for helping you get your students

to predict the impact of additional data being added into a spreadsheet,

to develop appropriate data collection and analysis techniques

to learn how to ask the right questions to elicit useful information from the data

 

Solid comfort in using Excel is a prerequisite for this course. You will need to have Microsoft Excel 2007 or 2003, Microsoft Word and Adobe Acrobat Reader on your computer

This course targets: NETS-T 1, NETS-T 2, NETS-T 4, NETS-T 5, and NETS-T 6.

 

I have to say that this is one course where I can use so much from what I learned, not only for myself, but for my students.  As a math teacher, I can show my students how to create formulas, charts, and tables, predict patterns, collect, organize, customize, and analyze graphs.  The possibilities are endless. 

Dora G

 

Advanced Excel for the Classroom Teacher                

This course is designed for the middle level or senior high math or science teacher who is solidly grounded in the Excel spreadsheet environment.

During this course, you will:

Learn the following: function tips and arguments, exponents, “watch formulas”, hyperlinks, pivot tables, inserting and/or constructing advanced functions for trigonometric and statistical data manipulation and analysis, additional work with relative and absolute references, variance, results analysis, logical values, functions/formulas and meaning, errors and troubleshooting, calculating and analyzing data, using Excel database tools and VBA.

Learn strategies for using the Tablet PC, the digital projector and Excel to actively engage students in your core content

 

A solid foundation in Excel is the prerequisite for this course. You will need to have Microsoft Excel 2007 or 2003, Word 2007 or 2003 and Adobe Acrobat Reader on your computer.

This course targets all six of the National Educational Technology Standards for Teachers.

 

I finally understand the PivotTable. Hurray! The pivot table will help to show the student data in a variety of ways. … I feel that I have created a useful tool to aid my students in their academic pursuits.

Chris F

 

Sessions

Session 1 - Summer       June 2 –July 11, 2008

Session 2 - Summer       July 14 – August 22, 2008

Session 3 - Fall               October 6 – November 14, 2008

Session 4 - Fall               October 27 – December 5, 2008

 

Session 5 - Spring          January 5 – February 13, 2009

Session 6 - Spring          February 16 – March 27, 2009

 

 

 

Microsoft EXCEL 2007 and 2003

course offerings

Helping Teachers Enhance Student Learning

through Effective Use of Technology