{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Funding","Priorities","Budget"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Funding","index":0,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Joseph McAvinnue Elementary School"]
[null,"School Year 20-21 Budget",null,null,null,null,"Comparison to previous year budget"]
[null,"Category","Students","Weight","Amount",null,"Year","19-20","20-21","Change"]
[null,"Weights",null,null,null,null,"Enrollment",472,471.8,{"$f":"I4-H4","v":-0.19999999999998863}]
[null,"All students",471.8,4500,{"$f":"C5*D5","v":2123100},null,"FSF Budget",4820685,4820685,{"$f":"I5-H5","v":0}]
[null,"Economically disadvantaged",316,1575,497700,null,"Other Funding",{"$f":"SUM(E27:E28)","v":293767.15000000002},{"$f":"SUM(E27:E28)","v":293767.15000000002},{"$f":"I6-H6","v":0}]
[null,"Low incoming performance",0,900,0,null,"Total Budget",{"$f":"SUM(H5:H6)","v":5114452.1500000004},{"$f":"SUM(I5:I6)","v":5114452.1500000004},{"$f":"I7-H7","v":0}]
[null,"Grades PreK-3",379.8,1575,598185,null,"$ per pupil",{"$f":"H7/H4","v":10835.703707627119},{"$f":"I7/I4","v":10840.297053836372},{"$f":"I8-H8","v":4.5933462092525588}]
[null,"Grade 9",0,3750,0]
[null,"ELL below Level 3",70,2750,192500]
[null,"ELL Level 3 and above",83,1400,116200]
[null,"SWD substantially separate",24,22500,540000]
[null,"SWD inclusion/language",38,6250,237500]
[]
[null,"Baseline"]
[null,"ELL Baseline",null,null,0]
[null,"SWD Baseline",null,null,0]
[null,"General Ed Baseline",null,null,0]
[]
[null,"Other Policies"]
[null,"Transition amount",null,null,515500]
[null,"Budget Exceptions",null,null,0,"Exception Reason: "]
[]
[null,"FSF Total"]
[null,null,null,null,{"$f":"SUM(E5:E13,E16:E18,E21:E22)","v":4820685}]
[null,"Funding from outside FSF"]
[null,"Title I",null,null,{"$f":"Budget!C152","v":168725}]
[null,"Other positions provided outside of FSF",null,null,{"$f":"SUM(Budget!G87,Budget!G93,Budget!G81, Budget!G115, Budget!G139:G142)","v":125042.15000000001}]
[]
[null,"Total funding"]
[null,null,null,null,{"$f":"SUM(E25,E27,E28)","v":5114452.1500000004}]
[]
[]
[null,"Summary"]
[null,"The McAvinnue's funding decreased due to weights but was supplemented by transition policy."]

{"sheet":"Priorities","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,4],[9,1,9,2],[10,1,10,2],[4,1,4,2],[6,1,6,2],[7,1,7,2],[5,1,5,2],[1,0,1,4],[2,1,2,2],[3,1,3,2],[8,1,8,2]]}
["Connect Quality Improvement Plan priorities to Budgeting Implications"]
["Directions: Take a moment to reflect on your school's priorities as stated in your Quality Improvement Plan, and how they will inform how you choose to spend your SBB allocation. This tab gives you space to identify your most urgent student needs, the strategies to address those needs, and the implications that this all has for your budget.\nReplace the examples in the yellow boxes with your own priorities, strategies, and budgeting implications. \n"]
[]
[null,"Urgent Student Needs",null,"Strategies to Address Needs ","Budget / Staffing Implications"]
[null,"\nThese are the student needs that principals have identified as the most urgent needs at their schools. Urgent needs should be as specific as possible (see examples provided). Depending on your district's theory of action, this information can be identified by the principal OR it could be provided by the district.",null,"\nAfter identifying the most urgent needs, principals should identify the strategies they will adopt to address those needs. As with the urgent needs, principals could decide this on their own or be given a menu of options by the district.","\nThis is where the principals will take theory to reality. Different strategies require different investments. Hence, in this section, principals are expected to list the cost of their strategies. What position will they need to hire? What materials will they need to purchase? Any investments required for the strategy to be successful should be listed here."]
[null,"Key Question: What are the urgent student needs you would like to focus on next year? ",null,"Key Question: What strategies and changes will you implement next year to address these needs? ","Key Questions: What are the resource implications for these strategies? Do you need to hire additional people? How much will this all cost you?"]
[1,"Additional support for our Special Education student population to ensure individual needs are being met during specialized instruction and allow for increased co-teaching opportunities within each grade level (PreK – Grade 4) \n\n",null,"We will have a Special Education Teacher at each grade level that will allow for increased opportunity to implement the co-teaching instructional model and increased fidelity of service delivery. ","Investigating the possibility of hiring an additional full-time Special Education Teacher."]
[2,"Additional support for our English Language Learners (ELL) to ensure continued deliberate support is provided that promotes measurable development, growth, and overall progress of language acquisition (Functional & Academic).\n",null,"We will increase the .6 ELD teacher to a full-time teaching position to support those ELL coded students that have an English Language Proficiency Level of 2.5 or higher.","Investigating the possibility of hiring an additional full-time ELD Education Teacher (.4 increase)."]
[3,"Continue our work to build a passion for reading with our students by supporting them to find in a manner that allows multiple opportunities to experience success in reading.\n",null,"Implement extensive professional development focusing on Reader's Conferencing.","Investing in PD focusing on Reader's Conferencing for all grade level throughout the 2020-2021 academic school year. Investigate hiring an additional tutor to support this initiative. "]
[4,"Building on our S.T.E.A.M. focus through the continuation of McAvinnue’s “FULL S.T.E.A.M. Ahead” Day with an increased budgetary focus to supplement materials that can be used to support the engaging project-based activities completed on this day.\n",null,"Continue the priority focus to integrate S.T.E.A.M. consistently with all grade levels during Early Release Days and beyond.","Increase classroom-based funding to include substantial allocation to purchase materials to be used for S.T.E.A.M. related activities and project-based opportunities."]
[5,"Continue to explore new ways to encourage school attendance for all students and increase opportunities for families to be more involved in their child’s school experience.\n",null,"Continue to support the ongoing committee work that focuses on family and student engagement. This working group plans monthly events that allow families to access the school in unique ways outside of the typical academic day.","Increase funding for events that prompt family and student engagement outside of the typcial school day."]

{"sheet":"Budget","index":2,"n_rows":157,"n_cols":10,"rows_kept":157,"cut":false,"hidden":false,"merged":[]}
["Joseph McAvinnue Elementary School","Last year's staff","Required minimum","Budgeted Staff","Check: Sufficient Staff? ","Average Salary + Benefits","Amount","Notes","Title I Check"]
["School Year 20-21 Budget",null,null,"Budget in blank cells",null,null,{"$f":"G3-G157","v":0},"Amount remaining to budget",{"$f":"B152-G152","v":0},"Amount remaining in Title I budget"]
["Positions in navy blue have been HS-only in the past",null,null,"Gray cells are budgeted for you",null,null,{"$f":"Funding!E31","v":5114452.1500000004},"Total Allocation, All Sources",{"$f":"B152","v":168725},"Title I  budget"]
["2100 Principal's Office:"]
["Principal/Coordinator",1,1,1,{"$f":"IF(D5<C5, \"Please budget additional staff\", \"Yes\")","v":"Yes"},140268,140268]
["Headmaster",0,0,null,{"$f":"IF(D6<C6, \"Please budget additional staff\", \"Yes\")","v":"Yes"},173679.8376]
["Assistant Principal",1,null,1,{"$f":"IF(D7<C7, \"Please budget additional staff\", \"Yes\")","v":"Yes"},128579,128579]
["House Deans",0,null,null,{"$f":"IF(D8<C8, \"Please budget additional staff\", \"Yes\")","v":"Yes"},141596.384716]
["Administrative Assistant",1,1,1,{"$f":"IF(D9<C9, \"Please budget additional staff\", \"Yes\")","v":"Yes"},56107.200000000004,56107]
[null,3,2,null,null,null,{"$f":"SUM(G5:G9)","v":324954}]
[]
["Coaches:"]
["Math Resource Teacher",1,null,1,{"$f":"IF(D13<C13, \"Please budget additional staff\", \"Yes\")","v":"Yes"},93512,93512]
["Literacy Specialist",1,1,1,{"$f":"IF(D14<C14, \"Please budget additional staff\", \"Yes\")","v":"Yes"},97985,97985]
["Instructional Specialist",0,0,null,{"$f":"IF(D15<C15, \"Please budget additional staff\", \"Yes\")","v":"Yes"},97985,{"$f":"D15*F15","v":0}]
["Additional professional development coaches",null,null,null,{"$f":"IF(D16<C16, \"Please budget additional staff\", \"Yes\")","v":"Yes"},97985,{"$f":"D16*F16","v":0}]
[null,2,1,null,null,null,{"$f":"SUM(G13:G16)","v":191497}]
[]
["General Education Teachers:"]
["Classroom Teachers"]
["PreSchool Teachers",1,1,1,{"$f":"IF(D21<C21, \"Please budget additional staff\", \"Yes\")","v":"Yes"},93512,93512]
["Kindergarten Teachers",4,3,4,"Yes",93512,374048]
[]
["1st Grade Teachers",4,"see below",4,"see below",93512,374048]
["2nd Grade Teachers",4,"see below",4,"see below",93512,374048]
["3rd Grade Teachers",4,"see below",4,"see below",93512,374048]
["4th Grade Teachers",4,"see below",4,"see below",93512,374048]
["5th Grade Teachers",0,"see below",null,"see below",93512,{"$f":"D28*F28","v":0}]
["6th Grade Teachers",0,"see below",null,"see below",93512,0]
["7th Grade Teachers",0,"see below",null,"see below",93512,0]
["8th Grade Teachers",0,"see below",null,"see below",93512,0]
["Loopers",0,"see below",null,"see below",93512,0]
["All Grades 1-8 Teachers",16,14,{"$f":"SUM(D24:D32)","v":16},"Yes"]
[]
[]
["Allied Arts "]
["Art",1,null,1,{"$f":"IF(D37<C37, \"Please budget additional staff\", \"Yes\")","v":"Yes"},93512,93512]
["Music",1,null,1,"Yes",93512,93512]
["Physical Education",1,1,1,"Yes",93512,93512]
["Technology Ed",0,null,null,"Yes",93512,{"$f":"D40*F40","v":0}]
["Drama",0,null,null,"Yes",93512,0]
["ITS",0,null,null,"Yes",93512,0]
["Content Literacy",1,null,1,"Yes",93512,93512]
["Health",0,null,null,"Yes",93512,0]
["Dance",0,null,null,"Yes",93512,0]
["Library/Media Specialist",0,null,null,"Yes",108441.77525000001,0]
["Other",0,null,null,"Yes",93512,{"$f":"D47*F47","v":0}]
[]
["Subject Teachers (High school only)"]
["Math Teachers",0,"see below",null,"see below",93512,{"$f":"D50*F50","v":0}]
["Science Teachers",0,"see below",null,"see below",93512,0]
["Social Studies Teachers",0,"see below",null,"see below",93512,0]
["English",0,"see below",null,"see below",93512,0]
["Foreign Language",0,"see below",null,"see below",93512,0]
["All HS Subject Teachers",0,0,null,{"$f":"IF(D55<C55, \"Please budget additional staff\", \"Yes\")","v":"Yes"}]
[]
["In House Suspension",0,null,null,"Yes",93512,0]
["Consumer Science",0,null,null,"Yes",93512,0]
["Business ",0,null,null,"Yes",93512,0]
["Video Production ",0,null,null,"Yes",93512,0]
["ROTC",0,null,null,"Yes",93512,0]
[]
["All General Education Teachers",25,null,{"$f":"SUM(D21:D22,D24:D32, D37:D47, D50:D54,D57:D61)","v":25},null,null,{"$f":"SUM(G21:G61)","v":2337800}]
[]
[]
["Paraprofessionals:"]
["Mainstream Paras"]
["Preschool Para",1,1,1,{"$f":"IF(D68<C68, \"Please budget additional staff\", \"Yes\")","v":"Yes"},37989.25,37989]
["Kindergarten Para",4,3,4,"Yes",37989.25,151956]
["Mainstream Paras",4,null,4,"Yes",37989.25,151956]
["All General Education Paras",9,4,{"$f":"SUM(D68:D70)","v":9},null,null,{"$f":"SUM(G68:G70)","v":341901}]
[]
["Special Programs"]
["Special Education","If you plan to change special education staffing, contact Mike Lovato by 3/16/2020"]
["Adjustment Teachers",0,null,null,{"$f":"IF(D75<>B75, \"Contact Mike Lovato\", \"No change\")","v":"No change"},93512,{"$f":"D75*F75","v":0}]
["LEAP Teachers",0,null,null,"No change",93512,0]
["CSA Teachers",3,null,3,"No change",93512,280536]
["Other Special Ed Teachers",4,null,5,"Contact Mike Lovato",93512,467560]
[null,null,null,null,"No change"]
["Special Education Classroom Paras",9,null,9,"No change",37989.25,341901]
["504 /1to1",0,"Provided outside of SSB",{"$f":"B81","v":0},"Provided outside of SSB",37989.25,{"$f":"D81*F81","v":0}]
[]
[]
["English Language Learners"]
["ELL Teachers",2.6,2.6,3,{"$f":"IF(D85<C85, \"Please budget additional staff\", \"Yes\")","v":"Yes"},93512,280536]
["ELL Para",2,null,2,{"$f":"IF(D86<C86, \"Please budget additional staff\", \"Yes\")","v":"Yes"},37989.25,75978]
["ELL Tutor (Title III)",1,"Provided outside of SSB",{"$f":"B87","v":1},"Provided outside of SSB",15750,{"$f":"D87*F87","v":15750}]
[]
["All Special Programs Teachers & Paras",22,3,{"$f":"SUM(D85:D87,D75:D81)","v":23},null,null,{"$f":"SUM(G85:G87,G75:G81)","v":1462261}]
[]
["Student Support:"]
["Guidance Counselor",null,null,null,{"$f":"IF(D92<C92, \"Please budget additional staff\", \"Yes\")","v":"Yes"},107538.8,{"$f":"D92*F92","v":0}]
["Social Worker",1,"Provided outside of SSB",{"$f":"B93","v":1},"Provided outside of SSB",109292.15000000001,109292.15000000001]
["Additional social workers",0,null,null,"Yes",109292.15000000001,0]
["SEL Tutors: 18 hrs/week",0,null,null,"Yes",18900,0]
["Tutors: 18 hrs/week",0,null,null,"Yes",18900,0]
["Tutors: 15 hrs/week (Title I)",4,null,5,"Yes",14850,74250]
["Parent Liaisons: Stipended (Title I)",0,null,null,"Yes",3000,0]
["Parent Liaisons: 18 hrs/week (Title I)",1,null,1,"Yes",11340,11340]
["Parent  Liaison, full time",0,null,null,"Yes",{"$f":"36865*1.1689","v":43091.498500000002},0]
[null,7,0,{"$f":"SUM(D92:D100)","v":7},null,null,{"$f":"SUM(G92:G100)","v":194882.15000000002}]
[]
["Facilities"]
["Security Guards",0,0,null,{"$f":"IF(D104<C104, \"Please budget additional staff\", \"Yes\")","v":"Yes"},52524.625532099999,{"$f":"D104*F104","v":0}]
["Custodians",3,3,3,{"$f":"IF(D105<C105, \"Please budget additional staff\", \"Yes\")","v":"Yes"},56107.200000000004,168321]
[null,3,0,{"$f":"SUM(D104:D105)","v":3},null,null,{"$f":"SUM(G104:G105)","v":168321}]
[]
["High School-Specific Positions"]
["Coordinator of Student Support Services",0,null,null,{"$f":"IF(D109<C109, \"Please budget additional staff\", \"Yes\")","v":"Yes"},146909.68979999999,{"$f":"D109*F109","v":0}]
["Discipline & Operations Specialist",0,null,null,"Yes",126736.81360000001,{"$f":"D110*F110","v":0}]
["Academic Chairs",0,null,null,"Yes",135108.95597375333,0]
["Director of the Freshman Academy",0,null,null,"Yes",137154.93876399999,0]
["Student Services Specialist - Freshman Academy",0,null,null,"Yes",117795.59358600002,0]
["Bursar/Financial Specialist",0,null,null,"Yes",58072.202723000002,0]
["Clerk Schedulers",0,null,null,{"$f":"IF(D115<C115, \"Please budget additional staff\", \"Yes\")","v":"Yes"},53207.876804600004,0]
["Administrator of Athletics",0,null,null,"Yes",141670.79689000003,0]
["Student Activity Advisor",0,null,null,"Yes",96122.317345999996,0]
[null,0,0,{"$f":"SUM(D109:D117)","v":0},null,null,{"$f":"SUM(G109:G117)","v":0}]
[]
["Other Positions"]
["Other (Please describe)",0,null,null,{"$f":"IF(D121<C121, \"Please budget additional staff\", \"Yes\")","v":"Yes"},"See James Hall and Linus Guillory to estimate salary + benefits",{"$f":"IFERROR(D121*F121, 0)","v":0}]
["Other (Please describe)",0,null,null,"Yes","See James Hall and Linus Guillory to estimate salary + benefits",{"$f":"IFERROR(D122*F122, 0)","v":0}]
[null,null,null,{"$f":"SUM(D121:D122)","v":0},null,null,{"$f":"SUM(G121:G122)","v":0}]
[]
["Total Staffing "]
[null,71,null,null,null,null,{"$f":"SUM(G10,G17,G63,G71,G89,G101,G106,G118, G123)","v":5021616.1500000004}]
[]
["Non-Personnel"]
["Instructional Supplies",37760,null,null,{"$f":"IF(D129<C129, \"Please budget additional funds\", \"Yes\")","v":"Yes"},null,92836]
["STEM Lead Stipends",0,null,null,{"$f":"IF(D130<C130, \"Please budget additional funds\", \"Yes\")","v":"Yes"}]
["Enrichment",0,null,null,"Yes",null,{"$f":"D131","v":0}]
["Athletics: Coaches",0,null,null,"Yes",null,0]
["Athletics: Contracted Services",0,null,null,"Yes",null,0]
["Athletics: Transportation",0,null,null,"Yes",null,0]
["Athletics: Supplies & Uniforms",0,null,null,"Yes",null,0]
["Athletics: Rental Fees",0,null,null,"Yes",null,0]
["Student Activity Stipends",0,null,null,"Yes",null,0]
["Student Activity Supplies",0,null,null,"Yes"]
["Dual Enrollment",0,"Provided outside of SSB",{"$f":"B139","v":0},"Provided outside of SSB",null,0]
["SCORE Peer Mediation",0,"Provided outside of SSB",{"$f":"B140","v":0},"Provided outside of SSB",null,0]
["Band camp",0,"Provided outside of SSB",{"$f":"B141","v":0},"Provided outside of SSB",null,0]
["Choral supplies",0,"Provided outside of SSB",{"$f":"B142","v":0},"Provided outside of SSB",null,0]
["Jr. Air Force ROTC Supplies & Equip.",0,null,null,"Yes",null,0]
["Other (describe in column H)",null,null,null,"Yes",null,0]
[null,37760,null,{"$f":"SUM(D129:D144)","v":0},null,null,{"$f":"SUM(G129:G144)","v":92836}]
[]
["Title I Review"]
["Coaches",1,1,1,"See below",97985,97985]
["Parent Liaisons: Stipended",0,null,{"$f":"D98","v":0},"See below",3000,{"$f":"D149*F149","v":0}]
["Parent Liaisons: 18 hrs/week",1,1,{"$f":"D99","v":1},"See below",11340,11340]
["Tutors: 15 hrs/wk",4,4,4,"See below",14850,59400]
["Total Title I Allocation",168725,168725,{"$f":"SUM(D148:D151)","v":6},{"$f":"IF(G152<C152, \"You have used \"&ROUND(G152/C152*100, 0)&\"% of your Title I budget\", IF(G152>C152, \"Exceeds Title I budget\", \"Yes\"))","v":"Yes"},null,{"$f":"SUM(G148:G151)","v":168725}]
[]
[]
[]
["Total Budget"]
[null,null,null,null,null,null,{"$f":"SUM(G126,G145)","v":5114452.1500000004}]