Project Overview
Student Learning Objectives
Procedure
Content Material
Assessment
Links to Course Competencies
Supplementary Resources
Recommendations

Stevens Institute of Technology

 
Use Excel to create a Climatogram

Assessment

Each of the students' responses from the questions in the Student Directions can be used for assessment based on the following sample rubric.

Student Worksheet Questions Score (points)
Part A: Practice using a Climatogram: Rio de Janeiro
1. The answer should be clear and provide an explanation why the student selected the "best" month to visit.
3 2 1
Provides clear & organized explanation using supportive facts. Provides clear & organized explanation. Provides correct answer.
____/3
2. The answer should be clear and provide an explanation why the student selected the "worst" month to visit.
3 2 1
Provides clear & organized explanation using supportive facts. Provides clear & organized explanation. Provides correct answer.
____3
Part B: Create a Climatogram for your City
4. The climatogram for the student's city should be correctly graphed and plotted on the corresponding x-y axes as described in the step-by-step instructions.
15 12 9 6 3
All line & bar graphs are accurate, axes, scales, & key are correctly identified, chart is labeled, & colors / weights of the lines are changed. All line & bar graphs are accurate, the axes, scales, and key are correctly identified, and the chart is labeled. All line & bar graphs are accurate, the axes, scales, and key are correctly identified. Line & bar graphs are correctly plotted or student made simple error in plotting the data but demonstrates understanding. Line and/or bar graphs may be correctly plotted or student made simple error in plotting the data but demonstrates understanding.
____/15
Part C: Analyze the Climatogram
1. The answer should be clear and provide an explanation why the student selected the "best" month to visit.
3 2 1
Provides clear & organized explanation using supportive facts. Provides clear & organized explanation. Provides correct answer.
____/3
2. The answer should be clear and provide an explanation why the student selected the "worst" month to visit.
3 2 1
Provides clear & organized explanation using supportive facts. Provides clear & organized explanation. Provides correct answer.
____/3
3. The answer should be clear and provide an explanation how graphs help communicate information and make data easier to understand.
3 2 1
Provides clear & organized explanation using supportive facts. Provides clear & organized explanation. Provides correct answer.
____/3
Extra-Credit: The climatogram should include line graphs for both the record high and low temperature using climate data from the weather web site.
3 2 1
Both record high and low temperature line graphs are correctly plotted. Record high or low temperature line graphs is correctly plotted and/or student made simple error in plotting the data. Student attempted graph but made simple error in plotting the data.
____/3
Total: ____/30

(NOTE: this RWLO is based on Lesson C5: Weather and Climate from the Weather Scope project)


Copyright 2005 Stevens Institute of Technology
Center for Innovation in Engineering & Science Education, All Rights Reserved