Lesson Plans for November 16-20, 2015

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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *