Friday, December 15th- 7th Grade- Begin IF statements

Archdale-Trinity Middle School Lesson Plan
Date: 12-15-2017

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheet- If statements
Standards:	SSB-1 Know the components of Spreadsheets SSB-2 Know Spreadsheet operations

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can understand the parts of an IF statement.	Students understand the parts of an IF statement.

Literacy/Vocabulary Strategies (Word Wall)
https://cs.harvard.edu/malan/scratch/ifelseifelse.gif
Bell-Ringer/Connecting Strategy
1.  Go to wclassroom.blogspot.com 2.  Go to Applications, Microsoft Office then Excel.     Open a new spreadsheet. Save it as IF.  3. You need a PEN or PENCIL
Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Practice: @ Open a new Spreadsheet @ In B2 type 3 and in C2 type 5. In E5 type the formula =B2+C2 What if in B2 we change 3 to 300? @ What if we want the spreadsheet program to do some activity if it gets a certain answer? Let’s conduct a test. If you are a boy stand and clap. http://pixabay.com/id/anak-laki-laki-bahagia-pria-147797/ If you are a girl sit and clap. http://commons.wikimedia.org/wiki/File:Adolf_Pirsch_Portrait_of_a_young_girl_with_her_dog_by_the_sea.jpg Now let’s say it a different way. The test is IF you are a boy, if yes stand and clap, if not sit and clap. Why learn IF statements? Besides spreadsheets, if statements are used in video games. #2.3 If Statements in Unity - Game Designer Code - [ Ultimate GameDev Tutorials ]    https://www.youtube.com/watch?v=XWrnCG_hOlI 1:10 to 2:06 Open the PowerPoint called 1 Excel IF statements explained @ How would we write the above example as an if function? Independent Exercise: @ =IF(Logical test is true, then, else)   @ =IF(you are a boy, stand and clap, sit and clap) @ LISTEN before you color! @ Students  will highlight the =IF and () and , in yellow will underline the logical test (what you are looking for) in red                 will underline the if true statement in green and                 will underline the if false statement (also called the else) in blue.                    If time: @ Students will complete the Practice with IF statements on page 13. Remember words need to have quotation marks around them AND     all formulas and functions start with an equal sign.     For example: =IF(A5="Carrot","Vegetable","Amphibian") @ Miss W will review more advance Spreadsheet functions like:     the IF function http://www.youtube.com/watch?v=bQJaWE7qsWw @ Open the Bonus this month if statement file. @ Students will answer questions about on the spreadsheet crossword puzzle.
Higher Order Thinking Questions
How does an IF statement work? Why?
Student Technology/Differentiation
Students will use Excel to create IF statements.
Closure Strategy
Exit Activity 11: Spreadsheet Review Exit Activity 11: Spreadsheet Review    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