Office Administration  ·  Level 5
Ict Skills
Chapter 3: Manage Data and Information
📚 10 Topics
⚑ What you will be able to do

By the end of this chapter, you will be able to:

  • Explain the key concepts of database management systems using the relational database model.
  • Install a relational database correctly by following your computer’s operating system guidelines.
  • Identify the main components of a relational database environment accurately.
  • Describe how relational database functions work using database management software.
  • Open a new database properly using MS-Access.
  • Recognize and use relational database objects like tables, queries, relationships, and reports correctly.
  • Print forms and reports accurately using database management software.
  • Use office internet services and perform internet searches safely and effectively to support your job tasks.
  • Download digital content from the internet safely, following workplace rules.

These skills will help you manage data confidently and efficiently, making you a valuable asset in any modern workplace.

Compiled by: Martin Munene

Managing data and information is a critical skill for office administration professionals in Kenya, where organizations increasingly rely on digital communication and information sharing to enhance productivity. Effective handling of data ensures that decisions are based on accurate and timely information, while efficient communication platforms support collaboration across departments and external partners. This chapter explores the foundational concepts of data and information, followed by an examination of popular communication tools widely used in Kenyan offices to manage, share, and interact with data effectively.

3.1 Meaning of Data and information

Data and information are words used every day in an office, but they mean different things. Data are raw facts and figures that have been recorded but not yet organised or interpreted: names, dates, amounts, quantities, ticks on a form or answers in a survey. Information is data that has been processed (sorted, calculated, summarised, arranged) so that it has meaning and can be used to make a decision. For example, the times at which each member of staff signed the attendance register are data; a monthly summary showing which departments had late arrivals and how often is information.

Characteristics of data

  • Raw: collected but not yet processed or organised.
  • Factual: records what was observed or entered, without interpretation.
  • Quantitative or qualitative: numbers (sales figures, hours) or descriptions (customer comments, colours).
  • Has little meaning alone: a figure such as 45 means nothing until we know what it counts.
  • Can come in large volumes: from forms, transactions, emails and systems.

Characteristics of good information

  • Accurate: free of errors, so decisions based on it are sound.
  • Relevant: suits the purpose and the person using it.
  • Timely: available when the decision is to be made.
  • Complete: contains everything needed, without gaps.
  • Clear and concise: easy to understand, without unnecessary detail.
  • Reliable: from a trustworthy source and correctly processed.

From data to information

  1. Collection: data is gathered from forms, registers, emails, receipts or systems.
  2. Input: it is entered into a computer, for example typed into a spreadsheet.
  3. Processing: it is sorted, classified, calculated and summarised.
  4. Output: the results are presented as reports, tables or charts.
  5. Interpretation: the reader gives the results meaning and uses them.
  6. Distribution and storage: the information is shared with those who need it and stored for later reference.
Data Information produced from it
Each day's petty cash vouchers Monthly petty cash summary by type of expense
Visitors' names and times in the visitors' book Weekly report of visitor numbers and busiest times
Individual stationery requisitions Quarterly stationery use per department
Answers in a customer feedback form Percentage of satisfied customers and main complaints

How offices use data and information, and why it matters, is covered under Importance and Uses of data and information.

Practice Questions

  1. Explain the difference between data and information, providing examples relevant to an office administration setting. (10 marks)
  2. Describe five characteristics of data and explain how each affects data handling in an office environment. (10 marks)
  3. Outline the process of transforming data into information and discuss its significance in decision-making. (10 marks)
The rest of this chapter
🔒

Create a free account to open more of this chapter.

Free: practical guides, quick cards, workplace scenarios and more.

Create a free account
🔒3.2 Importance and Uses of data and information

In the office administration profession within Kenya, managing data and information effectively is crucial for organizational success. Data and information serve as the backbone for decision-making, enhancing operational efficiency, and facilitating communicat…

🔒3.3 Types of internet services

In the context of office administration in Kenya, understanding the various types of internet services is essential for efficient communication, data management, and business operations. Internet services provide diverse functionalities ranging from communicat…

🔒3.4 Types of Internet Access Applications

Internet access applications are essential tools that allow office administrators in Kenya to connect to the internet and perform a wide range of tasks such as communication, research, data management, and cloud services. Selecting the appropriate internet acc…

🔒3.5 Web Browsing Concepts

Web browsing is a fundamental skill for office administrators who need to access online information, services, and communication platforms efficiently and safely. Understanding the core concepts behind web browsing, including how browsers work and the importan…

🔒3.6 Web Browsing

In office administration, especially within Kenyan institutions such as county government offices or banks, effective web browsing is essential for accessing information, conducting research, and communicating with stakeholders. Web browsers serve as the gatew…

🔒3.7 Web Based Information

The proliferation of internet access in Kenya has transformed how office administration professionals manage data and information. Web-based information is crucial in daily office tasks such as communication, research, and decision-making. Understanding how to…

🔒3.8 Downloads Management

Downloading is copying a file from the internet (a website, an email or a cloud service) to the computer or phone being used. Office staff download forms, reports, templates, software updates, pictures and attachments every day. Downloads management means cont…

🔒3.9 Performing Digital Data Backup (Online and Offline)

In the Kenyan office administration environment, managing data securely and ensuring its availability is critical for operational continuity. Digital data backup protects against accidental loss, hardware failure, cyber threats, and natural disasters. Both onl…

🔒3.10 Emerging Issues in Internet

The internet remains a vital tool for office administration in Kenya, enabling communication, data management, and service delivery. However, the evolving digital landscape presents new challenges and trends that office administrators must understand to mainta…

Chapter Summary

This chapter explored the fundamental concepts of data and information, clarifying their meanings and highlighting the importance and diverse uses of data in various contexts. It examined the different types of internet services available, including communication, information retrieval, file transfer, and web services, as well as specialized functions like automatic network address configuration, newsgroups, and e-commerce platforms. Various internet access applications were discussed, emphasizing how they enable users to connect and interact with online resources. The chapter then introduced key web browsing concepts, addressing both the technical aspects and the critical importance of security and safety while navigating the internet. Practical guidance on using web browsers was provided, covering tools, settings, cache and cookie management, bookmarks, and generating web outputs. The management of web-based information was analyzed with a focus on effective search techniques, critical evaluation skills, and compliance with copyright and data protection laws. Attention was given to downloads management and strategies for performing digital data backup both online and offline. Finally, emerging internet issues were considered, including popular communication platforms and best practices for searching and using web content effectively.

Self-Assessment

🔒 PDFDownload this self-assessment, with answers

A. Written Assessment

  1. Define the difference between data and information in the context of office administration. (3 marks)
  2. List and explain three types of internet services used in office communication. (6 marks)
🔒20 more in this section.

Chapter Examination Questions

🔒 PDFDownload these examination questions, with worked answers

SECTION A (40 Marks) - Answer ALL Questions

  1. Explain the difference between data and information in the context of an office administration environment such as a county government office. (4 marks)
  2. Identify and describe four uses of data and information in managing office records at a SACCO. (4 marks)
🔒18 more in this section.

Chapter Practical Activities

Practical 1: Differentiate Data and Information with Examples and Uses

Office Administration · Level 5
Ict Skills
PRACTICAL ASSESSMENT
TIME: 4 HOURS
⬇ PDFCandidate Instructions (Candidate Tool)

Type: Individual

INSTRUCTIONS TO CANDIDATE:
1.  You are required to perform the following task:
i.  Prepare a classification report differentiating data and information using provided samples, including their meanings, importance, and uses on two A4 pages.
2.  You have been provided with the following resources for the practical task:
Tools & EquipmentMaterials
PenSample raw data sets printed on A4 sheets
NotebookSample processed information reports printed on A4 sheets
⬇ PDFResources Required (Cutting List)
S/NItemQuantity
1Sample raw data sets printed on A4 sheets3 Sheets per Candidate
2Sample processed information reports printed on A4 sheets2 Sheets per Candidate
3Pen1 Pc per Candidate
4Notebook1 Pc per Candidate
⬇ PDFAssessor Guide
Items to be EvaluatedMarks AvailableMarks ObtainedComments
TASK 1: Explanation of Data and Information
Candidate defines data correctly
(Award 5 marks for accurate definition, 0 if incorrect)
5
Candidate defines information correctly
(Award 5 marks for accurate definition, 0 if incorrect)
5
Candidate explains the difference between data and information
(Award up to 10 marks for clear, correct differentiation)
10
Candidate identifies and classifies examples correctly as data or information
(Award 2 marks per correct classification up to 10 marks)
10
Candidate explains the importance of data and information
(Award 5 marks for clear explanation, 0 if missing or incorrect)
5
Candidate explains uses of data and information in organizations
(Award 5 marks for relevant uses, 0 if missing or incorrect)
5
Sub-Total40
PRODUCT CHECKLIST
Report is well structured, legible, and presented on two A4 pages
(Award 10 marks for neat, complete, and organized report)
10
Report includes correct examples matching definitions
(Award 10 marks for all examples matching data or information correctly)
10
Report contains no spelling or grammatical errors affecting clarity
(Award 10 marks for minimal or no errors)
10
Sub-Total30
GRAND TOTAL70
ASSESSMENT OUTCOME:   ☐ Competent    ☐ Not Yet Competent (competent if at least 50%)

Practical 2: Use of Internet Communication Services for Business Communication

Office Administration · Level 5
Ict Skills
PRACTICAL ASSESSMENT
TIME: 4 HOURS
⬇ PDFCandidate Instructions (Candidate Tool)

Type: Individual

INSTRUCTIONS TO CANDIDATE:
1.  You are required to perform the following task:
i.  Compose and send a formal email of 250-300 words, conduct a 5-minute chat conversation, and make a 3-minute video call as per the scenario instructions.
2.  You have been provided with the following resources for the practical task:
Tools & EquipmentMaterials
Computer with internet accessEmail draft content
Email accountChat conversation script
Instant messaging/chat applicationVideo call agenda
Video calling software
Telephone message pad
Pen
⬇ PDFResources Required (Cutting List)
S/NItemQuantity
1Computer with internet access1 Pc per Candidate
2Email account (e.g. Gmail or Outlook)1 Account per Candidate
3Instant messaging/chat application (e.g. WhatsApp Web, Microsoft Teams)1 Access per Candidate
4Video calling software (e.g. Zoom, Google Meet)1 Access per Candidate
5Telephone message pad and pen1 Pad and 1 Pen per Candidate
⬇ PDFAssessor Guide
Items to be EvaluatedMarks AvailableMarks ObtainedComments
TASK 1: Email Communication
Opened the email application and logged in successfully
(Award 2 marks for successful login, zero if failed)
2
Composed a formal email with correct recipient address
(Award 2 marks for correct recipient, 2 marks for formal tone)
4
Included subject line and appropriate greeting
(Award 1 mark each for subject line and greeting)
2
Email body is clear, concise, and between 250-300 words
(Award 4 marks for clarity, conciseness, and word count)
4
Used correct spelling and grammar throughout
(Award 3 marks for minimal or no errors)
3
Attached a file as instructed (e.g. company brochure PDF)
(Award 2 marks if attachment included correctly)
2
Sent the email successfully
(Award 3 marks for successful sending)
3
Sub-Total20
TASK 2: Chat Communication
Opened chat application and logged in
(Award 2 marks for successful login)
2
Initiated chat with assigned contact
(Award 3 marks for correct contact initiation)
3
Conducted a 5-minute chat maintaining professional language
(Award 5 marks for professionalism and duration)
5
Shared a link or file during the chat as instructed
(Award 3 marks for correct sharing)
3
Closed the chat session properly
(Award 2 marks for proper closure)
2
Sub-Total15
TASK 3: Video Call Communication
Opened video calling software and logged in
(Award 2 marks for successful login)
2
Dialed the correct contact and established connection
(Award 3 marks for correct call setup)
3
Introduced self and stated purpose of call clearly
(Award 3 marks for clear introduction and purpose)
3
Conducted a 3-minute video call maintaining professional conduct
(Award 5 marks for professionalism and call duration)
5
Ended the call politely and closed the application
(Award 2 marks for polite closure and proper exit)
2
Sub-Total15
TASK 4: Telephone Message Handling
Answered incoming call promptly with appropriate greeting
(Award 3 marks for prompt and correct greeting)
3
Identified self and department correctly
(Award 2 marks for correct identification)
2
Informed caller of executive’s absence and gave options
(Award 3 marks for clear information and options)
3
Recorded message accurately on telephone message pad
(Award 4 marks for accurate message recording)
4
Ended call politely and forwarded message to executive
(Award 3 marks for polite ending and forwarding)
3
Sub-Total15
PRODUCT CHECKLIST
Email sent with correct format, content length, attachment, and no errors
(Award up to 10 marks for email completeness and correctness)
10
Chat conversation logged with professional language and shared file/link
(Award up to 8 marks for chat professionalism and content)
8
Video call conducted professionally with clear introduction and proper closure
(Award up to 7 marks for video call quality and conduct)
7
Telephone message accurately recorded and forwarded
(Award up to 5 marks for message accuracy and handling)
5
Sub-Total30
GRAND TOTAL95
ASSESSMENT OUTCOME:   ☐ Competent    ☐ Not Yet Competent (competent if at least 50%)
🔒

Free: practical guides, quick cards, workplace scenarios and more.

Create a free account
🔒Perform effective online searches using information retrieval servicesPractical 3
🔒Transfer files over the internet using FTP protocolPractical 4
🔒Access and Navigate Web Services on the World Wide WebPractical 5
🔒Configure a device to obtain IP address automatically using DHCPPractical 6
🔒Participate in an Online Newsgroup DiscussionPractical 7
🔒Conduct an ecommerce transaction for selling a productPractical 8
🔒Install and Configure Internet Access Applications on a PCPractical 9
🔒Configure web browser settings and manage bookmarks for secure browsingPractical 10
🔒Evaluate the authenticity and copyright compliance of web-based informationPractical 11
🔒Manage Downloads and Perform Digital Data BackupPractical 12
🔒Discuss and demonstrate awareness of emerging internet challengesPractical 13
🔒Schedule, Join and Participate in Online Meetings Using Google Meet, Microsoft Teams, Zoom, and SkypePractical 14
🔒Search, Access and Manage Multimedia Content on WebsitesPractical 15
Flashcards 20 cards Study deck ▾
Question
1

↻ Tap card to reveal answer
🔒

18 more in this section.

Create a free account
Test Yourself 16 questions Start quiz ▾
0%
0 / 2
🔒

14 more in this section.

Create a free account
Am I competent?

At the start of this chapter we promised you would be able to:

  • Explain the key concepts of database management systems using the relational database model.
  • Install a relational database correctly by following your computer’s operating system guidelines.
  • Identify the main components of a relational database environment accurately.
  • Describe how relational database functions work using database management software.
  • Open a new database properly using MS-Access.
  • Recognize and use relational database objects like tables, queries, relationships, and reports correctly.
  • Print forms and reports accurately using database management software.
  • Use office internet services and perform internet searches safely and effectively to support your job tasks.
  • Download digital content from the internet safely, following workplace rules.

Tick each one you can genuinely do.

So, are you there yet?

You're competent when you can confidently do 50% or more of what this chapter promised.

Sign in to record how you're doing.