ITEC 363: Integration of Software
Prerequisite: ITEC 100
Credit Hours: (3)
This course is designed to provide students with advanced microcomputer applications skills in word processing, spreadsheets, databases, and multi-media presentations. Major emphasis is placed on the integration of software packages to complete business applications.
Detailed Description of Content of the Course
The course takes an integrated software approach to solving business applications using word processing, spreadsheet, database, and multi-media presentation software. Specific topics to be addressed may include but not limited to:
- Business Communication Topics
- Mail merges including labels/envelopes for mailing
- Desktop publishing
- Web page development
- Business Presentation Topics
- Multi-media tools (graphics, sound, video)
- Presentation planning and development
- Interactive presentation planning and development
- Data Management and Analysis Topics
- 3-D spreadsheet models
- Data management and analysis (database functions)
- Look-up tables (look-up functions)
- Relational database tables
- Queries, forms, and reports using multiple database tables
Detailed Description of Conduct of Course
The conduct of the course includes: lecture and demonstration by instructor, hands-on participation by the students, individual and group student presentations, and lectures and demonstrations by guest speakers.
Goals and Objectives of the Course
After completing the course, students are able to integrate word processing, spreadsheet, database, and multi-media presentation software to: prepare bulk mailings with labels/envelopes; develop newsletters, brochures, flyers, and other desktop publishing materials; design, create, and publish
web pages; plan, develop, and present business presentations using multi-media tools; develop 3-D spreadsheet models to manage and analysis business data; perform data management and analysis using database functions; create and maintain look-up tables using horizontal and vertical look-up functions; create charts/graphs from existing spreadsheet data; design, create, and maintain relational database tables; and generate queries, forms and reports using multiple database tables.
Student assessment is based on the following: objective testing of theory, hands-on individual and group student projects, and individual and group student presentations.
Other Course Information
A number of students have requested software training beyond the level that is currently provided at the freshman level.
Review and Approval
Sept. 25, 2001 Updated John P. Helm, Chair
Revised: June 1, 2012