Export to Excel
Since Excel is a popular application for data analysis and can open a variety of data file types, other applications allow you to export to Excel. For example, at the upper left of any Scantron data screen, you can export to Excel.
Some helpful data analysis tools are: Sorting Autofilter Conditional Formatting (Suggest you "Format" with "Patterns" and select a light color to highlight the cell.)

Scantron to Excel: Classroom Data Analysis

Select the Classroom Area icon and then select your class. You will notice the student scores listed for the tests taken.

Select the A+ to view more information.

Test Scores and Item Analysis are probably the most interesting to export into Excel. You should switch to the Table Layout (upper right) first.

Select the "Export CSV" and open the file in Excel.

You now can use the features in Excel to analyze the data.

Point Biserial (Item Analysis Statistic)
The point biserial The point biserial correlation coefficient (PBCC) measures the correlation between the correct answer on an item and the total test score of a student. The point biserial identifies items that correctly discriminate between high and low groups, as defined by the test as a whole (as opposed to only the upper and lower 27% of a group). See Understanding Item Statistics Detail for details. correlation coefficient (PBCC) measures the correlation between the correct answer on an item and the total test score of a student. The point biserial identifies items that correctly discriminate between high and low groups, as defined by the test as a whole (as opposed to only the upper and lower 27% of a group). Generally, the higher the point biserial the better the item discrimination, and thus, the better the item. The following general criteria may be used to evaluate test items.

Excel for Student InformationLinks to Excel TutorialsExcel Tutorials and Information from Internet4Classrooms

Excel Online Help from the University of Wisconsin-Eau Claire

Introduction to Excel from the University of Illinois

Export to ExcelSince Excel is a popular application for data analysis and can open a variety of data file types, other applications allow you to export to Excel. For example, at the upper left of any Scantron data screen, you can export to Excel.

Some helpful data analysis tools are:

Sorting

Autofilter

Conditional Formatting (Suggest you "Format" with "Patterns" and select a light color to highlight the cell.)

Scantron to Excel: Classroom Data AnalysisPoint Biserial (Item Analysis Statistic)

The point biserial The point biserial correlation coefficient (PBCC) measures the correlation between the correct answer on an item and the total test score of a student. The point biserial identifies items that correctly discriminate between high and low groups, as defined by the test as a whole (as opposed to only the upper and lower 27% of a group). See Understanding Item Statistics Detail for details. correlation coefficient (PBCC) measures the correlation between the correct answer on an item and the total test score of a student. The point biserial identifies items that correctly discriminate between high and low groups, as defined by the test as a whole (as opposed to only the upper and lower 27% of a group). Generally, the higher the point biserial the better the item discrimination, and thus, the better the item. The following general criteria may be used to evaluate test items.

## General Point Biserial Interpretation