1 / 23

Valid Data, without a recount…

Valid Data, without a recount…. A management data quality process model. W.D. Piotrowski & Lee V. Legutko Leon District Schools Tallahassee, Florida February 28, 2001. Serious Trouble:. Data Warehousing & Data Marts. Serious Trouble:. Data Warehousing & Data Marts

dianne
Download Presentation

Valid Data, without a recount…

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. Valid Data, without a recount… A management data quality process model W.D. Piotrowski & Lee V. Legutko Leon District Schools Tallahassee, Florida February 28, 2001

  2. Serious Trouble: • Data Warehousing & Data Marts

  3. Serious Trouble: • Data Warehousing & Data Marts • Data-based Decision Making

  4. Serious Trouble: • Data warehousing & data marts • Data-based decision making • Validity & Generalizability

  5. What prompted our situation: Citizen protest School Board concern Superintendent response

  6. Causes?? • MIS’s job • Data definition (training) • Consistency of reporting • Business rules: roles & responsibilities • Reporting & Accounting Process • Culture

  7. Business Process & Rules Collaborative Working Partnership: • Originators • Program Administration & Staff • Technical & Information Systems Staff Patience

  8. Business Rules Foundation • Understanding uses, mandates & requirements

  9. Example: Free and Reduced Lunch •    I.      Primary Uses (Data & audit/management requirements): • PurposeKey Dates • Title I* School eligibility/funding Feb. • E-Rate Telecommunications discounts Dec. • School Ratings A+ Schools Feb. • Annual Reports to Parents Parent/Community reports Oct. • Advisory Council Reports School Advisory reports Oct. • DOE School economic indicators Oct. Feb • Federal Program Audits* Federal funding requirements Annually • *Formally Audited

  10. Business Rules Foundation • Understanding uses, mandates & requirements • Specific responsibilities & support needs

  11.         II.      Specific Responsibilities School Level: Principal: designates F/R lunch certification contact (annual), oversees site responsibilities, ensures timely transmissions, aigns-off on periodic & end-of-year status reports.       F/R lunch certification contact: Originates & sends in F/R applications; Attends training and update sessions; Distributes, collects, & verifies applications; Forwards applications to Food Services; Serves as liason to Food Services regarding F/R lunch applications  Food Services:       Gathers DOE/Federal guidelines & interpret; Updates applications and procedures; Policy & procedure changes       Maintains & disseminate procedures/applications to schools       Provides projected start-up lists of approved students       Advertising       Processing & approval of applications; files & maintain applications       Record/Update F/R lunch status in official student record       Verify LCS SIS F/R lunch data completeness and accuracy against MDB       Parent notification letters c)  Technology &Information Services:       Provides enrollment labels on request       Process direct certifications for TANF       PCS/POS SIS database cross-validation & Audit Reports       Maintenance of official data repository; downloads & uploads       Produce management reports for school site & district level staff

  12. Business Rules Foundation • Understanding uses, mandates & requirements • Specific responsibilities & support needs • Process & timelines

  13. Put flowchart here on F/R lunch

  14. Business Rules Foundation • Understanding uses, mandates & requirements • Specific responsibilities & support needs • Process & timelines • Ready access to audit/exception & management reports: site, program, & senior management “views”

  15. Focus on Actual Reports Examples Train in use Have readily available AND Distribute

  16. Business Rules Foundation • Understanding uses, mandates & requirements • Specific responsibilities & support needs • Process & timelines • Ready access to audit/exception & management reports: site, program, & senior management views • Formal Sign-offs & Accountability

  17. Lessons learned: • Change the Culture • Can’t be done without stakeholders: site, program, & IS/IT • Codify & relate to audit standards • Monitor, monitor, monitor…

  18. Microsoft Outlook…

  19. Data Quality is…

  20. Data Quality is… Something you design in, not inspect out.

  21. Thank you. Bill Piotrowski Technology & Information Services Leon District Schools 520 South Appleyard Drive Tallahassee, Florida 32304 piotrowskiw@leon.k12.fl.us (850) 487-7530

More Related