Technology


 * Technology: Adam, Brian, and Tarran **


 * Lesson Title: Introduction to Spreadsheets **


 * Link to Lesson: http://www.learnnc.org/lp/pages/3231?ref=search **


 * Grade Level: Grade 4 Computer/Technology Skills **


 * Evaluation Scores **

Provides Clear Lesson Objectives Evidence: 4 - Leaning outcomes produce product at the end of the lesson
 * C: **

Exhibits sufficient knowledge of the subject topic/content? Evidence: 4 - Students are introduced to concepts and actually do real world examples using software

Assessments match instructional method Evidence: 4 - Students must follow instructional methods in order to produce the products to assess Lesson appears to help organize and manage student behavior--Explains sequence of events and procedures for students Evidence: 4 - Activities have a detailed sequence of events
 * P: **

Lesson plan incorporates at least 1 technology Evidence: 5 - computer Discusses possible limitations to technology or potential problems, as well as solutions Evidence: 4 - pre-activity uses play money instead of technology Provides clear rationale for technology choice Evidence: 5 – Self-explanatory why you must use computers for excel
 * T: **

Demonstrates understanding of technology as teacher tool or student tool Evidence: 5 - Students use excel for real world situations

Selects effective teaching strategies appropriate to subject domain to guide student thinking and learning Evidence: 4 – Guides students from excel introduction to solving problems with excel
 * PCK: **

Demonstrates awareness of possible student misconceptions Evidence: 3 - Example pre-activities through activities

Presents appropriate strategies for developing understanding of the subject content Evidence: 4 – Students are asked in pre-activities to think about accomplishing business tasks without technology and during activities, they use technologies to finish the same tasks

Chooses technologies enhancing approaches (teacher centered approaches) --Uses technology to present material Evidence: 5 – Uses digital projector to teach excel
 * TPK: **

Chooses technologies enhancing student learning (student centered approaches) --Students use technology to explore content and achieve learning goals Evidence: 5 – They use their own computer to complete excel exercise Provides clear rationale for technology choice to deliver instruction Evidence: 5 – Have to use a computer to teach excel

Chooses appropriate technologies for subject domain (mathematics, science) Evidence: 5 – Excel is tailored for mathematical problems
 * TCK: **

Link between technology and content is obvious or explicit Evidence: 4 – Obvious, computer

Appropriately uses content, pedagogy, and technology strategies Evidence: 5 – Creating solutions through excel
 * TPCK: **

Technology enhances content objectives and instructional strategies Evidence: 5 – Not possible without technology

= =
 * Overall evaluation of this lesson: 4.5 Good lesson demonstrates TPACK. Does a good job of leading students through concepts of excel in a methodical fashion and using it to solve real world problems **