Docstoc

Spreadsheet Vocabulary

Document Sample
Spreadsheet Vocabulary Powered By Docstoc
					                                             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

				
DOCUMENT INFO
Description: Spreadsheet Vocabulary document sample