HANDS-ON EXERCISE

The following hands-on exercises are designed to assist you in practising the various lessons in this section. Where constituted, you’re encouraged to carryout this exercises in groups for collaboration and effective results.

Exercise 1: Basic Data Entry and Formatting in Excel

• • Objective: Learn to enter and format data in Excel.
  • Instructions:
    1. Open Microsoft Excel and create a new workbook.
    2. Enter the following data in the first row: “Item”, “Quantity”, “Price”.
    3. Enter at least 5 rows of sample data.
    4. Format the header row to be bold and center-aligned.
    5. Format the “Price” column to display currency.
    6. Save the workbook as “BasicDataEntry.xlsx”.
    7. Share a screenshot of your work on the SAED Facebook page and with your personal remarks.

Exercise 2: Student Assessment Tracking in Excel

• • Objective: Set up a spreadsheet to track and analyze student assessments.
  • Instructions:
    1. Open Excel and create a new workbook.
    2. Create a header row with the following columns: “Student ID”, “Student Name”, “Assignment 1”, “Assignment 2”, “Test”,  “Examination”, “Total Score”, “Average”, “Position”, “Grade”.
    3. Enter sample data for at least 5 students.
    4. Use the SUM function to calculate the total score for each student.
    5. Calculate the Average using the appropriate formula.
    6. Solve the Position using the appropriate formula.
    7. Use the IF function to assign grades based on percentage ranges.
    8. Save the workbook as “StudentAssessment.xlsx”.
    9. Share a screenshot of your work on the SAED Facebook page and with your personal remarks.