Computer Concepts and Applications

Download as PDF

Course

COMP 111

Semester

Spring

Year

2022

Catalog

School of Arts and Sciences

General Course Information

Course Lecturer Name(s): Ms. Teah Cummings

Course Director Name: N/A

Course Lecturer(s) Contact Information: tecummings@sgu.edu

Course Director Contact Information: N/A.

Course Lecturer(s) Office Hours: By Appointment only

Course Director Office Hours: N/A

Course Lecturer(s) Office Location: Online

Course Director Office Location: N/A

Course Support N/A

Course Management tool: To learn to use Sakai, the Course management tool, access the link https://apps.sgu.edu/members.nsf/mycoursesintro.pdf

Course Curriculum Information

Course Description:

This course is designed to introduce students to basic computer concepts and to provide them with the necessary tools and techniques to produce documents, spreadsheets and presentations. The student will also be introduced to Internet use and principles. This course will cover areas such as: computers systems, hardware and software, file management, document production, working with spreadsheets and presentations.

Course Objectives:

To have a working and conversational knowledge of basic computer terms and concepts
To demonstrate the ability to do projects, using the productivity software that are used in the course

Student Learning Outcomes:

Define basic terms and concepts related to computers, networks, software and the Inter- net
Evaluate and select the correct office productivity software appropriate to use in a given situation.
Using Microsoft PowerPoint: Create well-designed professional and academic presenta- tions
Using Microsoft Word: Create and prepare professional and academic documents using a variety of techniques including use of Charts, SmartArt, Tables, fonts and layouts
Using Microsoft Excel: Choose and use the appropriate function to perform calculations and solve equations / problems.

Program Outcomes Met By This Course:

CTP-O1: Analyze a problem, identify and define the computing requirements appropriate to its solution, taking into consideration current techniques, concepts, skills, tools, and best practices used in the core information technologies
CTP-O2: Design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs, applying current techniques, concepts, skills, tools, and best practices used in the core information technologies.
CTP-O5: Demonstrate teamwork

SAS Grading Scale: Grades will be assigned as follows:

A = 89.5% or better

B+ = 84.5 - 89.4%

B = 79.5 - 84.4%

C+ = 74.5 - 79.4%

C = 69.5 - 74.4%

D = 64.5 - 69.4%

F = 65% or less

Course Materials:

Text: GO! All in One: Computer Concepts and Applications, 4rd Edition, by Shelley Gaskin Alicia Vargas, Debra Geoghan, Nancy Graviett. Pearson, 2019.

Supplementary Readings/Resources: Any text relating to Microsoft Office will assist the student in this course.

Recommended:

GO! with Microsoft Excel 2016 Comprehensive by Shelley Gaskin ,Alicia Vargas, . Pearson, 2017.

GO! with Microsoft Word 2016 Comprehensive by Shelley Gaskin, Alicia Vargas, Pearson, 2017.

GO! with Microsoft Powerpoint 2016 Comprehensive by Shelley Gaskin, Alicia Vargas, Pearson, 2017. .

Course Grading Requirement:

Computer concepts: 10%
Word processing: 20%
Spreadsheet: 30%
Presentation: 20%
Internet use: 20%

Course Requirements:

There will be one graded assignment and one exam for each module/unit, in addition to regular class exercises.

Course Schedule:

Lesson	Week	Major Topics
Unit 1: Computer concepts	1, 2	1. Computer systems Brief history of computers Types of computer systems, uses & definitions Impact of computers in society Information systems overview
		2. Hardware and software Types of hardware, purposes & ex- amples Types of operating systems & ex- amples Input and output devices
		3. File management File types & extensions file management techniques
Module Exercises	1-2	Unit 1
Module exam	3,4	Unit 1
Unit 2: Word processing	3,4,5	1. Create and edit text in a document
		2. Create hyper linked documents
		3. Formatting text – borders, styles, headers, footers
		4. Create different types of documents using Word
		5. Create and modify tables
		6. Mail merge
		7. Working with graphics
		8. Using track changes
Module Exercises	3 - 5	Unit 2
Module exam	5	Unit 2
Unit 3: Spreadsheet	5,6,7	1. Working with templates 2. Selecting cells and cell ranges
		3. Labels and numbers / using flash fill
		4. Introducing formulas and functions
		5. Use statistical functions (Sum, Aver- age, Minimum, and
		6. Maximum).Use logical functions (If, SumIf, Countif, vlookup)
		7. Work with ranges in functions.
		8. Copy formulas that include absolute and relative cell references.
		9. Using Excel to solve mathematical problems
		10. Charts – pivot tables & charts, regular types of charts
		11. What if analysis & goal seek

Module Exercises	5 - 7	Unit 3
Midterm	8
Unit 4: Presentation	9, 10, 11	Creating a new presentation 1. Opening an existing presentation
		2.	Adding new slides, slide master & lay- outs
		3.	Applying presentation templates / themes
		4.	Formatting slides,
		5.	Working with transitions & animations
		6.	Using special effects
		7.	Playing a slide show
		8.	Video & audio files
		9.	Recording/voice overs in slideshows
Module Exercises	9 - 11	Unit 4
Module exam	11	Unit 4
Unit 5: Internet use and principles	12, 13, 14	1.	Finding information on the Internet – Searching, web browser technology
		2.	Internet Applications – Email, cloud computing,
		3.	Integrating applications and Internet documents – copying, pasting, editing
		4.	How the internet works, HTML, basic web design concepts
		5.	Computer & Internet Security
		6.	Basic computer network terminology & setup
		7.	Online etiquette
		8.	Computer & online ethics, privacy, plagiarism, intellectual property rights,
Module Exercises	12 - 14	Unit 5
Module Review	15	Unit 5
Finals		Unit 5 only

School of Arts and Sciences Master Syllabi — Info for All Sections

Plagiarism Policy

Academic Integrity

The St. George’s University Student Manual (2019/2020) states as follows:

“Plagiarism is regarded as a cardinal offense in academia because it constitutes theft of the work of someone else, which is then purported as the original work of the plagiarist. Plagiarism draws into disrepute the credibility of the Institution, its faculty, and students; therefore, it is not tolerated” (p. 48).

Plagiarism also includes the unintentional copying or false accreditation of work, so double check your assignments BEFORE you hand them in.

Be sure to do good, honest work, credit your sources and reference accordingly and adhere to the University’s Honor Code. Plagiarism and cheating will be dealt with very seriously following the university’s policies on Plagiarism as outlined in the Student Manual.

Your work may be subject to submission to plagiarism detection software, submission to this system means that your work automatically becomes part of that database and can be compared with the work of your classmates.

Attendance Requirement

The St. George’s University Student Manual (2019/2020) states as follows:

“Students are expected to attend all classes and or clinical rotations for which they have registered. Although attendance may not be recorded at every academic activity, attendance may be taken randomly. Students’ absence may adversely affect their academic status as specified in the grading policy. If absence from individual classes, examinations, and activities, or from the University itself is anticipated, or occurs spontaneously due to illness or other extenuating circumstances, proper notification procedures must be followed. A particular course may define additional policies regarding specific attendance or participation” (p. 9).

Examination Attendance

The St. George’s University Student Manual (2019/2020) states as follows:

“All matriculated students are expected to attend all assigned academic activities for each course currently registered. Medical excuses will be based on self-reporting by students. Students who feel they are too sick to take an examination or other required activity on a specific day must submit the online SAS medical excuse, which is available on Carenage. Students are only allowed two such excuses a year. Upon consultation with the Director of University Health Service, the third excuse will result in a mandatory medical leave of absence. The policies regarding make-up examinations are at the option of the Course Director” (p.46).

For additional specific examination policies and procedures, refer to the St. George’s University Student Manual (2019/2020), pages 31 through 37.

Student Accessibility and Accommodation Services Policy

The St. George’s University Student Manual (2019/2020) states as follows:

“A student with a disability or disabling condition that affects one or more major life activities, who would like to request an accommodation, must submit a completed application form and supporting documentation to the Student Accessibility and Accommodation Services (SAAS) located in the Dean of Students Office. It is highly recommended that students applying for accommodations do so at least one month before classes begin to allow for a more efficient and timely consideration of the request. If a fully completed application is not submitted in a timely fashion, an eligibility determination may not be made, and accommodations, where applicable, may not be granted prior to the commencement of classes and/or examinations” (p. 8).

Disclaimer

It is the responsibility of the student to read and understand the policies, laws, rules and procedures that while they could affect your grade for a course, have not been specifically outlined in the course syllabus. These are contained in the St. George’s University Student Manual.