際際滷

際際滷Share a Scribd company logo
Data Visualization
of Great Neck Public School Budget Allocation 2016-2017
Ding Li 2016.04
2
:
$5M In Deficit. Programs Cut. Want To Read School Budget For The First Time
School Budget
in Scanned PDF File
Data
in Excel
Visualization
in Tableau
113 Pages, Hard to Figure Out
http://www.greatneck.k12.ny.us/gnps/pages/budget
/PrelimWorkBudget2016-17.pdf
Converted PDF to Excel
http://www.investintech.com/
Interactive Visualization
https://public.tableau.com/profile/ding.li#!/vizhome
/great_neck_school_budget_2016/BudgetOverview
3
:
The Education Fund For Each Student in Great Neck Is High
Students
6,399
Teachers
585
Budget
$218.9M
Budget
/Student
$34K
*Students and teachers are from 2015-2016 data at https://en.wikipedia.org/wiki/Great_Neck_School_District
4
 Programs for Handicapped Children
 $29.8M, 13.6% of Budget
 How many students in the program?
 Employee Benefits
 $54.1M, 24.7% of Budget
 Contract Transportation
 $10.7M, 4.9% of Budget
5
 Instructional Salaries
Programs for Handicapped Children
 $22.6M, 10.3% of Budget
 Healthcare Insurance
 $23.8M, 10.9% of Budget
 Social Security
 $9.3M, 4.3% of Budget
6
 Programs for Handicapped Children
 $2.85M
 Employee Benefits
 $598K
 Other Debt
 $420k
 New this year
7
 Healthcare Insurance
 $1.81M
 Instructional Salaries
Programs for Handicapped Children
 $1.35M
 Contractual and Other
Programs for Handicapped Children
 $825K
8
Question:
 Can we handle such increasing costs in the future?
 Do we need to cut more instramural programs in the future?
Programs for Handicapped Children
Budget: $29.8M
Increases: $2.85M
Healthcare Insurance
Budget: $23.8M
Increases: $1.35M

More Related Content

Great neck school budget 2016-2017 analysis

  • 1. Data Visualization of Great Neck Public School Budget Allocation 2016-2017 Ding Li 2016.04
  • 2. 2 : $5M In Deficit. Programs Cut. Want To Read School Budget For The First Time School Budget in Scanned PDF File Data in Excel Visualization in Tableau 113 Pages, Hard to Figure Out http://www.greatneck.k12.ny.us/gnps/pages/budget /PrelimWorkBudget2016-17.pdf Converted PDF to Excel http://www.investintech.com/ Interactive Visualization https://public.tableau.com/profile/ding.li#!/vizhome /great_neck_school_budget_2016/BudgetOverview
  • 3. 3 : The Education Fund For Each Student in Great Neck Is High Students 6,399 Teachers 585 Budget $218.9M Budget /Student $34K *Students and teachers are from 2015-2016 data at https://en.wikipedia.org/wiki/Great_Neck_School_District
  • 4. 4 Programs for Handicapped Children $29.8M, 13.6% of Budget How many students in the program? Employee Benefits $54.1M, 24.7% of Budget Contract Transportation $10.7M, 4.9% of Budget
  • 5. 5 Instructional Salaries Programs for Handicapped Children $22.6M, 10.3% of Budget Healthcare Insurance $23.8M, 10.9% of Budget Social Security $9.3M, 4.3% of Budget
  • 6. 6 Programs for Handicapped Children $2.85M Employee Benefits $598K Other Debt $420k New this year
  • 7. 7 Healthcare Insurance $1.81M Instructional Salaries Programs for Handicapped Children $1.35M Contractual and Other Programs for Handicapped Children $825K
  • 8. 8 Question: Can we handle such increasing costs in the future? Do we need to cut more instramural programs in the future? Programs for Handicapped Children Budget: $29.8M Increases: $2.85M Healthcare Insurance Budget: $23.8M Increases: $1.35M