Hire Me For Complete Course
For Help Contact Me on
WhatsApp Number : +994 40 158 33 14
Whatsapp Link : wa.link/fvv75z
#ValerianStateCollege
#NewPerspectivesExcel2019
#Module7
#SAMCriticalThinkingProject1c
#samproject1a
#samproject
#SamAssignment
#np_ex19_7a c
#NP_EX19_7c_FirstLastName
#NP_EX19_7c_FirstLastName_1
#NP_EX19_7c_FirstLastName_1.xlsx
#NP_EX19_7c
#NP_EX19_7c_FirstLastName_2
#NP_EX19_7c_FirstLastName_2.xlsx
#StudentRepresentativesWorksheet
#AcademicGroupsWorksheet
#AcademicPivotTableWorksheet
#AllGroupsWorksheet
#AllGroupsPivotTableWorksheet
#ActivitiesPivotTableWorksheet
1. Lael Masterson works in the Student Activities Office at Valerian State College in Illinois. Lael has started compiling information on students who are interested in helping run student organizations at Valerian State, and she needs your help completing the workbook.
Switch to the Student Representatives worksheet. Determine the base rate for the first student (which is based on the student's number of years of post-secondary education) using a function as follows:
a. Use a structured reference to look up the value in the Post-Secondary Years column. Retrieve the base rate in the table showing the base rate by post-secondary years. The formula should always use the exact range and find an approximate match.
b. Fill the function to the rest of the column, if necessary.
2. Student organizations sometimes require transportation for off-campus activities, and school policy requires students to be over 23 years old to serve as transport. Lael wants to determine how many of the active students will be eligible to transport other group members. Populate the Qualified Driver column as follows:
a. Enter a function and structured references to determine if the first student is a qualified driver. Display Yes if the student is older than 23; if not, display No.
b. Fill the function to the rest of the column, if necessary.
3. To be eligible for the leadership training program offered by the Student Activities Office, a student must have at least two years of post-secondary education or have gone through the organization finance training. Populate the Leadership Training column as follows:
a. Enter a formula using nested functions and structured references to determine if the first student is eligible for the leadership training program. Display Yes if one or both of the criteria are met. Display No if a student meets neither of the criteria.
b. Fill the formula to the rest of the column, if necessary
4. Experienced students may serve as mentors if they are at least age 21 and have at least three years of post-secondary education. Populate the Mentor column as follows:
a. Enter a formula using nested functions and structured references to determine if the first student is eligible to serve as a mentor. Display Yes if both of the criteria are met. Display No if a student meets none or only one of the criteria.
b. Fill the formula to the rest of the column, if necessary.
5. Lael is always on the lookout for qualified students who might be interested in running for office in student groups. A student is qualified to be an officer if they have already been elected to office in a student group; and if they have not, they are qualified if they have been certified financially. Populate the Officer Qualified column as follows:
a. Enter a formula using nested functions and structured references to determine if the first student is qualified to be an officer. If the student has been previously elected (i.e., "Yes" displays in the Elected column), display Elected.
b. Otherwise, if the student is "Finance Certified", display Yes; if not, display No.
c. Fill the formula to the rest of the column, if necessary.
6. Students who work with student organizations are also considered for employment at the Student Activities Office. Students with at least four years of post-secondary education are qualified for more complex Tier 2 jobs. Populate the final column as follows:
a. Enter Tier as the final column heading.
b. Enter a function and structured references to determine the work tier of the first student. If the student has completed at least four post-secondary years, display 2; if not, display 1.
c. Fill the function to the rest of the column, if necessary.
7. To the right of the large table, Lael has made a quick way to look up a student's name by their Student ID number. To make sure that the cell always displays a meaningful message, nest the existing function in another function to display Invalid Student ID if the VLOOKUP function returns an error result.
8. Lael wants to determine several totals and averages for active students. In the appropriate cell, enter a function and structured references to count the total number of students if they have been elected to offices in student organizations.
Негізгі бет Valerian State College | Module 7 | SAM Critical Thinking Project 1c | New Perspectives Excel 2019
Пікірлер