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). Design and production of professional quality documents that incorporate text, graphics and illustrations. Emphasis on newsletters, brochures, flyers, logos, catalogs and forms. Two lecture.
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
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)
||Microsoft Word Desktop Publish
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.
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
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.
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.
1. Data entry and analysis
2. Formulas and functions
4. Headers and footers
6. Charts and graphs
8. Pivot tables
9. Web pages
11. Links and embeds between applications
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)
CSA 139. Microsoft Access (2). Practical application of Microsoft Access. Emphasis on relational databases and query design to summarize and analyze information. Two lecture.
1. Relational Databases
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
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)
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.
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
12. Web Pages
13. Links and Embeds Between Applications
14. Text and Paragraph Formatting
15. Page Setup
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)
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.
3. Tables and charts
5. Slide formatting
6. Animation schemes
8. Slide masters
9. Custom slide shows
11. Speaker notes
12. Print options
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)
||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.