Spreadsheet Modelling & Analysis MGNM580

Session 24253 (Jan Mar)

Academic Task: 1 (Project)Nature:Individual

Course Title:Spreadsheet Modelling & AnalysisCourse Code:MGNM580

Section: Maximum Marks:30

Date of Allotment:Feb 10, 2025Date of Submission:Feb 24, 2025

The Objective of the Activity

After completing this assignment, the students will be capable of:

1. Understanding the importance of the data, in data analysis and visualization.
2. Clean the data
3. Arrange the data
4. Analyze the data
5. Draw inferences from the data
6. Present the data in visually appealing way

The Topic

The students are expected to make a one-page dashboard using publicly available data. They may use data of their choice from:

1. Screener
2. Prowess
3. Kaggle
4. Mavens data playground
5. Any other source (complete URL must be provided from where data has been taken)

For this assignment the syllabus would be the topics covered inUnit I to Unit IV. The dashboard must not be the compilation of tables and charts. It must tell a story.

The studentsmust use a combination of tables, charts, and numbers in the dashboard. The are free to design a static dashboard or a dynamic dashboard using pivot tables and/or formulae.

The students will design the dashboard and upload it on their#linkedin accountwhile using the#LovelyProfessionalUniversity, #MSOB and #SpreadsheetModellingAssignment1. All three #tags are mandatory.

The students must also update the link of their linkedin dashboard at thisgoogleform link:

https://docs.google.com/forms/d/e/1FAIpQLSd91Bm1ymphLxf-8_-10TBkYHgp3WTV_cKOqLC-JHeH6lf9pg/viewform?usp=header

The Evaluation Parameters

The evaluation is divided in two parts:

1. Linkedin shares and commenting (10 Marks)
2. Technical skill assessment by the faculty (20 Marks)
   
   

Distribution of Marks: Linkedin Shares and Comments

Shares and comments >= 100 (10 marks)

Shares and comments >= 80 (08 marks)

Shares and comments >= 60 (06 marks)

Shares and comments >= 40 (04 marks)

Shares and comments >= 20 (02 marks)

Distribution of Marks: Technical Skill Assessment by Faculty

Note that within the parameters each evaluation key point carries ONE MARK

Mapped Course Outcomes

CO1, CO2, CO3, CO4

Mapped Blooms Taxonomy

L4 L6