DammamCommunity College

Computer Science Department

(Computer Applications Semester 072)

Computer Application –II CA-141

Textbook Office 2003 by T OLeary and L OLeary, McGraw Hill Technology

Education, ISBN 0-07-283526-5

The student will learn the most important topics of Microsoft Office XP spreadsheet and database applications by completing hands-on assignments in Microsoft Excel and Microsoft Access.

Course Objectives

This course teaches the use of spreadsheet and database software.

Course Outcomes

Upon successful completion of this course, the student will be able to:

  • Create spreadsheets using Microsoft Excel.
  • Create databases using Microsoft Access.

Syllabus & Weekly Breakdown:

Week / CA 141 Lecture Topics
1 / Chap 1Introduction to Microsoft Excel
What is a Spreadsheet?
Row, Col, Heading, Formula and Constants
2 / Toolbars, File menus
Hands on Exercise sheet
Modifying the Worksheet
CellRange, Copy & Move Command
3 / Hands on Creating a Workbook
Formatting, Alignment, Fonts, Borders, Patterns and Shading
Hands on Exercise : Formatting a Spreadsheet
4 / Chap 2 Getting Proficiency
Employee Payroll ( Pointing, The file Handle and Comments)
Hands on Exercise : Creating a Payroll
Practice with Excel Exercise
5 / Chap 3 Spreadsheet in Decision making: what if?
Analysis of a spreadsheet
PMT Functions, FV Function, Inserting a function
Commands,
MAJOR 1
6 / Hands on Exercise : Basic Financial Functions
Relative and absolute addresses
Mixed references
Hands on Exercise : Advanced Financial Functions
Statistical Functions, IF Functions, VLOOKUP Functions
7 / Working with Large Spreadsheets:
Freezing Panes, AutoFilter commands
Hiding Rows and Columns,
Printing a large spreadsheet
MIDTERM BREAK
8 / Chap 4 : Graph and Charts:
Objectives
Charts and its types ( pie Chart, Column and Bar Charts
Creating a chart, Chart Wizard, Modifying a chart
Hands on Exercise : The Chart Wizard
Hands on Exercise : Object Linking and Embedding
9 / Chap 1: Introduction to Microsoft Access
What is a database?
Case Study : The college Bookstore
Database Windows
Fields ,Tables, Forms, Queries and Reports
10 / Filter and sorting
Pivot Tables and Pivot Charts
Looking Ahead: Relational Data base
Hands-on-Practice: Relational Database
MAJOR 2
11 / Chap 2 : Tables and Forms  Design, Properties, View and Wizard
Case Study: A student Database
Creating Tables, Primary Key, view and properties
12 / Forms: Auto Forms, Form Wizard, Modifying a Form
Chap 3: Report and Queries
Anatomy of reports, Report Wizard,
13 / Hands on Exercise : The report Wizard
Introduction to Queries, Query Window, Selection Criteria
Crosstab Queries , action Queries , Grouping Records
14 / Chap 4: Relational Databases, External Data, Charts and Switch Board
Multiple-Table Queries, Maintaining Database,
Importing spreadsheets
Hands-on Exercise : Importing and exporting Access Objects
15 / Hands-on Exercise : Total Queries and Charts
Switchboard Manager
Other Access Utilities
Review for final Exam
16 / Final Exam Period

Grade Determination

Marks
Major I exam / 15.00
Major II exam / 15.00
Final exam / 30.00
Lab
CA141 Lab exercises / 10
Activities / 5
CA141 Project / 5
Class work
Quiz / 10 / 5 during the semester
Home Work / 3
Attendance & participation / 7
Total / 100.00

Reading Assignments

You are responsible for the assigned reading as given in the following schedule. In some cases, only part of a chapter will be read on a given week. Note that we might not always cover chapters in the order presented in the book.

Lab Assignments - 20% of grade

Most people learn more by “doing” than by “listening”, thus you will learn far more about programming by hands-on lab experience than by merely reading your textbook. The lab assignments are a basic course requirement, like engineering lab work, and not at all like homework in a calculus class. You must complete most of the lab assignments in order to pass the course! Late assignments will be assessed a 50% penalty per lab meeting, which means that if you don’t submit lab work on time, I will take of half the points, and I will not accept late work after one week from the due date.NO EXCEPTIONS!

Talking with classmates about the assignments in general terms can be of value to you. Nevertheless, the work you submit must be your own! No credit will be given for assignments that are copied. Copying someone else’s assignment and modifying it to conceal that fact is a very serious offense.Cheating will not be tolerated.

Exams - 60% of your final grade

There will be two major exams during the semester and one final exam at the end of the semester. Exams may contain short answer and/or multiple choice questions.

Absences from Lectures/Labs

NO EXCUSE is acceptable except an official excuse from the Student Affairs office. If you are absent for more than 15 hours from lecture and/or lab without excuse, you will be dropped from the course and will receive a DN. Missing an entire 50-minute lecture will be considered missing one “hour”. For example, if you miss more than 15 lectures, you will get a DN. If you miss more than 5 labs, you will get a DN. If you miss more than 9 lectures and 2 labs, you will get a DN.

If you are absent for more than 25 hours from lecture and/or lab, with or without excuse, you will be dropped from the course and will receive a DN.

Absences from Exams

Don’t miss an exam. Acceptable excuses are usually limited to serious personal problems, such as hospitalization after an accident, etc. Examples of unacceptable excuses are job interviews, weddings, taking someone to the airport, or the desire to leave before the end of the exam period.

Withdrawal Policy

The last day for dropping all courses without permanent record is …………………. The last day for dropping all courses with a `W’ grade through Internet is ………………...

CA141 syllabus072.doc12/28/2018 4:07:59 PMPage: 1 of 4