Organising data in a table with headings

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. In a data table, what does each column have at the top?

A One heading that names the data in that column

B A different record for each cell

2. Which describes how a data table stores records?

A One column for each record, with all the pets mixed together

B One row for each record, like one pet

3. A table has the headings Name, Age and Favourite Sport. Which is the best row of data?

A Mia | 11 | Netball

B Mia and Netball | 11 | (blank)

4. Which table is set up better?

A Row 1 is Sam, row 2 is Ava, row 3 is Leo, with no gaps

B Row 1 is Sam, row 2 is empty, row 3 is Ava, row 4 is empty, row 5 is Leo

5. Which column heading is clearer for a column that holds how tall each student is?

A Stuff

B Height (cm)

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Name \| Age \| Pet		AOne record, with one row holding all the facts about one student
2Mia \| 10 \| Dog		BSam \| 6 \| Netball
3Each column has one heading that says what data goes in it		CThere is no heading row. Each column needs a heading such as Name, Age and Pet so we know what the data means.
4Each row is one record, so one student is one row		DName \| Year \| Sport
5Name \| Age Mia \| 10 (blank row) Tom \| 11		EA row of column headings that names each column of data in the table
6Mia \| 10 \| Dog Tom \| 11 \| Cat Zoe \| 9 \| Fish		FThere is a blank row between records. A data table should have no blank rows, so the blank row should be deleted.

Definitions

data table

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Name,___,Pet Mia,10,Dog Sam,11,Cat

Each ______ has one heading Each row holds one record

Heading row: Name,Pet Record 1: Mia,Dog Record _: Sam,Cat

Top row: headings Each row after it holds one ______

Heading row: Name,Pet Records: Mia,Dog and Sam,Cat Blank rows: _

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Name | | Pet

B Mia | 10 | Dog

C Sam | 11 | Cat

Question 2

A Pet and Age | Colour

B Rex | 3 | Brown

C Kit | 2 | Grey

Question 3

A Name | Year | Sport

B | |

C Ben | 6 | Soccer

D Cal | 5 | Tennis

Question 4

A Book | Pages | Author

B Holes | 233 | Sachar

C Matilda | 240 | Dahl

D Wonder | Palacio | 310

Question 5

A Fruit | Colour | Price

B Apple | Red | 1.20

C Banana, Pear | Yellow | 0.50

D Grape | Green | 3.00

Answer Key

Organising data in a table with headings

Section A: Quick Questions

A — One heading that names the data in that column

B — One row for each record, like one pet

A — Mia | 11 | Netball

A — Row 1 is Sam, row 2 is Ava, row 3 is Leo, with no gaps

B — Height (cm)

Section B: Match the Pairs

Name | Age | Pet → A row of column headings that names each column of data in the table

Mia | 10 | Dog → One record, with one row holding all the facts about one student

Each column has one heading that says what data goes in it → Name | Year | Sport

Each row is one record, so one student is one row → Sam | 6 | Netball

Name | Age Mia | 10 (blank row) Tom | 11 → There is a blank row between records. A data table should have no blank rows, so the blank row should be deleted.

Mia | 10 | Dog Tom | 11 | Cat Zoe | 9 | Fish → There is no heading row. Each column needs a heading such as Name, Age and Pet so we know what the data means.

Section C: Definitions

data table — A grid that organises data. Each column has one heading, and each row holds one record, like one student or one pet. There are no blank rows.

Section D: Fill in the Blanks

Name,Age,Pet
Mia,10,Dog
Sam,11,Cat

Each column has one heading
Each row holds one record

Heading row: Name,Pet
Record 1: Mia,Dog
Record 2: Sam,Cat

Top row: headings
Each row after it holds one record

Heading row: Name,Pet
Records: Mia,Dog and Sam,Cat
Blank rows: 0

Section E: Spot the Error

A — Every column needs its own heading. The Age column has no heading. It should be Name | Age | Pet.

A — Each column gets one heading only. Pet and Age were squashed into one heading. It should be Pet | Age | Colour.

B — A table must have no blank rows. This row is empty, so it holds no record. It should be Ava | 5 | Netball.

D — The values are in the wrong columns. The author is under Pages and the number is under Author. It should be Wonder | 310 | Palacio.

C — Each row holds one record. This row squashes two fruits into one row. It should be Banana | Yellow | 0.50, with Pear in its own row.