JCU Logo

JOHN CABOT UNIVERSITY

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

INSTRUCTOR: Stefano Gazziano
EMAIL: [email protected]
HOURS: MW 3:00 PM 4:15 PM
TOTAL NO. OF CONTACT HOURS: 45
CREDITS:
PREREQUISITES:
OFFICE HOURS: by appointment

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:

Operating systems . File systems and file/folder management.

How to work in different environments: local PC, intranet servers, internet services, cloud computing.

Personal productivity SW: Office (Microsoft, Apache OpenOffice, Google Drive suite) Simple Integration of documents

MS Office: Excel. Word and Powerpoint. Basic and advanced features. Embedding objects among different applications.







Multimedia documents: Prezi, Lucidpress. 

How the Web works: servers and browsers. Internet as a resource.




LEARNING OUTCOMES:
At the end of the course the student will:



1 - Understand the basic concepts of file management on local and network platforms

2 - Know how to use basic and advanced features of office automation programs

3 - Know how to produce professional reports integrating different office automation tools

4 - Understand different environment for personal productivity, local, intranet, cloud.

5 - Know how to use the Internet as a resource for personal productivity
TEXTBOOK:
NONE
REQUIRED RESERVED READING:
NONE

RECOMMENDED RESERVED READING:
NONE
GRADING POLICY
-ASSESSMENT METHODS:
AssignmentGuidelinesWeight
Class tests 30
Midterm 30
Final 30
Class participation 10

-ASSESSMENT CRITERIA:
AWork of this quality directly addresses the question or problem raised and provides a coherent argument displaying an extensive knowledge of relevant information or content. This type of work demonstrates the ability to critically evaluate concepts and theory and has an element of novelty and originality. There is clear evidence of a significant amount of reading beyond that required for the course
BThis is highly competent level of performance and directly addresses the question or problem raised.There is a demonstration of some ability to critically evaluatetheory and concepts and relate them to practice. Discussions reflect the student’s own arguments and are not simply a repetition of standard lecture andreference material. The work does not suffer from any major errors or omissions and provides evidence of reading beyond the required assignments.
CThis is an acceptable level of performance and provides answers that are clear but limited, reflecting the information offered in the lectures and reference readings.
DThis level of performances demonstrates that the student lacks a coherent grasp of the material.Important information is omitted and irrelevant points included.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 issues raised in the question. Most of the material in the answer is irrelevant.

-ATTENDANCE REQUIREMENTS:
ATTENDANCE REQUIREMENTS AND EXAMINATION POLICY



Attendance is mandatory. The class approach is very practical, with hands-on learning. 



You cannot make-up a major exam (midterm or final) without the permission of the Dean’s Office. The Dean’s Office will grant such permission only when the absence was caused by a serious impediment, such as a documented illness, hospitalization or death in the immediate family (in which you must attend the funeral) or other situations of similar gravity.



Absences due to other meaningful conflicts, such as job interviews, family celebrations, travel difficulties, student misunderstandings or personal convenience, will not be excused.
Students who will be absent from a major exam must notify the Dean’s Office prior to that exam.



Absences from class due to the observance of a religious holiday will normally be excused. Individual students who will have to miss class to observe a religious holiday should notify the instructor by the end of the Add/Drop period to make prior arrangements for making up any work that will be missed. 
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

Class contents

Homework

1

Intro  - Prof presentation  Course  goal and requirements.

Program of classes, general rules in class.

File systems, file and folder management. Folder management. Networks and protocols. Network storage of data. Data storage, local, intranet, extranet. Access to data at different locations.

Cloud computing, the new paradigma. Storing and sharing "in the cloud".  Working  on the same document at the same time from across the world. 

Cloud computing simple applications: class roster on Google Drive, shared compilation.

Google  spreadsheet common user info practice

2

Computers architecture and technology

Operating systems, file systems, types of software (OS, middleware, application software).

Personal productivity SW main alternatives:  Microsoft Office, Apache Open Office, Google Drive suite.  Simple Integration of documents

Software tools: compression of files , basic image processing.

Class test sw tools

3

MS Excel 1 – Worksheet, multiple spreadsheets, formatting cells, formulas and functions Absolute and relative references, named lists, drop down menu

4 MS Excel 2 –  Tables, Charts

Class test Excel

5

Pivot Tables. Charts. Multiple data series, enhanced charts.

 

6

Advanced Excel, what-if analysis.

Class test on Excel

7

Recap and Midterm week

 Midterm Test on MS Excel

8

MS Word. Professional document formatting. How to include text and pictures from external sources. Document sections and shortcuts. How to use Microsoft help web site and tutorial courses.  MS Word tabs and command groups

 

9

MS Word 2 : Building blocks and Style/Theme. Automate production table of contents, customized cover page, tables, document review, comments, header and footer, footnotes. Excel charts and table in Word

 Class test Word

10

MS Word 3: Master and subdocuments. Tracking changes, merging documents. Inserting references and tables.

Class Test Word

11

Presentation tools: Powerpoint, using a template, rules for presentations. Slide show design and principles. Video slide shows. Other presentation tools: Prezi, Lucidpress, multimedia documents and copyright issues.

Powerpoint test

12

Internet as a resource. Wee test. Document integration: merging Word, Excel, PowerPoint

Multimedia doc test

13

Recap week

Data presentation test

14

Final  week: recap, final exam rehearsal

 Final test rehearsal