Scholarships and volunteer hours at a youth center, without the spreadsheets

Note: general recommendations only, not professional advice. You are responsible for checking before use. Check scholarship terms in each program's official documents, and consult a lawyer on privacy questions. The full text is at the end.

Who this is for

For a scholarship coordinator, a youth center director or a community coordinator at a local authority or a community center, who runs several scholarship tracks in parallel: a scholarship that requires a fixed number of volunteer hours, a municipal scholarship in exchange for community activity, a matching scholarship or a participation grant. No technical background needed. You need a Google account (Forms and Sheets), WhatsApp or email, and a Claude, ChatGPT or Gemini account for writing drafts.

The problem in three lines

Every scholarship track is managed in a different file, with different rules, and only one coordinator knows what applies to which track. Hour reports arrive on WhatsApp, as screenshots and in forms, and every month-end starts with chasing whoever didn't report. And at the end of the year, when the funder or the authority needs a report, you spend a week putting the numbers together again.

The method in 7 steps

Step 1: A card for every scholarship track

What to do: Before you open applications, write a one-page card for every track. The card is the single source for that track's rules, and everything else (the call for applications, the eligibility check, the reminders and the report) is written from it.

How: Fill in the card only from the program's official documents: regulations, contract, procedure or a letter from the body that runs the scholarship. Not from memory and not from what applied last year. On every card:

• Track name and who runs it.
• Threshold conditions: age, residence, academic institution, year of study, any other condition written in the document.
• What the student must do: how many volunteer hours, in what kind of activity, by when. Some programs require a fixed number of hours, others require activity throughout the year.
• Amount and payment structure: how many installments, and what has to happen before each one. If it isn't written in the document, write [to fill] and ask.
• What to collect: which documents, and when.
• What gets reported at the end: to whom, in what format, by what date.
• Source: document name and version date.

Common mistake: Keeping the rules in your head. When the coordinator goes on leave or moves on, nobody knows why one student got an installment and another didn't.

Step 2: A call for applications and one application form

What to do: Write a call for applications from the cards, and build one application form in Google Forms for all tracks, with a question "Which track are you applying to".

How:

• The call is written from the card (template below). AI can draft a version for the website, a post and WhatsApp (prompt 1), but only from what's on the card.
• The form asks only for what you need to check eligibility and get back to the applicant: name, phone, email, track, institution and field of study, year of study, volunteering interests, available days and hours.
• Don't ask in the first form for an ID number, bank details or financial and medical information, unless the track really needs it to check eligibility. If you need documents like that, collect them later, only from those who passed the screening, and check with a lawyer how to keep them.
• At the top of the form, say in plain language what will be done with the details, who will see them and how long you'll keep them.
• The answers are saved to a sheet. That's the "Applicants" tab.

Common mistake: A separate form for every track, each in a different file. In the end the same student applies to three tracks, and nobody sees it.

Step 3: One sheet with clear tabs

What to do: All scholarship information lives in one Google Sheets file, with a tab per topic. Not a file per track and not a file per month.

How: The tabs:

• Tracks: a row per track, with a link to its card.
• Applicants: comes from the form. Extra columns: status (submitted / under review / missing document / approved / not approved / waiting list), who checked, decision date, note.
• Placements: place name, contact, type of activity, how many students it can take, days and hours.
• Assignments: student, track, volunteering place, start date, hours target.
• Hours: a row per monthly report: student, month, hours reported, place approval (yes / no / pending), cumulative hours.
• Payments: student, installment, installment condition, whether the condition was met, date passed to the finance department.

Every student gets an internal number (for example S-001), and that number links the tabs. That way you can work and share without copying phone numbers and ID numbers everywhere.

Permissions: only the people checking eligibility see the Applicants tab. A volunteering place doesn't need to see the whole sheet, only its own students. Share with named people, not "anyone with the link".

Common mistake: Adding a column for every question that comes up during the year. After six months there are sixty columns, half of them empty. Whatever doesn't fit the fixed columns goes in the "Note" column.

Step 4: Eligibility checks against written criteria

What to do: Every applicant is checked against the threshold conditions on the track card, the same way, and a person decides and records it.

How:

1. Turn the threshold conditions on the card into a short checklist (template below).
2. For each applicant, mark every condition: meets / doesn't meet / missing information.
3. AI can do a first pass (prompt 3): paste the criteria and the answers without name, phone or ID number, only with the internal number. It returns a table with a mark and an explanation for each mark.
4. Whoever checks goes over every row. The decision, and who made it, are recorded in the Applicants tab.
5. When there are more eligible applicants than places, the order of priority should be written on the card in advance, not decided along the way.
6. Every applicant gets a written answer, including those not approved.

Common mistake: Letting AI decide who's eligible. It can misread a condition, fill in information that doesn't exist, or be stricter than the rules for no reason. It marks, you decide.

Step 5: Matching students to volunteering placements

What to do: Every approved student is assigned to a volunteering place that fits their track, and knows from day one how many hours are required and by when.

How:

• Before assigning, check that every volunteering place meets the track's requirements. If the track requires a certain type of activity, it's written on the card.
• AI can suggest a first matching from the Placements tab and the students' availability (prompt 4). Paste internal numbers only. A person checks the final matching.
• A place that works with minors or a vulnerable population may require clearances from the student before they start. Check what's required before the first day.
• Every student gets an assignment message (template below) with the place, the contact, the hours target and how to report.
• The contact at the volunteering place gets the names of their students and the hours approval routine.

Common mistake: Assigning and forgetting. A student who didn't start volunteering in the first month almost always reaches the end of the year with a big hours gap.

Step 6: A monthly hours-report routine, and payment after approval

What to do: Once a month, on the same date, every student reports hours in a short form, the place approves, and only then does the relevant installment go to payment.

How:

• A fixed report form: internal number or name, month, place, dates and hours, what I did in one sentence. All reports go into the "Hours" tab.
• A fixed date: for example by the [to fill] of every month. Everyone knows it in advance.
• Place approval: the contact at the place gets, once a month, a list of their students and the hours they reported, and approves or corrects. The approval is recorded in the "Place approval" column.
• Reminders: three days before the date, a message to everyone. A day after, a personal message to whoever didn't report (prompt 6 writes the wording, prompt 5 finds who's missing).
• Monthly summary: AI can summarize the reports and flag anomalies, such as hours that don't add up with the days, a duplicate report or a big gap from the target (prompt 5). Check every flag before acting on it.
• Payment: in the "Payments" tab, mark for every installment whether its condition was met, according to the card. Only a row marked "yes" goes to the finance department. Where possible, the person who sends the payment is not the person who approved the hours.
• Transparency for the student: once a month every student knows how many hours they've built up, how many are left, and when the next installment is due.

Common mistake: Paying "in advance" before the hours are approved, because the student asked. Afterwards it's very hard to ask for the money back, and the report to the funder doesn't add up.

Step 7: The year-end report and the working routine

What to do: The annual report is written from the sheet, not from memory, and the whole system runs on an hour a week and two hours a month.

How:

• The report: check on the track card exactly what has to be reported and in what format. Pull cumulative numbers from the sheet: how many applied, how many were approved, how many completed, total hours, at which places, how many installments were paid. AI can write a draft from the numbers (prompt 7). Add one or two stories, with the student's consent, without identifying details.
• Every week (one hour): handling new applicants and missing documents, questions from students and places.
• Every month (two hours): reminders, collecting reports, place approvals, monthly summary, passing installments to payment.
• At the end of the year: deleting or archiving personal data you no longer need, as decided in advance. Updating the cards for next year from the new documents.

Common mistake: Starting to think about the report in the last month. If a column the report needs wasn't in the sheet from the start, you can't rebuild it.

Templates

Replace what's in square brackets.

Track: [track name]
Run by: [the body that runs the scholarship]
Source: [document name, version date]
Threshold conditions: [list, from the document]
What's required: [number] volunteer hours in [type of activity], by [date]
Payment: [number] installments. Installment 1: [condition]. Installment 2: [condition]
Documents: [list, and when to collect]
End report: [to whom, format, by when]
Order of priority when there aren't enough places: [to fill]

Applications are open for [track name] at [youth center name].
Who can apply: [main threshold conditions].
What you get: [from the card, add nothing].
What you commit to: [number] volunteer hours in [type of activity] during [period].
Apply by [date]: [link to form]
Questions: [name, contact channel]

Applicant: [internal number]   Track: [name]
Condition 1: [from the card]   meets / doesn't meet / missing information
Condition 2: [from the card]   meets / doesn't meet / missing information
Condition 3: [from the card]   meets / doesn't meet / missing information
Missing documents: [list]
Decision: [approved / not approved / waiting list]   Checked by: [name]   Date: [date]

Hi [first name], you've been assigned to volunteer at [place name] as part of [track name].
Contact at the place: [name, contact channel]. You start on [date].
The target: [number] hours by [date].
Report once a month, by the [day] of the month, in this form: [link].
Payment goes out in installments, after the place approves the hours.

Hi [first name], we haven't received your hours report for [month] yet.
You can report here by [date]: [link]
So far you've built up [number] hours out of [target]. The next installment goes out after the report is approved.
If something's getting in the way, write to me and we'll find a solution.

Hello [name], attached is the list of students volunteering with you and the hours they reported for [month].
Could you approve by [date], or let us know if something doesn't match?
[table: first name, hours reported]
Thanks, [name], [role]

Ready-made prompts

Don't paste ID numbers, phone numbers, addresses, bank details or financial and medical information about applicants into AI tools. Work with the internal number or a first name only. Paste the rules from the card, don't ask the AI to know what they are.

Here is a card for a scholarship track at a youth center: [paste card].
Write three versions of a call for applications: for the website (up to 150 words), for a social post (up to 80 words), and for WhatsApp (up to 40 words).
Use only what's written on the card. Don't add amounts, dates or conditions that aren't on it. If something is missing, write [to fill]. No superlatives. At the end of every version: [link to form].

I'm building one application form in Google Forms for several scholarship tracks. Here are the threshold conditions of each track: [paste].
Suggest a minimal list of questions: only what's needed to check the threshold conditions and get back to the applicant. For each question: field type, whether it's required, and which condition it relates to.
Flag questions that collect sensitive information, and suggest whether they can be moved to a later stage.
Add a three-sentence draft for the top of the form: what will be done with the details, who will see them and how long they'll be kept. Say that it's a draft for review.

Here are the threshold conditions of a scholarship track, from the official document: [paste].
Here are applicants' answers, with an internal number only and no identifying details: [paste table].
For every applicant and every condition mark: meets / doesn't meet / missing information, and write in one sentence what in the answer the mark is based on.
Don't assume information that isn't written. If an answer is unclear, mark "missing information". Don't recommend who to accept. Return a table that can be pasted into the sheet.

Here are the volunteering places: [table: place, type of activity, how many students it can take, days and hours].
Here are the approved students, internal number only: [table: number, track, interests, available days and hours].
Here is each track's requirement about the type of activity: [paste].
Suggest a matching: every student to one place that fits their track's requirement and their availability, without exceeding the place's capacity. Flag students with no match and places left empty.
Return a table that can be pasted into the sheet.

Here is the Hours tab for [month], internal numbers only: [paste: number, place, dates, hours reported, place approval].
Here is the list of all active students and each one's hours target: [paste].
1. Who didn't report this month.
2. Who reported and hasn't been approved by the place yet.
3. Anomalies: duplicate reports, hours that don't add up with the dates, a big gap from the pace needed to reach the target by [date].
4. A three-line summary: how many reported, total hours this month, how many are behind.
Only from the data. Don't draw conclusions about a student beyond the numbers.

I'm a scholarship coordinator at a youth center. Write three short WhatsApp messages, in plain, warm language, without blaming:
1. A general reminder to all students, three days before the report date ([date]).
2. A personal message to whoever didn't report, a day after the date.
3. A message to whoever is more than [number] hours behind the pace, offering a short call.
In every message leave room for [first name], [hours built up], [target] and [link]. Up to 50 words per message.

Here is what the body that runs the scholarship asks for in the annual report: [paste from the card or the document].
Here are the cumulative numbers from the sheet, without names: [paste: applied, approved, started, completed, total hours, hours per place, installments paid, who didn't complete and why, in categories].
Here is one story a student agreed to share, without identifying details: [paste].
Write a draft report in the structure they ask for. Every number in the report must come from the data I gave. If a number they ask for is missing, write [to fill]. Factual language, no superlatives.

One-page checklist

Before opening applications

• A card for every track, from the official documents, with source and version date
• A written order of priority in case there are more eligible applicants than places
• A call for applications written from the card only
• One minimal application form, with an explanation of what will be done with the details
• One sheet with tabs: Tracks, Applicants, Placements, Assignments, Hours, Payments
• An internal number for every student, and permissions by named people
• Checked with a lawyer: what data you collect, how you keep it, and when you delete it

At the start of the year

• Eligibility checked against a list, a decision by a person, and a record of who decided
• A written answer to every applicant
• A placement for every student, and required clearances before the first day
• An assignment message with the hours target and how to report

Every month

• A reminder three days before the report date
• A personal message to whoever didn't report
• Hours approval from every volunteering place
• A monthly summary and an anomaly check
• Installments go out only for rows whose condition was met
• Every student knows how many hours they've built up and how many are left

At the end of the year

• A report written from the sheet, in the required format
• Personal data no longer needed is deleted or archived
• The cards are updated for next year

How you know it's working

Write down where you are today, and measure from there:

• Time to decision: how many days pass from application to an answer to the applicant.
• On-time reporting: how many students reported by the date, without a personal reminder.
• Falling behind: how many students are more than a month behind the pace required of them.
• Completion: how many of the students who started reached their hours target by the end of the year.
• Payments: how many installments went out on time, and how many were delayed because of a missing report.
• Coordinator time: how many hours a month go on chasing reports and on the annual report, compared with last year.

Disclaimer

This content is general recommendations only, not professional, legal, accounting or tax advice. Every youth center and every scholarship program is different. The amounts, number of hours, eligibility conditions, payment structure and reporting requirements of every scholarship are set by its official terms, and you should check them in the program's documents and with the body that runs the scholarship. Nothing here describes the rules of any particular program. You are responsible for checking that the content fits your situation, and for checking the templates, the prompts and any draft written with AI before use. Decisions on eligibility and payment are made by a person. For questions about collecting and keeping personal data on applicants and students, access permissions, how long to keep data, use of outside AI tools and clearances for work with minors and vulnerable populations, consult a lawyer. Outside tools and terms of service change, so check them at the source.