testitemanalysiscalculator v2 excel 2003

3
<<<<< Test Item Analysis Calculator >>>>> Subject: Introduction to Hospitality Industry Teacher: Michael P. Celis # Of Correct Answers Student Score Period: Preliminary Grade(s): Date Of Assessment: July 15, 2014 # Of Questions: 0 # Of Students 22 <<< Student # 1 ALMODIENTE, JED 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 31 #DIV/0! 2 ARGUELLES, LYE ANN KAT 2 1 1 1 1 1 1 1 1 8 #DIV/0! 3 BACALUCOS, GLORY JANE 3 1 1 1 1 1 1 1 7 #DIV/0! 4 BALASA, REYNOLD OLIVAR 4 1 1 1 1 1 1 1 7 #DIV/0! 5 BELONIO, JAMES RONEL 5 1 1 1 1 1 1 1 7 #DIV/0! 6 BILLANES, MICHELLE 6 1 1 1 1 1 1 1 7 #DIV/0! 7 BOCALA, JOYLYN 7 1 1 1 1 1 1 1 1 8 #DIV/0! 8 BULAQUEÑA, CHRISTIAN 8 1 1 1 1 1 1 1 7 #DIV/0! 9 CASUGBO, MARCELA 9 1 1 1 11 1 1 1 7 #DIV/0! 10 COMPARACION, CAMELLA 10 1 1 1 1 1 1 1 7 #DIV/0! 11 CORTEL, ANGELA 11 1 1 1 1 1 5 #DIV/0! 12 DELA CRUZ, MEL CLEMEN 12 1 1 1 1 1 1 1 7 #DIV/0! 13 FLAGA JR., JERYM 13 1 1 1 1 1 1 1 1 8 #DIV/0! 14 FUENTES, ARGEL 14 1 1 1 1 1 1 1 7 #DIV/0! 15 LOJARES, DANDY ALDRED 15 1 1 1 1 1 1 1 7 #DIV/0! 16 OBLIGAR, CAREN RAY 16 1 1 1 1 1 1 6 #DIV/0! 18 OLANO, ROMAN 17 1 1 1 1 1 1 1 7 #DIV/0! 19 PADASAS, CHARISH JOY 18 1 1 1 1 1 1 1 1 8 #DIV/0! 20 PAGLINAWAN, MARIE SHA 19 1 1 1 1 1 1 1 7 #DIV/0! 21 TOLENTINO, IRENEO JR. 20 1 1 1 1 1 1 1 7 #DIV/0! 22 TORRES, BEVERLY 21 1 1 1 1 1 5 #DIV/0! 23 VILLARUEL, YRA 22 1 1 1 1 1 5 #DIV/0! 23 0 #DIV/0! 24 0 #DIV/0! 25 0 #DIV/0! 26 0 #DIV/0! 27 0 #DIV/0! 28 0 #DIV/0! 29 0 #DIV/0! 30 0 #DIV/0! 31 0 #DIV/0! 32 0 #DIV/0! 33 0 #DIV/0! 34 0 #DIV/0! 35 0 #DIV/0! Of Items Answered Correctly 22 22 6 18 19 19 21 2 1 1 1 1 1 1 1 1 1 1 0 1 1 1 3 5 6 3 1 6 3 2 1 0 0 0 0 0 1 0 1 1 100% 100% 27% 82% 86% 86% 95% 9% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 0% 5% 5% 5% 14% 23% 27% 14% 5% 27% 14% 9% 5% 0% 0% 0% 0% 0% 5% 0% 5% 5% Directions: Enter teacher, class information, student names etc. in the brown cells. When entering data in the blue or white cells, enter a character only if the question was answered CORRECTLY. Do not enter data in the '# Of Questions' OR ' # Of Students' cells. ***NOTICE*** There are two graph tabs at the bottom of the spreadsheet. Question# / Item > >> Student Names % Of Students Who Answered The Question/Item Correctly

Upload: michael-p-celis

Post on 07-Nov-2015

9 views

Category:

Documents


4 download

DESCRIPTION

ia

TRANSCRIPT

Test Item Analysis Calculator

Test Item Analysis Calculator>Directions: Enter teacher, class information, student names etc. in the brown cells. When entering data in the blue or white cells, enter a character only if the question was answered CORRECTLY. Do not enter data in the '# Of Questions' OR ' # Of Students' cells. ***NOTICE*** There are two graph tabs at the bottom of the spreadsheet.Subject:Introduction to Hospitality IndustryTeacher:Michael P. Celis# Of Correct AnswersStudent ScorePeriod:PreliminaryGrade(s):Date Of Assessment:July 15, 2014# Of Questions:0# Of Students22Question# / Item > >> Student Names