Week 2

Monday

Bell Ringer

WORKSHEET- 8.2 #1

Get a booklet and review the terminology through practice 6 of chapter 8 -

Quiz 8.1

Objectives

      1. Using formulas in a spreadsheet
      2. Using the fill handle
      3. Relative cell references
      4. Twig Email

Agenda

      1. Bell Ringer
      2. Quiz
      3. Twig email
      4. Work on Chapter 8 Questions and Exercises
      5. Set up a Yahoo account
      6. Review the shortcut sheet

    Assignments:

    1. Chapter 8 Office 2000

 

Tuesday

Bell Ringer

Finish Quiz 8.1

Work on chapter 8.1 questions

Objectives

      1. Use writing skills and Word features to improve spelling, grammer, and punctuation
      2. Understand basics of a stock portfolio
      3. Stock links
      4. Create a spreadsheet to track a portfolio of stocks

Agenda

      1. Finish Quiz 8.1
      2. Set up Yahoo startup page
      3. Finish chapter 8 Questions
      4. Stock Market Spreadsheets
      5. Stock Tutorial

    Assignments:

    1. Chapter 8 Office 2000

 

Wednesday

Bell Ringer

Create the stock portfolio worksheet as described in the Stock Market Worksheet

Objectives

      1. Understand basics of a stock portfolio
      2. Create a spreadsheet to track a portfolio of stocks
      3. Use sum, average, and round functions in a spreadsheet

Agenda

      1. Create Stock Project worksheet
      2. Reseach stocks on the internet
      3. Finish and print out the chapter 8 questions
      4. Work on the chapter 8 exercises

Assignments:

    1. Pick 10 Stocks for Stock Project
    2. Chapter 8 Office 2000

 

Thursday

Bell Ringer

Complete your stock portfolio and add the stocks to your yahoo page. Make sure your total is $15,000 or less.

Objectives

      1. Understand basics of a stock portfolio
      2. Create a spreadsheet to track a portfolio of stocks
      3. Use sum, average, and round functions in a spreadsheet
      4. Format cells in a spreadsheet
      5. Learn to use Windows XP shortcuts

Agenda

      1. Finish Stock Project worksheet
      2. Add stocks to the Yahoo page
      3. Email me a copy of your portfolio as an attachment (russ.wissing@connectseward.org)
      4. XP shortcuts
      5. Finish and print out the chapter 8 questions
      6. Finish the chapter 8 exercises
      7. optional - Image editing tutorial - files are in the K drive (fireworksmx_masking) folder

Assignments:

    1. Review for chapter 8 exam
    2. Chapter 8 Office 2000

Friday

Bell Ringer

Review chapter 8

Objectives

      1. Assess chapter 8 objectives

Agenda

      1. Review for chapter 8 exam
      2. Chapter 8 exam
      3. Finish Chapter 8 exercises
      4. optional - Image editing tutorial - files are in the K drive (fireworksmx_masking) folder

Assignments:

    1. Chapter 8 Office 2000

 

 

Back to Computer 2 main page

Back to SHS main page