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