Knowledge Base

Works 95 Grade Book TaskWizard: Incorrect Data in Class Summary

Article ID: 148171

Article Last Modified on 11/15/2004

APPLIES TO

This article was previously published under Q148171

SUMMARY

When you use the Grade Book TaskWizard in Works, you may notice the assignment name on the Class Summary row (row 4 of the Standard and Modified Grade Books) contains numbers instead of names or dates.

This happens if you place assignment dates on the Assignments line of the spreadsheet (row 10 in the Standard Grade Book; row 14 in the Modified Grade Book) instead of assignment titles. The Class Summary row has a General format, dates appear as serial numbers.

MORE INFORMATION

You can remedy this behavior by doing one of the following:

  • Type descriptive text such as the assignment name, in addition to the assignment date, in the Assignment cells.

    -or-

  • Format the Assignment row as Text (row 10 in the Standard Grade Book; row 14 in the Modified Grade Book).

    -or-

  • On the Class Summary row, format Assignment cells as Date.
NOTE: If you choose to reformat either the Assignment row or Class Summary row, you must first turn off Protection. The Grade Book TaskWizard turns Protection on by default. After disabling Protection and reformatting the desired cells, you can turn Protection back on.

REFERENCES

For information on how to turn protection on or off in the spreadsheet, click Index on the Help menu and read the entries under the topic, protecting data: spreadsheet cells.

For information on how to change the formatting of a spreadsheet cell, click Index on the Help menu and read the entries under the topic, cells: date formats.

Additional query words: 4.00 4.00a 4.50 w_works

Keywords: kbinfo KB148171


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.