Excel 365/2021 | Module 7: SAM Critical Thinking Project 1c |Valerian State College #newperspectives

Excel 365/2021 | Module 7: SAM Critical Thinking Project 1c |Valerian State College #newperspectives

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:

Whatsapp Number:
[phone]
[phone]

Gmail Id:

PROJECT STEPS
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 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 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 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 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 more than 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 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.

new perspectives excel 365/2021, module 7 sam critical thinking project 1c, valerian state college undefined project, new perspectives excel 365/2021 module 7 sam critical thinking project 1c, module 7 sam critical thinking project 1c valerian state college, valerian state college sam project module 7, shelly cashman excel 365/2021 module 7 sam critical thinking project 1c, shelly cashman excel 365/2021, excel 365/2021 module 7 sam critical thinking project 1c, Module 8-11 sam capstone project 1b, Module 8-11 sam capstone project 1c, Module 6 textbook project