Excel Worksheet Basics

• Basic terminology
• Entering and Editing Data
• Using automatic features
• Using Functions
• Using Equations
• Calculating Percent and Using Absolute Cell Reference

• Basic terminology
• Entering and Editing Data
• Using automatic features
• Using Functions
• Using Equations
• Calculating Percent and Using Absolute Cell Reference

• Standard Toolbar
• Formatting Toolbar
• Drawing Toolbar
• Customizing Toolbars
• Using menu items part 1 (File, Edit, and View menus) PC
• Using menu items part 1 (File, Edit, and View menus) Macintosh
• Using menu items part 2 ( Insert, Format, and Tools menus ) PC
• Using menu items part 2 ( Insert, Format, and Tools menus) Macintosh
• Using Keyboard Shortcuts in Microsoft Excel PC/Windows version
• Using Keyboard Shortcuts in Microsoft Excel Macintosh version

Creating and Designing Single Use Spreadsheets

• Calculating sales tax on a purchase
• Calculating the cost of a trip by car
• temperature converter
• calculate the price of pizza per square inch

Internet4Classrooms forms and templates in .xls format

• Graph paper - Excel files with small, medium and large grids.
• Pre-Reading Clock - establishing vocabulary readiness
• Quadrille paper - Excel files with small, medium and large grids, every fifth line is darker
• Venn Diagram - two circle, three circle, and instructions to make your own

• Using Microsoft Excel to perform classroom tasks

• Analyzing Classroom Data - a simple survey

• Using Excel to Create a Chart or Graph
• Using Excel as a grade book
• Using Mail Merge
• Using Mail Merge - Office 2003
• Fostering Literacy with Excel
• Recording a simple macro
• Create a chart using pictures for the bars or columns
• Create an interactive crossword puzzle
• Create a concept map using Excel
• Use an Excel worksheet to create a matching activity
• Make a Scatter Plot with Excel
• Using PowerPoint to animate an Excel Chart: Office 2003, Office 2000, or Macintosh X

• Using a Radar chart to analyze data
• Make a Custom List
• Use Excel to Import Data from the Internet
• Using Conditional Formatting
• Use Excel to Write a Branching Story
• Writing Mad-Libs with Excel
• Make a Review Quiz using Drop-down menus and Conditional Formatting
• Modifying Excel Charts
• Inserting an Image into the Background of an Excel Worksheet
• Transposing Rows and Columns in an Excel Workbook on 6/29/09

• Using Excel to Create a Chart or Graph
• Create an interactive crossword puzzle
• Using Mail Merge - Office 2007
• Using a Radar chart to analyze data
• Make a Custom List
• Use Excel to Import Data from the Internet

• Using Conditional Formatting
• Make a Venn diagram
• Animate an Excel chart in PowerPoint
• Using Compatibility Mode
• Inserting an Image into the Background of an Excel Worksheet
• Transposing Rows and Columns in an Excel Workbook on 6/29/09

• Using Excel to Create a Chart or Graph

• Make a Number Line
• Make Time Line

• Make a Venn Diagram
• Make a Web

• Make a Coordinate Plane
• Make a Hundreds chart

• Make a Ten Frame

• Number Line
• Time Line

• Coordinate plane - 4 Quadrants
• Template for making Webs

• Ten Frame
• Hundreds Chart

• Moon Phase Worksheet
• Moon Phases - Drag to Position
• Record the Daily Weather

• Fahrenheit to Celsius temperature converter
• M & M Spreadsheet
• Pizza Calculator - calculate the price per square inch
• Trip Calculator - How much will a car trip cost?
• Fostering Literacy Using Excel
• What would I weigh on...?
• Twenty Four Hours of Temperature Data

• Protecting Cell Contents
• Using a Macro to Clear Student Responses in a Quiz
• Mad-Libs with Excel
• Jeopardy Template See a web page about this template.
• Earthquake Project (8.4 mB)
• Drop Down

• Sign In Sheet
• Physics Crossword Puzzle
• Nursery Rhyme Crossword Puzzle
• Four Square Puzzle puzzle as a template
• Sample concept maps
• How do I spend my time?