By Antonio Reyes,2014-12-29 13:36
14 views 0


    Fall, 2007

INSTRUCTOR’S NAME: Charles J. Campbell E-MAIL:


INSTRUCTOR’S OFFICE HOURS: 2:00 5:30 and 8:30 9:00 pm TTh



    UM DRIVE FOR Judy Brown:

    UM DRIVE FOR C Campbell:

    Course Title and Description

Introduction to Business Microcomputer Applications. (3 credit hours) This course is designed

    to give students experience with Microsoft? Office Applications for the purpose of performing business tasks and for providing training for expected upper-division coursework needs. The course is in a lab environment with direct instruction concerning the use of current software, internet applications, and electronic communication. Out of class assignments require the use of a computer with Internet access. A significant part of the course will require online projects

    Texts Required

Microsoft? Excel 2007 Complete. Grauer and Barber. Pearson Prentice Hall Publisher.

    Learning Objectives

    1. Students will examine Internet resources and demonstrate the ability to download files

    from web sites, to use Internet search engines to locate information to be used in the

    solution of cases, to send and receive e-mail and attachments, to save files as web pages,

    and to import web information into applications.

    2. Students will have online use of myitlab which simulates Microsoft 2007. This software

    will be required to complete some assignments.

    3. Students will demonstrate an ability to use Microsoft? Word 2007, Microsoft?

    PowerPoint 2007, Microsoft? Access 2007, and Microsoft? Excel 2007 software.

    4. Students will create and edit spreadsheets using Microsoft? Excel 2007 and will

    demonstrate the ability to save, print, create hyperlinks, create macros using Visual Basic,

    compute values using relative and absolute formulas, produce charts, and apply advanced

    techniques including freezing panes, data analysis, goal seek, and solver.

    5. Students will demonstrate an ability to use Microsoft? Access 2007 software including

    creating and editing databases, analyzing and creating reports, working with multiple

    tables, and creating custom forms.

    6. Students will sit for an Excel Microsoft? Certified Application Specialist Exam thereby

    gaining the opportunity to become Excel Certified.

    7. Students will demonstrate the ability to integrate software packages to solve business

    problems including the following: Inventory Tracking Systems, Straight Line


    Depreciation, CD Portfolio Interest, Net Worth, Payment Schedules for Loans of Varying

    Years and Interest, FV Function, PMT Function, Investment Strategies, Disaster Plans,

    Client Tracking, Form Design, File Compression, Mail Merge, and Loan Tracking


    8. Students will complete a project requiring the integrated use of Office 2007 software.

    The students will research an MIS problem and create a PowerPoint slide show to present

    to the class.


Production Tests (45%)

    Three production tests will be given during the course of the class. Each will count as 15% of the final grade.

MCAS Excel Test (25%)

    A Microsoft? Certification Application Specialist Exam will be given for Excel. All students

    passing this exam at the acceptable standard will receive a certificate from Microsoft? stating certification. This exam is scheduled in advance, and students are expected to attend on the date announced. The MCAS exam is 25% of the final grade. There are no retakes for this exam.

Assigned Class work (20%)

    Students will complete online and in-class assignments to be submitted for credit.

Project (10%)

    Students will be assigned a project requiring a PowerPoint slide show presentation. Each student must give their presentation to receive credit for the project. All presentations will be given in class at the time scheduled for the class final examination.

Grading Scale

    Production Tests 1, 2, and 3 45%

    MCAS Test 25%

    Class work 20%

    Project 10%

     Total 100%

    A=90% +, B=80-89%, C=70-79%, D=60-69%, F=Below 60%. No plus or minus grades will be given. The MIS department does not post grades.

    Course Procedures

    Students will need a portable device for storing data files once the class begins Excel. Data files are provided by the publisher.



    Your instructor will adhere to university policies related to cheating and class conduct. (Refer to the Student Handbook, sections Academic and Misconduct and Classroom Misconduct for


    One item in the handbook specifies that students are not to cause disturbances in the classroom. In addition to any improper classroom behavior, any behavior that is distracting for other students or for your instructor is not allowed. Examples include bringing non-enrolled guests to class, and bringing phones or pagers that ring or beep during class.

No food or beverages are allowed in the classroom.

    Cell phones, iPods and other players are not appropriate for the classroom. Your instructor will give one warning if a cell phone rings. A second occasion will result in a 2-point deduction in your final grade. A third occasion will result in an additional 5-points deduction. After 3 occasions, you will be asked to leave the class.

    It is important that you attend class and that you arrive on time and stay until the class ends. Some of the work that is done in class is not available in the textbook you purchased. It is to your benefit that you attend class each day.

    Your instructor reserves the right to penalize your class work grade for repeated offences.


    Tentative Schedule

    Tuesday/Thursday Morning and Evening Classes

    8/28 Introduction, MyIT Lab 8/30-9/11 MyIT Lab Word and PowerPoint 9/13 Test 1

    9/18-9/27 Excel 1-5

    10/2 Test 2

    10/4-10/23 Excel 6-10

    10/25 MCAS Test

    10/30-11/13 Access 1-4

    11/15 Test 3

    11/20-12-4 Project

    Final Exam Date (See Schedule of Classes) PowerPoint Presentations

    School Holidays

    September 3 Labor Day

    October 15-16 Fall Break

    November 22-23 Thanksgiving

    December 6 Study Day

    Exam Schedule

    MWF, 6:50am W, Dec 12, 7:00 - 9:00am TR, 8:00am T, Dec 11, 8:00 - 10:00am MWF, 8:00am F, Dec 7, 8:00 - 10:00am TR, 9:40am T, Dec 11, 10:30am - 12:30pm MWF, 9:10am F, Dec 7, 10:30am - 12:30pm TR, 11:20am R, Dec 13, 8:00 - 10:00am MWF, 10:20am M, Dec 10, 8:00 - 10:00am TR, 1:00pm R, Dec 13, 10:30am - 12:30pm MWF, 11:30am M, Dec 10, 10:30am - 12:30pm TR, 2:40pm T, Dec 11, 1:00 - 3:00pm MW, 12:40pm W, Dec 12, 10:00am - 12noon TR, 5:30pm R, Dec 13, 5:30 - 7:30pm MW, 2:20pm W, Dec 12, 1:00 - 3:00pm TR, 7:10pm T, Dec 11, 7:00 - 9:00pm MW, 5:30pm W, Dec 12, 5:30 - 7:30pm TR, 8:50pm R, Dec 13, 8:00 - 10:00pm MW, 7:10pm M, Dec 10, 7:00 - 9:00pm S, 9:00am S, Dec 8, 9:00 - 11:00am MW, 8:50pm W, Dec 12, 8:00 - 10:00pm S, 1:00pm S, Dec 8, 1:00 - 3:00pm

     U, 1:00pm U, Dec 9, 1:00 - 3:00pm


Report this document

For any questions or suggestions please email