Question: 1 . Determine ( using appropriate function ) if student has received OSAP funding or not. All students whose Student ID starts with O
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 nonOSAP funded students
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 and Mar respectively. Her Program Code is 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 th & th characters from the left of the Student ID field
Do not convert any functions used in this exercise to Values
Submit your final excel files on CANVAS.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
