CCV Section Grid - Detail
 
Vermont State Colleges
 
Untitled

Web Schedules

Fall 2018
Spring 2019
Summer 2019

Accelerated Courses

Fall 2018
Spring 2019
Summer 2019

Course Planning by Program

2018-19

Web Schedule Summer 2019


Spreadsheets




Credits: 3 (45 hours)
Semester Dates: Last day to drop without a grade: 06-02-2019 - Refund Policy
Last day to withdraw (W grade): 07-09-2019 - Refund Policy
Faculty: Not Yet Assigned | View Faculty Credentials
This course has started, please contact the offering academic center about registration

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 2019 textbook data will be available on April 8. 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.

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