| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | 每人各項成績最低分不算一次(注意:內容空白並不是該項沒有成績,是為軟體計算方便將其塗成空白,該項成績也不列入小項的平均) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | 屬於英語聽講部份的成績 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | 屬於大一英文部份的成績 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | 標題 | D1-D8:Dictations Q1-Q5:Quiz Pr-P3:Presentations RJ1-RJ6:Reading Journals H1-H2:Home Works Li:Learning Initiative Fin1-Fin2:Final Exam Read: Reading Test Clz:克漏字 Voc:Vocabulary 主動:課堂自動舉手朗讀 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | Part1 | | =AVERAGE(RJ1:RJ8)*3+(H1+H2)/3+主動+(Fin1+Fin2)*.15 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | Read | | =學校期前與期末之閱讀(Reading)成績(參考Proficiency之s-read與f-Read,選其最高者) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | 英文學期 | | =Part1+Read*.25+(Clz+Voc)/25*1.5+4 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | Dic | | =AVERAGE(D1:D8) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | Qz | | =AVERAGE(Q1:Q5) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | PR | | =Pr/2+P2+P3 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | Li | | =Learning Initiative(課堂學習,Notetaking) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | List | | =學校期前與期末之聽力(Listening)成績(參考Proficiency之s-listen與f-Listen,選其最高者) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | 英聽學期 | | =List*.25+Dic*.35+Qz*.4+PR/2.5*1.5+Li*.5 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |