Education Statistics System (ESS) Upgrade

Specifications include, but are not limited to: •Analyze the existing ESS application’s architecture, functionality, and administrative capabilities to understand current strengths and weaknesses.•Create a new ESS application that is web based and has the following abilities: oDesign the application so there can be multiple administrators. The Lead Admin would have overall responsibility for the application. Each bureau within the DOE will have a Bureau Admin that is responsible for managingtheir surveys. The Bureau Admins will be able to add to/modify the pool of questions and other configuration settings (e.g. user access) for their surveys.Bureau Admins would manage one or more surveys with the Lead Admin having full rights to all surveys. oProvide a bank of questions that the Lead and Bureau Admins can leverage to create/modify the survey.oProvide a band of validations so as to not duplicate one validation in several placesoSurvey functionality provided should include:The ability for the Lead and Bureau Admins to:•Upload/import questions•Modify questions once they have been added to a surveyAbility to save, submit and certify (if needed)Skip logic for questionsPrepopulate summary data in surveysAbility for users to run reports to pull the data from prior years by links within the surveyoLink the survey mailing lists to the mailing lists (e.g. superintendent list) in the DOE’s common database (this is where the DOE’s master data is located). oProvide the Lead and Bureau Admins with the ability to create validations on the survey fieldsDynamic validations (e.g. decision trees, control totals based on inputs, etc...)Ability to have fields on survey that summarize data inputs (e.g. user enters number of staff per grade and a total row in the survey is then displayed automatically).Data typeComparisons to prior surveys (could be link)If yes, than a response should be > 0If answered x in one survey, x is brought into a new survey where additional details are needed and need to add up to the original value. oProvide the Lead and Bureau Admins with scheduling functionality:Admins can schedule the surveysAdmins can create and schedule the reminder messagesoSecurityLeverage the existing application security.Provide the Lead and Bureau Admins with the ability to maintain the security: •Role based•Single Sign on (SSO)oProvide logging capabilities (i.e. who, what, when, where). We want to know what was changed along with who made the change and when, and to which survey. •Deploy the new ESS application. oThe vendor to assist with transition to the new ESS applicationoThe vendor to work with DOE staff to re-create existing the surveys in the new application.oThe vendor to document all system changes to support end-user knowledge. •Training - P repare administrators/users adequately to use the new system from the day of deployment, including maximum knowledge transfer to allow the administrators to conduct its own training in the future.