Form 1 Revision Test #02

 Section A: Multiple-Choice Questions (MCQs)

Choose the correct answer for each question.

1. Which of the following is an example of a real-world application of a spreadsheet?
   A) Writing a novel
   B) Managing a budget
   C) Creating a slideshow
   D) Sending an email
2. What is the primary purpose of a digital portfolio?
   A) To store digital books
   B) To showcase personal and professional achievements
   C) To play online games
   D) To download software
3. Which of the following best describes ethical literacy in ICT?
   A) Understanding how to program software
   B) Knowing how to use a word processor
   C) Making responsible and informed decisions in digital environments
   D) Installing antivirus software
4. Which tool would be most appropriate for creating a professional presentation?
   A) Spreadsheet software
   B) Word processor
   C) Presentation software
   D) Database software
5. A digital divide refers to:
   A) The difference between analog and digital signals
   B) The gap between people with and without access to digital technology
   C) The connection speed of the internet
   D) The separation of different file types on a computer
6. Which of the following is NOT a component of a computer system?
   A) CPU
   B) Operating System
   C) Keyboard
   D) Wi-Fi Signal
7. A word processor is commonly used to:
   A) Edit and format text-based documents
   B) Create and analyze data in tables
   C) Edit high-resolution images
   D) Program a website
8. In digital literacy, "phishing" refers to:
   A) A method of illegally accessing computer networks
   B) The act of sending fraudulent messages to steal sensitive data
   C) A technique used for data encryption
   D) A strategy for securing wireless networks
9. The primary role of Information and Communication Technology (ICT) in education is to:
   A) Replace teachers in the classroom
   B) Provide online gaming platforms
   C) Enhance learning and improve accessibility to educational materials
   D) Limit student access to the internet
10. What is the key difference between ICT and IT?
    A) ICT focuses on communication while IT is about hardware only
    B) ICT includes IT but also covers communication technologies
    C) IT is a part of ICT but focuses only on software
    D) ICT and IT mean the same thing

 Section B: Matching Question

Match the ICT term in Column A with its correct description in Column B.

Column A	Column B
1. Digital Portfolio	A. Used to create and deliver presentations
2. Spreadsheet Software	B. A structured collection of personal work and achievements
3. Digital Divide	C. Application for managing and analyzing numerical data
4. Ethical Literacy	D. Knowing how to act responsibly online
5. Presentation Tools	E. The gap between those with and without technology access

 

Section C: Scenario-Based Question

Read the scenario below and answer the questions that follow.

Scenario:
Mwansa is a small business owner who recently adopted ICT tools to improve her business. She uses a spreadsheet to track sales, a word processor to write business reports, presentation software to pitch ideas, and a digital portfolio to showcase her work online. However, she faces challenges with data security, ethical concerns, and limited access to digital skills training.

Questions:

(a) How can Mwansa use a spreadsheet efficiently to track sales and make informed business decisions?

(b) What features of a word processor can help Mwansa create professional business reports?

(c) Suggest two advantages of using presentation tools for business pitching.

(d) Explain how the digital divide might impact Mwansa’s ability to expand her business online.

(e) What ethical literacy principles should Mwansa follow when handling customer data?

(f) Provide one ICT training resource Mwansa could use to improve her digital literacy.

 

Answer Key

Section A: Multiple-Choice Questions (MCQs) – Answers

1. B) Managing a budget
2. B) To showcase personal and professional achievements
3. C) Making responsible and informed decisions in digital environments
4. C) Presentation software
5. B) The gap between people with and without access to digital technology
6. D) Wi-Fi Signal
7. A) Edit and format text-based documents
8. B) The act of sending fraudulent messages to steal sensitive data
9. C) Enhance learning and improve accessibility to educational materials
10. B) ICT includes IT but also covers communication technologies

  Section B: Matching Question – Answers

Column A	Column B
1. Digital Portfolio	B. A structured collection of personal work and achievements
2. Spreadsheet Software	C. Application for managing and analyzing numerical data
3. Digital Divide	E. The gap between those with and without technology access
4. Ethical Literacy	D. Knowing how to act responsibly online
5. Presentation Tools	A. Used to create and deliver presentations

---

Section C: Scenario-Based Question – Answers

(a) How can Mwansa use a spreadsheet efficiently to track sales and make informed business decisions?

• Mwansa can enter daily sales data into a spreadsheet, use formulas for calculations, and generate charts to visualize trends.
• She can apply filters to analyze specific sales periods and use conditional formatting to highlight high or low sales.

(b) What features of a word processor can help Mwansa create professional business reports?

• Features like templates, tables, headers and footers, and bullet points can improve readability.
• Spell check and grammar tools ensure error-free documents.
• Page numbering and table of contents improve organization.

(c) Suggest two advantages of using presentation tools for business pitching.

1. Visual impact – Presentation slides with images, charts, and animations make ideas more engaging.
2. Structured communication – Helps Mwansa present ideas logically, keeping the audience focused.

(d) Explain how the digital divide might impact Mwansa’s ability to expand her business online.

• Limited internet access in her area may prevent her from reaching a wider market.
• Lack of digital skills training could make it difficult for her to effectively use e-commerce and online marketing tools.

(e) What ethical literacy principles should Mwansa follow when handling customer data?

• Confidentiality – Protect customer data from unauthorized access.
• Transparency – Clearly inform customers about data usage.
• Data security – Use strong passwords and encryption to prevent breaches.
• Consent – Obtain permission before collecting or sharing personal information.

(f) Provide one ICT training resource Mwansa could use to improve her digital literacy.

• Online platforms like Coursera, Udemy, or YouTube offer free and paid ICT courses tailored to business needs.
• Local ICT training centers or workshops can provide hands-on learning.