CSE 1112
Transcript Abbreviation:
Intr Computng CSM
Course Description:
Using productivity software, especially spreadsheets and databases, to solve problems for construction management; relative/absolute cell referencing, logic, functions; relational databases, querying, project integration.
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:
(N/A)
Electronically Enforced:
No
Exclusions:
Not open to students with credit for 1111 (101), 1113, 105, or 200.
Course Goals / Objectives:
Be familiar with computer basics: hardware, software, OS, and communications, including how the internet works
Be familiar with designing and testing spreadsheets to aid in estimating all aspects of construction costs by using spreadsheet features including relative/absolute cell referencing, boolean logic, reference functions, and financial functions
Be familiar with basic concepts of a relational database, with setting up a basic relational database including input and output forms, with writing queries to obtain needed information, and with developing reports
Be familiar with linking of spreadsheets, databases, word processing, and presentation software to automate the development of reports and presentations
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 | 2.0 | 0.0 | 0 | 2.5 | 0 |
| Excel - writing formulas using simple functions and relative/absolute cell addressing; boolean functions; LOOKUP function; financial functions; charts | 10.0 | 0.0 | 0 | 8.0 | 0 |
| Access; database features of Excel | 6.0 | 0.0 | 0 | 3.0 | 0 |
| Powerpoint; object linking; Word, including mail merge | 2.0 | 0.0 | 0 | 4.0 | 0 |
| How the internet works and how to create a simple webpage | 2.0 | 0.0 | 0 | 1.0 | 0 |
| Total | 22 | 0 | 0 | 18.5 | 0 |
Grading Plan:
Letter Grade
Course Components:
Lecture
Lab
Grade Roster Component:
Lecture
Credit by Exam (EM):
No
Grades Breakdown:
| Aspect | Percent |
|---|---|
| Labs | 20% |
| Homework | 12% |
| Class participation | 2% |
| Pop quizzes | 6% |
| Midterm | 20% |
| Final project | 10% |
| Final exam | 30% |
Representative Textbooks and Other Course Materials:
| Title | Author | Year |
|---|---|---|
| Series for Microsoft Office Bundle Including SAM Software | Shelly Cashman |
ABET-CAC Criterion 3 Outcomes:
| Significant contribution (7+ hours) | 1 | Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. |
| Substantial contribution (3-6 hours) | 2 | Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. |
| Some contribution (1-2 hours) | 3 | Communicate effectively in a variety of professional contexts. |
| Some contribution (1-2 hours) | 4 | Recognize professional responsibilities and make informed judgments in computing practice based on legal and ethical principles |
| Substantial contribution (3-6 hours) | 6 | Apply computer science theory and software development fundamentals to produce computing-based solutions. |
ABET-ETAC Criterion 3 Outcomes:
(N/A)
ABET-EAC Criterion 3 Outcomes:
| No outcome selected |
Embedded Literacies Info: