AP® Computer Science Principles · Big Idea 2 · Topic 2.3

From Data to Information

Data becomes information when a program organizes it so a pattern shows up: grouped, sorted, or graphed. Raw rows alone tell you nothing until something processes them into a shape a person can read.

Ten thousand rows of numbers is data: true, but useless on its own. Your eye cannot scan ten thousand anything and find a pattern. A program can, though. It can sort the rows, group them into categories, count how often something happens, or plot each value as a point on a graph. Once that happens, the data becomes information: something a person can actually read and act on. A table of every daily temperature for two years is data. A line graph of those temperatures, with a wave that rises every June and falls every January, is information. The shape only appears once the values are arranged in order and plotted, so the eye can catch the repeating curve.

The same trick works on anything sortable. Take 500 test scores and sort them from lowest to highest. Suddenly you can see where scores cluster, whether most students landed in the 70s and 80s, whether there is a long tail of very low scores, whether the distribution is roughly symmetric or skewed. None of that was visible in the original unsorted list, even though every number was already there. Sorting and grouping do not add new facts. They just reveal structure that was always hidden in the raw rows.

Joining two data sets can change the story entirely, because a conclusion drawn from one source only reflects what that source measured. A city looking only at reported bike thefts might conclude wealthy neighborhoods barely have a theft problem. Join in a second data set on reporting rates, and a hidden factor surfaces: those neighborhoods might report thefts more often, not experience fewer of them. This is why Big Idea 2 treats information as something built, not just found: the same underlying bits can support very different conclusions depending on what data gets combined and how.

Key terms

Data
Raw, unorganized facts or values, such as individual rows in a spreadsheet, before any pattern is drawn out.
Information
Data that has been organized, grouped, or displayed so a person can find meaning or a pattern in it.
Joining data
Combining two separate data sets, often to reveal a hidden factor that changes a conclusion drawn from just one.
Distribution
The overall shape of a set of values, showing where they cluster and how spread out they are.

Watch it explained

  1. How it worksHow does a program turn raw rows of data into a pattern a person can actually see?
  2. How it worksWalk me through spotting a seasonal trend in two years of daily temperature readings.
  3. Worked exampleShow me how sorting a list of 500 test scores reveals the shape of the whole distribution.
  4. Going furtherWhat changes about a conclusion when data from one source is joined with a second source?

Check yourself

Your turn1 of 2
A spreadsheet has 1423 rows of raw data. A program groups the rows into 14 equal-sized categories to summarize them as information a person can read. How many rows fall into each category?

End of topic.