? Project Overview

Students must create an Excel workbook with 3 main sheets:

? Sheet 1: Data Entry

? Sheet 2: Analysis

? Sheet 3: Dashboard

? Part 1: Sheet 1 – Data Entry

? Step 1: Create Table Structure

? Step 2: Apply Data Validation

• Subject → Dropdown list:

ICT,Math,English

• Marks → Whole number (0–100)

? Step 3: Apply Formulas

Grade:

=IF(D2>=80,"A",IF(D2>=60,"B",IF(D2>=50,"C","Fail")))

Result:

=IF(D2>=50,"Pass","Fail")

? Step 4: Apply Formatting

• Bold header
• Borders
• Fill color
• Center alignment

? Step 5: Conditional Formatting

• Marks ≥ 80 → Green
• Marks < 50 → Red

? Part 2: Sheet 2 – Analysis

? Step 6: Calculate Summary

• Total Marks:

=SUM(D2:D20)

• Average:

=AVERAGE(D2:D20)

• Highest:

=MAX(D2:D20)

• Lowest:

=MIN(D2:D20)

? Step 7: COUNTIF Analysis

• Pass Count:

=COUNTIF(F2:F20,"Pass")

• Fail Count:

=COUNTIF(F2:F20,"Fail")

? Step 8: Create Pivot Table

• Rows → Subject
• Values → Marks (Sum/Average)

? Part 3: Sheet 3 – Dashboard

? Step 9: Create Charts

• Column Chart → Student Marks
• Pie Chart → Pass vs Fail

? Step 10: Insert Pivot Chart

• Based on Pivot Table

? Step 11: Add Slicer (Optional)

• Filter by Subject

? Step 12: Design Dashboard

• Add titles
• Align charts properly
• Use consistent colors

? Part 4: Page Layout & Printing

? Step 13: Apply Page Layout

• Orientation → Landscape
• Fit to 1 page
• Add Header/Footer:

Student Performance Report
Your Name | Page Number

? Step 14: Export as PDF

• File → Save As → PDF

? Project Tasks Checklist

Students must:

✅ Create structured dataset
✅ Apply Data Validation
✅ Use formulas (IF, SUM, AVERAGE, COUNTIF)
✅ Apply Conditional Formatting
✅ Create Pivot Table
✅ Create Charts
✅ Design Dashboard
✅ Apply Page Layout
✅ Export as PDF

? Evaluation Criteria (Marks Distribution)

? Expected Learning Outcomes

Students will:

• Integrate all Excel skills
• Build a complete working project
• Analyze and present data
• Develop real-world spreadsheet solutions

⚠️ Common Mistakes to Avoid

• Incorrect formulas
• Poor formatting
• Missing validation
• Unclear dashboard
• Not linking data properly

?‍? Instructor Guidelines

• Review each sheet separately
• Check formulas carefully
• Evaluate dashboard clarity
• Ensure originality of student work

? Conclusion

This final project ensures students can apply Excel professionally, combining:
✔ Data Entry
✔ Analysis
✔ Visualization
✔ Reporting