Merged and centered across all columns used

Assignment Help Basic Computer Science
Reference no: EM131071285

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.

Reference no: EM131071285

Questions Cloud

Update of most of today modern browsers : With the update of most of today's modern browsers, there are several CSS3 properties that allow you to apply graphic-like rules to your HTML. Research some of these new CSS3 properties.
Bidirectional relationships between cultural-societal factor : Begin with a discussion of the historical foundations of each school of thought: psychoanalysis, behaviorism, and humanism. Be sure to include a discussion of the following:
How do principles of design contribute to communicating : How do the visual elements and principles of design contribute to communicating the message - intent of the artist(s)? What, if any, are the hidden messages, hidden agenda(s) illustrated in your chosen piece?
Application to you as a life coach : Two book reviews will be completed for two separate grades. The first book review will be over the Collins text and will be due in Week/Module 3. The second book review will be over the Grodzki & Allen text and will be due in week 5.
Merged and centered across all columns used : 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 ho..
How are the two debates similar : I need 300 words, do you see any similarities between the arguments for and against integration of psychology and theology with the argument between creationism and evolution? How are the two debates similar? If there is an apparent contradictio..
Positive and negative incentives for compliance : Class, there are both positive and negative incentives for compliance; we have talked primarily about negative incentives (fines, negilgence lawsuits, jail time).
Smallest address size that can be used : A memory is byte addressable and has a total size of 16,384 bytes. What is the smallest address size that can be used for this memory?
Calculate test statistic and find the p-value : Without assuming that the population variance is known, test the null hypothesis that the population mean weight of active ingredient per tablet is 5 grams. Use a two-sided alternative and a 5% significance level. State any assumptions that you ..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd