Grade Calculator (Mac 2016 Version)

User Generated

794Gevtb

Business Finance

Johnson Wales University

Description

The workbook for this project generates a grade calculator. In this project, you will create a grade

calculator to determine your grade for an exam. Once created you can use it for any exam you take in the

future.

Unformatted Attachment Preview

Excel 2016 Grade Calculator (Mac 2016) Grade Calculator (Mac 2016 Version) The workbook for this project generates a grade calculator. In this project, you will create a grade calculator to determine your grade for an exam. Once created you can use it for any exam you take in the future. Skills needed to complete this project: • Working in Protected View • Navigating a Workbook • Entering and Editing Text and Numbers in Cells • Applying Number Formats • Inserting Data Using AutoFill • Understanding Absolute and Relative References • Entering Simple Formulas 1. Open the start file EX2016-Grade-Calculator. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor and save it. 2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it. 3. Merge cells and center a title: a. Make cell A1 active by clicking in it. (A1 is considered the home position which means wherever you are at on the spreadsheet, you can simply click on the keyboard shortcut fn + command + left arrow keys to get to the A1 position). b. Highlight cells A1 through C1. This is usually depicted as A1:C1 in instructions. The cursor must look like to highlight. Click and hold and drag to the next cell. c. While A1:C1 are still selected, click on the HOME tab, and in the Alignment Grouping locate the Merge & Center button. Click it. 4. Enter the following in cell A3. a. Make cell A3 active. b. Type Number of Questions 5. Enter the following in cell C3. a. Make cell C3 active. b. Type 100 6. Enter the following in cell A5. a. Make cell A5 active. Page 1 Last Updated 3/5/2018 Excel 2016 Grade Calculator (Mac 2016) b. Type Wrong 7. Enter the following in cell B5. a. Make cell B5 active. b. Type Score 8. Enter the following in A6 and A7. a. Make cell A6 active. b. Type 1 and then press enter. c. Make cell A7 active (you could press enter after you typed in cell A6 or click to make cell A7 active). d. Type 2 and then press enter. 9. Next, we will make a sequence of numbers down column A. a. Highlight cells A6:A7. Remember the symbol for highlighting. b. Using the autofill (move your mouse to the lower right side of cell A7, the mouse will look like this +. It is called the autofill handle) click and drag down to cell A24. You should see numbers 0 thru 19. This is called a sequence. 10. The next item is to write a formula to calculate a grade as a percent. a. Highlight cell B6. b. A formula always starts with the equal sign = c. Type = d. The formula is cell C3 (100 - which is the number of questions) minus the number of wrong answers which is cell A6 but then we need to divide that number by the total number of questions. The formula uses Absolute cell references whenever the cell C3 is used because we don’t want it to change like the other cells (which are considered Relative cell values). Excel follows the same order of operation rules as Algebra. e. The formula should look like this: =($C$3-A6)/$C$3 then press enter. You will see only the answer in the cell which is 0.99. 11. Next, we will use the autofill handle on cell B6 and copy the formula down to B24. a. Highlight cell B6. b. Locate the autofill handle which will be in the lower right corner of the cell. Remember the mouse will look like •. Page 2 Last Updated 3/5/2018 Excel 2016 Grade Calculator (Mac 2016) c. Click and hold (when you see the symbol above) and double click. Another way is to click hold and drag it down to cell B24. d. You should see all the scores now. 12. Now we will apply the number format to percentage to the score column. a. Highlight cells B6:B24. b. Once highlighted, click on the Percent sign % on the Home tab in the Number Grouping. c. The scores should now show as percent with zero decimals. 13. So now you see all the scores you will get if you have 100 questions. Let’s look at this same scenario with 30 questions. You will only need to change one number of this spreadsheet. a. Highlight cell C3. b. Type 30 and press enter. c. Did you see how the scores changed? d. Highlight cell C3 again. e. Type 25 and press enter. f. Did you see how the scores changed? NOTE: For correct grading in SIMnet, be sure to leave the value 25 in cell C3. 14. Save and close the workbook. 15. Upload and save your project file. 16. Submit for grading. Page 3 Last Updated 3/5/2018 Excel 2016 Grade Calculator (Mac 2016) Grade Calculator (Mac 2016 Version) The workbook for this project generates a grade calculator. In this project, you will create a grade calculator to determine your grade for an exam. Once created you can use it for any exam you take in the future. Skills needed to complete this project: • Working in Protected View • Navigating a Workbook • Entering and Editing Text and Numbers in Cells • Applying Number Formats • Inserting Data Using AutoFill • Understanding Absolute and Relative References • Entering Simple Formulas 1. Open the start file EX2016-Grade-Calculator. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor and save it. 2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it. 3. Merge cells and center a title: a. Make cell A1 active by clicking in it. (A1 is considered the home position which means wherever you are at on the spreadsheet, you can simply click on the keyboard shortcut fn + command + left arrow keys to get to the A1 position). b. Highlight cells A1 through C1. This is usually depicted as A1:C1 in instructions. The cursor must look like to highlight. Click and hold and drag to the next cell. c. While A1:C1 are still selected, click on the HOME tab, and in the Alignment Grouping locate the Merge & Center button. Click it. 4. Enter the following in cell A3. a. Make cell A3 active. b. Type Number of Questions 5. Enter the following in cell C3. a. Make cell C3 active. b. Type 100 6. Enter the following in cell A5. a. Make cell A5 active. Page 1 Last Updated 3/5/2018 Excel 2016 Grade Calculator (Mac 2016) b. Type Wrong 7. Enter the following in cell B5. a. Make cell B5 active. b. Type Score 8. Enter the following in A6 and A7. a. Make cell A6 active. b. Type 1 and then press enter. c. Make cell A7 active (you could press enter after you typed in cell A6 or click to make cell A7 active). d. Type 2 and then press enter. 9. Next, we will make a sequence of numbers down column A. a. Highlight cells A6:A7. Remember the symbol for highlighting. b. Using the autofill (move your mouse to the lower right side of cell A7, the mouse will look like this +. It is called the autofill handle) click and drag down to cell A24. You should see numbers 0 thru 19. This is called a sequence. 10. The next item is to write a formula to calculate a grade as a percent. a. Highlight cell B6. b. A formula always starts with the equal sign = c. Type = d. The formula is cell C3 (100 - which is the number of questions) minus the number of wrong answers which is cell A6 but then we need to divide that number by the total number of questions. The formula uses Absolute cell references whenever the cell C3 is used because we don’t want it to change like the other cells (which are considered Relative cell values). Excel follows the same order of operation rules as Algebra. e. The formula should look like this: =($C$3-A6)/$C$3 then press enter. You will see only the answer in the cell which is 0.99. 11. Next, we will use the autofill handle on cell B6 and copy the formula down to B24. a. Highlight cell B6. b. Locate the autofill handle which will be in the lower right corner of the cell. Remember the mouse will look like •. Page 2 Last Updated 3/5/2018 Excel 2016 Grade Calculator (Mac 2016) c. Click and hold (when you see the symbol above) and double click. Another way is to click hold and drag it down to cell B24. d. You should see all the scores now. 12. Now we will apply the number format to percentage to the score column. a. Highlight cells B6:B24. b. Once highlighted, click on the Percent sign % on the Home tab in the Number Grouping. c. The scores should now show as percent with zero decimals. 13. So now you see all the scores you will get if you have 100 questions. Let’s look at this same scenario with 30 questions. You will only need to change one number of this spreadsheet. a. Highlight cell C3. b. Type 30 and press enter. c. Did you see how the scores changed? d. Highlight cell C3 again. e. Type 25 and press enter. f. Did you see how the scores changed? NOTE: For correct grading in SIMnet, be sure to leave the value 25 in cell C3. 14. Save and close the workbook. 15. Upload and save your project file. 16. Submit for grading. Page 3 Last Updated 3/5/2018
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

1

Grade Calculator (Mac 2016 Version)
Student name:
Institutional affiliation:

2
Gr...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags