200 likes | 390 Vues
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.
E N D
ADE Global Design Authority Project Review SCQA Format MCESA DSRS/DVT REIL Program January 8, 2013
Situation Complexity Question Answer Presentation Framework • Situation • Complexity • Question • Answer
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
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
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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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