0.6.3 Spreadsheets

A Spreadsheet Organizes Information in a Grid

A spreadsheet arranges information into:

• rows;
• columns;
• cells.

Each cell is located at the intersection of one row and one column.

This grid is useful for structured data because the same columns can describe many records consistently.

For example:

The columns establish the structure.

The rows hold the individual entries.

Columns Usually Represent Consistent Fields

In the music example:

Title
Artist
Genre
Year

are field names.

The meaning of the Genre column should remain the same from one row to the next.

If one row uses that column for genre and another uses it for a price, the data becomes difficult to interpret.

Consistency is one of the biggest advantages of a spreadsheet table.

Rows Can Represent Individual Items

Each data row can represent one item.

For example:

Northern Lights | Example Band | Rock | 2024

describes one song record.

The next row describes another song.

This row-based organization makes it possible to compare many similar records.

Later in the module, you will use more precise vocabulary for records and fields.

For now, focus on the visible structure.

Cells Hold Individual Values

A cell might contain:

Northern Lights

or:

2024

or:

Rock

Each value should make sense in the context of its column.

The same cell can also contain a formula, but the FIT structured-data sequence begins with understanding and organizing data rather than advanced spreadsheet calculations.

Headers Explain the Columns

A header row gives each column a clear meaning.

Compare this:

with:

The second table is easier to understand because the fields are named.

Good headers reduce ambiguity.

Spreadsheets Can Store More Than Numbers

A spreadsheet can contain:

• text;
• numbers;
• dates;
• Boolean-like states;
• formulas;
• links;
• other values.

Do not assume that “spreadsheet data” means only arithmetic.

The grid is useful because many kinds of structured information can be organized consistently.

Spreadsheets Support Data Operations

Once data is structured consistently, spreadsheet tools can help with operations such as:

• sorting;
• filtering;
• calculations;
• summaries;
• charts.

These operations are powerful because the spreadsheet knows which values belong to which rows and columns.

Later activities will use those capabilities more directly.

Keep One Kind of Information in One Column

Suppose a column is named:

Artist

Values should be artist names.

Avoid mixing:

Example Band
Dana Lee
2024
Rock

in the same field if those values represent different concepts.

A consistent column is easier to filter, sort, and understand.

Avoid Using Layout as Data Meaning

A visually pleasing spreadsheet can still contain poorly structured data.

For example, merged cells, blank spacer rows, and decorative blocks may make a report attractive but can make repeated records harder to process as a dataset.

In a structured-data table, prioritize:

• one clear header row;
• consistent columns;
• one logical item per row;
• values placed in the correct field.

Visual formatting can support readability, but the structure should carry the meaning.

A Spreadsheet Is Both Human-Readable and Machine-Usable

One reason spreadsheets are common is that people can inspect them directly.

At the same time, software can work with consistent rows and columns.

That makes a spreadsheet a useful bridge between human data entry and automated processing.

The Main Purpose in This Module

You are not learning every spreadsheet feature.

You are using spreadsheets to understand how structured data can be:

• organized;
• entered;
• imported;
• cleaned later;
• summarized later;
• connected to other digital systems later.

The next Learning Activity focuses on working in Google Sheets as one spreadsheet environment.