Template - Student Academic Profile Calculation Tool
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRST
1
2
Instructions:
3
4
First,
Log in to your Google account.

Go to "File" and "Make a copy" of this spreadsheet template. Rename your spreadsheet appropriately (ex. 2013 Student Profiles - MySchool)

You can now "share" this document with your team so you all have access to view and edit data.

Check the "Ranges" tab to assure your disired points and value ranges are correct.

You can make additional copies of Tabs (ex. Reading Scores), and then rename them with your grouping. (ex. 6th Reading). To do this, click on the small arrow next to the tab name to access the copy & rename options.
(NOTE: make sure to delete sample data in the Reading Scores tab, before making any copies or adding your own data)

Finally,
Copy in your student raw data into both Reading and Math Scores Tabs that your team wishes to review.
(Using copy and paste from another documents works just fine, so long as you do not copy into formula rows)

5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
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...