A Great Place to Visit...
SACRAMENTO Valley!!
...A Great Place to Live
Mrs. Clement
Computer Literacy
Center Junior High
Introduction
Standards 
Objectives
Activities
Assessment 
Results
Resources

 
 

Art found on 
Sacramento Metropolitan 
Chamber of Commerce website:
www.metrochamber.org

Sacramento native, Paula Wenzl,
created the above artwork which is 
featured on the Sacramento Metro 
Chamber Web site.  She has a 
remarkable portfolio of pictures 
that impressionistically conveys
the structures, signs and cultural
artifacts of our times. Perhaps her
best-known images nostalgically 
depict local landmarks of the 
Sacramento area.  She has won 
several awards and has been 
published in books and magazines. 
Galleries throughout the country 
now sell her works, and her images
have been purchased by major
corporate collections.

For sales, contact Paula Wenzl,
pawenzl@aol.com
 

 
Introduction: 
Subject:            Computer Literacy
Topic:                PowerPoint Presentation, Spreadsheets, Word Processing
Grade Level:    8
Student Lesson name and URL:
Standards Addressed: 
  •  Students will know how to use computer applications to access resources, manipulate data and produce useful information. 
  • 4.0 Computer Science and Information Technology

    •  
    • 4.1 Computer Science and Information Technology (CL):  Students will understand computer science and information technology concepts necessary to function in a rapidly changing technological, global society.  They will demonstrate competency by performing multiple tasks required to develop and use appropriate resources to access, modify, and provide information effectively.
    • 4.1.2 Computer and Communications Systemsóuse operating systems, hardware and peripherals, integrating communication tools and appropriate resources, to share information.
    • 4.1.3 Computer Applicationsóidentify, select, and use a variety of business and industry standard applications software; discuss current and emerging standards technology and trends.

     
  • 4.2 Administrative Support (S):  Students will understand support services necessary for the operation of a business organization n in a global society.  They will demonstrate competency by utilizing mutiple skills and performin g tasks in support of the business organizationís goals.

    •  

     
     
     


Return to top
Instructional Objectives:
  • Internet skills--finding resources
    • Students will be able to followlinks provided on a web page
    • Students will be able to copyimages from websitesandsave them 
    • Students will be able to copy text from websitesandsave itina Microsoft Works word processing document
    • Students will be able to savewebsite URLs--bookmarks, favorites--and then access them later
    • Students will understand copyright issues and understand how to obtain permission to use copyrighted material through the use of email

     
  • Presentation skills--PowerPoint
    • Students will be able to apply designs, selectslide layoutsand create new slides
    • Students will be able to enter text and insert images into placeholders
    • Students will be able to format text
    • Students will be able to change image properties
    • Students will be able to set custom animation and timing effects for placeholders
    • Students will be able to set timing of slides
    • Students will be able to insert sounds and/or link with CD tracks
    • Students will be able to use all views of slides
    • Students will be able to play their slide show presentation
    • Students will be able to print their presentation--six slides per page in black and white
  • Spreadsheet skills
    • Students will know  the spreadsheet terms label, value, formula, cell, cell range, column, row.
    • Students will be able to navigate around a spreadsheet using tab, shift + tab, enter key, and  arrow keys.
    • Students will be able to enter and update raw data in cells.
    • Students will be able to calculate results by using formulas to add, subtract,multiply, divide and average.
    • Students will be able to create a bar or pie chart from their spreadsheet
    • Students will be able to make a spreadsheet look professional through the use of  fonts, borders and shading, column and row width adjustment, and center across selection in MS Works.

Return to top
Student Activities:
Insert brief summaries of your introductory, enabling, and culminating activities. Insert links to online resources in your text and insert links to activities on your student lesson web site.
 
Prior Class Activities:
    1.  Students have already had the opportunity to complete fourteen
         prior assignments over the previous seven weeks of  this 
         twelve-week course covering:
    • basic operation of Windows 
    • file management 
    • word processing 
    • spreadsheets


    2.  PowerPoint (one 47-minute period):

    • As a whole class, students will view three sample PowerPoint presentations.
    •  Working in pairs, students will open, name and save a blank PowerPoint presentation.
    • Each pair of students will create four slides (title, clipart and text, text and clipart, bulleted list) about themselves, set custom animation and slide timings, and then run the slide show.  See assignment directions (insert link).


    3.  Internet Practice(one 47-minute period--students working in
         pairs):

         Students will...

    • open Netscape Communicator and complete a basic tutorial on its use. (Insert link)
    • go to a bookmarked teacher-created website (insert link) and 
      • practice saving images to a student-created image folder on the C: drive
      • practice copying text to a word processing document which they will save in their folder on the C: drive. (insert link)
    • open their PowerPoint presentation (insert link)
      • add two blank pages
      • insert placeholders for images and text
      • insert images and text saved into the appropriate placeholders
      • add custom animation and slide timings
      • run the slide show presentation
    4.  Practice inserting spreadsheets and charts into a presentation
         (30-minutes--students working in pairs)

         Students will...

    • open a completed spreadsheet assignment (insert link--Garfield) and copy the data.
    • open their PowerPoint presentation and add a blank page.
    • paste the spreadsheet data onto the blank page.
    • open a completed Olympic Medals compound document assignment (insert link) and copy the chart. 
    • add another blank page to their PowerPoint presentation and paste in the chart.
    • add custom animation and timings to the new slides.
    • add two blank slides to the end of the presentation, turn the background all black, and set a timing of two seconds each.
    • loop the presentation and play the slide show.
    • walk around the room, viewing presentations completed by others and sharing their own.


    5.  (15 minutes) Research copyright statements from bookmarked
          websites. 

    • Read statements
    • Discuss issues of copyright
    • Review rules of use for home, classroom and publishing in a public setting, such as a website.
      • Use of free images, copyrighted images
      • Use of copyrighted text
      • Giving credit to authors and artists

Return to top
    Sacramento Valley--A Great Place!--A PowerPoint
              Presentation (seven 47-minute periods)
     
      1.  As a whole class, students will preview all aspects of the assignment.
           (insert link)
      2.  Individually, students will create a 10-20 slide presentation promoting
           the Sacramento Valley.

           Students will...

      • plan the structure of their presentation using a planning worksheet (insert link) and PowerPoint outline view. 
      • use Internet links provided for research, saving images and text as needed.
      • complete the 10-20 slides.
      • perfect the timing.


      3.  Challenge activity: students will create a single-sheet trifold brochure
          on the Sacramento Valley using research found on the Internet. (insert link)


Return to top
Culminating Activity
text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text
insert back to the top
anchored link
(text or image)
Assessment

Insert your grading rubric for the culminating activity or a link to your rubric or test document file.

insert back to the top
anchored link
(text or image)
Results
After implementing your lesson (sometime between January & March), insert a chart of your pre-test, post-test, and culminating assessment data.
insert back to the top
anchored link
(text or image)
Web Resources & Supplementary Materials

Introductory Activity
List and link the web resources for this activity here. Also link supplementary materials such as PDF files and /or document files.

Enabling Activity
List and link the web resources for your learning activity(ies) here. Also link supplementary materials such as PDF files and /or document files.

Culminating Activity
List and link the web resources for your culminating activity here. Also link supplementary materials such as PDF files and /or document files.

insert back to the top
anchored link
(text or image)

 
 
 
 
 
 
 
 
 
 
 
 
 
 

School Name:  Center Junior High School
School Location:  Antelope, California
Your Name and e-mail address:  Diane Clement, dmc@jps.net
Last Revised: 08/18/2000