Excel Lesson Plan Rubric

Created in

TASKSTREAM.COM

  10 Your Score
Lesson Topic/Learning Context
The concept selected is not grade-level appropriate and shows little connection with the topic of the project. 
The concept selected is not grade-level appropriate or it does not support the topic of the project.
The lesson concept is grade-level appropriate, and supports the topic of project but may be too large or small for the indicated time frame. 
The concept is appropriate for the indicated grade level, can be done in indicated time frame, and supports the topic of the project. 
 
Lesson Objective
There are objectives but they are not written in terms of student performance or are not measureable. 
Objectives are written in terms of student performance but are missing one of the three components. 
Objectives are written in terms of student performance and contain condition, performance, and criteria for evaluation. One or more of the components are not clear. 
Objective is written clearly in terms of performance, containing condition, performance, and criteria for evaluation. Objective is clearly measurable. 
 
Lesson Procedure
The description of the learning activity is vague with no provision for Introduction or Summary. 
The learning activity is clearly explained but there is no Introduction or Summary. 
There is a clear explanation for the learning activity but either the Introduction or the Summary are missing. 
Provisions are made for an Introduction, a clear step-by-step procedure for the learning activity, and a reflective Summary activity. 
 
Lesson Goal (under Objectives) Goal of lesson (what students will take away from this lesson) is stated but not very clear and "Goal:" before list of objectives is not included.  Goal of lesson (what students will take away from this lesson) is stated but not very clear and "Goal:" before list of objectives is included.  Goal of lesson (what students will take away from this lesson) is clearly stated but "Goal:" before list of objectives is not included.  Goal of lesson (what students will take away from this lesson) is clearly stated and added in the template with "Goal:" before list of objectives.   
Standards
(M
ich
igan Grade Level Content Expectations and ISTE: National Educational Technology Standards for Students: The Next Generation)
No standards are included in lesson plan. 
At least one standard was included in the lesson plan. 
Either the Michigan Grade Level Content Expectations  standards or the ISTE technology standards were not included in the lesson plan 
All the appropriate standards from the Michigan Grade Level Content Expectations and the ISTE technology standards for students are included in the lesson plan.
 
 
Assessment/ Evaluation
The assessment plan is vague and confusing and does not include a rubric. 
The rubric included is minimal and does not give a true assessment of the task assigned to the student. 
The lesson plan includes a rubric but it is not comprehensive and some items may be confusing to students. 
The lesson plan includes a comprehensive assessment plan including a rubric with easily measurable items and a rating scale that makes sense. 
 
Use of Excel
The use of Excel is cursory and does not enhance the lesson being taught. 
Excel is used but it's use is not appropriate for the topic or the grade level addressed. 
Excel is used in a grade-level appropriate lesson. 
Excel is used in a creative manner that is grade-level appropriate and enhances the teaching of the topic. 
 
Teaching Excel to Students.
There is no reference to Excel in this lesson plan. 
Students are referred to a tutorial instructing them in the use of Excel. 
Students are introduced to Excel and its uses. 
The lesson plan includes detailed plans for teaching the students to use Excel. 
 
Use of TaskStream
There are many entries missing in the TaskStream template. 
There are some missing entries in the TaskStream template, but they are not very clear. 
All of the sections of the TaskStream have entries but they are not very clear. 
All of the sections of TaskStream are complete and they are very clear. 
 
Sample Student Products/ Handouts
There are no sample products or student handouts. 
Either the sample product or the data collection handout are not attached. 
A sample student product and a data collection handout are attached but they could be improved. 
The lesson plan has well done sample student products and data collection handouts attached.