XLS Grades & Attendance
About G&A
The Grades and Attendance Workbook calculates the attendance and the grades
that you enter into the workbook for one child. Excel G&A was designed for
homeschoolers who want to keep up with grades and
attendance. I actually designed this workbook for myself.
Microsoft Excel
I made the G&A files with Microsoft Excel 2002 and the files are fully compatible with MS Excel.
OpenOffice
OpenOffice, a free office software that can be downloaded from openoffice.org, will work with the Grades & Attendance files with this exception (as of 2009): In the Points Version, OpenOffice does not calculate grades when they are entered as fractions. I recommend that if you use OpenOffice, use Grades and Attendance: Whole Number or 48.
G&A Versions
It is very important to know that G&A has two versions and, this is the important part, the two versions are based on Grade Input. The versions are called Points and Whole Number. One cannot be the other, so choose which version to use first. This choice is based on how you would like to enter the grades. I will explain each one below.
Points
Points [help file] [download page]
Enter grades as a fraction, decimal, and percentage such as 33/35, 0.9, and 90%.
Points V2
Just like the one above, plus version 2 allows you to award AP or Honors quality points and also allows use to choose from two different grade scales.
Whole Number
Whole Number [help file] [download page]
Enter grades with numbers such as 87, 91.3, and 100.
48 [download page]
48 is another whole number version. It is designed for those who need a lot of room for grades, school year-round, and do not need to weigh grades.
Copyright:
The Grades and Attendance Workbook is "as is", free for personal
use, and copyrighted. The Grades and Attendance Workbook may not be
distributed in any way without permission from Donna Young. You have
permission to use the grade book for your students and you may make a copy
of the grade book for each student. You may make back-up copies of your
student's grade books. This grade book is only available from this web site
and from the author's cd-rom. Should you see it available from any other
source, please report to the author via feedback
form.
Changing The Calendar Year
I do not upload new files each year just to change the calendar year, there is no need for me to do that, remember, the files are spreadsheets, with formulas. You can change the calendar year. To change the calendar to reflect the current year, change the school year dates to your school year dates on the information tab.
See Step # 7 on Help Page
Michelle in TN commented about using G&A with Mac's Numbers.
Related Links
