Monday, October 26, 2015

Tuesday, October 27th- 7th Grade- Spreadsheets- freeze panes and review



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



Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets-
Formatting Spreadsheets

Standards:
SSB-1 Know the components of Spreadsheets



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can format spreadsheets.
 


Literacy/Vocabulary Strategies (Word Wall)

The Entry bar or formula bar shows the active cell’s information.
It is sometimes called the formula bar because you can see the formula when you click on the active cell
Look at the black border around the active cell D8.
The #####  in cell reference C3 means the cell is too small to show the number, widen the cell.
Look at how the values (numbers) are aligned to the right margin.
Look at how the labels (words) are aligned to the left margin.
Adding Formulas in Excel.
http://spreadsheets.about.com/od/excelformulas/ss/2011-01-16-excel-formulas-overview.htm

Bell-Ringer/Connecting Strategy

  1. Go to wclassroom.blogspot.com
  2. Get out a pen or pencil

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



Guided Practice:
To freeze rows:
  1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we'll select row 3. ...
  2. Click the View tab on the Ribbon.
  3. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. ...
  4. The rows will be frozen in place, as indicated by the gray line.

 
@ Miss W will redemonstrate how to create an accounting border.
     An accounting border has a single line on top and a double line on bottom

Independent Exercise:
 
@ Miss W will explain the critique or review process for the Educational PowerPoint candy challenge. Each day, students will vote on which PowerPoint they think has the best design. For you to win candy, you MUST BE SPECIFIC AND GIVE DETAILS.
  An example of a bad review:  I liked it.
  An example of a good review:  The contrasting colors made it stand out, I liked the fade out animations. I really learned about weather when they explained how snow is created.
@ Students will work in pairs to complete the Spreadsheet Review Worksheet.
@ Students will complete a 2nd PowerPoint Critique.



Closure Strategy

Exit Activity#11:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.  

Lesson Reflections


Posted by at No comments:

Sunday, October 25, 2015

Monday, October 26th Short Cut Links

All missing work due by TODAY. Zeros for anything NOT turned in today.

If you are a 7th Grade Student, click here: http://wclassroom.blogspot.com/2015/10/monday-october-26th-7th-grade.html

If you are a 8th Grade Student, click here: http://wclassroom.blogspot.com/2015/10/monday-october-26th-8th-grade-finish.html
Posted by at No comments:

Monday, October 26th- 8th Grade- Finish Famous Entrepreneur Presentations


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



Teacher:
Witkowski

Lesson/Unit Topic:
Characteristics of a Successful Entrepreneur-
Personal Characteristics and Skills

Standards:
NCCTE.BU20.03.01 Recall personal characteristics and skills needed for a successful entrepreneur



“I Can…” Statement

I can recall personal characteristics and skills needed for a successful entrepreneur.
.


Literacy/Vocabulary Strategies (Word Wall)
Communication skills are necessary for an entrepreneur.
You need to be able to read, write, speak AND listen.
 http://dealsandreels.com/wp-content/uploads/2014/11/Listening-skills.gif


Bell-Ringer/Connecting Strategy
      
     1.  Go to wclassroom.blogspot.com
     2.  Finish Module 3 Your Business Snapshot
3. All Students will go online and review their progress

by checking their grades AND MISSING WORK for at least this class
           
           
Lesson-Instructional Strategies &Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:
@ Entrepreneur PowerPoint and all 3 Everfi Modules are due today!

Independent Exercise:
@ Students will present their Entrepreneur presentations.
    Students will be quiet and respectful during the presentations.
@ Go to http://www.everfi.com/login/
Module 3 Your Business Snapshot
if you answer the questions CAREFULLY, it will merge your answers
to create a "business pitch" for your food cart. You will need this
business pitch so take your time on it.
_______________________________________________

Famous entrepreneur rubric

Slide 1- What accomplishment(s) made them an Entrepreneur

Slides 2, 3, and 4- Give examples of how they have 3 of the following characteristics:
         Persistent, Creative, Responsible, Inquisitive (curious), Goal-oriented,
         Independent, Self-confident, Risk taker
Slides 5 and 6- Give examples of how they have 2 of the following skills:
         Communication skills, Human Relations skills, Math skills,
         Problem-solving skills, Decision-making skills, Technical skills,
         Basic Business Skills

*You will need to READ your PowerPoint, put the examples in your own words.
*Add animations and transitions
*Add one large picture per slide that makes sense for that slide.
*If you get the picture from the internet, you need a citation for it.
*When finished, you will save it to Computer- Student Docs- Witkowski folder- Exploring Business folder- Entrepreneur folder- Famous Entrepreneur folder- Period 6 or Period 7
* Make sure your name is included in the file name.
1*FINISH Famous Entrepreneur PowerPoint
2*FINISH Module 2 Planning a Business 
3*Finish Module 3 Your Business Snapshot
4*Print out your Certificate-  CLICK ON LANDSCAPE
5*Finish Post-survey
6*Hang your Certificate on the outside wall.

If absent:
@ Students will correct test mistakes on https://quizlet.com/
@ Students will finish module 2, Planning and Building a Business (Food Truck) .
@ Go to http://www.everfi.com/login/
@ Take your time and read carefully
@ You are not able to go back and look for the answers so you must read and listen to the videos
  

         


Posted by at No comments:

Monday, October 26th- 7th Grade- Spreadsheets Review



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



Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets-
Formatting Spreadsheets

Standards:
SSB-1 Know the components of Spreadsheets



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can format spreadsheets.
 


Literacy/Vocabulary Strategies (Word Wall)

The Entry bar or formula bar shows the active cell’s information.
It is sometimes called the formula bar because you can see the formula when you click on the active cell
Look at the black border around the active cell D8.
The #####  in cell reference C3 means the cell is too small to show the number, widen the cell.
Look at how the values (numbers) are aligned to the right margin.
Look at how the labels (words) are aligned to the left margin.
Adding Formulas in Excel.
http://spreadsheets.about.com/od/excelformulas/ss/2011-01-16-excel-formulas-overview.htm

Bell-Ringer/Connecting Strategy

  1. Go to wclassroom.blogspot.com
  2. Get out a pen or pencil

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



Guided Practice:
Just like in Math, Spreadsheet formulas follow the PEMDAS rule.


The letters in PEMDAS stand for the following:
P-Parenthesis
E-Exponents
MD-Multiplication and Division
AS-Addition and Subtraction
 
@ Miss W will demonstrate how to create an accounting border.
     An accounting border has a single line on top and a double line on bottom

Independent Exercise:
 
@ Miss W will explain the critique or review process for the Educational PowerPoint candy challenge. Each day, students will vote on which PowerPoint they think has the best design. For you to win candy, you MUST BE SPECIFIC AND GIVE DETAILS.
  An example of a bad review:  I liked it.
  An example of a good review:  The contrasting colors made it stand out, I liked the fade out animations. I really learned about weather when they explained how snow is created.
@ Students will work in pairs to complete the Spreadsheet Review.
@ Students will complete a 2nd PowerPoint Critique.



Closure Strategy

Exit Activity#11:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.  

Lesson Reflections



Posted by at No comments:

Thursday, October 22, 2015

Friday, October 23rd Short Cut Links

All missing work due by TODAY. Zeros for anything NOT turned in today.

If you are a 7th Grade Student, click here: http://wclassroom.blogspot.com/2015/10/friday-october-23rd-7th-grade.html

If you are a 8th Grade Student, click here: http://wclassroom.blogspot.com/2015/10/friday-october-23rd-8th-grade-famous.html
Posted by at No comments:

Friday, October 23rd- 8th Grade- Famous Entrepreneur Presentations


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



Teacher:
Witkowski

Lesson/Unit Topic:
Characteristics of a Successful Entrepreneur-
Personal Characteristics and Skills

Standards:
NCCTE.BU20.03.01 Recall personal characteristics and skills needed for a successful entrepreneur



“I Can…” Statement

I can recall personal characteristics and skills needed for a successful entrepreneur.
.


Literacy/Vocabulary Strategies (Word Wall)
Communication skills are necessary for an entrepreneur.
You need to be able to read, write, speak AND listen.
 http://dealsandreels.com/wp-content/uploads/2014/11/Listening-skills.gif


Bell-Ringer/Connecting Strategy
      
     1.  Go to wclassroom.blogspot.com
     2.  Finish Module 3 Your Business Snapshot
3. All Students will go online and review their progress

by checking their grades AND MISSING WORK for at least this class
           
           
Lesson-Instructional Strategies &Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:
@ Entrepreneur PowerPoint and all 3 Everfi Modules are due today!

Independent Exercise:
@ Students will present their Entrepreneur presentations.
    Students will be quiet and respectful during the presentations.
@ Go to http://www.everfi.com/login/
Module 3 Your Business Snapshot
if you answer the questions CAREFULLY, it will merge your answers
to create a "business pitch" for your food cart. You will need this
business pitch so take your time on it.
_______________________________________________

Famous entrepreneur rubric

Slide 1- What accomplishment(s) made them an Entrepreneur

Slides 2, 3, and 4- Give examples of how they have 3 of the following characteristics:
         Persistent, Creative, Responsible, Inquisitive (curious), Goal-oriented,
         Independent, Self-confident, Risk taker
Slides 5 and 6- Give examples of how they have 2 of the following skills:
         Communication skills, Human Relations skills, Math skills,
         Problem-solving skills, Decision-making skills, Technical skills,
         Basic Business Skills

*You will need to READ your PowerPoint, put the examples in your own words.
*Add animations and transitions
*Add one large picture per slide that makes sense for that slide.
*If you get the picture from the internet, you need a citation for it.
*When finished, you will save it to Computer- Student Docs- Witkowski folder- Exploring Business folder- Entrepreneur folder- Famous Entrepreneur folder- Period 6 or Period 7
* Make sure your name is included in the file name.
1*FINISH Famous Entrepreneur PowerPoint
2*FINISH Module 2 Planning a Business 
3*Finish Module 3 Your Business Snapshot
4*Print out your Certificate-  CLICK ON LANDSCAPE
5*Finish Post-survey
6*Hang your Certificate on the outside wall.

If absent:
@ Students will correct test mistakes on https://quizlet.com/
@ Students will finish module 2, Planning and Building a Business (Food Truck) .
@ Go to http://www.everfi.com/login/
@ Take your time and read carefully
@ You are not able to go back and look for the answers so you must read and listen to the videos
  

         




Posted by at No comments:
Subscribe to: Posts (Atom)