Excel 2

Given a spreadsheet, we were to find the average, max, min, and range of the grades, as well as determine each student's indiviual grade.

First, we found the average of the grades. By finding the average grade of the first assignment using the  average function, we could determine the averages for the rest by clicking on the handle and dragging across. This is helpful because you do not have to type or click the same function repeatively.

There is no function for range, so we made one. We typed = and then clicked on the max value, typed a minus, and clicked on the min value.

Get the average of the grades, weigh them by a quarter. Get the average of the tests and weigh them by a half. The project also gets a quarter.
To do this, we had to make a formula.

(G1+G2)/2) * .25 The first half is the average of the two. .25 to get the weighted average.
G1 & G2 will be your cell ranges.

(G1+G2)/2 * .25 + (t1+t2/2) * .5 = (P * .25) This is what we had on the board for the formula but it is not correct. The parentheses have to match up and you must change "G1",etc to cell ranges.

Next, we used the help menu to find the IF function, and we used it to determine the letter grades.

When we were finished with all this, I made the background of my table purple by highlighting everything and selecting a filler color. I made borders around every cell by highlighting them all and right clicking format cells.

This exercise is going to be extremely helpful in my future, as this will be how I will complete my gradebook.
It follows the following NETS Standards:
1. Facilitate and Inspire Student Learning and Creativity

b.	engage students in exploring real-world issues and solving authentic problems using digital tools and resources.

Using the program Excel will prove useful not only to me as a teacher but also to my students as well. For a science project, they might collect data and determine things about said data using excel.

3. Model Digital-Age Work and Learning

a.	demonstrate fluency in technology systems and the transfer of current knowledge to new technologies and situations.

Using Excel as a gradebook demonstrates fluency in technology.