ECI 304 - Educational Applications of Computers: Teaching Tools

Date Due: Oct 26 (VB) Oct 20 (ODU)

Create products using the tools below to use in your classroom. A cover document should begin with an explanation of the class (discipline, grade level), and the topic studied for your example (i.e. life cycle of butterflies). Explain how teaching with each tool can enhance learning – for example, why is it better than reading the info out of a book or having a class discussion? See 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

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

Spreadsheet

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

Database

1. Student Records
2. Mail Merge
3. One use for delivering curriculum

Powerpoint

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

Inspiration

(Optional)

Specifications

Word processing - Formatted Resume

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

Database - Student Records

Database - Mail Merge

• Mail Merge with Excel

Database - One use for delivering curriculum

PowerPoint - Linear lecture aid

• PowerPoint in the Classroom

PowerPoint - Handout

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

• Host Classroom Game Shows with PowerPoint

Search 304