CIS 1140 Business Computer Skills

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

Outcomes

• 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

Module: Word Chapter 2: Document Presentation

• Log in to 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
• Utilize styles
• Create and modify styles
• Format a graphical object
• Insert symbols into a document

Module: Word Chapter 3: Collaboration and Research

• Log in to 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 in to 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
• 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

Module: Excel Chapter 2: Formulas and Functions in Excel

• Log in to 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
• 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

Module: Access Chapter 1: Introduction to Access

• Log in to myitlab
• Click Week 6: Introduction to Access

Lecture: Introduction to Microsoft Access 2010

Outcomes

• 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

Module: Introduction to PowerPoint

• Log in to myitlab
• Click Week 7: Introduction to PowerPoint

Lecture: Introduction to Microsoft PowerPoint 2010

Outcomes

• 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

Module: Integrated Projects: Creating Presentation Content from Office Documents Pages

Lecture: Introduction to Integration

Outcomes

• 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