Final Project: Schools

1. Final Project: Schools Mayari Serrano A. BIOL 595

2. Obtaining current data of all schools in Indiana. • There are approximately 1600 public schools in the state. • Schools selected based in its non white population => Project target diverse schools. Problem

3. IDOE

4. IDOE

5. IDOE

6. LWP::Simple • DBI • Data::Dumper • Spreadsheet::WriteExcel Packages

7. Input file CodesSI.txt (= 0013 ,) • School Id codes. • Store codes in the array target. • Use “get” to obtain data from each element in the array. • Information requited: • Principal First Name • Principal Last Name • Title • Address • City • Zip Code • County • Demographic data • Meals data • Storage all the schools’ information in an array of hashes. Steps for obtaining data

11. Create database • Define necessary parameters, length, and characteristics • Send information • Use quote to send information that could contain quotes. • Sent data in the same order as you want to be stored Steps to create Database

13. Retrieve information from database • Information of schools based on white percentage. • Create text file (tab delimited) • Create excel file Steps to create documents

17. 0013 (Perl change the value) • Quotation marks Lessons learned

18. Q & A