ITAP 1000 - Foundations of Computer Applications

Credit Hours: 3.00

Prerequisites: None

(replaces but does not equate to ITML 1000)

ITAP 1000 is specifically designed as a foundation for students with little or no experience using personal computers. The course provides an introduction to the use of standard business applications, fundamental computer concepts, and keyboarding skills. Students will be introduced to the fundamentals of word processing, spreadsheet, database, and presentation software. Core computer concepts such as using the Windows Operating System, file management, email, and Internet use will also be covered.

Billable Contact Hours: 3

Search for Sections

OUTCOMES AND OBJECTIVES
Outcome 1: Upon completion of this course, students will use Microsoft Office productivity software.

Objectives:

Create, edit, and format a Word Document.
Create, edit, format, an Excel Spreadsheet.
Build basic formulas, functions and charts in Excel.
Design and build an Access table.
Query an Access database.
Design and build a slide shows using Microsoft PowerPoint.

Outcome 2: Upon completion of this course, students will perform standard tasks within the operating system, including managing files and using the Internet effectively.

Objectives:

Create folders and sub-folders.
Save files into specific location.
Copy, move or copy/paste files between folders to organize content.
Access websites and search the Internet effectively.

Outcome 3: Upon completion of this course, students will effectively use a personal information manager to manage business communications.

Objectives:

Send and receive emails using Microsoft Outlook.
Create and manage appointments and meetings using Microsoft Outlook.
Manage contact lists and create tasks using Microsoft Outlook.

Outcome 4: Upon completion of this course, students will improve accuracy on the keyboard.

Objectives:

Perform keyboarding exercises to improve accuracy and proficiency.
Demonstrate proper typing technique, body posture, and control.

COMMON DEGREE OUTCOMES (CDO)
• Communication: The graduate can communicate effectively for the intended purpose and audience.
• Critical Thinking: The graduate can make informed decisions after analyzing information or evidence related to the issue.
• Global Literacy: The graduate can analyze human behavior or experiences through cultural, social, political, or economic perspectives.
• Information Literacy: The graduate can responsibly use information gathered from a variety of formats in order to complete a task.
• Quantitative Reasoning: The graduate can apply quantitative methods or evidence to solve problems or make judgments.
• Scientific Literacy: The graduate can produce or interpret scientific information presented in a variety of formats.

CDO marked YES apply to this course:
Communication: YES
Critical Thinking: YES
Information Literacy: YES
Quantitative Reasoning: YES
COURSE CONTENT OUTLINE

Introduction to Keyboarding
1. Proper typing techniques
2. Touch method
3. Speed and Accuracy improvement
Windows and File Management
1. Windows fundamentals
2. Creating and naming files
3. Navigating a file system
4. Copy/Move files in a file system
5. Use the Web effectively
6. Search the Web effectively
Outlook
1. Send and Receive Emails
2. Create and manage appointments
3. Manage contact lists
4. Create and manage task lists
Microsoft Word
1. Create a Word Document
2. Edit a Word Document
3. Format Text and Documents
Microsoft Excel
1. Create an Excel Spreadsheet
2. Edit an Excel Spreadsheet
3. Format an Excel Spreadsheet
4. Create a Chart in Excel
Microsoft Access
1. Design and Build an Access table
2. Design and Apply Basic Queries to an Access Database
Microsoft PowerPoint
1. Design and Build a Slide using Microsoft PowerPoint
2. Design and Build a Slide Show using Microsoft PowerPoint

Primary Faculty
Banta, Robert
Secondary Faculty

Associate Dean
Evans-Mach, Patrick
Dean
Balsamo, Michael

Official Course Syllabus - Macomb Community College, 14500 E 12 Mile Road, Warren, MI 48088