*
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 12-02-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- VLookup function
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
SSB-2 Know Spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can create a VLookup function.
|
Students can create a VLookup function.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
“In basic terms, VLOOKUP is used to look up a value from a different location in your workbook. It’s useful because when dealing with large amounts of data because you always need to look things up.”
http://www.trackpal.co.uk/blog/vlookup-for-beginners/  | |
Bell-Ringer/Connecting Strategy
| |
We are learning the numeric keypad.
Your thumb goes on the 0 at the bottom
Your index finger on the 4
Your middle finger on the 5
Your ring finger on the 6
Your pinky will hit the plus sign +
The daily bellringers will now be practicing the number pad
Choose exercise 2 and then click on the word "start."
Time will not start until you put your cursor
in the white rectangle and start typing.
Record your typing speed and accuracy in your typing file.
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Lesson:
@ Students will write out the LIST definition.
Independent Exercise
@ In pairs, one student will open the VLookup file and one student will click on
the instruction link.
@ Open up the VLookup file.
@ Students will complete a VLookup function as the teacher demonstrates the process.
@ Student will write the definitions for Lookup and VLookup
@ Students will write out the VLookup definition.
@ Open the count and count a practice file.
@ Use the count and counta functions.
@ Use the count if (the range is their names) function.
@ Use the sum, max, min and average functions.
@ Student will write definitions for validated and nonvalidated functions.
| |
| If time: Students will practice the IF function. | |
Higher Order Thinking Questions
| |
Why is the IF function needed in video games?
| |
Student Technology/Differentiation
| |
Students will use animation to create IF functions.
| |
Closure Strategy
| |
Exit Activity 11: Spreadsheet Review
2 items you may have forgotten:
Absolute value- is when you need cells to remain the same when copied
# means the column is too narrow and you need to make it wider to see the data
| |
No comments:
Post a Comment