- Name: Computer Applications
- Discipline: Information Systems
- Units (Credits): 3
- Transfer Information: (Courses with numbers 100 to 299) This course is designed to apply toward a WNC degree and/or transfer to other schools within the Nevada System of Higher Education, depending on the degree chosen and other courses completed. It may transfer to colleges and universities outside Nevada. For information about how this course can transfer and apply to your program of study, please contact a counselor.
- Academic Division: Career and Technical Education
- Prerequisites: IS 101 or experience in office software.
I: Catalog Course Description
Develops the student's knowledge of integrated office productivity software. Topics will cover word processing, database, spreadsheets and working with macro programming. Coursework or experience using office software is essential for successful completion and gives students the foundation to pass expert level certification tests.
II: Course Objectives
Offers advanced topics in spreadhseets, computer database management systems and macroprogramming. Reviews traditional methods and modern software tools to generate applications that do not require detailed and highly technical program writing efforts. Includes "hands-on" computer time. Formerly CIS 203. Prerequisite: IS 101 and (1 Credit Each) CIT 201, 202, and 203 recommended.
- 1. Manage word processing data and documents by merging, formatting with special features, customizing images, formatting with drawing tools, and formatting with macros and styles.
- 2. Share and Publish information by tracking changes, working with master and sub-documents, creating Tables and Indexes, preparing and protecting forms, importing data, creating hyperlinks, downloading and saving web pages.
- 3. Use advanced formatting and functions
- 4. Use advanced spreadsheet formatting and functions (Financial, Math and Trig, Statistical, Lookup and Reference, Logical), create array formulas, and work with lists.
- 5. Interpret and integrate spreadsheet data by using analysis and auditing tools, collaborating with workgroups, and using data from the internet and other sources.
- 6. Prepare advanced database tables, forms, queries and reports by modifying a tables design, creating and modifying forms, refining queries, and creating and modifying reports.
- 7. Automate, Secure and Integrate databases by defining relationships and establishing referential integrity, assigning user-level security, encrypting and decrypting a database, creating modules using Visual Basic Routines, and using data from the internet and other sources.
- 8. Create and Format presentations.
- 9. Customize and enhance presentations by adding visual elements, sharing and connecting data, linking and embedding objects and files, sharing presentations, and broadcasting a presentation online.
III: Course LinkageThis course fulfills a degree requirement in the Computer Tehnology-Office Techonology Associate of Applied Science Degree and may be chosen as an elective in the General Business Associate of Applied Science degree. The mission of the Associate of Applied Science degree in business is to provide knowledge and skills necessary to succeed in the current business environment. This course addresses the following AAS degreee student learning outcomes: Students are expected to:
- Understand the computer applications subject matter.
- Demonstrate an understanding of computer applications in the larger business/office environment.
- Understand the legal and ethical aspects of working with computer applications