 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 04-15-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Review for Vocabulary test
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can explain different features of Excel.
Test on Friday. |
Students know the different features of Excel
|
Literacy/Vocabulary Strategies (Word Wall)
| |
Landscape- If you turn a sheet of paper sideways it is called landscape,
because in days past when painters painted landscapes they turned their
canvases sideways. When they painted portraits their canvases were
turned the way you are use to seeing a sheet of paper used.
 | |
Bell-Ringer/Connecting Strategy
| |
On page 76, type lines 18 and 19.
We are using our right MIDDLE finger for the * asterisk key.
We are using our left PINKY finger for the SHIFT key
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
@ Work on Chart Components Notes Worksheet
@ Open the Review for Test Spreadsheet Vocabulary file
@ Miss W will review vocabulary words that will be on test.
Relative Cell Referencing- copies formulas and automatically adjusts to correct cell range.
Absolute cell referencing- formulas do NOT adjust or do NOT change.
For example- $C$12- column A does not change and row 2 does not change.
Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folder
then- rose variety file.
1. Look at cell C2 is it a value or a label in it?
2. Are values (numbers) aligned to the left or to the right?
3. Look at cell B3 is it a value of a label in it?
4. Are labels (words) aligned to the left or to the right?
5. What part of the spreadsheet is labeled with numbers?
6. What part of the spreadsheet is labeled with letters?
7. Put your cursor on D3. What does the dark border around it mean?
8. What does the entry bar show when your cursor in on D3?
9. What symbol do all formulas start with?
10. What are the symbols -, +, *, and / called?
11. When typing values (numbers) into a spreadsheet what two things should you not include?
12. What are the rectangular boxes on a spreadsheet called?
13. The fx button means function. What is a function?
14. What function could we use to add the percentages from D3 through D11?
15. When we highlighted cells D3 through D11, we selected them a group of cells and treated them like a unit. What is the name of that vocabulary term?
16. Go to sheet 2. Type in Monday in A1. Click on A1 and drag the cursor down. What did you just do?
17. If we took the rose names and put them in Z to A order, what type of order did we do?
18. If we took the rose names and put them in A to Z order, what type of order did we do?
19. The percentage of total adds up to 100%; what type of chart is best to show parts of a whole?
20. The garden company tracked their stock over time; what type of chart is best?
21. The garden company wants to track how all of their flowers did just not roses; what is the best type of chart to compare things?
22. When they make a pie chart, a small box shows that the Red Delight roses have a red pie piece, and the Yellow Button roses have a yellow pie piece. What is the name of the guide for this chart?
Hint: Paul Bunyan is also called by the same name.
23. If we a piece of paper sideways so it is longer on the top than the sides; what is it called?
24. The horizontal and vertical lines on the chart that can be hidden or shown on the screen or when you print are called what term?
25. What is it called when you copy formulas and they automatically adjust to the correct cell ranges?
Independent Exercise:
@ Students will practice identifying the spreadsheet vocabulary words.
@ Students will try to guess from the Voki's descriptions which Pink Sheet Vocabulary Word it is.
@ Students will study for Friday’s Spreadsheet vocabulary test
If time: Introduction to Relative References Video http://www.youtube.com/watch?v=Wli4L_tECPg
@ Go to the Spreadsheet folder, then the Relative Cell Reference folder, then
Open choco nutties file
@ Create the formula making B2 an absolute cell reference, $B$2.
| |
Higher Order Thinking Questions
| |
What are the different definitions involved with spreadsheets?
| |
Student Technology/Differentiation
| |
Students will use software to study for the vocabulary test. .
| |
Closure Strategy
| |
Exit Activity #8:
Simple Matching http://www.quia.com/mc/1799176.html
Exit Activity #9:
Choose home row and easy. Turn off sound.
Exit Activity#10:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.
| |
No comments:
Post a Comment