Friday, January 12, 2018

Tuesday, January 16th- 7th Grade- Spreadsheet Vocabulary Review

Archdale-Trinity Middle School
Lesson Plan

Date: 1-16-2018


Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets

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



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can explain spreadsheet terms
Vocabulary TEST this Thursday or Friday



Literacy/Vocabulary Strategies (Word Wall)





























Words are aligned to the left. 


Bell-Ringer/Connecting Strategy


1. Go to wclassroom.blogspot.com



2. Open  Review for Test Spreadsheet Vocabulary PowerPoint
3. You need a pen or pencil

4. Do NOT ask to get water, after Miss W gives instructions you may go
                      

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

Guided Lesson:
@ Miss W will review spreadsheet terms
@ Miss W will review Candy Poster Contest Rules


You need to do 100% of the questions
and you need to get 70% or higher

You may use PowerPoint, paper or friends
but you each must complete exit activity

When it is your water break...
Vote for the 5 Best Posters for your period
You may vote for yourself 
Do NOT tell anyone your number or disqualified
Do NOT make fun of poster or disqualified
Do not take too long or you will lose your votes

Independent Exercise
@ Students will review basic Spreadsheet terms.

If absent on Friday: 
@ Students will create a Spreadsheet vocabulary poster
on a word(s) they find hard to remember.
Rubric-
Spelling- 10
Creativity-  did picture and words make sense and you thought about design- 20
Effort- did you spend time on it- 20
Neatness of writing and pictures- 20
Coloring of poster- 20
Name is on BACK of poster- 10



Review for Test Spreadsheet Vocabulary PowerPoint Presentation”

How much do you remember about Spreadsheets?
By yourself or with a partner take turns and play


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

if time:  https://kahoot.it/


Higher Order Thinking Questions

How are tables formatted?

Student Technology/Differentiation

Students will review how to format a table. 

Closure Strategy


No comments:

Post a Comment