COE 201 Homework Assignment 2, Fall 2017

L E B A N E S E A M E R I C A N U N I V E R S I T Y Electrical and Computer Engineering Dept COE 201 Computer Proficiency Fall 2017 Assignment 2 Question 1 Student Name Percent Grade GPA(4.0 Scale) Standing Std1 Std2 Std3 Std4 Std5 Average(4.0) Highest Grade(4.0) Lowest Grade(4.0) Standard Deviation(4.0) Number Of High Distinction(s) (4.0) 1. Rename “sheet1” as “Part 1” and replicate the above tables. 2. The shaded cells should be computed using functions. For a better understanding of the role of each function, you should consider the following:  The column GPA calculates the 4.0 scale of the Percent Grade using the following calculation scheme: GPA = ( ( Grade +10 ) / 110 ) * 4  The Standing is dependent on the value of the GPA in a way that:  Current GPA ≥ 3.8, the student will have a standing of High Distinction  Current GPA ≥ 3.5, the student will have a standing of Distinction  Current GPA ≥ 3.2, the student will have a standing of Honor  Current GPA ≥ 2.0, the student will have a standing of Good  Current GPA < 2.0, the student will have a standing of Probation  Average should compute the 4.0 scale average of all students.  Highest Grade should compute the highest grade of all students.  Lowest Grade should compute the lowest grade of all students.  Standard Deviation should compute the standard deviation of all grades.  Number of High Distinctions should count the number of high distinction students 3. Rename “Sheet 2” as “Part 2” and create the following table. 4. The shaded cells should be computed using functions which, upon entering the student name, display the corresponding GPA and Standing (according to the information filled in sheet 1) Student Name GPA( 4.0 scale) Standing Question 2 Given the following information: Name Grade Raise Final Grade Smith1 76 Smith2 46 Smith3 55 Smith4 82 Smith5 41 Smith6 66 Smith7 75 Smith8 58 Smith9 68 Smith10 71 Raise Value 2.50% Average 1. Replicate in sheet3 the above table. 2. Write the function for the Raise and Final Grade fields. 3. You need to determine the raise value that would result in an average of 75/100. (The Raise and Final Grade field should automatically change when Raise Value changes). 4. Protect the sheet by locking the Raise, Final Grade, Raise Value and Average fields. Set the password to: 123456 Question 3 1. In Sheet4 of this book, plot the function 𝑦 = 5 𝑥 𝑒tanh 𝑥on an x-axis/y-axis. Hint: the curve will look as follows. Make sure that you also change the format as shown in the figure below. . Due Date: The assignment should be submitted to Blackboard under Assignment 2 Submission panel. It is due on October 16th 11:00 pm. Late submissions will be penalized. 0 2 4 6 8 10 12 0 5 10 15 20 25 30