ASSESSSS request (10MB) is an updated version of a pre/post ASSESSment SpreadSheet (assessss) as of Sept. 2013.  It includes both .xls and .xlsx versions, the former works with Open Office, it is just a larger file.  The spreadsheet has the ability to provide individual and entire class item analysis, especially helpful after pre-testing to determine instructional focus areas.  Please follow the instructions in the readme.txt file.  Except for the “scratch” worksheet, all remaining worksheets are linked – this means cutting in pasting in the remaining pages will cause data to become scrambled.

Assessssv5b is preset for the Force Concept InventoryTest for Understanding Graphs in KinematicsMechanics Baseline Test, and Lawson Classroom Test of Scientific Reasoning.  It has additional blank spreadsheet and answer keys for Energy Concept Inventory and the Conceptual Survey of Electricity and Magnetism. Users can analyze the FCI and the TUG-K2 by clusters (i.e., subcategory: by each of the 6 dimensions of the force concept). The readmefirst file  provides further information including the operation and history of the spreadsheet.  Please send notification about spreadsheet bugs to

This instrument was developed by Jamie Vesenka, Professor of Physics, Department of Chemistry and Physics, University of New England.

If you are an AMTA member, login on the upper right side for instant access to the spreadsheet. If you are not, complete the form below to request a copy of the ASSESSSS tool (you will receive the document within one to two business days).

After you click Submit, you may have to scroll back up to see the confirmation message.

AMTA is a membership organization, and your membership supports development and distribution of resources such as this spreadsheet. If you are not already a member, we encourage you to join here.

If you’re not yet ready to join, AMTA is a 501(c)3 organization; your donations are always welcome and tax deductible. Click the link on the right-side menu to make a donation ($10 suggested for the ASSESSSS document).

One Response to ASSESSSS request

  1. Diana Fisher says:

    I have taught system dynamics modeling for over 20 years at the high school level in algebra, pre-calculus, calculus, and designed a year-long modeling course for high school freshmen through seniors. System dynamics modeling uses icon-based software to model dynamic feedback systems. I would like to learn how to connect to your organization and perhaps share some of my expertise and learn more about the modeling your organization provides. After retiring from high school teaching I returned to the university and am in the dissertation phase of my doctorate in System Science at Portland State University.

Leave a Reply

Your email address will not be published. Required fields are marked *


− 6 = two

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <span style="">