![]() We will designate rows for individual items, and columns for individual students. Double-click at Sheet1 at the left-hand corner of the sliding bar at the bottom, type in Response to rename Sheet1. Entering student responses: Start the MS Excel spreadsheet program. We also assume that the test was given to a class of 15 students. In this tutorial, we assume that the test has 20 questions, among which 15 are in the multiple choice type and 5 are in the constructed response type. The following tutorial illustrates step by step procedures of analyzing assessment data using the MS Excel spreadsheet program. The advantage of using spreadsheet programs such as MS Excel is that it is available virtually anywhere (at school, at home) and on any computer platform (PC and Mac computers). Because using data to improve assessment and instruction primarily involves descriptive and simple inferential statistical analysis, general purpose computer packages such as MS Excel are sufficient. ![]() 1 Using MS Excel to Analyze Data: A Tutorial Various data analysis tools are available and some of them are free.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |