Microsoft KB Archive/252982

= Works: How to Create a Grade Book Spreadsheet Template =

Article ID: 252982

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 6.0
 * Microsoft Works Suite 2000
 * Microsoft Works Suite 2001

-



This article was previously published under Q252982



SUMMARY
This article describes how to create a grade book template using Microsoft Works Spreadsheet.

NOTE: Grade book templates are included in Microsoft Works 4.x, but are not included in Works 2000 Spreadsheet or later.



MORE INFORMATION
To create a grade book template in Works Spreadsheet, use the following methods in the order in which they are presented.

Create a Grade Book Design in Works Spreadsheet
To create a grade book design in Works Spreadsheet:
 * 1) Start Works Task Launcher.
 * 2) Click the Programs tab, click Works Spreadsheet, and then click Start a blank Spreadsheet.
 * 3) In the first row, type the headers or titles of the columns, such as "Student Name," "Date," and "Grade."
 * 4) Type the information for each student in each row.

Calculate the Grade Averages
To calculate the grade averages:
 * 1) On the Tools menu, click Easy Calc.
 * 2) Under Common calculations, click Average.
 * 3) Click and drag to select the range of cells in the spreadsheet that contain the grades that you want to average, and then click Next.

NOTE: You may need to move the Easy Calc dialog box away from the range of cells that you want to select.
 * 1) Click the cell in which you want the result to be calculated.
 * 2) Click Finish.

Save the Grade Book Spreadsheet As a Template
To save the grade book spreadsheet as a template:
 * 1) Click File, and then click Save As.
 * 2) Click Template.
 * 3) In the Type a name for the template below box, type a name for the template, and then click OK.

The template is displayed in the list of spreadsheet templates the next time you start Works Task Launcher.

For more information about how to create formulas and templates, please see your Works printed documentation or online Help.

Additional query words: w_works works2k w2001 teacher grades report card missing gone

Keywords: kbhowto kbui KB252982

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.