Worcester Diocese Professional Development Training

 

Integrating MS Office into the classroom

Facilitator: Brett Penza

 bpenza@holyname.net

 

 

Objective:  Class participants will be shown how to effectively port information across each of the popular Office Applications to produce innovative classroom lessons. Activities will include:

 

WEEK I:  Mail Merging a DataBase (Word & Excel)

·                    Student Progress Reports

WEEK II: Using Math Tables (Word & Excel)

·                    Baseball Statistics Lesson Plan

WEEK III: Outlining a Lesson Plan (Word & Powerpoint)

·                    Bring an Outline Document to Life in PPT

WEEK IV: Word, Excel, and Powerpoint as Web Tools

·                    Creating Quick, Effective Web Tools.

FINAL: Classroom Presentations (Word, Excel, & Powerpoint)

·                    Final Project:  Classroom Lesson Plan.

 

Pre-requisites:  Working knowledge of Word, Excel and Powerpoint.

Presenter: Brett Penza

Location: Holy Name High School

Dates: Tuesdays, October 2, 9, 16, 30. (23rd is diocesan pd day)

Time: 2:30 – 4:30 PM

 

WEEK I.

 

Mail Merging a DataBase (Word & Excel)

 

The Problem:     It is progress report day.  You have a grade book with grades and comments for all your students.  You have to produce a document to send out to every parent and guardian stating their child’s performance. You can figure every average, write out every report or you can do a MAIL MERGE.

 

The Steps:

1.      Create an EXCEL SPREADSHEET with the following layout

Last

First

Quiz

Test

Cls Part

Comment

 

2.      Enter 10-12 student names with grades and comments.

                       

Last

First

Quiz

Test

Cls Part

Comment

 Edwards

 Joe

 75

 81

 80

 prepare a bit more.

                                                           

3.      Save the sheet as “studentdata.xls”.

 

4.      Now open MS/Word and create a “progress report” shell-letter addressed to parents/guardians:          

 

East Overshoe High School

123 ABC Drive

Worcester, MA  01604

 

August 24, 2007

 

Dear Parent or Guardian:

 

It is our policy to update you on the progress of your child during the midpoint of the quarterly grading period.          is currently holding the following grades:

 

   Tests:                                   Quizzes:                             Class Participation:          

 

 

I hope you understand that I am always available to discuss the status of        ‘s  progress.   If you have any questions or concerns, please do not hesitate to call or e-mail me.  Thank you.

 

Sincerely,

 

Mr. Penza

 

 
 
 

 

 

 


·                    Student Progress Reports

5.                                          Now Coordinate the Mail Merge

 

 

 

 

 

 

 

 

 

 

 

                        5. MAIL MERGE

                              a. Tools-Letters and Mailing- Show Mail Merge Toolbar.

                              b. Click Main Document Setup icon on Toolbar.

                              c. Click Open Data Source Icon, choose the Excel “gradebook”.

                              d. Position cursor to location in doc.  Click merge field icon and

                                    select required column heading field.

                              e. When all fields are selected, click “abc” icon to view all merged                                       fields.

                              f.  If letter looks good,  click on icon to merge to new document.

Things You’ll Learn:

 

·        Basic Understanding of a Database.

·        Text Codes in Word.

·        Connecting Database to Word Doc.

·        Mail Merge Process.

 

Project Work:

·        Try to recreate the concepts on your own computer.  Find other purposes for a Mail-Merge.  Some Ideas:  A Class Trip Announcement to Parents, A Show or Concert, Class Expectation Letter.

 

WEEK II.

 

Integrating Math w/ Word & Excel

 

The Problem:     How do we give the students a sense of “purpose” as they develop wordprocessing and spreadsheet skills?  Here is a lesson plan that has proven to be effective in the classroom.  It integrates Mathematics with Word, Excel and Powerpoint.  The students will perform some advanced functions as they enter the world of baseball statistics.

 

The Steps:

 

Use the following lesson plan:

·                    Baseball Statistics Lesson Plan

 

Once a good understanding has been built using Excel.  Have the students write a short memo to the Dodgers General Manager, explaining why certain player contracts should be extended.   Have them cut and paste the Excel information to support the opinion.

 

Things You’ll Learn:

 

·        Application and Discipline Integration Ideas.

·        Copy/Paste from Web to Excel.

·        Data-Sort-Filtering.

·        Column Manipulation.

·        Formulas- +,-,  * , / , Average.

·        Absolute, Relative Formulas.

·        Copy/ Paste Techniques from Excel to Word.

 

Project Work:

·        Begin to think about how you could incorporate the Office Products to create your own interactive lesson plan.   This is the basic idea behind a WebQuest and MS/Office is an easy way to get this done.

 

WEEK III.

 

Word Outlines to PowerPoint Presentations

 

The Problem:     You have outlined a Chapter or Unit using MS/Word.  All your notes are intact.   Now, you want to present the material to your class.  Here’s how you can quickly convert all those notes to Powerpoint to make presentations to the class

 

The Steps:

 

·        MS/Word in VIEW-OUTLINE.

·        Manipulate each line to appropriate Levels.

·        File-Send-Powerpoint.

·        Background selection.

                       

 

Things You’ll Learn:

 

·        Outlining View in Word.

·        Adjusting Levels .

·        Importing from Word to Powerpoint.

·        Powerpoint Tips:

2.      Background selection.

3.      Page Numbering.

4.      Master Slide Technique.

5.      Picture Import.

 

Project Work:

·        Take a topic or lesson that you are currently teaching.  Create a quick  outline in Word, then convert to Powerpoint.  Once in Powerpoint, dress up the presentation with a Master Slide (Numbers/ Date/Author/Class), Background, Effective Pictures.

 

 

WEEK IV.

 

Word, Excel & Powerpoint as WebTools

 

The Problem:     We have heard much about WEBQUESTS. Perhaps we have even used some of them in class.  But how do we create our own WEBQUESTS? How do we publish them on the internet for all to use? 

                           In this lesson we will examine one of the many ways to develop Webquests using the MS/Office products.  We will also investigate several Internet sites that provide free storage.

 

The Steps:

 

·        Saving Word/ Excel/ PPT Documents as Web Page. ( the .html extension)

·        Investigating several options for FREE WEB Storage.

 

http://geocities.yahoo.com/        Microsoft Office Live        Bluehost.com

 

Things You’ll Learn:

 

·        Creating Web Pages through Office.

·        Identifying the elements folder that is created.

·        Learn about FREE or Low Cost Web Providers.

·        Uploading/ FTP your finished work.   

·        Importance of the index.html file.

 

Project Work:

·        You now have all the tools necessary to begin building your own library of WEBQUESTS through your knowledge of Office Products.  As your final project,  use one of your existing lesson plans or create a new one that you can easily adapt into a WEBQUEST.  Put it to use in your classroom and enjoy the fruits of your labor!

 

                              Examples:

                              Webquests