# BIL 101 INTRODUCTION TO COMPUTER SCIENCE HW 01 solved

\$35.00

## Description

5/5 - (1 vote)

Assume that you are the teacher of a course with 20 enrolled students and you want to report the
performance of the class. By using the grades information of your class you will make some
calculations in Excel and you will create a performance report in Word.
1. In Excel create a grades table for your class. The table will have 8 columns; the name of the
for each student.
2. In Excel, complete the following tasks by using Excel formulas:
a. Calculate the average of homework grades for each student.
b. Calculate the average grade for each homework.
table given below:
Grade = (Average of HWs) x 0,30 + Midterm x 0,30 + Final x 0,40
87-100 AA
81-86 BA
74-80 BB
67-73 CB
60-66 CC
53-59 DC
46-52 DD
39-45 FD
0-38 FF
d. Create a bar chart of the number of submissions (grades higher than 0) for each
homework.
e. Create a pie chart of letter grades: shows the percentage of students for each letter
f. Create a line chart that represents the distribution of final exam grades.
3. In Word, create a performance report written in your own words. The format of the report is
given below:
a. All the headings should be bold and should be formatted as 14 pt.
b. Font type of the report should be Times New Roman.
c. The report should have a cover with your name and the name of your course. (Be
creative!) You should create a section for the cover page.
d. All of the pages except the cover page should have top information with the name of
the course.
e. All of the pages except the cover page should have page numbers.
f. Your paragraphs should be aligned to both sides.