Spreadsheet

Communication Literacy	Grade Level	K	1	2	3	4	5	6	7	8	S1
Spreadsheet *Design* Students will:	Design a spreadsheet according to needs (MS Works, MS Excel)


Create Students will:	Create a new spreadsheet


	Enter labels


	Enter information


*Existing* Students will:	Open existing file


	Add new information in existing spreadsheet


Save Students will:	Save updated records to existing file

Communication Literacy	Grade Level	K	1	2	3	4	5	6	7	8	S1
Save As Students will be able to:	Use Save as… to save a spreadsheet with a new name and/or to a new location


Manage Information: Students will be able to:	Move to a specific cell


	Select a cell or blocks of cells


	Modify data (change data or correct information in cells)


	Use Fill Down, Fill Right, Fill Series features


*Layout* Students will:	Format a cell or cells


	Format text

Communication Literacy	Grade Level	K	1	2	3	4	5	6	7	8	S1
*Layout* Students will:	Change number format


	Emphasize cells with bold, italics, or underline features


	Emphasize cells with borders


	Change column widths and row heights


	Build a formula into a cell


	Copy and paste values and formulas into selected cells


	Insert or delete rows, columns or blocks of the spreadsheet

Communication Literacy	Grade Level	K	1	2	3	4	5	6	7	8	S1
*Layout* Students will:	Display or remove the grid lines, column and row headers for printing


	Set page layout and page breaks for printing


	Select printer and print document


Sort and Arrange Data Students will:	Retrieve using greater than (>), less than (<), and range criteria


	Protect cells from changes


Process Information Students will:	Organize information (arrange, sequence, group, classify)


	Analyze information for patterns and relationships

Communication Literacy	Grade Level	K	1	2	3	4	5	6	7	8	S1
Process Information Students will:	Synthesize information (interpret)


	Synthesize information (infer, predict, or problem solve)


	Evaluate and apply information to real life situations


	Use the spreadsheet to suggest trends in data


Charts Students will:	Create a chart (bar, line, pie, stack)


	Select data that is appropriate to formatting a chart


	Include titles, scales, legends


*Vocabulary* Students will understand the following as appropriate to grade level:	Fields, cells, sort, column, row, spreadsheet, chart, table, graph (line, bar, pie, 3D), formula, query, link, embedded, category, arrange, value, label, sum...