CSC210SU2021Syllabus

From BU Computer Science
Revision as of 16:45, 5 April 2021 by Cathy.bareiss (talk | contribs) (Created page with "{{:CSC210ForSyllabus}} ==Details== * Professor: Dr. Cathy Bareiss * Office SB 027 * Class Time: Online * Class Location: Online * Textbook: ==Course Content== ===Policies...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

CSC 210: Database 3 hours.

Description

A course introducing the student to the principles and practices of data base management and database design. Topics will include relational database design, normalization, SQL queries, reports and other interfaces to database data, and documentation, as well as ethical and privacy issues associated with database systems. Three lectures a week. Prerequisite: CSC 102, CSC 121, ITSC 121, or permission of the instructor.

Goals for CSC 210 are:

To be determined

Course outcomes for CSC 210 are:

Upon completion of CSC 210, students will understand:

  • how to write complex SQL queries
  • how to design and implement quality databases
  • security issues associated with database technologies
  • ethical issues associated with database technologies
  • improved testing techniques

Program outcomes for CSC 210 are:

  1. Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions.
  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.
  3. Communicate effectively in a variety of professional contexts.
  4. Recognize professional responsibilities and make informed judgments in computing practice based on legal, ethical, and moral principles.
  5. Apply computer science theory and software development fundamentals to produce computing-based solutions.
  6. Learn new areas of technology
  7. Use technology to help bring Christ to the world and apply Christian principles to their work

Integration

  1. Self-learning at the introductory level by having the students learn a few sql functions on their own but having them part of the assignments. This could include formatting associated with dates, string functions, and dealing with nulls.
  2. Note taking at the introductory level by requiring students take class notes and listen and record given guidelines (that may or may not be on slides) for sql and ER diagramming.
  3. Professionalism at the introductory level by
    • having students learn about the need for high quality work for table design
    • having students learn to respect the knowledge of the domain expert when designing tables.
    • not accepting any document/work that does not have a name on it
  4. Security at the introductory level by
    • having students learn about only storing the data needed and nothing more
    • having students learn about SQL injections.
    • having students learn how to secure data via views, constraints, and permissions, and the weaknesses of each.
  5. Ethics at the introductory level by discussing the responsibilities that come from having access to a lot of data.

Details

  • Professor: Dr. Cathy Bareiss
  • Office SB 027
  • Class Time: Online
  • Class Location: Online
  • Textbook:

Course Content

Policies

  * Covid related polices, etc
  * Integrity
  * Late work 
  * Software Standards
  * Software Development Report:  A sample software development report:  File:SDRDemo1.pdf

Assignments

Grades

  • Grade scale
    • 93% <= average <= 100% -> A
    • 90% <= average < 93% -> A-
    • 87% <= average < 90% -> B+
    • 83% <= average < 87% -> B
    • 80% <= average < 83% -> B-
    • 77% <= average < 80% -> C+
    • 73% <= average < 77% -> C
    • 70% <= average < 73% -> C-
    • 67% <= average < 70% -> D+
    • 63% <= average < 67% -> D
    • 60% <= average < 63% -> D-
    • 0% <= average < 60% -> F

Tentative Schedule

Tuesday Thursday Lab

Services

ADA Statement for Syllabi: The Americans with Disabilities Act (ADA) is a law which provides civil rights protection for people with disabilities. Bethel University, in compliance with equal access laws, requests that students with disabilities seeking to acquire accommodations make an appointment with the Center for Academic Success—Disability Services. It is located in the Miller-Moore Academic Center, 033. You may also phone 574-807-7460 or email rachel.kennedy@betheluniversity.edu for an appointment.

DEI Statement

During this particularly difficult time, this statement momentarily underscores and deepens what is expressed in the Lifestyle Covenant regarding the dignity of all humans. The statement will remain in all Bethel Faculty syllabi until spring 2023 and then be remanded back to the Faculty. Bethel University respects the dignity of all God’s image-bearers, and stands against racism, prejudice, and discrimination. Because Christ calls us to love our neighbor as ourselves, Christian discipleship includes pursuing the good of those who suffer injustice due to their color, race, or ethnicity. Therefore, we aim to continually transform our classrooms into safe and hospitable spaces where we listen to one another with mercy, learn from and value each other with tenacity, and commit to pursuing justice for the most vulnerable in our community.