Practical 1: Basic Use of Microsoft Word
-
Practical Task:
→ Create a professional one-page document in Microsoft Word that includes:- A title with styling
- A short paragraph with formatted text
- A bulleted list of tasks or items
- A table showing business data
- A picture inserted from your computer
-
Step 1: Open Microsoft Word
→ Start a blank document. -
Step 2: Add a title
→Type a title like “Weekly Sales Report” and apply: - Font: Calibri or Arial - Size: 20pt - Style: Bold and Centered -
Step 3: Write a short paragraph
→Describe the purpose of the report. Use: - Bold for key terms - Italic for emphasis - Underline for important phrases -
Step 4: Add a bulleted list
→List 3–5 tasks or items (e.g., “Review sales”, “Update inventory”, “Send invoices”). Use the bullet icon in the toolbar. -
Step 5: Insert a table
→Create a 3x3 table with columns like: | Product | Quantity | Price | Fill in sample data. -
Step 6: Insert a picture
→Use “Insert > Picture” to add a logo or relevant image from your computer. Resize and position it neatly. -
Step 7: Save your document
→Use
Ctrl + Sor click the Save icon. Name the file “Sales_Report.docx”. -
Step 8: Print or share your document
→Use “File > Print” or “File > Share” to present your work.
Post-practical (1): Microsoft Word Basics
- What is Microsoft Word used for in business?
- How do you change the font style of a title?
- What is the shortcut to save a document?
- How do you make text bold in Word?
- What is the purpose of a bulleted list?
- How do you insert a table in Word?
- What are common uses of tables in business documents?
- How do you center a title on the page?
- What is the difference between bold and italic text?
- How do you insert a picture into a Word document?
- Why is formatting important in professional documents?
- How do you underline a word or phrase?
- What is the default file extension for Word documents?
- How do you print a document in Word?
- What is the purpose of headers and footers?
- How can Word be used in industry reports?
- What is the benefit of using tables for data presentation?
- How do you adjust line spacing in a paragraph?
- What is the use of the “Styles” feature in Word?
- How do you share a Word document with others?
Practical 2: Basic Use of Microsoft Excel
-
Practical Task:
→ Create a simple **Sales Record Sheet** in Microsoft Excel that includes:- Column headers for Product, Quantity, Unit Price, and Total
- Data entry for at least 5 products
- Formulas to calculate totals
- Basic formatting (bold headers, borders, currency)
- A chart showing total sales per product
-
Step 1: Open Microsoft Excel
→ Start a new blank workbook. -
Step 2: Enter column headers in Row 1
→| A1: Product | B1: Quantity | C1: Unit Price | D1: Total | -
Step 3: Enter sample data in rows 2–6
→| Apple | 10 | 2.00 | =B2*C2 | | Banana | 15 | 1.50 | =B3*C3 | | Orange | 12 | 2.50 | =B4*C4 | | Mango | 8 | 3.00 | =B5*C5 | | Grapes | 20 | 1.80 | =B6*C6 | -
Step 4: Apply formatting
→- Bold the headers
- Add borders to the table
- Format Unit Price and Total as currency
-
Step 5: Insert a chart
→- Select Product and Total columns
- Go to “Insert” > “Chart” > “Column Chart”
- Label the chart as “Sales Summary”
-
Step 6: Save your workbook
→Use
Ctrl + Sor click the Save icon. Name the file “Sales_Record.xlsx”. -
Step 7: Present your sheet to the class or teacher
→ Explain how formulas and charts help in business.
Post-Practical (2): Microsoft Excel Basics
- What is Microsoft Excel used for?
- How do you enter data into a cell?
- What formula calculates total sales?
- How do you format numbers as currency?
- What is the purpose of column headers?
- How do you apply borders to a table?
- What does the formula
=B2*C2do? - How do you insert a chart in Excel?
- What type of chart shows sales per product?
- How do you save a workbook?
- Why is Excel useful in business?
- How can Excel help with budgeting?
- What is the difference between a row and a column?
- How do you bold text in Excel?
- What is a cell reference?
- How do you copy a formula to other rows?
- What is the benefit of using formulas?
- How do you rename a worksheet tab?
- What is the shortcut to create a new workbook?
- How can charts help in presentations?
Practical 3: Organizing Files and Folders
-
Practical Task:
→ Create a folder structure for a school or business project that includes:- Main folder with a clear name
- Subfolders for different types of files
- At least 3 sample files saved in the correct folders
-
Step 1: Create a main folder
→Right-click on your desktop or in File Explorer > New > Folder Name it “Project_2025” -
Step 2: Create subfolders inside the main folder
→Open “Project_2025” and create: - Documents - Images - Reports -
Step 3: Create or copy sample files into each subfolder
→- Save a Word document in “Documents”
- Save a picture in “Images”
- Save an Excel sheet in “Reports”
-
Step 4: Rename each file clearly
→Example: “MeetingNotes.docx”, “Logo.png”, “SalesData.xlsx” -
Step 5: View folder properties
→Right-click the folder > Properties Check size, number of files, and location -
Step 6: Compress the folder (optional)
→Right-click “Project_2025” > Send to > Compressed (zipped) folder -
Step 7: Present your folder structure to the class or teacher
→ Explain how organizing files helps in school or business.
Post-Practical (3): Files and Folders
- What is a file?
- What is a folder?
- How do you create a new folder?
- Why is it important to organize files?
- What types of files can be stored in a folder?
- How do you rename a file?
- What is the purpose of subfolders?
- How do you move a file into a folder?
- What does “right-click” mean?
- How do you check the size of a folder?
- What is a file extension? Give examples.
- How do you delete a file safely?
- What happens when you compress a folder?
- How do you search for a file on your computer?
- What is the difference between a file and a folder?
- How can folders help in business projects?
- What is the benefit of naming files clearly?
- How do you copy a file from one folder to another?
- What is a zipped folder used for?
- Why should you back up important folders?
Practical (4): Sending and Formatting an Email
-
Practical Task:
→ Use an email service like Gmail or Outlook to send a professional email that includes:- A clear subject line
- Proper greeting and closing
- Formatted text (bold, italic, underline)
- An attached document or image
-
Step 1: Log in to your email account
→Go to Gmail.com or Outlook.com and enter your username and password. -
Step 2: Click “Compose” or “New Message”
→This opens a blank email window. -
Step 3: Fill in the email fields
→- To: Enter the recipient’s email address
- Subject: Type a short, clear topic (e.g., “Meeting Reminder”)
-
Step 4: Write your message
→Start with a greeting (e.g., “Dear Mr. Sikalola,”) Write your message clearly. End with a closing (e.g., “Best regards, Mwamba”) -
Step 5: Format your text
→- Use bold for important points
- Use italic for emphasis
- Use underline for key dates or deadlines
-
Step 6: Attach a file
→Click the paperclip icon and choose a document or image from your computer. -
Step 7: Send your email
→Click the “Send” button to deliver your message. -
Step 8: Check your “Sent” folder
→Make sure the email was sent successfully.
Post-Practical(4): Email Essentials
- What is the purpose of email?
- How do you create a new email message?
- What should go in the “To” field?
- Why is the subject line important?
- What is a professional greeting in email?
- How do you format text in an email?
- What does bold text do in a message?
- When should you use italic text?
- How do you underline a word or phrase?
- How do you attach a file to an email?
- What types of files can be attached?
- What is the “Send” button used for?
- Where can you find emails you’ve sent?
- Why is it important to check your spelling?
- What is a good closing for a business email?
- How do you reply to an email?
- What is the difference between “Reply” and “Forward”?
- How do you delete an unwanted email?
- Why should you avoid clicking unknown links in emails?
- How can email be used in school or business?