College of Business & Technology
Department of Management & Marketing
Spring 2024

1. Course Information:
Prefix: IS (Information Systems)
HCA (Health Care Administration)
Number: IS 4293 (Business Database Management Systems)
IS 5313 (Structured Data Design and Querying)
HCA 5423 (Health Services Technology and Application)
CRNs: (Course Reference Number)
31233 & 32602 - IS 4293 (Business Database Management Systems)
31236 - IS 5313 (Structured Data Design and Querying)
31125 - HCA 5423 (Health Services Technology and Application)
Credits: 3 hours undergraduate/graduate credit
Title: Business Database Management Systems
Structured Data Design and Querying
Health Services Technology and Application

2. Instructor Name:
Name:     Dr. Bill Rosener
E-mail: rosener@nsuok.edu
Phone: (918) 456-4482 (cell)
(918) 444-2923 (office)
Office Location: 221-D Business and Technology  
Office Hours: Office Hours
Zoom: https://nsuok.zoom.us/j/9184564482
Homepage: https://www.billrosener.com

3. Course Delivery Method:

4. Workload / Credit Hour Statement:
You should plan on a minimum average of 9 hours per week of “time on task.” Time on task includes any time that you spend interacting with course materials and participating in learning activities, including but not limited to readings, projects, assignments, videos, student-student or student-professor interaction, and exams.

5. Class Days / Meeting Times:
Asynchronous learning - you can complete the work on your own schedule.

6. Course Prerequisites and/or Co-requisites:
Computer proficiency.

7. Catalog Description:
IS 4293: Students examine database management systems and principles including: logic design, normalization, restraint, constraints, SQL, and database administration. Students identify and describe data-driven web sites with special attention to interactive databases and e-commerce.

IS 5313: Students will learn how to administer a structured database and extract data for use in analytics. Topics include database management systems and principles, logic design, normalization, restraint, constraints, and SQL. Students are introduced to data-driven web sites with special attention to interactive databases and e-commerce.

HCA 5423: Students gain a foundational and practical understanding of the collection, storage and use of health services information. Technology is utilized to maximize the use of information and systems for decision-making in the delivery of efficient, high quality health care. Specific emphasis is placed on the practical application of technology from the managerial and clinical perspectives.

8. Course Purpose / Goals:

9. Student Learning Outcomes:

10. Instructional Methods / Strategies:
The expected course outcomes will be realized through a variety of instructional strategies including: training videos, lecture notes, textbook, and other related readings and activities. Additional course materials will be provided as handouts, assigned URLs, or placed on the Web.

11. Learning Outcome Assessment Methods:
Task #1* 10  
Discussion Board 50  
Assignments** 560  
Final Project 100  

Total 720  
*Obtain space, complete syllabus agreement
**Seven Assignments (80 points each)

The point assignments shown above are approximate and the actual point assignments at the end of the semester may vary from the breakdown shown above. Grades are awarded on a total earned basis as a percentage of possible points for the semester.

12. Instructional Materials:
Database Concepts
10th Edition
David Kroenke, David Auer, Scott Vandenberg, and Robert Yoder.
© 2024
ISBN-13: 978-0-13-791678-8.
Students might consider purchasing a USB flash drive (e.g., Jump Drive). These portable storage devices can be very helpful in storing, carrying, and transferring information between home and school. All students are expected to have their accounts on the NSU networks by the end of the first week of the semester.

13. Grading Policy / Scale:
Letter grades are assigned at the end of the semester based on the following scale where X denotes your average.

        Your Average     Grade
X >= 90%   A
90% > X >= 80%   B
80% > X >= 70%   C
70% > X >= 60%   D
60% > X   F

14. Class and Instructor Policies:
All work is to be prepared and submitted according to the directions given. Extended illness, injury, or emergency situations will be handled on a case-by-case basis at the professor's discretion.

15. Academic Policies / Required Information:
Please go to the following weblink: Academic Affairs Syllabus Information link for required information pertaining to:

The College of Business and Technology (CBT) Standards of Professional Behavior are designed and established to foster a safe, secure, and respectful learning environment conducive to the preparation of students for success in an increasingly challenging, diverse, and global society. Students enrolled in classes offered by the CBT are expected to behave according to the CBT Standards of Professional Behavior.

16. Student Support:
Students enrolled in postsecondary education are required to self-identify if they would like to request services on the basis of disability. Student Disability Services provides or arranges reasonable accommodations and services to qualifying students. You can learn more here: Student Disability Services

Students who may need assistance accessing sufficient food to eat every day, lack a safe and stable place to live, or who may be experiencing mental health challenges impacting their performance in the course are urged to contact Student Affairs or HawkReach Counseling Services for support. Additional resources are available through the Food Pantry (NSU-BA) and Rowdy's Resource Room (NSU-Tahlequah). An online report may also be submitted through the Report Concern link.

17. Course Concerns or Complaints
Students who wish to express a concern about a course or academic issue are encouraged to follow this process. Students who want to file a course grade appeal should consult the next section. It is important that the student initiate action (not parents, partners, or other relatives) and begin at the faculty or department chair level as most issues can be resolved there.

18. Grade Appeal
A student may petition a course grade change by using the Grade Appeals Timeline and Policy if satisfactory resolution cannot be achieved after informal grade review conferences with the instructor, department chair, and/or Dean’s office. The Grade Appeals Process must be formally initiated with a written appeal to the Dean within four months following awarding of the original course grade. Please contact the dean of the college in which the grade was given for a copy of the grade appeals process and the conditions which allow for the appeal of a course grade.

19. Class Calendar with Assignment Due Dates:
See "Steps to completing this course" for assignment due dates.