University of Cebu
Main Campus

SYLLABUS IN SPREADSHEET

Instructor: Mr. Jonathan O. Etcuban
College: Information and Computer Science
Email: sir_etcuban@yahoo.com
Website:  www.geocities.com/sir_etcuban

Credit Hours: 3 Hrs./Wk. 
Lec: 2 Hrs./Wk     
Lab: 1 Hr./Wk.

I. COURSE DESCRIPTION 

This subject is about a brief introduction of computers and the use of electronic spreadsheet.  It aims to develop knowledge and skills in the use of different software for different tasks.  Hands-on drills are provided to students to apply the principles and commands for actual practice.  Students are taught with theories before working on their hands-on drills to obtain the specific skills out of this course.

II. RECOMMENDED BACKGROUND 

Prerequisite: 
KB 10 – Keyboarding

Required Course Materials: 

• Innovate (A Mentor’s Guide to ICT Foundation Competencies)
• Three 3.5” IBM format, high Density diskettes. 
• Access to a computer running MS-Windows XP and Microsoft Office 97 or higher

Method of Instruction: 

Lecture notes, homework, and assignments will include reading assignments as well as Hands-on lab assignments. Students will be monitored for activity via online communication methods, such as, on-line discussion groups, email, and chat rooms. 

Attendance: 

Attendance is necessary to pass this course. Attendance will be monitored every meeting. “A student absences equivalent to 20% of instruction in a regular semester may be dropped by the instructor.” Please consult the Student’s Manual for details. Students with excessive absences will be automatically dropped from the course with notification. You will be required to keep pace with homework and other assignments. Email me regularly and keep me posted on your progress with the course.  

Homework and Computer Assignments: 

Homework and computer assignments will be sent to me as attachments via email or hard copy. You must keep pace with the course calendar of events. You have one week from the due date to complete homework or lab assignments. Assignments will not be accepted after the one-week grace period. Late assignments will be deducted 1 point for every calendar day late. This course requires extensive hands-on computer assignments. 

Exams: 

Exams and quizzes will be administered in person. Please refer to the calendar of course events for more information on exam dates. 

Course Expectations: 

You will be required to view the calendar of course events every week for assignments. Please be sure to follow date and time schedules. You will be asked to return both written and lab assignments as attachments via email. You are required to read each chapter before you attempt to take the chapter quiz. You will be quizzed after each chapter. If you diligently follow the course guidelines and complete all the required assignments, you will be adequately prepared to take the course exams. The calendar of events is subjected to change, make sure you refer to the calendar every week. 

Final Grade: 

Each student’s grade will be calculated as follows: 

Class Standing   50% 
Major Exams     35%
Projects            15%

III. COURSE CONTENT 

1.  Computer Concepts
2.  Software Concepts
3.  Functions, Features and Applications of a Spreadsheet software
4.  Cell, cell address, user interface, console, pointer, etc.
5.  Parts and Functions of MS Excel Screen Layout
6.  Types of Data
7.  Hierarchy of Mathematical Operations
8.  Standard and Formatting Toolbars
9.  Functions
10.  Conditional Formatting
11.  Charts

IV. LEARNING OUTCOMES 

At the completion of the course, the student will be able to: 

1.  to discuss concepts related to the effective use of computers
2.  to identify and understand the concepts related to Electronic Spreadsheet
3.  to discuss the functions and applications of Electronic Spreadsheet
4.  to create a simple spreadsheet system using Microsoft Excel