CCV Section Grid - Detail
Vermont State Colleges

Web Schedules

Spring 2021
Fall 2020
Summer 2020

One Credit Courses

Spring 2021
Fall 2020
Summer 2020

Course Planning by Program


Essential Objectives

Web Schedule Fall 2020

Revision Date: 10-Oct-20

CIS-1430-VO04Y - Spreadsheets

Online Class

Online courses take place 100% online via Canvas, without required in-person or Zoom meetings.

Synonym: 203918
Location: Online
Credits: 3 (45 hours)
Day/Times: Meets online
Semester Dates: 11-03-2020 to 12-21-2020
Last day to drop without a grade: 11-12-2020 - Refund Policy
Last day to withdraw (W grade): 12-01-2020 - Refund Policy
Faculty: Carol Caldwell-Edmonds | View Faculty Credentials
This section is waitlisted. Please contact your nearest center for availability..
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. Demonstrate the ability to create resources, set appropriate permissions, use cloud applications, and apply file management principles to cloud-based files.
5. Use spreadsheet software to present and analyze quantitative information, to draw conclusions from information, and to evaluate the reliability of those conclusions.
6. Demonstrate appropriate use of cell references absolute, relative, and conditional formulas.
7. Apply financial, statistical, mathematical, logical, text, and date functions to build applications.
8. Demonstrate effective use and formatting of graphs to enhance numerical data in spreadsheets.
9. Apply database functionality including tables, filtering, sorting, and queries.
10. Demonstrate the ability to import, export, merge, and convert data to and from external sources using a variety of document types.
11. Demonstrate effective use of linkages to share cell data among multiple spreadsheets, external workbooks, and templates.
12. Create, apply, and edit macros to automate routine tasks.
13. Create pivot tables and graphs to display information, forecast results, and compare alternatives.
14. Demonstrate the ability to print and display sections and whole spreadsheets in a form that make them easy to read and use.
15. Identify the steps needed to display a value from one sheet to another or to a separate workbook.

Additional Instructor Pre-Assignments/Notes/Comments:

There is no text book to purchase for this course; we will use resources available to you for free as CCV students, including texts online with Hartness Library and Microsoft Excel online tutorials. For details see this course in Canvas, and the syllabus below.

Evaluation Criteria:

25% labs and participation

25% assignments and in class or online discussion participation

25% quizzes and exams

25% projects

Grading Criteria:

A+ through A-: 100-90 For any work to receive an "A," it must clearly be exceptional or outstanding work. It must demonstrate keen insight and original thinking. It must not only demonstrate full understanding of the topic or issues addressed, but it must also provide a critical analysis of these. In addition, an "A" grade reflects a student's ability to clearly and thoughtfully articulate his or her learning.

B+ through B-: 89-80 For any work to receive a "B," it must be good to excellent work. It must demonstrate strong originality, comprehension, critical thinking, and attention to detail. In addition, a "B" grade reflects a student's ability to clearly articulate his or her learning.

C+ through C-: 79-70 For any work to receive a "C," it must meet the expectations of the assignment. It must demonstrate solid comprehension, critical thinking, and attention to detail. In addition, a "C" grade reflects a student's ability to adequately articulate his or her learning.

D+ through D-: 69-60 For any work to receive a "D," it must marginally meet the expectations of the assignment. It demonstrates minimal comprehension, critical thinking, and attention to detail. In addition, a "D" grade may reflect a student's difficulty in articulating his or her learning.

F: below 60 Work that receives an "F" grade does not meet the expectations or objectives of the assignment. It demonstrates consistent problems with comprehension, organization, critical thinking, and supporting details. In addition, an "F" grade reflects a student's inability to articulate his or her learning. Students are strongly urged to discuss this grade with their instructor and advisor.

P: Equivalent to D (+/-) or better and therefore course will not count as credit for specific program requirements or competence area requirements.

NP: indicates failure to meet course objectives and/or failure to meet grading criteria for successful completion as described in the instructor's course description.


Fall 2020 textbook data will be available on July 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-VO04Y 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: Carol Caldwell-Edmonds
Hiring Coordinator for this course: Theodore Pappadopoulos

Attendance Policy:

Attendance Policy:Regular attendance and participation in classes are essential components of a student's success in college and are completion requirements for courses at CCV. Please be aware that missing more than three (3) classes will result in a non-satisfactory grade. A pattern of late arrival or early departure will constitute absence at the instructor's discretion.


Course Syllabus

Unless otherwise noted, all chapters in the syllabus below refer toMicrosoft Excel 2019 Step by Step***, First Edition by Curtis Frye; ISBN: 9781509306176


Introductory and reference information:

Module 0.1 Spreadsheets: General Information about Canvas help, Instructor, textbook

Module 0.2 Course Resources: How this class is conducted | your bookshelf | Software (no charge) and services available to CCV students

Module 0.3 ZOOM information for this course


Module 1: Course overview | Spreadsheets-basics, using Microsoft Excel | Conditional Formatting | Cell References

Module 2: Excel basic formulas, functions, tables, themes, and images | Using conditional functions in spreadsheet applications

Module 3: Excel: analyzing and evaluating data | Excel views and charts | Principles of good spreadsheet design: formulating questions | Review for the midterm exam


Module 5 Excel Projects: introduction | Excel views and controls | What-if Analysis | Date Functions | Macros

Module 6 Project Development | Excel Pivot Tables and Pivot Charts | PowerPivot

Module 7 Excel Projects due | Final Exam - multiple choice, online quiz format

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