| Excel Lesson Plan Rubric | Created in TASKSTREAM.COM |
| 1 | 4 | 7 | 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 (Michigan 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. |