Thursday, December 14, 2017

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. Gambar Vektor Gratis: Anakhttp://pixabay.com/id/anak-laki-laki-bahagia-pria-147797/

If you are a girl sit and clap. of a young girl with herhttp://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 ]   
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:
@ 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

No comments:

Post a Comment