Milestone 5- Improved Diagnostic

This file will produce the information used in the diagnostic test.

https://www.dropbox.com/s/gwyd1tejb632qwg/Data%20set%20with%20TestOverall%203.11.14.xlsm

What we have been spending most of our time on is the automation of the numbers going into the diagnostic tests that was explained in the previous Milestone. You are able to add or delete rows of data and the Macro will still handle this and produce the correct Stanine numbers.

This file accomplishes three things right now:

1) Fill in the correct grades for each UserId
2) Create a "TestOverall" row that accumulates all "Overall" test rows and creates a single test score
3) Calculate the Stanine for each test

These options are fully automated by using Macros. The specific Macro is "Module1.filters". You are able to view the code along with the comments explaining the code. There is also a visualization on the last tab that could be used on the dashboard.


Our next steps will be to include the accurate Stanines to specific sections such as Algebra or Reading Comprehension. This will be done by comparing students in the same grade level who took the same test. We also need to correctly filter out the users that have omitted too many questions because we have determined that it is not valid data and shouldn't be included to calculate the Stanines.

One problem we had that needs to be corrected is a rounding issue for administering the Stanines. This is a small bug in our code that will be fixed by the next milestone. Without getting into too much technical detail, the result of the bug is that there will either be a slight overflow or shortfall of Stanine numbers given in relation to the number of actual tests.