Secondary data · worked example A secondary-data investigation

The white shark study, and the file it came from

A secondary-data investigation, followed from start to finish: no site visit, no equipment, no fieldwork. One published file, every animal caught on Queensland’s shark nets and drumlines since 1996, and every step needed before it could answer a question.

Every number below came out of the real file. So did every problem with it.

The issue in one paragraph

Since 1962, Queensland has set shark nets and drumlines (baited hooks on buoys) off popular beaches on its coast, in Australia. They catch more than the sharks they are there for: the programme’s own file records 1,456 turtles and 590 marine mammals. They also catch white sharks, a protected species. Which gear to set, nets or drumlines, is the programme’s own decision, and it records every animal each one catches. So I could test, not just claim, whether the two gears differ in what they do to one protected shark.

The question, in three drafts

Most first questions are too big to answer or too vague to measure. The dangerous draft is the second one, because it looks finished.

Draft 1

“Do shark nets work?”

No indicator, no units and no variation to explain. And "work" means bather safety, which this file does not measure.

Draft 2

“Do nets catch a larger share of white sharks than drumlines across Queensland?”

Measurable and dated, and asking the wrong question of this file. Drumlines are also set far north, from Cairns to Bundaberg, where white sharks do not swim, so a statewide comparison compares places as well as gear.

Final

“A comparison of the share of the sharks caught that were white sharks, between nets and drumlines, in the four areas of Queensland's Shark Control Program that set both (Gold Coast, Sunshine Coast North, Sunshine Coast South and Rainbow Beach), 1996 to 2023.”

Restricted to the four areas that set both gears, so the two are compared in the same places.

Independent variable: the gear, Net or Drum. Dependent variable: white sharks as a percentage of all the sharks that gear caught.

The hypothesis, written before I looked

“Nets will catch the larger share of white sharks, because a net takes whatever swims into it, while a baited hook takes what comes to the bait.”

Students often think a hypothesis the data refutes is a failed investigation. It is not. This one was refuted in the four areas, where the drumlines had the larger share, although the statewide figure would have seemed to support it. I kept it, because working out why it was wrong is most of the analysis.

The system, and the three lines

Every investigation in this guide fills three lines, running one way. Here the third line is also the first: the plan is the gear.

1 · What people do

The gear: a net, or a drumline (a baited hook on a buoy). The programme chooses which to set, and the file records it in one column, Gear.

2 · What happens to nature

White sharks, a protected species, as a share of all the sharks each gear caught. Worked out from CommonName and NumberCaught.

3 · Somebody's plan

Queensland's Shark Control Program. The gear is the plan, so the real-world strategy and the independent variable are the same thing.

What the file can see, and what it cannot

It is tempting to read a catch file as a count of sharks. It is not. The file records a flow: the animals the gear takes out of the coastal water each month. It says nothing about the storage, how many sharks live along the coast. White sharks pass in winter and spring, so how many are caught depends on when they pass, where the gear is and how much of it is in the water, and only partly on how many there are. That is why this study can compare the gears, and can never say whether white sharks are declining.

The strategy, and the argument about it

Criterion B (Strategy) needs one real-world strategy and one explained tension. Here the strategy is not beside the data: it is the independent variable, as close a fit as a study can have.

Queensland's Shark Control Program: nets and drumlines at popular beaches
Since 1962. The Shark Management Plan 2025 to 2029 added lethal gear at seven new locations on the Gold Coast, Sunshine Coast and Wide Bay, with daily servicing.

Who: The Queensland Government, through the Department of Primary Industries: nets and drumlines off about 85 beaches, serviced by contractors.

How it bears on the question: Directly: the gear is the programme. Which to set, nets or drumlines, is its own decision, and my question asks what each one does to one protected shark.

The tension: Swimmers' safety and a beach economy against wildlife: the file itself records 1,456 turtles and 590 marine mammals caught. The government's own KPMG review advised moving away from nets and drumlines; the 2025 plan expanded them, and scientists said culling does not make beaches safer.

See the source
No killing inside the Great Barrier Reef Marine Park, and catch alert drumlines
Tribunal ruling April 2019. Queensland lost its Federal Court appeal later that year.

Who: Humane Society International, with the Environmental Defenders Office, took the programme to the Administrative Appeals Tribunal. Queensland now runs catch alert drumlines there, which send a satellite alert so a team can release the shark.

How it bears on the question: Indirectly: it is the same argument, taken to a tribunal and then a court, and it shows what the tension does.

The tension: The tribunal found the evidence "overwhelming" that killing sharks does not reduce the risk of bites, against a state government that appealed the ruling and lost.

See the source

Students usually look for the disagreement in the data. It is not there. It lives in the government’s plan and the programme’s own pages, in a review the government commissioned (KPMG), in a tribunal decision, and in the news reporting of both sides.

What the tension does: resistance and delay (a lawsuit, then an appeal), and uneven costs. Bathers and the beach economy get the claimed safety; the wildlife, and the people who value it, bear the catch. For the environment, more gear in the water means more animals caught, protected species included. My question sits on the choice the plan makes: what each of its two gears does to one protected shark.

The dataset, and the protocol

On this route, the method section tells a reader how to get exactly the same file. This table is the model. Everything in it was recorded from the screen at the moment of download. None of it could have been worked out a month later.

Publisher
Queensland Government, Department of Primary Industries (Shark Control Program)
Dataset
Queensland's Shark Control Program Data and Information, on the Queensland Government Open Data Portal
File
Number caught by area, calendar year and species group (scp_numbers-caught.xlsx), last modified 19 June 2026
Extraction
Clicked the file's link on the dataset page, in a browser. A script is answered with an empty file
Downloaded
26 September 2026
Licence
Creative Commons Attribution 4.0: credit the Queensland Government, Shark Control Program
Format
One Excel file, one sheet, headings in the first row, 15 columns
Rows in the file
23,118, from 1996 to May 2026
Rows analysed
4,299, holding 5,228 sharks

Open the dataset page and download the file yourself

Click the file’s link in a browser. The portal’s bot protection answers a script with an empty file, so “the download worked” and “I have the data” are not the same thing. Open it and check the rows are there before anything else.

Fifteen columns, and what one row is
Year, Month, MonthName · when, to the month
Area, BeachName · where: the programme's area, and the beach
Gear · Net, Drum (a baited hook on a buoy) or Other
SpeciesGroup · SHARK, TURTLE, MAMMAL or OTHER
CommonName, ScientificName · the species. A name with a star is a group, not a species: HAMMERHEAD SHARK *
Alive/Deceased, Fate · alive or dead when the gear was checked, and whether the animal was released, died or was killed
NumberCaught · how many. Every total on this page comes from this column
MarinePark, CaabCode, FateReason · in the file, not used here

The usual assumption is that one row is one animal. It is not. One row is one kind of animal caught on one kind of gear at one beach in one month, with how many in NumberCaught. In the rows I analysed, 591 of 4,299 record more than one. And a month in which no white shark was caught has no white shark row at all, not a row with 0. Adding up NumberCaught handles both. Counting rows handles neither.

What the file actually was

A government file looks trustworthy, and this one is the programme’s own record. It still says less than it seems to.

23,118
rows in the download
4,003
rows holding more than one animal
214
white sharks in the whole file, 1996 to 2026
Why the study stops at 2023

All sharks caught ran at about 500 to 850 a year until 2022, then 948, 1,497 and 3,430 in 2023 to 2025. From 2024 the programme brought in new locations, daily servicing and new drumlines, and because the file records the programme’s own catch, more gear looks exactly like more sharks. A study that runs into those years measures the programme as much as the coast. And 2026 stops in May.

White sharks are rare in it. In the four areas, 1996 to 2023, they come eighth among the sharks caught:

Tiger shark1,351
Long nose whaler1,298
Scalloped hammerhead505
Bull whaler492
Great hammerhead274
Dusky whaler257
Hammerhead shark *251
White shark147

And they are almost all caught south of Bundaberg. The drumlines are also set from Cairns to Bundaberg, where the sharks are almost all tiger sharks, whalers and hammerheads. That one fact is why the second draft of the question had to go.

The whole calculation

Raw counts cannot be compared between the gears. Nets caught 3,296 sharks in the four areas and drumlines 1,932, so any count of white sharks would mostly compare how much each gear caught. So each gear is measured against itself: white sharks as a percentage of its own shark catch. That is the normalising control. The file does not contain that number; I made it.

The restricting control is the inclusion rule. I fixed it before I looked at a single white shark:

  • Year 1996 to 2023
  • SpeciesGroup SHARK
  • Gear Net or Drum
  • Area Gold Coast, Sunshine Coast North, Sunshine Coast South or Rainbow Beach

Two more decisions, also made before looking. Gear “Other” is 5 rows, holding one white shark: left out. UNKNOWN SHARK (18 animals) and the starred groups stay in “other sharks”: they are sharks, and none is recorded as a white shark. What survives is 66 beaches (16 with nets only, 35 with drumlines only, 15 with both): 4,299 rows holding 5,228 sharks.

Filter to the rule and copy what is left into a new tab. Columns as downloaded: F is Gear, J is CommonName, O is NumberCaught. P is the one column I added.

P2, filled down
=IF(J2="WHITE SHARK", "White shark", "Other shark")
a label on every row
Nets, white
=SUMIFS(O:O, F:F, "Net", P:P, "White shark")
73
Nets, other
=SUMIFS(O:O, F:F, "Net", P:P, "Other shark")
3,223
Drumlines, white
=SUMIFS(O:O, F:F, "Drum", P:P, "White shark")
74
Drumlines, other
=SUMIFS(O:O, F:F, "Drum", P:P, "Other shark")
1,858
Share
=100 * white / (white + other)
2.2% and 3.8%

Why a new tab: SUMIFS adds up every row in the column, including the rows a filter has only hidden. Run these on the filtered original and they count every year, every area and every species, turtles included. The check: 73 + 3,223 = 3,296 and 74 + 1,858 = 1,932. If yours differ, a filter is wrong.

One helper column, four SUMIFS, one division and a chi-squared test. That is the whole method.

White sharks as a percentage of all the sharks each gear caught, four areas, 1996 to 2023Two bars on a scale from 0 to 5 per cent. Nets: 73 white sharks among 3,296 sharks caught, 2.2 per cent. Drumlines: 74 white sharks among 1,932 sharks caught, 3.8 per cent.0%1%2%3%4%5%Nets73 of 3,2962.2%Drumlines74 of 1,9323.8%
Figure 1. White sharks as a percentage of all the sharks each gear caught, in the four areas that set both gears (Gold Coast, Sunshine Coast North, Sunshine Coast South and Rainbow Beach), 1996 to 2023. Totals are NumberCaught added up, not rows counted. Data: Queensland Government, Shark Control Program (CC BY 4.0), downloaded 26 September 2026. Author’s own analysis.

What it found

The four numbers the SUMIFS gave, and the share each one makes. Four areas, 1996 to 2023.

White sharks
Other sharks
All sharks
White share
Nets
73
3,223
3,296
2.2%
Drumlines
74
1,858
1,932
3.8%
Total
147
5,081
5,228

The test is a chi-squared test of independence on the 2 by 2 table: gear against white shark or other shark, with one degree of freedom. It runs on the counts, never the percentages, because a percentage has thrown away how many sharks it was made from. The result: chi-squared = 11.6, p about 0.0007, far above the critical value of 3.84 at p = 0.05. Every expected count is above 50 (the smallest is about 54), so the test is valid.

So the hypothesis is refuted. It was the drumlines, not the nets, that caught the larger share of white sharks, and the same is true in each of the four areas on its own:

Area
Nets
Drumlines
Gold Coast
56 of 1,246 (4.5%)
42 of 526 (8.0%)
Sunshine Coast North
8 of 1,016 (0.8%)
15 of 600 (2.5%)
Sunshine Coast South
3 of 327 (0.9%)
10 of 339 (2.9%)
Rainbow Beach
6 of 707 (0.8%)
7 of 467 (1.5%)
Four areas together
73 of 3,296 (2.2%)
74 of 1,932 (3.8%)

The season behind the gap

The headline is significant. That does not mean it is explained. Adding up the same columns by month explained it.

White sharks caught by month, and all sharks caught by month for each gear, four areas, 1996 to 2023Top panel, white sharks caught in each month from January to December: 3, 0, 3, 1, 5, 14, 26, 30, 31, 23, 7 and 4. Bottom panel, sharks of every kind caught in each month. Nets: 429, 428, 319, 179, 171, 183, 148, 110, 218, 343, 348 and 420, high in summer and low in winter. Drumlines: 197, 155, 177, 131, 169, 143, 160, 124, 185, 220, 126 and 145, much flatter. June to October is shaded: it holds 124 of the 147 white sharks, and the nets catch least in those months.June to OctoberWhite sharks caught0102030All sharks caught, by gear0100200300400NetsDrumlinesJanFebMarAprMayJunJulAugSepOctNovDec
Figure 2. White sharks caught in each month (top), and sharks of every kind caught by each gear in each month (bottom), in the four areas, 1996 to 2023, all years added together. The shaded months hold 124 of the 147 white sharks, but only 30% of the nets’ sharks, against 43% of the drumlines’. Data: Queensland Government, Shark Control Program (CC BY 4.0), downloaded 26 September 2026. Author’s own analysis.

White sharks pass in winter and spring: 124 of the 147 were caught June to October. The nets catch most of their other sharks in summer. Only 30% of the nets’ sharks were caught June to October, against 43% of the drumlines’.

So I compared the two gears in those five months alone. Nets: 63 white sharks of 1,002 (6.3%). Drumlines: 61 of 832 (7.3%). Chi-squared 0.8, p about 0.38: no significant difference.

The part the headline hides

Read carelessly, the headline says drumlines are worse for white sharks. The months say something else. Most of the difference comes from when each gear catches its other sharks, not which sharks it catches. The nets’ big summer catch of other sharks dilutes their white-shark share. Season is a confounding variable: it is tied to the gear’s catch and to the white sharks at once. Finding it is the kind of analysis Criterion E (Analysis and conclusion) is there for.

The conclusion, and what it cannot claim

A conclusion claims exactly what was found, and no more. This is mine.

“Across 1996 to 2023, in the four areas that set both gears, white sharks made up a larger share of the drumlines’ shark catch (3.8%) than of the nets’ (2.2%), a difference unlikely to be chance (chi-squared 11.6, p about 0.0007). But in the months white sharks pass, June to October, the two shares were close (7.3% and 6.3%) and not significantly different. The difference comes mostly from when each gear catches its other sharks, not from which sharks it catches.”

Four sentences the file cannot carry, each tempting:

“Drumlines catch more white sharks than nets.”

It is a share, not a rate. The file does not say how many nets and drumlines were in the water, or for how long, so it cannot say which gear catches more white sharks a day.

“Drumlines are worse for white sharks.”

The season test says most of the difference is timing. And if anything the fate data points the other way: 37 of the drumlines' 74 white sharks were alive when the gear was checked, against 28 of the nets' 73.

“Shark control makes beaches safer.”

Nothing here measures bites or swimmers.

“White sharks are declining.”

Catch depends on gear and effort, not only on how many sharks there are.

Eight things wrong with it

None of these were added on purpose. They are all in the programme’s own file, and each one is taught somewhere in the guide. Where one pushes the answer, it says which way.

  1. 1Place. Drumlines are also set from Cairns to Bundaberg, where there are no white sharks. Take in the whole state and the drumlines' share is dragged down until the answer reverses. step 2 →
  2. 2The download can arrive empty: the portal answers a script with an empty file. Click the link in a browser and check the rows are there. step 4 →
  3. 3The gear changed in 2024, and the programme records its own catch, so more gear looks exactly like more sharks. Hence the stop at 2023. step 4 →
  4. 4A row is not an animal: 4,003 rows in the file record more than one. Counting rows undercounts. step 5 →
  5. 5A month with no white shark has no row, not a row with 0. Only adding up NumberCaught treats the missing zeros correctly. step 5 →
  6. 6Season. The nets' big summer catch of other sharks dilutes their white share, which pushes it down and inflates the gap between the gears. step 6 →
  7. 7Effort is not in the file, so it gives a share and never a rate. Which way that pushes the answer is unknown. step 6 →
  8. 8Identification. 18 UNKNOWN SHARK and the starred groups could hide white sharks. That would push the true shares slightly up, by an amount nobody can tell for each gear. step 7 →

The evaluation

Students usually list weaknesses as if they were equal. They are not. Mine, ranked by how much they mattered:

  1. 1Season. It explains most of the difference. The sensitivity test: keep only June to October, and chi-squared falls from 11.6 to 0.8. This is a sensitivity test that failed, and it was worth more than one that passed: it turned a finding about gear into a finding about timing.
  2. 2Place. The second sensitivity test. Across the whole state the answer reverses: nets 1.8% (73 of 4,162), drumlines 0.9% (132 of 14,175), chi-squared 19.7. That is why the restriction to four areas was fixed before looking, and why it goes in the method with its reason.
  3. 3No effort data. A share, not a rate. Without the amount of gear in the water, no sentence about which gear catches more white sharks can be written.
  4. 4Identification. 18 unknown sharks sit in "other sharks". Any of them could have been a white shark.

The two sensitivity tests, in one table: the same comparison made four ways.

Compared
Nets
Drumlines
Chi-squared
What it says
Four areas, all months
73 of 3,296 (2.2%)
74 of 1,932 (3.8%)
11.6, p about 0.0007
Drumlines larger, significant
Four areas, June to October
63 of 1,002 (6.3%)
61 of 832 (7.3%)
0.8, p about 0.38
No significant difference
Four areas, November to May
10 of 2,294 (0.4%)
13 of 1,100 (1.2%)
expected counts about 7.5
Weak evidence either way
All Queensland, all months
73 of 4,162 (1.8%)
132 of 14,175 (0.9%)
19.7
Reversed: nets larger
Improvements that name something real
  • The programme's equipment locations file, on the same dataset page ("Queensland Shark Control Program equipment locations"), gives where each net and drumline is. With it, catch could be divided by the amount of gear, turning a share into a rate. It lists current locations, so it would need matching to the years it covers.
  • The biological information file on the same page ("Biological information from caught animals") records lengths. It could test whether the two gears catch white sharks of different sizes.
  • Compare the gears month by month rather than pooled, or pair the 15 beaches that set both gears.
Unresolved questions

Each has a different focus from my question, and each bears on the strategy.

  • Does a white shark caught on a drumline survive more often than one caught in a net? The file has 37 of 74 alive against 28 of 73. I did not test it.
  • Do nets and drumlines catch white sharks of different sizes?
  • What did the 2024 expansion, with new drumlines and daily servicing, do to the white-shark catch?

The sources

All three are real and public. Follow each link to the original; the summary is mine.

The data · a government open data portal
Queensland's Shark Control Program Data and Information
Queensland Government, Department of Primary Industries · file: Number caught by area, calendar year and species group · 1996 to May 2026 · CC BY 4.0

The programme's own record of every animal its nets and drumlines catch, by beach, month, gear and species. It has one author, the programme, which both collects the data and publishes it, so there is no second compiler to credit.

The same page holds the equipment locations file and the biological information file named in the evaluation.

Open the dataset page
The tension · a news report with a named author
Plan to increase lethal shark control in Queensland 'baffling' to scientist
Will Murray, ABC News, 8 June 2025

The government's own KPMG review advised moving away from nets and drumlines. The 2025 plan expanded them, and scientists said culling does not make beaches safer.

Cite it for who said what. Cite the data file for what was caught.

Read the report
The strategy · the programme's own page
Queensland Department of Primary Industries: catch alert drumlines
Organisation webpage, corporate author

Catch alert drumlines send a satellite alert so a team can release the shark. Queensland now runs them in the Great Barrier Reef Marine Park, after the tribunal's April 2019 ruling against killing sharks there.

Open the page
How I referenced them
  • Queensland Government, Department of Primary Industries. "Queensland's Shark Control Program Data and Information: Number caught by area, calendar year and species group." Queensland Government Open Data Portal, 2026. CC BY 4.0. Accessed 26 September 2026. https://www.data.qld.gov.au/dataset/fisheries-queensland-s-shark-control-program-information-and-data
  • Will Murray, "Plan to increase lethal shark control in Queensland 'baffling' to scientist," ABC News, 8 June 2025, accessed 26 September 2026, https://www.abc.net.au/news/2025-06-08/qld-shark-control-program-against-advice-of-kpmg-report/105387824
  • Queensland Department of Primary Industries, catch alert drumlines page. https://www.dpi.qld.gov.au/news-media/campaigns/sharksmart/equipment/catch-alert

The page’s own title could not be read, so the third reference describes the page rather than quoting one. Never invent a title to make a reference look complete.

One wrong word, everywhere

The natural word for a shark-control programme is killed, and it is wrong. The file records animals caught, and 65 of the 147 white sharks were alive when the gear was checked. Say what the number is: caught. step 8 →

Where it fits · ESS syllabus
  • 3.2 Human impact on biodiversity, A protected species caught by gear set for a different purpose, beside 1,456 turtles and 590 marine mammals in the same file.
  • 3.3 Conservation and regeneration, A protected shark, a tribunal ruling against killing inside a marine park, and catch alert drumlines that let a team release what is caught.
  • 1.2 Systems, The file counts a flow, the animals taken from the coast each month, not a storage, how many sharks there are.
  • 1.1 / 1.3 Perspectives and sustainability, Swimmers and a beach economy against wildlife, and a plan that expanded the gear its own government's review advised moving away from.
Questions to discuss
  1. Across the whole state nets had the larger share; in the four areas, drumlines did. Which comparison answers the choice the programme actually makes, and why?
  2. In June to October the gap almost disappears. Is the headline finding wrong, or only badly explained?
  3. 65 of the 147 white sharks were alive when the gear was checked. Does that change what "worse for white sharks" should mean?
  4. The file shows what each gear caught, not how much gear was in the water. How would you word a conclusion that stays inside what a share can say?
  5. The KPMG review advised moving away from nets and drumlines, and the 2025 plan expanded them. Could anything in this file settle that argument?
Using this

In your IA: notice how much of this happened before any analysis. The three drafts, the inclusion rule fixed before looking, and the check that four SUMIFS add up to 3,296 and 1,932 are most of Criterion C (Method). The test at the end is the smallest part.

In class: the download is one click in a browser. Give a class the file and the headline, and ask why the nets’ share is lower. Adding Month to the SUMIFS finds the season, and teaches more about confounding than any amount of explaining.

The white shark investigation used on the secondary-data route of this guide is the author’s own analysis of a published dataset: the Queensland Shark Control Program’s record of every animal caught on its nets and drumlines, published by the Queensland Government under CC BY 4.0 and downloaded on 26 September 2026. The choice of the four areas, the analysis and the conclusions are the author’s, not the Queensland Government’s.

The white shark study, and the file it came from · ESS IA guide | ESS all the way