Tuesday, March 6, 2018

Wednesday, March 7th- 8th Grade- Finish Franchise Project and record Audio

Archdale-Trinity Middle School
Lesson Plan
Date: 03-07-2018


Teacher:
Witkowski

Lesson/Unit Topic:
Types of Business Organizations-
Franchise Research Project

Standards:
NCCTE.BU20.01.02 Understand the types of business organizations.


“I Can…” Statement

I can understand the advantages and disadvantages of a franchise.
Test on Friday
.

Literacy/Vocabulary Strategies (Word Wall)
An advantage of a Franchise is the parent company
provides training and advice. A disadvantage of a
Franchise is that they have strict rules and you must
pay a royalty ( a percent of your profits) to them.
















https://tinobusiness.com/wp-content/uploads/2015/09/franchise-concept-chart-keywords-icons-48905302-e1442314550985.jpg
Bell-Ringer/Connecting Strategy
  1. Go to wclassroom.blogspot.com
      2.  Open your Franchise PowerPoint

     3.  Get out your blue sheets and your white franchise sheets

      4. In groups, complete Exit Activity 2

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

@ Miss W will review the Franchise Project rubric

@ Miss W will show sample of Franchise Project

@ Miss W will review PowerPoint skills needed for Franchise Project

@ Students will practice Exit Activity 



Independent Exercise:

PROJECT INSTRUCTIONS 
1.Open 1.02 Franchise Research Project

2. Finish the PowerPoint part of the project (answers, pictures, animations, transitions)

3. Finish the script. Why should someone buy your franchise?
Use the ongoing support items. 
 It is NOT a commercial to go to the place, it is a commercial to BUY the franchise


Headset WARNING:
No 2nd chances. Do NOT "play" with headset.
Do not throw, play with microphone, etc.

Make sure volume is turned up on computer and headset

@Recording Audio in Microsoft Office PowerPoint 2010
   1 min review how to put on youtube     http://www.youtube.com/watch?v=8_WCAInVLrQ


Follow along with Miss W to add your audio clip

  1. go to the Slide Show tab
  2. choose Record Slide Show
  3. choose Start Recording from Beginning
  4. make sure both boxes are checked
  5. when you are finished go to File then Save AND Send then choose Create a Video
  6. Open a PowerPoint and save to your lunch number
  7. On the title slide- Go to the Insert tab and then insert video
  8. We have now embedded a video into your PowerPoint

4. Save to presentation folder and help other students

@ When you are finished save to My Computer- Student Docs-

     Witkowski folder- Exploring Business folder- Business folder

-
     A Franchise Research Project folder then 1st period or 2nd period


     Make sure your name is in file name



to get information about your Franchise        k= thousands of dollars    m=  millions of dollars


Monday, March 5, 2018

Tuesday, March 6th Short Cut Links

Click here if you are a 8th Grade Student     http://wclassroom.blogspot.com/2018/03/tuesday-march-6th-8th-grade-continue.html?_sm_au_=iVVjHrsQvQD0v5tr

Click here if you are a 7th Grade Student   http://wclassroom.blogspot.com/2018/03/tuesday-march-6th-7th-grade-using.html?_sm_au_=iVVjHrsQvQD0v5tr

Tuesday, March 6th- 7th Grade- Using Functions

Archdale-Trinity Middle School
Lesson Plan
 
Date: 03-06-2018


Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets- Formatting Data

Standards:
SSB-1 Know the components of Spreadsheets
SSB-3 Know spreadsheet operations


“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can use a function.
TEST ON Friday
Students use different features of Excel.

Literacy/Vocabulary Strategies (Word Wall)
Format table- to give the data in a spreadsheet  color and design
Excel spreadsheets
Bell-Ringer/Connecting Strategy
1. Open Copy of Car Lot

2. Open 1 Spreadsheet Vocabulary file.


3. Get out your CAR DATA

4. Go to wclassroom.blogspot.com

5. Go to Applications then Microsoft Office 2016 then Excel 2016 and open a blank worksheet

Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:
@ What is a function?

Independent Activity:

Open a new Excel spreadsheet
In F2 type 20
In F3 type 30
In F4 type 40
In F5 type 50
In F6 type 60
We will type out a formula =F2+F3+F4+F5+F6 and then we type out function to see how functions are shortcuts. =Sum(F2:F6)
It is important to understand the parts of a function (equals sign, function name, parentheses, beginning of the range, colon, ending of the range and parentheses).
Open the Understanding Functions Word document


Open up the "3 Function practice independent activity” .
Excel 2010 Tutorial- Functions
1 min to 3 min Functions
3 mins to 4:30 mins Range
4:30 mins to 8:30 mins Practice
Stop at Count function at 8:30 mins


Slides 34 (functions- built in calculations) through 40
Answer questions 20 through 23
FLASH CARD 7 FORMAT TABLE
Finish car lot data sheet.
Open copy of car lot file and type the first 5 cars and SAVE.



On your car lot spreadsheet complete the following formatting:

1. choose a "format as table" style,

Skill 7- format table any color, (Home tab- format as table arrow)

Sorting

Make sure you have chosen a "Format as Table" style.

Click on the sort arrow by the price.
We are going to sort the most expensive car.
We are going to sort for the least expensive car.
Click on the sort arrow by the miles.
We are going to sort the car with the most miles.
We are going to sort the car with the least miles.
2. change the color of the 3 tabs,
Skill 23- change color of tabs,
       (Right click on tab, click on change color, choose color)
3. create a "thick box" border (any color) around your favorite car,
Skill 31 formatting cells- (highlight car, choose border button)
4. fill in that cell with any color (choose paint bucket)
5. and change the data format in the price column to currency.
Skill 31 formatting cells- change price column to currency             
       (highlight prices, then click on number format arrow)
6. create data bars of any color in your price field
Skill 13- data bars on price column any color,     
   (Home tab- Conditional Formatting button)
7. hide the row of the car you like the least
Right click on number of car you do not like and choose hide.
Open the Spreadsheet Vocabulary file
Slides 22 through 34

Higher Order Thinking Questions
What are the order of operation for a spreadsheet formula?
Student Technology/Differentiation
Students will use Excel to understand a formula’s order of operation.
Closure Strategy
Exit Activity 1: Uses of Spreadsheets http://www.quia.com/mc/2494317.html


These are the test questions.
Hints:
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars

Tuesday, March 6th- 8th Grade- Continue Franchise Project

Archdale-Trinity Middle School
Lesson Plan
Date: 03-06-2018


Teacher:
Witkowski

Lesson/Unit Topic:
Types of Business Organizations-
Franchise Research Project

Standards:
NCCTE.BU20.01.02 Understand the types of business organizations.


“I Can…” Statement

I can understand the advantages and disadvantages of a franchise.
Test on Friday
.

Literacy/Vocabulary Strategies (Word Wall)
An advantage of a Franchise is the parent company
provides training and advice. A disadvantage of a
Franchise is that they have strict rules and you must
pay a royalty ( a percent of your profits) to them.
















https://tinobusiness.com/wp-content/uploads/2015/09/franchise-concept-chart-keywords-icons-48905302-e1442314550985.jpg
Bell-Ringer/Connecting Strategy
  1. Go to wclassroom.blogspot.com
      2.  Open your Franchise PowerPoint

     3.  Get your franchise sheets
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:

@ Miss W will review the Franchise Project rubric

@ Miss W will show sample of Franchise Project

@ Miss W will review PowerPoint skills needed for Franchise Project

@ Students will practice Exit Activity 



Independent Exercise:

PROJECT INSTRUCTIONS 
1.Open 1.02 Franchise Research Project

2. Finish the PowerPoint part of the project (answers, pictures, animations, transitions)

3. Finish the script. Why should someone buy your franchise?
Use the ongoing support items. 
 It is NOT a commercial to go to the place, it is a commercial to BUY the franchise

4. Save to presentation folder and help other students

@ When you are finished save to My Computer- Student Docs-

     Witkowski folder- Exploring Business folder- Business folder

-
     A Franchise Research Project folder then 1st period or 2nd period


     Make sure your name is in file name



to get information about your Franchise        k= thousands of dollars    m=  millions of dollars