Computer Concepts and Applications

General Course Information

Course Lecturer Name(s): Ms. Teah Cummings

Course Director Name: N/A

Course Lecturer(s) Contact Information:

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

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:

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

Student Learning Outcomes:

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

Program Outcomes Met By This Course:

  1. 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
  2. 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.
  3. 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.


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:

  1. Computer concepts: 10%
  2. Word processing: 20%
  3. Spreadsheet: 30%
  4. Presentation: 20%
  5. 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:



Major Topics

Unit 1: Computer concepts



1, 2



1. Computer systems

  1. Brief history of computers
  2. Types of computer systems, uses & definitions
  3. Impact of computers in society
  4. Information systems overview

2. Hardware and software

  1. Types of hardware, purposes & ex- amples
  2. Types of operating systems & ex- amples
  3. Input and output devices

3. File management

  1. File types & extensions
  2. file management techniques

Module Exercises


Unit 1

Module exam


Unit 1

Unit 2: Word processing
















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


Unit 2

Unit 3: Spreadsheet




















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




Unit 4: Presentation

9, 10, 11

Creating a new presentation

1. Opening an existing presentation




Adding new slides, slide master & lay- outs




Applying presentation templates / themes




Formatting slides,




Working with transitions & animations




Using special effects




Playing a slide show




Video & audio files




Recording/voice overs in slideshows

Module Exercises

9 - 11

Unit 4


Module exam


Unit 4


Unit 5: Internet use and principles

12, 13, 14


Finding information on the Internet – Searching, web browser technology




Internet  Applications  –  Email,  cloud computing,




Integrating  applications  and  Internet documents – copying, pasting, editing




How the internet works, HTML, basic web design concepts




Computer & Internet Security




Basic computer network terminology & setup




Online etiquette




Computer & online ethics, privacy, plagiarism, intellectual property rights,

Module Exercises

12 - 14

Unit 5


Module Review


Unit 5




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


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.