Use Functions and Formulas to determine data outcomes.
You work as a teacher at a private school. You teach every subject to the four students in your gifted class except for art, computers, and physical education. To help you in determining a student’s grade for a semester, you ask the art, computers, and physical education instructors to send you grades for your four students, although each data set is in a different format. The art teacher sends you a Web page from the school’s Web system. The computer teacher, who uses an Access database to maintain data, queried the database to create a table for you. The physical education teacher typed all the information in a Word table. Take the different types of data, import them into an Excel spreadsheet, and create a Grades Summary worksheet.
At the conclusion of the instructions, the Grades Summary worksheet should appear as shown in Figure below:
please see the attached file.
# 1. Unit 10 data file,#2 screen and # 12 Physical Education.
I will attached the instruction and example