CCV Section Grid - Detail
 
Vermont State Colleges
 
Untitled

Web Schedules

Fall 2020
Summer 2020
Spring 2020

Accelerated Courses

Fall 2020
Summer 2020
Spring 2020

Course Planning by Program

2020-21

Essential Objectives

Web Schedule Summer 2020


Revision Date: 31-Dec-19

Computer Applications





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

Comments:

MS Office 2016 required

Course Description:

A hands-on introduction to information processing using operating system and application software designed for computers and mobile devices. Covers cloud computing, presentations, word processing, and spreadsheets. Basic math and computer skills are recommended.

Essential Objectives:

1. Describe the hardware components of a computer system, general functions of the operating system, and the interaction between computer hardware and applications software.
2. Describe the threat of computer malware, spyware, and phishing and demonstrate safe computing practices including file backup procedures.
3. Demonstrate the ability to create resources and set appropriate permissions for cloud-based files and applications and apply file management principles on local and remote networks.
4. Explain the function and the primary features of a word processing program and create documents appropriate for academic and business environments.
5. Design and build a spreadsheet using names, labels, tables, values, formulas, functions, and absolute and relative references.
6. Modify a spreadsheet using various copying and formatting options designed for data manipulation.
7. Use spreadsheet software to present and analyze quantitative information, to draw conclusions, and to evaluate the reliability of those conclusions.
8. Use presentation software to demonstrate proficiency in using text, graphs, organizational charts, tables, artwork, drawing tools, animation, and multimedia.
9. Identify Internet resources and search engines for effective research and retrieval of information on a specific topic.
10. Discuss legal and ethical issues related to computers and information processing, including copyright infringement and plagiarism.
11. Demonstrate an ability to access, navigate, and participate in an online learning environment.

Additional Instructor Pre-Assignments/Notes/Comments:

Computer Requirements: This section uses Microsoft Office 2016 on the Windows 10 operating system. During the class sessions we will use CCV’s personal computers (PC) or if you wish you may use your laptop. You are always welcome and encouraged to complete your work in a computer lab at CCV.

CCV Portal: In order to be able to access the CCV lab computers, you must have already logged into the CCV Portal and changed your password. If you are new to CCV and/or have not changed your password from the default password which was assigned to you, please login to the CCV Portal and change it the week before class. If you need help with this, please contact your local CCV office. The receptionist or your advisor should be able to help you accomplish this task.

Software:If you choose to use your laptop do not use the “Trial Version” of Microsoft Office 2016 that comes free with new computers as it is not complete. Also, do not use Office Mac or Google Drive, as there are compatibility issues.You may download Microsoft Office Home & Business (MAC/PC) 2016 at no cost to you from onthehub.com under Community College of Vermont using this link:https://ccvermont.onthehub.com/WebStore/ProductsByMajorVersionList.aspx?cmi_cs=1&cmi_mnuMain=f189368a-f0a6-e811-8109-000d3af41938.We will discuss this further during our first class session.

Disks: We will use your OneDrive disk storage space to save your work. In addition to your One Drive, you may use a USB flash-drive to save your work.

Methods:

We will use several methods to accomplish the goals of this course with minimal lecture time. There will be a heavy emphasis on student participation and hands-on computer use as well as writing assignments and presentations.

Evaluation Criteria:

Summary of Course Requirements

Points

% of Grade

Microsoft Word

4 Case problems each worth 10 points

40

2 Capstone projects each worth 30 points

60

Total Microsoft Word

100

20%

Microsoft Excel

4 Case problems each worth 10 points

40

2 Capstone projects each worth 30 points

60

Total Microsoft Excel

100

20%

Microsoft PowerPoint

2 Case problems each worth 20 points

40

PowerPoint class presentation

60

Total Microsoft Excel

100

20%

Integrating Word & Excel

40

8%

Examinations - 2 each worth 70 points

140

28%

Class Participation – 13 classes each worth 2 points with lowest 3 scores dropped

20

4%

Total

500

100%

Grading Criteria:

Point Range

Percentage

Grade

490 - 500

98 - 100

A+

465 – 489.9

93 - 97.9

A

450 – 464.9

90 – 92.9

A-

440 – 449.9

88 – 89.9

B+

415 – 439.9

83 – 87.9

B

400 – 414.9

80 – 82.9

B-

390 – 399.9

78 – 79.9

C+

365 – 389.9

73 – 77.9

C

350 – 364.9

70 – 72.9

C-

340 – 349.9

68 – 69.9

D+

315 - 339.9

63 - 67.9

D

300 – 314.9

60 - 67.9

D-

Below 300

Below 60

F

Textbooks:

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.

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.

Attendance Policy:

Class participation is a key component to the success of the course for the individual student and the group. Therefore, it is critical that you attend class regularly to be a full partner in this enhanced learning environment. Please make every effort to attend all class sessions. If you are forced to miss any class time, you are responsible for all material covered. More than three absences or missing a cumulative total of 8.25 hours of class time will result in not passing the course.

Syllabus:


Class Meeting

Topics

Assignments

(due at the beginning of class)

Session 1

Introductions - Syllabus Review - Administrative Issues

Topics: Essential Computer Concepts –

Hardware, Software, Networks, and Security Threats -

Managing Your Files - Internet Basics - Information Literacy - & Basic Business Electronic Communications.

Workshop: Introduction of Portal login, Moodle course page, CCV email, & Office 365 OneDrive. Exploring basics of Windows 10 & Windows Explorer.

Managing Files Tutorial - Internet Basics Tutorial - Internet Scavenger Hunt

Read the Concepts chapter in the text.

Read Managing Your Files – starting with Organizing Your Files and Folders on page FM5 through the first paragraph on FM8.

Session 2

Topics: Introduction to Microsoft Word - Creating & Editing a Document

Workshop: Discussion of last week’s tutorial issues - Word Tutorial 1

Complete tutorials and turn in Internet Scavenger Hunt.

Session 3

Topics: Navigating & Formatting a Document

Workshop: Discussion of last week’s tutorial issues - Word Tutorial 2

Complete Word Tutorial 1 and Case Problem 1. Email the Case Problem 1 Word documents you created to me.

Session 4

Topics: Creating Tables & a Multipage Report

Workshop: Discussion of last week’s tutorial issues - Word Tutorial 3

Complete Word Tutorial 2 and Case Problem 1. Email the Case Problem 1 Word document you created to me.

Session 5

Topics: Enhancing Page Layout & Design

Workshop: Discussion of last week’s tutorial issues - Word Tutorial 4 and Word Capstone Projects

Complete Word Tutorial 3 and Case Problem 1. Email the Case Problem 1 Word document you created to me.

Session 6

Examination 1

Topics: Introduction to Microsoft Excel - Creating a Spreadsheet

Workshop: Discussion of last week’s Word capstone project issues - Excel Tutorial 1

Complete Word Tutorial 4, the Case Problem 1 and the Word Capstone Projects. Email the Case Problem 1 and Capstone Projects Word and .pdf documents you created to me.

Session 7

Topics: Formatting Workbook Text & Data Calculating Data with Formulas & Functions

Workshop: Discussion of last week’s tutorial issues - Excel Tutorial 2 & 3

Complete Excel Tutorial 1 and Case Problem 1. Email the Case Problem 1 Excel files you created to me and turn in the printed version.

Session 8

Topics: Analyzing & Charting Financial Data

Workshop: Discussion of tutorials 2 & 3 issues - Excel Tutorial 4, and Excel Capstone Projects

Complete Excel Tutorials 2 & 3 and the Case Problem 1 for each tutorial. Email the Case Problem 1 Excel files you created to me.

Session 9

Topics: Integrating Word and Excel

Workshop: Discussion of last week’s tutorial and Excel Capstone Project issues - Integrating Word and Excel Tutorial Session 1

Complete Excel Tutorial 4, the Case Problem 1 and the Excel Capstone Projects. Email the Excel files you created to me.

Session 10

Topics: Introduction to PowerPoint - Creating a Presentation

Workshop: Discussion of last week’s Integrating Word and Excel tutorial issues - PowerPoint Tutorial 1

Complete Integrating Word & Excel Tutorial Session 1 and email the Word and Excel files you created to me.

Session 11

Topics: Tips for Effective Presentations

PowerPoint Presentation Assignment

Adding Media & Special Effects

Workshop: Discussion of last week’s tutorial issues - PowerPoint Tutorial 2

Complete PowerPoint Tutorial 1, Case Problem 1. Email the Case Problem 1 PowerPoint file you created to me and turn in the print version.

Session 12

Topics: Final PowerPoint Presentations

Examination 2

Complete PowerPoint Tutorial 2, Case Problem 1. Email the Case Problem 1 PowerPoint file you created to me.

Be prepared to give your oral presentation to the class.

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