TFIV

1. Model the use of technology tools to assess student learning of subject matter using a variety of assessment techniques. 2. Assist teachers in using technology to improve learning and instruction through the evaluation and assessment of artifacts and data. 1.  Guide teachers as they use technology resources to collect and analyze data, interpret results, and communicate findings to improve instructional practice and maximize student learning. //Teachers and Administrators at Northwest HS were trained on the basics of Microsft Excel 2007 to help collect, organize and display data.//
 * Technology Facilitation Standard IV. (TF-IV) **
 * Assessment and Evaluation. ** Educational technology facilitators apply technology to facilitate a variety of effective assessment and evaluation strategies. Educational technology facilitators:
 * TF-IV.A. Apply technology in assessing student learning of subject matter using a variety of assessment techniques. Candidates: **
 * TF-IV.B. Use technology resources to collect and analyze data, interpret results, and communicate findings to improve instructional practice and maximize student learning. Candidates: **
 * 1) [|Excel 2007 Introductions]
 * 2) [|Excel 2007 Inserting, Cutting, Deleting, etc.]
 * 3) [|Excel 2007 Sorting Data]
 * 4) [|Excel 2007 Creating Formulas with one Operator and Applying to Multiple Cells]
 * 5) [|Excel 2007 Finding Averages and Sums]
 * 6) [|Excel 2007 Conditional Formatting]

1. Assist teachers in using recommended evaluation strategies for improving students' use of technology resources for learning, communication, and productivity. 2. Examine and apply the results of a research project that includes evaluating the use of a specific technology in a P-12 environment.
 * TF-IV.C. Apply multiple methods of evaluation to determine students' appropriate use of technology resources for learning, communication, and productivity. Candidates: **

//Action Research Project// This assignment surveyed teachers about which technology they would want to learn more about and then demonstrated how to use Excel to analyze student math scores on assessments. Reflection: The RubiStar training with the first grade teachers was new for some but others had seen it before. The teachers liked the fact there were pre-made tutorials that they could reference. However, they commented that because their curriculum is so structured a lot of the rubrics they used are already created and in their curriculum guides. I will know this next time and try to create a different assessment tool to be instructed. The Excel trainings were created for teachers at Northwest High School. Since the new version 2007 version of Excel was installed most of the teachers wanted to see how the new features translated into the program. The teachers also wanted to learn some advanced features of Excel. The teachers liked the conditional formatting as well as multiple sorting options as this would help with groupings based on skill level. The teachers absolutely loved the video tutorials as a reference if they forgot a step. The tutorials were placed in the Teacher Shared Folder within the school LAN. The teachers have already asked for more in depth training which we plan on continuing as the school year progresses.