STEPs - Spreadsheets in the Classroom

How can spreadsheets be used to enhance student understanding?

Participants will create a standards-based classroom lesson that incorporates the use of spreadsheets, complete with a student sample and teacher support materials.

Targeted Standard

Standard III Teaching, Learning and the Curriculum
Teachers implement curriculum plans that include methods and strategies for applying technology to maximize student learning.

Teacher Standards Met

Standard II Planning and Designing Learning Environments and Experiences
Teachers plan and design effective learning environments and experiences supported by technology.

Standard IV Assessment and Evaluation
Teachers apply technology to facilitate a variety of effective assessment and evaluation strategies.

Standard V Productivity and Professional Practice
Teachers use technology to enhance their productivity and professional practice.

Student Standards Met

Standard III Technology Productivity Tools
Students use technology tools to enhance learning, increase productivity, and promote creativity.
Students use productivity tools to collaborate in constructing technology enhanced models, preparing publications, and producing other creative works.

Standard IV Technology Communications Tools
Students use telecommunications to collaborate, publish, and interact with peers, experts and other audiences.
Students use a variety of media and formats to communicate information and ideas effectively to multiple audiences.

Standard V Technology Research Tools
Students use technology to locate, evaluate, and collect information from a variety of sources.
Students use technology tools to process data and report results.
Students evaluate and select new information resources and technological innovations based on the appropriateness to specific tasks.

Standard VI Technology Problem-Solving and Decision-Making Tools
Students use technology resources for solving problems and making informed decisions.
Students employ technology in the development of strategies for solving problems in the real world.

BACK TO TOP

Skill Sets

Spreadsheets

	Create or open, name, and save a spreadsheet
	Understand printing options for a spreadsheet

	Enter, clear, delete, and edit contents of a cell
	Format cells, rows, and columns (numeric, border, fill, and font)
	Merge, unmerge, and wrap text in cells
	Insert functions
	Write formulas
	Create and format a chart
	Cut, copy, and paste cell contents
	Move a range of cells
	Insert a row or column
	Insert page breaks
	Protect cells
	Sort and filter data
	Add graphics
	Add and rename worksheets
	Insert comments

Creating a Project-Based Environment

	Plan for projects that are anchored in core curriculum; multidisciplinary
	Involve students in sustained effort over time
	Involve students in decision-making
	Foster collaborative environments
	Create clear real-world connections
	Use systematic assessment: both along the way and end product
	Teachers learn to act as coaches and facilitators of student learning
	Tap resources beyond the classroom community

BACK TO TOP