Introduction to Excel

A graph can be a useful tool to see the relationship between numbers. Looking at a bar graph of class averages in a set of tests or assignments allows a teacher to see areas of strength and areas where extra review and instruction is needed.

In this session, selected data is displayed as a bar graph. Then formatting changes, such as chart layout, style, background, and color are applied to make the graph clear and easy to read.

The grade book is edited using the Spelling command. Then multiple, empty worksheets that contain the student names and formulas are copied for use in other subject areas. Optional instructions are provided for formatting the worksheets.

In the final session, the workbook is prepared for printing:

• headers and footers are formatted
• worksheets are scaled to fit
• worksheets are previewed

Introduction to Excel, includes spreadsheet activities for use in the classroom:

• Excel Bingo
• Design a Survey
• Graph Survey Data

View Lesson