PhiladelphiaUniversity

Faculty of administratitive and financial sciences

Department of Business Networking & System Management

First Semester, 2014/2015

Course Syllabus
Course code: 0371102 / Course Title: Computer applications for administrative sciences
Course prerequisite (s) and/or co requisite (s): / Course Level: 1
Credit hours: 3 / Lecture Time: 13:10 - 14
Academic Staff Specifics
E-mail Address / Office Hours / Office Number / Rank / Name
/ 32403 / Ph.D / Dr.Mahmoud Abu Arra

Course module description:

This course is started with giving the basis of database system by focusing on how the tables are created

first, then how they are linked together next. The student stores fields' names, their data types and their properties.

Theformsare used also in order to enter data to the table. This includes using buttonsalong with macros and events.

In addition the student uses various queries to enable him retrieve data from tables. Of course he uses

them with separate and linked tables.

Course module objectives:

1-Enable the student to mention the basis of database system

2-Enables student to create a table , define its fields and properties

3-Enables a student to make different maintenance operation to the table i.e. delete, update..etc.

4-Enables a student to create a form to input data to the table using form toolbox.

5-Enable students to retrieve data from tables using queries.

Course/ module components:

[1]Microsoft Access 2010 Step by Step

Authors: Joyce Cox

Publisher:Microsoft Press; 1 edition

Year of publication: (July 25, 2010)

[2]Microsoft Access 2010, Step By Step (Arabic Edition)

Authors: Joyce Cox

Publisher:Arab Scientific Publishers

Year of publication: (October 12, 2010)

In addition to the above, the students will be provided with handouts by the lecturer.

Teaching methods:

  • Lectures
  • Discussion groups
  • Tutorials
  • Problem solving
  • Homework’s
  • SmallProject.
  • Research Paper

Learning outcomes:

  • Knowledge and understanding:

The data show is used to demonstrate practical exercise in the class to enable students see how it is done to save time and make lecture effective

  • Cognitive skills (thinking and analysis):

A number of queries are given to the student in the lecture to encourage him make a brain storm. This will definitely help him understand more how to work it out. This is done by offering the idea to students then encourage them to discuss it theoretically. This of course will help them practice in an effective way .

  • Communication skills (personal and academic):

A round is done in the class by the instructor to monitor how the practical part of the course is done to make sure that it is done effectively. Problems that may appear from time to time in the lecture are solved .

  • Practical and subject specific skills (Transferable Skills):

A project is given to the student to use his mental capabilities to solve the problem. This way of

demonstrating the course was fruitful taking into account the recognized results achieved. It was

not quiet convenient because the short time the students spend in solving the problem.

Assessment instruments:

  • Short reports and/ or presentations, and/ or Short research projects
  • Quizzes.
  • Home works
  • Final examination: 50 marks

Allocation of Marks
Mark / Assessment Instruments
20 / First examination
20 / Second examination
40 / Final examination: 50 marks
20 / Reports, research, Quizzes, Home works, Projects.
100 / Total

Documentation and academic honesty

This course is given from the textbook mentioned above. It is

copyright protected. Students are encouraged to purchase this

textbook from the university bookshop.

Definition of Plagiarism

Plagiarism is the unacknowledged borrowing of another writer’s words or ideas.

How Can Students Avoid Plagiarism?

To avoid plagiarism, you must give credit whenever you use

  • another person’s idea, opinion, or theory;
  • any facts, statistics, graphs, drawings—any pieces of information—that are not common knowledge;
  • quotations of another person’s actual spoken or written words; or
  • Paraphrase of another person’s spoken or written words.

If you are in doubt about whether what you are doing is inappropriate, consult your instructor. A claim that “you didn’t know it was wrong” will not be accepted as an excuse.

Penalty for Plagiarism

The minimum penalty for an act of plagiarism is a 0 on the assignment, homework, and project. Serious cases of plagiarism may result in failure in the course as a whole, or expulsion from the university.

Course/module academic calendar:

week / Basic and support material to be covered / Homework/reports and their due dates
(1) / -creating database, creating tables, defining primary key , creating fields and entering data to the table -
(2) / Defining fields' properties and testing Data entry . Sorting data using filter
(3) / Introducing query definition and types then making calculations using numeric fields
(4) / Creating a form design using toolbox tool.Entering data to the table using the created form
(5) / Introducing relations between tables : their types and how they
are created .
(6)
First examination / Working on relations to give students a clue of how they are used and to tested.
(7) / Creating events and macrosto create a button in the form. The students solve the practical exercises made for this purpose.
(8) / Using macros with various events with and without a form in order to enable the student to try them by his own
(9) / -Introducing maintenance queries i.e. delete and update
queries and how they are used with relations
(10) / - Introducing append and make-table queries using the same database and with two databases . This is done on single tables
(11)
Second examination / - working on data maintenance of related tables manually and using delete and update queries to see their effect .
(12) / Working on Master detailed forms along with queries created
For such a purpose. This is done using manual method and the wizard menus.
(13) / Working on other kinds of queries like duplicates and
Unmatched queries.
(14) / Working on reports on single and related tables. This
effort includes working on queries created using relations
(15)
Specimen examination
(Optional) / Comprehensive review for all the topics learned in the whole semester to resolve all obstacles that may appear while working
(16)
Final Examination / Tutorial, revision and Practical Exam .

Expected workload:

On average students need to spend 2 hours of study and preparation for each 50-minute lecture/tutorial.

Attendance policy:

Absence from lectures and/or tutorials shall not exceed 15%. Students who exceed the 15% limit without a medical or emergency excuse acceptable to and approved by the Dean of the relevant college/faculty shall not be allowed to take the final examination and shall receive a mark of zero for the course. If the excuse is approved by the Dean, the student shall be considered to have withdrawn from the course.

Module references:

Books

[1] Microsoft Access 2010

Authors: Microsoft

Publisher: Microsoft

[2] Access 2010 Bible

Authors: Michael R. Groh

Publisher: Wiley; 1 edition (May 10, 2010)

Websites

/access

1