Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

Design a workbook named semester_LastNameFirstName to help you track your previous semester courses and GPA.

  • Your name should list in cell A1 in an enlarged font size with a new font name merged and centered across all columns used.
  • Display in a labelled cell the current GPA.
  • Include column headings for the course name, course credit hours, letter grade, numerical grade, and quality points.
  • Format the column headings row with a border and each entry boldfaced and center-aligned in its cell.
  • Include at least three rows of data so make up courses if need be.
  • Create a lookup table somewhere on the sheet listing the letter grades and their numerical equivalent using data shown below.
  • Use the VLOOKUP function to compute the numerical grade for each course based upon the letter grade.
  • Compute quality points as credit hours times the numerical grade (ex. B+ grade on a 4 credit course yields 3.33 * 4 = 13.32 quality points).
  • Under the rows compute the sum of credit hours and the sum of quality points.
  • Somewhere on the sheet display the semester GPA computed as sum of quality points divided by the sum of credit hours.
  • Use an IF function to display a message whether this semester you increased or decreased GPA from the current GPA listed on top of the sheet.
  • Use two decimal places on all GPA-related values.
  • Rename Sheet1 appropriately and delete unused sheets.
  • Your workbook must be unique and reflect your own data and design.

Letter grades use the following numerical values:
A = 4.00 A- = 3.67 B+ = 3.33 B = 3.00 B- = 2.67 C+ = 2.33 C = 2.00 C- = 1.67 D+ = 1.33 D = 1.00 D- = 0.67 F = 0.00 

I took six classes last semester. Bua 202 (A), Cmj 314 (A), Cmj 483 (A), Bua 325 (B+), Bua 270 (B-). Ast 110 (C-), only Ast is one credits the rests are 3 credits hour class.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M91795649
  • Price:- $30

Priced at Now at $30, Verified Solution

Have any Question?


Related Questions in Computer Engineering

Question suppose you are asked to automate the prescription

Question : Suppose you are asked to automate the prescription fulfillment system for a pharmacy, MailDrugs. When an order comes in, it is given as a sequence of requests, "x1 ml of drug y1," "x2 ml of drug y2," "x3 ml of ...

Question suppose we iterate the application of a blurring

Question : Suppose we iterate the application of a blurring filter with kernel size 5 on an image of 800 times 600 pixels. How many times should we apply the filter for the color of the pixel at position (20, 20) to be i ...

Can someone help me with this java problem and explain the

Can someone help me with this Java problem and explain the parts please! Write a method "totalDays" that takes three integer arguments (number of weeks, number of days, number of hours) and returns the total real number ...

Remember all of the following steps when showing that a

Remember all of the following steps when showing that a problem D is NPcomplete: 1. Show that D is in NP by briefly explaining how to quickly verify a solution to it. 2. Choose another problem Q that is known to be NP-ha ...

Iq test scores of students are normally distributed with

IQ test scores of students are normally distributed with mean μ=100 and standard deviation σ=10. What is the 33th percentile of the IQ scores? For a randomly chosen student, what is the probability that his or her IQ sco ...

Assignment -note in your assignment how you arrived at your

Assignment - Note: In your assignment, how you arrived at your solution is as important (if not more so) than the solution itself and will be assessed accordingly. There may be more than one way to find a solution, and y ...

Sql database designstore a is a local bookstore store a has

SQL DATABASE DESIGN Store A is a local bookstore. Store A has been able to withstand the challenges of larger bookstore chains, as well as the internet giant Amazon, by offering new and used books and other products in a ...

You are requested to design an information technology

You are requested to design an Information Technology Infrastructure for an international nonprofit organization. The organization has six offices, one each in Ohio, Kentucky, Toronto, Michigan, Chicago, and Indiana. Col ...

Arectangular box without a top has surface area 2500 cm2

A rectangular box without a top has surface area 2500 cm 2 . The length x of its base is 18 cm longer that its width. • (a) Use MATLAB's polynomial functions to express the volume V of the box in terms of x. • (b) Plot V ...

Why should one listen to peter drucker in other words what

Why should one listen to Peter Drucker? In other words, what are his credentials/expertises? Provide at least three reasons. Copy question to the beginning of answer.

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As