Question: Use the data set provided to complete the following tasks in excel. 1. Determine (using appropriate function) if student has received OSAP funding or not.
Use the data set provided to complete the following tasks in excel. 1. Determine (using appropriate function) if student has received OSAP funding or not. All students whose Student ID starts with "O" are OSAP funded students. Display "Y" for OSAP students and "N" for non-OSAP funded students 2. Display a statement (using appropriate functions in the last column). The example of final statement for the first row is as follows: Ms. Violet Clozza enrolled in Diploma in Electrical and Electronic Engineering Design and Technology with Start and End dates as Mar 06, 2017 and Mar 02, 2018, respectively. Her Program Code is 08. Ms. CLOZZA's status is Graduated Note: - You can add as many extra columns as needed - All underline text should be added using appropriate functions and will vary for each row - Program Code is the 5th & 6th characters from the left of the Student ID field - Do not convert any functions used in this exercise to Values
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
