1 / 20

ADE Global Design Authority Project Review

ADE Global Design Authority Project Review. SCQA Format MCESA DSRS/DVT REIL Program January 8, 2013. Situation. Complexity. Question. Answer. Presentation Framework. S ituation C omplexity Q uestion A nswer. Situation. Complexity. Question. Answer. Objectives.

meira
Download Presentation

ADE Global Design Authority Project Review

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ADE Global Design Authority Project Review SCQA Format MCESA DSRS/DVT REIL Program January 8, 2013

  2. Situation Complexity Question Answer Presentation Framework • Situation • Complexity • Question • Answer

  3. Situation Complexity Question Answer Objectives • Align with REIL Grant Program (TIF) • Inform and improve instruction for teachers & principals • Performance pay for effective teachers • Arizona SB 1040 & HB 2823 • Improve educator performance • Align with the AELAS vision • Leverage Ed-Fi • Opt-in approach with non-MCESA districts • White label solution

  4. Situation Complexity Question Answer Factors • Looming May 2013 deadline • Limited resources • Time • People • New people would take time to get acclimated • Organizational process maturity model • Project Management • Obtaining business requirements • Methodology • Development maturity • Never built solution of this magnitude/complexity • Integration Management • Change Management

  5. Situation Complexity Question Answer Approach • Solution to be delivered in phases • Four milestones • Phase I – May, 2013 • Phase II – September, 2013 • Phase III – May, 2014 • Phase IV – May, 2015 • Each milestone delivers new or enhanced capability • Phases are sequentially • Solution evolution • Minimal throw away • Refactoring of components with each milestone • There may be version releases in between milestones • Allows solution to grow and provide needed features

  6. Situation Complexity Question Answer Phase I • Data Layer • Build upon the Ed-Fi ODS and start the ADE ODS v1.0 • Ed-Fi is extensible schema • Ed-Fi is not a static solution • Ed-Fi evolves to an agencies needs • Import Enterprise, HQT, TODCT and TNL data only • TNL & HQT gets SQL Server Integration Services (SSIS) • Enterprise & TODCT sources get SQL Scripts • Enterprise to be built out as part of AED3S project • Hosted TBD • Reporting Layer • Develop new or use existing SQL Server Reporting Services (SSRS) reports pull from ADE ODS v1.0 • Hosted on DEVAPP40/TestApp40/ProdApp40 (Cost unknown)

  7. Situation Complexity Question Answer Phase I (Cont) • Presentation Layer • New Model View Controller .NET 4.0 application (technology) • Renders reports provided by SSRS • Email Inquiry • Integrates with IMS for authentication/authorization services • Source code stored in TFS MCESA-AnalyticsIntegrationfolder • Hosted on DevWeb40/TestWeb40/ProdWeb40 (Cost unknown)

  8. Phase I Conceptual

  9. Situation Complexity Question Answer Phase II • Data Layer • Modify ADE ODS v1.0 to include additional data domains to v2.0 • Develop DSRS OLTP database for Inquiry management and data approval • Import Basis Research, Assessment and Student Roster data • Assessment and Student Roster get SSIS • Basis Research get SQL Scripts • Hosting TBD • Reporting Layer • Develop new or use existing SSRS reports to display additional data domains • Hosted on DEVAPP40/TestApp40/ProdApp40 (Cost unknown)

  10. Phase II (Cont) • Presentation Layer • Modify MVC .NET application developed in Phase I to consume new data • Provide links to new SSRS reports • IMS integration does not change from Phase I • Inquiry Management and Data Approval • TFS folder does not change from Phase I • Hosted on DevWeb40/TestWeb40/ProdWeb40 (Cost unknown)

  11. Phase II Conceptual

  12. Situation Complexity Question Answer Phase III • Data Layer • Modify ADE ODS v2.0 to include additional data domains to v3.0 • Develop ADE Dashboard database v1.0 based off the Ed-Fi Dashboard database • Import HR Personnel Data from SIS (salary augmentation, career pathway designation) • Develop SSIS packages for HR Personnel data import • Modify Ed-Fi SSIS packages to import data into dashboard DB • Hosting TBD • Reporting Layer • Modify SSRS reports to pull from ADE Dashboard DB • Develop new SSRS reports with for new data elements • Hosted on DEVAPP40/TestApp40/ProdApp40 (Cost unknown)

  13. Phase III (Cont) • Presentation Layer • Modify MVC .NET application developed in Phase II to consume new data domain • Provide links to render modified SSRS reports • IMS integration does not change from Phase II • Inquiry submission, management and approval will be enhanced from Phase II • TFS folder does not change from Phase II • Hosted on DevWeb40/TestWeb40/ProdWeb40 (Cost unknown)

  14. Phase III Conceptual Design

  15. Situation Complexity Question Answer Phase IV • Data Layer • Modify ADE ODS v3.0 to include new data to v4.0 • Modify ADE Dashboard v1.0 to include new data to v2.0 • Import internally calculated Value Added and REIL score and HUPP data • Develop SSIS packages for import to ADE ODS • Enhance Ed-Fi SSIS packages for import into ADE Dashboard • Hosting TBD • Reporting Layer • Develop new or modify existing SSRS reports to pull new data domain from new ADE ODS v4.0 • Hosted on DEVAPP40/TestApp40/ProdApp40 (Cost unknown)

  16. Phase IV (Cont) • Presentation Layer • Modify MVC .NET application developed in Phase III to consume new data domain • Provide links to render new or modified SSRS reports • IMS integration does not change from Phase III • Inquiry submission, management and approval will not change from Phase III • TFS folder does not change from Phase III • Hosted on DevWeb40/TestWeb40/ProdWeb40 (Cost unknown)

  17. Phase IV Conceptual

  18. Situation Complexity Question Answer Budget Overview • Software Needs • Secure FTP component for SSIS • MVC 3rd party controls • Hardware Needs • Capacity Planning is required • ADE ODS Hosting TBD • ADE Dashboard Hosting TBD • Viability of SSRS and application hosting on MCESAtopology and cost • Staffing Needs • Resources from the Michael & Susan Dell Foundation? • Solutions Architect • Data Architect • Database Designer • .NET Developer with MVC 4.0 experience • SSRS/SSIS Developer • Quality Assurance • Customer Support • TFS Expert (Part-time)

  19. Situation Complexity Question Answer Supplemental requirements • Constraints • MCESA Topology • SQL Server Reporting Services • Usability in Ed-Fi Dashboards is limited • Dependencies • IMS sp1 completion • Organizational Hierarchy build-out • TFS Build and Continuous Integration • Risk • ODS Querying in Phase I & II • Capacity Planning • Support Model Planning

  20. Any Questions?

More Related