Quantunet.com

My Account

Joins Us
Excel 2003 QuickSkills
Excel Education Curriculum Basic  

Content Based Standards

Competency Based Standards


Getting Started

 

The Excel environment and terminology
  • 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

 

 

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

 

 

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

 

 

Projects

 

Working with Workbooks I

  • The workbook
    • Moving around your workbook
      • Selecting pages in your work book
      • Adding worksheets
      • Deleting worksheets
    • Manipulating workbooks
  • Formatting worksheets
    • Changing the color of worksheet tabs
  • Manipulating worksheets in work books
    • Moving data between worksheets
  • Manipulating 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

 

 

Assisted Practice Exercises

 

Practice Exercises

 

Worksheets

 

Projects

 

Working with Charts I

Creating a chart

Formatting charts I

Working with Different Chart Types I

 

 

Assisted Practice Exercises

 

Practice Exercises

 

Worksheets

 

Projects

 

© 2008 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us