CIS 1130 PC Applications

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

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

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

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

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

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

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

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