Monday-

Holiday!

Tuesday-

Topics:  Discuss working with PivotTables and PivotCharts

Activities:  Students will take notes and practice new skills as we go through the Lesson 36 Try-Its on pp. 621-626 together. They will need to save their work into practice folder on their flash drive.

Wednesday-

Topics:  PivotTables and PivotCharts

Activities:  Students will reinforce yesterday’s learning by completing the Lesson 36 practice and Apply on pp. 626-629 on the computer.  Students will need to save work to Excel folder on flash drive and print when complete.

Thursday- Friday

Topics:  Test review over using advanced functions in Excel

Activities:  Students to complete Test review questions using notes, book, and computer.

 

Monday

Topics:  Using advanced functions for Data Analysis

Activities:  Students will reinforce yesterday’s learning b y completing the Lesson 34 Practice and Apply on pp. 611-613 on the computer.  Students will need to save to Excel folder on flash drive and print when complete.

Tuesday-Wednesday

Topics:  Using Lookup functions in Excel

Activities:  Students will take notes and practice new skills as we go through the Lesson 35 Try-Its on p. 615 together.  (Save work into Practice folder).  They will then complete Job 91 to reinforce the Vertical Lookup function. Students will need to save work into Excel folder on flash drive then print where indicated.

Thursday-Friday

Topics:  Review HLookup function in Excel

Activities:  Students to complete Job 92 over HLookup function on the computer.  Students will need to save work into Excel folder on flash drive then print where indicated.

 

 

 

 

Monday-

Topics:  Exam results; objectives for next chapter (advanced functions)

Activities:  Students to define the vocabulary for the next section in Excel over Advanced functions from pp. 596, 603-4, 614, 620 (21 words).  If students type words on computer, they will need to save work as Advanced Excel functions into the Excel folder of their flash drive and print.

Tuesday-

Topics:  Using advanced functions to predict trends

Activities:  Students will practice new skills on the computer as we go through the Lesson 33 Try-Its on pp. 597-600 together.  Students will need to save their work into their Practice folder on their flash drive.

Wednesday-

Topics:  Using advanced functions to predict trends

Activities:  Students will reinforce yesterday’s learning by completing the Lesson 33 Practice and Apply on pp. 600-602 on the computer.  Students will need to save to Excel folder on flash drive and print when complete.

Thursday-

Topics:  Using Advanced Functions for Data Analysis

Activities:  Students will practice new skills on the computer as we go through the Lesson 34 Try-Its on pp. 604-610 together.  Students will need to save their work into their Practice folder on their flash drive.

Friday-

Topics:  Using Advanced functions for Data Analysis

Activities:  Students will reinforce yesterday’s learning by completing the Lesson 34 Practice and Apply on pp. 611-613 on the computer.  Students will need to save to Excel folder on flash drive and print when complete.

 

Monday-

Topics:  Test results; objectives for next section

Activities:  Students to define the vocabulary for the next section (Excel Charts) on pp. 506-507, 520, 526, & 530 (20 words total).

Tuesday–

Topics:  Review creating charts in Excel.

Activities:   Students to take notes over creating charts in Excel, practice skills, then complete Job 58 over column charts on the computer.  Students will save into Excel folder on flash drive and print work when complete.

Wednesday–

Topics:  Creating pie charts in Excel

Activities:  Students to take notes over creating a pie chart in Excel, practice skills, then complete Jobs 13 & 60 on the computer.  Students will save into Excel folder on flash drive and print work when complete.

Thursday-

Topics:  Reinforce skills dealing with creating charts in Excel

Activities:  Students will complete Jobs 61 & 62 over creating different types of chart in Excel.  Students will save into Excel folder on flash drive and print work when complete.

Friday-

Activities:  Students will be given time to finish any unfinished computer work from this week.

 

Monday-Tuesday

Topics:  Reinforcement of PMT function in Excel and other personal business topics

Activities:  Students are to find two vehicles that they would like to purchase.  Must find cost of vehicle on Internet and note website where found.  Students are to then figure out monthly payments on their vehicles given different criteria.  Save and print when complete.

Wednesday-

Topics:  Review of formulas and functions

Activities:  Students will complete semester exam review over formulas and functions in Excel.  If don’t finish in class, for homework.

Thursday-

Topics: Review of formulas and functions

Activities:  Students to participate in Test review game over formulas and functions.  Winning team will receive 5 bonus points on their test grade.

Friday-

Activities:  Test over formulas and functions

Monday-

Topics:  Reinforcement of Excel formulas

Activities:  Students to complete Job 14 over formulas on the computer.  Save into Excel folder on flash drive and print when complete.

Tuesday–

Topics:  Review of Excel functions;  SUM function

Activities:  Students to take notes, then complete Job 29 over the SUM function on the computer.  Save and print when complete.

Wednesday–

Topics:  Review of other common functions (SUM, AVERAGE, MAX, MIN, COUNT)

Activities:  Students to take notes, practice functions with teacher, then complete function review on computer (Class Grades).  Must use functions, not regular formulas.  Save and print when complete.

Thursday-

Topics:  IF function

Activities:  Students to take notes, practice functions with teacher, then complete the “No jacket needed” exercise over the IF function on the computer.  Save and print when complete.

Friday-

Topics:  PMT function

Activities:  Students to take notes, practice functions with teacher, then complete exercise over PMT function on computer (COMP).  Save and print when complete.

 

Monday-

Topics:  Desktop publishing

Activities:  Students to finish test started Friday (was too long to finish in one class period)

Tuesday-

Topics:  Students to become familiar with vocabulary for next chapter in Excel.

Activities:  Students to define the vocabulary on pp. 397, 403 (absolute and relative reference words only), & p. 428.  Due by the end of class.

Wednesday-

Topics:  Test results

Activities:  Students will receive back their graded Desktop Publishing tests.  Go over any questions/problems together.  Students will make corrections to missed test questions.  Due by the end of class.

Thursday-

Topics:  Review of Excel formulas

Activities:  Students to complete Job 11 (Earn) over formulas on the computer.  Save into Excel folder on flash drive  and print when complete.

Friday-

Topics:  Reinforcement of Excel formulas

Activities:  Students to complete Job 14 over formulas on the computer.  Save into Excel folder on flash drive and print when complete.

 

Monday-Tuesday

Bring something to work on or read.  We will not start new section until Wednesday when band members return from state competition.

Wednesday–

Topics:  Review of Desktop Publishing topics

Activities:  Students to complete the written test review over Desktop Publishing using notes and/or book.  If don’t finish in class, due by the first of class tomorrow.

Thursday-

Topics:  Review of Desktop Publishing topics

Activities:  Students to compete in test review game over Desktop Publishing.  Winning team will receive bonus points towards their test grade.

Friday-

Activities:  Test over Desktop Publishing

Monday-Friday

Topics: Reinforce Desktop publishing topics

Activities:  Students to create a newsletter in Word with set criteria.  Due by end of class Friday.

 

Monday-

Topics:  Enhancing paragraphs with dropped capitals, borders, and shading

Activities:  Students to take notes practice new tasks on computer by going through the Try-Its on pp. 311-312 together. Save work into Practice folder on flash drive.

Tuesday-Wednesday

Topics:  Enhancing paragraphs with dropped capitals, borders, and shading

Activities:  Students to complete the Lesson 24 Practice and Apply on pp. 313-315 in book.  Save into Word folder on flash drive and print where indicated.  Due by the end of class Wednesday.

Thursday–

Topics:  Using format painter, highlights, symbols, and Quick parts

Activities:  Students to take notes practice new tasks on computer by going through the Try-Its on pp. 317-320 together. Save work into Practice folder on flash drive.

Friday–

Topics:  Using format painter, highlights, symbols, and Quick parts

Activities:  Students to complete the Lesson 25 Practice and Apply on pp. 321-323 in book.  Save into Word folder on flash drive and print where indicated.  Due by the end of class.