|
|
JOHN CABOT UNIVERSITY
COURSE CODE: "CS 110-3"
COURSE NAME: "Microcomputer Applications"
SEMESTER & YEAR:
Fall 2014
|
SYLLABUS
INSTRUCTOR:
Marco Scaramastra
EMAIL: [email protected]
HOURS:
TTH 3:00 PM-4:15 PM
TOTAL NO. OF CONTACT HOURS:
45
CREDITS:
PREREQUISITES:
OFFICE HOURS:
|
|
COURSE DESCRIPTION:
The course will provide students with a sound knowledge of the most commonly used office applications with a particular focus on integrating word-processing, data analysis and management, and multimedia projects’ development and presentation.
|
SUMMARY OF COURSE CONTENT:
Office productivity software: advanced features of Word Processing (MS Word), Data management (MS Excel), and Presentation software (MS PowerPoint). Integration between software packages.
|
LEARNING OUTCOMES:
1 Ability to produce professionally formatted word documents that use tables, graphic elements, and hypertextually indexed navigation.
2 Ability to produce spreadsheets that require calculations and provide dynamic outputs.
3 To build up expertise in the use of functions and statistical analysis.
4 Ability to produce hypertextual presentations by using hyperlinks and action buttons.
5 To know how to produce professional reports integrating different office applications.
|
TEXTBOOK:
|
REQUIRED RESERVED READING:
RECOMMENDED RESERVED READING:
|
GRADING POLICY
-ASSESSMENT METHODS:
Assignment | Guidelines | Weight |
Attendance and class participation | | 10% |
Class assignments | The course is very practical and students are required to complete and save on their reserved area all exercises assigned in class on a dayly basis. | 10% |
Midterm exam | The midterm exam will require students to produce a professionally formatted word document. | 20% |
Final exam | The final exam will require students to produce a purposeful excel worksheet containing data, formulas, and data analysis developed with the help of a set of instructions | 25% |
PC Project | The project will combine into a unified structure the microcomputer applications learnt during the course, namely Word, Excel, and PowerPoint. The guidelines for the computer project will be provided 3 weeks before the end of the course. The project deadline is the day of the final exam. | 35% |
-ASSESSMENT CRITERIA:
AThis level of performance demostrates professional skills in the use of computer applications and the achievement of professional ability in delivering information and providing correct data analysi BThis level of performance demostrates competent skills in the use of computer applications and the achievement of competent ability in delivering information and providing correct data analysis. CThis level of performance demostrates sufficient/acceptable skills in the use of computer applications and the achievement of a workable ability in delivering information and providing correct data analysis. DThis level of performance demostrates just sufficient skills in the use of computer applications and the achievement of a borderline ability in delivering information and providing correct data analysis. FThis level of performance demostrates insufficient skills in the use of computer applications and the failure in achieving a sufficient ability in delivering information and providing correct data analysis.
-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.
|
|
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
|
|
|
MS Word
Mastering the essentials
Basic formatting
|
|
2
|
|
|
Advanced formatting
Documents reviewing
|
Class assignment 1
|
3
|
|
|
Tables and graphical elements Desktop publishing
|
Class assignment 2
|
4
|
|
|
Tables and graphical elements Desktop publishing
|
Class assignment 3
|
5
|
|
|
MS Excel
Getting Started
|
|
6
|
|
|
Entering data into Cells
Formatting Cell
|
Class assignment 4
|
7
|
|
|
Midterm exam
|
|
8
|
|
|
Understanding and using Formulas
Using the power of Ranges
|
Class assignment 5
|
9
|
|
|
Understanding and using Functions
Creating Embedded Charts
|
Class assignment 6
|
9
|
|
|
Creating Pivot Tables and Charts
Using Database Functions
|
Class assignment 7
|
10
|
|
|
What-if analysis
|
Class assignment 8
|
11
|
|
|
What-if analysis
|
Class assignment 9
|
12
|
|
|
What-if analysis
|
Class assignment 10
|
13
|
|
|
MS PowerPoint
Preparing slides
Special effects and presentation timing.
Structuring and running a presentation
|
Project work
|
14
|
|
|
Project Q&A session
|
Project work
|
15
|
|
|
Final exam
|
|
|
|
|