Foot Wear Production  ·  Level 5
Digital Literacy
Chapter 2: Solve Tasks Using Office Suite
📚 0 Topics

Chapter Practical Activities

Practical 1: Create and format a text document with headings, paragraphs, and lists

Foot Wear Production · Level 5
Digital Literacy
PRACTICAL ASSESSMENT
TIME: 4 HOURS
⬇ PDFCandidate Instructions (Candidate Tool)

Type: Individual

INSTRUCTIONS TO CANDIDATE:
1.  You are required to perform the following task:
i.  Create a formatted text document titled 'Company Memo' with 3 headings, 3 paragraphs, and 2 lists, sized A4 portrait as per the provided specifications.
2.  You have been provided with the following resources for the practical task:
Tools & EquipmentMaterials
Computer with Word Processing SoftwareA4 Plain Paper
Keyboard and Mouse
Printer
⬇ PDFResources Required (Cutting List)
S/NItemQuantity
1Computer with Word Processing Software1 Pc per Candidate
2Keyboard and Mouse1 set per Candidate
3Printer1 Pc per 5 Candidates
4A4 Plain Paper20 Sheets per Candidate
⬇ PDFAssessor Guide
Items to be EvaluatedMarks AvailableMarks ObtainedComments
TASK 1: Check the student's presentation
Appropriately wore PPE (e.g. dust coat)
(Award 1 mark for correct PPE use, else 0)
1
Sub-Total1
TASK 2: Prepare the work area
Correctly arranged computer and peripherals for use
(Award 1 mark for correct arrangement, else 0)
1
Ensured the work area was clean and free from hazards
(Award 1 mark for hazard-free area, else 0)
1
Sub-Total2
TASK 3: Identify and use software tools correctly
Opened the word processing software correctly
(Award 1 mark for correct software launch, else 0)
1
Used formatting tools for headings, paragraphs, and lists appropriately
(Award 2 marks for appropriate formatting, else 0)
2
Sub-Total3
TASK 4: Create the document content accurately
Typed 3 headings with correct styles applied
(Award 2 marks for all headings correctly styled, else partial or 0)
2
Typed 3 paragraphs with correct spacing and alignment
(Award 2 marks for all paragraphs correctly formatted, else partial or 0)
2
Inserted 2 lists (one numbered, one bulleted) correctly formatted
(Award 2 marks for correct lists, else partial or 0)
2
Sub-Total6
TASK 5: Finalize and print the document
Saved the document with an appropriate file name
(Award 1 mark for correct saving, else 0)
1
Printed the document without errors
(Award 1 mark for error-free print, else 0)
1
Sub-Total2
TASK 6: Observe housekeeping practices
Closed all applications properly
(Award 1 mark for proper closure, else 0)
1
Cleaned and organized the work area after task completion
(Award 1 mark for cleanliness and organization, else 0)
1
Sub-Total2
PRODUCT CHECKLIST
Document contains 3 correctly formatted headings
(Award 2 marks if all headings meet formatting specs, else 0)
2
Document contains 3 well-structured paragraphs with correct alignment and spacing
(Award 2 marks if paragraphs meet criteria, else 0)
2
Document contains 2 correctly formatted lists (1 numbered, 1 bulleted)
(Award 2 marks if lists are correct, else 0)
2
Document is saved and printed on A4 paper in portrait orientation
(Award 2 marks if saved and printed correctly, else 0)
2
Sub-Total8
GRAND TOTAL24
ASSESSMENT OUTCOME:   ☐ Competent    ☐ Not Yet Competent (competent if at least 50%)

Practical 2: Design and format a sales report spreadsheet with formulas

Foot Wear Production · Level 5
Digital Literacy
PRACTICAL ASSESSMENT
TIME: 4 HOURS
⬇ PDFCandidate Instructions (Candidate Tool)

Type: Individual

INSTRUCTIONS TO CANDIDATE:
1.  You are required to perform the following task:
i.  Create a sales report spreadsheet calculating total sales and average sales per product for 5 products with sales data for 4 weeks, formatted as per company standards.
2.  You have been provided with the following resources for the practical task:
Tools & EquipmentMaterials
Computer with spreadsheet softwareSample sales data sheet
Keyboard and mouse
⬇ PDFResources Required (Cutting List)
S/NItemQuantity
1Computer with spreadsheet software installed1 Pc per Candidate
2Keyboard and mouse1 set per Candidate
3Sample sales data sheet (printed)1 Pc per Candidate
⬇ PDFAssessor Guide
Items to be EvaluatedMarks AvailableMarks ObtainedComments
TASK 1: Prepare the spreadsheet layout and enter data
Opened spreadsheet software and set up worksheet with appropriate headings
(Award 2 marks for correct layout and headings)
2
Entered sales data accurately for 5 products over 4 weeks
(Award 3 marks for accurate and complete data entry)
3
Sub-Total5
TASK 2: Use formulas to calculate totals and averages
Applied formula to calculate total sales per product correctly
(Award 3 marks for correct sum formula for totals)
3
Applied formula to calculate average sales per product correctly
(Award 3 marks for correct average formula)
3
Sub-Total6
TASK 3: Format the spreadsheet for readability and presentation
Formatted headings with bold font and background shading
(Award 2 marks for correct heading formatting)
2
Applied borders to data cells and totals
(Award 2 marks for proper cell borders)
2
Adjusted column widths for clear display of data
(Award 1 mark for appropriate column width adjustment)
1
Sub-Total5
PRODUCT CHECKLIST
Spreadsheet contains all required data, formulas and formatting as per task instruction
(Award 4 marks for completeness, accuracy and neatness of final spreadsheet)
4
Sub-Total4
GRAND TOTAL20
ASSESSMENT OUTCOME:   ☐ Competent    ☐ Not Yet Competent (competent if at least 50%)
🔒

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

Create a free account
🔒Generate and Customize Charts from Sales Data Using Spreadsheet SoftwarePractical 3
🔒Create a multimedia slide presentation on Kenyan wildlife conservationPractical 4
🔒Create a personalized invitation letter using mail mergePractical 5
🔒Collaborate on a shared project report document using cloud-based office toolsPractical 6
🔒Create and Format a Table in a Word Processor DocumentPractical 7
🔒Apply Advanced Spreadsheet Functions and Data Filtering to Analyze Sales DataPractical 8
🔒Set Page Layout and Print Options for a DocumentPractical 9
🔒Create Hyperlinks and Bookmarks in Documents and PresentationsPractical 10