Finally! An easy to use grade book for Standards Based report cards!
Using this Excel Spreadsheet will make filling in your standards based report card grades a snap. Upon opening the file, you'll notice that the workbook is broken up into 17 worksheets (the tabs at the bottom of the workbook page). The first tab is the "Overview" tab. All your grades from each quiz, test, homework assignment, or project from all the different standards are averaged and displayed here on this one page. The setup takes very little time, and will save you headaches little in the year.
On the "Overview" page, simply fill in the information in the red cells which includes: the subject for the grade book: Math, ELA, Social Studies, etc. and the student names. You only have to enter student names once, because they'll be copied to every single page in your grade book.
Next, double click or right click and rename the worksheet (the tab at the bottom of the page) named "Standard 1" and type in the first standard on your report card. This will change the name of the tab, as well as the name of the standard on the overview page and the title at the top of the worksheet for that tab. Repeat this step for each standard on your report card. If you don't need all 15 worksheets because your report card has less than 15 standards, you can right click on the tabs of the extra pages and select "delete"
Now you're ready to go! When you give an assignment, or quiz for a particular standard, open that tab, then enter the date, the name of the assignment/quiz and enter the standards based grades (i.e.: 1-4 (or 1-5 depending on your system)).
But wait! Not all of our quizzes and assignments are out of 4 or 5 points! If this is true for many of your assignments, then you'll love the extra tab I added to this workbook.
Click on the tab titled, "Gr Conversion." Here you can use my converter to change any grade to a standards based grade. If you've given a quiz with 27 questions, enter "27" into the box labeled "number of questions." Then select the range you believe should qualify as a 5, 4, 3, 2 and a 1. If your system only goes up to a 4, then you can leave the cells for 5 blank. When entering your ranges, you don't need a percentage sign, (i.e.: type "90" for 90%). Once you've set up your conversion, just enter the number of points out of 27 that your students received on their assignment and the grades will automatically be changed to standards based grades. Once done, select the new set of standards grades, and copy them. Then click on the appropriate tab that was assessed, type in the date and the name of the assignment and then paste. When pasting, make sure you paste special: VALUES ONLY.
Throughout the year, all of your little quizzes, assignments, projects and tests will add up to give you a picture of how your students are doing. A quick look at the "Overview" tab will tell you who's doing well, and who's struggling. You'll even be able to pinpoint the standard that they are struggling with (it will be highlighted yellow or red for your benefit!).
This grade book is a perfect way to organize your data and present it to your administrator or colleagues when at IEPs, RTIs or just your common planning times.
*All tabs are protected (aka: locked) to protect the unwary user from accidentally deleting a formula. If you're comfortable with excel and need to adjust a cell width or add your own touch the password is: password.
Thank you for taking a look!