INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY

FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page 1

of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Practical 1: Student Performance Analysis Using IF, AND, OR Functions

Aim
To use Excel functions (IF, AND, OR) and conditional formatting to analyze student
performance.

Requirements
Create a worksheet named "Results" with the following fields:

Procedure
Step 1: Create the Worksheet
1. Open Microsoft Excel.
2. Create a new workbook.
3. Rename Sheet1 to Results.
4. Enter the required column headings.
5. Press Ctrl + s to save you your work as student performance and save every after 2
minutes
Screenshot 1 shows the entry of the results

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page 2

of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 2: Calculate Final Mark

Formula Used
=(C2*40%)+(D2*60%)
Procedure
1. Click cell F2 under Final Mark.
2. Enter the formula above.
3. Press Enter.
4. Drag the fill handle down to apply the formula to all students.
screenshot 2 showing final mark

Step 3: Determine Pass/Fail Using IF Function

Formula Used
=IF(F2>=50,"Pass","Fail")
Procedure
1. Click cell G2 under Status.
2. Enter the formula above.
3. Press Enter.
4. Copy the formula down the column.
Screenshot 3 Here;

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page 3

of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 4: Use the AND Function

Formula Used
=IF(AND(F2>=70,E2>=80),"Eligible","Not Eligible")
Procedure
1. Click cell H2.
2. Enter the formula above.
3. Press Enter.
4. Copy the formula down the column.
Screenshot 4 Here:

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page 4

of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 5: Use the OR Function

Identify Students Requiring Academic Support Using OR
Formula Used
=IF(OR(F2<50,E2<60),"Support Needed","No Support Needed")
Procedure
1. Click cell I2.
2. Enter the formula above.
3. Press Enter.
4. Copy the formula down the column.
5. .
Screenshot 5 Here:

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page 5

of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 6: Apply Conditional Formatting

Procedure
1. Select the Status column.
2. Click Home → Conditional Formatting → Highlight Cells Rules → Text that Contains.
3. Type Fail.
4. Choose a Red Fill colour.
5. Click OK.
Screenshot 6 (Conditional Formatting Settings) Here

Results
Final Worksheet Screenshot Here:

Conclusion
The practical successfully demonstrated the use of IF, AND, and OR functions to analyze
student performance and the use of conditional formatting to visually identify failed students.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page 6

of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Practical 2: Employee Salary Management Using COUNTIF and COUNTIFS

Aim
To use Excel COUNTIF and COUNTIFS functions to analyze employee data and create a
summary of departmental statistics.

Requirements
Create a worksheet containing the following fields:

Step 1: Enter Employee Data

1. Open Microsoft Excel.
2. Create a worksheet named Employee Database.
3. Press Ctrl + s to save your as Employment salary Management and do it every after 2
minutes.

4. Enter employee records with the required fields.

Screenshot 1 (Employee Data Table) Here

Step 2: Count Employees in the IT Department Using COUNTIF

Formula Used
=COUNTIF(B3:B17,"IT")
Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page 7
of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Procedure
1. Select a blank cell.
2. Enter the formula above.
3. Press Enter to display the number of employees in the IT Department.
Screenshot 2 (COUNTIF for IT Department) Here

Step 3: Count Female Employees Using COUNTIF

Formula Used
=COUNTIF(C3:C17,"Female")
Procedure
1. Select a blank cell.
2. Enter the formula above.
3. Press Enter.
Screenshot 3 (COUNTIF for Female Employees) Here

Step 4: Count Male Employees Earning Above UGX 1,000,000 Using COUNTIFS
Formula Used
=COUNTIFS(C3:C17,"Male",D317:D,">1000000")
Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page 8
of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Procedure
1. Select a blank cell.
2. Enter the formula above.
3. Press Enter.
Screenshot 4 (COUNTIFS for Male Employees Above UGX 1,000,000) Here

Step 5: Count Employees in Finance with More Than 5 Years of Service

Formula Used
=COUNTIFS(B3:B17,"Finance",E3:E17,">5")
Procedure
1. Select a blank cell.
2. Enter the formula above.
3. Press Enter.
Screenshot 5 (COUNTIFS for Finance Employees with More Than 5 Years of Service)
Here

Step 6: Create a Summary Table

Create a summary table showing the number of employees in each department.
Example:
Department Number of Employees
IT
Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page 9
of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Department Number of Employees

Finance
HR

Marketing
Use COUNTIF to calculate the totals.
Example Formula
=COUNTIF(B3:B17,”IT”)
Do for other departments using the same formula
Screenshot 6 (Department Summary Table) Here

Step 7: Insert a Chart

Procedure
1. Select the Summary Table.
2. Click Insert tab.
3. Choose a suitable chart (Pie Chart ).
4. Add a chart title such as Department Distribution.
screenshot 7 (Department Distribution Chart) Here

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

10 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Results
Screenshot 8 (Completed Worksheet) Here

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

11 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Conclusion
The practical demonstrated the use of COUNTIF and COUNTIFS functions to analyze
employee records. A summary table was created to show departmental statistics, and a
chart was used to visualize the distribution of employees across departments.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

12 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Practical 3: Inventory Management Using VLOOKUP

Aim
To use the VLOOKUP function to retrieve product information, calculate total sales cost, and
classify purchases using the IF function.
Requirements
MUST DO;
Press ctrl + shift tp save your work as Inventory Management.
Worksheet 1: Products
Create a worksheet named Products with the following fields:

Worksheet 2: Sales
Create a worksheet named Sales with the following fields:

Step 1: Create the Products Worksheet

1. Open Microsoft Excel.
2. Create a worksheet named Products.
3. Enter product details including Product Code, Product Name, Unit Price, and
Category.
Screenshot 1 (Products Worksheet) Here

Step 2: Create the Sales Worksheet

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page
13 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

1. Create another worksheet named Sales.

2. Enter Invoice Number, Product Code, and Quantity.
3. Leave the remaining columns for formulas.
Screenshot 2 (Sales Worksheet Before Formulas) Here

Step 3: Retrieve Product Name Using VLOOKUP

Formula Used

=VLOOKUP(B2,Products!A:D,2,FALSE)
Procedure
1. Click the Product Name cell.
2. Enter the formula above.
3. Press Enter.
4. Copy the formula down the column.
Screenshot 3 (VLOOKUP for Product Name) Here

Step 4: Retrieve Unit Price Using VLOOKUP

Formula Used
=VLOOKUP(B2,Products!A:D,3,FALSE)
Procedure
1. Click the Unit Price cell.
2. Enter the formula above.
3. Press Enter.
4. Copy the formula down.
Screenshot 4 (VLOOKUP for Unit Price) Here

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

14 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 5: Retrieve Category Using VLOOKUP

Formula Used
=VLOOKUP(B2,Products!A:D,4,FALSE)
Procedure
1. Click the Category cell.
2. Enter the formula above.
3. Press Enter.
4. Copy the formula down.
Screenshot 5 (VLOOKUP for Category) Here

Step 6: Calculate Total Cost

Formula Used
=C2*E2
Procedure
1. Click the Total Cost cell.
2. Enter the formula above.
3. Press Enter.
4. Copy the formula down.
Screenshot 6 (Total Cost Formula) Here

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

15 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 7: Classify Purchases Using IF Function

Formula Used
=IF(C2>=20,"Bulk Purchase","Normal Purchase")
Procedure
1. Click the Purchase Type cell.
2. Enter the formula above.
3. Press Enter.
4. Copy the formula down.
Screenshot 7 (IF Function for Purchase Type) Here

Step 8: Professional Formatting

Procedure
1. Apply bold formatting to all headings.
2. Adjust column widths appropriately.
3. Apply borders to the table.
4. Format Unit Price and Total Cost as Currency (UGX).
5. Apply a suitable table style.
6. Center-align headings.
Screenshot 8 (Formatted Worksheet) Here

Results
Screenshot 9 (Completed Inventory Management Worksheet) Here

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

16 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Conclusion
The practical successfully demonstrated the use of the VLOOKUP function to retrieve
product details from another worksheet. Formulas were used to calculate total cost, while the
IF function was used to classify purchases as either Bulk Purchase or Normal Purchase.
Professional formatting techniques were applied to improve the appearance and readability
of the worksheet.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

17 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Practical 4: Examination Grading System Using HLOOKUP

Aim
To use HLOOKUP, IF, and COUNTIF functions to assign grades, classify performance, and
generate a grading summary report.

Requirements
Worksheet 1: Grade Table (Horizontal Layout)
Create a worksheet named Grade Table and arrange data horizontally as follows:

In the same Worksheet 1 ;

Create another worksheet named Students with the following fields:

Step 1: Create the Students Table

1. Create a worksheet named Students.

2. Enter student names and scores.
3. Leave Grade and Classification columns empty for formulas.
Paste Screenshot 3 (Students Table Before Formulas) Here

Step 3: Retrieve Grades Using HLOOKUP

Formula Used
=HLOOKUP(G4,$A$1:$E$2,2,TRUE)
Procedure
1. Click the Grade cell.
2. Enter the formula above.
3. Press Enter.
4. Copy down for all students.
Screenshot 3 (HLOOKUP Formula in Grade Column) Here

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

18 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 4: Classify Students Using IF Function

Classification Rule
 Distinction → Score ≥ 80
 Credit → Score 70–79
 Pass → Score 50–69
 Fail → Score < 50
Formula Used
=IF(B2>=80,"Distinction",IF(B2>=70,"Credit",IF(B2>=50,"Pass","Fail")))
Procedure
1. Click the Classification cell.
2. Enter the formula above.
3. Press Enter.
4. Copy down.
Paste Screenshot 4 (IF Classification Formula) Here

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

19 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 5: Generate Report Using COUNTIF

Create a summary table:
Grade Number of Students
A
B
C
D
F
Formula Used
Example for Grade A:
=COUNTIF(H:H,"A")
Repeat for other grades:
=COUNTIF(H:H,"B")
Procedure
1. Create summary table.
2. Use COUNTIF to calculate totals.
3. Fill all grade categories.
Screenshot 5 (Grade Summary Report) Here

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

20 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 6: Final Report Output

Show the complete worksheet with:
 Names
 Scores
 Grades
 Classification
 Summary table
Conclusion
The practical demonstrated the use of HLOOKUP for grade retrieval from a horizontal table.
The IF function was used to classify student performance into Distinction, Credit, Pass, and
Fail. Finally, COUNTIF was used to generate a summary report showing the number of
students per grade.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

21 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Question 5: Data Validation and Drop-Down Lists

Title
Student Registration Form Using Data Validation and Drop-Down Lists

Set Up Form Layout

Start Here
Create the basic structure of the registration form.
 Open a new Excel workbook
 In row 1, type headers: Student Name, Faculty, Department, Program Type, Age,
Email Address, Student ID
 Adjust column widths for readability
Screenshot 1

2Prepare Source Lists

Enter lists for drop-down menus.
 Go to a new sheet named Lists
 In column A, type faculties (Science, Arts, Engineering, Business, Law)
 In column B, type program types (Undergraduate, Postgraduate, Diploma)
Screenshot 2

[Link] Drop-Down Lists

Link the source lists to form fields.
 Select Faculty column cells
 Data → Data Validation → Allow: List → Source: =Lists!$A$2:$A$6
 Select Program Type column cells
 Data Validation → List → Source: =Lists!$B$2:$B$4
Screenshot 3

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

22 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

[Link] Age Validation

Restrict age entries to valid range.
 Select Age column cells
 Data Validation → Whole Number → Between 18 and 35
 Add Input Message: 'Enter age between 18 and 35'
 Add Error Alert: 'Invalid Age! Must be 18–35'

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

23 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Add Error Alert: 'Invalid Age! Must be 18–35' as shown below

Add when i add age great than 35 it will show the alert message

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

24 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

[Link] Email Validation

Ensure email addresses contain '@'.
 Select Email column cells
 Data Validation → Custom → Formula: =ISNUMBER(SEARCH("@",F2)) as shown
below;

The formula:
=ISNUMBER(SEARCH("@",F2))
is used to check whether the email entered in cell F2 contains the @ symbol.
Part 1: SEARCH("@",F2)
Suppose F2 contains:
jonathan@[Link]
Excel looks for the position of @ inside the text.
SEARCH("@",F2)
Result:9
because @ is the 9th character.
 Add Input Message: 'Email must contain @ symbol'
 Add Error Alert: 'Invalid Email! Please include @'

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

25 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

6. Prevent Duplicate IDs

Ensure each Student ID is unique.
 Select Student ID column cells
 Data Validation → Custom → Formula: =COUNTIF($G$2:$G$100,G2)=1

=COUNTIF($G$2:$G$100,G2)=1
Purpose
This formula is used to prevent duplicate Student IDs (or any duplicate data) in column G.
 Add Error Alert: 'Duplicate ID detected! Enter a unique Student ID'

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

26 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

[Link] and Finalize

Recommended
Verify that all rules work correctly.
 Try entering valid and invalid ages

 Test email addresses with and without '@'

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

27 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

 Enter duplicate Student IDs to confirm rejection

 Save the workbook as 'Student Registration [Link]'

 Then your final results look like this;

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

28 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Creating a Registration Form with Dependent Drop-Down Lists in Microsoft Excel

Aim
To create a registration form with dependent drop-down lists using Named Ranges, Data
Validation, and Worksheet Protection.
Step 1: Create the Workbook and Data Worksheet
1. Open Microsoft Excel and create a Blank Workbook.
2. Rename Sheet1 to Data.
3. Create another worksheet and rename it Registration Form.
4. In the Data worksheet, enter the Faculty, Department, Country, and District data in
separate columns as required.
5. Adjust the column widths to display all the data clearly.
Screenshot 2: Data worksheet showing all entered data.

Create the Faculty Named Range

1. Highlight cells A2:A3.
2. Click inside the Name Box (located to the left of the Formula Bar).
3. Type: Faculty
4. Press Enter.
Screenshot 4: Creating the Faculty named range.

Step 3: Create the Department Named Ranges

Computing
1. Highlight B2:B4.
2. Click the Name Box.
Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page
29 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

3. Type:
Computing
4. Press Enter.
Business
1. Highlight C2:C4.
2. Click the Name Box.
3. Type:
Business
4. Press Enter.
Step 6: Create the Country Named Range
1. Highlight D2:D3.
2. Click the Name Box.
3. Type:
Country_List
4. Press Enter.

Step 7: Create the District Named Ranges

Uganda
1. Highlight E2:E4.
2. Click the Name Box.
3. Type:
Uganda
4. Press Enter.
Kenya
1. Highlight F2:F4.
2. Click the Name Box.
3. Type:
Kenya
5. Press Enter.
Step 8: Design the Registration Form
Switch to the Registration Form worksheet.
Enter the following labels.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

30 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Leave cells B2:B5 empty because they will contain the drop-down lists.
Step 9: Create the Faculty Drop-Down List
1. Select cell B2.
2. Click the Data tab.
3. Select Data Validation.
4. Under Allow, choose List.
5. In the Source box, type:
=Faculty
6. Click OK.
Test the drop-down to ensure it displays:
 Computing
 Business

Step 10: Create the Department Dependent Drop-Down

1. Select cell B3.
2. Open Data Validation.
3. Choose List.
4. In the Source box, type:
=INDIRECT(B2)
5. Click OK.
If a warning appears because B2 is empty, click Yes.
Test the drop-down:
 Selecting Computing displays:
o Computer Science
o Information Technology

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

31 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

o Software Engineering
 Selecting Business displays:
o Accounting
o Finance
o Marketing

Step 11: Create the Country Drop-Down

1. Select cell B4.
2. Open Data Validation.
3. Choose List.
4. Enter the following source:
=Country_List
5. Click OK.

Step 12: Create the District Dependent Drop-Down

1. Select cell B5.
2. Open Data Validation.
3. Choose List.
4. Enter:
=INDIRECT(B4)
5. Click OK.
Test the list:
If Uganda is selected, the districts displayed are:
 Kampala
 Wakiso
 Gulu
If Kenya is selected, the districts displayed are:
 Nairobi
 Mombasa
 Kisumu

Step 13: Unlock the Input Cells

1. Select cells B2:B5.
2. Right-click and choose Format Cells.
3. Open the Protection tab.
4. Uncheck Locked.
5. Click OK.
Step 14: Protect the Worksheet
1. Click the Review tab.
2. Select Protect Sheet.
3. (Optional) Enter a password.
4. Ensure Select unlocked cells is checked.
5. Uncheck Select locked cells.
6. Click OK.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

32 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 15: Test the Registration Form

1. Select a Faculty and verify that the Department list changes accordingly.
2. Select a Country and verify that the District list updates automatically.
3. Try editing the labels or protected cells to confirm that worksheet protection is
working.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

33 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

34 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 3: Create the Report

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

35 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

 Add a page for the Table of Contents.

 Type the report using headings such as:
o Introduction
o Advantages of Information Technology
o Recommendations

Apply Heading 1 and Heading 2 styles where appropriate.

Screenshot to Attach:

Step 4: Format the Document

 Apply a professional Theme.
 Format the text using:
o Font size 12
o Line spacing 1.5
o Justified alignment
 Insert Headers, Footers, and Page Numbers.
Step 5: Insert Objects
 Insert a Table summarizing IT applications.
 Add a SmartArt diagram.
 Insert relevant Pictures and add captions to each.
Screenshot to Attach:

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

36 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 6: Generate References

 Generate an Automatic Table of Contents from the headings.
 Insert citations and create a References page using APA Style.
Screenshot to Attach:

Step 7: Save the Document

 Review the document for errors.
 Save the final version.
Screenshot to Attach:

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

37 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

38 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Experiment 8
Mail Merge and Professional Documentation
Aim Experiment: Mail Merge and Professional Documentation
Aim
To create a student database and use Microsoft Word Mail Merge to generate
personalized internship placement letters, including a university logo, signature line, and
date field, then save each letter as an individual PDF document.
Procedure
Step 1: Create the Student Database
Procedure
1. Open Microsoft Excel.
2. Create a new workbook.
3. In the first row, type the following headings:
o Student Name
o Registration Number
o Company Assigned
4. Enter details for all 30 students.
5. Save the workbook as [Link].
Screenshot
Paste Screenshot Here

Step 2: Open Microsoft Word

Procedure
1. Open Microsoft Word.
2. Click Blank Document.
3. Save the document as Internship Placement [Link].
Paste Screenshot Here

Step 3: Start Mail Merge

Procedure
1. Click the Mailings tab.
2. Select Start Mail Merge.
3. Choose Letters.
Step 4: Connect the Student Database
Procedure
1. Click Select Recipients.
2. Select Use an Existing List.
3. Browse to [Link].
Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page
39 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

4. Select the worksheet containing the student information.

5. Click OK.
Step 5: Design the Internship Letter
Procedure
1. Insert the university logo at the top of the page.
2. Type the internship placement letter.
3. Leave spaces where personalized information will appear.

Step 6: Insert Mail Merge Fields

Procedure
1. Place the cursor where the student's name should appear.
2. Click Insert Merge Field.
Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page
40 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

3. Insert:
o Student Name
o Registration Number
o Company Assigned

Step 7: Insert Date Field

Procedure
1. Go to the Insert tab.
2. Select Date & Time.
3. Choose a preferred date format.
4. Tick Update Automatically.
5. Click OK.
Screenshot

Step 8: Insert Signature Line

Procedure
1. Go to the Insert tab.
2. Click Signature Line.
3. Enter the required details.
4. Click OK.
Screenshot
Figure 8: Signature line inserted.
Paste Screenshot Here

Step 9: Preview the Letters

Procedure
1. Click Preview Results.
2. Use the navigation arrows to move through different student records.
3. Verify that all information is correctly displayed.
Screenshot
Figure 9: Preview of a personalized internship placement letter.
Paste Screenshot Here

Step 10: Complete the Mail Merge

Procedure
1. Click Finish & Merge.
2. Select Edit Individual Documents.
3. Choose All Records.
4. Click OK.
Step 11: Save the Letters as PDF
Procedure
1. Open the merged document.
2. Click File → Save As.
3. Choose the save location.
4. Select PDF (*.pdf) as the file type.
5. Save each student's letter as an individual PDF using the format:
InternshipLetter_REG001.pdf
Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page
41 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

InternshipLetter_REG002.pdf
InternshipLetter_REG003.pdf
Continue until all 30 letters have been saved.
Screenshot
Figure 11: Saving the merged letter as a PDF.
Paste Screenshot Here

Expected Output
After completing the exercise:
 A student database containing 30 records is created.
 Personalized internship placement letters are generated.
 Each letter displays the correct student information.
 The university logo appears at the top.
 A signature line is included.
 The current date is automatically inserted.
 Each letter is saved as a separate PDF file.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

42 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

NO.9
Academic Presentation Design
Aim
To create a professional Microsoft PowerPoint presentation titled "Emerging Trends in
Artificial Intelligence" by applying themes, inserting charts, SmartArt, images, icons,
animations, slide transitions, and speaker noteS.
Procedure
Step 1: Create a New Presentation
 Open Microsoft PowerPoint.
 Select Blank Presentation.
 Save the file as Emerging Trends in Artificial [Link].
Step 2: Apply a Theme
 Click the Design tab.
 Select a professional theme.
 Choose suitable colours and fonts for the presentation.
Screenshot

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

43 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 3: Create the Slides

Insert a Vertical List SmartArt to display the agenda items neatly.
Create 10 slides with the following titles:

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

44 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 4: Enter and Format Content

 Type the required titles and information on each slide.
 Format headings using larger bold fonts.
 Arrange the content neatly using bullet points.
Step 5: Insert Images and Icons
 Go to Insert → Pictures to add relevant AI images.
 Go to Insert → Icons and add suitable icons such as a document, shield, code,
paintbrush, or balance scale.
 Resize and position the images and icons appropriately.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

45 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 6: Insert SmartArt

 Click Insert → SmartArt.
 Insert:
o Vertical List SmartArt for the Agenda slide.

o Process SmartArt for the Edge AI slide.

o Pyramid or Matrix SmartArt for the Conclusion slide.

 Enter the required information.

Screenshot

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

46 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 7: Insert a Chart

 Select the slide for Global Data Explosion.
 Click Insert → Chart.
 Choose a Column or Line Chart.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

47 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

 Replace the sample data with the provided AI data.

Screenshot
Step 8: Apply Slide Transitions
 Click the Transitions tab.
 Select Fade or Push.
 Click Apply to All.
Screenshot

Step 9: Apply Animations

 Select text, images, SmartArt, and charts.
 Click the Animations tab.
 Apply effects such as Fade, Float In, Appear, or Wipe.

Step 10: Add Speaker Notes

 Click Notes at the bottom of the PowerPoint window.
 Add speaker notes to Slides 4, 7, and 9.
 Save the presentation.
Screenshot

Step 11: Review and Save

 Check spelling, formatting, and slide order.
 Run the slideshow using Slide Show → From Beginning.
 Save the presentation.
Screenshot

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

48 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

No. 10 ..Business Proposal Presentation Using Microsoft PowerPoint

Aim
To create a professional business proposal presentation for Ranict IT Solutions using
Microsoft PowerPoint, incorporating SmartArt, tables, charts, multimedia, hyperlinks,
automatic slide timings, and exporting the presentation as a PDF.

Procedure
Step 1: Create and Save the Presentation
 Open Microsoft PowerPoint and create a Blank Presentation.
 Apply a professional theme (preferably blue, gray, or white).
 Save the presentation as Ranict IT Solutions Business [Link] before you
begin working.
Step 2: Create the Presentation Slides
Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page
49 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Create six slides with the following content:

 Slide 1: Title Slide
o Company name: Ranict IT Solutions

o Subtitle: Empowering Businesses Through Smarter Technology

o Presenter name and date

o Add a Start Presentation button.

 Slide 2: Company Profile

o Company overview

o Mission and Vision

o Insert a SmartArt Hierarchy organizational chart showing:

 CEO/Founder
 CTO and CMO
 IT Support Team and Software Engineers
Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page
50 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

 Slide 3: Services Offered

o Managed IT Support

o Cloud Solutions

o Cybersecurity

o Insert suitable icons and an audio/video clip set to Play Automatically.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

51 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

 Slide 4: Market Analysis

o Click Insert.

o Click Chart.

o Select

o Column

o Choose

o Clustered Column

o Click OK.

o A small Excel sheet opens. wing the target sectors, local market size, and
projected annual growth.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

52 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

 Slide 5: Financial Projections

o Insert a Clustered Column Chart using the provided revenue, expenses, and
net profit data for Years 1–3.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

53 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

 Slide 6: Conclusion
o Summarize the proposal.

o Add the statement "Let's Build the Future Together."

o Create a Return to Home button.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

54 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Step 3: Insert Presentation Features

Enhance the presentation by:
 Adding hyperlinks between the Start Presentation button (Slide 1 → Slide 2) and
Return to Home button (Slide 6 → Slide 1).
 Applying slide transitions and setting automatic timings for all slides.
 Testing the slideshow to ensure hyperlinks and multimedia work correctly.

Step 4: Save and Export

 Save the completed presentation.
 Export it as a PDF using File → Export → Create PDF/XPS Document.
 Verify that both the PowerPoint and PDF files have been saved successfully.
Screenshot 4: PDF export window or completed PDF file.

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

55 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

56 of 57
INTERNATIONAL BUSINESS SCIENCE AND TECHNOLOGY UNIVERSITY
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY

Monday, 17 August 2026 SENFUKA JONATHAN ROLL No. 011260616 Page

57 of 57