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.

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.

 

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.

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.

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.

 

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.

Monday-

Topics:  Overview of next section (Excel Basics); students will become familiar with vocabulary used in next chapter

Activities:  Students to define selected vocabulary for this section from pp. 343-344, 352-353, 362, 371-372, 380-381, 390.  May write on notebook paper or type vocabulary in MS Word.  If type, must save as Excel Basics Vocab into Excel folder on flash drive. Print and/or turn in when complete.

Tuesday-

Topics: Starting Excel; naming and saving a workbook; exploring the Excel window; exploring the Excel Interface; navigating the worksheet; changing worksheet views; closing a workbook and exiting Excel

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

Wednesday-

Topics:  Worksheet and workbook basics

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

Thursday-

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.

Friday-

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.

 

Monday-

Assign flash drives to each student. Students will then download files for MOS study guide off of website onto flash drive

Tuesday-Friday

Students who did not pass the MOS exam over Microsoft Word 2013 before the break will be working with Mrs. Ross to reinforce Word Topics before retest.

Monday-

Quiz 3: Backstage View

Tuesday-Wednesday

Project: Unit Simulation

Thursday-

Get students set up to take MOS Word certification

Friday-

MOS Word certification testing