BUSN 330
Business Software
Spring 2005

  
Instructor:   Gary D. Gibson  Telephone:  589 2145 Ext--2043

Office:  Room 226, Newman Hall
	 
E-Mail: gary.gibson@kctcs.edu

OFFICE HOURS:   

Monday-Wednesday-Friday  9:00 a.m. -- 10:30 a.m.
Monday-Wednesday-Friday  1:30 p.m. --  3:00 p.m.

Tuesday-Thursday 9:00 a.m. -- 10:00 a.m.
Tuesday-Thursday 1:30 p.m. --  2:30 p.m.

Semester, Days, Time, and Meeting Place:

Spring 2005 --Wednesday - 7:00 p.m. . - 9:45 p.m..

Prerequisites:

CIS 100

Textbook and Other Materials:

  Blanc, I., Vento, C., & Steele, T. (2002). Performing with Microsoft Office XP: Advanced Course . Course Technology: Boston.

Course Description:  Advanced software course for business covering the more advanced functions of word processing, spreadsheets, presentation software, and Internet use for business professionals.

Course Format:  The basic format for class will be primarily lecture, demonstration, problem solving and hands on computer exercises.  A number of computer problems and exercises will be assigned throughout the semester.  One written assignment will be assigned.

Cognitive Objectives:  The student should be able to demonstrate the following competencies:
  • Use a word processing program to create online forms
  • Use a word processing program working with Macros and visual Basic for Applications (VBA)
  • Use a word processing program to work with a Master Document, an Index, and a Table of Contents
  • Use Macros and Visual Basic for Application (VBA) with Excel.
  • How to do Formula Auditing, Data Validation, and Complex Problem Solving using Excel.
  • Be able to import data, make routing changes, use PivotCharts, PivotTables and Trend line in Excel.
  • How to creating a Pivot Table list web page using excel.
  • Create reports using the design view is MS-Access
  • Use visual Basic for Application (VBA) with Access
  • How to Administer A Database System using Access
  • How to use grouped data access pages, Pivot Tables, and PivotCharts
  • Work with Macros and Visual Basic for Applications (VBA) with PowerPoint
  • How to Create A Se lf-Running Presentation Containing Interactive Documents with PowerPoint

General Education Competencies - Specific Competencies/Evaluation: Writing: To communicate effectively using standard written English. Students will be expected to answer essay test questions. In addition, students will be required to write an essay or term paper.

Reading: To analyze, summarize, and interpret a variety of reading materials. Exams are based on classroom lecture and discussion as well as required reading in the text. The nature of management requires an the analyzing, summarizing and interpretation of required reading material.

Integrated Learning: To think critically and make connections in learning across the disciplines. Students are expected to integrate facts and critically apply these through data analysis, theory application, interpretation of information and problem solving. This will be evaluated through scheduled tests and classroom discussion.

Creative Thinking:  To elaborate upon knowledge to create new thoughts, processes and/or products. Students are expected to think creatively from information presented in the classroom and from research done in the library. This will be evaluated as a part of scheduled tests and the one term paper.

Ethics/Values:  To demonstrate an awareness of ethical considerations in making value choices. Students should become aware of ethical considerations in both general and business issues. They are expected to take responsibility for and show commitment to their studies and to understand the consequences of serious unethical behavior such as cheating or copyright infringement.

Method of Evaluation and Grading: Methods of evaluation will include (5 primarily objective type tests (multiple choice/true- false), 15 on-line quizzes and 30 in-class/homework.  Each test may also include 1 or 2 short answer questions.  


The final grade will be determined according to the following table:

Method of Evaluation
Four  Tests (100 points each) 400 points
10 Quizzes (10 points each) 100 points
30 In-class exercises (5 points each) 150 points

NOTE: All exercises must be completed by the due date in order to receive credit.

Grading Scale
585 - 650 = A
520 - 584 = B
455 - 519 = C
390 - 454 = D
Below 390 = F

 

Attendance Policy: It is the belief of the instructor that performance is directly related to class attendance and participation. Failure to attend and participate will result in reduced performance.  No make up test will be given without prior approval of the instructor.

Testing: Five primarily objective type tests (multiple choice/true-false) and a comprehensive final exam will be given. Each test may also include 1 or 2 short answer questions. On test dates, students are required to attend. No make-up test will be given without prior approval of the instructor.

Academic Integrity: It is the aim of the faculty of Lincoln Memorial University to foster a spirit of complete honesty and a high standard of integrity. The attempt of any student to present as his/her own any work which he/she has not honestly performed is regarded by the faculty and administration as a very serious offense and renders the offender liable to sever consequences and possible suspension.

  1. Cheating: dishonesty of any kind on examinations or written assignments, unauthorized possession of examination questions, the use of unauthorized notes during an examination, obtaining information during an examination from another student, assisting other to cheat, altering grade recorded, or illegally entering an office are instances of cheating.
  2. Plagiarism: Offering the work of another as one's own without proper acknowledgment is plagiarism; therefore, any student who fails to give credit for quotations or essentially identical material taken from books, magazines, ex cyclopedias or other reference works, or from the themes, reports, or other writing of a fellow student has committed plagiarism.