subject

Directions: In column B, labeled ID#, assign each student a unique ID#. These numbers should start at 123 and run consecutively through 150. You should not type each number individually (use fill). If any student is missing an assignment, the cell should be red. This should update automatically (don’t manually shade it red). Calculate the current grade as a percentage. The Current grade column should only look at grades that have been submitted to the gradebook. (ignore empty cells) Note: All assignments are not equally weighted. Calculate the finale grade as a percentage. The Final grade column treats all grades as being submitted (0’s are computed for omitted work). Compute the students current letter grade. The Letter grade column is based off of the Current grade and should update automatically as assignments are graded. Report the count for how many students fall into each grade cut point. This should update automatically as grades are input. Calculate the class rank. Rank should be calculated such that each student has a unique rating based off of current grade and ties should be broken based on location. (Whatever is listed first is ranked first) Calculate Averages, ranges, and Medians for All assignments and percent grades.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 12:00
Which of these is a benefit of using objects in a powerpoint presentation? a. collaborators can create the external files while you create and edit the slide show. b. you can easily change the theme and design of the presentation. c. you can have older data in the source file while having up-to-date data in the presentation. d. collaborators can easily share the presentation.
Answers: 2
question
Computers and Technology, 24.06.2019 00:00
Afashion designer wants to increase awareness about her brand. which network can she use and why she can use the blank to blank her products online. answers for the first blank: internet, extranet, or intranet answers for the second blank: market, design, and export
Answers: 1
question
Computers and Technology, 24.06.2019 12:00
How can we take picture in this app
Answers: 1
question
Computers and Technology, 24.06.2019 22:30
To add additional commands to the quick access toolbar, a user can navigate to the view. backstage status bar design file
Answers: 2
You know the right answer?
Directions: In column B, labeled ID#, assign each student a unique ID#. These numbers should start a...
Questions
Questions on the website: 13722360