CSE 1111
Transcript Abbreviation:
Intr Cmp Prob Solv
Course Description:
Problem solving techniques using productivity software; spreadsheets, formulas, conditional logic; relational databases, relational algebra; word processing; data presentation; graphics.
Course Levels:
Undergraduate (1000-5000 level)
Designation:
Elective
General Education Course
General Education Course:
Foundations
Mathematical and Quantitative Reasoning (or Data Analysis)
Cross-Listings:
(N/A)
Credit Hours (Minimum if “Range”selected):
3.00
Max Credit Hours:
(N/A)
Select if Repeatable:
Off
Maximum Repeatable Credits:
(N/A)
Total Completions Allowed:
(N/A)
Allow Multiple Enrollments in Term:
No
Course Length:
14 weeks (autumn or spring)
12 weeks (summer only)
Off Campus:
Never
Campus Location:
Columbus
Lima
Mansfield
Marion
Newark
Wooster (ATI)
Instruction Modes:
In Person (75-100% campus; 0-24% online)
Hybrid Class (25-74% campus; 25-74% online)
Prerequisites and Co-requisites:
(N/A)
Electronically Enforced:
No
Exclusions:
Not open to students with credit 1112 (105), 1113 (101), or 200.
Course Goals / Objectives:
Be familiar with computer basics - hardware, software, OS, and communications
Be familiar with using spreadsheets to solve problems - including relative/absolute cell referencing, Boolean logic, reference functions, and financial functions
Be familiar with basic concepts of a relational database and use querying tools to obtain needed data
Be familiar with using and integrating word processing and presentation graphics tools
Be familiar with basic concepts about how the internet works
Be familiar with applying computational skills to problems involving algebra and geometry in practical situations (i.e., direct contribution to the learning goals and objectives in the GE quantitative and logical skills category)
Check if concurrence sought:
No
Contact Hours:
| Topic | LEC | REC out-of-class | REC in-class | Weekly LAB out-of-class | Weekly LAB in-class |
|---|---|---|---|---|---|
| Computer basics | 1.5 | 0.0 | 0 | 1.5 | 0 |
| Excel - writing formulas using simple functions and relative/absolute cell addressing | 1.5 | 0.0 | 0 | 1.5 | 0 |
| Excel - using Boolean logical functions - AND,OR, NOT, IF | 4.0 | 0.0 | 0 | 3.0 | 0 |
| Excel - Solving problems using multiple worksheets | 2.0 | 0.0 | 0 | 1.5 | 0 |
| Excel - using a LOOKUP function, using financial functions, charts. | 4.0 | 0.0 | 0 | 4.0 | 0 |
| Understanding relational database concepts; Access; | 5.0 | 0.0 | 0 | 4.0 | 0 |
| Powerpoint, object linking; Word, mail merge; | 3.0 | 0.0 | 0 | 3.0 | 0 |
| How the Internet works; simple webpages. | 1.0 | 0.0 | 0 | 1.0 | 0 |
| Total | 22 | 0 | 0 | 19.5 | 0 |
Grading Plan:
Letter Grade
Course Components:
Lecture
Lab
Grade Roster Component:
Lecture
Credit by Exam (EM):
No
Grades Breakdown:
| Aspect | Percent |
|---|---|
| Lab assignments | 20% |
| Homeworks | 12% |
| Class participation | 2% |
| Pop quizzes | 6% |
| Midterm | 20% |
| Final project | 10% |
| Final exam | 30% |
Representative Textbooks and Other Course Materials:
| Title | Author | Year |
|---|---|---|
| Shelly Cashman Series for Microsoft Office Bundle Including SAM Software | Shelly Cashman |
ABET-CAC Criterion 3 Outcomes:
| No outcome selected |
ABET-ETAC Criterion 3 Outcomes:
(N/A)
ABET-EAC Criterion 3 Outcomes:
| Significant contribution (7+ hours) | 1 | an ability to identify, formulate, and solve complex engineering problems by applying principles of engineering, science, and mathematics |
| Substantial contribution (3-6 hours) | 2 | an ability to apply engineering design to produce solutions that meet specified needs with consideration of public health, safety, and welfare, as well as global, cultural, social, environmental, and economic factors |
| Some contribution (1-2 hours) | 3 | an ability to communicate effectively with a range of audiences - pre-2019 EAC SLO (g) |
| Some contribution (1-2 hours) | 4 | an ability to recognize ethical and professional responsibilities in engineering situations and make informed judgments, which must consider the impact of engineering solutions in global, economic, environmental, and societal contexts |
| Substantial contribution (3-6 hours) | 6 | an ability to develop and conduct appropriate experimentation, analyze and interpret data, and use engineering judgment to draw conclusions |
| Some contribution (1-2 hours) | 7 | an ability to acquire and apply new knowledge as needed, using appropriate learning strategies |
Embedded Literacies Info: