Using+the+WNYRIC+Regents+Item+Map

The mapping database is provided in a Microsoft Excel file and includes a mapping of all New York State regents exam questions from non-restricted January and June test administrations since 2009. Since the file contains questions from all subjects, it will be necessary for you to filter the results to show only your area of interest. To do this, you can use the **Sort and FIlter** function in //Microsoft Excel//.

Download the mapping database file to your computer > When you open the file, your screen should look something like this:
 * Open the file in Microsoft Excel. The illustrations here show the process using Excel 2016 for Windows, but the process is the same for any Windows or Mac version from Excel 2010 to the current version.

>
 * 1) Select Sort and Filter from the ribbon and click on Filter in the drop-down menu.
 * 2) Begin by selecting the course/assessment of interest by clicking on the small drop-down arrow to the immediate right of Assessment in column A
 * 3) In the drop-down menu that results, click on the X next to Select all to remove the Xs from all of the assessments then click on the box next to the assessment you wish to examine and click OK.

You'll need to further filter the results to answer your questions about the data. Look at the examples below to see a couple of different approaches you might follow.

Social Studies examples
Return to the WNYRIC Mapping home page