Question: 1 . Determine ( using appropriate function ) if student has received OSAP funding or not. All students whose Student ID starts with O

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
- 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!