DRFT 116 - Technology Applications with Excel

1 Credits: (1 lecture, 1 lab)

Course Description
This course introduces the study of microcomputer programming in Microsoft Excel. Programming assignments emphasize technical applications. Industrial problems that require technical computer programming solutions are incorporated in the programming assignments whenever possible. This course meets the General Education competencies of Technological Competence (TC) and Critical Thinking (CT).

Note Fall semester only.

Corequisite MATH 101 or MATH 117 or permission of the instructor.

Text
Gottfried, B.S. (2019). Spreadsheet tools for engineers using Excel (4^th ed.). New York, NY: McGraw-Hill.

Objectives
The student will be able to:

A. Identify problems that can be effectively solved through Excel. (TC) (CT)

B. Create charts and graphs from raw data. (CT)

C. Perform basic statistical analysis of data. (CT)

D. Apply Excel to make logical decisions. (CT)

E. Perform unit conversions. (CT)

F. Arrange data by sorting and filtering. (CT)

G. Utilize technology to receive and transmit data. (TC)

Content
A. Fundamentals

B. Graphing

C. Statistical analysis

D. Data modeling

E. Data sorting and filtering

F. Data transfer

G. Unit conversion

H. Logical if-then-else operators

Student Evaluation
Objectives A, B, C, D, E, F, and G may be evaluated using a combination of homework, examinations, and a comprehensive final examination. The comprehensive final must be worth at least 20% of each student’s final grade.