Data Journalism Starter Skills Every Student Reporter Needs
You Do Not Need to Be a Programmer
Data journalism sounds intimidating, but at the student level it almost never requires code. It requires curiosity about numbers, comfort with a spreadsheet, and the same verification instincts you already apply to human sources. If you can ask a good question of a person in an interview, you can learn to ask a good question of a spreadsheet. The skills below will get you through the vast majority of data stories a student reporter is likely to pursue.
Finding Data Worth Reporting On
Public data is more available than most student reporters realize. Government agencies at the local, regional, and national level routinely publish open data portals covering budgets, enrollment figures, public health statistics, transportation counts, and more. School districts and student governments often publish budget documents, meeting minutes with attached spreadsheets, and annual reports that rarely get read closely by anyone, which is exactly why they are worth your attention.
- Start with budgets. A budget document is a story about priorities told in numbers. Compare this year’s line items to last year’s and look for anything that moved sharply in either direction.
- Look for anything published on a schedule. Recurring reports, whether monthly, quarterly, or annual, are easy to compare across time, which is often where the real story lives.
- Ask officials directly what data they already collect. Many organizations track internal metrics that are never proactively published but are available if you file the right request.
The Public Records Angle
When data is not already published, a records request can often get it released, provided it is not exempt under whatever public records law applies where you live. Rules vary significantly by country and by state or province, so check what applies to your own jurisdiction and, when in doubt, ask a faculty adviser or a local journalism organization for guidance before filing.
Core Spreadsheet Skills
A basic spreadsheet program is the only tool most student data stories require. Focus on mastering a small set of functions rather than trying to learn everything at once.
- Sorting and filtering to quickly find the largest, smallest, or most unusual values in a column.
- Basic formulas for sums, averages, and percentage change, so you can describe growth or decline accurately instead of guessing.
- Pivot tables for grouping and summarizing large datasets, which is often the fastest way to spot a pattern buried in thousands of rows.
- Cleaning data, meaning fixing inconsistent formatting, removing duplicate entries, and standardizing labels so the same category is not being counted under two different names.
Cleaning is unglamorous but it is where most data errors are born. If a dataset lists a category as “9th grade,” “Ninth Grade,” and “Freshman” in different rows, your totals will be wrong until you standardize those labels. Budget real time for this step; do not treat it as an afterthought.
Asking Good Questions of a Dataset
Once your data is clean, interrogate it the way you would interrogate a source. What changed over time? What is the biggest outlier, and is it a real trend or a data entry error? How does this compare to a similar group, whether that is a comparable school, department, or time period? Write your questions down before you start looking for answers, so you are not just fishing for whatever number looks most dramatic.
Verifying Before You Publish
Numbers feel authoritative, which makes them dangerous to get wrong. Apply the same verification discipline to data that you would apply to a quote.
- Confirm the source and the date of the dataset. Numbers that are years out of date can be technically accurate and still misleading if presented as current.
- Understand what is actually being measured. A count of “reported incidents” is not the same as a count of “actual incidents,” and conflating the two is a common and serious error.
- Recalculate at least one figure yourself rather than trusting a summary number handed to you by an official source. If your math does not match theirs, that discrepancy might be a story in itself.
- Ask a knowledgeable person to sanity-check your interpretation before publication, the same way you would ask a source to confirm you understood a complex explanation correctly.
Presenting Data Honestly
How you present a number can be just as misleading as getting the number wrong. A few habits protect both your readers and your credibility.
- Show the baseline. A jump from two incidents to four is technically a one hundred percent increase, but presenting the raw numbers alongside the percentage keeps readers from being misled by a small sample size.
- Avoid cherry-picking the most dramatic time frame. If a trend looks alarming over one month but flat over three years, say so.
- Keep charts simple. A basic bar or line chart that shows exactly the comparison you are making is almost always better than something more elaborate that requires a legend to decode.
- Always label your axes and your units so a chart cannot be misread out of context if it is shared on its own.
Pairing Data With Human Sources
A number alone rarely makes a complete story. The spreadsheet tells you that something is happening; a human source tells you why it matters. If enrollment in an elective dropped by a third, the data gives you the fact, but a conversation with a student, a teacher, and a scheduling administrator gives you the explanation and the human stakes. Treat data as the starting point for reporting, not the finished product, and your data stories will read like journalism rather than a spreadsheet with captions.