SS3 SECOND MOCK EXAMINATION
DIGITAL TECHNOLOGY PRACTICAL
Time Allowed: 2 Hours
Instruction:
1. Answer ALL questions.
2. Save your work in a folder named SS3_Mock_Practical_YourName.
3. Ensure all files are properly named as instructed.
4. Print your final outputs where necessary.
SECTION A – WORD PROCESSING (40 Marks)
Using a Word Processing Package such as Microsoft Word, type the following passage exactly as
shown.
Question 1
Create a document and save it as Digital_Skills.docx
Type the text below.
THE IMPORTANCE OF DIGITAL TECHNOLOGY IN MODERN EDUCATION
Digital technology has transformed the way students learn and teachers deliver lessons.
Computers, tablets and the internet have made information more accessible than ever before.
Students can now conduct research online, collaborate with classmates, and submit
assignments electronically.
In schools today, word processors help students prepare assignments and reports. Spreadsheet
programs assist in analyzing data and performing calculations, while presentation software
allows students to present their ideas clearly using slides, images and charts.
Learning digital skills prepares students for the modern workplace. Many careers now require
knowledge of computers, data processing and communication technologies. Therefore, schools
must ensure that students acquire practical digital literacy skills.
Apply the following formatting:
1. Insert the title THE IMPORTANCE OF DIGITAL TECHNOLOGY IN MODERN EDUCATION and
format it as:
Bold
Font size 18
Center aligned
2. Format the body text as:
Font: Times New Roman
Font size 12
Justified alignment
Line spacing 1.5
3. Insert:
Header: SS3 DIGITAL TECHNOLOGY PRACTICAL
Footer: Your Name and Page Number
4. Insert a bulleted list under the second paragraph showing three uses of digital tools:
Word Processing
Spreadsheet
Presentation Software
5. Insert a table with 3 columns and 4 rows showing:
Software Type Example Use
Word Processor MS Word Typing documents
Spreadsheet MS Excel Calculations
Presentation PowerPoint Slide presentations
6. Save the file.
SECTION B – SPREADSHEET (30 Marks)
Open a Spreadsheet Application (Microsoft Excel or Google Sheets).
Save the file as Student_Scores.xlsx
Question 2
Enter the following data.
Student Name English Mathematics Economics
Chinedu 65 70 60
Aisha 80 75 72
Musa 55 60 58
Grace 90 85 88
Tunde 72 68 74
Perform the following tasks:
1. Insert a column titled Total.
2. Calculate the Total score for each student using a formula.
3. Insert another column titled Average.
4. Calculate the Average score for each student.
5. Use a formula to find:
Highest score in Mathematics
Lowest score in English
6. Create a Bar Chart showing Student Names vs Total Scores.
7. Format the worksheet:
Bold headings
Apply borders to the table
Center all scores
Save your work.
---
SECTION C – PRESENTATION PACKAGE (30 Marks)
Using Microsoft PowerPoint or Google Slides, create a presentation and save it as:
Digital_Literacy_Presentation.pptx
Question 3
Create a 5-slide presentation on the topic:
DIGITAL LITERACY FOR STUDENTS
---
Slide 1 – Title Slide
Title:
Digital Literacy for Students
Subtitle:
Name
Class
School
Slide 2 – Meaning of Digital Literacy
Digital literacy refers to the ability to use computers and digital tools effectively for learning,
communication and problem solving.
Slide 3 – Importance of Digital Literacy
Include at least four points:
Access to information
Online communication
Academic research
Career opportunities
Slide 4 – Examples of Digital Tools
Insert bullet points:
Word Processing Software
Spreadsheet Software
Presentation Software
Internet Browsers
Slide 5 – Conclusion
Digital literacy is an essential skill for students in the 21st century. It improves learning and
prepares students for modern careers.
Additional Instructions
Apply the following:
1. Use a design theme/template.
2. Insert at least one relevant image.
3. Apply slide transitions.
4. Use animation on bullet points.
Save your presentation.
EXAMINER'S MARKING GUIDE (Optional)
SectionMarks
Word Processing 40
Spreadsheet 30
Presentation 30
Total 100