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

 

 
Real World Learning Objects: Educational Technology
A Study of Diverse Populations Through the Creation of Charts and Graphs

Assessment

Grading Rubric: Excel Spreadsheets

Category

Acceptable

Target

Score

1 point

2 points

Organization

Data is placed haphazardly throughout the spreadsheet; row or column headings are poorly chosen or non-existent;

Placement of data shows planning and facilitates easy reading & comprehension. No empty rows or columns between data fields or records.

 

Data Input

Data provided is incomplete or entered incorrectly.

Data provided is entered correctly.

 

Formatting

Cell and text formatting options are not utilized correctly. 

Cell and text formatting options are used.  Cell and text formatting options (like font size, bold, justification and text color) effectively emphasize important values. 

 

Chart Info

The source data is correct, but the chart lacks one or more of the following: title, axis labels, legend. Data series have not been renamed or are non-descript.

The source data is correct and the chart has a title, axis labels, and legend. Data series have been named.

 

Chart Aesthetics

Chart elements are completely illegible.

Text and numbers are legible; chart size and type are adequate.  Data labels used ONLY if they improve usability.

 

Total

/10