 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 1-06-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- Review
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
SSB-2 Creation and Formatting of Spreadsheets
SSB-3 Know spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can do well on the spreadsheet review.
Review Test on Thursday.
|
Students do well on the spreadsheet review.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
What if the tax rate was .08, would you need to type the formula again?
What do all formulas begin with? What does the * do?
Is “cost of car” a label or a value? Name a value?
B6 has a dark border around the cell. What is B6 called?
What do rows have in front of them? Are columns vertical or horizontal?
What is B4 called? Begins with a “c”
http://spreadsheets.about.com/od/exceltips/qt/what_if_tip.htm
| |
Bell-Ringer/Connecting Strategy
| |
On page 363, type sentence 3 and 4 in the top paragraph.
Today’s typing is a general review using all of the alphabetic key strokes we have learned this semester.
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Lesson:
Spreadsheet Review:
Review the following files in the 7th Grade Review folder to answer the questions or fill in the blanks:
Independent Exercise:
Look at the Review for Test Spreadsheet Vocabulary PowerPoint to fill in the blanks.
Descending order- is ____________ to __________ sort order or 100 to 1 order.
Relative cell referencing- _____________ formulas and automatically ____________ to correct cell range.
In contrast, an __________________ cell reference does not change when its formula is copied and pasted to other cells.
Which symbol is used for absolute cell references? ______________
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
___Go to Types of Charts PowerPoint and look on slide 3 to fill in the blanks.
_____________________Chart- comparisons
Stacked Bar Chart - charts each group’s ________________________________to the whole.
Line Charts show ________________________ or changes in data over time.
XY Scatter Charts are used to indicate the __________________________ of two or more sets of data.
Pie Charts answers the question “What is the ________________________of each part to the whole?”
Exploded Pie Chart is an ___________________________ pie chart.
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
___Look at the 4.01 Advanced Functions document to answer the questions and fill in blanks.
Which function allows the computer to insert dates according to your instructions? ___________
VLOOKUP- Looks for a value in the ___________________________ column of a table, and then gives you a value in the ________________________row from the column specified.
Which function counts the number of cells within a range when given specific conditions?
To create a list: Type and highlight the __________________ you want to use. Next you will ________________________ the list in the name box (beside the ____________________Bar) then ___________________________ the cell that you want the drop-down list to appear in. Then do to _____________, Validation, Allow: List, and then source: ____(the name of your list)
Which function helps you control the kind of info that is entered into a worksheet? A drop-down list would be an example because you could only choose information that was entered into the list. ___________________________________
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
___Look at the Excel if statements explained PowerPoint
Write the IF statement for IF A2 is equal to “Feline”, write “Cat” in B2, otherwise, write “Amphibian”
___________________________________________________________________________
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Play the SCATTER GAMES on the quizlet sites
___ match words to definitions for the link below
___ You can use notes. You must get 100% for the link below. http://www.quia.com/quiz/2055803.html?AP_rand=1395669365
| |
Higher Order Thinking Questions
| |
Explain why sometimes absolute cell referencing is needed.
| |
Student Technology/Differentiation
| |
Students will use online sites to review spreadsheet concepts.
| |
Closure Strategy
| |
Exit Activity 12: 10 Steps of a Presentation
Do NOT look at the PowerPoint
| |
 |
No comments:
Post a Comment