CSE 1114
Transcript Abbreviation:
DBIntroWithAccess
Course Description:
Database concepts and techniques for 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.50
Max Credit Hours:
1.50
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, 1112, or 2111.
Course Goals / Objectives:
Be familiar with concepts of relational databases.
Be familiar with solving problems using MS 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 familiar with using MS Access to create data tables, reports, and forms.
Be competant using macros.
Be exposed to SQL.
Be exposed to tools that facilitate lifelong learning of technology.
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 |
|---|---|---|---|---|---|
| Relational database management systems | 1.0 | 0.0 | 0 | 1.0 | 0 |
| Table Design, including primary/foreign keys, and referential data integrity | 3.0 | 0.0 | 0 | 3.0 | 0 |
| Table Relationships (inner and outer joins) | 3.0 | 0.0 | 0 | 3.0 | 0 |
| Use the query tool to find/organize information | 3.0 | 0.0 | 0 | 3.0 | 0 |
| Access Macros | 1.0 | 0.0 | 0 | 1.0 | 0 |
| SQL | 1.0 | 0.0 | 0 | 0.0 | 0 |
| Forms and Reports | 2.0 | 0.0 | 0 | 2.0 | 0 |
| Total | 14 | 0 | 0 | 13 | 0 |
Grading Plan:
Letter Grade
Course Components:
Lecture
Lab
Grade Roster Component:
Lecture
Credit by Exam (EM):
No
Grades Breakdown:
| Aspect | Percent |
|---|---|
| Homework Assignments | 15% |
| Lab Assignments | 25% |
| Midterm Exam | 20% |
| Class Attendance and Participation | 10% |
| Final Exam | 30% |
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:
(N/A)
Embedded Literacies Info: