-
Spreadsheets
- What are they?
- Some ways a teacher can use Excel.
-
Basic Excel Screen Features
- Description of basic Excel sheet icons.
-
Controlling Column and Row Size
- To change the width of a column
- Insert a heading
- Change row size
- Selecting areas of an Excel worksheet
- Applying grid lines to cells
- Renaming work sheets
-
Headings in Worksheets
- Putting main heading in worksheet
- Including other titles in worksheets
- Including headings from page to page
- Inserting new rows and columns
- Deleting rows and columns
-
Entering Data into Cells
- Putting text into cells
- Assigning properties to groups of cells
- Typing text in cells
- Money figures using Currency Style
- Working with decimals and commas
-
Working With Text Lists
- Entering a list
- Sorting a single text column
- Sorting two columns together
- Sorting three or more columns together
|
-
Working With Numerical Data
- Applying changes to columns and rows
- Sorting a numerical data
- Preparing a work area
- Sorting more then two columns together
- Sorting data by marks
- Working with currency lists
- Sorting currency lists
-
Using Basic Formulas
- Using the Sum feature
- Using the Average feature
- Paste Function feature
- Keeping Class Records: An Example
- Sample Rubric: "English 10 - Oral Presentations"
-
How to Make Graphs and Charts
- Charts and Graphs
- Creating a 'Column Chart' using student marks
- Applying color to graphs and charts
-
Using Color in Worksheets
- Applying Color to Cells
- Applying Color to Data
- Applying color to Heading rows
- Applying Color to entire column(s) or row(s)
- Example Worksheet With Color
-
WordArt and Clip Art
- Using WordArt
- Using Clip Art
- Using other Excel Graphics
- Importing Graphics into Excel
|