Bellringer- We are learning the number keypad. http://www.typeonline.co.uk/number_pad_lesson2.html
Choose exercise 1 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 accuracy
To hear bellringer message
What are we learning today? Choose exercise 1 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 accuracy
To hear bellringer message
How formulas calculate the values in spreadsheets.
Guided Lesson:
Slides 18 and 19
Open Exercise 31 Skill- Changing data to currency Skill- using the fill color
Independent Exercise:
On your car lot spreadsheet complete the following formatting:
1. choose a "format as table" style,
2. change the color of the 3 tabs,
3. create a "thick box" border (any color) around your favorite car,
4. fill in that cell with any color
5. and change the data format in the price column to currency.
6. Write down study guide question 13 and write down a, b, c or d for the answer.
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 20-30)
Independent exercise:
Green formula sheet exerciseWrite down study guide question 14, 15 and 16 and write down a, b, c or d for the answers.
Correct study guide questions
Group slide 27 exercise- more complicated formulas
Write corrected and complete answers for study guide questions 14, 15 and 16
Daily spreadsheet skill exercises-
Skill 15- replace formulas with calculated value, skill 1 ascending order, Skill 13- data bars,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