CCV Section Grid - Detail
Vermont State Colleges

Web Schedules

Fall 2020
Summer 2020
Spring 2020

Accelerated Courses

Fall 2020
Summer 2020
Spring 2020

Course Planning by Program


Essential Objectives

Web Schedule Summer 2020

Revision Date: 15-Apr-20

CIS-1430-VR01 - Spreadsheets

Synonym: 184928

Location: Rutland - Meets Online

Credits: 3 (45 hours)
Day/Times: Meets online
Semester Dates: 05-26-2020 to 08-17-2020
Last day to drop without a grade: 06-11-2020 - Refund Policy
Last day to withdraw (W grade): 07-14-2020 - Refund Policy
Faculty: Carl Zeller | 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
  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.

Browse the Canvas Site for this class.

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.

Additional Instructor Pre-Assignments/Notes/Comments:

Please note that this class will be administered 100% online. This means that in order to succeed in the class, the student must meet the MINIMUM personal technology requirements:

1. A personal computer or laptop running Microsoft Windows 10. Chromebooks are not an option. Use of a Mac computer is not recommended (see below).

2. You must have Office 365 (available to students as a free download) or Excel 2016 / 2019 to take this class. The Mac version of Excel can be used but there are significant differences and the supplied textbook is written based on using the PC version.

3. A reliable high-speed internet connection of at least 5Mbps. Dial-up / 3g data connections are not acceptable.


* Self-Administered Tutorials
* Online exams
* Word processing and Excel projects
* Homework practicals

Evaluation Criteria:

Attendance and Participation: 30%
Homework: 30%
Exams: 40%

Grading Criteria:

Letter grades will be awarded based on the calculated numeric grade earned in class:

A+ 100%
A 93 - 99.99%
A- 90 - 92.99%
B+ 87 - 89.99%
B 83 - 86.99%
B- 80 - 82.99%
C+ 77 - 79.99%
C 73 - 76.99%
C- 70 - 72.99%
D+ 67 - 69.99%
D 60 - 66.99%
F 0 - 59.99%


Summer 2020 textbook data will be available on April 6. 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.

CIS-1430-VR01 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: Carl Zeller
Hiring Coordinator for this course: Debra Grant

Mailing Address:
2623 E Pittsford Rd
Rutland, VT 05701

Notes: If you need to contact me outside of class, feel free to do so preferably via email or text. I look forward to an interesting and productive class. Mobile phone / SMS: (802) 236-5644 E-Mail:

Attendance Policy:

Attendance in this class will be gauged by the Student’s progress in keeping up with the Tutorials, measured by the completion of the Knowledge Assessments at the end of each chapter. Participation in online discussions and meetings will also be noted.


Class 1 - 5/27
Course Introduction
Class Introduction
History of Spreadsheets
Introduction to Canvas

Class 2 - 6/3
File management – Copying Book and Student Files to Flash Drive
Lesson 1 - Excel Overview and Lesson 2 – Working with Microsoft Excel HW: (P.34) Projects 2-1 and 2-2

Class 3 - 6/10
Lesson 3 – Using Office Backstage and Lesson 4 – Using Basic Formulas HW: (P. 48) Projects 3-1, 3-2 and (P.62) Projects 4-1, 4-2

Class 4 - 6/17
Lesson 5 – Using Functions HW: (P.69) Projects 5-1 and 5-2

Class 5 - 6/24
Lesson 6 – Formatting Cells and Ranges HW: (P.69) Projects 6-1 and 6-2

Class 6 - 7/1
Lesson 7 – Formatting Worksheets and Lesson 8 – Managing Worksheets HW: (P. 114) Projects 7-1, 7-2 and (P.130) Projects 8-1, 8-2

Class 7 - 7/8
Mid-Term Exam
Lesson 9 – Working with Data and Macros HW: (P.168) Projects 9-1 and 9-2

Class 8 - 7/15
Lesson 10 – Using Advanced Formulas HW: (P.194) Projects 10-1 and 10-2

Class 9 - 7/22
Lesson 11 – Securing Workbooks HW: (P.214) Projects 11-1 and 11-2

Class 10 - 7/29
Lesson 12 – Creating and Using Pivot Tables and Creating Charts HW: (P.245) Projects 12-1 and 12-2

Class 11 - 8/5
Lesson 13 - Google Sheets

Class 12 - 8/12
Final Exam

Accessibility Services for Students with Disabilities: CCV strives to mitigate barriers to course access for students with documented disabilities. To request accommodations, please

  1. Provide disability documentation to the Accessibility Coordinator at your academic center.
  2. Request an appointment to meet with accessibility coordinator to discuss your request and create an accommodation plan.
  3. Once created, students will share the accommodation plan with faculty. Please note, faculty cannot make disability accommodations outside of this process.

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