Analisis Item Bahasa Inggeris Sekolah Menengah Tingkatan 1,2,3

# item analysis for english lower forms pt3

Our principal suddenly ask every teacher to do items analysis in softcopy, so I have came out with this excel spreadsheet. The pink sections which are the total and grade are both automatic. So, you just need to key in white and grey cells only.

At the bottom, the excel auto calculate on how many students that have achieved in every grade.

I hope this items analysis spreadsheet will help you. You can download it from the link below : 

ANALISIS ITEM BAHASA INGGERIS SEKOLAH MENENGAH TINGKATAN 1,2,3


If you want to create your own template, please refer to the following blog pages. They really help me a lot in creating this documents.

http://www.ummimamabiz.com/tutorial-langkah-langkah-mengisi-gred-secara-automatik-menggunakan-microsoft-excel/

http://warnawanyy.blogspot.my/2015/10/microsoft-excel-markah-tahunan-pelajar.html

http://ctwaida.blogspot.my/2009/09/microsoft-excel-hai-kawan2.html