Simple Group Creator By @JenRoberts1
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRST
1
2
Basic InstructionsAdvanced Options
3
Welcome to the Group Creator sheet. This sheet automatically creates homogeneous and heterogeneous groups for you based on your student data. If you have advanced spreadsheet knowlwdge you may want to try some of these things.
4
You can find more information about how this works from thie BLOG POST about it.
5
1If you just got here you only have "view only" access. Use File/Make a copy to create your own version of this sheet. Rearrange the order of the groups on the sheet so it is a bit less obvious which groups are higher. I typically make my even numbered groups the lower ones and the odd numbered groups the higher ones. This simple trick keeps many kids from noticing that they are grouped homogeneously.
6
7
2To get started type (or paste) your student roster into the roster sheet. (See the tabs below.) I have sample names in there now to demonstrate how the sheet works.Rename the tabs below to Number Groups, Letter Groups etc to make it even less obvious that student groups are homogeneous or heterogeneous.
8
9
3Add some data you might use to rank your students, such as a recent quiz score, into the Score column. Use a random number generator instead of scores and all groups become heterogeneous and more random.
10
11
4Hover over the B above the word score to reveal a small grey down arrow. Click on the arrow to reveal options. Select "Sort Sheet Z-A" That will put students with the highest scores at the top of your roster. I'm sure you'll have other creative ideas and improvements. Please let me know about them.
12
13
5Once your students are sorted from highest to lowest your groups have already been created. Try clicking on the tabs to the right of the roster to see your various group possibilities. Thanks for being a great teacher. @JenRoberts1
14
15
Note: If a student leaves your class you can delete their name and re-sort the roster sheet, but DO NOT delete their ROW. That will cause a ripple effect of errors. goo.gl/Oqn3Mj
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...
 
 
 
Instructions
Roster
6 Homogeneous Groups
6 Heterogeneous Groups
9 Homogeneous Groups
9 Heterogeneous Groups
Homogeneous Pairs
Heterogeneous Pairs