1 / 11

Weighted Grade Calculator

Weighted Grade Calculator. BY: BILGUUJIN DORJSUREN, KATHERINE WORONOWICZ, KELLY CANALES, NISSI DAVID, AND SYLVIA CHENG ENGLISH 393: TECHNICAL WRITING MAY 10, 2011. INTRODUCTION. Excel is a spreadsheet program made and distributed by Microsoft that can be used in numerous different ways.

jorden-kirkland
Download Presentation

Weighted Grade Calculator

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Weighted Grade Calculator BY: BILGUUJIN DORJSUREN, KATHERINE WORONOWICZ, KELLY CANALES, NISSI DAVID, AND SYLVIA CHENG ENGLISH 393: TECHNICAL WRITING MAY 10, 2011

  2. INTRODUCTION • Excel is a spreadsheet program made and distributed by Microsoft that can be used in numerous different ways. • The most common usage of excel is to organize data, make charts, and run statistical analysis. • Anyone can use Excel. • In this presentation, we will be showing how to make a weighted grade calculator. • To do this process, you will need a computer with the excel program installed.

  3. STEP 1. Label the rows with the proper headings as listed: a. A2: Item b. B2: Worth c. C2: Points received d. D3: Total points possible for assignment (Out of) e. E2: Grade Revised f. F2: Weighted

  4. STEP 2. Label the Columns from A3 downward with the appropriate assignments and one cell labeled “Total” Ex: a. A3: Exam 1 b. A4: Exam 2 c. A5: Exam 3 d. A6: Final e. A9: Total

  5. STEP 3 In columns B3-B6 (Exam 1-Exam 4) insert the percent weighted as listed in the syllabus as a decimal a. In the column B9, enter the equation =SUM (B3:B6)

  6. STEP 4 In columns C3-C6 enter the point received on an assignment

  7. STEP 5 In columns D3-D6 enter the total points possible for the corresponding assignment

  8. STEP 6 In columns E3-E6: enter a division function for each row of assignments by dividing cells in column C by cells in column D a. E3:= C3/D3 b. E4: =C4/D4 c. E5: =C5/D5 d. E6: =E5/E6

  9. Step 7 In column F, enter the function B*E for each row of assignments a. F3: =B3*E3 b. F4: = B4*E4 c. F5: = B5*E5 d. F6: = B6*E6

  10. Your Grade! Step 8 In cell F9: insert another SUM function from the range of F3-F6 a. F9:= SUM(F3:F6) * 100 b. Here your final grade will appear

  11. QUESTIONS?

More Related