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:

· One fully solved exercise, which will be explained by the professor during the online Q&A session.

· 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.

Final Grade

 The final grade for the project will be the average grade of the four submitted files.