Terms and Concepts 

Unknown

Basic

Intermediate

Mastery

Spreadsheet

Workbook

Worksheet

Graphs

Functions

Charts

Formulas

Data Analysis

Unknown  

I do not know nor have I ever encountered this before.  

Basic  

I have heard people talk about doing this with a computer, but I don’t know how to do this.  

Intermediate  

I have had training or limited experience to do this.  

Mastery  

I am fully proficient in this skill.  

a

Group of Skills

Specific Skills 

AUnknownA

 Basic

Intermediate

aaaMasteryaaa

Create a workbook

Save a worksheet data as a web page

Switch from one worksheet to another

Manipulate worksheets

Create multiple worksheets within a single workbook

Rename, delete, and copy worksheets

Manipulate data

Copy, cut, and paste data from one location to another

Format various data types such as text, currency, dates, and numbers

Select a range of data to create a formula

Select a range of data to create a graph or chart

Select a range of data to select an area to print

Group of Skills

Specific Skills 

AaUnknownaA

   aBasic a    

Intermediate

aaaMasteryaaaa

Manipulate formulas

Create, edit and delete formulas on a single worksheet

Create edit, and delete formulas that cross multiple worksheets

Use conditional statements within formulas

Manipulate charts and graphs

Create a chart or graph using at least 4 variables

Change chart and graph information such as legend, color, titles, captions, axes, and types of graphic to display

Edit and delete existing charts and graphs

Print workbooks and worksheets

Define print areas

Create header and footers for the selected print area

Change the margins and page orientation for print

Manipulate Rows and Columns

Change the width, or height, of a column, or row

Automatically fit the width or height to a cell's contents