 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 05-28-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- Formatting
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
SSB-2 Know Spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can format spreadsheets
|
Students can format spreadsheets
|
Literacy/Vocabulary Strategies (Word Wall)
| |
You can merge and center titles in Excel.
When you merge cells you take several small cells and make one large cell.
 | |
Bell-Ringer/Connecting Strategy
| |
On page 103, type lines 25 and 25..
Today’s typing is a general review using all of the alphabetic keystrokes we have learned this semester
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Lesson:
@ Signed interim reports due
@ Miss W will review how to format a spreadsheet.
| |
Independent Exercise:
@ Students will practice formatting skills on the Independent Practice.
If absent on Wednesday:
@ Compare your time to your beginning of the year time! :)
@ Students will complete formula sheet individually
@ Students will complete any missing work:
*** The 3 Purpose PowerPoint
*** The Review Test
*** The Review Test Correction Sentences
*** The Review Test Analysis (which type of question did you miss the most?)
Questions 1 through 8 are Typing Questions
Questions 9 through 15 are PowerPoint Questions
Questions 16 through 25 are Spreadsheet Questions.
| |
Important Dates- Last Grades if you want to improve your final grade.
3 Purpose PowerPoint due today, Tuesday, May 19
Review Test, Thursday, May 21
Test Corrections or Correction Voki due today, Friday, May 22
Final typing improvement test is Tuesday, May 26th
Daily Review Grades from Monday, June 1st through Thursday, June 4th
Daily typing grade on Thursday, June 4th
Official End of Semester test for this class is Friday, June 5th
| |
Higher Order Thinking Questions
| |
How does formatting a spreadsheet make it easier to use?
| |
Student Technology/Differentiation
| |
Students will format a spreadsheet
| |
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