One set of facts, three readers
Oakfield Youth Club is made up. The data says Football has 4 members, and Chess and Art club have 3 each.
The manager wants to know where to spend money. A parent wants to know what is on. A volunteer wants a poster. The facts are the same, but each reader needs a different page.
By the end of this lesson
Note
I can choose a report, a chart or a presentation that suits the audience and the purpose.
Key words
| Word | What it means |
|---|---|
| Audience | the people who will read or watch |
| Purpose | the reason you are presenting |
| Report template | a ready-made layout you can change for a report |
| Chart | a picture of numbers, such as a bar chart |
| Presentation | slides or a talk that shows your findings |
The cells students fill in are left blank in this preview.
Starter: what you already know
Have a go
Starter: what you already know
4 questionsYour answers are marked here and are not kept. A college account keeps every student’s marks.
A report is a query made readable
A report shows the result of a query (a question you ask a table) in a clear layout. Most tools give you a report template, which is a ready-made layout. You then edit it.
Change the title. Choose the fields. Write plain headings. Sort the rows and group them. Remove what the reader does not need. You can change an output screen the same way.
Try it: a readable report
-- The manager report: members for each activity, most popular first.
SELECT activities.activity_name AS Activity,
activities.weekday AS Day,
COUNT(*) AS Members
FROM signups
JOIN activities ON signups.activity_id = activities.activity_id
GROUP BY activities.activity_id
ORDER BY Members DESC, Activity;
-- Change Members DESC to Members to put the smallest first.
Check
Have a go
Check
3 questionsYour answers are marked here and are not kept. A college account keeps every student’s marks.