 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 10-23-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets-
Formatting Spreadsheets
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can format spreadsheets.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
The Entry bar or formula bar shows the active cell’s information.
It is sometimes called the formula bar because you can see the formula when you click on the active cell
Look at the black border around the active cell D8.
The ##### in cell reference C3 means the cell is too small to show the number, widen the cell.
Look at how the values (numbers) are aligned to the right margin.
Look at how the labels (words) are aligned to the left margin.
http://spreadsheets.about.com/od/excelformulas/ss/2011-01-16-excel-formulas-overview.htm
| |
Bell-Ringer/Connecting Strategy
| |
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
Learn the following flashcard skills:
02 Color Scales- Home tab, click Conditional Formatting, click color scales
04 Sparklines-
Insert tab, click Column Sparklines, highlight where you want sparklines, click Marker color, Negative points red (Notice the absolute value)
Insert tab, click Line Sparklines, highlight where you want sparklines, click Show Marker
06 Alignment of data - Home tab- top of the alignment group
14 Merge Cells- Home tab, Merge and center button
16 Hide and Show Rows- right click on row 12 and choose hide, highlight column labels E and G and right click and choose unhide.
19 Hide worksheet- right click on tab and choose hide
Independent Exercise:
Open your Hurricanes file:
1. Use any color scale on column E.
2. Merge cells H4 and I4.
3. Hide column B.
4. Insert column sparklines at the bottom of Column D in cell D14.
5. Align the hurricane names in Column A counter clockwise.
| |
@ Miss W will explain the critique or review process for the Educational PowerPoint candy challenge. Each day, students will vote on which PowerPoint they think has the best design. For you to win candy, you MUST BE SPECIFIC AND GIVE DETAILS.
An example of a bad review: I liked it.
An example of a good review: The contrasting colors made it stand out, I liked the fade out animations. I really learned about weather when they explained how snow is created.
| |
Closure Strategy
| |
Exit Activity#11:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.
| |
Lesson Reflections
| |
No comments:
Post a Comment