English Communication, a course taught at Hiroshima Bunkyo University's Bunkyo English Communication Center (BECC), is a CEFR-aligned task based learning course taught in level-differentiated curriculum streams. To facilitate the BECC's streaming guidelines, the BECC has developed a Microsoft Excel spreadsheet that intelligently and quickly streams students based on their in-house exams scores into ready-to-use class rosters that are balanced by ability level, sex, and department. The Excel spreadsheet utilizes several key formulas such as VLOOKUP,COUNTIFS, AVERAGEIFS, RAND and RANK to simultaneously manipulate the master studentlist, individual class rosters, and the streaming totals chart in order to minimize user inputs while maximizing information available to the streamer. This paper follows the streaming process from start to finish via a series of formula explanations and descriptive screenshots.
Jordan Svien (Thu,) studied this question.