Content Based Standards

Competency Based Standards

Getting Started

• Introduction to spreadsheets
  • What is a spreadsheet
  • Opening Excel
• The Excel environment and terminology
  • The Excel window
    • The Title bar
    • The Menu bar
    • The Tool bar
    • The Formatting bar
    • The Formula bar
    • The Workbook window
    • The Status bar
    • The Task plane
  • The Cell
  • The Worksheet
  • reordering worksheets
  • The Workbook
• Moving around in Excel
  • A highlighted cell
    • Selecting a cell
    • Selecting a group of cells I
    • Selecting a group of cells II
  • Referencing a cell
    •  Rows and Columns
  • Using the arrow keys
    • Moving around a document with the arrow keys
  • Using the vertical and horizontal sliders
    • The Horizontal slider
    • The Vertical slider
• Zooming in and out of the workbook
  • Working with the zoom settings
• Working with cells
  • Selecting cells
    • Selecting a cell
    • Selecting multiple cells
    • Selecting groups of cells
  • Entering text into cells
  • Clearing cell contents
  • Inserting and deleting columns and rows
  • Performing calculations in excel
    • Performing calculations in cells
      • Addition
      • Subtraction
      • Multiplication
      • Division
    • Using the keyboard number pad
  • Using auto sum on a range of cells
    • The auto sum button
• Manipulating data
  • Types of cell entries
    
  • Entering data
  • Using autofill index
    • Autofill identical data
    • Autofill patterned data
  • Sorting data
    • Alphabetically
    • Numerically
      • Ascending
      • Descending
  • Moving data
    • Drag & Drop
    • Copy
    • Paste
  • The undo action
• Using the spell-check feature in Excel
  • Changing the language settings
• Working with workbooks
  • Create new workbooks
  • Save workbooks
    
  • Close workbooks
    
  • Close multiple workbooks
    
  • Open Excel files and workbooks

• Understand the fundamental terms used to describe components in the excel spread sheet program
• Identify components in the excel graphical user interface
• Distinguish between a cell, worksheet and workbook
• Recognize the most common uses for spreadsheet programs

Moving around Excel

• Competently move around an excel document using the mouse or keyboard
• Select cells and groups of cells using the mouse

Working with cells

Manipulating data

Assisted Practice Exercises

• Moving Around Excel
• Creating a new workbook

Practice Exercises

Worksheets

• Using The Correct Terminology I
• Entering Data
• Manipulating Data I

Worksheets

• Using The Correct Terminology I
  • Locate named parts of the excel window
  • Identify commonly used icons and tools
  • Distinguish between instructions
    • Left click
    • Right click
    • Scroll
    • Drag mouse
• Moving Around
  • Understand how to highlight a cell
  • Appreciate the organization of cells in a workbook
  • Know how to reference a cell in a workbook
  • Understand how to highlight groups of cells
  • Know how to reference groups (ranges of cells)
  • Move around a worksheet with the keyboard
  • Move around with the scroll bars
  • Move around with the scroll wheel

Projects

• The Total Number of Items I

Projects

• The Total Number of Items I
  • Enter information into an group of organized cells manually
  • Use the auto sum button to find the total value of data in a group of cells
  • Skills Used
    • Entering data
    • Moving around a document
    • Using the autosum button
    • Saving a document
  • Purpose of project
    • Demonstrate the primary function of excel to users
    • Allow the user to practice acquired skills in a constructive multi part project
    • Guide the user in the integration of new skills into a purpose driven set actions

Functions and Formulas I

• Performing calculations with data in cells
  • Basic Algebra functions
    
  • Using Mathematics Functions
    
  • Using the Equation Bar
    
  • Performing calculations of ranges of cells
• Formulas
  • Using Formulas
  • Creating formulas
  • Editing formulas
  • Editing the range of a formula
  • Copy & pasting formulas to other cells
  • Using autofill with formulas
  • Auto-calculate
• Functions
  • Functions and arguments
  • Using built in functions
    • The functions menu
  • Inserting functions
    • Using the autosum button
    • The sum function
      • The sum function AV Tutorial
    • The average function
    • The round function
    • The max value function
    • The min value function
    • The absolute function
• Using auto functions
  • The auto-sum function
  • The auto-count function
  • The auto-max function
  • The auto-min function
• Absolute and relative referencing
  • The difference between absolute and relative referencing
  • The effect of absolute referencing on copying formulas
• Using logical conditions
  • Creating IF statements

Assisted Practice Exercises

Practice Exercises

Worksheets

• Cell Referencing I
• Working with Formula I
• Absolute & Relative Referencing I
• Conditional Statements I
• Conditional Statements II

Projects

• Creating a Simple Budget

Formatting Spreadsheets I

• The formatting toolbar
  • Showing the formatting toolbar
• Formatting cells
  • Formatting cell dimensions
    • Changing cell width
    • Changing cell height
    • Using auto fit
  • Borders and shading
    • Set cell borders I
    • Remove cell borders
    • Create cell outline
    • Set cell color fill
• Formatting Cell Contents
  • Formatting cell contents Index
  • Formatting text
    • Changing font
    • Displaying symbols
    • Changing text size
    • Changing text color
  • Formatting text style
    • Bold
    • Italics
    • Underline
  • Formatting numbers
    • Percentages
    • Commas
    • Currency (Dollar signs)
    • Decrease the numer of decimal places
    • Increase the number of decimal places
  • Enter Symbols into a cell
  • Formatting data in cells
    • Dates
    • Fractions
    • Decimals
  • Align cell contents
    • Center
    • Left
    • Right
  • Positioning text in a cell
    • Top
    • Middle
    • Bottom
  • Wrapping text in a cell
  • Changing display orientation
    • Vertical
    • Horizontal
    • Angled
• Copying formatting to other cells
• Formatting tables
• Using readymade formats
  • The format menu
• Formatting the worksheet
  • Rows and columns
    • Change column width
    • Set column width numerically
    • Change row height I
    • Set row height numerically
  • Tabs
    • Set tab color
• Formatting the page view
  • Center the worksheet on the page
  • Changing page orientation
  • Hide or display grid lines
• Formatting for printing
  • Adding headers and footers on printed pages
  • Preview page before printing
  • Adding page breaks
• Printing Spread Sheets
  • How to print preview
  • Using the quick print command

Assisted Practice Exercises

• Changing text to bold
• Changing text to italics
• Changing text to underline
• Changing text alignment to center
• Changing text to left justified

Practice Exercises

• Formatting groups of cells

Worksheets

• Preparing Your Data
  
• Creating a Table of Data I

• Creating a Table of data II

Projects

Working with Workbooks I

• The workbook
  • Moving around your workbook
    • Selecting pages in your work book
    • Adding worksheets
    • Deleting worksheets
  • Manipulating workbooks
    • Closing multiple workbooks
• Formatting worksheets
  • Changing the color of worksheet tabs
• Manipulating worksheets in work books
  • Moving data between worksheets
• Manipulating worksheets
  • Moving worksheets
  • Inserting new worksheets
  • Deleting worksheets
  • Copying worksheets
  • Pasting worksheets
  • Reordering worksheets
  • Renaming worksheets
• Grouping worksheets
  • How to group worksheets
  • best practices
• Creating Multiple worksheet formulas
  • Referencing cells in different worksheets
  • Referencing ranges in different worksheets
• Collaborating with coworkers
  • Password protect from making changes
  • Protecting specific cells in a workbook
  • Sharing workbooks with other users
  • Hiding formulas or data from view
  • Hiding worksheets
• Printing
  • Printing entire workbooks
  • Printing worksheets within a workbook
    • Printing active sheets
    • Print selection

Assisted Practice Exercises

Practice Exercises

Worksheets

Projects

Working with Charts I

• Showing the chart toolbar

Creating a chart

• Chart Type Index page
  
• Embedding the chart in a worksheet
  
• Creating a new worksheet for a chart
  
• How quick graph data
• Using the chart wizard

Formatting charts I

• Formatting Charts Main Index
  
• Formatting Line chart Index
  
• Editing the titles
  • Edit the chart title
    
  • Changing title color
    
  • Repositioning the title
    
  • Changing the title font
    
  • Changing the title text size
• Editng the axis labels
  • Changing the axis label font
    
  • Changing the axis label color
    
  • Changing the axis label size
    
  • Changing the axis label position
    
  • Changing the axis label orientation
    
• Editing the axis
  • Changing the axis color
    
  • Changing the axis tick marks
    
  • Changing the axis scale
    
  • Changing the axis scale font
    
  • Changing he axis scale color
    
  • Changing the axis scale size
    
• Editing the legend
  • Changing the legend text font
    
  • Changing the legent text color
    
  • Changing the legend text size
    
  • Changing the legend position
    
  • Changing the legend border
    
  • Removing the legend
• Editing lines
  • Changing the line color
    
  • Changing the line style
    
  • Changing the line weight
    
  • Changing the line smoothness
    
• Editing Points
  • Changing the point style
    
  • Changing the color of points
    
  • Changing the point size
• Editing the grid
  
  • Changing the grid color
    
  • Removing the grid
• Background
  
  • Changing the background color
    
  • Changing background to gradient fill
• Positioning
  
  • Positioning the plot in the chart area
    
  • Resizing the plot in the chart area
    
  • Resizing the chart in the worksheet
    
  • Positioning the chart in the worksheet

Working with Different Chart Types I

• How to make a line chart
  
• How to make a scatter plot
  
• How to make a column
  How to make a pie chart

Assisted Practice Exercises

Practice Exercises

Worksheets

Projects