[Item Analysis Products] [Item Analysis Services] [Item Analysis Pricing] [Item Analysis Templates] [Item Analysis Directions]

1. Content Consultant Services

Each Summit County ESC content consultant can provide services to Summit County local and affiliate districts in half-day increments. Item analysis services include the following:

  • “Red flagging” district data, examining trends, and reviewing results with district personnel. The red-flagging process involves examining incorrect student responses and determining which questions need to have an alternate response(s) more closely examined to determine why it was incorrectly chosen by students
  • “Red flagging” building data, examining trends and reviewing results with building personnel
  • Large group demonstrations showing how to filter and sort district or building data in that discipline. This may reveal content issues in need of consideration in the interpretation of the data
  • Follow up consultation

2. Technology Consultant Services

Summit County ESC technology consultants will do hands-on in-services with Summit County local and affiliate district/building personnel using the district's lab facilities. When using district facilities, a district technology person must be present to handle any possible problems that might occur with the district technology. All computers being used must have Microsoft Excel 97 or later. SCESC consultants can bring with them six PC laptops to help with any training. One item analysis trained technology consultant must be present at all times for every seven participants. District personnel who have been trained at an SCESC Item Analysis workshop can be used in this capacity. Those attending can be shown how to:

  • Use Excel to manipulate the data already placed in the templates
  • Sort safely so all the data stays in sync
  • Use autofilters
  • Do their own red flagging of data
  • Use Internet hyperlinks

3. Item Analysis Workshops

These half-day sessions can be provided to districts in the SCESC lab. the workshop covers the following:

  • Learn to import district text file (purchased separately from NCS Pearson) into Excel
  • Learn to create worksheets for each report
  • Learn to cut and paste district, building, and classroom data into separate worksheets
  • Analyze data by sorting and filtering
  • Analyze through addition of Red Flag information and analysis of questions


Summit County ESC

Phone: 330-945-5600, Fax: 330-945-6222