This spreadsheet was originally created in 2003 by a person no longer with the organization. It was created to organize all of the data collected via an online survey in Qualtrics, generated in a program that occurs twice a year. Over the last 10 years, there have been over 1300 respondents who answered hundreds of questions with a numeric answer in a four-party survey. The data would then be transferred to the four worksheets of the Excel model, which generated charts showing each individual answers, group or cohort means, and all-program means.
This same spreadsheet has been used since 2003 and over the years it has been altered and is no longer accurate. This was made evident in this last program&acirc;€™s iteration, when one of the all-program means became 100%. We are not sure when exactly things went awry, but we can see when major changes were made like adding a 4th part to the survey and to the spreadsheet. Also new columns were added with extra, unnecessary identifying data (i.e. IP address, date and time started and finished). Because the size of the data is so large (13 MB), it has been suggested to us that possible solutions include combining all four worksheets into one, and to instead create a new model in Access.
We are looking for two different projects to be completed.
1) Initially we need you to manually work out the spreadsheet&acirc;€™s formulas in order to get the correct all-program means for the current program (and check that everything else is right as well) so that we can quickly get booklets ready for the people in the program. (Sample booklet sent.) This first project does NOT involve creating an entirely new model.
2) If the first is successful, the next assignment will be to complete overhaul the Spreadsheet model, posssibly in Access, and create a manual that clearly explains the model for people in the future to work with.