|
Productivity tutorial You might think of Microsoft Office Excel as only a spreadsheet software program used to record data, but it is also an excellent tool for analyzing that data. Perhaps you are already using a spreadsheet to keep track of your students' grades. You might even be analyzing patterns in those grades. Office Excel 2002 makes it possible to perform the same types of analyses on data from all kinds of sources, including text files, databases, and the Web. The PivotTable features of Excel enable you to analyze large amounts of complex data in a flexible manner and to summarize your findings in a graphical format. Download the tutorial to learn how to use Excel 2002 in the classroom: | • | Step-by-step instructions show you how to use Microsoft Office Excel 2002 to import data, analyze it, and put it on the Web. | | • | The accompanying instructor presentation offers a visual guide to the tutorial, suitable for use by an instructor leading a class or for self-paced learning. |
On This PageTutorial information|
Instructional level | | • | Intermediate user | | • | Advanced user |
| Curriculum areas | | • | Teacher productivity | | • | Classroom management | | • | Technology |
| Software required | | • | Microsoft Office Excel 2002 |
|
Objectives| • | Gather real-world data from different sources, including text files, databases, and the Web. | | • | Use PivotTables and PivotCharts to ask questions of complex data. | | • | Save your analysis as an interactive Web page. |
Tutorial outline| • | Before you begin
An introduction to the tutorial and what you will learn. | | • | Using Excel 2002
Before you start working with collected data, become familiar with the features of Microsoft Excel and where they appear on your screen. | | • | Importing data
Learn how to enter data manually, generate data by using forms or macros, or import data from a variety of sources. | | • | Analyzing data
After gathering your data into Excel, learn to perform many kinds of analyses, from simple filtering to advanced forecasting analysis. | | • | Using Excel 2002 on the Web
Learn to put your Excel files on the Web and then return them back to Excel without losing any of the formatting. |
Web links to tutorial, instructor presentation, and other resourcesNote: To open these files you will need a shareware compression utility, like WinZip or PKZip. You can download a 45-day trial version of the WinZip utility for free. 
Analyzing data with Microsoft Excel 2002 (1 MB Microsoft Word file)
Instructor presentation (1 MB Microsoft PowerPoint file)
| |
