Best Methods and Practices for English Communication Course Streaming

DOI IR Web Site

Search this article

Abstract

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.

Journal

Keywords

Details 詳細情報について

Report a problem

Back to top