Return to Main CISD Home Page CISD Schools CISD Departments What's New in CISD CISD Help Desk Services Please Email us your comments. Conroe Independent School District

Conroe Independent School District
Technology Competencies
Introduction to Spreadsheets
Description: This class is designed for teachers who want to learn to sort and filter data; display subtotals; create and manipulate pivot tables; work with functions and templates; and perform data projections and data analysis. In addition, teachers will learn to manage, protect, and link workbooks; link and embed objects, and consolidate information.
Prerequisite Skills: Introduction to Windows
Outline
A. Entering and Changing Worksheet Information
  1. Entering text and numbers
  2. Using AutoFill and Working with Formulas
  3. Changing the View of Your Worksheet
  4. Moving Around a Worksheet
  5. Finding and Replacing Information
  6. Clearing, Cutting, Deleting, and Inserting a Range
  7. Moving and Copying Information
B. Performing Calculations
  1. Selecting Ranges
  2. Using AutoCalculate and Naming Ranges
  3. Using Functions
  4. Finding the Sum of a Range of Numbers
  5. Finding the Average of a Range of Numbers
  6. Using Paste Function
  7. Using Paste Function to Create and Modify Formulas
  8. Creating Simple Formulas with Basic Operators
  9. Modifying Formulas
C. Sorting Data
  1. Using the Sort Command from the Data Menu
  2. Changing the Sort Orientation
 D. Formatting Worksheet Information
  1. Formatting Numbers and Text
  2. Changing the Font Size of Text
  3. Changing the Color of Text
  4. Changing Column Width and Row Height
  5. Formatting Cells and Ranges
  6. Controlling the Alignment of Text
  7. Indenting Text in Cells
  8. Changing the Orientation of Text in Cells
  9. Using Text Control and Using AutoFormat
  10. Centering Text Across Cells
  11. Adding Borders and Color to Ranges
  12. Copying and Clearing Formatting
E. Creating a Basic Chart
F. Preparing and Printing Workbooks
  1. Setting Up the Page
  2. Setting the Margins, Headers and Footers, and
  3. Sheet Options
  4. Previewing and Printing a Worksheet
  5. Printing a Worksheet with Gridlines
G. File Management
  1. Using the Help Feature
  2. Displaying Tips