Publishers of Materials that Help People Learn

 

Microsoft Office Excel

        2007        or     2003        (for Windows)

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 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

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

 This was a very well organized and helpful class.  In fact, out of all the classes I have taken through the distance learning program at Adams State, this is the one that has been the most beneficial to me.                                      GREAT Class!                                                                                                                                                               Laura V.

 

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.

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 – 2010 - 2011

Participants need to register for a specific session, but no later than 2 weeks into the session:

Session 1 - Fall                     August 31 –  November 20, 2010

Session 2 - Spring                                 January  5 – April 22, 2011

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 teacher.

 

 

 

 

 

 

Are you a tech rookie and maybe a little fearful of learning to use Microsoft Office for PC’s?

The Technology Boot Camp lets you develop skills in Microsoft Word, PowerPoint & Excel to strengthen your tech skills and your confidence in using technology to help your students learn.

Save $75 over the tuition for three individual courses! See “Other Courses” page for details