School Data - HR Analytics Practice

** This Data set is complied for Educational Purpose only **

------------- Data is in below spread sheet ----------------

This is a fictional data set created for Practicing basics of Analytics. The data set has few references from https[:]//data.world/

https://docs.google.com/spreadsheets/d/1ZlPtkw0N_AqB7GFNpWmGeqCEzr2mFU-LeXFlid2BIzc/edit?usp=sharing

------------- Questions ----------------
1. Create Student ID using Excel Formuala, which should convey the standard or Grade as well as student ID while any one looks at it.

Hind: Eg. 101001 (Meaning 1st standard 001 student)

2. Assume Pass mark is 45

2A - Write formula to Mark as "Phy-PASS" if Physics mark >45
2B - Mark as "All-PASS" if marks in all subjects are >45
2C - Mark as "2Sub-Pass" if any two subject marks are >45

3.Write Forumula to count no of boys who scored >75

4. Charts
4A - Girls vs Boys in Pie chart
4B - Vertical Bar chart indicate boys and girls in each class in one chart.


------------- Being Creative is Fun and increase confidence ----------------
 Other Imaginative self questions
 
------------- Story telling with Data  ----------------
What is your observations on the data in question. Or what will you convey to Principal or Board, and your recommendation to school.
Hint: Eg - 
We understand that there is more girls in Lower Primary than Upper Primary. 
Recommendation - Equal gender ratio increases perspective, diffrent learing opputunity. UNICEF link for gender disparity. https://data.unicef.org/topic/gender/gender-disparities-in-education/
Girls scored more in Physics than in Maths. Recommended to increase attention to Girls for Maths by more practice sessions or awarenes or make learning math FUN.
50% of boys scored more than 80 and remaining 50% scored less than 30 in Maths. Recommendation - This data shows large deviation among boys on Chemistry. attention should be given like above for remaining 50.