JSON Array/Object exercises

You required .json files from server and received raw data as JSON array/object.
Blue colored section represent content of those .json files, and violet colored section explain exercises connected to those data.
Each exercise takes as an input a particular JSON array/object.
Beige colored section holds output of those exercises.

course.json file

employees.json file

students.json file

Make an Array of Strings

From course.json file use value of Students Evaluation Grade property and make an array of strings as follows:
["firstGrade/10", "secondGrade/10", . . .]

Make an Array of Objects

From course.json file use value of Students Evaluation Grade property and make an array of objects as follows:
[{grade_1: frequency}, {grade_2: frequency}, . . .]

Calculate The Average Grade

From course.json file use value of Students Evaluation Grade property and do the following statistics:
Calculate the average grade.

Total Years of Experience of All Employees

Based on information about Years of Experience of each employee from employees.json file, do the following statistics:
Calculate the total years of experience of all employees.

Total Years of Experience of Each Department

Based on information about Years of Experience and Department of each employee from employees.json file, do the following statistics:
Calculate the total years of experience of each department.

Total Number of Employees of Each Department

Based on information about Department of each employee from employees.json file, do the following statistics:
Calculate the total number of employees of each department.

Employees Classified based on Years of Experience

Based on information about Name and Years of Experience of each employee from employees.json file, do the following statistics:
Classify employees based on their personal years of experience.
There are four possible classes in which you should place all employees.
Newbie: 1 year of experience; Amateur: from 2 to 5 years of experience; Pro: from 6 to 10 years of experience; Expert: from 11 years of experience.

List of All Employees

From employees.json file use value of Name property of each employee and list all their names in an array as follows:
["name1", "name2", . . .].

Minimum and Maximum Number of Points

For each student in students.json file, write statement in which you will mentiton student's name, last name and maximum and minimum achieved number of points. It should look something like this:
Student NAME LASTNAME has achieved maximum of ___ points, and minimum of ___ points.

Reordered Number of Points

For each student in students.json file, sort number of points so that the first one to show are even, and the second one are odd. It should look something like this:
Student NAME LASTNAME has following number of points: 28, 46, 62, 71, 9, 17.

Who is the best in the tournament?

For each student in students.json file calculate total number of points achieved in the tournament. Than sort students based on their scores and give them appropriate medal.

Number of Points Greater than their Average.

For each student in students.json file filter out those number of points that are greater than their average.