Course Syllabus

Summer 2025 | CIS-1430-VO05F - Spreadsheets

Flex Class

FLEX courses are online courses with flexible assignment submission, allowing students to manage their completion pace during the semester. FLEX courses remain open for enrollment throughout the first half of the semester. Flex course enrollment for Summer 2025 ends on July 3.

Faculty

Hilary Ivy
View Faculty Credentials
View Faculty Statement
Hiring Coordinator for this course: Deb Grant

General Education Requirements

VSCS Digital and Technical Literacy

Note

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.

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. Identify the correct data functions for various applications 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.
14. Demonstrate appropriate prompt engineering when working with generative AI applications for text and media.

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 computer recommendations Support page.

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, along with free Open Educational Resources (OER) and/or library materials.

Summer 2025 textbook/book details will be available on 2024-12-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-VO05F Link to Textbooks for this course in eCampus.

For Open Educational Resources (OER) and/or library materials details, see the Canvas Site for this class.

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.

Artificial Intelligence(AI) Policy Statement

CCV recognizes that artificial intelligence (AI) and generative AI tools are widely available and becoming embedded in many online writing and creative applications.

Integrated: This course's generative AI policy acknowledges the use of AI is an essential skill in today's world. By using genAI for specific purposes, students become equipped with relevant skills and tools necessary to thrive in a technology-driven society. Emphasizing the mastery of generative AI should empower you to harness its potential, enhancing your problem-solving abilities and preparing you for future challenges and opportunities. Be aware, however, that any time generative AI is used at any point in the assignment without attribution it may be considered a violation of CCV's Academic Integrity Policy.

Methods

• Hands-on Practice: Provide students with sample data sets and guide them through creating spreadsheets, formatting cells, entering formulas, and using various functions. Encourage them to follow along and practice as you demonstrate.
• Real-world Examples: Use practical examples from different industries or scenarios to illustrate how spreadsheets are used in the real world. This helps students understand the relevance and applicability of the skills they are learning.
• Step-by-Step Tutorials: Break down complex tasks into smaller, manageable steps and provide detailed tutorials or worksheets for students to follow. This approach ensures that no one gets left behind and everyone can work at their own pace.
• Collaborative Learning: Encourage students to work in pairs or small groups on spreadsheet projects or assignments. This fosters peer learning, teamwork, and the ability to troubleshoot problems together.
• Visual Aids: Use screencasts, video tutorials, or live demonstrations to visually explain concepts and techniques. Visual aids can help reinforce understanding and provide a reference for students to review later.
• Quizzes and Lab Assessments: Incorporate quizzes, practice exercises, or mini-projects to assess students' understanding and provide feedback on their progress.

Evaluation Criteria

Grading:

Self-Assessments 10%

Quizzes 25%

Assignments & Discussion 30%

Projects 30%

Course Participation 5%

Evaluation Criteria:

Discussion Response Criteria

40 points= An initial post is submitted by Friday of the week that it is assigned. The post thoroughly responds to the question and refers to readings or reviewed resources. Posts are thoughtful, spelling and grammar is well done. It is a minimum of 150 words for a minimum grade of 30 points.

60 points=Comments on a minimum of three of your classmate's posts are posted by the following Tuesday. Comments are connected to ideas others posted. The comments are communicated with a minimum of grammatical or spelling errors. The comments are a minimum of 75 words each for a minimum grade of 50 points.

*DISCUSSIONS CANNOT BE MADE UP! You MUST post and comment for the discussion in the week that it is assigned to get credit.

Text Questions Response Criteria

Your answers to the questions are accurate, thoughtful, and spelling and grammar is well done. All questions are answered in complete sentences, unless it is specified that it is a 'list' that is asked for.

Grading Criteria

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

	High	Low
A+	100	98
A	Less than 98	93
A-	Less than 93	90
B+	Less than 90	88
B	Less than 88	83
B-	Less than 83	80
C+	Less than 80	78
C	Less than 78	73
C-	Less than 73	70
D+	Less than 70	68
D	Less than 68	63
D-	Less than 63	60
F	Less than 60
P	100	60
NP	Less than 60	0

Weekly Schedule

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

Participation in discussion forums is an integral part of building a community for this remote class. There are multiple discussion post assignments throughout the semester. For all discussion post assignments student's initial submission must be received at least THREE days BEFORE the assignment due date. Response post to your classmates must be received by the due date to recieve full credit.

Zero tolerance policy for bigoted, racist, msogynist or xneophobic statements in this class. Failure to engage respectfully with your peers will affect your final grade.

Missing & Late Work Policy

Late work will recieve an automatic deduction of 5 points for each day late. Missing work will receive a zero. If you are having trouble keeping up with your work please reach out early.

Accessibility Services for Students with Disabilities:

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

Apply Now for this semester.