Majors in Computer Applications:
See also Web Careers & Gaming
Computer Applications A.A.S. 311
Revised: Effective Semester - Summer 2007
The Computer Applications program is for students who want to use the computer as a tool of productivity. The General Education courses, in conjunction with specialized courses, provide a broad foundation and sharpen students' skills in preparation for entry into or advancement in today's workplace.
This curriculum, following the database systems track, provides training, skills, and knowledge that prepare students for employment as entry-level database programmers and designers; or provides current professionals with essential database programming and design skills. Students will create Microsoft Access and Web database applications as well as write database user interfaces in the Visual Basic.Net environment.
This curriculum, following the information technology track, prepares students for a wide variety of positions involving the use of application software. Job possibilities include support in the areas of accounting, finance, marketing, sales, administration, and any area that requires the use of computer applications as a necessary tool of production. Emphasis is placed on the proficient use of software applications as well as the ability to use those applications as tools in decision making, managing people and information, communicating effectively, enhancing company viability and addressing many of today's technology challenges. This track provides students with in-depth knowledge in more than one application area and has the potential to lead to Microsoft certification in those areas.
The computer applications program participates in an interdisciplinary Web Careers program, which includes an A.A.S. and four certificate curricula.
In addition, an AA. in computer gaming is offered with three specialized tracks see Gaming for more information.
| General Education Requirements |
| Foundation Courses |
|
|
|
English foundation |
3 |
| |
Health foundation |
1 |
| |
Mathematics foundation |
3 |
| |
Speech foundation |
3 |
| Distribution Courses |
|
|
|
Arts or humanities distribution |
3 |
| |
Behavioral and social sciences distribution |
3 |
| |
Natural sciences lab distribution |
4 |
| Database Systems Track: 311E (37-38 credit hours) |
| CA 106 |
Computer Use and Management |
3
|
| CA 141 |
Introduction to Database Applications |
3
|
| CA 240 |
Advanced Database Applications |
3 |
| CA 272 |
Professional Web Site Development |
4 |
CA 278
|
Web Application Development Using ColdFusion |
4 |
| CA 282 |
Web Application Development Using PHP and My SQL |
|
or |
|
|
| CA 288 |
Advanced Web Application Development Using ColdFusion |
3
|
| CS 140 |
Introduction to Programming |
3
|
| CS 215 |
Visual Basic Programming |
3
|
| EN 101 |
Techniques of Reading and Writing I* |
3 |
|
Electives: Select 11-12 credits from CA and CS courses |
|
|
Total credit hours for database systems track |
60 |
* EN 101 if needed for EN 102/109 or general elective
Program Outcomes for Database Systems Track
Upon completion of this program a student will be able to:
- Describe the advantages, disadvantages, and appropriates uses of various database management systems (DBMS).
- Design a database system based on user requirements.
- Create entity-relationship diagrams that accurately describe a database structure.
- Understand and successfully utilize basic database design concepts such as primary and foreign keys, normalizing, bridge tables, alternate primary keys, and strong versus weak entities.
- Create a database system that successfully fulfills an organization’s data requirements.
- Apply appropriate problem-solving methodologies to the analysis and solution of related problems.
- Communicate effectively using oral and written techniques.
| Information Technology Track: 311B (37-38 credit hours) |
| CA 106 |
Computer Use and Management |
3 |
| CA 120 |
Introduction to Computer Applications |
3 |
| CA 141 |
Introduction to Database Applications |
3 |
| CA 232 |
Word Processing Applications |
3 |
| CA 252 |
Spreadsheet Applications |
3 |
| CA 272 |
Professional Website Development |
4 |
| EN 101 |
Techniques of Reading and Writing I* |
3 |
|
Electives: Select 18-19 credits from any AC 201, AC 202, BA, CA, CS, EC, GD, MG |
|
Total credit hours for information technology track |
60 |
* EN 101 if needed for EN 109/109 or general elective
Program Outcomes for Information Technology Track
Upon completion of this program a student will be able to:
- Apply file management skills effectively.
- Locate information on the Web with proficiency.
- Send an email with a suitable subject line and an attachment.
- Create a word processed document demonstrating the use of formatting, page setup, editing, printing, mail merge.
- Create a spreadsheet demonstrating the use of formatting, editing, calculating, charting, page setup, and printing.
- Create a presentation demonstrating the use of presentation techniques, layouts, formatting, editing, printing, clip art, WordArt, transitions, and animation.
- Create a database demonstrating the use of table, query, simple report, simple form, and printing.
- Design and upload a home page containing header, body with links, and animation.
Back to top
Database Systems Certificate: 238
New: Effective Semester — Summer 2007
This certificate curriculum provides training, skills, and knowledge that prepare students for employment as entry-level database programmers and designers or provides current professionals with essential database programming and design skills.
Students will create Microsoft Access and Web database applications as well as write database user interfaces in Visual Basic.Net.
| CA 106 |
Computer Use and Management |
3 |
| CA 141 |
Introduction to Database Applications |
3 |
| CA 240 |
Advanced Database Applications |
3 |
| CA 272 |
Professional Website Development |
4 |
| CA 278 |
Web Application Development Using ColdFusion |
4 |
| CA 282 |
Web Application Development Using PHP and MySQL |
|
or |
|
|
| CA 288 |
Advanced Web Application Development Using Cold Fusion |
3 |
| CS 140 |
Introduction to Programming |
3 |
| CS 215 |
Visual Basic Programming |
3 |
Total credit hours 26 |
Program Outcomes for the Database Systems Certificate
Upon completion of this program a student will be able to:
- Describe the advantages, disadvantages, and appropriate uses of various database management systems (DBMS).
- Design a database system based on user requirements.
- Create entity-relationship diagrams that accurately describe a database structure.
- Understand and successfully utilize basic database design concepts such as primary and foreign keys, normalizing, bridge tables, alternate primary keys, and strong versus weak entities.
- Create a database system that successfully fulfills an organization’s data requirements.
Back to top
Gainful Employment Disclosure
Institution OPEID: 006911
Program CIP: 11.0601
Program Length: 3 semesters (this does not include time for developmental or AELP courses)
Related Occupations: Database Architects
Cost:
- Cost for entire program completed in 3 semesters: $3,796
- Total estimated costs for books and supplies for the entire program: $1,200
- More cost information
Montgomery College does not offer on-campus housing
Debt at Program Completion:
Between July 1, 2011 and June 30, 2012:
- 8 students completed this program; 2 of them had student loan debt upon completing the program
- Median cumulative debt for all students (both borrowers and non-borrowers):
$4,750 Federal student loan debt
$0 Private loan debt
Program Completion in Normal Time: 0 of 8 students completed the program within 3 semesters
Job Placement: This program is not required to collect job placement information by the college's accrediting agency. This information will be updated as it becomes available.
Back to top
Revised: Effective — Summer 2007
This certificate curriculum is for the career professional who needs to become more proficient at using today's popular software applications as tools in decision making, managing people and information, communicating effectively, enhancing company viability, and addressing today's many technology challenges.
| CA 106 |
Computer Use and Management |
3 |
| CA 120 |
Introduction to Computer Applications |
3 |
| CA 141 |
Introduction to Database Applications |
3 |
| CA 232 |
Word Processing Applications |
3 |
| CA 252 |
Spreadsheet Applications |
3 |
| CA 272 |
Professional Website Development |
4 |
Total credit hours 19 |
Program Outcomes for the Information Technology Certificate
Upon completion of this program a student will be able to:
- Apply file management skills effectively.
- Locate assigned information on the Web with proficiency.
- Send an email with a suitable subject line and an attachment.
- Create a word processed document demonstrating the use of formatting, page setup, editing, printing, and mail merge.
- Create a spreadsheet demonstrating the use of formatting, editing, and calculating with appropriate functions and formulas, charting, page setup, and printing.
- Create a presentation demonstrating the use of presentation techniques, layouts, formatting, editing, printing, clip art, WordArt, transitions, and animation.
- Create a database demonstrating the use of tables, queries, simple reports, and simple forms.
- Design and upload a home page containing header, body with links, and images.
- Demonstrate an understanding of the vocabulary of information technology.
Back to top
Gainful Employment Disclosure
Institution OPEID: 006911
Program CIP: 11.0301
Program Length: 2 semesters (this does not include time for developmental or AELP courses)
Related Occupations: Computer Operators
Cost:
- Cost for entire program completed in 2 semesters: $2,774
- Total estimated costs for books and supplies for the entire program: $1,000
- More cost information
Montgomery College does not offer on-campus housing
Debt at Program Completion:
Between July 1, 2011 and June 30, 2012:
- 8 students completed this program; 0 of them had student loan debt upon completing the program
- Median cumulative debt for all students (both borrowers and non-borrowers):
$0 Federal student loan debt
$0 Private loan debt
Program Completion in Normal Time: 0 of 8 students completed the program within 2 semesters
Job Placement: This program is not required to collect job placement information by the college's accrediting agency. This information will be updated as it becomes available.
Back to top
Refer to course description pages to identify courses with prerequisites.
Courses in italics meet General Education requirements.