Annotated diagram of a database or spreadsheet

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. What makes a diagram of a spreadsheet an annotated diagram?

A It has labels and notes explaining what each part does

B It only shows the spreadsheet with no extra writing

2. A student draws a database table and labels one field 'StudentID - Integer'. What is this annotation showing?

A The field name and its data type

B The formula used to calculate the field

3. Which note would best annotate cell D2 in a spreadsheet?

A Formula =B2*C2 calculates the total cost

B This is a nice-looking cell

4. Which parts of a database or spreadsheet can be labelled in an annotated diagram?

A Only the title of the file

B Tables, fields, cells and formulas

5. A field called Age should only accept whole numbers from 0 to 120. Which annotation fits best?

A Formula: =SUM(Age)

B Validation: range check, integer between 0 and 120

Match the Pairs

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

Left column		Right column
1Field: DateJoined (Date/time)		AThe note does not record the formula. It should show how the value is calculated, such as D2 = B2*C2.
2Note: D2 = B2*C2		BValidation: Age must be a whole number from 12 to 18
3An annotation on a validation rule explains which values a field will accept		CAn annotation that records the formula in a cell, showing how the value is calculated from other cells
4An annotation identifies a field and says what data it holds and what type it is		DThe data type is wrong. Quantity is a count used in calculations, so it should be labelled Integer, not Text.
5Field: Quantity (Text) - number of items ordered		EField: Price (Floating point) - cost of one item in dollars
6Cell D2: Total cost of the order		FAn annotation that labels a field and states its data type, so readers know it stores dates and times

Definitions

annotated diagram

Fill in the Blanks

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

Field: DateOfBirth Data type: _________

Cell D2 note: =___(B2:C2) adds the marks

Validation: _____ check keeps Mark 0 to 100

Label: StudentID = primary ___ (unique)

F2: =__(E2>=50,"Pass","Fail") Note: tests if the mark reaches 50

Spot the Error

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

Question 1

A Table: Students

B Field: Age (Text)

C Note: whole number, 12 to 19

Question 2

A Cell B2: Price (dollars)

B Cell C2: Quantity (Integer)

C Cell D2: Total (price x qty)

D Formula D2: =B2+C2

Question 3

A Field: Quantity (Integer)

B Validation: range 1 to 1000

C Note: rejects 0 and 101

Question 4

A Cell: Orders

B Field: OrderDate (Date/Time)

C Note: stores the date ordered

Question 5

A Cell A1: Student name

B Cell B1: Test 1 mark

C Cell C1: Test 2 mark

D Formula D1: =SUM(B1:C1)

E Note: D1 is the mean of B1:C1

Answer Key

Annotated diagram of a database or spreadsheet

Section A: Quick Questions

A — It has labels and notes explaining what each part does

A — The field name and its data type

A — Formula =B2*C2 calculates the total cost

B — Tables, fields, cells and formulas

B — Validation: range check, integer between 0 and 120

Section B: Match the Pairs

Field: DateJoined (Date/time) → An annotation that labels a field and states its data type, so readers know it stores dates and times

Note: D2 = B2*C2 → An annotation that records the formula in a cell, showing how the value is calculated from other cells

An annotation on a validation rule explains which values a field will accept → Validation: Age must be a whole number from 12 to 18

An annotation identifies a field and says what data it holds and what type it is → Field: Price (Floating point) - cost of one item in dollars

Field: Quantity (Text) - number of items ordered → The data type is wrong. Quantity is a count used in calculations, so it should be labelled Integer, not Text.

Cell D2: Total cost of the order → The note does not record the formula. It should show how the value is calculated, such as D2 = B2*C2.

Section C: Definitions

annotated diagram — A diagram of a database or spreadsheet with labels and notes on its parts, such as tables, fields, data types, cells, formulas and validation, explaining what each part does.

Section D: Fill in the Blanks

Field: DateOfBirth
Data type: Date/time

Cell D2 note: =SUM(B2:C2) adds the marks

Validation: Range check keeps Mark 0 to 100

Label: StudentID = primary key (unique)

F2: =IF(E2>=50,"Pass","Fail")
Note: tests if the mark reaches 50

Section E: Spot the Error

B — The note says Age is a whole number, so the field data type should be Integer, not Text.

D — The annotation says D2 is price x quantity, so the formula must multiply: =B2*C2, not add.

B — The note says 101 is rejected, so the validation range must end at 100, not 1000.

A — Orders is the label for the whole table that holds the fields, so it should say Table: Orders, not Cell.

D — The note says D1 is the mean of the marks, so the formula should be =AVERAGE(B1:C1), not SUM.