Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each characteristic which lists in the Guideline, please show me the step and formula. Apply your creative thinking and problem-solving skills to design and
For each characteristic which lists in the Guideline, please show me the step and formula.
Apply your creative thinking and problem-solving skills to design and implement a solution. Instructions: You are assigned to be in charge of Scholarship Fund for your school. You are given a student databased table with their GPAs and the criterion table to assign them with a letter grade. Please use formulas to calculate if they should get scholarship based on the rule of GPA 4 they will get $5000 otherwise O. Please also use assign their letter grade for on the criterion table. Once you are done with your SS data, please perform the following tasks. sorting and query SCHOLARSHIP TABLE GRADE TABLE Student ID Lname Fname GenderAgeScholarship Amount GPA Grade Grade GPA 2.15 25 23o 452618 Chucky Kate 471829Trello 0.00 F 1.00 D- 1.25 D Len 3.32 23 4.23 491827 Chan Suzy 19 521989- Counte ill 610298 Forkner Meg Lyn Julie 2.90 1.75 D+ 25 3.92 2.00 C- 28 1.15 638192.Delta 721890 Fritz 756719 Lopes 781020 Lene Sally 821928 Total 2.25 C 2.75 C+ 0.42 18 Hector 3.15 3.00 B- 25 2.77 3.25 B 3.50 B+. Janice 23 4.30 23.1 3.90 A- 4.00 A. 4.25 A+ Consider This: Plan Ahead Guidelines Grading Notes Suggested Score . Percent - 1. Create worksheet table with correctYou should create an attractive data and formatted headings worksheet that starts approximately in row 7. Headings should be formatted Using a table stvle is best, Provide conditional format for GPA column 2. Use formula to complete the Please use IF function to complete the scholarship column (if GPA is greater and equal to 4.00 scholarship, then 5000, otherwise 0. Use look 30 workbook table | complete letter grade column based on uR function to the criterion given 3. Create criteria range with headingsCriteria range should start in row 1 and 10- the headings should be identical to the table. . 4. Create extract range with headingsoExtract range should be to two rows below the criteria range. The headings should be identical to the table. 10 5. Individual Extractions. You may copy the result of the query and sorting result to a separate electronic document. . 1 sort Student by LN in Ascending order 2.select all the scholarship recipients 3.select all the students whose GPA is 20 greater than4 4.Sort students by letter grade and age in descending order 100 0 TOTALS Apply your creative thinking and problem-solving skills to design and implement a solution. Instructions: You are assigned to be in charge of Scholarship Fund for your school. You are given a student databased table with their GPAs and the criterion table to assign them with a letter grade. Please use formulas to calculate if they should get scholarship based on the rule of GPA 4 they will get $5000 otherwise O. Please also use assign their letter grade for on the criterion table. Once you are done with your SS data, please perform the following tasks. sorting and query SCHOLARSHIP TABLE GRADE TABLE Student ID Lname Fname GenderAgeScholarship Amount GPA Grade Grade GPA 2.15 25 23o 452618 Chucky Kate 471829Trello 0.00 F 1.00 D- 1.25 D Len 3.32 23 4.23 491827 Chan Suzy 19 521989- Counte ill 610298 Forkner Meg Lyn Julie 2.90 1.75 D+ 25 3.92 2.00 C- 28 1.15 638192.Delta 721890 Fritz 756719 Lopes 781020 Lene Sally 821928 Total 2.25 C 2.75 C+ 0.42 18 Hector 3.15 3.00 B- 25 2.77 3.25 B 3.50 B+. Janice 23 4.30 23.1 3.90 A- 4.00 A. 4.25 A+ Consider This: Plan Ahead Guidelines Grading Notes Suggested Score . Percent - 1. Create worksheet table with correctYou should create an attractive data and formatted headings worksheet that starts approximately in row 7. Headings should be formatted Using a table stvle is best, Provide conditional format for GPA column 2. Use formula to complete the Please use IF function to complete the scholarship column (if GPA is greater and equal to 4.00 scholarship, then 5000, otherwise 0. Use look 30 workbook table | complete letter grade column based on uR function to the criterion given 3. Create criteria range with headingsCriteria range should start in row 1 and 10- the headings should be identical to the table. . 4. Create extract range with headingsoExtract range should be to two rows below the criteria range. The headings should be identical to the table. 10 5. Individual Extractions. You may copy the result of the query and sorting result to a separate electronic document. . 1 sort Student by LN in Ascending order 2.select all the scholarship recipients 3.select all the students whose GPA is 20 greater than4 4.Sort students by letter grade and age in descending order 100 0 TOTALSStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started