Objectives

Given a results analysis template, demonstrate charting results and percentages.

Prerequisites

The student must know how data tables work. Also, the student must know how to use a data table in either Excel or by hand.

Introduction

Often, teachers will be collecting data to chart student progress and achievement. How to organize all this data can be a daunting task though. In this unit, the learner will be exposed to 2 different templates to chart relevant student data. Some teachers prefer charting data by hand while some prefer charting data in computer spreadsheets such as Excel. In this unit, the learner will be taught to use 2 different templates to be able to demonstrate he or she can chart relevant student data using a real example. This will lead to the learner performing a data analysis in the Unit 3.

Instruction

Activity 1

Activity 2

Assessment

For your assessment, you will be demonstrating that you can chart student data and percentages.

You may do so by hand using a print out template that can be found here.

You may also do so using an Excel template. Unfortunately, Excel files cannot be uploaded for use. You may choose to mirror the paper template in Excel if you feel more comfortable.

Task

Choose 3 out of 5 student's data from their answer sheets below. Using the data, chart the data and find the appropriate percentages. In the tables below, when a response is incorrect, there will be an "X" next to the response. When finished, please post your reflections in the message board under "Charting Task".

Student 1

Student 1
Question #	Response
1	a
2	a
3	b
4	a
5	c
6	c
7	a
8	d
9	d
10	d

Student 2
Question #	Response
1	a
2	c - X
3	a - X
4	a
5	a - X
6	c
7	d - X
8	b - X
9	d
10	d

Student 3
Question #	Response
1	c - X
2	a
3	b
4	a
5	c
6	c
7	b - X
8	b - X
9	d
10	d

Student 4
Question #	Response
1	c - X
2	b - X
3	b
4	a
5	a - X
6	c
7	a
8	b - X
9	b - X
10	b - X

Student 5
Question #	Response
1	a
2	a
3	b
4	a
5	c
6	c
7	a
8	b - X
9	b - X
10	b - X

Enrichment

Use an assessment in your own class and chart your classes data. Post your results, with only first names, in the message board under "Charting Enrichment Task."