Creating Reports: Sorting, Grouping and Summary
Master the art of transforming raw data into professional, insightful reports — a key CSEC IT skill!
What Makes a "Good" Report?
The Purpose
A Report is a formatted, printed document that presents data from your database in a clear, professional way. While Tables store raw data and Queries filter specific information, Reports organize everything into a presentation-ready format that managers, principals, or customers can understand at a glance.
The Three Pillars of Great Reports
- Clarity: Is the data in logical order? (This is what Sorting does)
- Organization: Is related data grouped together? (This is what Grouping does)
- Insight: Does the report show totals, averages, or other meaning? (This is what Summary does)
Click "Reportify" to transform messy sales data into an organized report!
Sorting: Bringing Order to Chaos
The Direction
Ascending (A-Z, 1-10): Sorts from smallest to largest, or A to Z. Best for creating alphabetical lists of students or employees.
Descending (Z-A, 10-1): Sorts from largest to smallest, or Z to A. Perfect for showing the highest test scores at the top!
Multi-Level Sorting
When you have records that might have the same value (like two students named "Williams"), you can sort by multiple fields. For example: Sort by Last Name, then by First Name — this ensures all "Williams" are grouped together but listed alphabetically by first name.
Click on column headers to toggle between Ascending and Descending order!
| Student Name | Math Score | English Score |
|---|---|---|
| Jordan Williams | 85 | 92 |
| Ashley Brown | 78 | 88 |
| Marcus Johnson | 95 | 85 |
| Sarah Davis | 82 | 90 |
| Mike Wilson | 88 | 75 |
Grouping: Organizing by Category
The Concept
Grouping places records into "sections" based on a shared value. Imagine a school report grouped by "Form" — all Form 3 students appear together, followed by Form 4, then Form 5. This makes it easy for a principal to quickly find the information they need.
Group Headers
When you group data, a Group Header appears at the top of each section showing the category name (like "Form 3" or "North Region"). This provides visual hierarchy and helps readers navigate the report quickly.
Visual Hierarchy
Grouped reports follow a clear visual pattern: Group Header → Records in that Group → Group Footer (optional totals). This structure is much easier to read than a long, unbroken list of records.
Click "Group by Category" to organize these mixed-up library books!
Summary: Adding Meaning to Numbers
What is a Summary?
A Summary (or aggregate) uses mathematical functions to describe a group of data rather than showing individual records. Instead of listing every sale, you show the Total Sales. Instead of every test score, you show the Average Grade.
Key Functions for CSEC
- SUM: Adds up all values (e.g., Total Sales = SUM of all transactions)
- AVG: Calculates the mean (e.g., Average Grade = SUM of scores ÷ COUNT of students)
- COUNT: Counts how many records exist in a group
- MIN/MAX: Finds the smallest or largest value
Click different aggregate functions to see the Group Footer update!
Report Sections: Where Does Data Go?
Report Header/Footer
Appears once at the very beginning/end of the entire document. Use for the report title, date, and Grand Totals that apply to all data.
Page Header/Footer
Appears at the top/bottom of every page. Perfect for column names (like field headers) and page numbers.
Group Header/Footer
Appears at the start/end of every category when you group data. Use for the group name (e.g., "Form 3") and Sub-totals for that group.
Detail Section
Where the individual records appear. This is the main body of your report showing one record per line.
Drag each label to the correct section of the report!
CSEC SBA Prep: The Summary Screenshot
Evidence of Learning
Showing subtotals and grand totals in your reports is a high-scoring feature for your SBA because it demonstrates you understand how to use aggregate functions and group data meaningfully.
Where to Place Totals
❌ Wrong Placement
Detail Section:
If you put "Grand Total" here, it will repeat on every single line!
✅ Correct Placement
Report Footer:
Grand Total appears once at the end — exactly where it should be!
Pre-Submission Checklist
Knowledge Check: The Report Architect
The Logic Quiz
Test your understanding of where to place summaries!
Answer quickly! You have 20 seconds per question.
Quiz Complete!
Design Challenge
Scenario: Store Inventory Report
You need to create a report showing all products in a store. The manager wants to see products organized by category (Electronics, Clothing, Food), with the total value of inventory per category.
Your task: What would you use for sorting and grouping?
Answers: Sort by Product Name (A-Z), Group by Category
Sorting
Arranging data in ascending or descending order based on one or more fields
Grouping
Organizing records into categories based on shared field values
Summary/Aggregate
Calculations (SUM, AVG, COUNT) that describe a group of data
Report Sections
Different areas (Header, Detail, Footer) where specific content belongs