Week 4

Monday

Bell Ringer

Chapter 9 Quiz

Objectives

      1. Assess chapter 9 objectives

Agenda

      1. Review ch 9 exercises
      2. Review ch 9 terminology
      3. Ch 9 exam
      4. Finish image editing projects
      5. Start chapter 10

    Assignments:

 

Tuesday

Bell Ringer

Check your grades on the Powerschool server, if your exercise grades are not 100% you should correct the ones you missed.

Read the chapter 9 summary and vocabulary to prepare for the exam

Objectives

      1. Determine how to present data in a spreadsheet
      2. Locate data and replace it
      3. Copy and move data
      4. Use the Max and Min function
      5. Insert functions into a formula
      6. Understand absolute cell references.
      7. Insert and delete rows and columns
      8. Change the print orientation and margins of a worksheet
      9. Add and remove page breaks
      10. Use the IF function

Agenda

        1. Chapter 9 Quiz
        2. Finish chapter 9 Exercises
        3. Finish image editing project and print them to the color laser in a 4 x 6 size. Insert into word and resize them. Use the ruler as a guide
        4. Review for chapter 9 exam on Tuesday

    Assignments:

    1. Microsoft Office Chapter 9

Wednesday

Bell Ringer

Chapter 10 practices

Objectives

      • Use and Print Multiple Sheets
      • Copy and move data between sheets
      • Refer to data in different sheets
      • Create pie, bar, and line charts of spreadsheet data
      • Modify, format, and print charts

Agenda

      1. Graph PowerPoint
        1. Requirements
          1. 5 slides
            • Title slide
            • Bar chart
            • Pie Chart
            • Line chart
            • Stacked bar chart
          2. All graphs have titles and axis labels
          3. One picture fill in a chart
          4. One gradient fill in a chart
          5. A sentence or two on each slide to explain the graph

      Assignments:

      1. Microsoft Office Chapter 10

Thursday

Bell Ringer

Open the Literary City Book Sales workbook from the chapter 10 folder

Objectives

  • Cell references on multiple worksheets
  • Renaming and adding worksheets
  • Using appropriate graphs to fit your data
  • Finding the equation of a least squares regression line
  • Graphing data from the internet

Agenda

  1. Worksheet 10.1 Using multiple sheets
  2. Graph PowerPoint
    1. Requirements
      1. 5 slides
        • Title slide
        • Bar chart
        • Pie Chart
        • Line chart
        • Stacked bar chart
      2. All graphs have titles and axis labels
      3. One picture fill in a chart
      4. One gradient fill in a chart
      5. A sentence or two on each slide to explain the graph

    Assignments:

  3. Microsoft Office Chapter 10

Friday

Bell Ringer

Quiz 10.1

Objectives

  • Using multiple worksheets
  • Renaming and adding worksheets
  • Using appropriate graphs to fit your data
  • Graphing data from the internet
  • Creating a PowerPoint slideshow

Agenda

  1. Bell Ringer graphs
  2. Graph PowerPoint
    1. Requirements
      1. 5 slides
        • Title slide
        • Bar chart
        • Pie Chart
        • Line chart
        • Stacked bar chart
      2. All graphs have titles and axis labels
      3. One picture fill in a chart
      4. One gradient fill in a chart
      5. A sentence or two on each slide to explain the graph

PowerPoint requirements

  1. Use a design template
    1. Use the title placeholder so your webpage output looks good.
  2. Include animation at least one instance
  3. Include a sound file - play automatically or on your click

 

 

Assignments:

Microsoft Office Chapter 10

 

 

 

Back to Computer 2 main page

Back to SHS main page