{"created":"2023-07-25T10:12:57.124186+00:00","id":79,"links":{},"metadata":{"_buckets":{"deposit":"6709f5b7-ea17-4117-b1d8-b3483c1db488"},"_deposit":{"created_by":7,"id":"79","owners":[7],"pid":{"revision_id":0,"type":"depid","value":"79"},"status":"published"},"_oai":{"id":"oai:h-bunkyo.repo.nii.ac.jp:00000079","sets":["50:83:86"]},"author_link":[],"item_10002_biblio_info_7":{"attribute_name":"bibliographic_information","attribute_value_mlt":[{"bibliographicIssueDates":{"bibliographicIssueDate":"2019-12-19","bibliographicIssueDateType":"Issued"},"bibliographicPageEnd":"33","bibliographicPageStart":"11","bibliographicVolumeNumber":"54","bibliographic_titles":[{"bibliographic_title":"広島文教大学紀要","bibliographic_titleLang":"ja"},{"bibliographic_title":"Bulletin of Hiroshima Bunkyo University","bibliographic_titleLang":"en"}]}]},"item_10002_description_19":{"attribute_name":"フォーマット","attribute_value_mlt":[{"subitem_description":"application/pdf","subitem_description_type":"Other"}]},"item_10002_description_5":{"attribute_name":"抄録","attribute_value_mlt":[{"subitem_description":"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.","subitem_description_language":"en","subitem_description_type":"Abstract"},{"subitem_description":"英語コミュニケーションは広島文教大学のイングリッシュコミュニケーションセンター（BECC）で教授されている科目の一課程であり，CEFR（ヨーロッパ言語共通参照枠）レベルに則ったタスク中心法のコースで，様々なレベルのカリキュラムを使用したコースである。BECCのストリーミングガイドライン（各レベルへの学生の振り分け）を容易にするため，BECCではマイクロソフトのエクセルスプレッドシートを作成し，これにより内部テストの点数を基に，技能レベルや性別，学部をバランスよく調整し，学生を理性的かつ迅速に振り分け，即使用可能なクラス名簿の作成ができるようになった。エクセルスプレッドシートではVLOOKUPやCOUNTIFS，AVERAGEIFS，RANDやRANKといった何種類かの重要な数式を用いることで，使用者にとっては最小限の入力で最大限の情報利用を可能にするため，原盤となる学生名簿や各クラス名簿，コース全体の総合表を同時に処理することができる。本論はこの振り分けの過程を一連のエクセル数式の説明と明確なスクリーンショットを通して，初めから最後まで解説するものである。","subitem_description_language":"ja","subitem_description_type":"Abstract"}]},"item_10002_identifier_registration":{"attribute_name":"identifier_registration","attribute_value_mlt":[{"subitem_identifier_reg_text":"10.51095/kiyo.54.02","subitem_identifier_reg_type":"JaLC"}]},"item_10002_publisher_8":{"attribute_name":"出版者","attribute_value_mlt":[{"subitem_publisher":"広島文教大学","subitem_publisher_language":"ja"}]},"item_10002_source_id_11":{"attribute_name":"item_10002_source_id_11","attribute_value_mlt":[{"subitem_source_identifier":"AA12881318","subitem_source_identifier_type":"NCID"}]},"item_10002_source_id_9":{"attribute_name":"item_10002_source_id_9","attribute_value_mlt":[{"subitem_source_identifier":"24351660","subitem_source_identifier_type":"PISSN"}]},"item_10002_subject_21":{"attribute_name":"日本十進分類法","attribute_value_mlt":[{"subitem_subject":"370","subitem_subject_scheme":"NDC"}]},"item_10002_version_type_20":{"attribute_name":"出版タイプ","attribute_value_mlt":[{"subitem_version_resource":"http://purl.org/coar/version/c_970fb48d4fbd8a85","subitem_version_type":"VoR"}]},"item_creator":{"attribute_name":"著者","attribute_type":"creator","attribute_value_mlt":[{"creatorNames":[{"creatorName":"Svien, Jordan","creatorNameLang":"ja"},{"creatorName":"スヴェン, ジョーダン","creatorNameLang":"ja-Kana"},{"creatorName":"Svien, Jordan","creatorNameLang":"en"}]}]},"item_files":{"attribute_name":"ファイル情報","attribute_type":"file","attribute_value_mlt":[{"accessrole":"open_date","date":[{"dateType":"Available","dateValue":"2023-01-26"}],"displaytype":"detail","filename":"kenkyukiyo54(Jordan).pdf","filesize":[{"value":"3.3 MB"}],"format":"application/pdf","licensetype":"license_note","mimetype":"application/pdf","url":{"label":"kenkyukiyo54(Jordan).pdf","url":"https://h-bunkyo.repo.nii.ac.jp/record/79/files/kenkyukiyo54(Jordan).pdf"},"version_id":"6f6ba699-000c-4378-a135-cd6046e7a844"}]},"item_language":{"attribute_name":"言語","attribute_value_mlt":[{"subitem_language":"eng"}]},"item_resource_type":{"attribute_name":"item_resource_type","attribute_value_mlt":[{"resourcetype":"departmental bulletin paper","resourceuri":"http://purl.org/coar/resource_type/c_6501"}]},"item_title":"Best Methods and Practices for English Communication Course Streaming","item_titles":{"attribute_name":"タイトル","attribute_value_mlt":[{"subitem_title":"Best Methods and Practices for English Communication Course Streaming","subitem_title_language":"en"}]},"item_type_id":"10002","owner":"7","path":["86"],"pubdate":{"attribute_name":"PubDate","attribute_value":"2023-01-26"},"publish_date":"2023-01-26","publish_status":"0","recid":"79","relation_version_is_last":true,"title":["Best Methods and Practices for English Communication Course Streaming"],"weko_creator_id":"7","weko_shared_id":-1},"updated":"2024-12-26T02:27:53.638834+00:00"}