Untitled

Web Schedules

Fall 2024
Spring 2024
Summer 2024

One Credit Courses

Fall 2024
Spring 2024
Summer 2024

No Cost Textbook/Resources Courses

Fall 2024
Spring 2024
Summer 2024

Low Cost Textbook/Resources Courses

Fall 2024
Spring 2024
Summer 2024

Course Planning by Program

2023-24

Essential Objectives

Course Syllabus


Revision Date: 21-Dec-23
 

Spring 2024 | CIS-1430-VU01 - Spreadsheets


In Person Class

Standard courses meet in person at CCV centers, typically once each week for the duration of the semester.

Location: Winooski
Credits: 3 (45 hours)
Day/Times: Wednesday, 11:45A - 02:30P
Semester Dates: 01-24-2024 to 05-01-2024
Last day to drop without a grade: 02-11-2024 - Refund Policy
Last day to withdraw (W grade): 03-24-2024 - Refund Policy
This course has started, please contact the offering academic center about registration

Faculty

Shelby Losier
View Faculty Credentials
View Faculty Statement
Hiring Coordinator for this course: Nick Molander

General Education Requirements


This section meets the following CCV General Education Requirement(s) for the current catalog year:
VSCS Digital and Technical 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 catalog year 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 learn to build a variety of spreadsheets using simple and complex formulas, functions, graphics, database features, sorts, linkages within and between spreadsheets, and macros. Basic computer and internet skills are required.


Essential Objectives

1. Demonstrate ability to manage workbook options and settings including multiple workbooks, macros, workbook versions, privacy and protection, comment management, editing and display languages, and language-specific features.
2. Manage and format data using Flash Fill, advanced Fill Series options, custom number formats, data validation, groups, subtotals, and removing duplicate data.
3. Develop proficiency with advanced formulas and functions including but not limited to logical and Boolean functions, nesting multiple functions, date and time functions, and financial functions.
4. Proficiently choose the correct data functions for various application such as VLOOKUP, HLOOKUP, MATCH, and INDEX functions.
5. Summarize data from multiple ranges with the Consolidate feature.
6. Perform what-if analyses with tools such as Goal Seek and Scenario Manager.
7. Troubleshoot formulas with trace precedence and dependence, validate and evaluate formulas using error checking rules, and monitor cells and formulas using the Watch Window.
8. Manage advanced charts and tables including dual axis charts, maps, and advanced chart types.
9. Create PivotTables and PivotCharts using slicers, and calculated fields and incorporate styles and appropriate details.
10. Design, plan, and organize data that is accessible and accurately and ethically conveys information, thoughts, and ideas.
11. Explain how the use and presentation of data and spreadsheets can be used to persuade, inform, and misinform, particularly around systems of inequality and social change.
12. Evaluate and cite digital information effectively and ethically.
13. Demonstrate the ability to create resources, set appropriate permissions for cloud-based files and applications, and apply file management principles on local and remote networks.


Required Technology

Students in this course will need access to Microsoft 365. This software is available on CCV lab computers at CCV academic centers and to CCV students free of charge through a download of Microsoft 365. Information on how to download Microsoft 365 can be found HERE.

Microsoft 365 can be installed on Windows 10/11 PC and Macintosh computers and laptops. It cannot be installed on a Chromebook. Microsoft 365 on a Macintosh computer does not include all of the features supported by Windows and there are significant menu differences.

If you have difficulty in acquiring or accessing this resource for your course, please contact your advisor or financial aid counselor.

More information on general computer and internet recommendations is available on the CCV IT Support page. https://support.ccv.edu/general/computer-recommendations/

Please see CCV's Digital Equity Statement (pg. 45) to learn more about CCV's commitment to supporting all students access the technology they need to successfully finish their courses.


Required Textbooks and Resources

This course uses one or more textbooks/books/simulations.

Spring 2024 textbook details will be available on 2023-11-06. On that date a link will be available below that will take you to eCampus, CCV's bookstore. The information provided there will be specific to this class. Please see this page for more information regarding the purchase of textbooks/books.

CIS-1430-VU01 Link to Textbooks for this course in eCampus.

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


Methods

This course will cover the application of spreadsheet software, namely Excel. Teaching methods will include lectures, open resource and internet materials, class discussions, practical application exercises, and group projects.

CCV's online course management tool, Canvas, will be utilized to submit assignments, disseminate open resource and internet materials, and facilitate course communications.

This course runs Wednesday-Tuesday weekly, and all assignments are due no later than each Tuesday by 11:59 PM. It is important that assignments are completed each week in order to effectively participate.


Evaluation Criteria

  • Attendance/Participation - 10%
  • Discussion Posts - 10%
  • Quizzes - 10%
  • Assignments - 10%
  • Group Project - 20%
  • Mid-Term Project - 20%
  • Final Project - 20%

Grading Criteria

CCV Letter Grades as outlined in the Evaluation System Policy are assigned according to the following chart:

 HighLow
A+10098
A Less than 9893
A-Less than 9390
B+Less than 9088
B Less than 8883
B-Less than 8380
C+Less than 8078
C Less than 7873
C-Less than 7370
D+Less than 7068
D Less than 6863
D-Less than 6360
FLess than 60 
P10060
NPLess than 600


Weekly Schedule


Week/ModuleTopic  Readings  Assignments
 

1

Basics of Spreadsheets

  

Basic Skills - Essential Skills Text - Session 1

  
  • Quiz
  • Assessment
 

2

Basic Spreadsheets Continued

  

Basic Skills - Essential Skills Text - Session 2

  
  • Quiz
  • Assessment
 

3

Formatting & Efficiency Tools

  

Formatting & Efficiency Tools -Essential Skills Text - Session 3

  
  • Quiz
  • Assessment
  • Discussion Post
 

4

Conditional Formatting, In-Cell Graphing & Advanced Functions

  

Conditional Formatting, In-Cell Graphing & Advanced Functions -Essential Skills Text - Session 4

  
  • Quiz
  • Assessment
 

5

Tables & Ranges

  

Tables & Ranges -Expert Skills Text - Session 1

  
  • Quiz
  • Assessment
  • Group Assessment Milestone 1
 

6

Forms, Names & Formula Auditing

  

Forms, Names & Formula Auditing -Expert Skills Text - Session 5

  
  • Assessment
  • Discussion Post
 

7

Sheets & Books/Charts & Graphs

  

Sheets & Books/Charts & Graphs -Essential Skills Text - Session 5

  
  • Quiz
  • Mid-Term Assessment
 

8

Maps

  

Maps -Expert Skills Text - Session 10

  
  • Assessment
  • Discussion Post
 

9

Advanced Functions, Cont.

  

Advanced Functions, Cont. -Expert Skills Text - Session 3

  
  • Quiz
  • Assessment
  • Group Assessment Milestone 2
 

10

Data Integrity, Subtotals & Validations

  

Data Integrity, Subtotals & Validations -Expert Skills Text - Session 2

  
  • Quiz
  • Assessment
  • Discussion Post
 

11

Working Across Worksheets and Workbooks

  

Working Across Worksheets and Workbooks -Essential Skills Text - Session 6

  
  • Quiz
  • Assessment
 

12

Excel Forms & Printing

  

Excel Forms & Printing -Essential Skills Text - Session 7 &Expert Skills Text - Session 8

  
  • Quiz (x2)
  • Assessment (x2)
 

13

Hyperlinks and Office Integration

  

Hyperlinks and Office Integration -Expert Skills Text - Session 7

  
  • Quiz
  • Assessment
  • Group Assessment Milestone 3 (Final)
 

14

Pivot Tables, What-If Analysis & Data Security

  

Pivot Tables, What-If Analysis & Data Security - Expert Skills Text Sessions 6 and 9

  
  • Group Presentation
  • Assessment
  • Final Assessment
 

Attendance Policy

Regular attendance and participation in classes are essential for success in and are completion requirements for courses at CCV. A student's failure to meet attendance requirements as specified in course descriptions will normally result in a non-satisfactory grade.

  • In general, missing more than 20% of a course due to absences, lateness or early departures may jeopardize a student's ability to earn a satisfactory final grade.
  • Attending an on-ground or synchronous course means a student appeared in the live classroom for at least a meaningful portion of a given class meeting. Attending an online course means a student posted a discussion forum response, completed a quiz or attempted some other academically required activity. Simply viewing a course item or module does not count as attendance.
  • Meeting the minimum attendance requirement for a course does not mean a student has satisfied the academic requirements for participation, which require students to go above and beyond simply attending a portion of the class. Faculty members will individually determine what constitutes participation in each course they teach and explain in their course descriptions how participation factors into a student's final grade.


Participation Expectations

Full participation requires active and thoughtful engagement in class each week. The following habits and skills are important.

  • Attend class regularly, on-time and for the full session
  • Complete all of the week's reading and assignments before the start of class
  • Listen to others attentively and with an open mind
  • Positively contribute to class discussions and activities
  • Ask questions and seek help when you need it
  • Challenge yourself to do your best work

To earn full participation in discussion posts, students should:

  • Read the assigned material and demonstrate an understanding of those resources in your assignments and posts. Readings and resources should be cited using APA format.
  • Post an original response to the prompt(s) before Sunday at midnight (11:59 PM) and a minimum of two responses to peers before Tuesday at midnight (11:59 PM). You are welcome to post early and/or more frequently, as your schedule allows, but you will not receive full credit if you do not meet these minimum requirements and/or deadlines.
  • Posts should be substantive and demonstrate college-level writing. A substantive post is well-developed, a minimum 150 words, and references the reading or another appropriate source. A substantive post is NOT one or two sentences of general statements or unsupported opinion.


Missing & Late Work Policy

  • Late assignments can be submitted up to one week past the deadline. You will lose 5% each day that an assignment is late. After a week, work will no longer be accepted for credit.
  • Late work is not accepted in the discussion forum. Interacting with classmates is an essential part of online discussions and cannot be made up after the fact.
  • Extensions will be granted only in extenuating circumstances by contacting your instructor as soon as possible.

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. https://ccv.edu/discover-resources/students-with-disabilities/
  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 Integrity


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.