Apr 29

Computer Applications – 4/30/08

Objective:

  • Create pie, bar, and line charts.
  • Format and edit charts.
  • Print a chart

I.  Bellwork

A.  Pg 328 #14 Question and Answer (see pg 311)

II.  Classwork

A.  Pages 333-334  Exercise 5

B.  Page 339 Exercise 11

C.  Chart/Graph Review Sheet

III.  Notebook Work (See yesterday’s agenda)

IV.  Test on Thursday/Friday & Notebook Check

Apr 29

Computer Applications – 4/29/08

Objective:

  • Create pie, bar, and line charts.
  • Format and edit charts.
  • Print a chart

I.  Bellwork

A.  Pg 328 12 a-d Question and Answer (see pg 310)

II.  Classwork

A.  Pages 332-333   Exercise 4 – Print

B.  Pages 333-334  Exercise 5

III.  Notebook Work

A.  Copy and Label the buttons on the formatting and standard toolbars in Excel

IV.  Test on Thursday/Friday

Apr 23

Computer Applications – 4/24/08

Objectives: 

  •  Review Excel options for creating, editing, and printing charts.

I.  Bellwork Pg 328

A.  #6 A- E  write questions and answers (see pg 306-307)

II.  Classwork

A.  Page 328 #15 A-E  True and False.  If False explain why.

B.  Print – Temperature Part 2 (See pgs 320-324)

C.  Micro Type Pro Section I-L Due Friday

Apr 22

Computer Applications – 4/23/08

Objectives:

  • Create pie, bar, and line charts.
  • Move, size, and delete charts.
  • Print a chart.

I.  Bellwork Pg 328

A. Write Question and Answers #5

II.      Excel Creating Charts and Graphs

A. Continents Part 1  Pages 303-306 

B.  Continents Part 2 Pages  307-308

C. Temperature Part 1 pgs 311-318

D. Temperature Part 2 pgs 320-324 -Save

III.  Notebook Work

A.  Charts and graphs are useful in the way they can visually present data.  Write a paragraph (3-4 sentences) about how you might be able to use charts/graphs in your classes and life.  Be specific about what types of charts/graphs and data you will be using and its purpose.

Apr 21

Computer Applications – 4/22/08

Objective:

  • Explain how charts enhance and simplify the understanding of numerical data in a worksheet 
  • Identify different chart objects

I.  Bellwork 

A.  Click on the Chart Wizard

1.  List 10 different standard chart types that are available using chart wizard  (click on the chart wizard button)

II.  Creating Charts in Excel

A. Page 328 Review Questions  1-4  (Questions & Answers)

B. Micro Type Pro I-L due on Friday

Apr 18

Computer Applications – 4/18/08

Objective

  • enter and edit data in worksheet
  • create and use formulas to perform calculations 
    • I.  Bellwork – Q & A

    A.  List 5 different functions you can create using the AutoSum button.

  • B.  Can you change or add a function to the AutoSum button? Explain how.

    II.  Classwork

    A.  Exercise 1 Page 287 – Finish & Print

    B.  Exercise 2 Page 288

    C.  Micro Type Pro Red Sections – Lesson I

    Apr 16

    Computer Applications – 4/17/08

     Objectives:

  • Use the SUM, AVERAGE, MAX, MIN, and ROUND functions.
  • Sort the data in a spreadsheet.
  • Insert and delete rows and columns
  • I.  Bellwork pg 278
         A.  What commands create a new worksheet?

         B.  What is a linked cell?

    II.  Notebook Work – Bar Graph 

         A.  Write Questions and Answers

    III.  Classwork

         A.  Car Sales Pgs 279-281-Print

         B.  Exercise 1 pg 287