MIS 2749 COURSE SYLLABUS
INSTRUCTOR’S NAME: Charles J. Campbell E-MAIL: firstname.lastname@example.org
INSTRUCTOR’S PHONE: 678-2477 INSTRUCTOR’S OFFICE: 242
INSTRUCTOR’S OFFICE HOURS: 2:00 – 5:30 and 8:30 – 9:00 pm TTh
TEXT WEB SITE: www.prenhall.com/grauer
UM DRIVE: http://umdrive.memphis.edu
UM DRIVE FOR Judy Brown: http://umdrive.memphis.edu/jbrown/public
UM DRIVE FOR C Campbell: http://umdrive.memphis.edu/ccampbll/public
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
Microsoft? Excel 2007 Complete. Grauer and Barber. Pearson Prentice Hall Publisher.
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.
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.
Production Tests 1, 2, and 3 45%
MCAS Test 25%
Class work 20%
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.
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.
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
Final Exam Date (See Schedule of Classes) PowerPoint Presentations
September 3 Labor Day
October 15-16 Fall Break
November 22-23 Thanksgiving
December 6 Study Day
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