Monday, May 4, 2015

Tuesday, May 5th- 7th Grade- Spreadsheet If Statements

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 05-05-2015



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)

The exclamation mark shows strong feelings.
Signo De Exclamación, Mark,

Bell-Ringer/Connecting Strategy

We are learning the numeric keypad.
Your thumb goes on the 0 at the bottom
Your  index finger on the 4
Your middle finger on the 5
Your ring finger on the 6
Your pinky will hit the plus sign +

The daily bellringers will now be practicing the number pad
Choose exercise 2 and then click on the word "start."
Time will not start until you put your cursor
in the white rectangle and start typing.
Record your typing speed and accuracy in your typing file

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 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 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 in blue.
                   will highlight the =IF and () and , in yellow

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
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






7 comments: