Spreadsheet: 85785d1285818626-countifs-function-teaching
Sheet: data

 | Fall 06A | Fall 06B | Fall07A | Fall07B
average | 69 | 84 | 90 | 105
 | 77 | 81 | 94 | 105
 | 93 | 96 | 96 | 89
 | 81 | 64 | 95 | 92
 | 46 | 84 | 94 | 48
 | 72 | 86 | 93 | 97
 | 95 | 93 | 95 | 88
 | 50 | 99 | 95 | 104
 | 97 | 98 | 90 | 105
 | 88 | 59 | 91 | 79
 | 97 | 93 | 95 | 102
 | 70 | 96 | 93 | 77
 | 88 | 89 | 95 | 96
 | 91 | 90 | 92 | 99
 | 88 | 77 | 95 | 88
 | 70 | 93 | 93 | 91
 | 72 | 77 | 93 | 98
 | 91 | 91 | 96 | 97
 | 94 | 91 | 93 | 21
 | 63 | 98 | 90 | 80
 | 93 | 94 | 96 | 91
 | 61 | 0 | 94 | 73
 | 77 | 73 | 91 | 90
 | 62 | 81 | 91 | 89
 | 78 | 91 | 95 | 96
 | 79 | 96 | 96 | 91
 | 83 | 90 | 90 | 83
 | 93 | 93 | 91 | 104
 | 78 | 86 | 94 | 93
 | 89 | 2 | 93 | 103
 | 88 | 79 | 92 | 92
 | 101 | 87 | 90 | 91
 | 86 | 91 | 92 | 103
 | 95 | 101 | 91 | 79
 | 84 | 50 | 94 | 94
 | 36 | 86 | 90 | 65
 | 92 | 81 | 93 | 91
 | 91 | 82 | 95 | 92
 | 80 | 66 | 92 | 90
 | 85 | 81 | 96 | 105
 | 86 | 81 | 91 | 99
 | 82 | 80 | 91 | 95
 | 92 | 73 | 92 | 106
 | 75 | 91 | 92 | 95
 | 89 | 74 | 91 | 99
 | 68 | 82 | 94 | 94
 | 97 | 79 | 95 | 95
 | 88 | 72 | 94 | 95
 | 88 | 80 | 101 | 60
 | 83 | 79 | 102 | 94
 | 74 | 91 | 101 | 105
 | 88 | 65 | 98 | 91
 | 83 | 92 | 97 | 97
 | 88 | 92 | 99 | 86
 | 95 | 93 | 100 | 77
 | 69 | 87 | 102 | 74
 | 88 | 85 | 97 | 96
 | 94 | 87 | 97 | 104
 | 84 | 89 | 97 | 105
 | 88 | 79 | 101 | 83
 | 93 | 91 | 104 | 98
 | 90 | 88 | 99 | 105
 | 80 | 72 | 101 | 81
 | 80 | 92 | 102 | 88
 | 82 | 90 | 99 | 96
 | 76 | 93 | 97 | 92
 | 89 | 98 | 103 | 89
 | 17 | 89 | 97 | 98
 | 93 | 80 | 105 | 98
 | 84 | 74 | 97 | 92
 | 80 | 94 | 106 | 92
 | 85 | 71 | 103 | 91
 | 95 | 92 | 97 | 106
 | 90 | 84 | 106 | 95
 | 80 | 91 | 100 | 89
 | 82 | 87 | 100 | 86
 | 90 | 94 | 98 | 99
 | 90 | 92 | 105 | 94
 | 86 | 90 | 104 | 96
 | 67 | 99 | 104 | 100
 | 83 | 82 | 103 | 93
 | 91 | 78 | 101 | 78
 | 83 | 94 | 97 | 79
 | 93 | 94 | 100 | 97
 | 91 | 84 | 101 | 96
 | 71 | 76 | 98 | 85
 | 15 | 86 | 102 | 103
 | 86 | 88 | 97 | 105
 | 95 | 76 | 99 | 105
 | 82 | 91 | 105 | 94
 | 92 | 95 | 97 | 83
 | 90 | 75 | 100 | 13
 | 80 | 82 | 100 | 64
 | 95 | 95 | 102 | 106
 | 87 | 95 | 100 | 78
 | 82 | 83 | 104 | 89
 | 83 | 97 | 102 | 88
 | 66 | 92 | 105 | 82
 | 83 | 86 | 97 | 83
 | 83 | 82 | 97 | 93
 | 85 | 21 | 102 | 72
 | 91 | 88 | 100 | 94
 | 87 | 92 | 104 | 96
 | 57 | 66 | 103 | 104
 | 76 | 84 | 101 | 97
 | 89 | 82 | 105 | 82
 | 95 | 73 | 99 | 83
 | 83 | 85 | 103 | 92
 | 89 | 94 | 99 | 17
 | 92 | 46 | 99 | 95
 | 91 | 56 | 102 | 75
 | 86 | 84 | 104 | 30
 | 95 | 85 | 100 | 93
 | 74 | 96 | 102 | 89
 | 92 | 93 | 98 | 105
 | 97 | 78 | 102 | 33
 | 87 | 88 | 100 | 81
 | 94 | 81 | 105
 | 79 | 86 | 99
 | 86 | 63 | 101
 | 98 | 78 | 104
 | 98 | 100 | 100
 | 95 | 94 | 98
 | 78 | 91 | 105
 | 76 | 91 | 104
 | 76 | 84 | 102
 | 85 | 39 | 82
 | 84 | 95 | 84
 | 83 | 78 | 86
 | 89 | 97 | 83
 | 86 | 87 | 82
 | 86 | 92 | 82
 | 94 | 79 | 82
 | 92 | 82 | 81
 | 76 | 86 | 85
 | 85 | 76 | 81
 | 90 | 89 | 86
 | 91 | 81 | 85
 | 96 | 83 | 84
 | 90 | 92 | 81
 | 85 | 98 | 85
 | 70 | 98 | 86
 | 59 | 82 | 84
 | 97 | 80 | 81
 | 93 | 42 | 82
 | 77 | 92 | 86
 | 91 | 83 | 85
 | 90 | 79 | 82
 | 69 | 85 | 84
 | 95 | 91 | 83
 | 83 | 97 | 84
 | 91 | 85 | 83
 | 88 | 79 | 83
 | 79 | 94 | 86
 | 90 | 32 | 87
 | 93 | 66 | 87
 | 91 | 93 | 88
 | 79 | 71 | 89
 | 76 | 86 | 88
 | 90 | 64 | 89
 | 86 | 56 | 88
 | 67 | 83 | 88
 | 70 | 85 | 88
 | 86 | 95 | 87
 | 87 | 84 | 87
 | 93 | 85 | 88
 | 88 | 92 | 89
 | 84 | 92 | 87
 | 79 | 77 | 89
 | 82 | 91 | 89
 | 93 | 74 | 89
 | 58 | 93 | 88
 | 62 | 73 | 87
 | 89 | 91 | 89
 | 87 | 88 | 79
 | 92 | 84 | 76
 | 95 | 92 | 75
 | 92 | 95 | 78
 | 97 | 79 | 78
 | 92 | 92 | 73
 | 81 | 82 | 77
 | 100 | 89 | 74
 | 97 | 69 | 74
 | 94 | 89 | 75
 | 71 | 85 | 75
 | 93 | 83 | 75
 | 95 | 91 | 77
 | 93 | 89 | 71
 | 93 | 93 | 71
 | 91 | 83 | 72
 | 76 | 0 | 78
 | 96 | 83 | 77
 | 63 | 83 | 77
 | 79 | 44 | 72
 | 73 | 91 | 77
 | 78 | 66 | 75
 | 67 | 80 | 79
 | 88 | 92 | 74
 | 94 | 87 | 65
 | 93 | 83 | 65
 | 98 | 94 | 61
 | 80 | 91 | 68
 | 86 | 87 | 63
 | 85 | 2 | 69
 | 79 | 81 | 66
 | 83 | 93 | 27
 | 90 | 93 | 58
 | 89 | 87 | 0
 | 76 | 99 | 0
 | 94 | 70 | 56
 | 91 | 83 | 27
 | 86 | 96 | 25
 | 96 | 95 | 1
 | 85 | 85 | 24
 | 69 | 91 | 39
 | 97 | 97 | 43
 | 87 | 73 | 47
 | 74 | 88 | 51
 | 94 | 92 | 0
 | 93 | 97 | 20
 | 70 | 88 | 0
 | 73 | 90 | 0
 | 79 | 85 | 41
 | 84 | 87 | 12
 | 81 | 78 | 54
 | 86 | 86 | 33
 | 76 | 88 | 54
 | 76 | 94 | 28
 | 75 | 99 | 19
 | 96 | 93
 | 98 | 72
 | 85 | 94
 | 87 | 94
 | 92 | 92
 | 91 | 87
 |  | 76
 |  | 73