Aurora Public Schools · Colorado

The 562-description review starts with the job list

Search APS’s supplied inventory and inspect the draft family map. List rows and the Q&A scope count are shown separately.

HSG response to RFP B2728 · HR Compensation Consultant

The supplied inventory

The scope remains 562 job descriptions (Q&A 2): 351 APT and 211 Classified. The supplied list has 576 rows: 351 APT and 225 Classified. HSG will reconcile the 14-row Classified difference with APS at kickoff, including duplicate rows and file-name artifacts.

Source: jd_list.tsv.txt, exported from jd_list.xlsx; Q&A 2.

Titles per range

APT

APT list rows per range. Values are provided in the adjacent table.

Classified

Classified list rows per range. Values are provided in the adjacent table.

Source: HSG counts of supplied job-list rows, including duplicates.

Read the chart values
Titles per range
GroupRangeList rows
APTAPT 140
APTAPT 240
APTAPT 366
APTATP 31
APTAPT 448
APTAPT 544
APTAPT 620
APTAPT 724
APTAPT 821
APTAPT 911
APTAPT 1023
APTAPT 1111
APTReview Required2
Classified172
Classified181
Classified192
Classified221
Classified231
Classified242
Classified2611
Classified2713
Classified287
Classified294
Classified308
Classified316
Classified323
Classified339
Classified349
Classified3510
Classified3639
Classified3710
Classified3811
Classified3911
Classified407
Classified4111
Classified426
Classified433
Classified445
Classified455
Classified4611
Classified477
Classified482
Classified491
Classified502
Classified511
Classified524

Draft job-family map

Starting point for APS review

The RFP asks the consultant to build the framework with APS. These assignments use title keywords only. They do not establish job duties, reporting relationships or final placements.

Source: RFP IV.2 items 1 and 2; Q&A 6.

HSG draft family assignments
FamilyAll rowsAPT rowsAPT range spanClassified rowsClassified range span
School leadership20204 to 100None
District leadership95953 to 110None
Early childhood1033 to 4719 to 43
Exceptional student services1351 to 5829 to 44
Health and wellness17121 to 5526 to 50
Family and community engagement31231 to 5836 to 44
Nutrition services1412 to 21318 to 51
Custodial932 to 4622 to 35
Transportation and fleet1541 to 41128 to 45
Safety and security1352 to 5833 to 52
Technology34261 to 7829 to 52
Finance and business services45241 to 42126 to 46
Human resources20111 to 8931 to 46
Communications and marketing1631 to 41326 to 47
Facilities and skilled trades3581 to 52733 to 52
Administrative and clerical support3023 to 32824 to 50
Instruction and student support1591061 to 115317 to 48
See the matching rules and order

The first matching rule wins, ignoring case. School leadership precedes district leadership. The last family is the fallback. Each title receives exactly one family. Counts include all supplied rows.

Generator keyword rules
FamilyKeyword expression
School leadership^(?:assistant |asst\.? )?principal\b|^head of school\b
District leadership^(?:(?:assistant|deputy|executive|senior)\s+)*(?:director|chief|superintendent)\b|^deputy,?\s+chief\b
Early childhoodearly childhood|preschool|child development|ece\b
Exceptional student servicesexceptional|special education|\bess\b|\bsped\b|autism|braille|sign language|deaf|hearing|speech|occupational therap|physical therap|\bswap\b
Health and wellnessnurse|health|wellness|psycholog|suicide|mental|therap|crisis
Family and community engagementfamily|community|engagement|liaison|mckinney|parent|wraparound|interpret|translat
Nutrition servicesnutrition|food|cafeteria|kitchen|cook
Custodialcustodi|cleaner
Transportation and fleettransport|bus |driver|fleet|vehicle|mechanic, (?:bus|fleet|vehicle)
Safety and securitysafety|security|dispatch|emergency|patrol
Technologytechnology|information technology|\bit\b|network|system|computer|database|software|telecom|cyber|data |programmer|application
Finance and business servicesaccount|financ|budget|payroll|purchas|procurement|warehouse|inventory|business|buyer|bookkeep|audit|grant
Human resourceshuman resource|recruit|compensation|benefit|talent|credential|personnel|leave|hr\b|total reward
Communications and marketingcommunicat|marketing|public relation|media|graphic
Facilities and skilled tradesfacilit(?:ies|y)|electric|plumb|carpent|hvac|trade|maintenance|journey|grounds|painter|paint|construction|locksmith|building|irrigation|welder|roof|energy|utility|mechanic
Administrative and clerical support^assistant to |secretar|clerical|clerk|reception|administrative assistant|assistant, administrative|office|registrar|executive assistant
Instruction and student support.*

What the list tells us

Review Required

2 rows carry this text in their title, range or calendar.

File-name text

2 titles include .docx, .doc or .pdf.

Normalized title duplicates

2 groups cover 4 rows. Matching ignores case, spaces and punctuation; it does not strip words or file extensions.

Shared APT ranges

6 ranges contain school-leadership titles and titles suggesting central-office work. This is a title-based screen for APS to verify.

Source: HSG counts and title rules applied to jd_list.tsv.txt.

See each duplicate title group
Normalized duplicates
Title variantsRowsGroups and ranges
Assistant Director, Career & Technical Education
Assistant Director, Career & Technical Education
2APT / APT 7
APT / APT 7
Assistant, Restorative Practices
Assistant Restorative Practices
2Classified / 27
Classified / 27
See the shared APT ranges
Title-based shared-range screen
APT rangeSchool-leadership rowsCentral-office title rows
4324
539
6119
8218
964
10419

School leadership matches titles beginning with principal, assistant principal or head of school. Central-office candidates match chief, director, manager or analyst and exclude school-leadership matches.