Plot a line chart of Total marks vs Student_ID, andIdentify performance variations (ups/downs).
See Answer →Compute average marks of each subject, and plot a bar chart of subject-wise averages
See Answer →Create a new column Total = sum of 4 subjects; also Also, Create Percentage = (Total/400)* 100
Find:
Topper (max Total)
Lowest scorer (min Total)
d) Plot a scatter diagram and histogram of Maths scores and interpret whether scores are concentrated or spread out.
See Answer →Read students_scores.csv into a panda DataFrame. and Display:
First 5 rows
Column names
Data types
See Answer →Read students_scores.csv into a panda DataFrame. and Display:
First 5 rows
Column names
Data types
See Answer →Use Python programming language to perform the tasks given below:
Note: Save the above data given in Dataset: Students' Exam Scores in a CSV file (students_scores.csv), save it, and Now Write a program in Python to perform following tasks:
See Answer →Now, create a single dashboard that includes:
i. Bar Chart (Subject-wise Average)
ii. Line Chart (Maths Trend)
iii. Pie Chart (Subject Contribution)
iv. Summary Statistics Table
See Answer →
Create a Table View displaying: Average, Minimum, Maximum, and Standard Deviation. (For all four subjects).
See Answer →. Create the following DAX measures: Average, Minimum, Maximum, and Standard Deviation.
(For all four subjects).
See Answer →
Create a Pie Chart showing percentage contribution of each subject based on average marks.
See Answer →
Create a Line Chart showing Maths scores across students. (Use Student_ID on X-axis.)
See Answer →Save the above data given in Dataset: Students' Exam Scores in an excel file or CSV file, save it, and perform following:
Import the Students' Exam Scores dataset into Power BI.
Verify data types for each subject.
Rename fields appropriately (if required).
See Answer →Create a Table View displaying: Average, Minimum, Maximum, and Standard Deviation. (For all four subjects).
f. Now, create a single dashboard that includes:
i. Bar Chart (Subject-wise Average)
ii. Line Chart (Maths Trend)
iii. Pie Chart (Subject Contribution)
iv. Summary Statistics Table
See Answer →
Explain why workplace safety training is essential and the benefits it provides to employees and the organization.
See Answer →
Describe the procedure for hazard reporting in the workplace and the benefits of reporting hazards.
See Answer →
Explain HACCP and food safety management systems and evaluate their role in preventing food hazards in hospitality operations.
See Answer →What is significance of security audits? Explain any five security auditing tools.
See Answer →
Discuss strategies to prevent slips, trips, and falls in hotels and restaurants.
See Answer →