CSE 2111
Transcript Abbreviation:
Spreadsheets & DBs
Course Description:
Spreadsheet and database modeling/programming concepts and techniques to solve business related problems; efficient/effective data handling, computational analysis and decision support. Additional topics: computer concepts, networking, project integration.
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:
3.00
Select if Repeatable:
Off
Maximum Repeatable Credits:
3.00
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:
Wooster (ATI)
Newark
Marion
Mansfield
Lima
Columbus
Instruction Modes:
In Person (75-100% campus; 0-24% online)
Prerequisites and Co-requisites:
Prereq: Math 1130 or above, or Math Placement Level L.
Electronically Enforced:
No
Exclusions:
Not open to students with credit for 1111 or 1112.
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 basic concepts of computing, components of a computer, and concepts of how the internet works.
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 Mathematical and Logical Analysis: Students comprehend mathematical concepts and methods to construct valid arguments, understand inductive and deductive reasoning, and increate general problem solving skills.
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 |
|---|---|---|---|---|---|
| Introduction to Computing - hardware, software, operating system | 2.0 | 0.0 | 0 | 1.0 | 0 |
| Spreadsheet Basics - creating a simple spreadsheet, relative/absolute cell referencing, using functions, using multiple worksheets; simple data analysis | 5.0 | 3.0 | 0 | 3.0 | 0 |
| Decision Making with Spreadsheets - using Boolean logical operators/functions | 2.0 | 1.0 | 0 | 1.0 | 0 |
| Financial and Date Functions - solving problems with variable inputs, financial and date computations using reference | 3.0 | 1.0 | 0 | 2.0 | 0 |
| Programming/Modeling - using spreadsheets and formula auditing for complex problems | 1.0 | 1.0 | 0 | 1.0 | 0 |
| Introduction to Databases - theory and use of MS Access | 2.0 | 0.0 | 0 | 1.0 | 0 |
| Writing Queries in Access - select queries, sorting, aggregating, writing expressions, using inner and outer joins | 3.0 | 2.0 | 0 | 2.0 | 0 |
| Summarizing Data - using data with many-to-many relationships and advanced querying techniques | 1.0 | 1.0 | 0 | 0.5 | 0 |
| Using MS PowerPoint - displaying data from Excel and Access; Object Linking and Embedding | 1.0 | 0.0 | 0 | 0.5 | 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 | 3.0 | 1.0 | 0 | 1.0 | 0 |
| Additional Topics - MS Office integration using MS Word mailmerge; lifelong learning; finding information on new/unknown tools in computing | 1.0 | 0.0 | 0 | 0.5 | 0 |
| Basics of Computer Networking - WWW architecture and protocols, and writing your own webpage | 2.0 | 0.0 | 0 | 0.5 | 0 |
| Total | 26 | 10 | 0 | 14 | 0 |
Grading Plan:
Letter Grade
Course Components:
Lecture
Lab
Grade Roster Component:
Lecture
Credit by Exam (EM):
Yes
Grades Breakdown:
| Aspect | Percent |
|---|---|
| Labs | 20% |
| Exams | 40% |
| Final | 40% |
Representative Textbooks and Other Course Materials:
| Title | Author | Year |
|---|---|---|
| Course notes, Custom text | D. Gross |
ABET-CAC Criterion 3 Outcomes:
(N/A)
ABET-ETAC Criterion 3 Outcomes:
(N/A)
ABET-EAC Criterion 3 Outcomes:
(N/A)
Embedded Literacies Info: