In cell 2A, you will start to write the student's name.
Next to each of the student's names, you will place at least 5 grades for each of the students.
Now that you have placed at least 20 student's names and 5 grades for each student, you are now ready to input your formulas.
There are a few different ways to input the average formula.
In order to find the average, you will need to type in '=AVERAGE(B2:F2)' if the first student's name is in A2 and the first five grades are in B2 to F2. (if students name is on a different line or the grades have been placed in different cells, then the formula will not work.
In my example where the =AVERAGE(B2:F2)
line is written, that is called the formula bar. You can access this by
choosing View>Formula Bar
To copy the formulas, choose Edit from the toolbar and then select Fill>Down and this copy the formula all the way down.
To insert additional worksheets, choose Insert>Worksheet.
If you want to label your worksheet, you will want, double click the mouse on the title and proceed to label the worksheet.
To make the lines or grids show up, press the CTRL and A (pc) or Apple and A. Once your entire worksheet is highlighted, choose 'Borders' which is located near the pen on your task bar.
If you would like to know how to change the width or height of a cell, do the following...
CHANGING WIDTH & HEIGHT OF THE COLUMNS
You will also need to have a letter average for each student, so place the following formula on the same line as your first student....(hint, copy and paste this formula instead of trying to type it in and the formula starts with the equals sign and ends after the 5th parenthesis). This formula works only if your first student starts on the second row and the numeric average is in row J.
=IF(SUM(J2)>89,"A",IF(SUM(J2)>79,"B",IF(SUM(J2)>69,"C",IF(SUM(J2)>59,"D",IF(SUM(J2)>49,"F"))))
Your finished product will need to consist of the following.
1. Twenty students
2. Five grades for each students
3. Class average for the assignments
4. Students average
5. Letter grade average next to the student's numeric average
For this section, you will create a montly spreadsheet with your finances. Your document will need to have 1 full month of your choice.
You will also need to have at least 8 columns that will represent categories in which you spent money and 1 column for your deposits.
You will create a sum formula for each column at the bottom of each column
You will need to have at least 3 entries per column execpt for the Rent and Deposit column.
In the end, you will need to create a formula will sum all of your expenses and minus that to your deposit to get a difference.
In the example below, I will create some formulas for you, but this will only work if your spreadsheet is in the exact same place.
In order to get the sum of column B, the formula would be =SUM(B2:B32)
In order to get the sum of column C, the formula would be =SUM(C2:C32)
In order to get the sum of column D, the formula would be =SUM(D2:D32)
In order to get the sum of column E, the formula would be =SUM(E2:E32)
In order to get the sum of column F, the formula would be =SUM(F2:F32)
In order to get the sum of column G, the formula would be =SUM(G2:G32)
In order to get the sum of column H, the formula would be =SUM(H2:H32)
In order to get the sum of column I, the formula would be =SUM(I2:I32)
In order to get the sum of total expenses, the formula would be =SUM(B33:H33)
In order to get the diffeence, the formula would be =I34-I35
GRAPHS.
You will make a graph using a student's grades, you will need to do the following. Select a student and highlight all of his/her grades including the name of the student. You will accomplish this by starting at the cell where the student's name is located and press the mouse and keep it pressed and drag the mouse across until both student's name and all of his her grades are highlighted. Once your items are highlighted, you can take your finger off of the mouse.
While your student is selected, you will also want to highlight the grades. You can do this by pressing down the apple key and dragging your mouse across the assignments.
After both name and assignments are highlighted, you will select the 'Insert' from the toolbar and then select 'Chart.'
When you select 'Chart.' the next menu to appear will be
Select 'Finish' at the bottom and see what you have just created.
After creating the chart, you can go back and change some of the options. Play around with the different options and choose the one you like best.
Make sure your chart should has the name of the assignment
.