Send More Info
Apply Now
Classroom Login
Call Now
Call Now 855-300-1469

CIS 1140 Business Computer Skills

Course Description

Uses commercial software to understand the business functions of computers and develop personal competency in practical application of computers in business. Provides specific knowledge and advanced capabilities in various skills necessary for effective performance in business classes and the business world.

Course Objectives

Upon completion of this course, students should be able to

  • Operate a word processing system to create, edit, and output documents such as letters, reports, etc., in a suitable business format
  • Create a spreadsheet to develop, edit, manipulate, and output spreadsheets and charts for business operations
  • Navigate a presentation management program to create, edit, and output business presentations
  • Utilize a database management system to create, manipulate, access, and output databases as used in business operations
  • Copy or link the products of the above applications so that a seamless product is produced for business use

Week 1

Module: Introduction to Word: Organizing a Document
  • Log into myitlab
  • Click Week 1: Introduction to Word
Lecture: Introduction to Business Computer Skills
Lecture: Introduction to Microsoft Word 2010


  • Comprehend Word Basics
  • Customize Word
  • Use features that improve readability
  • Check spelling and grammar
  • Display a document in different views
  • Prepare a document for distribution
  • Modify document properties

Week 2

Module: Word Chapter 2: Document Presentation
  • Log in to myitlab
  • Click Week 2: Document Presentation


  • Apply font attributes through the Font dialog box
  • Control word-wrapping
  • Set off paragraphs with tabs, borders, lists, and columns
  • Apply paragraph formats
  • Utilize styles
  • Create and modify styles
  • Format a graphical object
  • Insert symbols into a document

Week 3

Module: Word Chapter 3: Collaboration and Research
  • Log in to myitlab
  • Click Week 3: Collaboration and Research


  • Insert comments in a document
  • Track changes in a document
  • Acknowledge a source
  • Create and modify footnotes and endnotes
  • Insert a table of contents and index
  • Add other reference tables
  • Create cross references

Week 4

Module: Excel Chapter 1: Introduction to Excel, What is a Spreadsheet?
  • Log in to myitlab
  • Click Week 4: Introduction to Excel
Lecture: Introduction to Microsoft Excel 2010


  • Plan for effective workbook and worksheet design
  • Explore the Excel window
  • Enter and edit cell data
  • Use symbols and the order of precedence
  • Use Auto Fill
  • Display cell formulas
  • Create worksheets
  • Manage columns and rows
  • Select, move, copy, and paste
  • Apply alignment and font options
  • Apply number formats
  • Select page setup options
  • Print a worksheet

Week 5

Module: Excel Chapter 2: Formulas and Functions in Excel
  • Log in to myitlab
  • Click Week 5: Formulas and Functions in Excel


  • Use semi-selection to create a formula
  • Use relative, absolute, and mixed cell references in formulas
  • Avoid circular references
  • Insert a function
  • Use total values with the SUM function
  • Insert basic statistical functions
  • Use data functions
  • Determine results with the IF function
  • Employ lookup functions
  • Calculate payments with the PMT function
  • Create and maintain range names
  • Use range names in formulas

Week 6

Module: Access Chapter 1: Introduction to Access
  • Log in to myitlab
  • Click Week 6: Introduction to Access
Lecture: Introduction to Microsoft Access 2010


  • Navigate among the objects in an Access database
  • Compare working in storage and working in memory
  • Practice good database management
  • Back up, compact, and repair Access files
  • Create filters
  • Sort table data on one or more fields
  • Know when to use Access or Excel to manage data
  • Use the Relationships window
  • Determine relational power

Week 7

Module: Introduction to PowerPoint
  • Log in to myitlab
  • Click Week 7: Introduction to PowerPoint
Lecture: Introduction to Microsoft PowerPoint 2010


  • Open an existing PowerPoint presentation
  • Create and modify a presentation
  • Identify PowerPoint user interface elements
  • Use PowerPoint views
  • Open and save a slide show
  • Get Help
  • Create a storyboard
  • Use slide layouts
  • Apply design themes
  • Review the presentation
  • Add a table
  • Insert clip art
  • Manipulate images within PowerPoint
  • Use transitions and animations
  • Run and navigate a slide show
  • Print with PowerPoint
  • Edit text on slides
  • Add/Move/Delete slides
  • Create speaker notes
  • Preview and print slides, handouts, and speaker notes
  • Apply themes
  • Modify the slide master
  • Add and modify tab stops
  • Work with tables, SmartArt, and text boxes

Week 8

Module: Integrated Projects: Creating Presentation Content from Office Documents Pages
Lecture: Introduction to Integration


  • Insert a Word outline into PowerPoint
  • Import Excel data into PowerPoint Chart
  • Insert a hyperlink into a PowerPoint slide
  • Merge Access data with a Word document
  • Complete an entire mail merge process for form letters
  • Create a Word outline
  • Create PowerPoint slides from a Word outline
  • Copy and paste an Access query into a PowerPoint presentation
  • Link an Excel chart to a PowerPoint presentation

The course description, objectives and learning outcomes are subject to change without notice based on enhancements made to the course. November 2011