|
|
|
 |
|
|
|
|
|
|
While working on this module, you will learn:
• Excel terms
• Parts of the spreadsheet
• How to create and use a spreadsheet
Note: This module does not include creating and interpreting graphs/charts.
A rubric has been included to help guide you through the collection of all the artifacts you will need to share as evidence of completing the module. Also, the rubric is an assessment tool to be used by the designated personnel in your school district to whom you will submit your completed work for CEU credit.
|
|
|
|
Files
|
|
|
Excel with Excel Module Rubric |
|
 |
|
|
|
|
|
2.
|
PLANNING AND DESIGNING LEARNING ENVIRONMENTS AND EXPERIENCES. Teachers plan and design effective learning environments and experiences supported by technology.
|
|
A. |
design developmentally appropriate learning opportunities that apply technology-enhanced instructional strategies to support the diverse needs of learners. |
|
D. |
plan for the management of technology resources within the context of learning activities. |
|
3.
|
TEACHING, LEARNING, AND THE CURRICULUM. Teachers implement curriculum plans, that include methods and strategies for applying technology to maximize student learning.
|
|
C. |
apply technology to develop students' higher order skills and creativity. |
|
D. |
manage student learning activities in a technology-enhanced environment.
|
|
4.
|
ASSESSMENT AND EVALUATION. Teachers apply technology to facilitate a variety of effective assessment and evaluation strategies.
|
|
B. |
use technology resources to collect and analyze data, interpret results, and communicate findings to improve instructional practice and maximize student learning. |
|
C. |
apply multiple methods of evaluation to determine students' appropriate use of technology resources for learning,communication,and productivity.
|
|
5.
|
PRODUCTIVITY AND PROFESSIONAL PRACTICE. Teachers use technology to enhance their productivity and professional practice.
|
|
A. |
use technology resources to engage in ongoing professional development and lifelong learning. |
|
B. |
continually evaluate and reflect on professional practice to make informed decisions regarding the use of technology in support of student learning. |
|
C. |
apply technology to increase productivity. |
|
D. |
use technology to communicate and collaborate with peers, parents, and the larger community in order to nurture student learning.
|
|
6.
|
SOCIAL, ETHICAL, LEGAL, AND HUMAN ISSUES. Teachers understand the social,ethical,legal,and human issues surrounding the use of technology in PK-12 schools and apply those principles in practice.
|
|
B. |
apply technology resources to enable and empower learners with diverse backgrounds, characteristics, and abilities. |
|
|
|
|
|
Activity 1: To find out about spreadsheets and how they work, go through the following tutorial. Take notes while you go throug the tutorial. http://www.usd.edu/trio/tut/ex...
Click on START HERE.
Activity 2: Test your knowledge by completing the Excel Quiz.
Activity 3: Read the following article and reflect of what you discovered.
http://www.wcpss.net/news/post...
What subject areas did Mrs. Betancourt integrate into the Iditarod Project?
How did she integrate each subject area?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Activity 1: Practice using a spreadsheet by completing the following activity.
http://www.ncwiseowl.org/kscop...
Activity 2: Create your own spreadsheet using the Excel Spreadsheet Practice Handout.
Check your answers using the Spreadsheet Practice Answer Key. Note: This is an Excel file.
|
|
|
|
Files
|
|
|
Excel Spreadsheet Practice Activity |
|
|
|
|
Spreadsheet Practice Answer Sheet |
|
|
|
|
|
|
|
|
|
|
|
Consider the following questions as you reflect on the use of spreadsheets as a tool to increase student achievement:
1. How are spreadsheets used in the home, school, and business world?
2.Why should I use spreadsheets with my students?
3.How might I collaborate with the media coordinator, the technology facilitator, or other teachers to create and/or implement activities using spreadsheets?
|
|
|
|
|
|
|
|
|
|
|
|
|
Activity 1: Look at the following Web site for ideas on how you might incorporate spreadsheets into you curriculum: http://www.ncwiseowl.org/kscop...
Activity 2: Look at the NC SCOS and find the spreadsheet objectives for your grade level.
http://www.dpi.state.nc.us/cur...
Activity 3: Use the Spreadsheet Idea Template to document your ideas. A sample Spreadsheet Idea Sample has been provided.
|
|
|
|
Files
|
|
|
Spreadsheet Idea Template |
|
|
|
|
Spreadsheet Idea Sample |
|
|
|
|
|
|
|
|
|
|
|
|
Using the information you documented in the Spreadsheet Idea Template, create and teach a lesson plan using a spreadsheet. Develop student activities and questions. Be sure to reflect on the lesson plan implementation successes, document feedback from students, and provide document showing evidence of changes made due to feedback. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
