Since we have been discussing the benefits of Excel and spreadsheets in general, your first assignment will be based on a fictional class (former and current NFL quarterbacks), and their test scores from their Baseball 101 class. You can enter this data, or just download the file, then edit based on grade sheet. Good luck! Data for spreadsheet Test Test Test Test Test Test Test Test Test Test Test Lastname Firstname 1 2 3 4 5 6 7 8 9 10 11 Griese Bob 82 90 80 90 85 90 85 90 75 95 92 1 Unitas John 91 85 90 80 75 85 90 75 70 90 88 2 Elway John 70 90 90 80 90 70 90 75 80 83 75 3 Favre Brett 85 76 90 65 90 80 90 80 70 70 69 4 McNair Steve 75 90 75 90 75 90 80 80 72 70 69 5 Romo Tony 80 75 74 72 89 89 70 70 70 78 77 6 Palmer 65 70 75 80 85 90 85 80 75 70 50 7 Manning Archie 60 70 70 74 74 80 80 80 75 90 80 8 Marino Dan 90 90 95 95 80 80 80 80 99 70 90 9 Theisman Joe 55 60 65 70 80 80 90 90 90 90 85 10 Joe 52 45 33 100 66 75 90 81 23 100 73 11 Course Baseball 101 EDIT 4310 Exercise Grade sheet Excel Exercise 5: 50 points Grades Name Date 50 POINTS POSSIBLE TOTAL Directions: Change text to Arial Roundtop 11 pt # (5 pts): Yes (5) No (0) Align all 11 Tests to -90 (5 pts) Yes (5) No (0) Sort Worksheet by Lastname in Alphabetical Order (5 pts) Yes (5) No (0) Center All 11 tests (5 points) Yes (5) No (0) Put a double-line border around entire table (5 points): Yes (5) No (0) Renumber (5 points): Yes (5) No (0)
Since we have been discussing the benefits of Excel and spreadsheets in general, your first assignment will be based on a fictional class (former and current NFL quarterbacks), and their test scores from their Baseball 101 class. You can enter this data, or just download the file, then edit based on grade sheet. Good luck! Data for spreadsheet Lastname Firstname Test 1 Test 2 Test 3 Test 4 Test 5 Test 6 Test 7 Test 8 Test 9 Test 10 Test 11 1 Griese Bob 82 90 80 90 85 90 85 90 75 95 92 2 Unitas John 91 85 90 80 75 85 90 75 70 90 88 3 Elway John 70 90 90 80 90 70 90 75 80 83 75 4 Favre Brett 85 76 90 65 90 80 90 80 70 70 69 5 McNair Steve 75 90 75 90 75 90 80 80 72 70 69 6 Romo Tony 80 75 74 72 89 89 70 70 70 78 77 7 Palmer 65 70 75 80 85 90 85 80 75 70 50 8 Manning Archie 60 70 70 74 74 80 80 80 75 90 80 9 Marino Dan 90 90 95 95 80 80 80 80 99 70 90 10 Theisman Joe 55 60 65 70 80 80 90 90 90 90 85 11 Joe 52 45 33 100 66 75 90 81 23 100 73 Course Baseball 101 EDIT 4310 Exercise Grade sheet Excel Exercise 5: 50 points Grades Name Date 50 POINTS POSSIBLE TOTAL Directions: Change text to Arial Roundtop 11 pt # (5 pts): Yes (5) No (0) Align all 11 Tests to -90 (5 pts) Yes (5) No (0) Sort Worksheet by Lastname in Alphabetical Order (5 pts) Yes (5) No (0) Center All 11 tests (5 points) Yes (5) No (0) Put a double-line border around entire table (5 points): Yes (5) No (0) Renumber (5 points): Yes (5) No (0)
EDIT4310VC01.docx