Course Syllabus – Fall 2015

Office Hours: Monday 10:00-12:00

E-mail: eridalice@unyt.edu.al

Course Description

 

This course provides a basic understanding of the technical and management aspects of the basic Computer’s hardware and software with an emphasis on Microsoft Office 2010. This course will enable students to tap the full features and functionality of the Microsoft Office 2010 system, resulting in increased academic and job performance, individual differentiation and personal confidence.

 

Course Objectives

The objective of this course is to provide a basic understanding and usage of common computer applications following Microsoft Standards. You will learn basic concepts about computer’s hardware and software. Course material on document processing will be presented using Microsoft Office 2010. The course will offer basic understanding and use of computer-based communication means.

 

At the end of the course students will be able to:

Understand basic concepts of computer’s hardware and software

Understand and use Microsoft Office (Word, Excel, Access, Power point, Outlook)

 

Required Readings, Text

 

  • MOS 2010 Study Guide for Microsoft® Word, Excel®, Power Point, Outlook by Joan Lambert & Joyce Cox.

 

  • Microsoft Office 2010 Digital Classroom: Published by Wiley Publishing, Inc., Indianapolis, Indiana.

 

  • Go! with Basic Computer Concepts Getting Started, First Edition, Shelley Gaskin, Robert L. Ferrett. Pearson Prentice Hall, 2011 (ISBN: 978-0-13-509901-8). (only specific sections of the book will be required for selected topics)

 

Content of the Course

 

MS Office Word Core MS OFFICE WORD CORE
  • Introduction to Computers
  • Sharing and Maintaining Documents
  • Formatting Content
  • Applying Page Layout and Reusable Content
  • Including Illustrations and Graphics in a Document
  • Proofreading documents
  • Applying References and Hyperlinks
  • Performing Mail Merge Operations
MS Office Excel Core MS OFFICE EXCEL CORE
  • Managing the Worksheet Environment
  • Creating Cell Data
  • Formatting Cells and Worksheets
  • Managing Worksheets and Workbooks
  • Applying Formulas and Functions
  • Presenting Data Visually
  • Sharing worksheet data with other users
  • Analyzing and Organizing Data
MS Office Power Point 2010 MS OFFICE POWER POINT
  • Managing the PowerPoint environment
  • Creating a Slide Presentation
  • Working with graphical and multimedia elements
  • Creating charts and tables
  • Applying transitions and animations
  • Collaborating on a presentation
  • Preparing a presentation for delivery
  • Delivering a presentation
MS OfficeOutlook 2010 MS OFFICE OUTLOOK
 

  • Managing the Outlook Environment
  • Creating and Formatting Item Content

 

 

Course Requirements : Students are required to attend lectures and labs. Lecture handouts and lab notes will be available before commencement of the class. Students are expected to participate in class discussions. In the event of illness or emergency, contact your instructor IN ADVANCE to determine whether special arrangements are possible.

Participation: Participation extends beyond mere attendance. You may miss up to two classes without penalty. Each absence beyond the first two will cost you points off of your participation grade. The only exceptions to this rule are severe illness (doctor’s note required) and UNYT approved trips/activities. Appropriate documentation for absences beyond the first two is necessary and is to be provided on the class day directly before or after the one you miss.

 Exams: Two examinations will be taken one midterm and one final. Test format may combine a mixture of Definitions, Blanks, and short answers, two or three Essay questions covering all readings, lecture, and hand-out and class discussion content. No Student may miss a scheduled exam without receiving permission before the administration of the exam. Make-up exams might be significantly different from the regular tests, and will be administered at a time of instructor own convenience.

Reading assignments: You will be required to read all the handouts, slides, and other relevant materials that are posted under the course website https://sites.google.com/site/unytcomputerapplications/. Each week, you will be notified in class about specific materials to read and/or assignments to prepare for the week. The reading assignments are selected to give you adequate understanding of the course material.

Assignments: Homework assignments will usually be based on the chapters/material posted on the website, including the due dates. Assignments must be submitted as specified to be considered on-time. Late assignments will not be accepted except under dire circumstances the student has presented to instructor prior to assignment due-date and has received positive reply regarding any late submissions.

Make-up policy Midterm/Final exam: Only students who miss an exam for university-approved and verifiable reasons will be allowed to take a make-up exam. Even then, except in the most extreme circumstances, no student may miss a scheduled exam without receiving permission before the administration of the exam. Make-up exams might be significantly different in format from the regular tests, and will be administered at a time of instructor’s convenience.

 

General Requirements: Late assignments and absence from tests will not be tolerated.  In the event of illness or emergency, contact your instructor IN ADVANCE to determine whether special arrangements are possible. The University’s rules on academic dishonesty (e.g. cheating, plagiarism, submitting false information) will be strictly enforced. Please familiarize yourself with the STUDENT HONOUR CODE, or ask your instructor for clarification.

Grading Policy

 

 Participation and Lab Exercises 10%
Assignments 20%
Midterm 30%
Final 40%

 

BRITISH SYSTEM AMERICAN SYSTEM
Grade

Designation

Percentage (%) Generic Assessment Criteria Letter Grade

& %

Generally Accepted Meaning
Distinction  95-100 The work examined is exemplary and provides clear evidence of a complete grasp of the knowledge, understanding and skills appropriate to the Level of the qualification. There is also ample excellent evidence showing that all the learning outcomes and responsibilities appropriate to that Level are fully satisfied.  

 

 

A+  (100 +)

Outstanding Work

 

 

 Distinction 85-94 The work examined is outstanding and demonstrates comprehensive knowledge, understanding and skills appropriate to the Level of the qualification. There is also excellent evidence showing that all the learning outcomes and responsibilities appropriate to that Level are fully satisfied.  A  (96-100)
 Distinction 80-84 The work examined is excellent and is evidence of comprehensive knowledge, understanding and skills appropriate to the Level of the qualification. There is also excellent evidence showing that all the learning outcomes and responsibilities appropriate to that Level are satisfied.  A-  (90-95)
Merit  75-79 The work examined is very good and is evidence of the knowledge, understanding and skills appropriate to the Level of the qualification. There is also very good evidence showing that all the learning outcomes and responsibilities appropriate to the Level are satisfied. B+  (87-89) Good work, distinctly above average

 

 Merit  70-74 The work examined is good and is evidence of the knowledge, understanding and skills appropriate to the Level of the qualification. There is also good evidence showing that all the learning outcomes and responsibilities appropriate to that Level are satisfied.  B  (83-86)
 Merit  65-69 The work examined is sound and is evidence of the knowledge, understanding and skills appropriate to the Level of the qualification. There is also sound evidence showing that all the learning outcomes and responsibilities appropriate to that Level are satisfied.  B-  (80-82)  Acceptable work

 

 Pass 60-64 The work examined is sound but provides limited evidence of the knowledge, understanding and skills appropriate to the Level of the qualification. There is also sound but limited evidence showing that all the learning outcomes and responsibilities to that Level are satisfied.  C + (77-79)
 Pass  55-59 The work examined is acceptable but provides significantly restricted evidence of the knowledge, understanding and skills appropriate to the Level of the qualification. There is also acceptable but significantly restricted evidence showing that all the learning outcomes and responsibilities appropriate to that Level are satisfied.  C  (73-76)
 Pass  50-54 The work examined is acceptable but provides barely sufficient evidence of the knowledge, understanding and skills appropriate to the Level of the qualification. There is also acceptable but barely sufficient evidence showing that all the learning outcomes and responsibilities appropriate to that Level are satisfied. C –  (70-72)  Work that is significantly below average

 

 Fail  0-49 Work that is significantly below average and does not meet minimum standards for passing a course. D/F (0-69) Work that does not meet minimum standards for passing  the course

 

Learning Difficulties: If you feel that you have encountered special learning difficulties or serious problems that interfere with your studies, please make an appointment with UNYT Counseling Center, Dr. E Cenko (enilacenko@unyt.edu.al) and/or the Academic Support Center, Dr. A Canollari (albanacanollari@unyt.edu.al).  For more information, please contact me and or your academic advisor.

 

Date: October 10, 2014                                                                    Prepared by:     Erida Lice