Tuesday, May 19, 2015

Wednesday, May 20th- 7th Grade- Spreadsheet Formatting- Review for Thursday's Test

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 05-20-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.
to center the following,

Bell-Ringer/Connecting Strategy

On page 95, type lines 3 and 4..
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.

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

Lesson Reflections




No comments:

Post a Comment