Spreadsheet: 31927d1227943631-average-multiple-rows-based-on-2-columns-example_honours
Sheet: Sheet1

District Number | School Number | School Name | Master Timetable ID | Teacher ID | Teacher Name | Student Number | Student Legal Last Name | Student Legal First Name | Student Name | Grade | Homeroom | Course Code | Reporting Date | Mark |  | Final Mark | Report Cycle Description | Study Habit | Comments | Semester Average | School Final Exam
12 | 12345 | School 1 | 54321 | 111111 | Teacher One | 234567 | Martin | [NAME] | [NAME] | 7 | 122 | Math | 2008-11-28 00:00:00 | 88 |  |  | Report #1 | Good | Comment for this student | 90.625
12 | 12345 | School 1 | 54321 | 222222 | Teacher two | 234567 | Martin | [NAME] | [NAME] | 7 | 122 | Science | 2008-11-28 00:00:00 | 90 |  |  | Report #1 | Excellent | Comment for this student | 90.625
12 | 12345 | School 1 | 54321 | 333333 | Teacher three | 234567 | Martin | [NAME] | [NAME] | 7 | 122 | Socials | 2008-11-28 00:00:00 | 87 |  |  | Report #1 | Good | Comment for this student | 90.625
12 | 12345 | School 1 | 54321 | 444444 | Teacher Four | 234567 | Martin | [NAME] | [NAME] | 7 | 122 | PE | 2008-11-28 00:00:00 | 86 |  |  | Report #1 | Good | Comment for this student | 90.625
12 | 12345 | School 1 | 54321 | 555555 | Teacher Five | 234567 | Martin | [NAME] | [NAME] | 7 | 122 | English | 2008-11-28 00:00:00 | 93 |  |  | Report #1 | Excellent | Comment for this student | 90.625
12 | 12345 | School 1 | 54321 | 666666 | Teacher Six | 234567 | Martin | [NAME] | [NAME] | 7 | 122 | Foods | 2008-11-28 00:00:00 | 92 |  | 92 | Report #1 | Excellent | Comment for this student | 90.625
12 | 12345 | School 1 | 54321 | 777777 | Teacher Seven | 234567 | Martin | [NAME] | [NAME] | 7 | 122 | Tech | 2008-11-28 00:00:00 | 91 |  | 91 | Report #1 | Good | Comment for this student | 90.625
12 | 12345 | School 1 | 54321 | 888888 | Teacher Eight | 234567 | Martin | [NAME] | [NAME] | 7 | 122 | French | 2008-11-28 00:00:00 | 98 | 90.625 |  | Report #1 | Excellent | Comment for this student | 90.625
12 | 12345 | School 1 | 54321 | 999999 | Teacher Nine | 345678 | Smith | [NAME] | Smith Mary | 8 | 121 | English | 2008-11-28 00:00:00 | 86 |  |  | Report #1 | Good | Comment for this student | 81.625
12 | 12345 | School 1 | 54321 | 111111 | Teacher One | 345678 | Smith | [NAME] | Smith Mary | 8 | 121 | French | 2008-11-28 00:00:00 | 87 |  |  | Report #1 | Good | Comment for this student | 81.625
12 | 12345 | School 1 | 54321 | 444444 | Teacher Four | 345678 | Smith | [NAME] | Smith Mary | 8 | 121 | Foods | 2008-11-28 00:00:00 | 88 |  | 88 | Report #1 | Satisfactory | Comment for this student | 81.625
12 | 12345 | School 1 | 54321 | 333333 | Teacher Three | 345678 | Smith | [NAME] | Smith Mary | 8 | 121 | Socials | 2008-11-28 00:00:00 | 85 |  |  | Report #1 | Satisfactory | Comment for this student | 81.625
12 | 12345 | School 1 | 54321 | 666666 | Teacher Six | 345678 | Smith | [NAME] | Smith Mary | 8 | 121 | Science | 2008-11-28 00:00:00 | 76 |  |  | Report #1 | Needs Improvement | Comment for this student | 81.625
12 | 12345 | School 1 | 54321 | 888888 | Teacher Eight | 345678 | Smith | [NAME] | Smith Mary | 8 | 121 | French | 2008-11-28 00:00:00 | 65 |  |  | Report #1 | Needs Improvement | Comment for this student | 81.625
12 | 12345 | School 1 | 54321 | 222222 | Teacher Two | 345678 | Smith | [NAME] | Smith Mary | 8 | 121 | English | 2008-11-28 00:00:00 | 89 |  |  | Report #1 | Satisfactory | Comment for this student | 81.625
12 | 12345 | School 1 | 54321 | 777777 | Teacher Seven | 345678 | Smith | [NAME] | Smith Mary | 8 | 121 | Tech | 2008-11-28 00:00:00 | 77 |  | 77 | Report #1 | Good | Comment for this student | 81.625
12 | 12345 | School 1 | 54321 | 555555 | Teacher Five | 456789 | [NAME] | Sue | [NAME] | 9 | 145 | Tech | 2008-11-28 00:00:00 | 60 |  |  | Report #1 | Needs Improvement | Comment for this student | 64.125
12 | 12345 | School 1 | 54321 | 111111 | Teacher One | 456789 | [NAME] | Sue | [NAME] | 9 | 145 | French | 2008-11-28 00:00:00 | 67 |  |  | Report #1 | Good | Comment for this student | 64.125
12 | 12345 | School 1 | 54321 | 333333 | Teacher Three | 456789 | [NAME] | Sue | [NAME] | 9 | 145 | English | 2008-11-28 00:00:00 | 65 |  |  | Report #1 | Satisfactory | Comment for this student | 64.125
12 | 12345 | School 1 | 54321 | 222222 | Teacher Two | 456789 | [NAME] | Sue | [NAME] | 9 | 145 | Woods | 2008-11-28 00:00:00 | 66 |  |  | Report #1 | Good | Comment for this student | 64.125
12 | 12345 | School 1 | 54321 | 444444 | Teacher Four | 456789 | [NAME] | Sue | [NAME] | 9 | 145 | Foods | 2008-11-28 00:00:00 | 50 |  |  | Report #1 | Needs Improvement | Comment for this student | 64.125
12 | 12345 | School 1 | 54321 | 666666 | Teacher Six | 456789 | [NAME] | Sue | [NAME] | 9 | 145 | PE | 2008-11-28 00:00:00 | 68 |  |  | Report #1 | Needs Improvement | Comment for this student | 64.125
12 | 12345 | School 1 | 54321 | 888888 | Teacher Eight | 456789 | [NAME] | Sue | [NAME] | 9 | 145 | Math | 2008-11-28 00:00:00 | 57 |  |  | Report #1 | Needs Improvement | Comment for this student | 64.125
12 | 12345 | School 1 | 54321 | 777777 | Teacher Seven | 456789 | [NAME] | Sue | [NAME] | 9 | 145 | Science | 2008-11-28 00:00:00 | 80 |  |  | Report #1 | Good | Comment for this student | 64.125
12 | 12345 | School 1 | 54321 | 222222 | Teacher Two | 567890 | Jones | [NAME] | Jones [NAME] | 12 | 112 | French | 2008-11-28 00:00:00 | 87 |  |  | Report #1 | Excellent | Comment for this student | 80.5
12 | 12345 | School 1 | 54321 | 333333 | Teacher Three | 567890 | Jones | [NAME] | Jones [NAME] | 12 | 112 | English | 2008-11-28 00:00:00 | 67 |  |  | Report #1 | Good | Comment for this student | 80.5
12 | 12345 | School 1 | 54321 | 555555 | Teacher Five | 567890 | Jones | [NAME] | Jones [NAME] | 12 | 112 | Math | 2008-11-28 00:00:00 | 78 |  |  | Report #1 | Satisfactory | Comment for this student | 80.5
12 | 12345 | School 1 | 54321 | 111111 | Teacher One | 567890 | Jones | [NAME] | Jones [NAME] | 12 | 112 | Science | 2008-11-28 00:00:00 | 90 |  |  | Report #1 | Excellent | Comment for this student | 80.5