Many of you have gradebook programs and this year we will be eventually using a network gradebook.   This exercise is to help you review everything we have done.  You might need some of these concepts for other projects so hang in there.

Open the Excel Practice Workbook.  Normally you wouldn't open a file from the Internet without scanning it for viruses but we know the source. You can go back and forth between this window and the Excel workbook.  Save the worksheet as an Excel Microsoft Workbook.

In this exercise you will:
Review most of the formatting we have used.
Define more formulas
Fomat Dates
Insert and rename a worksheet
Change the order of worksheets in the navigation bar.
Protect your workbook

1. Go to the Grades worksheet.
2. Horizontally align row 1.  HOW
3. Change the font to 12 pt. for the entire sheet. HOW
4. Insert a row above row 1. Highlight row 1.  <Insert> <Row>
5. Insert a column between E and F and another between F and G
6. AutoFit the columns and rows.  HOW
7. Custom set the viewing area to include A1 to O10.  HOW
8. Formula for Averaging. Go to L3.  Average the daily grades.  =average(B3:E3)   You and click and drag on the cells to define the range.


9. Average the Chapter Test Grades
10. Formula for Weighted Averaging.  This formula says that the daily average in cell L3 is worth 40% and the test average in cell M3 is worth 60% giving a weighted total of 100%.


11. Formula to sum and average cells that are separated.  Semester grades can be figured this way.  Set the cells to average 1, 2, and 3 six-week grades together. Example:  =(B2+X2+AK2)/3 The weigted average for the grades is 0.80.  The semester test grade is weighted 0.20.  Those two added together give the semester grade.
12. Weight columns O and P to give you a Semester Grade.


13. Changing Decimals.  You can change the decimal by clicking on the <Increase Decimal> or <Decrease Decimal> in the task bar.
14. Moving rows.  Darwin was transferred.  Don't delete him - cut him.   Move the row below the last name and delete the empty row. HOW   Hide Darwin's row.   HOW.
15. Formatting Numbers.  Gradebooks need dates.  In B1 add 9/12.  This is the military format.  Highlight row 1.  <Format><Cells><Number>tab <Date> Pick a style you like.
16. Inserting worksheets.  You have five classes.  Insert additional worksheets.  <Insert> <Worksheet>
17. Right click on the worksheet tab.  Rename the worksheet.
18. Left click on the worksheet tab and you can drag it to a different location.
19. SAVING.  Save as a Microsoft Excel Workbook file format.  Choose <Options> Check <Always create backup>  Protect your file with a password you WILL NOT forget and the students will not guess.  I name my grade files with a year.  Example:  Hein99.  All the grades from both semesters and all classes are in one workbook file.


20. Format the Page Setup.  Add gridlines.  Select Landscape printing.  Set to print on one page.  Set a Header and Footer.  Set a print area.

This page was prepared by Nancy Hein, Hawley ISD, Hawley, TX
July 2000
 
 

This web site was made possible by funding through the Texas Education Agency