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

CIS 1130 PC Applications


Course Description

Introduces computer applications. Includes basic computer concepts and terminology through experience using the operating system, word processing, spreadsheet and presentation management software.

Course Objectives

Upon completion of this course, students should be able to

  • Utilize a word processing system to create, edit, and output documents such as letters, reports, etc., in a suitable business format
  • Navigate a spreadsheet program to create, edit, manipulate, and output spreadsheets and charts for business operations
  • Operate a presentation management program to create, edit and output business presentations
  • 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 PC Application

Lecture: Introduction to Microsoft Word 2010

Outcomes

  • Understand Word basics
  • Customizing Word
  • Use features that improve readability
  • Check speaking 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 into myitlab
  • Click Week 2: Document Presentation

Outcomes

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

Week 3


Module: Word Chapter 3: Collaboration and Research

  • Log into myitlab
  • Click Week 3: Collaboration and Research

Outcomes

  • 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 into myitlab
  • Click Week 4: Introduction to Excel

Lecture: Introduction to Microsoft Excel 2010

Outcomes

  • 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
  • Manage 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 into myitlab
  • Click Week 5: Formulas and Functions in Excel

Outcomes

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

Week 6


Module: Introduction to PowerPoint

  • Log into myitlab
  • Click Week 6: Introduction to PowerPoint

Lecture: Introduction to Microsoft PowerPoint 2010

Outcomes

  • Use PowerPoint views
  • Save as a slide show
  • Plan a presentation
  • Assess presentation content
  • Use slide layouts
  • Apply themes
  • Review the presentation
  • Insert media objects
  • Add a table
  • Use animations and transitions
  • Insert a header or footer
  • Run and navigate a slide show
  • Print in PowerPoint

Week 7


Module: PowerPoint Chapter 2: Presentation Development: Planning and Preparing a Presentation

  • Log into myitlab
  • Click Week 7 Presentation Development

Outcomes

  • Create a presentation using a template
  • Modify a template
  • Create a presentation in Outline view
  • Modify an outline structure
  • Print an outline
  • Import an outline
  • Add existing content to a presentation
  • Examine slide show design principles
  • Apply a theme
  • Use sections

Week 8


Module: Integrating Word, PowerPoint, and Excel

Lecture: Introduction to Integration

Outcomes

  • Insert a Word outline into PowerPoint
  • Import Excel data into PowerPoint chart
  • Insert a hyperlink into a PowerPoint slide
  • Embed an Excel chart in a Word Document
  • Edit an embedded Excel chart in Word
  • Link an Excel Worksheet to a Word document
  • Update a linked Excel worksheet
  • Test and break a link

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