1. No category

Presented by Barry G. Haines
Morris County Technology Fellowship Recipient
Morris County ETTC – http://www.mcvts.org/ettc/ettcpage.htm
Barry Haines – Templates for Success –
http://www.barry.haines.net/templates.html
New Jersey Professional Development Provider #2069
Certified Technical Trainer
Microsoft Office Classroom Tools
[email protected]
1
After inserting the Microsoft Office Classroom Tools, you should see this screen:
followed by this screen: Click Next>
Then Yes. At the next screen make sure you have the following checked:
Microsoft Office Classroom Tools
[email protected]
2
You may also choose to install all of the clipart off of the CD by scrolling down, but this
is not necessary (see pages 8-9).
Then click Next> and allow time for the installation.
Finally, click “Finish.”
Now when you click on the Start menu and choose Programs, you should see the
following menu:
.
Microsoft Office Classroom Tools
[email protected]
3
Alternately, you may download the Microsoft Office Classroom Tools from the
Internet
Go to:
http://www.microsoft.com/education/product/cdoffer.asp
Scroll to the bottom of the page and download your choice of:
New and Improved Teacher Tools: More than 40 timesaving
templates for teachers, including an improved grade book, tests, a
calendar, and lesson plans. (3,715 Kb)
•
New and Improved Student Tools: 30 templates for students,
including reports, lab sheets, graph paper, and conversion tables. Plus
5 new templates like the Change Making Game. (3,434 Kb)
•
New and Improved Administrative Tools: 11 templates for
administrators including Field Trip Permission Slip, Schedules, and
Seating Chart. (1,601 Kb)
•
Easier to Use Classroom Activities: Step-by-step classroom
activities that let students integrate Microsoft Word, Excel, PowerPoint,
and reference materials as they explore subjects such as state
histories, endangered species, and voting behavior. (1,440 Kb)
•
To Download the Microsoft/Scholastic Lesson Plans,
Additionally there are 4 great books full of useful classroom lesson plans for integrating
technology in your classroom. They are found at:
http://www.microsoft.com/education/lesson/productivity/index.asp
You will need to install Adobe Acrobat onto your machine.
Enjoy!
Some of the many teacher templates available in MS Word.
Microsoft Office Classroom Tools
[email protected]
4
Office Classroom Tools Overview
Introduction
Welcome to the Office Classroom Tools. These templates and classroom activities were
designed to show how Microsoft Office applications (Word, Excel, PowerPoint, Access)
could be integrated into the classroom. The purpose of this Help file is to provide an
overview of this CD-ROM.
After the Classroom Activities section, you’ll find details about other components on the
Office Classroom Tools CD
How to Use Classroom Activities
Each Classroom Activity includes a Help File and one or more Office (Word, Excel,
PowerPoint, Access) template(s). In order to use the template files, you must use the
Help file at the same time, or print out the Help file.
If you’re using Office 97, follow these steps to access the activities:
1. Click the Start menu, click Programs, and then click Microsoft Office Classroom
Tools.
2. Each activity includes both a Teacher Guide and a Student Activity. You can print the
Help topic for either section.
3. The Help file is designed to stay on top the associated templates are launched by
clicking a link in the Help file.
Classroom Activities
All About Me
Applications: PowerPoint, Word: Language arts
Discipline: Social studies
Level: Intermediate
Description: In this lesson, students create and deliver an autobiographical,
multimedia presentation.
Buy Low, Sell High
Applications: Word, Excel, PowerPoint:
Discipline: Math, Economics,
Level: High school
Description: Students learn how to invest in corporate stocks by creating
investment “portfolios,” tracking stock performance, and reporting their results.
Campaign Hot Buttons
Applications: Word, Excel:
Discipline: Language arts, Social studies, Science
Level: Middle school, High school
Description: Students design, administer, and analyze a simple poll on the issue
of water quality. Poll results are used to develop a position statement and
persuasively present a stand on the issue.
Candy Is Dandy
Applications: Word, Excel:
Discipline: Geography, Language arts, Social studies
Level: Intermediate, Middle school
Microsoft Office Classroom Tools
[email protected]
5
Description: Students learn the benefits of using graphs to communicate
information and solve problems as they investigate color distribution in bags of
M&M candies.
Celebrate the USA
Applications: Excel, Word, PowerPoint
Discipline: Geography, Language arts, Social studies
Level: Middle school
Description: Working in teams of four, students take on the role of marketers
hired to promote one state in the United States. Each team will research a state
and create a brochure.
Code Crackers Game
Applications: Excel
Discipline: Math
Level: Intermediate, Middle school
Description: This engaging and challenging math game provides students with
opportunities to work with math operations and simple algebraic equations by
creating a spreadsheet-based “rule machine.”
Don’t Trash the Earth
Applications: Excel, Word, PowerPoint
Discipline: Science, language arts, math
Level: Intermediate, Middle school
Description: Students learn about recycling as they collect data on their own
household trash production, analyze and chart the data, and present their
findings.
Endangered Species
Applications: Word, PowerPoint, Access 97
Discipline: Science, Language arts
Level: Intermediate, Middle school
Description: In this cross-curricular activity, students research endangered
species and their habitats. The class can add its research to an Access 97
Endangered Species database.
Get Out the Vote
Applications: Word, Excel
Discipline: Social studies
Level: Middle school, High school
Description: Students investigate why people do or don’t vote. Students conduct
a survey, make hypotheses about voter motivation, and develop materials to
promote voting among young people.
Nutrition Track
Applications: Excel, Word
Discipline: Health, Math
Level: Intermediate, Middle school
Description: Students create a food diary, and then chart and analyze their diet
as compared with the USDA recommended allowance for each food group.
Microsoft Office Classroom Tools
[email protected]
6
Templates used in each Activity
Links to these files are included within the Help files. If you are not running the Help file
simultaneously, you will need to print out the Classroom Activity Lesson files, and
launch these files.
Endangered Species: Endangered Species Examples, Endangered Species Note,
Endangered Species Slides, Endangered species database, Endangered Species
Buy Low Sell High: Stock Results, Stocktracker
Campaign Hot Buttons: Water Quality Poll, Poll briefing, Water Quality Data
Get Out the Vote: Voting Survey, Voting patterns, Target a strategy, ,
Celebrate the USA: Newsletter Wizard, State project
Don’t Trash the Earth: Recycling Flyer, Trash Stats, Don’t trash the earth
All About Me: All About Me Slides
Code Crackers Math Game: Code crackers math game
Candy is Dandy: Candy hypothesis, Candy is dandy
Nutrition Track: Nutrition Results, Nutrition Worksheet
Teacher Tools folder (templates & wizards)
Brochure.dot, Word: Create a school brochure layout.
Calendar, Excel: Keep track of weekly and daily events.
Calendar.wiz, Word: Get help from a wizard to create monthly classroom calendars.
Certificate, Word, PowerPoint: Create a Student of the Month certificate; or a
certification of appreciation.
Class Welcome, PowerPoint: Create a “welcome” presentation for students, parents,
or staff.
Conversion Tables, Excel: Do conversions for linear, area, temperature, nautical, and
liquid/dry measure.
Fundraising, Excel: Keep track of budgets, donations, pledges and volunteer lists.
Grade Book, Excel: Keep track of class grades. Choose from two different gradebook
templates.
Graph Paper, Excel: Use online or print graph paper of varying sizes.
Lesson Plan, Word: Tab through this Word form and enter your own lesson plan.
Lists & Charts, Excel: Keep track of different types of information in a list.
Newsletter Wizard, Word: Step through creating an outline for your class or school
newsletter.
Schedules, Excel: Keep track of classroom, period, and work schedules.
Staff Development, PowerPoint: Use to create a staff development or training
presentation. Replace the sample text.
Tests, Word: Choose from an essay, true/false, or multiple choice test format.
Thesis, Word: Create a layout for a thesis.
Microsoft Office Classroom Tools
[email protected]
7
Student Tools folder (templates & wizards)
Brochure, Word: Create a school brochure layout.
Calendar , Excel: Keep track of weekly and daily events.
Calendar Wizard, Word: Get help from a wizard to create monthly classroom
calendars.
Certificate, Word, PowerPoint: Create a Student of the Month certificate; or a
certification of appreciation.
Conversion Tables, Excel: Do conversions for linear, area, temperature, nautical, and
liquid/dry measure.
Graph Paper, Excel: Use online or print graph paper of varying sizes.
Lists & Charts, Excel: Keep track of different types of information in a list.
Newsletter Wizard, Word: Step through creating an outline for your class or school
newsletter.
Schedules, Excel: Keep track of classroom, period, and work schedules.
Thesis, Word: Create a layout for a thesis.
Designs folder (PowerPoint templates)
Bluemoon.pot
Brownbag.pot
Buttons.pot
Clipbord.pot
Gavel.pot
Linepapr.pot
Mountain.pot
Wetsand.pot
Numbers.pot
Quill.pot
Rules.pot
Soaring.pot
Stick Figure.pot
Theater.pot
Microsoft Office Classroom Tools
[email protected]
8
ADDITIONAL CLIP ART
Microsoft Office 98 must have been installed with the "Clip Art Gallery" component for
this clip art package to work correctly.
INSTALLATION TO LOCAL HARD DISK
In order to be able to install this clipart, you will require 200MB of free space on your
hard disk.
After using the CD-ROM installation, you must manually insert the clip art package into
the clip art gallery to make it available to the user. To do so:
1. Start Microsoft Word (or Excel/PowerPoint).
2. With a new document, choose Insert|Picture|Clipart from the menu.
3. Once the Microsoft Clip Gallery opens, click Import Clips
4. Change the “Files of type” to Clip Gallery Catalogs
.
5. Browse to the Clip Art Gallery file you wish to add and choose open.
You may wish to open the CD, or find the clipart package on the C:/ drive
Microsoft Office Classroom Tools
[email protected]
9
The clipart package will have a .cag and will probably look like the following.
It should read moct99.cag
6. Click Import, then OK
7. Close the Microsoft Clip gallery.
8. Choose Insert|Picture|Clipart again from the menu.
9. When Microsoft Clip Gallery opens the new images will be available.
Microsoft Office Classroom Tools
[email protected]
10
The 2nd Classroom CD contains over 100 lesson plans which you may access one of
two ways as follows:
1) After inserting the 2nd CD, click Classroom Resources
then click “Productivity in the Classroom” at the bottom of the page.
You may then search for an discipline based lesson plan.
2) After inserting the CD, CLOSE all open windows, right click on the CD icon and
choose EXPLORE.
Double click “Classroom,” then “Docs” then
click on one of the following 4 files:
Microsoft Office Classroom Tools
[email protected]
11
Microsoft Word Processing Basics. Select and Take Action!
______________________________________
Name
___________
Class
GOAL
To practice basic word processing skills in Microsoft Word. When working in a word
processing program remember to think in two parts: 1) Select 2) Take Action!
Why might you want to select text? To delete it, resize it, change the text font, color, or
style.
Selecting Text
Using click and drag:
• Click and drag over the text
• Double click on a word
• Triple click in a paragraph to select the paragraph
Using the selection bar
Move your mouse to the left boarder so that it turns into this type of icon.
Then,
• click once -- to select a line of text
• click twice -- to select a paragraph of text
• click three times – to select the entire document.
• click and drag in the selection bar -- to select any amount of text
To select a vertical block of text hold the (Alt) key and drag across the text.
Taking Action!
There are at least three ways to modify your text. The formatting toolbar, the Format
font menu, and by right clicking on the selected text.
1) Use these buttons on your formatting toolbar to modify your text.
Style
Font Style
Bold, Italic, Underline
Fonts
Numbers &
Bullets
Indents
Font Size
Microsoft Office Classroom Tools
Highlighter
[email protected]
Align
Left, Center, Right
Justify 12
2) The formatting font menu
Open the font formatting menu to make additional changes. Click on the Format menu
at the top of your document. Then choose Font. . .
Explore all of these different fields. Preview your choices in the lower right.
3) Right click on the selected text and you will see a shortcut pop-up menu.
Click on the word Font and you will see the same font menu as above.
Microsoft Office Classroom Tools
[email protected]
13
Inserting and Editing ClipArt and Graphics in MSWord or Powerpoint
_____________________
____________
Name
Class
l
l
1
GOAL:
To insert a clipart (.wmf or .bmp), or picture (.jpg or .gif) file into a PowerPoint
or Microsoft Word document.
To learn graphic editing techniques.
Steps:
1. Open Microsoft Word (or Powerpoint). Click Start/Programs/Applications/MSWord
Note: you may open an existing file, or a new file.
2. Place your blinking cursor where you want the picture or clipart inserted.
3. Click Insert: Picture
Clip Art (*.wmf, or *.bmp files)
4. Select Clip Art to get the Clip Art Gallery.
OR Pictures (*.jpg, or *.gif files) – graphics from the internet
5. Select from file
to point your computer at a graphics file saved back to your computer from the
Internet.
Example:
Microsoft Office Classroom Tools
[email protected]
14
Inserting and Editing Graphics in MSWord and Powerpoint
After selecting a piece of ClipArt, or Picture from the Inernet to insert:
6. Click “Insert”.
Your clip art will appear in your document.
7. Click once on the object to see “handles.”
8. Move – the object when you see the four sided arrow, click and drag to move the
object.
9. Resize - Move your mouse until you see a double-sided arrow. This allows you to
resize the object.
PICTURE TOOLBAR
10. Crop – Click once on the crop tool, then move your mouse to one of the handles
and click and drag to make the object size cropped larger or smaller.
Note: If you don’t see the Picture Toolbar, click View:Toolbars: Picture
Microsoft Office Classroom Tools
[email protected]
15