ZipGrade Changes

Updated 5/25/2020

5/25/20

NEW SCALING SPREADSHEET


There are now two versions of the scaling spreadsheet on GravityKills.nets


  • Current/Past Version - requires two CSV ZipGrade files.
  • NEW Version - requires one CSV Zipgrade file and has additional features NOT available on the current version. New features will be outlined below.


Both version will be available on GravityKills. The NEW version will be identified as MULTIPLE FORMS version.

Only ONE ZipGrade CSV File

Now you only need to export and copy & paste one CSV ZipGrade file into the scaling spreadsheet. The file needed is titled "Full Format (with student responses)".

NEW Features on MULTIPLE FORMS Spreadsheet

(Item Analysis tab)


Here are the features only available on the MULTIPLE FORMS spreadsheet.


The MULTIPLE FORMS spreadsheet:

  1. displays the answer choice percentages for all forms (A, B, C, D, and E).
  2. gives the number of tests for each form.
  3. gives the percentage of tests for each form.
  4. gives the percentage correct for each form.
  5. gives the number of points each question is from the group average.
  6. shows how far each question is from the group average.
  7. gives the Difficulty Rating (DIF) beside the answer choice percentages for each form.


All the information on the far left of the spreadsheet (question scatter plot, percentages histogram or percent correct-discriminatin factor table) will NOT change as the form is changed. All this information is for “ALL FORM DATA COMBINED”.
Big picture

3/14/2020

Improvement Factor

(Student Scores tab)


The default calculations on the spreadsheet are the same as they were prior to this update. The "Improvement Points" has been replaced with "Improvement Factor". The change was necessary to maintain consistent terminology through the spreadsheet and allow for better understanding of the "Scores vs Grade Break Scatter Plot".


Beneath the "Improvement Factor" is the calculation a zero on the unit test and 100 on the CrissCross would earn with the selected Improvement Factor and Improvement Multiplier settings. The calculations change as settings are varied.


Abbreviations

CC = CrissCross

I.F. = Improvement Factor

I.P. = Improvement Points

Big picture

Score and Grade Break Scatter Plot

(Student Scores tab)


Added several features below the scatter plot. An adjustable blue line identifies what combinations of Unit Test and CrissCross scores given the selected grade. The other features are explained in the picture below.
Big picture

3/3/20 Changes

Suggested Minimum

(Item Analysis tab)


Added back the "Suggested MINIMUM Number of Questions to Drop"

Big picture

Questions to Review

(Student Scores tab)


There was a glitch when a question had the same score on the unit test and on the CrissCross activity. The spreadsheet would repeat a question number multiple times. This has been corrected. In addition the chart now highlights when questions have the same Review Ranking.

Big picture

2/21/2020 Changes

Choice Check Scan Documents

The Choice Check scan document is available in PDF and Word.


Go to GravityKills.net to download the files.

Big picture

Post IA (Optional)

Now there's no need to enter a separate key for CrissCross into ZipGrade. Score your CrissCross scan documents with the test's key(s). When finished with CrissCross, export a second version of the Item Analysis report and paste it into the "Post IA (Optional)" tab. The spreadsheet will separate the test data from the CrissCross data.

CrissCross Bump

(Student Scores tab to the left of the histograms)


After completing the unit test and CrissCross activity some students still receive an overall failing grade on the assessment. Teachers can now decided if a passing CrissCross score warrants students receiving a mastery grade (70) on the assessment.


Selecting "Yes" - Students with an overall failing score are awarded:

  • 70 if their CrissCross score is greater than a 70 or
  • their CrissCross score if it's less than 70.


Selecting "No" - Student with an overall failing score are awarded their weighted average plus any improvement points.

Big picture

Assessment Weights

(Student Scores tab)


The assessment weights now have a default setting (which can be changed).

  • Unit Test weight is set to equal the average on the unit test.
  • CrissCross Activity weight is set to equal 100 minus the Unit Test weight


For example:

A unit test with an overall average for all the classes is 72%.

Assessment Weights

  • Unit Test = 72%
  • CrissCross Activity = 100 - 72 = 28%


Rationale

Easier test don't need as much of a grade assist as harder test. The easier the test, the less CrissCross impacts the students' grades and the converse for harder test.


Teachers can always change the assessment weights to any value they want.

Big picture

Scores and Grade Break Scatter Plot

(Student Scores tab beneath the histograms)


A scatter plot of CrissCross scores vs. Unit test scores.


Note - CrissCross should not lower a student's grade.


Explanation of Graph Features

  • CC Cut Line - CrissCross should not lower a student's grade. There should be no grades above the GRAY line.
  • A Break Line - Points below the GREEN line will earn an A.
  • B Break Line - Points between the YELLOW and GREEN line will earn an B.
  • C Break Line - Points between the ORANGE and YELLOW line will earn a C
  • Passing Line - Points to the right of the RED dashed line are below passing before CrissCross.
  • Bump Line - Points between the RED and ORANGE line can be bumped up. See CrissCross Bump feature.
  • Bump Line - Points between the RED and GRAY line can be bumped over. See CrissCross Bump feature.


The graph will adjust as Assessment Weights and Improvement Factor are changed.

Big picture

Changes Prior to February 17, 2020 - PD Day

Absence Identification

Replaced "X" with an "A" and Red Highlights

(Student Scores Tab)

Big picture

Improvement Calculator

Number Correct for a Selected Percentage Correct

(Student Scores Tab)

Big picture

Tier Rankings

Tier Rankings with Pre and Post Breakdown

(Student Scores Tab)


Thanks to Clark HS for sharing tier rankings.

Big picture
Big picture
Big picture

Histograms

Unit Assessment and Final Score Histograms

(Student Scores Tab)

Big picture

Class Averages

Averages with Average Number of Improvement Points

(Student Scores Tab)

Big picture

Setting the Average

Set the Overall Class Average (See Notes below Chart)

(Student Scores Tab)

Big picture

Choice Checks

Set the Number of Choice Checks by Period

(Student Scores Tab)

Big picture
Big picture
Big picture

Post CrissCross

Selecting Questions to Review Post CrissCross

(Student Scores Tab)

Big picture
Big picture

Sorting Scores

Score Scores by ZipGrade ID Number

(Sharing Scores Tab)

Big picture
Big picture

Alpha Order by Class Period

Alphabetical Listing of Grades and Tier by Period

(Sharing Scores Tab)

Big picture

Question Difficulty Ratings

Both Student and Teacher Difficulty Ratings and Counts

(Item Analysis Tab)


Thanks to the Michael and Michael for the suggesting teacher difficulty.

Big picture
Big picture

Test Difficulty Ratings

Both Student and Teacher Difficulty Ratings for the Test

(Item Analysis Tab)



Thanks to Jerry for the suggesting teacher expectation.

Big picture
Big picture

T-TESS and the Reflective Cycle

T-TESS statements, data and reflective cycle

(T-TESS tab)
Big picture