data analysis
Individual Final Project Guidelines
Project Description
• The final project accounts for 40% of the overall grade.
• Students are required to prepare 5 Excel files.
• Each file should replicate the same calculations and procedures demonstrated by the professor in the example Excel files.
Reference Sessions
• The relevant materials and step-by-step explanations were provided during Q&A sessions 3, 4, 5, and 6.
• These sessions serve as the primary reference for completing the project.
Evaluation Criteria
• Accuracy in reproducing the calculations.
• Proper structure and organization of the Excel files.
• Clarity and consistency of the results.
• Timely submission.
Project Components
• The individual final project consists of a collection of 5 Excel files that must be submitted.
• Each file will be opened at the beginning of the corresponding Q&A session, where the professor will explain in detail how to solve the exercise.
• All files with the worksheets will be available in the Worksheet section of the Virtual Campus.
• Each file includes:
o One fully solved exercise, which will be explained by the professor during the online Q&A session.
o One dataset for students to use in their project work.
• The student’s task is to reproduce all calculations performed by the professor but using the new dataset provided.
• Students must create their own worksheets until completing the same number of sheets as the professor’s original file.

