COMPUTERS AND TECHNOLOGY HIGH SCHOOL

C. Following the given instructions, create a grade calculator using MS Excel. The grade calculator should allow you to enter your assignment marks/ grades and calculate your overall grade for a specific course. ∙ Create a new Excel workbook and name it "Grade Calculator."
∙ Set up the following column headers in cells A1 to C1:
∙ A1: Assignment Name, B1: Max Score, C1: Your Score
∙ In the subsequent rows, enter the names of the assignments, their maximum scores, and obtained scores.
∙ Create a formula in column D (cell D2) to calculate the percentage for each assignment using the formula: (Your Score / Max Score) * 100.
∙ Create another column (column E) and use conditional formatting to assign letter grades based on the following scale:
∙ 90 or above: A, 80-89: B, 70-79: C, 60-69: D, Below 60: F
∙ In cell E1, enter "Grade" as the column header.
∙ Calculate the overall course grade by averaging the percentages of all assignments. Place this average in cell D6 and apply appropriate formatting to display it as a percentage.
∙ Calculate the corresponding letter grade for the overall course grade in cell E6 using the same conditional formatting rules mentioned above.
∙ Save the Excel workbook with an appropriate name.

Answers

Answer 1
Answer:

Create a grade calculator in Excel: Set up columns for Assignment Name, Max Score, and Your Score. Use a formula in column D to calculate percentages. Apply conditional formatting in column E to assign letter grades. Calculate the overall course grade in cell D6 and its corresponding letter grade in cell E6. Save the workbook.

Related Questions

The first thing you must consider in any type of communication is ______.a. The type of communicationb. The style of communicationc. The purpose of the communicationd. The timing of the communication
Lenny is evaluating a presentation. Which of the following questions will Lenny ask when evaluating the presentation’s organization of content?Were the examples appropriate and easy to understand? Was the content presented in a simple manner? Were the main points and sub-points clear, and were they presented logically? Was the content made interesting with visual aids or activities? Were the transitions between sections smooth and easy to follow? Did the presenter engage the audience? Was the content presented innovatively?
Normal viewthe place where the slide order can be changed notes view the place where creating and editing occurs slide pane contains lists of commands used to create presentations menu bar provide rows of icons to perform different tasks toolbars area in which information for handouts can be added its matching
_________ is an organized portfolio of formal systems for obtaining processing and delivering information in support of the 4 operations and management of an organization. Options MIS DSS MRS None of the above
The primary benefit to the use of overlays in animation is that animators are able to

An intranet is a way for a company or organization to protect copyrighted and other important information?

Answers

Note that an intranet is a private network contained and used only by an organization.

True is your answer, for only the people who have access to it, are ablt to access the information.

hope this helps

If this is true or false, it would be true

Hope this helps

-AaronWiseIsBae

It's safe to download files from the internet if u perform regular Windows security updates, that is all u need to protect your computer from viruses? True or False

Answers

Answer

TRUE

Explanation

A computer virus is a self-replicating program which are malicious and are designed to infect and gain control over a computer without the owner's knowledge.

To protect your computer from viruses especially when downloading files from the internet, it is advisable for one to perform regular windows security updates. This is because because windows have malware definitions to its windows defender and security essential utilities.
This is True. 
If you are downloading files from the internet like videos, documents, images, or installers, your computer is at risks of malware and viruses. To avoid it, you must regularly perform Windows Security updates. These updates help resolves vulnerability issues in Windows Applications, especially in Internet Explorer. 

Forensic scientists generally photograph and sketch a computer and its components during their analysis? True or false

Answers

This is considered true sir 
Im going with true as well as he said

_____ refer(s) to computer programs that provide instructions for a computer to execute a desired task. Answer .a.Software .b. Intranet .c.Hardware .d.Extranet

Answers

Software, which contains coded information that is almost like instructions for your computer.

Answer:

Software

Explanation:

The software is an computer program.

Computers are classified by price, processing speed, capacity, anda. user friendliness.
b. use.
c. decade in which they were designed.
d. physical size.

Answers

c. decade in which they were designed

Which of the following is true of utility patents? Select one:a. They are implemented to protect intangible abstractions.
b. They are valid for the lifetime of the inventor.
c. They are used to patent machines and processes.
d. They are obtained for the ornamental nonfunctional design of an item.

Answers

Utility Patents are used to patent machines and process and it is called patents for inventions.
Other Questions
Use the information from this website to answer the question. When scientists discuss objects that might hit Earth, what term do they use to describe them as a group?
Write a program to input the day of a week and print holiday if it is Saturday
Which of the following statements comparing debit cards to credit cards is TRUE?
Inherent flaws in system software code are called:a. Logic Bomb b. Vulnerability c. Hazards d. Heuristics