Test Scoring and Analysis Using SAS

Chapter 2: Reading Test Data and Scoring a Test

Introduction

Reading Data from a Text File and Scoring a Test

Explanation of Program 2.1

Reading Space-Delimited Data

Reading Comma-Delimited Data (CSV File)

Reading Data Directly from an Excel Workbook

Reading an Answer Key from a Separate File

Modifying the Program to Score a Test of an Arbitrary Number of Items

Displaying a Histogram of Test Scores

Matching Student Names with Student IDs

Creating a Fancier Roster Using PROC REPORT

Exporting Your Student Roster to Excel

Conclusion

Introduction

This chapter shows you how to read test data from a variety of sources (e.g., text files, CSV files, Excel workbooks) and how to compare the student responses and the answer key to score a test. In addition, ...