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.
||Creating Dynamic Forms Adobe
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.
1. Form types
2. Creation of forms
3. Form design
4. Interactive and dynamic forms
5. Styles, components, templates and masters
7. Multimedia in forms
8. Data transfer, submission and security
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)
CSA 133. Microsoft Publisher (2). Practical applications on the functions of Microsoft Publisher using the Windows Operating System. Design and production of professional quality documents that incorporate text, graphics and illustrations. Emphasis on newsletters, brochures, flyers, logos, catalogs and forms. Two lecture.
3. Styles and formatting
4. Graphics, drawn objects, border art, WordArt, text boxes and tables
5. Web pages
6. Merged publications with data
7. Graphic design concepts
8. Printing processes
1. Create an advertising document. (1,2)
2. Edit, revise and print publications. (1-4,8)
3. Use templates to create personal and office publications (flyers, newsletters, letterheads, trifold brochures, business cards, envelopes and web pages). (1-5)
4. Incorporate business forms, tables, graphics, drawn objects, border art, WordArt and business information sets inside publications. (3,4)
5. Create a catalog, letter or invoice and merge it with data. (1-4,6)
6. Produce web pages. (5)
7. Incorporate graphic design concepts to create publications. (7)
||Microsoft Word Desktop Publish
CSA 134. Microsoft Word Desktop Publishing (2). Desktop Publishing using advanced features in Microsoft Word within the Windows Operating System to plan, define, and incorporate desktop publishing concepts and the design and creation of business and personal documents. Prerequisite: CSA 140 . Two lecture.
1. Graphic design concepts
2. Desktop publishing process
3. Personal documents
4. Business documents
5. Page design elements
6. Simple web pages
1. Use graphic design rules in document creation. (1)
2. Plan and prepare business documents such as letterheads, envelopes, business cards, fillable forms, and certificates. (2-4)
3. Plan and create promotional documents such as flyers, brochures, newsletters, and gift certificates. (2-4)
4. Develop and create newsletters while incorporating design elements such as mastheads, sidebars, pull quotes, kickers, jump lines, and color along with Word features such as columns and styles. (2-5)
5. 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. (2,5,6)
CSA 138. Microsoft Excel (2). Practical application on the basic functions of Microsoft Office Excel using the Windows Operating System. Emphasis on creating worksheets for data input and analysis. Two lecture.
2. Formulas and functions
4. Worksheet appearance
5. 3D referencing, structured references and what-if analysis
6. Tables and named ranges
7. Auditing, analyzing and consolidating data
8. Ranges, data tables and pivot tables
1. Create worksheets containing data and formulas. (1-2)
2. Create worksheets with advanced features. (1-8)
3. Format and analyze data. (2-8)
4. Format, modify, and organize worksheets. (1-8)
CSA 139. Microsoft Access (2). Practical application of Microsoft Access using the Windows Operating System. Emphasis on relational databases and query design to summarize and analyze information. Two lecture.
1. Relational databases using Microsoft Access
2. Tables and table properties
3. Fields and set field properties
5. Sorting and filtering Tables and Queries
6. Using Queries to analyze data
7. Crafting forms as an interface
8. Displaying and printing data analysis
9. Importing and Exporting data
1. Define and utilize relational databases. (1)
2. Use Access to create Tables and Queries to manage and analyze data. (2-6)
3. Create and customize data entry forms. (7)
4. Create and print reports that detail selected information. (8)
5. Import and export data. (9)
CSA 140. Microsoft Word (2). Practical application of Microsoft Office Word using the Windows Operating System. Two lecture.
1. Document creation, formatting and editing
2. Headers, footers, page numbers, Styles and Themes
3. Templates, complex tables, charts and graphics
4. Linking to other documents
5. WordArt, textboxes, pull quotes and Smart Art
6. Forms, form letters and mail merge
7. Footnotes, endnotes, outlines, table of contents and indexes
1. Create documents using basic and advanced formatting. (1-8)
2. Create templates, merged documents and forms. (3,5)
3. Create documents with WordArt, Smart Art, Graphics, Tables and charts, (3-4)
4. Create research papers using Microsoft Word. (1,2,7)
CSA 142. Microsoft PowerPoint (2). Practical application of Microsoft PowerPoint using the Windows Operating System. Two lecture.
1. Creating and editing presentations
2. Placeholders and bulleted lists
3. Graphics using clip art and WordArt
4. Enhancing pictures
5. Tables, charts and Smart Art diagrams
6. Transitions, animation, multimedia effects and hyperlinks
7. Templates, themes and master slides
8. Outlines, integrating, reviewing and protecting
9. Print options
1. Create slide presentations that include text, graphics, and advanced features. (1-5)
2. Create and format presentations from templates; use slide master, slide transitions, animation schemes and multimedia effects. (5-7)
3. Create presentations from other programs and print as handouts. (7-9)
||Create Web Page/Dreamweaver
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.
1. Basic web page elements
2. HTML coding elements
3. Links and URLs
6. Style sheets
7. Website publishing
8. Site management
10. Layout tools and concepts
11. Rollover images
12. Templates and libraries
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)
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.
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
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.