EDUC 540 - Educational Technology: Microsoft Office Assignments

Date Due: January 25 (note extension!)

Create products using the tools below. See atomiclearning.com or internet4classrooms for ideas related to the different tools, and bring those into the discussion of your tool if mentioned in the book.

When you demo products for the class, you will explain any special problems, hints for use (both your own ideas and the text), etc. that you discovered. Each person should turn in a word processed assessment of selected products, discussing the process used to develop the product, any problems or interesting new features discovered, and other ideas for lessons using that tool.

Requirements for tools are listed below:

Products

Click on each assignment for specifications and support.

Word processing

Choose two of the following:

1. Formatted Resume
2. Letterhead
3. Quiz Master
4. One use for delivering curriculum

Powerpoint

Choose one of the following:

1. Linear lecture aid
2. 10 screen non-linear multimedia product for delivering curriculum

Spreadsheet

Choose one of the following:

1. Gradebook with weighted grades
2. Two classroom exercises
3. Two uses for delivering curriculum
4. Mail Merge

Specifications

Word processing - Formatted Resume

• 1 page minimum
• Header and footer containing Name (header) and Page Number (footer)
• Different header and footer on first page
• Use of styles to format
• Bullet lists, indents, tabs and/or other formatting techniques
• Online Resources
  • Entering and editing text
  • Headers and Footers
  • Bullets
  • Borders and shading

Word processing - Letterhead

• Template that includes your school name, formatting, page numbers, etc.
• Document is ready for content to be added
• Saved as "stationary"
• Online Resources
  • Entering and editing text
  • Headers and Footers
  • Bullets
  • Borders and shading

Word processing - Quiz Master

• Template that includes your school name, formatting, page numbers, etc.
• Document is ready for content to be added
• Saved as "stationary"
• Includes formatted answer areas using "dingbats" and tabs with leaders
• Online Resources
  • Entering and editing text
  • Headers and Footers
  • Bullets
  • Borders and shading

Word processing - One use for delivering instruction

• Fully formatted document(s) to support instruction
• Should relate to your discipline
• Online Resources
  • Microsoft Tutorials (search for Word)
  • Teach-nology Lesson Plans (search for Word)
  • Creating a newsletter

Spreadsheet - Gradebook with weighted grades

• Labels for all columns
• At least 4 tests
• At least 2 assignments
• All tests and assignments must be graded on 100 point scale
• At least 3 different weights (i.e. final test worth 20% of grade, assignment 2 worth 5%, etc.)
• Final grade shown on 100 point scale
• Online Resources
  • Gradebook Basics
  • A List of Online Resources for Excel Gradebooks

Spreadsheet - Two classroom exercises

• Complete two simple exercises on Week 3 agenda

Spreadsheet - Two uses for delivering curriculum

• Find two uses for a spreadsheet to support teaching in your area
• Online Resources
  • Using Excel in a Classroom
  • Survey Analysis
  • Everything you need for using spreadsheets in the classroom (!)
  • Tons of links on the bottom of this page

Spreadsheet - Mail Merge

• Mail Merge with Excel

PowerPoint - Linear lecture aid

• PowerPoint in the Classroom
• Basic PowerPoint

PowerPoint - 10 screen non-linear multimedia product for delivering curriculum

• Host Classroom Game Shows with PowerPoint

Search 540