Microsoft Excel is a spreadsheet program. It is easily used for mathematics, as well as textual applications. It can save files as web pages, as well as in Excel format. It also executes mathematical functions on a high level.
Excel
|
|
Keyboard Shortcuts (to view or print) |
| Objectives • Gain an understanding of the purpose and use of computer generated worksheets in an educational environment • Develop proficiency creating, editing, enhancing and working with worksheet applications • Develop proficiency creating charts and graphs • Develop proficiency working with math formulas and functions • Develop proficiency creating Web pages • Demonstrate proficiency in developing instructional materials using Excel • Increase Internet and World Wide Web skills |
|
Creating A Worksheet & Embedded Chart
Objective: Students will demonstrate proficiency creating, editing, saving and printing a worksheet with the Chart wizard and AutoCalculate.
Links:
1. Introduction to Excel
2. Creating a Worksheet with an Embedded Chart
| Formulas, Functions,
Formatting & Web Queries Objective: Students will demonstrate proficiency creating an Excel spreadsheet utilizing formulas, functions, formatting and Web searches. Links: 1. Utilizing Formulas 2. Using Functions 3. Applying Cell Formatting 4. Using a Web Search: Google.com's Basics of Search 5. Classroom Integration Links Above |
| What-If Analysis, Charting &
Working With Large Worksheets Objective: Students will demonstrate proficiency using drawn objects, using the fill feature, adding and deleting rows and columns, adding absolute cell references, enhancing text layout, and using the IF function. Links: 1. Create a Series 2. Absolute Versus Relative Addresses 3. 3-D Pie Charts 4. Classroom Integration Links Above |
| Creating Static and Dynamic
Web Pages Using Excel (2000 version only): Objective: Students will demonstrate proficiency creating static and dynamic Web pages. Links: 1. Static versus Dynamic Web Page 2. Define dynamic Web page 3. Saving an Excel Worksheet as a Web Page 4. Classroom Integration Links Above |
| Linking an Excel Worksheet
To A Word Document (97 version only): Objective: Students will demonstrate proficiency linking an Excel spreadsheet to a Word document. Links: 1. Object Linking and Embedding 2. Saving the Word Document with the Linked Worksheet--DEAD LINK 3. Classroom Integration |
| Integrating Spreadsheets Into the
Classroom Objective: Students will demonstrate the ability to create a technology-enriched project that uses an Excel spreadsheet. |
||||||||||||||||||||||
|
Microsoft Excel
|
