Lesson Plans for April 24-28, 2017

Monday-Wednesday

Topics:  Review of Microsoft Excel topics

Activities:  We will discuss/review topics from Microsoft Excel and go through practice exercises in the MOS Study Guide in preparation of this week’s MOS certification test.

Thursday-

MOS certification tests

Friday-

MOS certification tests for those absent on Thursday

Lesson Plans for April 10-14, 2017

Monday-

Topics:  Excel chart test results

Activities:  Students to receive back graded Excel Chart tests; discuss; students to then correct questions (and computer actions) missed as needed on notebook paper.

Tuesday-Thursday

Topics:  Discovering financial costs project

Activities:  Discuss the “Discovering financial costs project”.  Students to do research to discover costs required in order to live on their own. Students will also calculate pay from a part-time and full-time job making minimum wage.  students will then put research findings into Excel to create a spreadsheet as well as an Excel chart.  Project will count as two daily grades.

Friday-

HOLIDAY!!

Lesson Plans for April 3-7, 2017

Monday-

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.

Tuesday-

Topics:  Reinforcement of Excel Charts

Activity:  What Color are your Skittles?

Wednesday-

Topics: Review of Excel Charts

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

Thursday-

Topics:  Review of Excel Charts

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

Friday-

Activities:  Test over Excel Charts 

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, 2017

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.