EMBRY-RIDDLE AERONAUTICAL UNIVERSITY
Orlando Center
Course Outline for
Course No. MGMT 221 Title
Advanced Computer Based Systems Cr.
Hrs: 3
Lecture Hours: 45 Laboratory Hours: 0
Instructor: Kenyon Johnson Email: instructor@kenyonjohnson.com
*Please
place MGMT 221 in subject line
COURSE DESCRIPTION:
This course is a continuation of BA 120.
It covers advanced concepts of spreadsheet use, database management systems,
and presentation graphics. Students
perform macro and command language programming in applications packages. In addition, the course provides experience
in locating and retrieving graphical and text-based information from the
Internet to support management activities.
Prerequisite:
Computer Skills
GOALS:
This course is a required course for the
AS and BS degree program in Aviation Business Administration, the BS degree
program in Aviation Maintenance Management (AMT), the BS degree program in
Management of Technical Operations, and an elective course in degree programs
permitting open electives at the 200 level.
The course is designed to provide
students with hands-on experience in the use of
relatively complex spreadsheet and database applications in
various business areas, with emphasis on the aviation/aerospace industry. In addition to providing a framework for
using the structured concepts in analyzing, designing, and programming end-user
applications, students will learn
concepts that are useful in choosing the best alternatives from among competing
design methodologies. Use of the
Internet for business research and communication is emphasized.
LEARNING OUTCOMES:
Upon course completion, students will be
able to:
1. Use
advanced structured spreadsheet design techniques, and to prepare appropriate
documentation and descriptive information.
2. Automate
the entry, update, and deletion of spreadsheet data, and the preparation of
required reports, through the use of spreadsheet macros.
3. Design
and create a complex database, using appropriate techniques for naming files
and fields, typing data, and creating and modifying the file structure.
4. Add,
modify and delete database records; compose queries correctly; and exchange
data with spreadsheet models of aviation/aerospace business operations.
5. Use
a report generator to produce meaningful reports based on queries of the database.
6. Design
and produce graphic presentation material from data contained in spreadsheets
and database management systems to illustrate and explain business management issues
and operations.
7. Use
the Internet to communicate with others and to obtain graphic and textual
information for business presentations.
NOTE
ON LIBRARY USE: The Jack
R. Hunt Library, located on the Daytona Beach Campus is the primary library for
all Extended Campus students. The Dean of Academics strongly recommends that
every faculty member, where appropriate, make it a requirement for all students
in their class to access the Hunt Library or a comparable college-level local
library and perform research. The results of this research can be used for
class projects such as research papers, group discussion, or individual
presentations. The important thing is getting our students to access the
library. The Internet address for the Hunt Library is: http://amelia.db.erau.edu/
NOTE: Written and oral
communications, aviation applications of subject matter, and computer skills
are emphasized in each course offered throughout the Extended Campus.
MGMT/BA 221
New Perspectives on
Computers, Brief
5th
Ed., 2003 (Parsons/Course Technology)
ISBN:
0-619-100354
and
2000,
(Author/ Course Technology)
2000,
(Author/ Course Technology)
Course
Kit ISBN: 0-619-027797
SUPPLEMENTAL MATERIALS:
1. Reference
publications/supplemental readings on reserve in the Library or provided as
handouts.
2. Audio-Visual
materials available in the Library.
3. Personal
computers and appropriate computer software are provided for student use in
labs.
TOPICS:
1. Review
of basic concepts.
Review of basic DOS and Windows commands,
and of word processor and spreadsheet
commands and functions. Review of
concepts of using spreadsheet macros, such as naming, executing, and
documenting; review use of appropriate logical constructs, subroutines, and
structured and modular concepts in macro development.
3 class hours
2. Database
concepts
Define, describe, and apply concepts of
using database management systems, including file creation, normalization,
development of relatively complex queries using a database software.
15 class hours
3. Define,
describe, and apply concepts of using presentation graphics in developing
business presentations, including selection of appropriate color schemes, page
layouts, text font sizes and styles, placement of charts and tables, use of
graphics, and presentation of computer “screen shows”.
10 class hours
4. Concepts
of the Internet
Experience and practice in accessing the
Internet, using various search engines,
using e-mail, telnet and ftp (file transfer protocol) commands
effectively, and using World-Wide Web
browser software.
9 class hours
5. Complete
a project using the Internet to research and retrieve aviation/aerospace information for an oral,
group presentation. (aviation related)
3 class hours
GRADING SYSTEM:
Midterm 25%; Presentation 10%;
Homework 40%; Final Exam 25%.
90-100%........ A
80-90%.......... B
70-80%.......... C
60-70%.......... D
Below 60%..... F
SCHEDULE:
|
Date |
Lecture |
Assignment |
|
3/20/03 |
Computer Concepts & Introduction to
Office 2000 |
|
|
3/27/03 |
Microsoft Word 2000 Part I |
Word Lab |
|
4/3/03 |
Microsoft Word 2000 Part II |
|
|
4/10/03 |
Microsoft Powerpoint 2000 |
Powerpoint Lab / |
|
4/17/03 |
Mid-Term Exam (25%) |
Word Lab Due (10%) |
|
4/24/03 |
Microsoft Excel |
Excel Lab / Powerpoint Lab Due (10%) |
|
5/01/03 |
|
Aviation Oral Presentation (10%) |
|
5/08/03 |
Microsoft Access 2000 |
Access Lab / Excel Lab Due (10%) |
|
5/15/03 |
Final Exam (25%) |
Access Lab Due (10%) |