Teacher Leader Project Presentation

How to use the Data Toolkit Presenter: James Granger Audience: CSArts Faculty Date: April, 4 2019

Presentation Objectives

TWBAT… explain the philosophical underpinnings of our grading scale to parents and students.

TWBAT… use the data toolkit to convert objective test scores to mastery scores easily and efficiently.

What are the advantages and disadvantages of our grading scale? Advantages

Disadvantages

What are the advantages and disadvantages of our grading scale? Advantages

Disadvantages

DISCUSS WITH YOUR ELBOW PARTNER (90 secs)

So, is a 50% on a test really a C?

DISCUSS WITH YOUR ELBOW PARTNER (90 secs)

CSArts Grading Scale

Mastery Score

Score in Gradebook

6

100%

5

83%

4

66%

3

50%

2

33%

1

17%

0

0%

CSArts Grading Scale

Score on Test

Mastery Score

Score in Gradebook

100%

6

100%

90%

5

83%

80%

4

66%

70%

3

50%

60%

2

33%

50%

1

17%

0%

0

0%

CSArts Grading Scale

Score on Test

Mastery Score

Score in Gradebook

100%

6

100%

90%

5

83%

80%

4

66%

70%

3

50%

60%

2

33%

50%

1

17%

0%

0

0%

45% 86%

28% 4.5

Lorem ipsum porta dolor sit amet nec

Lorem ipsum porta dolor sit amet nec

Lorem ipsum dolor sit amet adipiscing. The percent of Donec risus dolor, porta venenatis neque pharetra luctus felis. that Proin vela tellus nec in questions felis volutpat amet molestie cum sociis. student got right

Lorem ipsum dolor sit amet adipiscing. Donec risus dolor, porta venenatis neque pharetra luctus felis. Proin vel tellus nec in felis volutpat amet molestie cum sociis.

The students current level of mastery: “meets expectations”

Lorem ipsum dolor sit amet adipiscing. Donec risus dolor, porta venenatis neque pharetra luctus felis. Proin vel tellus nec in felis volutpat amet molestie cum sociis.

Student takes test

Convert to mastery

Score in Grade Book

● ● ● ●

Donec risus dolor porta venenatis Pharetra luctus felis Proin vel tellus in felis volutpat Molestie nec amet cum sociis

● ● ● ●

Donec risus dolor porta venenatis Pharetra luctus felis Proin vel tellus in felis volutpat Molestie nec amet cum sociis

Student Example

4.5/6 36% = .75 = 75% Lorem ipsum porta dolor sit amet nec

4.5 expressed as a decimal and a percent ● ● ● ●

Donec risus dolor porta venenatis Pharetra luctus felis Proin vel tellus in felis volutpat Molestie nec amet cum sociis

Why is this beneficial to our students?

DISCUSS WITH YOUR ELBOW PARTNER (90 secs)

A Tale of Two Grading Scales Traditional Grading Scale

Student’s Assessment Score 95%

95%

95%

95%

Traditional Grading Scale

0%

Student’s Assessment Score 95%

95%

95%

95%

0%

95%

95%

76%

Rolling Average Grade 95%

95%

Traditional Grading Scale

By how much did the zero affect the student’s grade?

DISCUSS WITH YOUR ELBOW PARTNER (90 secs)

The Impact of One Zero

01

Size of a grade level in percentage points

10%

02

Change measured in percentage points

19%

03

Change measured in grade levels

04

Can a student recover their original grade?

Traditional Grading Scale

2 No

A Tale of Two Grading Scales CSArts Grading Scale

Student’s Assessment Score 83%

83%

83%

CSArts Grading Scale

83%

0%

Student’s Assessment Score 83%

83%

83%

83%

0%

83%

83%

66%

Rolling Average Grade 83%

83%

CSArts Grading Scale

By how much did the zero affect the student’s grade?

DISCUSS WITH YOUR ELBOW PARTNER (90 secs)

The Impact of One Zero

01

Size of a grade level in percentage points

17%

02

Change measured in percentage points

17%

03

Change measured in grade levels

04

Can a student recover their original grade?

CSArts Grading Scale

1 Yes

What are the advantages and disadvantages of our grading scale?

Disproportionate focus on failure No space at top of scale to recover

Proportionate focus on failure Space at top of scale to recover

That’s nice, but I don’t have the time to manually convert all those scores.

COMPLAIN TO YOUR ELBOW PARTNER (10 secs)

Culminating Activity It’s not that hard

OPEN YOUR GRADBOOKS

CLICK ON THE THREE DOTS

SELECT “EXPORT”

SELECT “GRADEBOOK AS CSV”

THEN, HIT “NEXT”

OPEN DOWNLOADED SPREADSHEET

DELETE UNWANTED DATA

KEEP JUST THE STUDENTS’ NAMES AND SCORES

COPY THIS DATA

DON’T COPY THE HEADER ROW

OPEN UP THE DATA TOOLKIT

SELECT THIS CELL AND PASTE DATA

IF YOU NEED TO DELETE OLD DATA, DO NOT TOUCH THIS COLUMN

COPY THE MASTERY SCORES BACK INTO YOUR GRADEBOOK

FEELING ADVENTUROUS?

FEELING ADVENTUROUS?

USE THE “BLOCK” COLUMN TO PROCESS MULTIPLE CLASSES AT THE SAME TIME

FEELING ADVENTUROUS?

THE HISTOGRAM WILL SHOW YOU YOUR GRADE DISTRIBUTION

FEELING ADVENTUROUS?

THE CONVERSION SCALE IS CUSTOMIZABLE

How might you use this tool in your classroom?

DISCUSS WITH YOUR ELBOW PARTNER (90 secs)

THANKS! Any questions? You can find me at ✘ [email protected]