CCV Section Grid - Detail
 
Vermont State Colleges
 
Untitled

Web Schedules

Fall 2018
Spring 2018
Summer 2018

Accelerated Courses

Fall 2018
Spring 2018
Summer 2018

Course Planning by Program

2018-19

Web Schedule Summer 2018


Revision Date: 14-Apr-18

CIS-1430-VO01Y - Spreadsheets


Synonym: 178523
Location: Online
Credits: 3 (45 hours)
Accelerated Section: This course has special meeting dates and times. See comments below or consult VSC Web Services - Search for Sections in the VSC portal for specific dates and times. If you have any questions call the site office offering the course.
Semester Dates: 06-26-2018 to 08-13-2018
Last day to drop without a grade: 07-05-2018 - Refund Policy
Last day to withdraw (W grade): 07-24-2018 - Refund Policy
Faculty: Glenn Marvel | View Faculty Credentials
This course has started, please contact the offering academic center about registration
This section meets the following General Education Requirement(s):
Technological Literacy
    Note
  1. Many degree programs have specific general education recommendations. In order to avoid taking unnecessary classes, please consult with additional resources like your program evaluation, your academic program page, and your academic advisor.
  2. Courses may only be used to meet one General Education Requirement.

Course Description:

This course provides a comprehensive examination of spreadsheet software. Students will build a variety of spreadsheets using simple and complex formulas, functions, graphics, database features, sorts, linkages within spreadsheet and between spreadsheets, and macros. Basic algebra skills are recommended.

Essential Objectives:

1. Design, build, edit, and format complex and multi-sheet workbooks.
2. Demonstrate simple and conditional formatting of numerical and text data to create readability and appeal of the spreadsheet.
3. Demonstrate principles of good spreadsheet design including planning, documentation, and organization.
4. Use spreadsheet software to present and analyze quantitative information, to draw conclusions from information, and to evaluate the reliability of those conclusions.
5. Demonstrate appropriate use of cell references absolute, relative, and conditional formulas.
6. Apply financial, statistical, mathematical, logical, text, and date functions to build applications.
7. Demonstrate effective use and formatting of graphs to enhance numerical data in spreadsheets.
8. Apply database functionality including tables, filtering, sorting, and queries.
9. Demonstrate the ability to import, export, merge, and convert data to and from external sources using a variety of document types.
10. Demonstrate effective use of linkages among multiple spreadsheets, external workbooks, and templates.
11. Understand how to build, apply, and edit macros to automate routine tasks.
12. Create pivot tables and graphs to display information, forecast results, and compare alternatives.
13. Demonstrate the ability to print and display sections and whole spreadsheets in a form that make them easy to read and use.

Textbooks:

Summer 2018 textbook data will be available on April 9. On that date a link will be available below that will take you to eCampus, CCV's bookstore. The information provided there will be for this course only. Please see this page for more information regarding the purchase of textbooks.

The last day to use a Financial Aid advance to purchase textbooks is the 3rd Tuesday of the semester. See your financial aid counselor at your academic center if you have any questions.

Contact Faculty:

Email: Glenn Marvel
Hiring Coordinator for this course: Theodore Pappadopoulos

Syllabus:


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.

Teaching 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.

Please note: In order to receive accommodations for disabilities in this course, students must make an appointment to see the Americans with Disabilities Coordinator in their site and bring documentation with them.

Academic Honesty: CCV has a commitment to honesty and excellence in academic work and expects the same from all students. Academic dishonesty, or cheating, can occur whenever you present -as your own work- something that you did not do. You can also be guilty of cheating if you help someone else cheat. Being unaware of what constitutes academic dishonesty (such as knowing what plagiarism is) does not absolve a student of the responsibility to be honest in his/her academic work. Academic dishonesty is taken very seriously and may lead to dismissal from the College.

Course description details subject to change. Please refer to this document frequently.

To check on space availability, choose Search for Classes.


Return to Online Section Grid
Return to Spreadsheets Page




© Community College of Vermont
For support click on: Vermont State Colleges Help Desk and choose the Student and Visitor Login.
Complete the screen that follows as fully as you can.