Wednesday, October 3, 2012

Thursday, Oct 4 Spreadsheets- Entering formulas

Bellringer- We are learning the number keypad. http://www.typeonline.co.uk/number_pad_lesson2.html
Choose exercise 2 and then click on the word “start.”
Time will not start until you put your cursor in the white rectangle and start typing.
Record your typing speed and accuracyTo hear bellringer message
What are we learning today?
How to enter formulas that calculate the values in spreadsheets.

Guided Lesson:
 “Spreadsheet PowerPoint Presentation” parts of spreadsheet vocabulary describing- cell, column, row, cell range, cell address, and active cell, label, value and formulas

Slides 25 and 27

Note: Just because you are learning about many different ways to format data doesn't mean you want to use all of the methods at once.

Daily spreadsheet skill exercises
Open Exercise Skill 1 ascending order (Home tab)then Skill 13- data bars (Conditional Formatting button)Skill 21- hide gridlines (Page layout tab)

Independent exercise:

Green formula sheet exercise AND
Write down study guide questions 14, 15, 16 and 17 and write down a, b, c or d for the answers.


Guided Lesson:
Correct study guide questions
Write corrected and complete answers for study guide questions 14, 15, 16 and 17

Start on the Excel Home Tab Ribbon Sheet Worksheet
you may write or type the answers but do NOT print until Miss W checks it.


Exit Activity- SmartBoard formative testing of vocabulary How much do you remember about Spreadsheets? By yourself or with a partner take turns and play http://www.quia.com/hm/174125.html?AP_rand=933500499&playHTML=1

No comments:

Post a Comment