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

2024-25

Essential Objectives

Course Syllabus


Revision Date: 27-Dec-23
 

Spring 2024 | CIS-1041-VO10S - Computer Applications


Synchronous Class

Synchronous courses are delivered through a combination of online and regularly-scheduled Zoom sessions. In synchronous classes, students must attend Zoom sessions and actively engage with each other and faculty in course activities and discussions.

Location: Online
Credits: 3 (45 hours)
Synchronous Section: This course has schedule meeting dates and times online via Zoom. See below or consult Self Service - Search for Courses and Sections for specific dates and times.
In-Person Meeting Day/Times via Zoom: Monday, 06:00P - 08:00P
Semester Dates: 01-22-2024 to 04-29-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

Mario Hankerson
View Faculty Credentials
View Faculty Statement
Hiring Coordinator for this course: Deb Grant

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 hands-on introduction to office application software designed for computers and mobile devices. Topics include cloud applications, presentations, word processing, and spreadsheets. Basic computer and internet skills are required.


Essential Objectives

1. Demonstrate safe computing practices.
2. 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.
3. Explain the function and the primary features of a word processing program and create documents appropriate for academic and business environments.
4. Design and build a spreadsheet using professional formatting, names, labels, tables, values, formulas, functions, and absolute and relative references.
5. Use spreadsheet software to present and analyze quantitative information, draw conclusions, and evaluate the reliability of those conclusions.
6. Use presentation software to demonstrate proficiency in using text, graphs, organizational charts, tables, artwork, drawing tools, animation, and multimedia.
7. Demonstrate effective, safe, and ethical searching, evaluating, communicating, and citing of digital information.
8. Discuss legal and ethical issues related to computers and information processing, including fair use standards, academic honesty, and user accessibility.
9. Discuss how digital media perpetuates or disrupts systems of inequality.
10. Determine the appropriate devices and software for a variety of tasks and how to accurately convey information, thoughts, and ideas.


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 is a no cost textbook or resource class. ***

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


Methods

  • Small-group and whole-class discussion
  • Online discussion forums
  • Lecture
  • Mini-lecture videos and emails
  • Online reading and videos from library and software vendors
  • Small group activities
  • In-class procedures with application software
  • Online exams
  • Word processing and Spreadsheet projects
  • Presentation project with discussion
  • Homework practicals

Evaluation Criteria

Your final grade will be based on the following assessments:

Grade Table
Assignment Category Grade Weight Percentage
Discussions, Knowledge Forums & Assignments 35%
Quizzes 30%
Projects 25%
Self-Assessments 10%
Total 100%

Attendance and Participation
This grade is based on your weekly participation in class as assigned as well as group and participatory projects.

Discussions
There are weekly required discussion forums based on the content for the week.

Quizzes
Quizzes are given online with 5 attempts but a 2 week period for completion. Quizzes are based on online videos and reading as well as projects and group work. ChatGPT or similar AI/ML tools are allowed to assist.

Homework
A varying number of homework assignments are assigned weekly based on the content covered for the week. ChatGPT or similar AI/ML tools are allowed to assist.

Projects
There are three cumulative projects based on the material covered in the class allowing students to apply the skills covered in class. ChatGPT or similar AI/ML tools are allowed to assist.

Self-Assessments
Students complete web-based forms to evaluate their class and homework performance on a weekly basis.


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

OneDrive and Intro to Cloud Computing

  
  • Windows 10 - GCF Learn Free
  • OneDrive lessons from GCF Learn Free
  
  • 4 introductory online discussions on Canvas
  • OneDrive submission practice
  • Create Folders in OneDrive
  • Copy and Share O365 Word Document
  • Create a Google Drive Account
  • Update Canvas Profile Picture
  • Self-Assessment
 

2

Google Drive, Malware, Spyware, Phishing

  
  • Instructor written "Using Google Drive"
  • Instructor written "Overview of Google Docs"
  • Google Drive lessons in GCF Learn Free
  • Phishing handout
  • Website on email phishing
  • Website on web phishing
  
  • Online Discussion on experience with malware
  • Select a research and presentation topic
  • Create a Course folder in OneDrive
  • Specific file sharing in Google Drive
  • Quiz:Phishing Self-Assessment
  • Self-Assessment
 

3

Word Processing – Templates, Structure, Graphics, Tables

  
  • GCF Learn Free Word
  • Microsoft Word 2019 Step by Step Part 1
  • Microsoft Word 2019 Step by Step Part 2
  
  • Create a document from a template
  • 2030 Resume assignment
  • Open a PDF in Word (not available for Mac computers)
  • Edit text
  • Modify text
  • Tables
  • Add graphic elements
  • Quiz: VSC Library
  • Self-Assessment
  • Online Discussion
 

4

Research Papers, Page-level Formatting, Copyright/Plagiarism

  
  • Microsoft Word 2019 Step by Step Chapters 9 and 10 and 13
  • Several videos and web articles on copyright and Creative Commons
  • Wikipedia entry on History of Copyright Law
  • Films on Demand video on Plagiarism and Information Ethics
  
  • Online discussion about remixing, stealing, reposting, piracy, sharing, copyright, and plagiarism
  • Format page backgrounds
  • Complete Microsoft Official Academic Course chapter on writing research papers in Word
  • Headers, Footers, page numbers
  • Quiz:Based on Hartness Library video "Plagiarism and Information Ethics"
  • Self-Assessment
 

5

Columns, Markup, Picture Diagrams/3D Models, Search Skills

  
  • Microsoft Word 2019 Step by Step Chapter 7
  • Microsoft Word 2019 Step by Step Chapter 11
  
  • Formatting and Expense Report
  • Formatting a two-column newsletter
  • Mark up documents
  • Picture diagrams OR 3D models
  • 2030 Resume
  • Research topic sources
  • Self-Assessment
  • Quiz:based on VSC Library video "Effective Internet Searches"
  • Online Discussion
 

6

MailMerge and Intro to Presentations

  
  • Microsoft Word 2019 Step by Step Chapter 13
  • Microsoft Word 2019 Step by Step Chapter 14
  • Life after Death by PowerPoint – YouTube video - Don McMillan
  • How to Avoid Death by PowerPoint – TED Talk – David JP Phillips
  • GCF Learn Free PowerPoint (optional)
  • PowerPoint Step by Step Chapter 1
  • PowerPoint Step by Step Chapter 2
  
  • Mail Merge assignment from MOAC Lesson 11
  • Quiz:Microsoft Office Word
  • Research project storyline worksheet
  • Remove audio from the beginning or end of an audio file
  • Remove audio from the middle of an audio file
  • Create a bad presentation
  • PowerPoint Step by Step Chapter 1 Practice Task(s)
  • PowerPoint Step by Step Chapter 2 Practice Task(s)
  • Self-Assessment
  • Online Discussion
 

7

Create Presentations, Manage Slides

  
  • PowerPoint Step by Step Chapter 3
  • PowerPoint Step by Step Chapter 4
  • PowerPoint Step by Step Chapter 5
  
  • PowerPoint Step by Step Chapter 3 Practice Task(s)
  • PowerPoint Step by Step Chapter 4 Practice Task(s)
  • PowerPoint Step by Step Chapter 5 Practice Task(s)
  • Self-Assessment
  • Online Discussion
 

8

Manage Graphics, Sound, Animation, Notes

  
  • PowerPoint Step by Step Chapter 6
  • PowerPoint Step by Step Chapter 7
  • PowerPoint Step by Step Chapter 8
  
  • PowerPoint Step by Step Chapter 6 Practice Task(s)
  • PowerPoint Step by Step Chapter 7 Practice Task(s)
  • PowerPoint Step by Step Chapter 8 Practice Task(s)
  • Self-Assessment
  • Online Discussion
 

9

Prepare Presentations for Presentation, Multimedia, Presenter View

  
  • PowerPoint Step by Step Chapter 9
  • PowerPoint Step by Step Chapter 10
  • PowerPoint Step by Step Chapter 11
  
  • Create a working presentation
  • Present computer ethics topic
  • Create and share computer ethics topic handout
  • Self-Assessment
  • Online Discussion
 

10

Intro to Spreadsheets – Setup a Workbook, Work with Data and Tables

  
  • Excel Basics with GCF Learn Free
  • Planet Money Podcast Episode 606
  • Microsoft Excel Step by Step Chapter 1
  • Microsoft Excel Step by Step Chapter 2
  
  • Podcast reaction essay
  • Enter and revise data
  • Find and Replace data
  • Manage data with Flash Fill
  • Quiz:Microsoft Office Word
  • Self-Assessment
  • Online Discussion
 

11

Perform Calculations, Change Workbook Appearance, Manage Data

  
  • Microsoft Excel Step by Step Chapter 3
  • Microsoft Excel Step by Step Chapter 7
  • Microsoft Excel Step by Step Chapter 14 (certain parts)
  
 

12

Reorder and Summarize Data, Multiple Sources, Printing Spreadsheets

  
  • Microsoft Excel Step by Step Chapter 3
  • Microsoft Excel Step by Step Chapter 4
  • Microsoft Excel Step by Step Chapter 6
  • Google Sheets Function List
  • GCF Learn Free: Data Validations, IF function, VLOOKUP function
  • More reading on IF, Data Validation, and VLOOKPUP
  
  • Incorporate basic statistical functions
  • Research and find appropriate functions for use in a spreadsheet
  • Chapter 3 practice tasks
  • Chapter 4 practice tasks
  • Self-Assessment
  • Online Discussion
 

13

Formatting & Charts

  
  • Microsoft Excel Step by Step Chapter 9
  • Microsoft Excel Step by Step Chapter 13 (certain parts)
  • Instructor created Canvas pages
  
  • Chapter 9 practice tasks
  • Chapter 13 practice tasks
  • Information around us – chart
  • Evaluate misleading charts
  • Self-Assessment
  • Online Discussion
 

14

Logical Functions, Data Validation

  

Microsoft Excel Step by Step Chapter 5

  
  • Chapter 5 practice tasks
  • Quiz: Microsoft Excel
  • Self-Assessment
  • Online Discussion
 

15

Student Computing Ethics Presentations

  

Classmate computer ethics presentations

  
  • Review classmate presentations
  • Self-Assessment
  • Online Discussion
 

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. You'll have the opportunity to self-assess and receive instructor feedback on each of these areas at the mid-point and the end of the semester.

  • Attend class regularly, on-time and for the full session
  • Positively contribute to class discussions and activities
  • Ask questions and seek help when you need it
  • Challenge yourself to do your best work


Missing & Late Work Policy

  • Assignments are due by the deadline noted on the syllabus, even when you need to be absent. Your work (programming assignments) can be emailed or uploaded to Canvas.
  • You are responsible for checking Canvas and getting any notes, materials and assignments for the class you missed. Please reach out and ask questions if anything is unclear.
  • Late work in not accepted, except in emergency situations. In the case of an extenuating circumstance, please communicate as early as you can with your instructor about the need to miss class and/or assignments.

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.