lesson 7.3 - representing information (text, numbers, tables)
Representing information as text, numbers and tables. Explore how we structure data to make it useful. Perfect for BTEC DIT!
You've learned that 'data' needs 'context' to become 'information'. But what does that actually look like? This lesson, we'll explore the three main ways we package information for a business like Pedal Power Cycles: simple text, powerful numbers, and super-organised tables. It's time to build the filing cabinets for our data!
Learning Outcomes
The Building Blocks (Factual Knowledge)
The Connections and Theories (Conceptual Knowledge)
The Skills and Methods (Procedural Knowledge)
Recall the three main ways information is represented: text, numbers, and tables (C2.A2.1, C2.A2.2, C2.A2.3).
The Connections and Theories (Conceptual Knowledge)
Describe the characteristics and uses of each representation type.
Explain why choosing the correct representation method is important for data analysis.
The Skills and Methods (Procedural Knowledge)
Apply knowledge to categorise different pieces of information into their correct representation type.
Digital Skill Focus: This lesson, you will focus on entering data accurately into a pre-formatted digital table to organise information logically.
Structuring the Story: How We Represent Information
Last lesson, we learned that turning raw data into useful information is all about adding context and meaning. But how do we physically structure it? In computing, especially for a business like Pedal Power Cycles, we rely on three fundamental methods.
1. Text (Alphanumeric)
This is the most basic way to represent information. Text, also known as an alphanumeric string, is any combination of letters, numbers, and symbols.
Examples: A customer's name ("J. Smith"), a postcode ("B1 2JP"), a product code ("MP-500"), or an email address.
Key Feature: You cannot perform mathematical calculations on information stored as text. Even if you have the text "150", the computer sees it as a sequence of symbols ('1', '5', '0'), not the numerical value one hundred and fifty.
For Pedal Power Cycles, text will be used for customer names, product descriptions, and staff details.
2. Numbers
When we need to perform calculations, we must represent the information as a number. This tells the computer that the value can be used in arithmetic operations like addition, subtraction, multiplication, and division.
Examples: The quantity of bikes sold (e.g., 5), the price of an item (e.g., 499.99), or a percentage discount (e.g., 10%).
Key Feature: Numbers are essential for analysis. A business can only calculate total profit, average sales, or price increases if the values are stored as numbers.
Pedal Power Cycles will use numbers for all their financial data, sales quantities, and performance metrics.
3. Tables
A table is the most common and powerful way to structure related information. A table organises information into a grid of columns and rows. This structure is the foundation of all spreadsheet and database software.
Columns (Fields): Each column represents a specific attribute or characteristic. For example, 'Product Name', 'Price', 'Sale Date'.
Rows (Records): Each row represents a single, complete entry. For example, all the details for one specific sale would make up one row.
A table is brilliant because it combines text and numbers in a highly organised way, showing the relationship between them clearly. It's the perfect tool for turning a chaotic list of data into a structured block of information.
Turn to the person next to you and explain the difference between representing a price as text ('£99.99') versus as a number (99.99) in a spreadsheet. Why does this small difference matter so much for a business?
Task From Chaos to Columns: Organising Sales Data
A manager from Pedal Power Cycles has emailed you a list of the latest sales, but it's just a messy block of text. It's raw data, and not very useful! Your job is to bring order to this chaos by designing and creating a structured table to represent this information properly.
1
Get Organised!
First, create a document to work in.
Navigate to your Component_2 -> 01-PSA-Brief folder.
Create a new word processing document and name it Information Representation Task.docx.
2
Design Your Table
Read the 'Manager's Notes' below. Identify all the different pieces of information you have for each sale.
In your document, create a new, empty table.
Add a top row to your table and create a clear heading for each column (these are the 'fields'). Think about what information needs its own column.
3
Populate the Table
Now, carefully read through the notes again and transfer the details for each sale into your table. Every individual sale should be on its own row (a 'record').
Manager's Notes
Right, here are the latest sales. On 15/05/2024, Sarah sold 2 of the 'City-Rider' bikes (which have the code CR-002) for £450.50 each. Later that day, John sold one 'Mountain-Pro' bike (code MP-001) for £799.99. The next day, 16/05/2024, Sarah was busy again and sold 4 'Safety Helmets' (code ACC-010) at £35.00 each. Finally, on 17/05/2024, David sold another one of the 'Mountain-Pro' bikes (MP-001) for the usual price of £799.99.
Act as a data analyst. I have this list of sales: "On 15/05/2024, Sarah sold 2 of the 'City-Rider' bikes (CR-002) for £450.50 each. John sold one 'Mountain-Pro' (MP-001) for £799.99 on the same day." Design a table structure for me with clear column headings that could be used in a spreadsheet to organise this information. List the column headings and suggest a suitable data type for each (e.g., Text, Number, Date). Limit response to 100 words for a Key Stage 4 student. NO intro, NO outro, NO deviation from the topic, NO follow-up questions.
Outcome: A completed document containing a well-structured table that accurately organises the raw sales notes.
Hungry for more?
Real-World Tables: Find a table of information online, like a sports league table or a bus timetable. Identify what each row (record) represents and what each column (field) represents.
Data Types in Code: Research 'data types' in a programming language like Python. How are text (strings) and numbers (integers/floats) different in code?
Advanced Tables: Look up 'Relational Databases'. How do they use multiple tables that are linked together to organise information even more efficiently?
Application to the Component Sample PSA
The data files provided for Pedal Power Cycles in the real PSA will be in the form of spreadsheets, which are essentially large, structured tables. Understanding that a table is made of columns (fields) and rows (records) is fundamental. You will need to identify the correct fields to use in your formulas and functions in Task 2. The entire dashboard you build will be based on taking this tabular information and transforming it into visual charts and summaries to make it easy for managers to understand.
Out of Lesson Learning
⭐ Field Spotter
Look at the Pedal Power Cycles client brief again. Based on the description of their 'sales data' spreadsheet, list five different 'fields' (column headings) that you would expect to be in their table.
Look at the Pedal Power Cycles client brief again. Based on the description of their 'sales data' spreadsheet, list five different 'fields' (column headings) that you would expect to be in their table.
⭐⭐ Data Type Detective
For the five fields you listed in the task above, write down what data type each one should be (e.g., Text, Number, Date, Currency). For each one, write a short sentence to justify your choice.
For the five fields you listed in the task above, write down what data type each one should be (e.g., Text, Number, Date, Currency). For each one, write a short sentence to justify your choice.
⭐⭐⭐ Table Designer
The brief also mentions a separate file for staff information. Design a table for this data. Draw it out or write down the column headings for at least four appropriate fields that would be needed to store information about the staff members.
The brief also mentions a separate file for staff information. Design a table for this data. Draw it out or write down the column headings for at least four appropriate fields that would be needed to store information about the staff members.
Last modified: June 8th, 2026
