Good day Sir! You are a blessing for 2 reasons: (1) you spent time to create this useful craft; (2) you gave it for free! May you continue to grow as you benevolently help our teachers.
Thank you so much sir! Your item analysis template is by far the most informative, effective, efficient, and user-friendly. Wishing you continued success and blessings!
Hi Sir Carlo! I was browsing some videos about item analysis and I saw your video. I'm taking Prof Ed at the moment. so far I'm having a hard time trying to make my own item analysis, I'm so glad that I stumbled on your profile. God bless you!!!! Grabe, it's amazing how your brain works! This is a very detailed work by the way and I appreciate this.
Hi Carlo, thank you for this very useful template. I am wondering if you could take a look at the 500x200 template, it seems that it has few problems. in the summary sheet, the reliability measurement doesn't show anything, and the same happen to the central tendency. this affect the subsequent sheets, the DiffDisc does not work, the MCDist seems wrong and the printable sheet looks incorrect too. Can you take a look on the 500x200 template, because I'm working with huge number of data, sometimes easily exceeds 800 students.
I have the papers from a multiple choice test and for "fun" I wanted to enter the information into a spreadsheet and use that to handle the grading. Then I realized I not only couldn't figure out the formula I would need to grade the papers, I couldn't find a youtube video that seemed like it taught what I would need to know. Then I found your video and it looks like it will do everything I want (and a lot more). Thank you very much.
Thank you for this innovative idea in calculating the item analysis. It really a big help for my pilot testing of MCQ for my dissertation. Salamat kaayo sir, God Bless po.
Thank you very much for your kindness sir in sharing this tool for item analysis for free. This will really help us, educators, to save time and have a reliable result. God bless you sir and more power to your channel!!!
I'm very amazed to your work and the way you explained the whole template. It is indeed one great work. All I can say are good words from your work, the way you explain and you have a good voice. Salute to you!
have a blessed day sir..thank you so much for this tool you'v work. it really helps a lot. you are amazing, talented, kindhearted. declaring more blessings to you and fam
Thank you so much Sir for sharing this comprehensive video and the free template as well. You've done a great job for us teachers! Kudos! You're amazing! May God bless you more!
Hello sir, thank you so much for this tool, very helpful for teachers like me who have so many appended duties. This tool will help me improve my way of developing test. God bless you more!
Thank you so much. I have spent HOURS working on formulas to analyze the data from an exam my board gives. I appreciate the ease of this template with minimal input from me! I did want to add my exam questions to be able to know which ones we need to look at editing or rejecting, but every sheet is locked. I can put in my raw data, but cannot add my questions. Did you recently make it password protected??
Good day sir, this piece of tool is very helpful in assisting teachers to study within themselves. It identifies whether or not we are doing good in the teaching learning process. Consider the comprehensiveness and straightforwardness of the output. It makes me, as a teacher, look for something more creative and effective, to transfer learning more evident among the learners. Thank you sir and God bless you a hundredfold more!
Thank you, Sir! It has been very helpful. But just wanted to ask po cause in our summary sheet, it did not generate any result for the central tendency of scores, reliability measurement, and in the high group and low group.
Worth a subscription! Thanks po! Sir parequest naman po ng template for INDEX OF MASTERY FOR FORMATIVE ASSESSMENT (25 below item quizzes) po. I hope you'll acknowledge this request Sir! God bless po!
Hello sir, very infomative and helpful as well can you plz tell me how one can change the high group and low group to 27 % as when I am doing analysis of 68 items of MC it is calculating at 18 . thank s
Hi Carlo, there seems to be something wrong with the 500x200 version. In the summary part, 'central tendency' section doesn't give correct results. Since it's locked I can't figure out why. Is it possible that you check and revise it? 100x100 works well but we sometimes ask too many questions in our tests so I would really appreciate if 500x200 is fixed.
Very useful! From what I see, however, it won't report students' scores (just the upper and lower 27%?). Am I missing this somewhere? If it isn't there, would it be possible to add this (or possibly provide the password so that I could add it?). Many thanks.
Hello po. I just want to ask, bakit po sa summary part sa may UG and LG I have 27 students sa grade 6 is 26 lang naka register 13 sa UG and 13 din sa LG. Ganun din sa Grade 4 ko 22 students pero 10 pang sa UG and 11 lang sa LG bali 21 lang instead na 22. Thanks. I'd like to edit nalang sana pero protected po. Sana masagot. Salamat
sir i have a question po, since you have said that we can put short answer on the template you have provided for those who have true or false questions, ano po ilalagay namin na input for the answer key base on the given choices from a-z? iinput nalang po ba na t is for true and f for false ganon nalang po? thank you po so much sir!
Good Day sir,,, Ganda talaga ng files mu sir... Zipgrade + Lem4 madali lng mag Item Analysis..No need na mag encode ng answers,,, copy n paste nlng... .Paano po kaya pwd mailagay ang MPS.. Then, bakit po kaya yung Higher Group and LG kuh tig 9 students lng student on record kuh is 32?
Good day Sir! You are a blessing for 2 reasons: (1) you spent time to create this useful craft; (2) you gave it for free! May you continue to grow as you benevolently help our teachers.
Hello sir, do you have the latest template? Ung meron pong MDAT
In return to your generosity, I am going to watch your video up to its full length and not skip the ads. Thank you so much sir!
Thank you so much sir! Your item analysis template is by far the most informative, effective, efficient, and user-friendly. Wishing you continued success and blessings!
WOW. YOU ARE VERY KNOWLEDGEABLE OBVIOUSLY AN EXPERT IN YOUR CRAFT. THANK YOU SO MUCH PO SIR
Thank you very much for your generosity in sharing this tool for item analysis for free. May God bless you greatly!!!
Thank you so much! your thorough discussion makes it easy for me to navigate the item analysis template sir🤗
Hi Sir Carlo! I was browsing some videos about item analysis and I saw your video. I'm taking Prof Ed at the moment. so far I'm having a hard time trying to make my own item analysis, I'm so glad that I stumbled on your profile. God bless you!!!! Grabe, it's amazing how your brain works! This is a very detailed work by the way and I appreciate this.
Sir, sobrang ganda po. Super easy nga po at lahat ng kelangn sa report nanjn na. Salamat po sa pag share. God bless you po.
Hi Carlo, thank you for this very useful template. I am wondering if you could take a look at the 500x200 template, it seems that it has few problems. in the summary sheet, the reliability measurement doesn't show anything, and the same happen to the central tendency. this affect the subsequent sheets, the DiffDisc does not work, the MCDist seems wrong and the printable sheet looks incorrect too. Can you take a look on the 500x200 template, because I'm working with huge number of data, sometimes easily exceeds 800 students.
I have the papers from a multiple choice test and for "fun" I wanted to enter the information into a spreadsheet and use that to handle the grading. Then I realized I not only couldn't figure out the formula I would need to grade the papers, I couldn't find a youtube video that seemed like it taught what I would need to know. Then I found your video and it looks like it will do everything I want (and a lot more). Thank you very much.
Thank you for this innovative idea in calculating the item analysis. It really a big help for my pilot testing of MCQ for my dissertation. Salamat kaayo sir, God Bless po.
Dear Sir. Thank you very much for a very comprehensive and informative discussion of item analysis. Thank you very much for sharing your template.
Thank you sir. Very helpful po itong video nyo. GOD Bless po!
Very useful sir. Very well done and comprehensive. Thanks po
Thank you for sharing this useful tool for teachers. God bless you.
Thank you very much for your kindness sir in sharing this tool for item analysis for free. This will really help us, educators, to save time and have a reliable result. God bless you sir and more power to your channel!!!
Thank you very much sir! Ang laking tulong po nito.
Thank you po sir! More excel tutorials for newbies like me...
I'm very amazed to your work and the way you explained the whole template. It is indeed one great work. All I can say are good words from your work, the way you explain and you have a good voice. Salute to you!
have a blessed day sir..thank you so much for this tool you'v work. it really helps a lot. you are amazing, talented, kindhearted. declaring more blessings to you and fam
Thank you for this Sir Carlo Excel.. KUDOS.. I will Share it to my Co-teachers
Thank you, Carlo. Excellent explanation - easy to understand and clear. More power!
Thank you very much for this very comprehensive explanation of item analysis, i learn a lot. GOD Bless sir and more power
Thank you sir for sharing your expertise.😊
Thank you very much. I really appreciate your efforts. Thanks a lot again.
Thank you so much for your generosity. what a wonderful, amazing and comprehensive tool and explanation. God bless you sir!
Thank you for this Sir Carlo. I will surely share this with my class. Kudos to you.
Wow! thank you very much sir for sharing this template with comprehensive explanation it will help us a lot .God bless and more power.
thank you sir Carlo, malaking tulong po ito
Thank you,sir! ❤
OMG!!!! YOU ARE REALLY AMAZING. THANK YOU SO MUCH TO THE MOON AND BACK :)
thank you sir. made my work easier.
Very informative video Sir Carlos....Kudos and God bless u always
Thank you sir for sharing your expertise!
Thank you, Carlo!
tHAnk you very helpful poh talaga
Thank you so much Sir for this very informative video.
Excellent discussion and excellent tool! Hats off to you sir!
Thank you SIr.Very helpful .
Thank you so much Sir for sharing this comprehensive video and the free template as well. You've done a great job for us teachers! Kudos! You're amazing! May God bless you more!
Masterpiece!... Hope you give a tutorial how you did that sir...
Thank you, sir Carlo.
Wonderful resource. Thank you.
Thank you very much, sir, for your comprehensive explanation. It has been a huge help to me.
Iam really amazed by your detailed explanation sir
THANK YOU SO MUCH SIR FOR THIS!!!!
thank u for sharing, sir and Godbless
Hello sir, thank you so much for this tool, very helpful for teachers like me who have so many appended duties. This tool will help me improve my way of developing test. God bless you more!
thank you po. God bless!
wow! thank for this sir.. easy to use!
thank you very much sir carlo for the item analysis.
good job Sir, highly commendable... thanks for sharing your expertise...
Wow! thank you very much sir for sharing this template with comprehensive explanation it will help us a lot in our field
Thank you for sharing Sir Carlo, it must have taken you some time to set this up that will bennefit a lot of teachers.
Gppd day. Thank you for sharing.
Thank you so much. I have spent HOURS working on formulas to analyze the data from an exam my board gives. I appreciate the ease of this template with minimal input from me! I did want to add my exam questions to be able to know which ones we need to look at editing or rejecting, but every sheet is locked. I can put in my raw data, but cannot add my questions. Did you recently make it password protected??
VERY HELPFUL SIR. MAY I REQUEST THE TEMPALTE SIR. THANK U SO MUCH AND GOD BLESS
Galing. Thank you so much sir. Godbless
Good day sir, this piece of tool is very helpful in assisting teachers to study within themselves. It identifies whether or not we are doing good in the teaching learning process. Consider the comprehensiveness and straightforwardness of the output. It makes me, as a teacher, look for something more creative and effective, to transfer learning more evident among the learners. Thank you sir and God bless you a hundredfold more!
thank you sir......🥰
Thank you, Sir! It has been very helpful. But just wanted to ask po cause in our summary sheet, it did not generate any result for the central tendency of scores, reliability measurement, and in the high group and low group.
Worth a subscription! Thanks po! Sir parequest naman po ng template for INDEX OF MASTERY FOR FORMATIVE ASSESSMENT (25 below item quizzes) po. I hope you'll acknowledge this request Sir! God bless po!
In the kingdom of the blind you are the one-eyed king. May your tribe increase a hundred folds.
Thank You sir It is very informative..
Great job! How to increase items from 20 to 50?
LEGENDARY
Thank very much sir for this work
Thank you so much sir Carlo.. Dasurve sa subcribe and like..
thank you sooo much sir,you're the best!
Thanks for your help
Tu so much sir God bless
Thank you so much for this! Very helpful!
thank you Sir.
thank you Sir Carlo. Your amazing!
Very useful sir... thank you so much sir.
can i have a copy of your template.. its very useful and big help to me...
Hello sir, very infomative and helpful as well can you plz tell me how one can change the high group and low group to 27 % as when I am doing analysis of 68 items of MC it is calculating at 18 . thank s
THANKYOU SO MUCH FOR THIS
Thanks much Sir!
Thank you very much
Really helpful.. i would like to ask if you have made Item analysis based on Mastery Level (Mastered, Moving towards Mastery, etc)?
Hello sir. No sir, I haven't.
Thank you for your quick response sir :) but the rest of your excels helped a lot :)
Can i have sir a copy? Tnx
It is very useful to use and easy.
How can download this template?
Thank you for sharing your expertise.
Hi sir! Sir, please the watch the video. I stated in the video how to download the template.
Hi Carlo, there seems to be something wrong with the 500x200 version. In the summary part, 'central tendency' section doesn't give correct results. Since it's locked I can't figure out why. Is it possible that you check and revise it? 100x100 works well but we sometimes ask too many questions in our tests so I would really appreciate if 500x200 is fixed.
Hello, thank you.
Thanks much Po❤️
Thank u sir
Thank you sir
Very useful! From what I see, however, it won't report students' scores (just the upper and lower 27%?). Am I missing this somewhere? If it isn't there, would it be possible to add this (or possibly provide the password so that I could add it?). Many thanks.
thank you
than k u so much/god bless u
Sir, unable to paste the responses, kindly suggest
GOOD EVE SIR.. CAN I USE YOUR FILE TO CONDUCT LAC SESSION ON HOW TO USE THIS EXCEL TEST ITM ANALYSIS?
HI SIR... YES SIR GO AHEAD!
Dear sir.. I can't open n download the link
hi sir, can I ask, how can I identify least learned competencies when applied in DepEd Quarter Exams? Thanks for the reply.
Try searching for other item analysis templates either on Google or TH-cam sir. Hopefully, you'll find what you're looking for.
Good day Sir Carlos...Can I ask for the password of the sheet because I need to un protect the sheet and fill in the the password.Thank you!
Hello po. I just want to ask, bakit po sa summary part sa may UG and LG I have 27 students sa grade 6 is 26 lang naka register 13 sa UG and 13 din sa LG. Ganun din sa Grade 4 ko 22 students pero 10 pang sa UG and 11 lang sa LG bali 21 lang instead na 22. Thanks. I'd like to edit nalang sana pero protected po. Sana masagot. Salamat
sir i have a question po, since you have said that we can put short answer on the template you have provided for those who have true or false questions, ano po ilalagay namin na input for the answer key base on the given choices from a-z? iinput nalang po ba na t is for true and f for false ganon nalang po? thank you po so much sir!
Good Day sir,,, Ganda talaga ng files mu sir... Zipgrade + Lem4 madali lng mag Item Analysis..No need na mag encode ng answers,,, copy n paste nlng...
.Paano po kaya pwd mailagay ang MPS.. Then, bakit po kaya yung Higher Group and LG kuh tig 9 students lng student on record kuh is 32?
good eve po sir paano po xa madownload? hindi ko pa xa madownload po, thanks po
Pano i download😊