This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2007

Gradebook: Phase 2
Cleaning Up the Data for Use

After you have added the student information to your Excel worksheet, you may discover that you want to remove unnecessary information and make columns wider to display all of the information. For more information, refer to Getting Started with Excel.

return to topViewing All Your Data

In order to see all your data, the columns must be wide enough to display the text. Adjusting the column border may be necessary to view all your data. You can have Excel determine the best "fit" based on the information in the column or row by using the mouse or menus. For more information on adjusting your column width and row height, refer to Working with Rows and Columns.

return to topRemoving Unnecessary Information

As the instructor for the class, your name is included in the Getlist and Gradebook information. Since you will not be graded, you can remove your name from the Excel worksheet. You may also delete extra columns. For more information, refer to Working with Rows and Columns: Adding and Removing Rows and Columns.

return to topSeparating First and Last Names

The Getlist or Gradebook command returns students' names in the following format: last name, first name, middle initial. If you copy and paste from the email message to Excel, the name information appears in one column. However, you may want to have separate columns for each part of the name. Excel can do this with the Text to Columns command. For more information on how to use this command, refer to Splitting Cell Data.

Excellence. Our Measure. Our Motto. Our Goal.