Simple Group Creator By @JenRoberts1

	A	B	D
1
2		Basic Instructions	Advanced 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 this BLOG POST about it.
5	1	If 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	2	To 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	3	Add 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	4	Hover 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	5	Once 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