CSE 2112
Transcript Abbreviation:
Spreadsheet&DB4Eng
Course Description:
Spreadsheet and database modeling/programming concepts and techniques to solve business and engineering related problems; efficient/effective data handling, computational analysis and decision support.
Course Levels:
Undergraduate (1000-5000 level)
Designation:
Elective
General Education Course:
(N/A)
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
Instruction Modes:
In Person (75-100% campus; 0-24% online)
Prerequisites and Co-requisites:
Prereq: 1222, 1223, 1224, Engr 1281.01H, or 1281.02H. Prereq or concur: Math 1151, 1161.01, or 1161.02.
Electronically Enforced:
No
Exclusions:
Not open to students with credit for 1111, 1112, 1113, or 2111.
Course Goals / Objectives:
Be competent with programming spreadsheets by appropriately using simple and nested functions, including logical and numerical functions, basic statistical functions, time and date functions, and table lookup functions.
Be competent with designing/engineering spreadsheets to minimize errors in construction and modification, including appropriately using relative/absolute cell referencing.
Be competent with aggregating and summarizing multivariate data sets, including both numerical and categorical variables.
Be competent with importing into spreadsheets from large data sets in text format and with more than one data source.
Be competent with applying sound spreadsheet engineering principles in business contexts such as pro forma income and balance sheets, basic analysis of large data sets, and fundamental computations for financial, marketing, and operational analysis.
Be competent with using spreadsheets to effectively communicate their purpose and process, both on the computer and on paper.
Be competent with using spreadsheets to effectively communicate results using appropriate numerical and graphical tools.
Be familiar with concepts of relational databases.
Be familiar with using MS Access to create data tables, simple reports, and forms.
Be competent with solving problems using Access Query tools including selection queries, sorts, aggregation, calculations, inner/outer joins, and situations with datasets containing many-to-many relationships using multiple queries.
Be exposed to tools that facilitate lifelong learning of technology.
General Education overall goal statement: Students develop skills in quantitative literacy and logical reasoning including ability to identify valid arguments, use mathematical models, draw conclusions and critically evaluate results based on data.
General Education goal statement for Basic Computational Skills: Students demonstrate computational skills and familiarity with algebra and geometry, and apply these skills to practical problems.
General Education goal statement for Mathematical and Logical Analysis: Students comprehend mathematical concepts and methods to construct valid arguments, understand inductive and deductive reasoning, and increase general problem solving skills.
General Education goal statement for Data Analysis: Students understand basic concepts of statistics and probability, comprehend methods needed to analyze and critically evaluate statistical arguments, and recognize importance of statistical ideas.
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 |
|---|---|---|---|---|---|
| Spreadsheet Design, IF and Boolean Functions, Scenario Manager and Goal Seek | 3.0 | 0.0 | 0 | 3.0 | 0 |
| More Boolean function options, calculations and reference functions. | 3.0 | 0.0 | 0 | 3.0 | 0 |
| Excel Solver, Pivot tables, graphing | 2.0 | 0.0 | 0 | 2.0 | 0 |
| Excel Statistical functions, Date functions, Text Functions and Data validation techniques | 3.0 | 0.0 | 0 | 3.0 | 0 |
| Programming in Excel VBA | 3.0 | 0.0 | 0 | 3.0 | 0 |
| Introduction to Database Design | 1.0 | 0.0 | 0 | 1.0 | 0 |
| Writing Queries in Access - select queries, sorting, aggregating, writing expressions, using inner and outer joins. | 3.0 | 0.0 | 0 | 3.0 | 0 |
| Summarizing Data - using data with many-to-many relationships and advanced querying techniques. | 1.0 | 0.0 | 0 | 1.0 | 0 |
| Access Forms and Reports, Macros, and Programming in Access | 5.0 | 0.0 | 0 | 5.0 | 0 |
| Using Excel as a Database - importing data, Excel data tables, filtering, sorting, subtotals, pivot tables; using text functions to manipulate data; advanced Excel tools: scenario manager, data analysis tools, and macros. | 2.0 | 0.0 | 0 | 2.0 | 0 |
| Total | 26 | 0 | 0 | 26 | 0 |
Grading Plan:
Letter Grade
Course Components:
Lecture
Lab
Grade Roster Component:
Lecture
Credit by Exam (EM):
No
Grades Breakdown:
| Aspect | Percent |
|---|---|
| Homework and In-Class Assignments | 15% |
| Lab Assignments | 25% |
| Quizzes (2@10% each) | 20% |
| Midterm Exam | 20% |
| Final Exam | 20% |
Representative Textbooks and Other Course Materials:
| Title | Author | Year |
|---|---|---|
| No Textbooks and Other Course Materials Entered. | ||
ABET-CAC Criterion 3 Outcomes:
(N/A)
ABET-ETAC Criterion 3 Outcomes:
(N/A)
ABET-EAC Criterion 3 Outcomes:
| Some contribution (1-2 hours) | 1 | an ability to identify, formulate, and solve complex engineering problems by applying principles of engineering, science, and mathematics |
| Some contribution (1-2 hours) | 6 | an ability to develop and conduct appropriate experimentation, analyze and interpret data, and use engineering judgment to draw conclusions |
Embedded Literacies Info: