Thursday, November 20, 2014

Friday, Nov 21st- 7th Grade- Spreadsheets- Count Functions

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 11-21-2014


Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheet- Count 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 COUNT function.
Students can create Count functions.

Literacy/Vocabulary Strategies (Word Wall)

The a percent % sign shows a number or ratio expressed as a fraction of 100.
Paintings : % percent sign
https://www.flickr.com/photos/veganstraightedge/5533235507/

Bell-Ringer/Connecting Strategy

On page 92, type lines 11 and 12.
We are using our LEFT INDEX finger for the % PERCENT  key.
We are using our RIGHT PINKY finger for the SHIFT  key.

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

Guided Lesson:
@ Students will start learning about the Count functions.
@ Count and Count A   video http://www.youtube.com/watch?v=4igXvy7JTcU
@ Go to the Spreadsheet folder and open the bottle file.
@ While we are waiting for everyone to get the file open
Bottle breaking slow motion https://www.youtube.com/watch?v=t2NSxiFo1go
@ Put your cursor in B11
@ Type =COUNT(B2:B10) if you did it correctly you should get 6.
@ Type =COUNTA(B2:B10) if you did it correctly you should get 8.
@ Students will start the Overview of Advanced Functions Notes Worksheet by         
completing the notes (copying the Function, Use and Example)     
for Count, and CountA functions.

@ CountIF function video slide 10 of PowerPoint

Independent Exercise
@ Open the CountIF Sports example spreadsheet file to practice the Count functions
    and save to your lunch number.
@ Students will start the Overview of Advanced Functions Notes Worksheet
by completing the notes (copying the Function, Use and Example)     
for the CountIF function.


If time:
@ Microsoft Excel 2010 Data Validationhttp://www.youtube.com/watch?v=qfLirkaWnCY

@ Students will answer questions about on the spreadsheet crossword puzzle.



Higher Order Thinking Questions

What is the difference between the different COUNT functions?

Student Technology/Differentiation

Students will use Excel to create COUNT 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