CSE 1113
Transcript Abbreviation:
Spreadsheet Progrg
Course Description:
Spreadsheet modeling/programming concepts and techniques to solve business 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):
1.00
Max Credit Hours:
1.00
Select if Repeatable:
Off
Maximum Repeatable Credits:
(N/A)
Total Completions Allowed:
(N/A)
Allow Multiple Enrollments in Term:
No
Course Length:
7 weeks (autumn or spring)
14 weeks (autumn or spring)
12 weeks (summer only)
Off Campus:
Never
Campus Location:
Newark
Marion
Mansfield
Lima
Columbus
Instruction Modes:
In Person (75-100% campus; 0-24% online)
Prerequisites and Co-requisites:
Prereq: Math 1130 (130) or above.
Electronically Enforced:
No
Exclusions:
Not open to students with credit for 1111 (101), 1112 (105), 2111, or 200.
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.
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 |
|---|---|---|---|---|---|
| Course intro & spreadsheet basics - entering/editing data, formatting, filling a series | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Writing formulas, order of precedence, precision vs. display, Relative/absolute referencing | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Using functions:simple - SUM, MIN, MAX, COUNT, COUNTA, STD.DEV.,MEDIAN, MODE, | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Functions requiring multiple arguments: ROUND, COUNTIF, SUMIF, LARGE, SMALL, RANK, SUMPRODUCT, PERCENTILE, QUARTILE | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Using multiple worksheets, working with large spreadsheets (split screen, freeze panes, What-if Analysis & Goal Seek | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Date/Time Functions | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Boolean logic: Relational Operators, AND, OR, NOT functions | 1.0 | 0.0 | 0 | 0.0 | 0 |
| IF functions | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Reference Functions (vlookup, hlookup) | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Solving Larger Problems - Nesting formulas & Modeling Spreadsheet Solutions | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Formula Auditing, Evaluate Formula tool, Calculation Options & other error checking | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Database Concepts - Using Excel as a database: sort, filter, Subtotals, Data Tables, Pivot Tables | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Importing & Exporting Data (csv), Embedding & Linking data, transposing data, Inserting symbols. Scenario Manager, Data Analysis Tools, Macros (other features) | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Total | 13 | 0 | 0 | 0 | 0 |
Grading Plan:
Letter Grade
Course Components:
Lecture
Grade Roster Component:
Lecture
Credit by Exam (EM):
Yes
Grades Breakdown:
| Aspect | Percent |
|---|---|
| Spreadsheet programming lab assignments (done out of class) | 20% |
| Midterm | 30% |
| Final | 50% |
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: