Packing Slip

item	Let Excel Track Your Attendance for You!!
contact	Mary McGlasson (Chandler-Gilbert Community College) mary.mcglasson@cgcmail.maricopa.edu 1 of 42 packages by Mary McGlasson
credits	Jim McGlasson
college(s)	Chandler-Gilbert Community College
discipline(s)	Any subject
summary	Okay, so it's not very exciting, but let's face it -- tracking student attendance over the course of the semester isn't a lot of fun. This spreadsheet allows you to enter the day's attendance, then calculates number of absences. PLUS, if you have attendance points in your grade, it will feed those point totals right into your grade roster for you!
details	Tracking student attendance is no fun, but it is necessary for both the institution and, since I include attendance points as a (small) part of the course grade, for myself as well. I think that my husband took pity on me when he saw me counting up the number of absences for my 5 classes one day, so he wrote up an excel formula to do the counting for me. Then when he saw me copying and pasting those numbers into my grade roster, he linked my worksheets together so that the attendance points would feed right into the grades. Cool, huh? Attached is the template for my gradebook that contains 3 worksheets: Attendance, grades, and phone list. It will: (1) keep tally of the number of absences (it looks for an "A" in the attendance column) (2) fill in all the dates for the semester; all you have to do is type in the initial class date (the formula is set up to calculate the dates for 2-day-per-week sessions, all you do is put in the date of the first Monday or Tuesday of the semester) (3)feed the attendance information directly into the "grades" worksheet AND . . . (4) if you type your students' names into the attendance worksheet at the beginning of the semester, it will automatically feed those names into the "Grades" and "Phone list" rosters. Use as much or as little of this spreadsheet as you like; it's the attendance tally (and the student name piece) that has proven most useful to those I've shared it with. Note! As a professional courtesy to the owner of this package, if you use some aspect of this package or have some thoughts about it, please share your feedback via the comments form below.
supplements	These items are licensed under a Creative Commons License Gradebook template (spreadsheet) Grades-template.xls (96.0 kB) Note! As a professional courtesy to the owner of this package, if you use some aspect of this package or have some thoughts about it, please share your feedback below.
comments [5 comment(s)]	Most recent comment about this package: On Mon Mar 20, 2006 at 1:16AM President Of Case BDS <sapientmoxie@gmail.com> said: Amazing... This will be utilized to your recognition for our Ballroom Dance Lessons here @ Case Western Reserve University. Thank you for posting it!
shareback [1 shareback(s)]	A "Shareback" cites the places on the web that mention, reference, or use this MLX package, and "shares" that information back here (more about shareback...) Most recent shareback for this package: MLX Happenings cited Sun Feb 15, 2004 at CogDogBlog A few interesting things shaking out over at the Maricopa Learning eXchange. A faculty member who coordinates service learning projects at his college got the idea about using an MLX special collection to have a convenient way of organizing the... Sharebacks can be generated automatically by weblog tools.
extra	Last modified: Feb-12-2004 Date created: Feb-12-2004 Visitor count: 6877 Dublin Core Metadata record This package is included in the Chandler-Gilbert Instructional Technology Packages special collection.