Using Project-based learning

Calendar for E-Squared in Portage Public Schools

Covers Chapter 6, Project Launch -- Implementation Strategies, of Reinventing Project-Based Learning, p. 93 to 112.

TaskStream Lesson Plan 2, using Excel (Module #7 in Blackboard Learning System)

Using TaskStream, you will write a lesson plan for an elementary classroom that includes a data collection activity for a specific concept within your Project topic, using Microsoft Excel as a collection-and-reporting tool.

Each member of your team will create a different Lesson Plan. You will need to discuss in lab and post in Blog which team member will work on which Lesson Plan. If two team members turn in a lesson plan with the same concept, neither will get points for this assignment.

Requirements for this lesson plan are:

• a Student activity that involves collection of data
• a data collection sheet created by you and attached to your lesson plan under Instructional Materials.
• the classroom teacher (you) showing students how to use Excel -- inputting data and creating a graph
• a Student Sample of Excel spreadsheet and graph attached under Student Sample
• Michigan Grade Level Content Expectations
• ISTE: National Educational Technology Standards for Students: The Next Generation
• assessment criteria for the lesson activity on a rubric developed in the Rubric Wizard and attached to the lesson plan.

SUBMITTING ASSIGNMENT : Once your lesson plan is completed and you have attached (a) a sample student product, (b) rubric, (c) data collection handout, and (d) Standards (Michigan Grade Level Content Expectations and the ISTE: National Educational Technology Standards for Students: The Next Generation), it is turned in through Taskstream. Please follow these steps:

1. Be sure that you have created lesson plan, using TS Basic template, and ALL attachments (i.e. rubric, student sample, data collection sheet, etc.)

2. Review Rubric for Lesson Plan Two (in Rubric section) and make sure you have all requirements.

3. Click on the "Request Feedback (Submit for Review)" button as seen below. **

4. Click in box next to your instructor's name.

5. Be sure and go back into TaskStream to read comments once you have received points for this assignment.

**If you do not see the above button, you need to notify your instructor.

DUE DATE: By 11:59 p.m., Friday, November 6, 2009.

NOTE: All assignments have specific due dates. Late assignments will lose 10 points for each WEEK they are late. NO EXCEPTIONS!

Lesson Plan 2 Rubric. Be sure to read it before you write the lesson plan so that you include all the assessment parts.

FOR LESSON PLAN 2:

For helpful information on data collection, go to Raw Data

For helpful information on Excel: Excel 2007 Help

Ideas for Lesson Plan can be found at Data Collection Links

The following lesson plan is an example of the kind of product you should be developing for this assignment. It includes:

• a handout for students,
• a sample student product, and
• a rubric that will be used in assessing the assignment that the students have been asked to complete.

You can access each part of this sample by clicking on the link below and then clicking on the appropriate links in the lesson plan.

Favorite Types of Butterflies