50_Team_with_Individual_Teachers_SHEETS_NEWEST_9_8_18
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DIRECTIONS
Updated 9/8/18
2
3
NOTE
4
This Google Sheets version of the Excel Scaling spreadsheet has VERY limited capabilites.
5
- Capable of scaling a multiple-choice test
6
- Incapable of test analysis, indepth item analysis, objective analysis, choice analysis or easy gradebook entry
7
8
MAKE A COPY OF THIS FILE TO YOUR GOOGLE DRIVE THEN SHARE WITH YOUR TEAM.
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
How to navigate to different TABS
29
-
Click on the arrows at the bottom left corner of the screen.
30
31
What do you want to do?
32
1.
Analyze and Scale a ZipGrade Multiple-Choice Assessment
33
Go to the URL below for directions. Skip to page 7.
34
http://gravitykills.net/Curriculum/4_Steps.pdf
35
Copy and paste only the Standard Form data into this spreadsheet.
36
37
Go to the URL below for an explanation of spreadsheet features.
38
http://gravitykills.net/Curriculum/ZipGrade_Spreadsheet_Tabs.pdf
39
40
Go to the URL below for an explanation of scaling selections.
41
http://gravitykills.net/Curriculum/Scale%20Explanation.pdf
42
43
2.
Analyze ONLY a Free Response Assessment
44
Choose between the 50 Free Response or 100 Free Response tab.
45
Enter scores into the table.
46
Adjust BLUE cells to set a scale.
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu