|
|
JOHN CABOT UNIVERSITY
COURSE CODE: "CS 110-3"
COURSE NAME: "Computer Office Applications"
SEMESTER & YEAR:
Fall 2022
|
SYLLABUS
INSTRUCTOR:
Stefano Gazziano
EMAIL: [email protected]
HOURS:
MW 1:30 PM 2:45 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:
|
REQUIRED RESERVED READING:
RECOMMENDED RESERVED READING:
|
GRADING POLICY
-ASSESSMENT METHODS:
| Assignment | Guidelines | Weight |
| 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
|
|
|
|