Managing Grades with Excel 2002

Use a grade book to organize and track assignments and tests in Microsoft Excel 2002.

Easily customize a grade book for your specific needs and classroom situation.

Assign varying degrees of importance to graded elements.

Quickly calculate numerical scores into letter grades.

Analyze your student data and save your analysis as an interactive Web page.

Before You Begin 
An introduction to the tutorial and what you will learn.

Using Excel
Become familiar with how to access the powerful features of Excel and where they appear on your screen.

Importing Data
Learn how to easily generate data or import data in a variety of ways, including from text files, databases, and the Web.

Customizing the Grade Book 
Excel provides many different tools for you to view and manipulate grade information in a variety of ways. The use of formulas makes customization quick and easy.

Analyzing Data 
With PivotTables and PivotCharts, you can sum and average, filter, and analyze specific data for your classroom needs.

Using Excel 2002 on the Web 
With native file formatting recognition, you can post your Excel files to the Web quickly and easily. You can also use interactive worksheets to share and continue your data analysis.