A school district school board is dividing between five high schools. The school board can hire 300 teachers. They want to distribute the teachers between the high schools using Jefferson's method of...


A school district school board is dividing between five high schools. The school board can hire 300 teachers. They want to distribute the<br>teachers between the high schools using Jefferson's method of apportionment.<br>Use a spreadsheet to determine:<br>• the standard divisor,<br>• the modified divisor, and<br>• the distribution of teachers to each school.<br>Below you will see the different formulas to use. Start in the cell labeled

Extracted text: A school district school board is dividing between five high schools. The school board can hire 300 teachers. They want to distribute the teachers between the high schools using Jefferson's method of apportionment. Use a spreadsheet to determine: • the standard divisor, • the modified divisor, and • the distribution of teachers to each school. Below you will see the different formulas to use. Start in the cell labeled "Total Teachers". Total Teachers 300 Modify Quota Student Standard High School Lower Quota Modified Lower Quota Population Quota Cherry Creek (CC) Smoky Hill (SH) 3200 =B3/$B$10 =ROUNDDOWN(C3,0) =B3/$B$11 =ROUNDDOWN(E3,0) 2400 Overland (O) 2200 Eagle Crest (EC) 2500 Grandview (G) 3000 Total 13300 =SUM(D3:D7) =SUM(F3:F7) Standard Divisor =B8/B1 Modified Divisor Standard divisor: 44.33 Modified divisor: 44.20 Teachers: CC:72, SH: 54, O: 49, EC:56, G:67 Standard divisor: 44.33 Modified divisor: 44.18 Teachers: CC:72, SH: 54, O: 50, EC:56, G:68 Standard divisor: 44.33 Modified divisor: 44.0 Тeachers: CC:72, SH: 54, O: 50, ЕC:56, G:68 Standard divisor: 44.33 Modified divisor: 43.85 Teachers: CC:72, SH: 54, O: 50, EC:57, G:68

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here