Section 1
Summer 2012


CIS100 Business Computer Systems (4)

Summer 2012


Time: Mondays 6:10pm-10:00pm

Location: Salazar Hall, Room C363



Song Xing, Ph.D.
Associate Professor of Information Systems
Office: Simpson Tower, Room 605
Phone: (323)343-2917

Office hours: Mondays & Tuesdays 4:45pm-6:05pm, send the instructor email for an appointment for other times. 

This course will provide the students with an understanding of the fundamentals of computers and computer nomenclature, particularly with respect to personal computer hardware and software, the Web, and enterprise computing. It includes a concise, yet comprehensive introduction to both computer concepts and Microsoft Office 2010 on lectures and lab sessions.

The lab experiments are designed and intended to complement the material presented in the lectures in order to strengthen the students' understanding of the computer concepts. Specifically, the lab provides an overview of microcomputer applications including an introduction to Microsoft Word 2010, Microsoft Excel 2010, Microsoft Access 2010, Microsoft PowerPoint 2010, and Microsoft Outlook 2010. Students are expected to be well prepared when they come to the lab in order to make the most efficient use of their time.


  • Gary B. Shelly, Misty E. Vermaat, Discovering Computers Fundamentals: Your Interactive Guide to the Digital World, 8th Edition, CENGAGE Learning, 2012, ISBN-10: 1111530459 ISBN-13: 9781111530457. (optional)
  • Gary B. Shelly, Misty E. Vermaat, Microsoft® Office 2010: Introductory, 1st Ed, CENGAGE Learning, 2011, ISBN-10: 1439078386, ISBN-13: 9781439078389 (optional)
Microsoft offers free Office 2010 online training courses ( which will complement our lectures by enhancing student learning and understanding.

Tentative Topics:

  1. Introduction to Computers (Special Feature: Timeline).
  2. The Internet and World Wide Web (Special Feature: Making Use of the Web).
  3. Application Software (Special Feature: Digital Communications).
  4. The Components of the System Unit (Special Feature: Digital Video Technology).
  5. Input and Output.
  6. Storage.
  7. Operating Systems and Utility Programs (Special Feature: Buyer's Guide).
  8. Communications and Networks.
  9. Database Management.
  10. Computer Security and Safety, Ethics, and Privacy.
  11. Information System Development and Programming Languages.
  12. Enterprise Computing (Special Feature: Living Digitally).
  13. Word 2010: Creating, Formatting, and Editing a Word Document with Pictures; Creating a Research Paper with Citations and References; Creating a Business Letter with a Letterhead and Table.
  14. PowerPoint2010: Creating and Editing a Presentation with Clip Art; Enhancing a Presentation with Pictures, Shapes, and WordArt; Reusing a Presentation and Adding Media.
  15. Excel 2010: Creating a Worksheet and an Embedded Chart; Formulas, Functions, and Formatting; What-If Analysis, Charting, and Working with Large Worksheets.
  16. Access 2010: Databases and Database Objects: An Introduction; Querying a Database; Maintaining a Database.
  17. Outlook 2010: Managing E-Mail Messages with Outlook; Managing Calendars.
The schedule of lecture topics and lab assignments is listed on the Schedule page of the course web site. The detailed lecture slides will be posted on the Lectures page of the course web site before the class begins. The References & Other page of the course web site also lists many useful links for helping people to study the course.


There will be homework assignments, lab projects, a mid-term exam, and a final exam. The final grade will be determined using the following weights: homework assignments and lab projects 25%, mid-term exam 33%, final exam 37%, class/lab participation and attendance 5%.

Lab Sessions:

An introduction to lab assignments will be conducted at the begining of each lab. Students are expected to be well prepared when they come to the lab in order to make the most efficient use of their time. The instructor will provide assistance to students who need help for their lab assignments.


Homework assignments must be done individually. Failure to do so will result in a violation of the Academic Honor Code. The following cases will be considered as violations: identical answers and extremely similar answers.


The tentative date for the mid-term is July 23, Monday, 6:10pm-8:40pm. The Final exam is scheduled for Sep 5, Wednesday, 7:30pm-10:00pm.

The final exam is not cumulative and it will only cover the material talked after the mid-term exam. The study guides and exam sample questions will be posted on the Homework page of the course web site. You are allowed to use one page note in two exams.

Make-up exams will be given only in unusual circumstances beyond the student's control. Arrangements for make-up exams must be made in advance.

Attendance Policy:

Attendance is mandatory. Send the instructor ( email in advance if you have to miss a class due to emergency or sickness.

Last modified on Friday, 27-Apr-12.