Writing an IPO chart for a spreadsheet or database task

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. A student plans to find the average of five test scores in a spreadsheet. Which entry belongs in the Input column of the IPO chart?

A The five test scores typed into cells

B The average mark shown at the bottom

2. For the task 'work out the average of the scores', which entry is the Process?

A Add the scores and divide by how many there are, e.g. =AVERAGE(B2:B6)

B Type the scores into column B

3. A database table of students is searched to find everyone in Year 11. Where does 'Run a query to select records where Year = 11' go in the IPO chart?

A Output

B Process

4. Which is the best Output for a query that finds all students with a mark above 80?

A A list of the matching student records

B The full table of marks before searching

5. A student is planning a column chart of monthly sales. What goes in the Output column?

A The monthly sales figures typed into the sheet

B A column chart showing sales for each month

Match the Pairs

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

Left column		Right column
1Input: Test scores in B2:B11 \| Process: =AVERAGE(B2:B11) \| Output: Class average		AOutput: Column chart of sales for each month
2Input: Students table \| Process: SELECT * WHERE Year = 11 \| Output: List of Year 11 students		BInput: Monthly sales imported from sales.csv
3The Input column lists the data entered or imported into the task, not the calculation done on it		CThe Input and Process are swapped. The average is a calculation (Process) and the scores are the data entered (Input).
4The Output column states the result shown to the user, such as a chart		DThe Output repeats the Process instead of describing the result shown, such as a list of customers in A-Z order.
5Input: Average of the scores \| Process: Scores in B2:B11 \| Output: Class average		EAn IPO chart row for a spreadsheet task where entered scores are averaged to show one result
6Input: Customers table \| Process: Sort by surname \| Output: Sort by surname		FAn IPO chart row for a database task where a query filters a table and shows the matching records

Definitions

IPO chart

Fill in the Blanks

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

_____: test scores typed into B2:B11 Process: work out the average score Output: average shown in cell D2

Input: scores in B2:B11 Process: =_______(B2:B11) Output: mean mark shown in D2

Input: Students table Process: sort by score, highest first ______: ranked list shown on screen

Input: Students table with Score field Process: find rows where Score _ 80 Output: list of matching names

Input: monthly sales in B2:B13 Process: group sales by month Output: column _____ of sales by month

Spot the Error

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

Question 1

A Input: scores in B2:B11

B Process: =AVERAGE(B2:B11)

C Output: =AVERAGE(B2:B11)

Question 2

A Input: Students table

B Process: query Year = 11

C Process: sort Surname A to Z

D Output: import Students table

Question 3

A Input: column chart of sales

B Process: select A1:B7

C Output: column chart of sales

Question 4

A Output: Books table, 200 rows

B Process: query Genre = Fantasy

C Output: list of fantasy titles

Question 5

A Input: quiz marks, C2:C21

B Process: find the mean mark

C Process: =COUNT(C2:C21)

D Output: mean mark in E2

Answer Key

Writing an IPO chart for a spreadsheet or database task

Section A: Quick Questions

A — The five test scores typed into cells

A — Add the scores and divide by how many there are, e.g. =AVERAGE(B2:B6)

B — Process

A — A list of the matching student records

B — A column chart showing sales for each month

Section B: Match the Pairs

Input: Test scores in B2:B11 | Process: =AVERAGE(B2:B11) | Output: Class average → An IPO chart row for a spreadsheet task where entered scores are averaged to show one result

Input: Students table | Process: SELECT * WHERE Year = 11 | Output: List of Year 11 students → An IPO chart row for a database task where a query filters a table and shows the matching records

The Input column lists the data entered or imported into the task, not the calculation done on it → Input: Monthly sales imported from sales.csv

The Output column states the result shown to the user, such as a chart → Output: Column chart of sales for each month

Input: Average of the scores | Process: Scores in B2:B11 | Output: Class average → The Input and Process are swapped. The average is a calculation (Process) and the scores are the data entered (Input).

Input: Customers table | Process: Sort by surname | Output: Sort by surname → The Output repeats the Process instead of describing the result shown, such as a list of customers in A-Z order.

Section C: Definitions

IPO chart — A table that plans a data task: Input (data entered or imported), Process (calculation, sort or query done) and Output (result shown), e.g. scores in, average worked out, chart out.

Section D: Fill in the Blanks

Input: test scores typed into B2:B11
Process: work out the average score
Output: average shown in cell D2

Input: scores in B2:B11
Process: =AVERAGE(B2:B11)
Output: mean mark shown in D2

Input: Students table
Process: sort by score, highest first
Output: ranked list shown on screen

Input: Students table with Score field
Process: find rows where Score > 80
Output: list of matching names

Input: monthly sales in B2:B13
Process: group sales by month
Output: column chart of sales by month

Section E: Spot the Error

C — The Output row should say what result is shown, such as the average in D2. The formula is the calculation, so it belongs in the Process row.

D — Importing the Students table is data coming in, so it is an Input. The Output row should show the result, such as the list of Year 11 names.

A — A chart is the result shown, so it is an Output. The Input row should list the data entered, such as the monthly sales in B2:B7.

A — The Books table is the data imported or entered, so it is an Input. Line 1 should start with Input, not Output.

C — COUNT only counts how many cells hold numbers. To find the mean mark the Process should use =AVERAGE(C2:C21).