Presenting data to the user

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. A student wants to compare the exact marks of 8 classmates in three subjects. Which presentation suits this task best?

A A table, because exact values can be read across rows and columns

B A pie chart, because it always shows exact marks best

2. A manager wants to see at a glance how monthly sales changed over a year. Which presentation suits this task best?

A A long list of sales figures in plain text

B A line chart showing sales for each month

3. A user is entering a new customer's name, phone number and address. Which presentation suits this task best?

A A bar chart with a bar for each field

B A form with a labelled input control for each field

4. Which statement about showing only the data a user needs is correct?

A A canteen worker needs to see the item, quantity and pickup time, not the student's home address

B A canteen worker should see every field stored about the student so nothing is missed

5. Which report layout is better for a term summary sent to parents?

A A clear title, grouped sections with headings, and a summary at the top

B All the raw data dumped in one block with no headings

Match the Pairs

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

Left column		Right column
1SELECT name, price FROM products;		APresents data as a table with column headings so exact values are easy to look up
2<table><tr><th>Day</th><th>Rain</th></tr></table>		BA chart is a poor choice when the user needs to read exact values for many items; a table suits this task better
3A chart suits a task where the user wants to see a trend or compare values at a glance		Cprint report: heading, rows sorted by house, total points
4A report groups and orders selected data under headings and totals so it can be read and acted on		Ddisplay line chart of Max by Day
5SELECT * FROM students; -- parent only needs name and points		EShows only the two columns the user needs, rather than every column in the table
6display pie chart of 40 exact test marks to teacher		FSelects every column, so the user sees extra data they do not need, including unrelated fields

Definitions

data presentation

Fill in the Blanks

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

SELECT _________, points FROM students;

SELECT name, stock FROM products _____ stock = 0;

SELECT name, price FROM products ORDER BY price ____;

<_____> <tr><th>Name</th><th>Points</th></tr> </table>

if task is "show trend over time" then display _____ end if

Spot the Error

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

Question 1

A input task

B if task = 'lookup' then

C show line chart of sales

D else

E show table of sales

Question 2

A print 'Term Report'

B print 'Name Maths English'

C for each s print s.average

D print 'Class average: ', avg

Question 3

A houses ← ['Red','Blue']

B input task

C show pie chart of houses

Question 4

A input task

B if task = 'add' then

C show form with blank fields

D else if task = 'add' then

E show table of records

Question 5

A task ← 'compare'

B if task = 'compare' then

C show form of sales

D else

E show table of sales

Answer Key

Presenting data to the user

Section A: Quick Questions

A — A table, because exact values can be read across rows and columns

B — A line chart showing sales for each month

B — A form with a labelled input control for each field

A — A canteen worker needs to see the item, quantity and pickup time, not the student's home address

A — A clear title, grouped sections with headings, and a summary at the top

Section B: Match the Pairs

SELECT name, price FROM products; → Shows only the two columns the user needs, rather than every column in the table

<table><tr><th>Day</th><th>Rain</th></tr></table> → Presents data as a table with column headings so exact values are easy to look up

A chart suits a task where the user wants to see a trend or compare values at a glance → display line chart of Max by Day

A report groups and orders selected data under headings and totals so it can be read and acted on → print report: heading, rows sorted by house, total points

SELECT * FROM students; -- parent only needs name and points → Selects every column, so the user sees extra data they do not need, including unrelated fields

display pie chart of 40 exact test marks to teacher → A chart is a poor choice when the user needs to read exact values for many items; a table suits this task better

Section C: Definitions

data presentation — Showing data to users as a table, list, form, report or chart, chosen to suit the data and the user's task, and showing only the data they need.

Section D: Fill in the Blanks

SELECT firstName, points FROM students;

SELECT name, stock FROM products
WHERE stock = 0;

SELECT name, price FROM products
ORDER BY price DESC;

<table>
  <tr><th>Name</th><th>Points</th></tr>
</table>

if task is "show trend over time" then
  display chart
end if

Section E: Spot the Error

B — A line chart suits a trend over time, so the condition should be 'trend'. A lookup task needs exact values, which a table shows better, so it belongs in the else branch.

C — The column headings are Name, Maths and English, but the loop prints only an average. Each row must match the headings, so it should print each student's row of marks.

C — The data is just a few names with no numbers to compare. A simple list is the right way to present it, so line 3 should show a list, not a pie chart.

D — The second condition repeats 'add', so the table can never be shown. It should be 'browse', because a table suits viewing many records.

C — A form is used to enter data, not to display it. Comparing sales across categories is best shown with a bar chart.