in the
Classroom
Created by:
Talitha Hudgins
Table of ContentsMicrosoft Office in the Classroom Welcomes You
Getting Started
Syllabus
Credit Request Form
Section 1: Microsoft Word Overview
Word Processor and the Writing Process / 6
Views / 8
Revision Control
Collaboration Features / 8
Enhancing Collaboration / 8
Share Files / 8
Save as A Web Page / 8
Track Changes / 11
To Use Versions / 11
Layout and Design Features / 12
Newsletter-style Columns / 12
Insert Graphics / 13
Insert Symbols / 17
Headers and Footers / 18
Strategies for the Classroom / 21
Sample Projects / 21
Section 2 Microsoft Excel
Anatomy of a Spreadsheet / 25
Planning and Creating a Worksheet / 25
Basic Information of a Spreadsheet / 26
Entering Column and Row Titles / 27
Wrap Text within Cells / 28
Entering Numbers / 28
Basic Math Function / 29
Common Formulas / 29
Calculating a Sum / 30
Format Features / 31
Quick Tips / 31
Sort / 31
Filter / 32
Add Comments / 32
Use the Chart Wizard / 34
Create a Chart / 34
Drawing Toolbar / 34
Print Options / 35
Strategies for the Classroom / 36
Support Curriculum / 36
What if? / 37
Create a Self Test / 38
Compare Two Groups / 39
Show Change Over Time / 40
Standard Conversions / 41
Calories Group Work Problem / 42
Baseball Group Work Problem / 43
Section 3 Microsoft PowerPoint
PowerPoint in the Classroom / 46
Overview / 46
Presenter Tips / 46
Acquire Objects and Copyright / 47
Acquire Objects / 47
Strategies for the Classroom / 49
Managing a Student Project / 50
Higher Level Thinking Skills / 52
Multiple Intelligences / 53
Sample Presentations / 54
Storyboard / 54
Section 4 Microsoft Publisher
Publisher / 55
Student Projects with Publisher / 55
Design a Quick Publication / 56
Section 5 Microsoft Tools
Microsoft Tools / 58
Keystroke Commands / 58
Toolbar / 59
Screen Capture / 59
Using Help / 60
Section 6 UEN Tools
UEN Tools / 61
Lesson Plan Tool / 61
Rubric Tool / 61
Section 7 Web Sites
Websites / 62
Microsoft Office in the Classroom
Description
Designed with classroom use in mind, this course offers introductory training on Excel, PowerPoint, and Publisher, with some tips for maximizing your use of Word. Participants accumulate a “portfolio” of instructional plans that include sample student assignments or products created with Office software for use in the classroom. Software skills are presented in a context of strategies for effective educational application, and many examples of project-based learning and constructivist teaching are included. Together, participants discuss and explore all aspects of the learning process from setting the stage for learning through assessing students’ understanding. We encourage participants to come with core standards on which to base their instructional plans, and to incorporate critical thinking strategies and Internet resources along with the Office products in their activities.
Rationale
The curriculum of this four-day course promotes project-based learning and helps teachers see and practice ways to effectively integrate technology into their classroom. Using Office software effectively, personal productivity can increase for students and teachers, meeting ISTE National Educational Technology Standards for both groups. In addition, by creating instructional plans that teachers relate to state standards, technology is used to enhance student engagement in core concepts. During the class, teachers are encouraged to work in teams, problem-solve and learn by experiencing the benefits of collaborative learning.
Pre-requisites
Basic computer skills such as copy/cut/paste and save
Learning Outcomes
· Design an assignment that utilizes proven teaching and learning strategies and uses Office products to support student achievement of a curriculum-based learning goal.
· Demonstrate understanding of at least one strategy to use Office products to assess student learning.
· Evaluate student projects using a rubric.
· Excel skills: enter basic math formulas, format a spreadsheet, use the chart wizard to create a graph or chart, use efficiency features such as AutoFill and other shortcuts.
· PowerPoint skills: create slides of different formats, use drawing tools and templates, insert text, images, hyperlinks, audio and video.
· Publisher skills: use wizards to create and then customize graphically enhanced documents.
· Word skills: review efficiency features such as keystroke commands, learn to make and insert screen captures into Word documents.
Things to bring
Materials for note-taking and a blank CD or diskette for saving materials
Online Materials:
Microsoft Office Website:
http://www.microsoft.com/office/programs/default.asp
Interactive Software Tutorials from ActDEN
http://www.actden.com/index.htm
Putting the Power into the PowerPoint:
http://www.uen.org/utahlink/activities/view_activity.cgi?activity_id=7864
Credit
1 hour USOE credit
1 semester hour SUU credit
Points
28 licensure points
This class meets the following NETS for teachers
I. A & B, II. A, D, E, III. A, B, C & D, IV. A & C, V. A, B, C & D, VI. A, B & C
Assignment
Develop an instructional plan that has clearly stated state core learning goals. The unit plan needs to incorporate all the Office products learned. Use the UEN lesson plan tool for your instructional plan. Complete at least these required sections of the Lesson Plan Tool and others as needed.
· General
o Summary
o Curriculum Tie
o Publish lesson (display on Public my.uen page)
· Instructional
o Materials (attach MS Office files)
o Background (attach MS Office files)
o Instructional procedures
· Assessment
o Describe plan and/or associate a rubric
Email my.uen public address and ALL personal information and credit type from Credit Request Form to instructor.
Word Processor and the Writing Process
Word processing can be a powerful learning tool. Students who write using a word processor can easily outline then expand their ideas; request and consider grammar or spelling suggestions; revise as many times as necessary before printing; and even submit their electronic work to their teacher for edits. There are as many ways to use a word processor as there are types of writing assignments.
Teachers know that writing is a powerful learning experience for students. Weaving knowledge into written composition is often a more effective learning tool than listening to a lecture or reading. You can facilitate the writing process by using a Microsoft program. Word can help students overcome some of the obstacles in learning to write by providing tools that help enrich the diverse and complex writing process. In each of the different activities that make up the writing process—prewriting, composition, revision, and publication—Microsoft Word provides flexible support for the different ways of composing, and integrating tools that allow for peer-to-peer collaboration and mentoring. As students engage in these different activities they can also interact with other writers and secure feedback. As you teach students to write, Word has the capability to help organize these activities and to help students derive maximum benefit from them. Microsoft Word is also a compelling tool for harnessing the energy of your students’ writing processes to produce a dynamic, social writing-and-learning experience.
As you explore Microsoft word you will go through the process of:
· Creating a document
· Using the outline view and the document map;
· Revising your document while tracking changes and adding comments;
· Collaborating with your peers
· Saving documents to public folders and Web pages where additional comments and responses can be exchanged.
Views
Views in Microsoft Word
Word has several views including Normal, Web Layout, Print Layout, and Outline that are customized to focus on a particular set of formatting characteristics. Within any of these views, you can activate the document map, which allows quick navigation of your entire document by clicking on the appropriate heading in the map. Word also supports implementation of the Document Map as a navigation control in HTML format, allowing you to save your document as a frameset with navigation along the left side.
Outline View
On the View menu, click Outline or click Outline View in the lower left corner of the document window.
Your document will be shown in outline format. The outline can be expanded or collapsed by double-clicking on the plus symbols next to the major headings. The outline is based on the styles and indents that have been used in your document.
To display the Document Map
On the View menu, click Document Map. Clear the selection to hide the map.
After the map is displayed you can click anywhere on the map to move to that location in the document. Think of it as a clickable index of the entire document.
Revision Control
Revision is an activity that takes place throughout the writing process. Most authors are continually reviewing what they have just written and making large or small changes all along. Revision also takes place in formal stages as we publish a version of a composition, receive feedback, and then return to the document to do further work. Word contains two features that help writers manage this more formal aspect of the revision process, Versions and Track Changes.
Think of Versions as “snapshots” of a composition taken at various stages of the writing process. Saving Versions of your composition as you write enables you to retrieve information that you subsequently may have revised out of a document and to manage multiple drafts of a document for different audiences and purposes. The writer can also compare saved versions of the document.
The Word Track Changes feature allows multiple users to revise a document while retaining the original integrity of the document. When Track Changes is enabled, a reviewer’s proposed changes are highlighted in a particular color (each reviewer is identified in a different highlight color). You can see the reviewer’s name by pointing to the change. The originator of the document can accept or reject any proposed changes.
Collaboration Features
Enhancing Collaboration
Writing is inherently a social behavior. It works best as a learning tool when the writing process is rich with social interaction and possibilities for collaboration. There are a few important features of Microsoft Word 2002 in creating writing as a collaborative process, for instance saving documents as a Web Pages.
Share Files
Consider exploring a bit further and crafting writing assignments that ask students to work together in small groups as they generate text. Time-on-task goes up as students negotiate the composition process with one another; they spend more time thinking about and talking about the core issues of your class.
Although you may find that students struggle to work effectively with peers, keep in mind that co-authorship is the rule and not the exception outside of the classroom and that many education scholars contend that peer-to-peer interaction with respect to academic tasks (like writing) is the most important factor in successful outcomes in college.
Save as a Web Page
To save as a Web Page go to File Menu, scroll down to Save as Web Page, click Save. The page is now a web document that may be up loaded to a school Web site or your own.
Track Changes
MS Word offers a chance for teachers to track students writing.
Tracking changes in a document allows you to make revisions to a document without losing the original text. When you track changes, Word shows changed text in a different color from the original text and uses revision marks, such as underlines, to distinguish the revised text from the original text. To preserve the layout of your document, Word also identifies the change and its type, such as a deletion, in a balloon that appears in the margin of the document. By default, Word underlines and changes the color of inserted text. It also includes a vertical changed line in the margin to the left of any changed text to help you locate changes in the document.
How to Track Changes
· Turn Track Changes On:
o Go to the View menu, then toolbars. Select Reviewing.
o Then click the Track Changes button. Any changes that you make are now indicated by revision marks.
o When track changes is turned on, the Track Changes button has a blue border, and the letters TRK are highlighted on the status bar; when track changes is turned off, the Track Changes button has no border, and TRK is gray on the status bar.
· To Make Changes and Add Comments:
o If you have text/words you no longer want on the document, select the text and press delete. Word inserts a callout that describes the change. For example, if you deleted the text, the quick brown fox, you will see a callout that says: Deleted: The quick brown fox.
o NOTE: If you do not see the callout, you may be viewing your document in normal view. Go to the View menu, switch to print layout view to see the callouts.
o Rest the mouse pointer over the text that you deleted. In addition to the callout, Word marks the deletion with a ScreenTip. If you rest the mouse pointer over the deletion, the ScreenTip tells you the name of the person who made the change, when the change was made, and the type of change that was made. In this case, the ScreenTip displays Deleted.
o If you have text you want to add to your document, click where you want the text to appear and type the text. Word inserts the new text in a different color font. The color differs for each person who makes changes to a document when track changes are turned on.
o Rest the mouse pointer over the text that you added. A ScreenTip tells you the name of the person who made the change, when the change was made, and the type of change that was made. In this case, the ScreenTip displays Inserted.
o On the Insert menu, click Comment. If you selected text and then inserted a comment, Word marks the selection with large colored parentheses. If no text was selected when you inserted a comment, the location is marked by a colored vertical bar. A callout appears in the margin of the document. The callout describes the type and content of your change. For example, if you add a note or an annotation to your document, the callout says, Comment: followed by the note or annotation text.
o Rest the mouse pointer over the comment that you added. A ScreenTip tells you the name of the person who made the change, when the change was made, and the type of change that was made. In this case, the ScreenTip displays Commented.