20 Jun 1. In this exercise, you will do a simple spreadsheet for a highly simplified version of a class gradeboo
1. In this exercise, you will do a simple spreadsheet for a highly simplified version of a class gradebook. Read this all through to the end once before you try it.
2. Start Microsoft Excel.
3. Save the spreadsheet as a file called Class Gradebook.
4. Select cells A1 through G8.
5. Select the font to Ariel and the size to 11.
6. Type Class Gradebook into cell A1. (Never mind if it "extends" into cell A2).
7. Select cells A1 through G1 – make sure they are highlighted. Merge and Center the title over that range.
8. Bold Class Gradebook and set its' font to size 18.
9. Now add some column headers – in cells A3 through G3, enter Student Test1 Test2 Homework1 Homework2 Total Average (Note that some don't quite fit, that's fine for now.)
10. Select cells A3 through G3. Find the Cells area in the ribbon at top, then find the Format area inside it. Click on Format, a menu pops down, click on Column Width and set it to 16.
11. Note how those columns just got wider.
12. Center each row 3 column header in its column and change the font of all the column headers to Courier New.
13. Change the font of the row 3 column headers you just added to Courier New.
14. Now you will add some grade data. In cells A4 through E4, enter Bill 95 87 40 45
15. Do NOT change the font or alignment, it will be different from the column headers and that's what we want.
16. In cell F4, add up cells B4 through E4 with the AutoSum function. Look in the Editing area of the ribbon.
17. Click In cell G4 and type =Average(B4:E4) then press enter. This uses the Average function to get the average.
18. Now, make up data for 3 more students, and place it in rows 5, 6 and 7.
* Max test grade is 100
* Max homework grade is 50
* First name only for the student
* Pick a variety of grades!
19. Add functions (or copy them) to get the Total and Average values for each row you added.
20. Add the text Class Average in cell F8.
21. Set cell F8 font to Courier New.
22. Use the average function in cell G8 to get the average of the 4 numbers above it.
23. Select cells G4 through G8, and set the numbers in there to all have 2 decimal points.
24. Select cells A3 through G7.
25. Select Insert on the main menu, find the charts area, and find and click on the Insert Column or Bar Chart icon. Then select the first one on the left, at the top in the 2-D Column area. It's called a Clustered Column.
26. You will see a chart pop up. Click and drag it so it's just below the table. Roughly center it.
27. Change the chart title to Class Gradebook .
28. Save your file.
29. Your project will be graded according to the following rubric:
Requirements
Max Points Possible
Table formatting correct
20
Table data correct
10
Table functions correct
20
Chart present and formatted correctly
10
Total
60
30. Review your work and make any corrections needed to get the highest score possible. Use the following image as a guide. Some items have been blocked out deliberately.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Chat with us today! We are always waiting to answer all your questions.