*
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 12-03-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- Count and Count A functions
| |
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 Count and Count A functions.
|
Students can create Count and Count A functions.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
To find a function, click the down arrow next to the Autosum button,
Click on “More functions” Type in the name of the function you are looking for and click GO. Then click OK.  | |
Bell-Ringer/Connecting Strategy
| |
We are learning the numeric keypad.
Your thumb goes on the 0 at the bottom
The daily bellringers will now be practicing the number pad
Choose exercise 1 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 review instructions.
Independent Exercise
| |
@ 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
and any other definitions they have not completed.. | |
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