logo

Cambridge IGCSE Information and Communication Technology revision notes

Present data Revision Notes

Cambridge IGCSE revision notes for Present data.

At a glance

revision notes

Resource type

Topic

Present data

CambridgeIGCSEInformation and Communication TechnologyDatabases

Complete revision guide

Effective Presentation of Data in Database Reports

This note explains how to present data effectively in database reports by including all necessary data and labels, using appropriate headers and footers, setting report titles, choosing suitable output formats, aligning data correctly, and formatting numeric data for clarity and professionalism.

Syllabus source

Section 3, Topic 18.3, page 31, objective 18.3.1

Open source document ↗

What you should be able to do

  • ✓Understand the importance of including all necessary data and labels in reports.
  • ✓Learn how to use headers and footers effectively in database reports.
  • ✓Distinguish between tabular and columnar data presentation styles.
  • ✓Apply correct alignment techniques for text and numeric data.
  • ✓Format numeric data to display decimal places, currency symbols, and percentages appropriately.
1

Including Complete Data and Labels in Reports

A report must contain all relevant data and clear labels to ensure the reader understands the information presented. Omitting data or labels can cause confusion or misinterpretation. For example, a sales report should include product names, quantities sold, and sales figures, each clearly labelled.

Labels act as headings or descriptors for data columns or fields, guiding the reader through the report. Always double-check that every data field has an appropriate label and that no data is missing before finalising the report.

  • Verify all required data fields are present.
  • Ensure each data column or field has a clear, descriptive label.
  • Avoid leaving any data unlabeled or ambiguous.
2

Using Headers and Footers in Database Reports

Headers and footers organise report content and provide contextual information on each page. There are four common types: report header, report footer, page header, and page footer.

The report header appears once at the beginning of the report and often contains the report title and date. The report footer appears once at the end and can include summary information or disclaimers.

Page headers and footers appear on every page, typically showing page numbers, the report title, or the date. Using these consistently helps readers navigate multi-page reports easily.

  • Use report header for the main title and introductory information.
  • Use report footer for summaries or notes at the end.
  • Include page headers and footers for page numbers and repeated titles.
  • Maintain consistent formatting for all headers and footers.
3

Choosing Between Tabular and Columnar Data Presentation

Data can be displayed in different formats depending on the report’s purpose and the nature of the data. The two common styles are tabular and columnar.

Tabular style arranges data in rows and columns, similar to a spreadsheet. This is effective for comparing multiple records across several fields. For example, a student grades report listing names, subjects, and marks in a table.

Columnar style presents data vertically, with each record’s fields stacked one below the other, often used for detailed reports on individual records. For example, a customer profile report showing name, address, and purchase history in separate lines per customer.

  • Use tabular style for summarising multiple records.
  • Use columnar style for detailed, record-by-record reports.
  • Select the style that improves readability and suits the report’s purpose.
4

Aligning Data and Labels Correctly

Proper alignment improves readability and professionalism. Text data and labels are usually left-aligned to maintain a clean left margin.

Numeric data should be right-aligned so that digits line up vertically, making it easier to compare values. For numbers with decimals, decimal alignment is preferred, where decimal points line up vertically.

For example, in a financial report, aligning currency amounts by the decimal point helps readers quickly scan and compare figures.

  • Left-align text and labels for clarity.
  • Right-align numeric data to line up digits.
  • Use decimal alignment for numbers with decimal places.
  • Check alignment consistency throughout the report.
5

Formatting Numeric Data for Clarity

Numeric data should be formatted to enhance understanding. This includes specifying the number of decimal places, adding currency symbols, and formatting percentages.

For example, monetary values should display the currency symbol (£, $, €) and two decimal places for pence or cents (e.g., £123.45). Percentages should include the % symbol and be rounded appropriately (e.g., 12.5%).

Consistent formatting avoids confusion and presents data professionally. Most database software allows setting these formats in the report design stage.

  • Specify decimal places to suit the data type.
  • Include currency symbols for monetary values.
  • Format percentages with the % symbol and suitable precision.
  • Apply consistent numeric formatting throughout the report.

At-a-glance summary

Comparison table

StepDetailExampleExam Use
Include all data and labelsEnsure no data or labels are missingSales report includes product names and sales figuresMarks awarded for complete, labelled data
Use headers and footersAdd report/page headers and footers for contextReport header with title; page footer with page numberMarks for correct use of headers/footers
Choose data layoutSelect tabular or columnar styleTabular for multiple records; columnar for detailed recordExplain choice and apply correctly
Align dataLeft-align text; right-align numbers; decimal-align decimalsRight-align currency amounts by decimal pointMarks for correct alignment techniques
Format numeric dataSet decimal places, currency symbols, percentages£123.45 with two decimals; 12.5% with % symbolMarks for consistent and correct numeric formatting

Active recall

Quick check

1. Why should numeric data be right-aligned or decimal-aligned in reports?

Right or decimal alignment lines up digits vertically, making it easier to compare numbers quickly and accurately.

2. What is the purpose of a report header?

A report header appears once at the start and provides the report title and context to the reader.

3. When would you choose a columnar layout over a tabular layout?

When presenting detailed information about individual records rather than summarising multiple records.

4. How do you format currency values in a report?

Include the currency symbol and specify two decimal places to show pence or cents clearly.

Related topics

Study nearby topics next

Revision hubs

Keep studying from the right hub