Archdale-Trinity Middle School
Lesson Plan
| |
Date: 1-16-2018
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
SSB-2 Know Spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can explain spreadsheet terms
|
Vocabulary TEST this Thursday or Friday
|
Literacy/Vocabulary Strategies (Word Wall)
| ||
Words are aligned to the left. | ||
Bell-Ringer/Connecting Strategy
| ||
1. Go to wclassroom.blogspot.com
2. Open Review for Test Spreadsheet Vocabulary PowerPoint 3. You need a pen or pencil 4. Do NOT ask to get water, after Miss W gives instructions you may go | ||
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| ||
Guided Lesson:
@ Miss W will review spreadsheet terms
@ Miss W will review Candy Poster Contest Rules You need to do 100% of the questions and you need to get 70% or higher You may use PowerPoint, paper or friends but you each must complete exit activity When it is your water break... Vote for the 5 Best Posters for your period You may vote for yourself Do NOT tell anyone your number or disqualified Do NOT make fun of poster or disqualified Do not take too long or you will lose your votes Independent Exercise @ Students will review basic Spreadsheet terms. If absent on Friday: @ Students will create a Spreadsheet vocabulary poster on a word(s) they find hard to remember. Rubric- Spelling- 10 Creativity- did picture and words make sense and you thought about design- 20 Effort- did you spend time on it- 20 Neatness of writing and pictures- 20 Coloring of poster- 20 Name is on BACK of poster- 10 | ||
| ||
How much do you remember about Spreadsheets? By yourself or with a partner take turns and play https://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1 Hints: do NOT include these in your spreadsheet numbers--- commas and dollar signs copy formulas and automatically adjusts to correct cell range- relative cell referencing not Paul Bunyan, but a guide- legend * - / + --- mathematical operators selected group--- cell range another place that displays the active cell's info.--- entry bar active cell in a spreadsheet has this around it---border allows you to quickly fill in days of week---autofill turn sideways!--- landscape if time: https://kahoot.it/ | ||
Higher Order Thinking Questions
| ||
How are tables formatted?
| ||
Student Technology/Differentiation
| ||
Students will review how to format a table.
| ||
Closure Strategy
| ||
Exit Activity 3
|
No comments:
Post a Comment