Click here if you are a 8th Grade Student http://wclassroom.blogspot.com/2018/04/tuesday-may-1st-8th-grade-finish.html?_sm_au_=i5VVsTwWfQMWSHHw
Click here if you are a 7th Grade Student http://wclassroom.blogspot.com/2018/04/tuesday-may-1st-7th-grade-continue-if.html?_sm_au_=i5VVsTwWfQMWSHHw
Monday, April 30, 2018
Tuesday, May 1st- 7th Grade- Continue IF functions
Archdale-Trinity Middle School
Lesson Plan
| |
Date: 05-01-2018
|
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.
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:
@ 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.
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")
Using IF statements and
Code with Angry Birds and Plants and Zombies getting out of a maze
https://www.flickr.com/photos/stickergiant/8365977342/
@ 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 |
Tuesday, May 1st- 8th Grade- Finish Resourcing Phase and Begin Actualization Phase
Archdale-Trinity Middle School
Lesson Plan
| |
Date: 05-01-2018
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
The Entrepreneurial Process-
Actualization Phase
| |
Standards:
|
NCCTE.BU20.03.02 Understand entrepreneurship and the entrepreneurial process
|
“I Can…” Statement
| |
I can create business cards
|
Literacy/Vocabulary Strategies (Word Wall)
| |||||||||||||||||||||||||||
In the Actualization phase of the Entrepreneurial process
you would have the Grand Opening and conduct day to day business. 
https://mir-s3-cdn-cf.behance.net/project_modules/max_1200/11e81830242479.561a591088898.jpg
| |||||||||||||||||||||||||||
Bell-Ringer/Connecting Strategy
| |||||||||||||||||||||||||||
Lesson-Instructional Strategies and Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |||||||||||||||||||||||||||
Guided Lesson:
@ Miss W will explain the Actualization Grand Opening Project Rubric
What is the Creativity Grade? How creative is your flyer to get customers to come to it? --- Are the words Grand Opening, in large letters? --- Is there a date and time of the grand opening? --- Do you have a list of fun activities listed? --- There should not be a lot of white space, are the pictures too tiny? --- Did you put the correct information on the tear sheets? --- Does it look nice, see example above or does it look like you just quickly threw something together? ---- Did you just copy and paste and not add anything new? Next test will be NEXT Tuesday
Independent Exercise:
http://fitsmallbusiness.com/grand-opening-ideas/
@ Students will create a PROFESSIONAL Grand Opening Flyer and Business Card
for your Food Truck Business.
@ If you were absent on Monday.
@ Resourcing Phase Review PowerPoint see slide 110
Total of 9 slides- large clip art on each slide
1. Resourcing is the stage in which the entrepreneur identifies and acquires the financial, human, and capital resources needed for the venture startup, etc.
2. Capital resources are equipment and land.
3. Identify potential investors.
4. Apply for loans, grants and financial assistance.
5. Seeks and hires employees.
6. Identifies strategies to protect intellectual property.
7. You apply for a patent to protect an invention.
8.You apply for a trademark to protect a name or logo.
9.You apply for a copyright to protect original art work.
| |||||||||||||||||||||||||||
@ We have not covered the Harvesting Phase yet
Expansion Projects, Creating a 5 year plan, and IPO Initial Public Offering https://www.quia.com/rr/827311.html?AP_rand=944607509 |
Friday, April 27, 2018
Monday, April 30th Short Cut Links
Click here if you are a 8th Grade Student http://wclassroom.blogspot.com/2018/04/monday-april-30th-8th-grade-finish-menu.html?_sm_au_=i5V5M42T7q2Nrsrs
Click here if you are a 7th Grade Student http://wclassroom.blogspot.com/2018/04/monday-april-30th-7th-grade-begin-if.html?_sm_au_=i5V5M42T7q2Nrsrs
Click here if you are a 7th Grade Student http://wclassroom.blogspot.com/2018/04/monday-april-30th-7th-grade-begin-if.html?_sm_au_=i5V5M42T7q2Nrsrs
Monday, April 30th- 7th Grade- Begin IF statements
Archdale-Trinity Middle School
Lesson Plan
| |
Date: 04-30-2018
|
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 ]
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 |
Subscribe to:
Posts (Atom)