Thursday, November 20, 2014

Friday, November 21st Short Cut Links

If you are a 7th Grade student click here http://wclassroom.blogspot.com/2014/11/friday-nov-21st-7th-grade-spreadsheets.html

If you are a 8th Grade student click here http://wclassroom.blogspot.com/2014/11/friday-nov-21st-8th-grade-publisher.html

Friday, Nov 21st- 8th Grade- Publisher Voki on publications and design principles

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 11-21-2014



Teacher:
Witkowski

Lesson/Unit Topic:
Publisher-  Publication Vokis, Presentations, Review for Monday’s Test

Standards:
DB-6 Format Newsletters



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can create a voki about a type of publication or design principle.
Test on Monday
Students create vokis on a publication types and design principles.
Literacy/Vocabulary Strategies (Word Wall)
The a percent % sign shows a number or ratio expressed as a fraction of 100.
Paintings : % percent sign
https://www.flickr.com/photos/veganstraightedge/5533235507
Bell-Ringer/Connecting Strategy
On page 92, type lines 11 and 12.
We are using our LEFT INDEX finger for the % PERCENT  key.
We are using our RIGHT PINKY finger for the SHIFT  key.

Guided Lesson:
@ Review for Monday's test
@ Create vokis on publications and design principles http://www.voki.com/
@ Copy and paste Voki link to Edmodo for Publication Type Presentations
@ Review for test
@ Finish Publication Characteristics Notes PowerPoint
Higher Order Thinking Questions
How do you determine which type of Publication to use?
Student Technology/Differentiation
Students use vokis to learn about Publisher publications.
Closure Strategy
Exit Activity #12:

Exit Activity #13:



Friday, Nov 21st- 7th Grade- Spreadsheets- Count Functions

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 11-21-2014


Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheet- Count functions

Standards:
SSB-1 Know the components of Spreadsheets
SSB-2 Know Spreadsheet operations


“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can create a COUNT function.
Students can create Count functions.

Literacy/Vocabulary Strategies (Word Wall)

The a percent % sign shows a number or ratio expressed as a fraction of 100.
Paintings : % percent sign
https://www.flickr.com/photos/veganstraightedge/5533235507/

Bell-Ringer/Connecting Strategy

On page 92, type lines 11 and 12.
We are using our LEFT INDEX finger for the % PERCENT  key.
We are using our RIGHT PINKY finger for the SHIFT  key.

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

Guided Lesson:
@ Students will start learning about the Count functions.
@ Count and Count A   video http://www.youtube.com/watch?v=4igXvy7JTcU
@ Go to the Spreadsheet folder and open the bottle file.
@ While we are waiting for everyone to get the file open
Bottle breaking slow motion https://www.youtube.com/watch?v=t2NSxiFo1go
@ Put your cursor in B11
@ Type =COUNT(B2:B10) if you did it correctly you should get 6.
@ Type =COUNTA(B2:B10) if you did it correctly you should get 8.
@ Students will start the Overview of Advanced Functions Notes Worksheet by         
completing the notes (copying the Function, Use and Example)     
for Count, and CountA functions.

@ CountIF function video slide 10 of PowerPoint

Independent Exercise
@ Open the CountIF Sports example spreadsheet file to practice the Count functions
    and save to your lunch number.
@ Students will start the Overview of Advanced Functions Notes Worksheet
by completing the notes (copying the Function, Use and Example)     
for the CountIF function.


If time:
@ Microsoft Excel 2010 Data Validationhttp://www.youtube.com/watch?v=qfLirkaWnCY

@ Students will answer questions about on the spreadsheet crossword puzzle.



Higher Order Thinking Questions

What is the difference between the different COUNT functions?

Student Technology/Differentiation

Students will use Excel to create COUNT functions.

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






Thursday, November 20th Short Cut Links

If you are a 7th Grade student click here http://wclassroom.blogspot.com/2014/11/thursday-nov-20th-7th-grade-spreadsheet.html?_sm_au_=iVVZtdJsBt6Zrc7R

If you are a 8th Grade student click here http://www.wclassroom.blogspot.com/2014/11/thursday-nov-20th-8th-grade-publisher.html

Wednesday, November 19, 2014

Thursday, Nov 20th- 8th Grade- Publisher- Publication Review, Voki





Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 11-20-2014




Teacher:
Witkowski

Lesson/Unit Topic:
Publisher-  Publication Review and Voki

Standards:
DB-6 Format Newsletters



tI Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can tell the difference between publications.
Newsletter due today!
Test on Monday.
Students know the difference between publications.


Literacy/Vocabulary Strategies (Word Wall)
How can this newsletter be better?
It needs more white space.
It needs more pictures and citations.
Kindergarten Newsletter by
http://worddraw.deviantart.com/art/White-Cupcake-Clipart-206789145
Bell-Ringer/Connecting Strategy
On page 91, type lines 6 and 7.
We are using our LEFT INDEX finger for the 5  key.
Guided Lesson:
@ Miss W will review the rubric for today’s assignment.
@ Miss W will explain about the Publication Characteristics Notes

Independent Exercise
Thursday’s assignment
1. Your newsletter has a title and you saved it to your lunch number.
2. You have your name on it.
3. You have your book/movie/video game review on it.
4. You have a good headline for your review.
5. You have a picture AND a citation for the picture.
6. You have checked your spelling and grammar.
7. Sentences start with capital letters and end with periods.

Friday’s assignment
8. Type a paragraph about What’s going on in the classroom?
something you enjoyed doing in one of your
academic classes (NOT P.E)
9. Find a clip art picture for it or a picture and citation
10. Create a good headline for it.
11. You have checked your spelling and grammar.
12. Sentences start with capital letters and end with periods.

Monday’s ASSIGNMENT
13. Type a paragraph about a student in a club or sport (see board)
14. Find a clip art picture for it or a picture and citation
15. Create a good headline for it.
16. You have checked your spelling and grammar.
17. Sentences start with capital letters and end with periods.
18. You must show Miss W your teacher interview questions

Tuesday’s Assignment
20. Type a paragraph about A teacher interview
or about an international item (vacation, holiday, etc.
IF YOU DID NOT FINISH INTERVIEW YOU WILL DO THE INTERNATIONAL ITEM.
21. Find a clip art picture for it or a picture and citation
22. Create a good headline for it.
23. You have checked your spelling and grammar.
24. Sentences start with capital letters and end with periods.

Have you…

25.Do you have your headlines in a 3d text box?
Part of the Layout- Headlines Rubric
3D helps to capture the reader’s attention.
Click on headline- Click on Orange Drawing Tools Tab
Click on 3D effects twice.

26.Have you put a frame or border around your pictures?
Part of the Design Elements Rubric
Click on the picture- Click on the Pink Picture Tools Tab
Either click on the border button or the Picture Style button.

Wednesday’s Assignment
27. Add the following building blocks- page parts, ads, accents, calendars
28. Complete or copy and paste and complete index
29. Review design elements
  • pictures and citations for each unless clip art
      • picture frames on first page
      • picture frames or shape with words on second page
  • GOOD headlines (noun and verb)
  • drop capital
  • hyphenation .85 or .8
  • proper white space not too much or too little
  • proper CONTRAST
  • 3D format
  • check spelling and grammar
  • check design does it look nice?
Links to help you to format your newsletter
@ Students will increase the hyphenation to .8
@ Students will use a drop capital for their articles.
@ Students will make their headlines larger and more stylish.
@ Students will make sure their headlines are creative.
Review items 1-29 especially spelling and grammar. REVIEW RUBRIC

Thursday’s work

  1. Create a PowerPoint on the Publication Characteristics Notes
  2. Each bullet needs a clip art image or picture and citation.

If time:

  1. Choose your publication voki topic and create a rough draft.


  1. Start your voki.
Higher Order Thinking Questions
How do I create an interesting newsletter?
Student Technology/Differentiation
Students use Publisher to create a newsletter.
Closure Strategy
Exit Activity #12:

Exit Activity #13: