Personal Accounting Spreadsheet Template by rmf12915


More Info
									                              COURSE SYLLABUS
                         ACC-1106 Accounting Spreadsheets

Instructor:                  Daniel G. Jenkins
Office location:             A130
                             Albany Technical College
                             1704 South Slappey Blvd
                             Albany, Ga. 31701
E-mail address     
Office phone number:         229 430-3519
Office hours:                M-R 7:15-8:00, R 11:00-11:50, M & W 12:00-12:50
                             & 4:00-5:30 & 7:10-7:40, T & R 3:00-4:30
Textbook:                       Benchmark Series Specialist and Expert Excel
                                2003, EMCParadigm, Rutkosky, Flynn. ISBN 0-

Course Number and Name:          ACC 106 – Accounting Spreadsheet Fundamentals
Program of Study:                Accounting
Credit Hours:                    3 Class Hours: 1       Lab Hours: 4
Prerequisite:                    SCT 100


Albany Technical College, a public postsecondary institution of the Georgia
Department of Technical and Adult Education, provides technical education and
training to promote regional economic development. To accomplish this purpose, the
college offers a variety of educational opportunities including traditional and distance
learning delivery methods. Albany Tech strives to:

      Provide quality competency-based associate degree, diploma, and technical
       certificates of credit programs that prepare students for employment in
       business, technical sciences, allied health, personal services, and industry.
      Provide basic adult literacy programs to help adults improve life skills and
       prepare for continued education and training.
      Contribute to the technological advancement of area businesses and industry
       through workforce education and training.
      Offer life-long learning opportunities for the advancement of skills,
       knowledge, and personal growth.

COURSE DESCRIPTION: This course provides instruction in the use of electronic
spreadsheet software packages for program-related spreadsheet applications. Topics
include: creation of spreadsheet; editing and deleting entries; introduction to
macros; computations through the use of formula and/or logic functions; and
program-related spreadsheet applications. Laboratory work includes theoretical and
technical application.

Rev. 10/2/2006
Spreadsheet Fundamentals
Data Entry/Modification
Computation Using Functions/Formulas
Charts and Graphs

COURSE OBJECTIVES: After completing this course, the student will be able to
complete the following objectives with at least 70 percent accuracy:

   1. Define electronic spreadsheet
   2. Define the problem to be solved or the goal of the spreadsheet.
   3. Define the formulas, values, and variables needed to produce the desired
   4. Define the desired output to be produced as a result of the model.
   5. Manually verify or test computations to be performed by the model.
   6. Demonstrate proficiency in entering text, labels, formulas, and values into
       designated cells.
   7. Edit data recorded in the spreadsheet and make any necessary revisions.
   8. Demonstrate proficiency in making adjustments to display formats using the
       format options available.
   9. Produce a hard copy of the model utilizing specified print options.
   10. Store a copy of the mode on a disk.
   11. List and compare popular spreadsheet software packages.
   12. Define terms, commands, and special features of data entry using
       spreadsheet software.
   13. Interpret the options and spreadsheet format displayed on the screen.
   14. Demonstrate proficiency in moving to different parts of the screen using
       special keys and function keys.
   15. Load the spreadsheet software program.
   16. Select the template or model for data entry.
   17. Demonstrate proficiency in entering text, formulas, and values in specific
   18.         Direct the software to store the data in working storage.
   19. Demonstrate proficiency in locating errors in previously entered data and
       correct these errors through add, change, and delete functions.
   20. Demonstrate proficiency in using special editing features when modifying
       complex cell content.
   21. Use commands such as COPY, MOVE, INSERT, DELETE, and ERASE to
       rearrange data in the model.
   22. List and explain the computational functions available in the spreadsheet
   23. Demonstrate proficiency in the basic mathematical operations such as
       addition, subtraction, multiplication, division, and exponents.
   24. List and describe the characteristics of potential spreadsheet applications.
   25. Identify situations which lend themselves to spreadsheet applications.
   26. Use and evaluate spreadsheet application for depreciation, perpetual
       inventory, financial statements and analysis, financial projections, and office
   27. Define macro.
   28. Demonstrate proficiency in creating and executing macros.
   29. Demonstrate proficiency in incorporating word processing and/or database
       files within spreadsheet files.

Rev. 10/2/2006

This course may be presented utilizing traditional and distance learning delivery
methods. For web-enhanced, hybrid, tele-tech, or online courses, students are
expected to access their internet-based course site regularly to check for
announcements, additional coursework or assignments, and other important

This course is a hybrid course. Hybrid courses are taught partially via the Internet
and partially via the classroom. A Hybrid course does not meet in a classroom for
every contact hour described in the course catalog, and includes assignments that
are to be completed outside of the classroom, where students complete course-
related activities and may use the Internet to complete/submit assignments, take
tests, review content, do research, and participate in discussion groups. Internet-
based content will include the Syllabus, assignment schedule, instructor contact
information, textbook and required reading information, and Internet-based
supplemental content or research links.


Students enrolled in this hybrid course are expected to access their on-line course
site regularly to check for announcements, additional coursework assignments, and
other important information. Assignments are to be submitted in accordance with
the Projected Learning Schedule, which is an integral part of this Syllabus. If the
student fails to submit an assignment when due or misses an exam and does not
contact the instructor in a timely manner (either in person, or by e-mail, fax, or
telephone), a grade of zero may be issued for the assignment or exam.            In
addition, students are required to respond to e-mail initiated by the
instructor within 48 hours of receipt.

Students are expected to be punctual and attend all regularly scheduled classes.
Class attendance is calculated from the first officially scheduled class meeting
through the last scheduled meeting. Students may not miss more than 10% of the
scheduled class time. Students may not miss more than five (5) instructional
hours of this course. Failure to comply with these requirements may result
in the student being dropped from the course. The student is encouraged to
Review the attendance and drop policies as outlined in the Albany Technical
College Student Handbook.

GRADE CALCULATION: Required competencies will be evaluated through the use
of written exams and completed lab assignments. The student’s final grade will be
calculated as follows:
               Chapter Challenges                     30% of final grade
               Chapter Test                           40% of final grade
               Final Exam                             30% of final grade

Makeup Tests: Makeup tests will be given at the discretion of the instructor. One
makeup test date for missed tests will be scheduled approximately two weeks before
the end of the quarter (usually at 3:00 p.m.). ALL makeup tests must be taken on
that date. A grade of “0” will be assigned for tests not made up.

Rev. 10/2/2006
WORK ETHICS: A portion of the curriculum of on-site courses is devoted to the
development of positive work ethics among students. On-line course students are
encouraged to access the Work Ethics sections in the Course Documents area of their
course. The program is designed to encourage good work habits in the areas of
quality of work, ability to follow instructions, productivity, dependability, honesty,
reliability, attendance and punctuality, attitude, integrity, enthusiasm, interpersonal
skills, and initiative.

WORK ETHICS EVALUATION: On-site students will receive a formal report at mid-
term and at the end of the quarter. The mid-term report is a progress report, but
the end-of-quarter report constitutes the final grade. The quarterly work ethics
grade will not affect the academic grade. Points are assigned to evaluate each of the
ten work ethics traits as follows:

       Exceeds Expectations                3   points
       Meets Expectations                  2   points
       Needs Improvement                   1   points
       Unacceptable                        0   points

REFERENCES: The instructor will provide additional resource material as may be
necessary. This material will be posted on the on-line course site in the Course
Documents section.

For extra practice of assistance, see you instructor for times when the lab is
available. Free tutorial services are available through the special needs coordinator.
Students who feel that they will benefit from tutoring should notify the instructor so
that they can be referred for tutoring.

The Georgia Department of Technical and Adult Education (DTAE) has developed
curricula standards with direct involvement of business and industry. These
standards will serve as the industry-validated specifications for each occupational

These standards allow Georgia's 33 technical colleges to offer their business partners
this guarantee:

"If one of our graduates, who was educated under a standard program, and his or
her employer agree that the employee is deficient in one or more competencies as
defined in the standards, Albany Technical College will retrain that employee at no
instructional cost to the employee or employer.

This guarantee applies to all graduates of ATC who are employed in the field of their
training. It is in effect for a period of two years after graduation.
Spring 2006
Week 1                  Read getting started pages GS1-GS12
                        Read using windows xp pages w1-w28

Rev. 10/2/2006
Week 2           Read Chapter 1 and complete exercises
                 pages S7-S31; Complete and Turn
                 Assessments 1-3

Week 3           Read Chapter 2 and complete exercises
                 pages S33-S61; Complete and Turn in
                 Assessments 1-6

Week 4           Read Chapter 3 and complete exercises
                 pages S69-S91; Complete and Turn in
                 Assessments 1-6

Week 5           Read Chapter 4 and complete exercises
                 pages S97-S130; Complete and Turn in
                 Assessments 1-8

Week 6           Read Chapter 5 and complete exercises
                 pages S145-S171; Complete and Turn in
                 Assessments 1-6

Week 7           Read Chapter 6 and complete exercises
                 pages S179-S208; Complete and Turn in
                 Assessments 1-6

Week 8           Read Chapter 7 and complete exercises
                 pages S213-S236; Complete and Turn in
                 Assessments 1-6

Week 9           Read Chapter 8 and complete exercises
                 pages S241-S272; Complete and Turn in
                 Assessments 1-6

Week 10          Final Online and any uncompleted work

Rev. 10/2/2006

To top