Middle+School+Math+1


 * Middle School Math 1: Caroline, Christine, and Rachel **

Evidence: Modify and use spreadsheets to solve problems.
 * Lesson Title: **** Spreadsheet formulas **
 * Link to Lesson: **** http://www.learnnc.org/lp/pages/3016?ref=search **
 * Grade Level:6-8 math **
 * Evaluation Scores **
 * C: **
 * Provides Clear Lesson Objectives -5

Evidence: gives a step by step way to complete the assignment( 21 steps) Evidence: yes, you still use spreadsheet to check answer; compare the printed information to the set of instructions to make sure the assignment is complete. Students should be provided a copy of the attached [|answer sheet]. They will be required to deduct 5 points for each item that does not match the answer sheet then a classmate will double check the paper to see if all errors were detected Evidence: the list of instructions
 * Exhibits sufficient knowledge of the subject topic/content? -4.5
 * P: **
 * Assessments match instructional method - 4
 * Lesson appears to help organize and manage student -behavior--Explains sequence of events and procedures for students - 5

Evidence: Microsoft Excel Evidence: doesn’t not have anything about the limitations but has the solutions for lesson; [|answer sheet]. Evidence: doesn’t say why he pick to use this technology; This lesson will provide practice using formulas, print options, functions, and adjusting column widths. Evidence: doesn’t clearly say a not teacher tool but the kids are doing the work on the spreadsheet.
 * T: **
 * Lesson plan incorporates at least 1 technology- 5
 * Discusses possible limitations to technology or potential problems, as well as solutions-1
 * Provides clear rationale for technology choice- 2.5
 * Demonstrates understanding of technology as teacher tool or student tool- 3.5

Evidence: it is guided but the teacher doesn’t really have to be there for students to do the assignment they just have to follow list of instructions Evidence: not really it just tells you what to take off for every error. ; Carefully follow all directions and proofread your work. Evidence: it more of an assessment of knowledge.
 * PCK: **
 * Selects effective teaching strategies appropriate to subject domain to guide student thinking and learning- 3.5
 * Demonstrates awareness of possible student misconceptions-.5
 * Presents appropriate strategies for developing understanding of the subject content- 2

Evidence: not using the technology to present the information Evidence: it just an application of the content to reinforce the knowledge the students already have Evidence: none in the lesson plan
 * TPK: **
 * Chooses technologies enhancing approaches (teacher centered approaches) --Uses technology to present material- 1
 * Chooses technologies enhancing student learning (student centered approaches) --Students use technology to explore content and achieve learning goals-4
 * Provides clear rationale for technology choice to deliver instruction-1

Evidence: a good way to show the data
 * TCK: **
 * Chooses appropriate technologies for subject domain (mathematics, science)-4

Evidence: the students could be doing anything we don’t really see how they learn about formulas
 * Link between technology and content is obvious or explicit-1

Evidence: it just really using technology
 * TPCK: **
 * Appropriately uses content, pedagogy, and technology strategies-2

Evidence: its doesn’t really do anything to teach them about using formulas.
 * Technology enhances content objectives and instructional strategies- 1


 * Overall evaluation of this lesson: A good way to learn how to use excel but doesn’t really do anything to improve knowledge about using formulas. **

= =