 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 11-20-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- Date 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 a DATE function.
|
Students can create date functions.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
The DATE functions are important for businesses because they can do all types of sales analysis.
Why is the Friday after Thanksgiving called Black Friday? http://en.wikipedia.org/wiki/Dashboard_(business)  | |
Bell-Ringer/Connecting Strategy
| |
On page 91, type lines 6 and 7.
We are using our LEFT INDEX finger for the 5 key.
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Lesson:
@ Miss W will start to explain more advance Spreadsheet functions like:
Date, Now, Days360
@ Open a new Spreadsheet
@ In cell B7 insert the Now function
@ In cell B10 insert the Date function and enter 2015 for year, 6 for month and 9 for day.
@ We are now going to see how many days until the end of school!
@ In cell D12 insert the Days360 function Start date is B7 and End Date is B10
@ This will give you how many days before your next Student Day Off.
@ Lets find how many days until Christmas.
@ Change the number in B10 to 2015 for year, 12 for month and 25 for day.
@ Lets find how many days until your birthday. :)
@ Change the number in B10 to your birthday.
Independent Exercise:
@ WRITE your NAME on the top of the Advanced Functions Notes Worksheet.
@ Students will start the Overview of Advanced Functions Notes Worksheet by
completing the notes (copying the information in Function, Use and Example)
for IF, Date, Now and Days360
| |
If time:
@ Students will answer questions about on the spreadsheet crossword puzzle.
| |
Higher Order Thinking Questions
| |
What is the difference between the Date function, the Now function and the Days360 function?
| |
Student Technology/Differentiation
| |
Students will use Excel to create Date, Now and Days360 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