[Solved] Office 2016 Myitlab Grader Instructions Excel Project Excel Ch 7 Post Lab 12 Part 1 2 Proj Q37198114
Office 2016 myitlab:grader Instructions Excel Project Excel Ch 7 – Post-Lab 12 Part 1/2 Project Description: You work in the Admissions Office for West Coast University, a mid-sized regional university in California. Your assistant entered a list of college applicants for the Fall 2015 semester. You determine if a student qualifies for early admission or early rejection based on SAT and GPA. After determining the immediate admissions and rejections, you calculate a total score based on SAT and GPA to determine regular admissions and rejections Instructions: For the purpose of grading the project you are required to perform the following tasks Points Possible Step Instructions Open exploring e07_grader h2_Admissions.xisx and save it as exploring e07 grader h2 Admissions LastFirst. 0.000 Enter a nested logical function in the Admit Early column F17) to display either Yes or No. The university admits a student carly if that student mects both the carly admission critcria for the SAT and GPA. That is, the student’s SAT score must be 2000 or higher, and the GPA must be 3.80 or higher. Use appropriate references to the cells in the Admission Criteria range. Based on the requirements, the first student, Julie Alevy, will be admitted early 10.000 2 Enter a nesled logical Tunction in the Reject Early column (in G17) to display either Yes or No. The university rejects a student carly if that student has cither an SAT score less than 1000 or a GPA below 1.80. Use appropriate references to the cells in the Admission Criteria range 10.000 Enter a formula in the Score column in H17) to calculatc an applicant’s admission score. Apply thc multiplier (found in the Miscellaneous Standards & Filter range) to the student’s GPA and add that score to the SAT. Julic Alevy’s score is 4700. 4 10.000 Enter a nested IF function inside a main IF function in the Final Decision column (in 117). The decision text should be one of the following: Early Admission, Early Rejection, Admit, or Reject. Hint: Two logical tests are based on the Yes No displayed in the Admit Early and Reject Early columns. For regular admission, a student must have a combined admission score that is 2900 or higher. A student is rejected if his or her score is lower than the threshold. Use appropriate references to the cells in the Miscellaneous Standards& Filter ran 10.000 5 12.000 6 Copy the formulas down the Admit Early, Reject Early, Score, and Final Decision columns. In cell F7, cnter a databasc function to count the total number of carly admissions withthreshold scores. Use the criteria in cells K6:L7 in your function. 10.000 7 In cell F8, enter a database function to count the total number of in-state early admissions. Use cell refcrences from the Criteria range in your function. 10.000 8 Enter database functions to calculate the avcrage SAT (cell G7) and GPA (cell H7) for all carly admits with admissions scores at or above the threshold. Note that you cannot merely average the existing avcrages bccausc the counts are diffcrent for Early Admits and Regular Admits. You can usc thc database function without performing an advanced filter with an output range (use cell references from the Criteria ra in 12.000 9 r function Current Instruction.docx Updated: 11/15/2016 Office 2016 myitlab:grader Instructions Excel Project Points Possible Step Instructions In cell H8, calculate the avcragc GPA for all in-state carly admits (usc cell refcrences from the Criteria range in your function). 10 10.000 Create a footer with your name on the left side, Page 1 of? codes in the middle, and the file name code on the right side. 6.000 12 Save and close the workbook, and submit the file as directed. 0.000 Total Points100.000 Current Instruction.docx Updated: 11/15/2016 x Applications for Fall 2015 Admssio West Coast University Admissions Office lications for Fall 2015 Admission Eary Admit Early Reject Description SAT Average GPA Threshold eaty admission scores State eary admssion n State Mscelaneous Standards& Fiter 4.00 4.00 4.00 4.00 Bridgette 而丙匹 ,6 v’ Application, for Fall 201 Admi5sinn .00 3 45 3 e8 3 50 3 50 n Sale Show transcribed image text Office 2016 myitlab:grader Instructions Excel Project Excel Ch 7 – Post-Lab 12 Part 1/2 Project Description: You work in the Admissions Office for West Coast University, a mid-sized regional university in California. Your assistant entered a list of college applicants for the Fall 2015 semester. You determine if a student qualifies for early admission or early rejection based on SAT and GPA. After determining the immediate admissions and rejections, you calculate a total score based on SAT and GPA to determine regular admissions and rejections Instructions: For the purpose of grading the project you are required to perform the following tasks Points Possible Step Instructions Open exploring e07_grader h2_Admissions.xisx and save it as exploring e07 grader h2 Admissions LastFirst. 0.000 Enter a nested logical function in the Admit Early column F17) to display either Yes or No. The university admits a student carly if that student mects both the carly admission critcria for the SAT and GPA. That is, the student’s SAT score must be 2000 or higher, and the GPA must be 3.80 or higher. Use appropriate references to the cells in the Admission Criteria range. Based on the requirements, the first student, Julie Alevy, will be admitted early 10.000 2 Enter a nesled logical Tunction in the Reject Early column (in G17) to display either Yes or No. The university rejects a student carly if that student has cither an SAT score less than 1000 or a GPA below 1.80. Use appropriate references to the cells in the Admission Criteria range 10.000 Enter a formula in the Score column in H17) to calculatc an applicant’s admission score. Apply thc multiplier (found in the Miscellaneous Standards & Filter range) to the student’s GPA and add that score to the SAT. Julic Alevy’s score is 4700. 4 10.000 Enter a nested IF function inside a main IF function in the Final Decision column (in 117). The decision text should be one of the following: Early Admission, Early Rejection, Admit, or Reject. Hint: Two logical tests are based on the Yes No displayed in the Admit Early and Reject Early columns. For regular admission, a student must have a combined admission score that is 2900 or higher. A student is rejected if his or her score is lower than the threshold. Use appropriate references to the cells in the Miscellaneous Standards& Filter ran 10.000 5 12.000 6 Copy the formulas down the Admit Early, Reject Early, Score, and Final Decision columns. In cell F7, cnter a databasc function to count the total number of carly admissions withthreshold scores. Use the criteria in cells K6:L7 in your function. 10.000 7 In cell F8, enter a database function to count the total number of in-state early admissions. Use cell refcrences from the Criteria range in your function. 10.000 8 Enter database functions to calculate the avcrage SAT (cell G7) and GPA (cell H7) for all carly admits with admissions scores at or above the threshold. Note that you cannot merely average the existing avcrages bccausc the counts are diffcrent for Early Admits and Regular Admits. You can usc thc database function without performing an advanced filter with an output range (use cell references from the Criteria ra in 12.000 9 r function Current Instruction.docx Updated: 11/15/2016
Office 2016 myitlab:grader Instructions Excel Project Points Possible Step Instructions In cell H8, calculate the avcragc GPA for all in-state carly admits (usc cell refcrences from the Criteria range in your function). 10 10.000 Create a footer with your name on the left side, Page 1 of? codes in the middle, and the file name code on the right side. 6.000 12 Save and close the workbook, and submit the file as directed. 0.000 Total Points100.000 Current Instruction.docx Updated: 11/15/2016
x Applications for Fall 2015 Admssio West Coast University Admissions Office lications for Fall 2015 Admission Eary Admit Early Reject Description SAT Average GPA Threshold eaty admission scores State eary admssion n State Mscelaneous Standards& Fiter 4.00 4.00 4.00 4.00 Bridgette 而丙匹 ,6 v’ Application, for Fall 201 Admi5sinn .00 3 45 3 e8 3 50 3 50 n Sale
Expert Answer
Answer to Office 2016 myitlab:grader Instructions Excel Project Excel Ch 7 – Post-Lab 12 Part 1/2 Project Description: You work in… . . .
OR
