Lesson Plans for March 27-31, 2017

Monday-

Topics:  Creating and formatting a pie chart in Excel

Activities:  Students to take notes, participate in discussions, then complete Jobs 13 & 60 on the computer.  Save and print where indicated.

Tuesday-

STAAR English I EOC Testing- If not taking test, please bring something to work on.

Wednesday-

Topics:  Reinforcement of Excel charts

Activities: Students are to complete Job 61 (line chart) and Job 62 (3-D horizontal bar chart) using their notes and computer.  Save and print when complete.

Thursday-

STAAR English II EOC Testing– If not taking test, please bring something to work on or read.

Friday-

Topics: Reinforcement of Excel Charts

Activity:  What Color are your Skittles?

Lesson Plans for March 20-24, 2017

Monday-

Topics:  Function test results; objectives for next chapter

Activities:  Students to make corrections as needed to their function test.

Tuesday-

Topics:  Become familiar with new vocabulary (using charts in Excel)

Activities:  Students to define vocabulary for next chapter

Wednesday-

Topics:  Creating and formatting a column chart in Excel

Activities:  Students to take notes, participate in discussions, then complete Job 58 on the computer.  Save and print where indicated.

Thursday-

No class- Early release for District Academic UIL competition 

Friday

Topics:  Creating a formatting a pie chart in Excel

Activities:  Students to take notes, participate in discussions, then complete Jobs 13 & 60 on the computer.  Save and print where indicated.

 

Lesson Plans for March 6-10, 2016

Monday-

Topics:  IF function

Activities:  Students will take notes, practice new function on computer, then complete the reinforcement exercise on the computer (Bring my jacket).  Students are to save and print work when completed.

Tuesday-

Topics:  PMT function

Activities:  Students will take notes, practice new function on computer, then complete the reinforcement exercise on the computer (Job 36).  Students are to save and print work when completed.

Wednesday-

Topics:  Review of functions

Activities:  Students to complete test review questions using their notes.  If don’t finish in class, for homework.  Due at the first of class Thursday.

Thursday-

Topics:  Review of functions

Activities:  Test review questions due.  Students to then participate in test review game.  Winning team will receive 5 bonus points towards their next test grade.

Friday-

Activities:  Test over functions

Lesson plans for February 13-17, 2016

Monday-

Topics:  Review chapter topics over Excel formulas; copying and pasting; techniques for moving data in Excel; sheet, display, and print operations

Activities:  Students to complete Test Review questions using notes and book.  If don’t finish in class, for homework. Due at the first of class Tuesday.

Tuesday-

Topics:  Test review

Activities:  Students will participate in test review game. Winning team will receive 5 bonus points on next test.

Wednesday-

Excel Test: over Excel formulas; copying and pasting; techniques for moving data in Excel; sheet, display, and print operations

Thursday-

Topics:  Test results

Activities:  Students will receive back graded tests. Time to discuss any questions over test.  Students will then make corrections to test as needed.

Friday-

Topics:  Students to become familiar with new vocabulary.

Activities:  Students to define new vocabulary using book.  Due at the end of class.

Lesson Plans for February 6-10, 2017

Monday

Topics:  Copying and pasting

Activities:  Students to take notes and practice new skills as we go through the Lesson 8 Try Its together on the computer (pp. 404-407). Students to then complete Lesson 8 Practice and Apply on pp. 407-409 .  Save completed work to flash drive and print (if necessary) when complete.

Tuesday-

Topics: Techniques for moving data in Excel

Activities:   Students to take notes and practice new skills as we go through the Lesson 9 Try Its together on the computer (pp. 411-414). Students to then complete Lesson 9 Practice and Apply on pp. 415-416 .  Save completed work to flash drive and print (if necessary) when complete.

Wednesday-

Topics:  Sheet, display, and print operations

Activities:  Students to take notes and practice new skills as we go through the Lesson 10 Try Its together on the computer (pp. 418-421). Students to then complete Lesson 10 Practice and Apply on pp. 422. .  Save completed work to flash drive and print (if necessary) when complete.

Thursday-

Topics:  Reinforce chapter topics

Activities:  Students to complete the Excel Chapter 1- Critical Thinking Exercise and Portfolio Builder on pp. 423-425. Save completed work to flash drive and print (if necessary) when complete.

Friday-

Time to finish any unfinished computer work from week.

 

Lesson Plans for January 30-February 3, 2017

Monday-

Topics:  Become familiar with new vocabulary

Activities:  Students to define assigned vocabulary words using book. Due at the end of class.

Tuesday-

Topics:  Using formulas in Excel; editing a formula; copying a formula using the fill handle

Activities:  Students to take notes over Excel formulas, then complete Jobs 9 and 11 on the computer.  Save and print when complete.

Wednesday-

Topics:  Reinforcement of formulas in Excel

Activities:  Students to complete Jobs 10 and 14 over formulas on the computer. Save and print when complete.

Thursday-

Topics:  Copying and pasting

Activities:  Students to take notes and practice new skills as we go through the Lesson 8 Try Its together on the computer (pp. 404-407). Students to then complete Lesson 8 Practice and Apply on pp. 407-409 .  Save completed work to flash drive and print (if necessary) when complete.

Friday-

Topics: Techniques for moving data in Excel

Activities:   Students to take notes and practice new skills as we go through the Lesson 9 Try Its together on the computer (pp. 411-414). Students to then complete Lesson 9 Practice and Apply on pp. 415-416 .  Save completed work to flash drive and print (if necessary) when complete.

Lesson Plans for January 23-27, 2017

Monday-

Topics:  Review of Excel Basics

Activities:  Students to participate in test review game.  Winning team will receive 5 bonus points towards their test.

Tuesday-

Activities:  Test over Excel Basics.  **You will need a pencil for scantron portion of test**

Wednesday-

Early release– class will not meet

 

Thursday-

Topics: Test results

Activities:  Students will receive back their graded tests.  Students will be given the opportunity to ask questions and clarification about test.  Students will then make corrections as needed.

Friday-

Topics:  Students to become familiar with new vocabulary

Activities:  Students to define new vocabulary using their book.  May write or type on computer.

Lesson Plans for January 16-20, 2017

Monday-

Holiday!

Tuesday-

Topics:  Working with Ranges

Activities:  Students will take notes and practice new skills as we go through the Lesson 6 Try-Its together on the computer (pp. 391-393).  Students to then complete Lesson 6 Practice and Apply on pp. 393-396.  Save complete work to flash drive and print (if necessary) when complete.

Wednesday-Thursday

Topics:  Excel Basics Review

Activities:  Students will complete Test Review questions using their books.  If don’t finish in class, for homework.   Due by the first of class Friday, January 20, 2017.

Friday-

Topics:  Review Excel Basics

Activities:  We will discuss and go over Test review over Excel Basics.  Students will be given the opportunity to correct their test reviews as needed.

 

Lesson Plans for January 9-13, 2017

Monday-

Topics:  Adding worksheet contents

Activities:  Students will take notes and practice new skills as we go through the Lesson 3 Try-Its together on the computer (pp. 363-367).  Students to then complete Lesson 3 Practice and Apply on pp. 367-3370.  Save complete work to flash drive and print (if necessary) when complete.

Tuesday-

Topics:  Worksheet formatting

Activities:  Students will take notes and practice new skills as we go through the Lesson 4 Try-Its together on the computer (pp. 372-377).  Students to then complete Lesson 4 Practice and Apply on pp. 377-379.  Save complete work to flash drive and print (if necessary) when complete.

Wednesday-

Topics:  More on Cell Entries and Formatting

Activities:  Students will take notes and practice new skills as we go through the Lesson 5 Try-Its together on the computer (pp. 381-386).  Students to then complete Lesson 5 Practice and Apply on pp. 387-389.  Save complete work to flash drive and print (if necessary) when complete.

Thursday-

Topics:  Working with Ranges

Activities:  Students will take notes and practice new skills as we go through the Lesson 6 Try-Its together on the computer (pp. 391-393).  Students to then complete Lesson 6 Practice and Apply on pp. 393-396.  Save complete work to flash drive and print (if necessary) when complete.

Friday-

Topics:  Excel Basics Review

Activities:  Students will complete Test Review questions using their books.  If don’t finish in class, for homework.   Due by the first of class Tuesday, January 17, 2017.