Steps for Using Gradebook on MS Excel
Prior in the year I worked with Beth Melton, an Excel Microsoft Most Valuable Professional (MVP), to make a too simple and visual gradebook format in Excel 2010. It's worked for instructors with almost no Microsoft Excel involvement. Truth be told, the majority of the evaluation estimation recipes are dealt with for you. We assembled the format in Excel 2010, as a result of all the new 2010 information perception highlights. It even incorporates a printable understudy advance report!
This short video tells you the best way to download, use, and alter the format. Or on the other hand, on the off chance that you like to look over directions, search underneath for the well ordered systems.
Download the format
1. Open Excel 2010.
2. Snap the File tab.
3. Snap New.
4. In the Office.com Templates look box, type gradebook and afterward click the hunt (amplifying glass) catch.
5. Snap the Gradebook with printable understudy advance report format.
Picture of Office.com Template display in Excel 2010 behind the stage
6. In the data sheet, click Download. The layout will open as another Excel spreadsheet.
7. Snap File and afterward click Save As to spare a neighborhood duplicate of this record.
Note: You can likewise download this layout from mcafee.com/myaccount formats.
Erase placeholder information
In the wake of downloading the layout, you'll see three lines of understudy names, three sections with task names and grades, and some accommodating tips in light dark colored callouts. We added the placeholder information to the format to enable you to perceive what it should resemble. For instance, in the screen capture underneath notice how the letter evaluation and rate is determined dependent on the all out focuses conceivable and the individual understudy's absolute focuses earned.
To alter the format, you'll have to:
Peruse and afterward erase the light darker callouts.
Fill in your very own information, for example, the name of your class, your name, and the names of your understudies. To add more names to the spreadsheet, you'll need to embed more columns into the Excel table (directions underneath).
Fill in task data, for example, the task name, due date, and absolute conceivable focuses. To add more assignments to the spreadsheet, you'll need to embed more sections into the Excel table (directions underneath).
Vital: Each task has a coordinating section in the Total Possible Points table.You must keep information in no less than one understudy name push, one task name segment, and one Total Possible Points cell populated with information to save existing equations.
Add understudy name columns to the layout
Snap the column number beside the last understudy name in the Excel table.
Drag the cursor down to the column number you need to embed. For instance, in the event that you have 26 understudies in your class drag the cursor from line 7 to line 30.
Right-click the featured columns and select Insert.
Add task sections to the layout
Snap the last task name in the Excel table to choose that cell and afterward drag your cursor to one side and feature the sections you need to include. For instance, to add 3 new segments to the table, click Assignment name3 to choose that cell. At that point intuitive your cursor to segment L.
Right-click the featured lines, click Insert and select Table Columns to the Right.
Physically compute an understudy's evaluation rate
To physically compute an understudy's evaluation rate, do the accompanying:
In the line for the understudy, select cell under the rate (%) section. The equation will show up as: =IFERROR([@[Total Points Earned]]/TotalPoints,"")
Supplant TotalPoints in the equation with the new numeric passage and press Enter.
On the off chance that this is the first run through a manual change has been made to the rate sections in the exercise manual, click Undo to switch the programmed determined segment. The Undo step isn't required for resulting changes.
Note: All understudies who have manual evaluation rate computation will have a mistake pointer (green triangle) in the upper left corner of the cell. It's a smart thought to leave the blunder pointer as a visual affirmation of the change. Note that the mistake marker won't print.
Instructions to print an understudy advance report
1. From the Student Summary exercise manual, click cell B8 and utilize the drop-down bolt to choose an understudy's name. The reference chart will refresh with that understudy's evaluation information.
2. Snap the File tab on the strip.
3. Select the Print tab, and afterward click the Print catch.
On the off chance that you need to rapidly print a report for each understudy in your gradebook, open the Student Summary worksheet. In the Student Summary worksheet, click Print All.
I trust this gradebook format spares you time. Have an extraordinary 2011-2012 school year, instructors!