|
Accounting Diploma
|
General Education Core Courses
|
|
Introduction to Accounting as an Information System
|
4
|
|
Occupational Courses
|
|
The Accounting Cycle
الدورة المحاسبية
|
12
|
|
Merchandising Operations
عمليات البيع والشراء
|
4
|
|
Financial Statements
القوائم المالية
|
4
|
|
Professional Occupational Courses
|
|
Banking systems
أنظمة البنوك المحاسبية
|
4
|
|
Introduction to E- Commerce
التجارة الكترونية
|
4
|
|
Accounting with Computer
|
Win XP Troubleshooting & Internet
|
17
|
|
MS Excel
|
36
|
|
MS Access
|
36
|
|
Personal skills
|
|
Time management
|
4
|
|
How to write a CV
|
4
|
|
Total Hours
|
129
|
STUDENT COURSE SYLLABUS
Course Title:
Accounting Diploma
Course Duration:
136 Hours.
Session:
4 hours.
Accounting Diploma include Four courses to improve Performance of
student
I:
Accounting
Course Description:
Accounting as an
information system; basic accounting concepts; the double entry
accounting system; the accounting cycle; merchandising operations;
worksheet for a merchandising business: classified financial
statement; closing entries; data processing.
Course Goals:
1. Understand the accounting process and the basic accounting concepts.
2. Be acquainted with the double entry accounting system.
3. Demonstrate
accounting
procedures used
in
accounting
systems
for
merchandizing business.
merchandising
4. Know how to prepare the worksheet and the financial
statements for a
business.
.5. Be
familiar vlith the data processing systems.
"Session: In this course one session equals
4 hours.
Course Outline:
|
Session* No.
|
Title/subtitle
|
Assignment
|
|
1
|
Accounting as
an Information System
|
|
|
|
- Introduction to
financial accounting
- Accounting
principles
- Fields of
accounting activity
- Accounting
concepts
- The balance sheet
and income statement
|
Solve
exercises as assigned by
The instructor
-
Study the
demonstration
problem
|
|
2
|
The Double Entry Accounting System
|
|
|
|
-
The system of debits, credits
- The general
ledger and the trial balance - Errors in transaction
analysis
- Discussion of assignment
|
- Solve
exercises as assigned by
the instructor
- Answer
the self-test questions
|
|
3
|
The Accounting Cycle
|
|
|
|
-
Source documents
- Journals
- Posting
- Adjustments
|
- Study the
demonstration
problem
- Solve the
practical exercise
|
|
4
|
Preparing Financial Statements
|
|
|
|
-The
Accounting cycle concluded
- Preparing a
work sheet
- Completion
of accounting cycle
- Summary of
accounting cycle
- Closing and reversing entries
|
-
Study the key points in the
chapter objectives
- Answer
the self-test questions
and practical exercise
- Solve a
business decision
problem
|
|
5
|
Merchandising Operations
|
|
|
|
- Recording purchases, returns, and
allowances
- Recording sales, returns, and allowances
|
-
Study the demonstration
problem
- Solve business decision problem
|
|
6
|
Quiz
|
|
|
|
|
|
|
7
|
Financial Statements
|
|
|
|
- Worksheet
for a merchandising business
- Classified
financial statements
- Adjusting
entries
- Closing
entries
|
- Study the
key points in the
chapter objectives
-
Answer the self-test questions and practical
exercise
- Solve a business decision
,
problem
|
|
8-9
|
Data
Processing Manual and Electronic Systems
|
|
|
|
- Control accounts
and subsidiary ledgers
- Special journals
- Sales journals
- Cash receipts
journal
- Invoice register
(purchase journal)
- Cash
disbursements journal
- Use of the
general journal
- The voucher
system
|
- Study the
key points in [he
chapter objectives
- Answer
the self-test questions
and practical exercise
- Solve a
business decision
problem
|
|
10
|
Banking
systems
- Over
view about banking systems
- Cheque
Roles
|
Solve
exercises as assigned by
the instructor
|
|
|
|
|
|
11
|
Introduction to E- Commerce
|
Solve
exercises as assigned by
the instructor
|
II: MS Windows
Course Description:
Learn about the computer construction and
associated peripherals; learn the basic features of
Windows XP
work with the, desktop tools, files, folders and printers;
work with Windows
applications; use the expanded multimedia
capabilities; use the network capabilities; use the
Internet.
Course Goals:
1. Learn computer
construction and associated hardware peripherals.
2.. Exploit the
work environment of Windows XP
4.
Learn the expanded multimedia capabilities'.
5. Be familiar
with ,network capabilities of Windows XP
|
Session* No.
|
Title/subtitle
|
Assignment
|
|
1
|
Introduction &
Windows 9X
Architectural Elements
|
|
|
|
- Overview of computer construction
and layout.
.
- Hardware peripherals.
-
Understanding keyboard layout and
functions.
- Using
the mouse.
- Overview
of the Windows XP Desktop
- Understanding Explorer
Windows 9X
Architectural Elements
- Operating System
- File system
- Device drivers
-use file
management
- Multitasking and multithreading
- System robustness
- Resources support
|
lab practice
|
|
2
|
Highlight the Troubleshooting Features
|
|
|
|
-
Understanding the setup process
-
Understanding the hardware detection
- Using
safe recovery
- Tips
for specific setup problems
- Tips for specific startup problems
|
lab practice
|
|
3
|
Network
Capabilities
|
|
|
|
-
Understanding resources sharing
- Dial-Up
Networking connections.
-
Understanding modems
-
Understanding modem standards
-
understanding Communication in Windows XP
- Optimizing
communications
- Setting up a
network printer
-
Controlling a printer's queue
|
lab practice
|
|
4
|
Internet Connection
|
|
|
|
-
Overview of the Internet
- Overview of
some Internet utilities
-Final Exam
|
lab practice
|
III: MS Excel
Course Description
Introduction
to spreadsheets, organization of worksheets; types of
worksheet entries; arithmetic,
string, and logical formulas and functions; manipulation of files;
temporary exit to the operating 'system; copying data using
relative, absolute and mixed addresses; moving data within the
worksheet; changing the worksheet appearance; printing the worksheet
using advanced printing options; creating and printing graphs.
Course Goals:
1- Know the
features and capabilities of spreadsheets.
2- Recognize
different types
of data entries.
3- Learn
techniques
fin handling worksheets.
4-Be
acquainted with the functions and formulas offered by the
spreadsheet.
5-Be
acquainted with graphical data representation.
|
Session* No.
|
Title/subtitle
|
Assignment
|
|
1
|
Basic
Skills& File Management
|
|
|
|
Basic
Skills
- Introduction to spreadsheets
-
Starting and quitting the package
- Controlling spreadsheet windows
- Using dialog boxes and menus
File Management
- Create a new worksheet
- Save a worksheet
- Activate an existing worksheet
- Deactivate a worksheet
-
Rename a worksheet
- Delete a worksheet
|
- In lab practice on using
spreadsheet windows
-
In lab practice on file management
|
|
2
|
Working With Cells& With Formulas
|
|
|
|
Working With Cells
-
Using toolbars
-
Entering and
editing data
- Working with
ranges
- Copying,
moving and clearing cells
Working
With Formulas
-
Inserting and deleting cells, rows and
columns -
Writing formulas.
|
.
In – Lab
practice on working
with cells
In-lab
practice on working
with
formulas
|
|
3
|
Formatting
Cells& Formatting Cells (Cont'd)
|
|
|
|
Formatting
Cells
-
Formatting numbers, dates and times
-
Working with fonts
-
Formatting other cell attributes
Formatting
Cells (Cont'd)
,
-
Working with
columns and rows
-
Using colors in spreadsheets
-
Working with cell formats
|
In-lab practice on formatting cells
In-lab practice on working with rows
and columns
|
|
4
|
Enhancing
Cell Appearance & Sorting
|
|
|
|
Enhancing
Cell Appearance
-
Changing the spreadsheet views
-
Spell checking the worksheet
-
Adding comments with text boxes
Sorting
- Direct cell
manipulation
-
Column sorting
-
Multiple column
sorting
|
In-lab practice on enhancing cell
appearance
In-lab practice on sorting
|
|
5-6
|
Built-in
Functions
|
|
|
|
Built-in
Functions
- What are
built-in functions?
- Entering
functions
- Statistical and arithmetic functions
|
In-lab practice on using built-in
functions
|
|
7
|
Working With Charts
|
|
|
|
- Creating
charts
- Working with
chart types
|
In-lab
practice on working
with charts
|
|
8
|
Enhancing
Charts
|
|
|
|
- Adding
objects to a chart
- Data series
editing
- Working with
3-D charts
- Adding graphic objects to spreadsheets
|
In-lab
practice on enhancing charts
|
|
9
|
Review
and Final Exam
|
|
IV: MS
Access
Course Description:
Use of a database software application to
handle database files and manipulate data; sorting
database files; handling index files;
overview of the special features of the software package; brief
theoretical overview of database management; relational systems;
data independence; Structured Query Language (SQL) and data
manipulation; indexing and hashing techniques.
Course Goals:
1. Handle different types of files through
l selected database software application.
2. Be familiar with practical data
manipulation.
3. Recognize the special features of the
selected software.
4. Understand the database management
system.
5. Know the relational systems.
6. Be acquainted with the SQL language.
|
Session* No.
|
Title/subtitle
|
Assignment
|
|
1
|
Basic Concepts &
Using Your Database Package
|
|
|
|
Basic Concepts
-
Data versus
information
-
What is a database
- Database
classification
-
Data types
- Data
independence
-
Relational systems
- The database
management system
-
The relational model
-
Optimization
-
The SQL language
Using Your
Database Package
-
Starting your database package
- Navigating
through different menus of your
package
-
Opening a database
file
-
Orientation to the
database window of your
package
-
Orientation
to tables
-
Orientation to queries
-
Orientation to forms
-
Orientation to
reports
|
In-lab practice
on using the main menu with keyboard and mouse
|
|
2
|
Table Basics &
Query
Basics
|
|
|
|
Table Basics
- Opening arid
examining tables
-
Navigating in a
table
-
Finding records in
a table
-
Designing tables
and saving designs
- Creating
different types of fields
- Setting a primary
key
- Adding records to
a table
-
Modifying table
design
- Inserting.
deleting and moving fields
-
Adding values to a modified table
-
Editing and
deleting records
-
Copying values
and records
Query Basics
- Starting and
running queries
- Query design
- Creating queries
- Selecting queries
- Adding and
rearranging fields in a query
- Sorting records
in a query
-
Setting a criterion
for a query
- Combining
criteria with "and" and "or" conditions
- Creating
calculated fields
|
.
In-lab
practice on working with Tables
In-lab
practice on working with queries
|
|
3
|
Form Basics
& Report Basics
|
|
|
|
Form Basics
-
Viewing data in
forms
- Form types
and data sources
- Form design
- Selecting,
deleting and moving form elements
- Rearranging
form elements
-
Previewing and
printing forms
-
Sorting and filtering records within a form
- Editing and
adding records through a form
Report
Basics
-
Understanding
report design
- Specifying fields
and sorting order in a report
-
Controlling the
report layout
-
Modifying the report design
|
In-lab
practice on using Forms
In-lab
practice on using reports
|
|
4
|
Advanced
Table Design& Advanced Query Design
|
|
|
|
Advanced
Table Design
- Examining
field properties
. -
Modifying the field form 1t
-
Setting default values
-
Setting validation rules
- Using memo
fields
- Using
counter data types as a primary key field
-
Changing a primary
key
-
Testing duplicate values in a primary key
field
Advanced
Query Design
:- Creating
and running select queries
-
Creating calculated fields
- Deleting
fields from a query
-
Creating single
parameter queries
-
Creating multiple
parameter queries
-
Creating action
queries
-
Creating update
queries
-
Creating delete
queries
-
Creating multiple
table queries
-
Joining tables
-
Creating make-table
queries
|
In-lab practice on advanced table
tasks
In-lab practice on advanced query
tasks
|
|
5
|
Advanced Form
design
|
|
|
|
-
Editing memo fields
-
Enhancing memo
fields control properties
-
Adding text box
bound controls
-
Modifying a bound
control format property
- Adding calculated
rectangle and list box controls
-
Creating forms that contain
subforms
|
In-lab
practice on advanced form tasks
|
|
6
|
Using Macros With
forms
|
|
|
|
-
Examining a macro
design
- Creating and
running a macro
- Using command
button controls
-
Synchronizing forms
-
Controlling form
window placement
|
In-lab
practice on using macros
|
|
7
|
Advanced
Report Design
|
|
|
|
-
Adding Controls to
a report
-
Performing
horizontal and vertical calculations in a report
-
Changing a report's
page layout
- Creating mailing
labels reports
-
Changing a report's
record source
|
In-lab
practice on advanced report tasks
|
|
8
|
Review
and Final Exam
|
|
|
|
Soft Skills
|
|
|
1
|
Time management
|
|
|
2
|
How to write a CV
|
|
Assessment of
Students:
Frequency*: Five
assessments as follows:
The first
assessment is scheduled for session 6.
The second
assessment is scheduled for session 10.
The third
assessment is scheduled for session 14.
The fourth
assessment is scheduled for session 22.
The Fifth
assessment is scheduled for session 30.
Type: Practical
and/or written
The final grade
will be the total of the following:
Points
Assessment I
(Accounting)
20
Assessment 2
(Accounting)
20
Assessment 3 (MS
Windows)
20
Assessment 4 (
MS Excel )
20
Assessment 5 (
MS Access)
20
Final grade:
100
|
