Computer Application Specialist Certificate    Click here to request more info


Program Contacts

Dean Stacey Hilton, Interim (928) 717-7775
Instructional Assistant Mitzi Martin (928) 776-2157

Quick Facts


About the Computer Application Specialist Certificate

The Computer Application Specialist certificate is designed to provide students with the skills necessary to be proficient working with current software applications in the Microsoft environment.

Program Outcomes

Upon successful completion of the Computer Application Specialist Certificate program, the learner will be able to:

 

  1. Accomplish a variety of office tasks using current software programs. (All courses within the program)
  2. Develop the software skills necessary to solve various office problems/scenarios by using current software applications in the office environment. (All courses within the program)
  3. Manage information systems and electronic media to accomplish office tasks efficiently. (All courses within the program)

 

 

Program-Specific Requirements

Course Course Title Hours
CSA124 Creating Dynamic Forms Adobe

COURSE DESCRIPTION:
CSA 124. Creating Dynamic Forms Using Adobe LiveCycle Designer (2). Practical application of Adobe LiveCycle Designer and Acrobat. Emphasis on use of Designer to create attractive forms that are interactive and dynamic for distribution as .pdf documents and/or use in web pages. Two lecture.

COURSE CONTENT:
1. Form types
2. Creation of forms
3. Form design
4. Interactive and dynamic forms
5. Styles, components, templates and masters
6. Scripting
7. Multimedia in forms
8. Data transfer, submission and security
9. Distribution

LEARNING OUTCOMES:
1. Illustrate the different types of electronic forms and their uses. (1)
2. Use LiveCycle Designer to create forms. (2, 4)
3. Implement design principles when creating forms. (3)
4. Evaluate form styles, components, templates and masters. (5)
5. Create interactive forms. (2, 4)
6. Create forms with data and user input. (2, 4, 6, 8)
7. Write script to control form interactions. (6)
8. Use external files in a form; connect to XML schema. (7, 8)
9. Use data submission and security measures (8, 9)
10. Utilize Adobe Acrobat and LiveCycle together (1, 2, 4, 7- 9)

2
CSA133 Microsoft Publisher

COURSE DESCRIPTION:
CSA 133. Microsoft Publisher (2). Design and production of professional quality documents that incorporate text, graphics and illustrations. Emphasis on newsletters, brochures, flyers, logos, catalogs and forms. Two lecture.

COURSE CONTENT:
1. Publications
2. Templates and wizards
3. Styles and formatting
4. Graphics, drawn objects, border art, WordArt, text boxes and tables
5. E-Commerce web pages
6. Merged publications with data
7. Graphic design concepts
8. Printing processes

LEARNING OUTCOMES:
1. Create an advertising flyer. (1-2)
2. Edit, revise and print publications. (1,8)
3. Prepare trifold brochure using wizards and templates with graphics, draw objects, border art, WordArt and tables. (3)
4. Design personal and office publications (newsletter, letterhead, business card, envelope and web page) using templates and information sets. (1-4, 7)
5. Design and develop business forms and tables. (1-4,7)
6. Create a catalog with merged data. (1,2,6)
7. Create e-commerce web pages. (5)
8. Incorporate graphic design concepts to create publications. (1,7)

2
CSA134 Microsoft Word Desktop Publish

COURSE DESCRIPTION:
CSA 134. Microsoft Word Desktop Publishing (2). Desktop Publishing using advanced Microsoft Word feature to plan, define, and incorporate desktop publishing concepts and the design and creation of business and personal documents. Prerequisite: CSA 140 . One lecture. Three lab.

COURSE CONTENT:
1. Understanding the desktop publishing process
2. Planning and creating letterheads, envelopes, business cards, resumes, and certificates
3. Planning and creating promotional documents such as flyers, brochures and gift certificates
4. Planning and creating web pages
5. Planning and creating publications such as newsletters, reports, and manuals

LEARNING OUTCOMES:
1. Produce internal business documents such as memos, agendas, press releases, and fax cover sheets with a variety of typefaces, type styles, type size, and special symbols.
2. Produce business letterheads, envelopes, and business cards using a variety of templates, fonts, and ruled lines.
3. Create resumes, calendars, personal address labels, and certificates.
4. Produce promotional documents such as flyers, brochures and announcements using Word's Tables and Borders toolbar, Picture toolbar, Drawing toolbar, Picture Editor, Word Art, and Autoshapes.
5. Create specialty promotional documents, such as gift certificates, postcards, name tags, business greeting cards, and invitations.
6. Create a Web home page with hyperlinks using Microsoft Word and apply basic desktop publishing concepts to the layout and design of the Web page.
7. Create newsletters using Word features such as columns and styles and design elements, such as masterheads, sidebars, pull quotes, kickers, jump lines, and color.
8. Prepare reports, term papers, manuals, and forms containing elements such as a cover page, table of contents, title page, and indexes.

2
CSA138 Microsoft Excel

COURSE DESCRIPTION:
CSA 138. Microsoft Excel (2). Practical application on the basic functions of Microsoft Office Excel. Emphasis on creating worksheets for data input and analysis. Two lecture.

COURSE CONTENT:
1. Data entry and analysis
2. Formulas and functions
3. Ranges
4. Headers and footers
5. Hyperlinks
6. Charts and graphs
7. Filters
8. Pivot tables
9. Web pages
10. Macors
11. Links and embeds between applications
12. Data
13. Cells
14. Worksheets

LEARNING OUTCOMES:
1. Create worksheets containing data and formulas. (1-2)
2. Create worksheets with advanced features. (3-11)
3. Format and analyze data. (11-14)
4. Format, modify, and organize worksheets. (12-14)

2
CSA139 Microsoft Access

COURSE DESCRIPTION:
CSA 139. Microsoft Access (2). Practical application of Microsoft Access. Emphasis on relational databases and query design to summarize and analyze information. Two lecture.

COURSE CONTENT:
1. Relational Databases
2. Queries
3. Forms
4. Reports
5. Fields and Records
6. Table Properties
7. Field Properties
8. Data Sorts and Filters
9. Data Analysis
10. Report Printing
11. Import and Export of Data

LEARNING OUTCOMES:
1. Create relational databases. (1, 5-7)
2. Create queries to manage and analyze data. (2, 8-9)
3. Create data entry forms. (3)
4. Create reports to detail selected information. (4, 8-10)
5. Import and Export data. (11)

2
CSA140 Microsoft Word

COURSE DESCRIPTION:
CSA 140. Microsoft Word (2). Practical application of Microsoft Office Word. Practical application of Microsoft Office Word. Emphasis on creating and formatting content, working with visual content, and organizing documents. Two lecture.

COURSE CONTENT:
1. Text
2. Graphics and Watermarks
3. Headers and Footers
4. Merged Documents
5. Tables and Charts
6. Footnotes and Endnotes
7. Tables of Content and Figures
8. Citations
9. Outlines
10. Templates
11. Forms
12. Web Pages
13. Links and Embeds Between Applications
14. Text and Paragraph Formatting
15. Page Setup
16. Columns
17. Styles

LEARNING OUTCOMES:
1. Create office documents using basic and advanced formatting features. (1-17)
2. Create templates. (10)
3. Create merged documents. (4)
4. Create forms. (11)
5. Create web pages. (12)
6. Create linked or embedded documents. (13)

2
CSA142 Microsoft PowerPoint

COURSE DESCRIPTION:
CSA 142. Microsoft PowerPoint (2). Practical application of Microsoft PowerPoint. Emphasis on creating and formatting slide presentations, working with multimedia, and slide show delivery options. Two lecture.

COURSE CONTENT:
1. Text
2. Graphics
3. Tables and charts
4. Multimedia
5. Slide formatting
6. Animation schemes
7. Templates
8. Slide masters
9. Custom slide shows
10. Timings
11. Speaker notes
12. Print options

LEARNING OUTCOMES:
1. Create slide presentations that include text, graphics, and advanced features. (1-4)
2. Format slides and slide objects. (5)
3. Create slide transitions and animations schemes. (5,6)
4. Create presentations from templates. (7)
5. Format presentations using slide masters. (8)
6. Deliver slide shows for a range of audiences. (9-11)
7. Print presentation slides, outlines and handouts. (12)

2
CSA144 Create Web Page/Dreamweaver

COURSE DESCRIPTION:
CSA 144. Creating Web Pages Using Dreamweaver (3). Create website using Dreamweaver software. Emphasis on creating, publishing to the web and maintaining website. This is cross-listed with WEB 144. Three lecture.

COURSE CONTENT:
1. Basic web page elements
2. HTML coding elements
3. Links and URLs
4. Tables
5. Forms
6. Style sheets
7. Website publishing
8. Site management
9. Typography
10. Layout tools and concepts
11. Rollover images
12. Templates and libraries
13. Automation
14. Spry

LEARNING OUTCOMES:
1. Critique web elements on existing web sites. (1,2)
2. Use tables to present data. (4)
3. Create a website with logical file organization and navigation. (8)
4. Use semantic tags. (2)
5. Import images into a web page. (1)
6. Create text, image, image map, email and file links. (3)
7. Layout a web site using tables, absolute positioned elements, and templates or libraries. (4,5,9,10,12)
8. Use automation tools to alter multiple pages of a site. (13)
9. Apply external style sheets with class and tag selectors. (6)
10. Create forms with validation. (5,14)
11. Create image rollovers and disjoint image rollovers. (11)
12. Publish a web site. (7,8)

3
CSA172 Microsoft Windows

COURSE DESCRIPTION:
CSA 172. Microsoft Windows (2). Personal computer operations using the Microsoft Windows operating environment. Customizing, optimizing and maintenance of desktops, folders, and documents. One lecture. Two lab.

COURSE CONTENT:
1. Introduction to personal computers and operating systems
2. Window components
3. The Start button
4. My Computer and Help
5. File, document and folder naming conventions
6. Creating documents
7. Modifying and editing documents
8. Printing documents and using the Managing the Print queue and spool
9. Using the taskbar
10. Working with multiple windows
11. Cutting, copying and pasting
12. Object moving, copying and shortcuts
13. Sorting and finding documents
14. Using the Recycle Bin
15. Using system tools such as defrag and scandisk
16. Explorer Window
17. System shut down

LEARNING OUTCOMES:
1. Identify fundamental personal computing concepts and terminology.
2. Identify components of the Windows screen; select items with the mouse pointer; access Windows features by using the Start button; and work with windows by using buttons and dragging techniques.
3. Observe the contents of a disk by using the My Computer icon; and access a disk quickly by creating a desktop shortcut.
4. Work with multiple programs by using the taskbar to switch between windows.
5. Share data between applications using the Edit Copy and Edit Paste commands.
6. Display the contents of a disk by using the Windows Explorer; create a folder by using a shortcut menu; copy and move documents and folders by dragging them; and sort and locate documents.
7. Prepare a disk for use with the Format command; copy and move groups of documents; delete and restore documents by using the Recycle Bin; and exit Windows.
8. Create a custom user interface by changing properties of the taskbar, the desktop, and other components.
9. Create subfolders and modify file attributes.
10. Manipulate the print queue; set up a printer to print.

2

Note:  It is always best to discuss educational and career goals with an academic advisor prior to enrolling in any courses.  Learn more about Academic Advising.