Workflow · Finance close · Opening soon
Chronic absenteeism report
Export attendance data from PowerSchool, then upload the file to Mammoth. It calculates each student’s absences against the days they were enrolled, flags students at 10% or more, and groups the results by grade.
Someone typed
“list students who are chronically absent: missed 10% or more of the school days they were enrolled, by grade”
The agent read it as
List students who are chronically absent: missed 10% or more of the school days they were enrolled, by grade, from PowerSchool attendance export.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
PowerSchool attendance export
CSV export · 40 rows
Step
List chronically absent students
Step 1
Result
Chronic Absence List
11 rows
Schedule
Runs when you say
Proposed
- FilePowerSchool attendance exportCSV export · 40 rows
- StepList chronically absent studentsStep 1
- ResultChronic Absence List11 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 11 rows came out.
- Download PowerSchool attendance export sample (40 rows)PowerSchool: Attendance > Reports > Student Attendance Summary > Export
What you get back
The result of that run, the rows to look at first.
Chronic Absence ListSample data11 rows
| Student name | Grade | Absence rate (%) | Days absent | Days enrolled | Student ID |
|---|---|---|---|---|---|
| Adrian Cole | 6 | 11.6 | 8 | 69 | 100369 |
| Iris Monroe | 6 | 10 | 7 | 70 | 100344 |
| Ethan Vale | 7 | 12.7 | 9 | 71 | 100347 |
| Micah Lane | 7 | 14.5 | 10 | 69 | 100377 |
| Lena Shaw | 8 | 11 | 8 | 73 | 100350 |
| Silas Grant | 8 | 12.7 | 9 | 71 | 100371 |
| Caleb Finch | 9 | 13.5 | 10 | 74 | 100353 |
| Jordan Fox | 9 | 11.3 | 8 | 71 | 100379 |
| Aiden Ross | 10 | 11.1 | 8 | 72 | 100359 |
| Layla Quinn | 11 | 14.9 | 11 | 74 | 100362 |
| Julian King | 12 | 16 | 12 | 75 | 100365 |
How it works
How to use the Chronic Absence List workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Chronic Absence List: questions
How do you list chronically absent students by grade?
Export attendance data from PowerSchool, then upload the file to Mammoth. It calculates each student’s absences against the days they were enrolled, flags students at 10% or more, and groups the results by grade.
What export should you use?
Use a PowerSchool attendance export that includes student names or IDs, grade, enrollment dates, and attendance records or absence counts. The file needs enough information to compare missed days with days enrolled.
What happens to students who do not match the rule?
Students who are below the 10% threshold do not appear in the final list. If a row is missing the data needed for the calculation, it cannot be used for the report.
How do you change the rule in words?
Edit the rule to match the cutoff you want. For example, change 10% or more to a different percentage, or change the grouping from grade to another field in the export.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent