CIS120 Final Project Case Study Instructions Rev1 PDF

Preview

Summary

Additional information to help study for the case study that covers SOX and ISSA compliance and proper data handling and proper auditing procedures for security professionals...

Description

CIS 120 Final Project Case Study Grades Analysis Overview Please use the Excel data file to analyze the grades for students in their class. You are required to use either a formula or function to receive points for the steps. Typing in the answer is worth 0 (zero) points. Steps to complete are as following: 1.

Separate the student first name and last name into two columns. (5 points)

2.

Get the Average, Minimum, and Maximum of Test 1. (5 Points)

3.

Get the Average, Minimum, and Maximum of Test 2. (5 points)

4.

Get the Average, Minimum, and Maximum of Final Test. (5 points)

5.

Calculate the Final Average based on Test 1, Test 2, and Final Test. (5 points)

6. If the first 5 students expect to get the Final Average of 95, what would their Final Tests need to be. (10 points) 7. Assign letter grade to each student after above calculations are completed using Vlookup or Hlookup. (10 points) 8. What is the final grade distributions? In other words, how many students earned A, B, C, D, and F? Organize your data by grade in your excel sheet to show your result. (15 points) Grading scale: >= 0 and = 60 and = 70 and = 80 and = 90 and...