hard teachers also ushered in the final exam each semester: Examinee's platoon, examination room table signing production, student achievement statistical analysis, student transcript production ... How can we improve the efficiency of these jobs? The following is a tutorial area for the efficiency of prawns prepared by the tutorial, hoping to help teachers.
pre-Test preparation:
< Font size= "4" >
This is not only applicable to the register, but also suitable for grade leader, teach the teacher to the statistics of each class Oh!
"ET" skillfully use table to quickly format entry number
"ET" test, examinee by name of the last word sort of implementation method
> Each exam is sorted by last name? Give the students a "surprise" this time! : lol
"ET" use table to make examination table sign
This complex work or let "ET" to help you finish it!
post-Test statistics:
"ET" in table 2007 The average score for a specific scale
"ET" SUMIF, Application of COUNTIF and SUMPRODUCT functions in performance statistics
which student left behind, who made the most progress? "ET" helps you to make accurate statistics.
"ET" Spreadsheet design score notice