**PLEASE NOTE: THIS IS A SEVEN WEEK CLASS. TYPICALLY, THIS CLASS IS TAUGHT DURING A FOURTEEN WEEK SEMESTER. THE CLASS WILL BE VERY INTENSE WITH ASSIGNMENTS DUE EVERY THREE TO FOUR DAYS AT THE MOST. ASSIGNMENTS DURING THE FIRST FIVE WEEKS WILL BE DUE EVERY TWO TO THREE DAYS SINCE THESE CHAPTERS SHOULD BE A REVIEW FOR MOST STUDENTS. COME PREPARED TO WORK TO MEET THE DEADLINES.**

**YOU MUST HAVE OFFICE 365 OR ACCESS TO THE** **MICROSOFT VERSION** **of** **EXCEL 2016 TO TAKE THIS CLASS. THE MAC VERSION OF EXCEL CAN BE USED BUT THERE ARE SIGNIFICANT DIFFERENCES AND THE TEXTBOOK IS WRITTEN BASED UPON USING THE PC VERSION.**

T**eaching Methods:**

1. All classes meet online. Students should plan to take careful notes of discussion items as not all material may be found in the texts or readings. Participation in the discussion is required. You should plan on participating in the discussion at least twice each week. Students may procure outside material relevant to topics being covered.

2. Students are required to read each assigned chapter from the text and to complete the associated Excel tutorial. Other assignments may include Review Assignments, Case Problems, and other projects which will be periodically assigned to reinforce material in the text.

3. Exams: Three exams will be given: The first exam will follow the completion of Chapter Four, the second exam will follow the completion of Chapter 8 and the Final Exam will follow the completion of Chapters Nine through Eleven. Exams will be posted to Moodle seven days before they are due. No discussion will be permitted between the class and me with regard to exam questions or concepts.

4. All material will be distributed on Moodle. You may be required to download information from Moodle to complete an assignment. All assignments are submitted to me no later than 11:55 PM of the date mentioned below for the topic in question. When submitting homework, please submit through Moodle using the naming convention mentioned in the Textbook.

__Module One--Beginning June 26, 2018__

*In Class*

**Introductions** and discuss class format.

Class Activity and discussion of Excel Tutorial 1—Getting Started with Excel

*Homework (due 6/28/2018 at 11:55 PM)*

Do Excel Module 1, pp. 1-57.

Complete Case Problem 2 on pp. 60-61 and submit using Moodle.

__Module Two--Beginning June 29, 2018__

*In class*

Review Homework

Class Activity and discussion of Excel Tutorial 2—Formatting Workbook Text and Data

*Homework (due 7/1/2018 at 11:55 PM)*

Do Excel Module 2, pp. 65-122.

Complete Case Problem 2 on pp. 126-127 and submit through Moodle.

__Module Three--Beginning July 2, 2018__

*In class*

Review Homework

Class Activity and discussion of Excel Tutorial 3--Performing Calculations with Formulas and Functions

*Homework (due 7/5/2018 at 11:55PM)*

Do Excel Module 3, pp, 131-180.

Complete Case Problem 1 on pp. 182-183 and submit through Moodle.

__Module Four--Beginning July 6, 2018__

*In class*

Review Homework

Class Activity and discussion of Excel Tutorial 4—Working with Charts and Graphics

Do Excel Module 4, pp. 187-250.

Review for **Exam** One.

*Homework (due 7/8/2018 at 11:55 PM)*

Complete Case Problem 2 on pp 253-254 and submit through Moodle.

__Exam One—Beginning July 9, 2018__

**Exam*** *One *due by 7/12/2018 at 11:55 PM.* No Discussion of exam permitted after 7/08/2018. Exam will be posted on 7/9/2018 at 1:00AM. Submit as (first initial, last name)FE

__Module Five: Beginning July 13, 2018__

*In Class*

Class Activity and discussion of Excel Tutorial 5--Working with Excel Lists

*Homework (due 07/16/2018 at 11:55 PM)*

Do Excel Module 5, pp. 257-318.

Complete Case Problem 2 and submit through Moodle.

__Module Six: Beginning July 17, 2018__

*In class*

Review Homework

Class Activity and discussion of Excel Tutorial 6--Working with Multiple Worksheet and Workbooks

*Homework (due 7/20/2018 at 11:55 PM)*

Do Excel Module 6, pp. EX 327-380.

Complete Case Problem 1 on pp. EX 382-383 and submit through Moodle.

__Module Seven: Beginning July 21, 2018__

*In class*

Review Homework

Class Activity and discussion of Excel Tutorial 7--Developing an Excel Application

*Homework (due 7/24/2018 at 11:55PM)*

Do Excel Module 7, pp. EX 387-452.

Complete Case Problem 1 on pp. EX 455-457 and submit through Moodle.

__Module Eight: Beginning July 25, 2018__

*In class*

Review Homework

Class Activity and discussion of Excel Tutorial 8--Working with Advanced Functions

Review for Exam Two.

*Homework (due 07/28/2018 at 11:55 PM)*

Do Excel Module 8, pp. EX 463-522.

Complete Case Problem 2 on pp. EX 525-526 and submit through Moodle.

__Exam Two: Beginning July 29, 2018__

Exam* Two due by 08/01/2018 at 11:55 PM. *No Discussion of exam permitted after 07/28/2018. Exam will be posted on 07/29/2018 at 1:00AM. Submit through Moodle as (exam file name)1 or 2

__Module Eleven: Beginning August 2, 2018__

*In class*

Review Homework

Class Activity and discussion of Excel Tutorial 11--Connecting to External Data

Do Excel Module 11, pp. EX 659-719, then Case #2 on pp. EX 723-724 and submit to me no later than 8/4/2018 at 11:55 PM

__Module Nine: Beginning August 5, 2018__

*In class*

Class Activity and discussion of Excel Tutorial 9—Exploring Financial Tools and Functions

Do Excel Module 9, pp. EX 529-586.

Complete Case Problem 1 on pp. EX 589-590 and submit through Moodle by 08/07/2018 at 11:55 PM

__Module Ten: Beginning August 8, 2018__

*In class*

Review Homework

Class Activity and discussion of Excel Tutorial 10--Performing What-If Analyses

Final Project Assignment discussion on Discussion Board

*Homework (due 08/10/2018 at 11:55 PM)*

Do Excel Module 10, pp. EX 595-651.

Complete Case Problem 1 on pp. EX 653-655 and submit to me through Moodle.

Review and Discussion of upcoming Final Exam.

__Final Exam: Begins August 11, 2018.__

Final Exam is available on 08/11/2018 at 1:00 AM and is due by 11:55 PM on 08/13/2018. Students will complete all three problems. Submit to me as (exam file name) 1, 2 or 3.