Excel is a great way to keep track of grades. I actually keep track of my grades for grad school in an Excel spreadsheet.
I have each class as its own worksheet within a workbook. I have forumulas which calculate the total number of points earned divided by the total number of points available. When I put my grade in for a particular assignment, it tallys automatically as I enter data.
I took this one step further and have a Summary page which pulls the final grade from the corresponding worksheet and calculates my letter grade. Then, it averages out my total grade point average for me. It took a little time to add the formulas and make the individual spreadsheets, but now it's a breeze. All I do now is add my grades for my assignments; everything tallys automatically.
I always know where I am as far as grade point average, etc...
I also keep track of the hours I work throughout the year. I have a master spreadsheet in which I input the time I arrive, take lunch, come back from lunch and leave work. The hours I work that day are tallied via a formula as well as another formula which calculates how many hours I worked for the entire week. Even further, a formula calculates my hours worked against a 40-hour week to give me a calculation of whether I've worked over or under my hours. (This is usually over - guess I love work).
So Excel is in my life every day and I love it!
“Excel is a great way to keep track of grades” This statement is so true for a classroom teacher. It is a good feeling to know that you can back up why a student is not doing well in your class with a spreadsheet.
ReplyDelete“Summary page which pulls the final grade from the corresponding worksheet and calculates my letter grade.” I like this idea of a summary page, it would make calculating the student’s final grades a lot easier if they were all on one page.
“I also keep track of the hours I work throughout the year.” What a clever why to use Excel. I never thought to use it for hours worked; I only have used it for calculating grades.
Gina M.
Sounds like you are a very organized person. I like that you are keeping track of your work hours. Are you a teacher? That information would be really useful in someone's research on teacher commitment or how much they work beyond contract hours.
ReplyDeleteAaron Huestis
I am not a teacher yet although I have assisted in instruction with other professors. I am a Multimedia Systems Analyst in the Technology Department. Many of the projects on which I work take organization plus I was just born and raised with organizational skills.
ReplyDelete