Learning Excel

I have to say I had an advantage with this lesson.  I am lucky enough to teach a basic Microsoft Office course at my high school. We learn Word, Access, Excel and PowerPoint.  I love teaching the class because the students learn skills today that they can apply tomorrow.  My students earn certification from Microsoft if they can pass a standardized test. That being said, I really don't know a lot of the skills beyond what I teach my students.  I never had to copy formulas across different sheets so that was interesting to learn.  I don't anticipate that I will be creating excel spreadsheets to create grades for my students.  This is all done (and is required) in our grading software at school.  I am not sure if I mentioned this in previous posts, but I am a football coach at my school and use Excel to help me break down our opponents tendencies.

You can see on 3rd and 1 and 2 they ran the ball 6 times and threw it once.  They went left 4 times and right 3 times.  They went to the field 5 times and to the boundary 2 times. You get the idea

Link to my spreadsheet


ISTE 5  Engage in professional growth.  I expanded my knowledge of Microsoft Excel.  I am looking forward to learning how to use  VLOOKUP