Fall Oasis District Foundation Summary Calculation

12 views
Skip to first unread message

The Chad

unread,
Nov 3, 2023, 1:01:33 PM11/3/23
to ak-...@googlegroups.com
Would anyone have or know where to find the documentation that explains how the District Foundation Summary report calculates its numbers? I'm guessing it runs some calculations based on FTE, Membership, and some state law math, but I can't seem to find it anywhere.

I'd love to be able to run my Oasis report against the calculations so I can give my superintendent more accurate numbers as I'm finalizing data.
They get really excited when they see more lines than they expect on the Fall Oasis sheet, and it's hard to explain that Line Count =/= Student Count when I can't explain why they don't equate.


I'd appreciate any help you can provide.


-Chad Jacks
Ketchikan

Robin Gage

unread,
Nov 3, 2023, 1:38:19 PM11/3/23
to ak-...@googlegroups.com

That would be a challenge! To reproduce the formulas that DEED uses to calculate the foundation summary. But I don’t think you have to, you can run the District Foundation Summary before you submit your report. I did that yesterday to see what our foundation summary would look like before I submit it.

 

I like to get my report in SRM and error-free, then I let it marinade a day before I submit it, just in case someone tells me we have a student enrolled who hasn’t been to school all year.

 

A screenshot of a computer

Description automatically generated

--

Robin Gage

District Test Coordinator/PowerSchool Admin

Northwest Arctic Borough School District

907-442-1833

www.nwarctic.org

 

From: ak-...@googlegroups.com <ak-...@googlegroups.com> on behalf of The Chad <chad....@k21schools.org>
Date: Friday, November 3, 2023 at 9:01 AM
To: ak-...@googlegroups.com <ak-...@googlegroups.com>
Subject: [AKPSUG] Fall Oasis District Foundation Summary Calculation

[EXTERNAL EMAIL - CAUTION]: Do not open unexpected attachments or links.

--
You received this message because you are subscribed to the Google Groups "AK PSUG" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
ak-psug+u...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ak-psug/CAB5OjTz%2BTvByQqh1EE0-rbsJsajt5cPQixatQhZA0DJTBjK1mQ%40mail.gmail.com.

Kyle Schneider

unread,
Nov 3, 2023, 2:01:39 PM11/3/23
to ak-...@googlegroups.com
The formula for an individual student is:

(days membership * FTE) ÷ 20

You can have multiple line for a student because the students need a line for every school they’re enrolled in - dual enrolled students would have a line of their primary and a line for their secondary schools so that the enrollment gets apportioned correctly.


Kyle Schneider
GSD Educational Services
Desk: 907-917-4149
Cell: 802-281-8430
ky...@gsded.com

On Nov 3, 2023, at 1:38 PM, 'Robin Gage' via AK PSUG <ak-...@googlegroups.com> wrote:

That would be a challenge! To reproduce the formulas that DEED uses to calculate the foundation summary. But I don’t think you have to, you can run the District Foundation Summary before you submit your report. I did that yesterday to see what our foundation summary would look like before I submit it.
 
I like to get my report in SRM and error-free, then I let it marinade a day before I submit it, just in case someone tells me we have a student enrolled who hasn’t been to school all year.
 
<image001.png>
--
Robin Gage
District Test Coordinator/PowerSchool Admin
Northwest Arctic Borough School District
 

From: ak-...@googlegroups.com <ak-...@googlegroups.com> on behalf of The Chad <chad....@k21schools.org>
Date: Friday, November 3, 2023 at 9:01 AM
To: ak-...@googlegroups.com <ak-...@googlegroups.com>
Subject: [AKPSUG] Fall Oasis District Foundation Summary Calculation

[EXTERNAL EMAIL - CAUTION]: Do not open unexpected attachments or links.

Would anyone have or know where to find the documentation that explains how the District Foundation Summary report calculates its numbers? I'm guessing it runs some calculations based on FTE, Membership, and some state law math, but I can't seem to find it anywhere.

I'd love to be able to run my Oasis report against the calculations so I can give my superintendent more accurate numbers as I'm finalizing data.
They get really excited when they see more lines than they expect on the Fall Oasis sheet, and it's hard to explain that Line Count =/= Student Count when I can't explain why they don't equate.


I'd appreciate any help you can provide. 
 
 
-Chad Jacks
Ketchikan
-- 
You received this message because you are subscribed to the Google Groups "AK PSUG" group.
To unsubscribe from this group and stop receiving emails from it, send an email to 
ak-psug+u...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ak-psug/CAB5OjTz%2BTvByQqh1EE0-rbsJsajt5cPQixatQhZA0DJTBjK1mQ%40mail.gmail.com.

-- 
You received this message because you are subscribed to the Google Groups "AK PSUG" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ak-psug+u...@googlegroups.com.

The Chad

unread,
Nov 6, 2023, 11:18:32 AM11/6/23
to ak-...@googlegroups.com
Thanks, Kyle.

I was expecting something super complicated and beyond my brain's understanding, so I'm a little sad to see it's such a simple formula.

Kyle Schneider

unread,
Nov 6, 2023, 11:20:07 AM11/6/23
to 'Kyle Schneider' via AK PSUG
All the really complicated stuff happens inside the forumla where they take each student and run it through modifiers (like intensive status, etc.) , then adjust by cost factors, etc.


Kyle Schneider
GSD Educational Services
Desk: 907-917-4149
Cell: 802-281-8430
ky...@gsded.com

Robin Gage

unread,
Nov 6, 2023, 1:28:31 PM11/6/23
to ak-...@googlegroups.com

Chad, a little light reading if you want to dig into the state’s funding formula some more.

 

It is a bit old, but I’m sure you could get a new version of it if you want to reach out to Jared De Lara.

 

--

Robin Gage

District Test Coordinator/PowerSchool Admin

Northwest Arctic Borough School District

907-442-1833

www.nwarctic.org

 

Funding_Program_Overview_2012.pdf
Reply all
Reply to author
Forward
0 new messages