Monday, May 15, 2017

Tuesday, May 16th- 7th Grade- Embedded versus Linked Charts

Archdale-Trinity Middle School
Lesson Plan
 
Date: 05-16-2017


Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheet- Social Studies and 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 create a spreadsheet, use functions and format my data.
Students can create a spreadsheet, use functions and format their data.

Literacy/Vocabulary Strategies (Word Wall)

Linked Spreadsheets will change . 



http://vitamincm.com/wp-content/uploads/2010/11/tab-1.gif


Bell-Ringer/Connecting Strategy

  1. Go to wclassroom.blogspot.com

Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)



Guided Practice:

@ Miss W will explain the difference between
embedded charts (appears on the same sheet as the spreadsheet),
separate charts (does not appear on the same sheet as spreadsheet will update if both files are open.)
and linked charts (will change to reflect changes made to spreadsheet even if both are not opened.)


Copy paste Excel chart into PowerPoint: Embedding vs Linking Chart


@ Students will follow instructions and complete the 5 Invoices spreadsheet.



Independent Exercise:
@ Students will create find the functions for the 5 invoices exercise.



Higher Order Thinking Questions

How do you create a spreadsheet?

Student Technology/Differentiation

Students will use Excel to create spreadsheets.

Closure Strategy

Exit Activity #10:
Work with partners.
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars

Exit Activity#11:
Working in pairs and using the PINK Study Guide answer the questions.


No comments:


Post a Comment









No comments:

Post a Comment