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
Thursday, November 20, 2014
Friday, Nov 21st- 8th Grade- Publisher Voki on publications and design principles
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.
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:
Million dollar Game http://www.quia.com/rr/531753.html
Exit Activity #13:
Publisher Ribbon http://www.quia.com/mc/320506.html
|
Friday, Nov 21st- 7th Grade- Spreadsheets- Count Functions
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.
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.
@ Go to the Spreadsheet folder and open the bottle file.
@ While we are waiting for everyone to get the file open
@ 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
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
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. 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
Links to help you to format your newsletter
Review items 1-29 especially spelling and grammar. REVIEW RUBRIC
Thursday’s work
If time:
|
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:
Million dollar Game http://www.quia.com/rr/531753.html
Exit Activity #13:
Publisher Ribbon http://www.quia.com/mc/320506.html
|
Subscribe to:
Posts (Atom)