JCU Logo

JOHN CABOT UNIVERSITY

COURSE CODE: "CS 110-4"
COURSE NAME: "Computer Office Applications"
SEMESTER & YEAR: Spring 2019
SYLLABUS

INSTRUCTOR: Khaison Duong
EMAIL: [email protected]
HOURS: MW 11:30-12:45 PM
TOTAL NO. OF CONTACT HOURS: 45
CREDITS:
PREREQUISITES:
OFFICE HOURS:

COURSE DESCRIPTION:
This course helps students develop the advanced skills that are necessary in personal productivity office applications, such as word processing, data management and analysis, and presentation/slide design. The course follows best practices and reviews available internet tools for data storage.
SUMMARY OF COURSE CONTENT:
Practical use of the Windows environment. MS Word. MS Excel. MS PowerPoint.
LEARNING OUTCOMES:
1      produce well formatted and use key features of MS Word documents .

2     produce spreadsheets with MS Excel and manipulate data meaningfully.

3      produce quality presentations with MS PowerPoint.

TEXTBOOK:
NONE
REQUIRED RESERVED READING:
NONE

RECOMMENDED RESERVED READING:
NONE
GRADING POLICY
-ASSESSMENT METHODS:
AssignmentGuidelinesWeight
Attendance and participation 15
Classwork and assignments5 assignments partially done as classwork25
Projects3 projects (Word, Excel, PowerPoint)30
Final exam 30

-ASSESSMENT CRITERIA:
AWork of this quality directly addresses the task or problem raised and provides a coherent application of concepts displaying mastery of the skills learned. This type of work demonstrates the ability to critically evaluate concepts and theory and apply them with an element of novelty and originality. There is clear evidence of a significant amount of work beyond that required for the course.
BThis is highly competent level of performance and directly addresses the task or problem raised. There is a demonstration of some ability to critically evaluate theory and concepts and relate them to practice. Work produced reflects students’ own adaptation and not simply a repetition of standard lecture. The work does not suffer from any major errors or omissions and provides evidence of work beyond the required assignments.
CThis is an acceptable level of performance and provides work that is clear but limited, reflecting the information offered in the lectures and resources.
DThis level of performances demonstrates that the student lacks a coherent grasp of the material or skills. Important concepts are not applied adequately. In effect, the student has barely done enough to persuade the instructor that s/he should not fail.
FThis work fails to show any knowledge or understanding of the task or problem. Most of the work produced is unacceptable or irrelevant.

-ATTENDANCE REQUIREMENTS:
Attendance is mandatory as all lessons will be held in the computer laboratory and will be a combination of theory and practice. Students spending most of the class time using smart-phones or the like will be marked absent. Students will lose 1% for every unexcused absence. Consistently being late will also be penalized.
ACADEMIC HONESTY
As stated in the university catalog, any student who commits an act of academic dishonesty will receive a failing grade on the work in which the dishonesty occurred. In addition, acts of academic dishonesty, irrespective of the weight of the assignment, may result in the student receiving a failing grade in the course. Instances of academic dishonesty will be reported to the Dean of Academic Affairs. A student who is reported twice for academic dishonesty is subject to summary dismissal from the University. In such a case, the Academic Council will then make a recommendation to the President, who will make the final decision.
STUDENTS WITH LEARNING OR OTHER DISABILITIES
John Cabot University does not discriminate on the basis of disability or handicap. Students with approved accommodations must inform their professors at the beginning of the term. Please see the website for the complete policy.

SCHEDULE

Week

Topic

Assignment

1

 

 

Introduction

Writing and text editing

Word templates

 

2

MS Word
Home tab
Basic formatting

Page layout

3

Documents reviewing

Table of contents

Class assignment 1

4

Insert tab

Tables and graphical elements

Class assignment 2

5

References

discovery

6

MS Excel

Entering data into Cells
Formatting Cells

7

Creating multiple sheets

Class assignment 3

8

Understanding and using Formulas

9

Understanding and using Functions
Creating Charts

Class assignment 4

10

Creating Pivot Tables

Class assignment 5

11

What-if analysis

 

 

 

Logic functions and lookup

 

12

MS PowerPoint
Preparing slides
Special effects and presentation timing.

13

Presentations

14

Presentations

15

Final exam