Get documents about "Spreadsheet Vocabulary
Description
Spreadsheet Vocabulary document sample
Document Sample
Gulfport School District
Gulfport Central Middle School
2009-2010 Lesson Plan
Teacher: Brandi Savant/Corey Lombard Grade: 8th Subject: ICT II
Day: Monday Date: December 7, 2009 Unit 3: Tech. Productivity Tools:
Spreadsheet Applications
Lesson Plans
Competency 1: Explain spreadsheet applications. CP1, CP2, CP3, Time Standards Checklist
CP4, CP5, CF2, KA1, KA2 MicroPace,
Competency 2: Perform spreadsheet applications. CP1, CP2, CP3, rcu.blackboard.com,
CP4, CP5, CF2, KA3 Microsoft Word 2007 ,
Compentency 3: Create and graph spreadsheet data. CP1, CP2, Microsoft Excel 2007
CP3, CP4, CP5, CF2, KA1, KA2, KA3, LO2 www.freetypinggame.net
WOW Qualities Content/Sub
Objectives: a. Org of Knowledge b.
1a. Identify and key terminology used with spreadsheet Product Focus c. Clear
applications. 1b Identify the basic components of a spreadsheet Standard/Protection d.
application screen. 1c. Research, key, illustrate, and print Affirmation/Affiliation e.
terminology related to spreadsheet applications. 2a. Demonstrate Novelty/Variety f. Choice g.
the use of basic spreadsheet format commands. 2b. Write Authenticity
formulas using basic arithmetic operations. 2c. Demonstrate the
Components
use of basic spreadsheet functions 2d. Modify worksheet data 2e.
Structure and format data in a worksheet 2f. Sort and manipulate
a. Assessment
data using formulas and functions 2g. Create and modify charts in a b. Fluency
worksheet. 2h. Print a worksheet 3a. Apply spreadsheet c. Comprehension
applications to integrated academic activities 3b. Create a budget d. Vocabulary
narrative that integrates spreadsheet and word processing e. Oral Language
applications. f. Independent Reading
Bell Ringer: 7 min. g. Word Attach
a. Log in to Computer h. Content Text
b. MCT 2 Vocabulary: students will have 5 new terms to i. Journal/Writing
define. (procedure, to justify, inquiry, to evaluate, supporting Skills Covered
evidence) Keyboarding
c. Check Daily Agenda on Blackboard Timed Writing Tests
Logging on to Blackboard
Navigating Blackboard
Anticipatory Set: What do you think should be on the exam? 2 min. MicroPace
Modeling: Teacher will model on the Promethean how the Windows Review
nine weeks exam was created using pool of questions from Word 2007 Review
previous tests.
Guided Practice: 15 min.
a. Teacher will model on the Promethean how to copy
questions from Blackboard to Microsoft Word.
Independent Practice/Affiliation: 29min.
a. Student will work independently to create mock exams
from their previous tests to use as study guides. Students
will then quiz each other by exchanging study guides.
b. Students will work on Micro Pace lessons.
Closure: Ask for questions and have students log off. 2 min.
Technology: Computer, Promethean Board Homework: None Interventions: Assist any student having difficulty
Gulfport School District
Gulfport Central Middle School
2009-2010 Lesson Plan
Teacher: Brandi Savant/Corey Lombard Grade: 8th Subject: ICT II
Day: Tuesday Date: December 8, 2009 Unit 3: Tech. Productivity Tools:
Spreadsheet Applications
Competency 1: Explain spreadsheet applications. CP1, CP2, CP3, Time Standards Checklist
CP4, CP5, CF2, KA1, KA2 MicroPace,
Competency 2: Perform spreadsheet applications. CP1, CP2, CP3, rcu.blackboard.com,
CP4, CP5, CF2, KA3 Microsoft Word 2007 ,
Compentency 3: Create and graph spreadsheet data. CP1, CP2, Microsoft Excel 2007
CP3, CP4, CP5, CF2, KA1, KA2, KA3, LO2 www.freetypinggame.net
WOW Qualities Content/Sub
Objectives: a. Org of Knowledge b.
1a. Identify and key terminology used with spreadsheet Product Focus c. Clear
applications. 1b Identify the basic components of a spreadsheet Standard/Protection d.
application screen. 1c. Research, key, illustrate, and print Affirmation/Affiliation e.
terminology related to spreadsheet applications. 2a. Demonstrate Novelty/Variety f. Choice g.
the use of basic spreadsheet format commands. 2b. Write Authenticity
formulas using basic arithmetic operations. 2c. Demonstrate the
Components
use of basic spreadsheet functions 2d. Modify worksheet data 2e.
Structure and format data in a worksheet 2f. Sort and manipulate
a. Assessment
data using formulas and functions 2g. Create and modify charts in a b. Fluency
worksheet. 2h. Print a worksheet 3a. Apply spreadsheet c. Comprehension
applications to integrated academic activities 3b. Create a budget d. Vocabulary
narrative that integrates spreadsheet and word processing e. Oral Language
applications. f. Independent Reading
Bell Ringer: 7 min. g. Word Attach
a. Log in to Computer h. Content Text
b. MCT 2 Vocabulary: students will have 5 new terms to i. Journal/Writing
define. (procedure, to justify, inquiry, to evaluate, supporting Skills Covered
evidence) Keyboarding
c. Check Daily Agenda on Blackboard Timed Writing Tests
Logging on to Blackboard
Navigating Blackboard
Anticipatory Set: What do you think should be on the exam? 2 min. MicroPace
Modeling: Teacher will model on the Promethean how the Windows Review
nine weeks exam was created using pool of questions from Word 2007 Review
previous tests.
Guided Practice: 15 min.
a. Teacher will model on the Promethean how to copy
questions from Blackboard to Microsoft Word.
Independent Practice/Affiliation: 29min.
a. Student will work independently to create mock exams
from their previous tests to use as study guides. Students
will then quiz each other by exchanging study guides.
b. Students will work on Micro Pace lessons.
Closure: Ask for questions and have students log off. 2 min.
Technology: Computer, Promethean Board Homework: None Interventions: Assist any student having difficulty
Gulfport School District
Gulfport Central Middle School
2009-2010 Lesson Plan
Teacher: Brandi Savant/Corey Lombard Grade: 8th Subject: ICT II
Day: Wednesday Date: December 9, 2009 Unit 3: Tech. Productivity Tools:
Spreadsheet Applications
Lesson Plan
Competency 1: Explain spreadsheet applications. CP1, CP2, CP3, Time Standards Checklist
CP4, CP5, CF2, KA1, KA2 MicroPace,
Competency 2: Perform spreadsheet applications. CP1, CP2, CP3, rcu.blackboard.com,
CP4, CP5, CF2, KA3 Microsoft Word 2007 ,
Compentency 3: Create and graph spreadsheet data. CP1, CP2, Microsoft Excel 2007
CP3, CP4, CP5, CF2, KA1, KA2, KA3, LO2 www.freetypinggame.net
Objectives: WOW Qualities Content/Sub
1a. Identify and key terminology used with spreadsheet a. Org of Knowledge b.
applications. 1b Identify the basic components of a spreadsheet Product Focus c. Clear
application screen. 1c. Research, key, illustrate, and print Standard/Protection d.
terminology related to spreadsheet applications. 2a. Demonstrate Affirmation/Affiliation e.
the use of basic spreadsheet format commands. 2b. Write
Novelty/Variety f. Choice g.
formulas using basic arithmetic operations. 2c. Demonstrate the
Authenticity
use of basic spreadsheet functions 2d. Modify worksheet data 2e.
Structure and format data in a worksheet 2f. Sort and manipulate Components
data using formulas and functions 2g. Create and modify charts in a a. Assessment
worksheet. 2h. Print a worksheet 3a. Apply spreadsheet b. Fluency
applications to integrated academic activities 3b. Create a budget c. Comprehension
narrative that integrates spreadsheet and word processing d. Vocabulary
applications. e. Oral Language
Bell Ringer: f. Independent Reading
a. Log in to Computer 7 min. g. Word Attach
b. MCT 2 Vocabulary: students will have 5 new terms to h. Content Text
define. (to entertain, bold-faced print, to persuade, bulleted i. Journal/Writing
lists, to inform) Skills Covered
c. Check Daily Agenda on Blackboard Keyboarding
Timed Writing Tests
Anticipatory Set: Are there any questions before we take Logging on to Blackboard
our MPT? Navigating Blackboard
MicroPace Windows
Modeling: Remind students how to access the Exam on Blackboard. 2 min. Review Word Review
Guided Practice: 5 min.
a. Teacher will help students log in and take their Exam
Independent Practice/Affiliation:
a. Students will complete Nine Week Exam 39min.
b. Students will complete any unfinished assignments from this
week.
c. Students will work on lessons in MicroPace. 2 min.
Closure: Ask for questions and have students log off.
mputer, Promethean Board Homework: None Interventions: Assist any student having difficulty
Gulfport School District
Gulfport Central Middle School
2009-2010 Lesson Plan
Teacher: Brandi Savant/Corey Lombard Grade: 8th Subject: ICT II
Day: Thursday Date: December 10, Unit 3: Tech. Productivity Tools:
2009 Spreadsheet Applications
Competency 1: Explain spreadsheet applications. CP1, CP2, CP3, Time Standards Checklist
CP4, CP5, CF2, KA1, KA2 MicroPace,
Competency 2: Perform spreadsheet applications. CP1, CP2, CP3, rcu.blackboard.com,
CP4, CP5, CF2, KA3 Microsoft Word 2007 ,
Compentency 3: Create and graph spreadsheet data. CP1, CP2,
CP3, CP4, CP5, CF2, KA1, KA2, KA3, LO2
Microsoft Excel 2007
www.freetypinggame.net
Objectives: WOW Qualities Content/Sub
1a. Identify and key terminology used with spreadsheet a. Org of Knowledge b.
applications. 1b Identify the basic components of a spreadsheet Product Focus c. Clear
application screen. 1c. Research, key, illustrate, and print Standard/Protection d.
terminology related to spreadsheet applications. 2a. Demonstrate Affirmation/Affiliation e.
the use of basic spreadsheet format commands. 2b. Write Novelty/Variety f. Choice g.
formulas using basic arithmetic operations. 2c. Demonstrate the
Authenticity
use of basic spreadsheet functions 2d. Modify worksheet data 2e.
Components
Structure and format data in a worksheet 2f. Sort and manipulate
data using formulas and functions 2g. Create and modify charts in a a. Assessment
worksheet. 2h. Print a worksheet 3a. Apply spreadsheet b. Fluency
applications to integrated academic activities 3b. Create a budget c. Comprehension
narrative that integrates spreadsheet and word processing d. Vocabulary
applications. e. Oral Language
Bell Ringer: f. Independent Reading
a. Log in to Computer 7 min. g. Word Attach
b. MCT 2 Vocabulary: students will have 5 new terms to h. Content Text
define. (to entertain, bold-faced print, to persuade, bulleted i. Journal/Writing
lists, to inform) Skills Covered
c. Check Daily Agenda on Blackboard Keyboarding
Timed Writing Tests
Anticipatory Set: Who has already made their Christmas Logging on to Blackboard
Wish List? Navigating Blackboard
MicroPace Windows
Modeling: Teacher will introduce "All I want for Christmas" Review Word Review
Assignment and show an example of a completed project. 2 min.
Guided Practice:
a. Teacher will guide students in setting up the first column in their
spreadsheet.
Independent Practice/Affiliation: 34 min.
a. Given a budget of $1000, Students will create a wish list
using Microsoft Excel. First, students will estimate the cost
of each item. Then using specific websites students will
research the actual cost of the item and find a picture of each
item. Students will include all of this information in their
spreadsheet.
b. Finish Exam if needed. 10 min.
Closure: Ask for questions and have students log off. 2 min.
mputer, Promethean Board Homework: None Interventions: Assist any student having difficulty
Gulfport School District
Gulfport Central Middle School
2009-2010 Lesson Plan
Teacher: Brandi Savant/Corey Lombard Grade: 8th Subject: ICT II
Day: Friday Date: December 11, Unit 3: Tech. Productivity Tools:
2009 Spreadsheet Applications
Lesson Plan
Competency 1: Explain spreadsheet applications. CP1, CP2, CP3, Time Standards Checklist MicroPace,
CP4, CP5, CF2, KA1, KA2 rcu.blackboard.com, Microsoft
Competency 2: Perform spreadsheet applications. CP1, CP2, CP3, Word 2007,
CP4, CP5, CF2, KA3 www.freetypinggame.net
Compentency 3: Create and graph spreadsheet data. CP1, CP2,
CP3, CP4, CP5, CF2, KA1, KA2, KA3, LO2
WOW Qualities Content/Sub
a. Org of Knowledge b. Product
Objectives: Focus c. Clear
1a. Identify and key terminology used with spreadsheet Standard/Protection d.
applications. 1b Identify the basic components of a spreadsheet Affirmation/Affiliation e.
application screen. 1c. Research, key, illustrate, and print Novelty/Variety f. Choice g.
terminology related to spreadsheet applications. 2a. Demonstrate Authenticity
the use of basic spreadsheet format commands. 2b. Write Components
formulas using basic arithmetic operations. 2c. Demonstrate the a. Assessment b.
use of basic spreadsheet functions 2d. Modify worksheet data 2e. Fluency c.
Structure and format data in a worksheet 2f. Sort and manipulate Comprehension
data using formulas and functions 2g. Create and modify charts in a d. Vocabulary
worksheet. 2h. Print a worksheet 3a. Apply spreadsheet e. Oral Language f.
applications to integrated academic activities 3b. Create a budget Independent Reading
narrative that integrates spreadsheet and word processing g. Word Attach
applications. h. Content Text
i. Journal/Writing
Bell Ringer:
Skills Covered
a. Log in to Computer 7 min.
Keyboarding
b. MCT 2 Vocabulary: students will have 5 new terms to Timed Writing Tests
define. (public awareness, to narrate, necessity, conclusion, Logging on to Blackboard
public involvement) Navigating Blackboard
c. Check Daily Agenda on Blackboard MicroPace Windows
Review Word 2007
Anticipatory Set: Who is over budget on their All I want for Review
Christmas project?
Modeling: Teacher will model "All I want for Christmas"
Assignment and show an example of a completed project. 2 min.
Guided Practice: 15 min.
a. Teacher will guide students in setting up the first column in their
spreadsheet.
Independent Practice/Affiliation:
a. Given a budget of $1000, Students will create a wish list
using Microsoft Excel. First, students will estimate the cost
of each item. Then using specific websites students will
research the actual cost of the item and find a picture of each
item. Students will include all of this information in their
spreadsheet. 29 min.
b. Students will work on Micro Pace lessons.
Closure: Ask for questions and have students log off. 2 min.
Technology: Computer, Promethean Board Homework: None Interventions: Assist any student having difficulty
Related docs
