Spreadsheets

To learn how to use Microsoft Excel to create graphs and analyze information.

Each student will be able to:

1. List five terms associated with spreadsheets
2. Explain that the three most common uses of spreadsheets are analysis, calculation and graphing
3. Given a column and row designation, locate a specific cell in a spreadsheet.
4. Identify the types of data that can be entered into a spreadsheet cell.
5. Enter data into cells of a spreadsheet
6. Explain that a graph is a graphic representation of data
7. Using data entered by the student, use that data to generate a bar graph.
8. List four types of graphs that a spreadsheet can produce.
9. Demonstrate the ability to copy a graph into a word processed document.
10. Explain that Formulas are used in a spreadsheet to perform calculations.

NT.K-12.1

Basic Concepts and Understanding

Students demonstrate a sound understanding of the nature and operation of technology systems. Students are proficient in the use of technology.

NT.K-12.3

Technology Productivity Tools

Students use technology tools to enhance learning, increase productivity, and promote creativity. Students use productivity tools to collaborate in constructing technology-enhanced models, prepare publications, and produce other creative works.

NT.K-12.6

Technology Problem-Solving and Decision-Making Tools

Students use technology resources for solving problems and making informed decisions. Students employ technology in the development of strategies for solving problems in the real world.

Learning Standards addressed in this unit:

English Language Arts Learning Standards

• Standard 1: Language for Information and Understanding
  • Listening and Reading
    • Key Idea 1
      
  • Speaking and Writing
    
    • Key Idea 2
      
      • Key Idea 2 - Alternate
• Standard 2: Language for Literary Response and Expression
  
• Listening and Reading
  
  • Key Idea 2 -
    
  • Key Idea 2 - Alternate

Mathematics, Science, and Technology Learning Standards

• Standard 2: Information Systems
  Students will access, generate, process and transfer informabon using appropriate technologies.

• Information Systems
  
  • Key Idea 1 - Information technology is used to retrieve, process, and communicate information and as a tool to enhance learning.
    
  • Key Idea 2 - Knowledge of the impacts and limitations of information systems is essential to its effective and ethical use.
    
  • Key Idea 3 - Information technology can have positive and negative impacts on society, depending upon how it is used.

• Standard 3: Mathematics
  • Modeling/Multiple Representation
    
    • Key Idea 4
  • Patterns/Functions
    
    • Key Idea 1 - Alternate - Students use mathematical patterns in a real-world situation.
      
    • Key Idea 7 -
• Standard 5: Technology
  
  • Tools, Resources, and Technological Processes
    
    • Key Idea 1 - Alternate
    • Key Idea 2
  • Computer Technology
    
    • Key Idea 1 - Alternate
    • Key Idea 3
      
  • Technological Systems
    
    • Key Idea 1 - Alternate
    • Key Idea 4

  
  Career Development and Occupational Studies Learning Standards

• Standard 3a: Universal Foundation Skills
  
  • Basic Skills
    
    • Key Idea 1
      
    • Key Idea 1 - Alternate
      
  • Technology
    
    • Key Idea 5
      
    • Key Idea 6
      
    • Key Idea 6 - Alternate

The following instructional strategies will be used to deliver specific curricular topics.

1.Lecture and Presentation

2.Overhead Projector with transparencies

3.Movies and DVD's

4. Computer software that retieves, stores,organizes, processes, edits  and presents information: examples of software used Microsoft Excel

5. Use of the World Wide Web to provide resources for the identification and collection of instructional resources.

6.Dittos and Worksheets

7.Teacher created websites and webpages

8.Hands-On, Project based instructional activities.

Techniques used to evaluate student progress: Homework, Oral Questioning, Classwork (written), Worksheets, Quiz's, Test, Project based instructional activities