Productivity Tools
Syllabus                                        Course Projects                                                Course Blog

Purpose

To become familiar with the use of Word, Excel, and PowerPoint in the preparation of classroom materials, to be aware of resources -- such as templates, that increase productivity

Due Date

Monday, September 24th at the beginning of class

Percent

10%

Submittal

Link all of the 9 objects and complete/publish your webpage with the reflection, links, and screen shots. You do not need to print a copy of your reflection.

Details

You've gotten your first teaching job! You're in your dream school teaching the grade and subject you'd hoped for. You spent all summer planning exciting lessons that incorporate all of the great technology you learned about in your EDIT class. You just finished loading your stapler and you decide to walk down to the teachers' lounge and grab something from the vending machine, after all, you're ready for the first day of school and you still have 4 days of preplanning left!

You enter the lounge and you notice a line of teachers waiting for the copy machine. Since you plan to NEVER use a worksheet -- or the textbook, you've had no need for the copier all week. You see your mentor teacher near the end of the line and you ask him what he's copying. Once you're revived after hearing his reply, you decide you need to get to work.

You realize that it's not just lessons that you've got to get ready for the first week of school. There are all kinds of materials and handouts that need to be prepared for Open House and the first day of school. According to your mentor teacher, you'll need newsletters, certificates, seating charts, and more to be prepared for classes to begin. Thank goodness for your EDIT class -- you know about productivity tools and how they can help you get things done. You'd planned to use them to work with students, but had forgotten all about how helpful they could be to you. You've got a big task ahead of you though, you need to create a packet of materials for Open House and the first day of school.

Your mentor teacher has given you a list of things you should have available for parents during Open House (see grading rubric below). The list also includes items to make your classes more "student-friendly" on the first day of school. You'll use it as a checklist to make sure you have everything.

You remember learning about some templates for productivity tools from your EDIT class. You check your portfolio site from the course and you find these links:

Microsoft Template Gallery for PCs
Microsoft Template Gallery for Macs
GLC Resources for First-Year Teachers
GLC Templates
Education World Templates
Puzzle Maker or Word Sheet Generator
Spreadsheet ideas 

Inner Geek Tutorials (Element K)


Once you create all of your materials, you'll be ready for open house and the rest of your first year!

 

Rubric

 

 

 

 

Criteria

Satisfactory

Outstanding

Suggested Program

Student Example

Points

Tri-fold Brochure or Newsletter

 

(2 pages!)

You could have put more effort into the brochure. The information could be more informative. You are missing Word Art, Clip Art and a table. Spelling errors are present.

It is clear that you spent time on your classroom brochure. The information is informative and you have incorporated Word Art, Clip Art, use of bullets and/or numbering, and at least one table.

Word

Brochure

15

Calendar

Calendar is missing some events or the Clip Art

Calendar for August with Clip Art or a Picture and at least five events/holidays

Screenshot

Word

Calendar

10

Attendance and Grade Record

Missing formulas, missing some students and the workbook sheets are not labeled.

  • An attendance sheet for 8 students calculating the number of absences for a 5 day period.
  • A grade sheet for the same 8 students calculating their grade average for five assignments.
  • Both of the sheets need to alphabetized by the last name. The workbook sheet tabs must be labeled. 

Excel

Grades and Attendance

10

Excel Pictograph

Excel spreadsheet does not include basic pictograph elements covered in class

Excel spreadsheet shows understanding of advanced features of Excel

Screen shot

Excel

Pictograph Example

10

Seating Chart

Missing a few desks, the teacher work area, the computers, or furniture.

Layout of classroom, including: 20 desks, teacher work area, 3 computers, other classroom furniture.

Screenshot

PowerPoint

Seating Chart

10

Business Cards
or
Student Name Tags

You are missing some of this section.

Professional Business cards with contact information for parents (full sheet) or Colorful nametags(3)

Word

Business Cards

Student Name Tags

5

Certificates/
Hall Passes

You are missing some of this section.

Colorful certificates (2) or
hall passes (2)

Word/PowerPoint

Certificate

Hall Pass

5

Worksheet

You are missing some of this section.

Worksheet or subject specific crossword puzzle for the first day of school created with web-based productivity tool

Screenshot

Worksheet Generator or
Puzzle Maker

First Day

5

Portfolio Reflection

Create a new page for your portfolio (named "Productivity Tools")- include links to each of your productivity tools artifacts. Give an explanation for each of your artifacts, what you learned in the development of the artifact, and how it could be used in a classroom.

Then, explain in detail the types of activities students can do using productivity tools. Your discussion and specific descriptions should focus on activities at a LoTi level of 3 or greater. Use examples from class readings. Make sure to publish the page when you are finished.

 

---

30

Wow Factor

Products exceed requirements of project

---

Varies

Total Points

100