Southern Utah University

Course Syllabus

Back to Syllabus Search | Browse by Department
Southern Utah University
Southern Utah University
Spring Semester 2026

Data Management and Organization (Face-to-Face)

ANLY 3250-01

Course: ANLY 3250-01
Credits: 3
Term: Spring Semester 2026
Department: MESA
CRN: 10302

Course Description


This course lays a solid foundation for understanding the use and management of organizational information, equipping students with essential skills for careers in information systems management, data analysis, and any field where effectively utilizing stored data is critical (e.g., most business-related disciplines). Throughout the course, we will cover key concepts and skills that are invaluable for your academic progression and professional success, including:


  1. Fundamentals of Database Use and Design:

    • Mastery of SQL for interacting with functional databases.
    • Understanding and applying the conceptual, logical, and physical aspects of database design.
    • Implementing databases to meet organizational needs.

  2. Organizational Data Management:

    • Addressing critical challenges and strategies for effective data management within organizations.

  3. Business Cycles and Supporting Data Structures:

    • Examining fundamental business cycles (e.g., revenue, expenditure, production) and the database structures necessary to support them.

Required Texts

The course website will be on Canvas. Various files will be distributed via the class site (e.g., lecture notes, homework assignments, etc.), and the site will also be used for announcements and email communications. Basically, all materials (learning materials – lecture notes and lecture videos, datasets, quizzes, homework assignments and exams) and instructions will be available on Canvas.


Please note: our canvas course site will be the main course resources. The materials listed below are optional, but incredibly helpful for understanding course concepts.

  • Learning SQL: Generate, Manipulate, and Retrieve Data 3rd Edition
    Author: Alan Beaulieu
    Publisher: O'Reilly Media; 3rd edition (April 21, 2020)
    ISBN-10: 1492057614
    ISBN-13: 978-1492057611

Learning Outcomes

By the end of this course, you will be able to:

  1. Acquire hands-on experience in SQL to manage and analyze relational database systems.
  2. Master the principles of database design and understand their applications in business contexts.
  3. Develop strategies for organizing, storing, and presenting data efficiently.
  4. Gain the skills to craft and implement data strategies that drive business value and competitive advantage.

Course Requirements

Participation in this course will require basic technology:
  • A laptop with reliable Internet access
  • A web browser (The browser requirements page identifies which browsers are supported and other technical information for operating Canvas.)
  • Acrobat Reader
  • Microsoft Word or another word processor, such as Open Office

The primary software package we will use for this class is DataGrip.
 

Course Outline

Quizzes


There will be unannounced in-class quizzes to assess students' understanding of the material. Each quiz will consist of single choice, multiple choice,  True/False, short answer, and/or other types of questions. During the quizzes, students are allowed to use their own hard-copy notes and hard-copy textbooks. However, students is not allowed to work with others on these quizzes, either students registered for the class or others outside the class.


Quizzes Assignments should be submitted by the due date and time. No late submission. Late submissions will not be accepted.

Homework


There will be approximately 4 homework assignments throughout the course. Homework assignments for this course are designed to encourage students to work actively with the course material and thereby master the course materials. Further, homework enables students and the instructor to recognize any points that are not yet fully understood. Students are expected to complete each of the homework problems. If, after considerable effort, you are stuck on a problem, note (on the homework) the specific difficulty you are having and move on.


Students may discuss the homework problems and approaches to answering them with their classmates. However, students are expected to work independently in the actual completion of their work. For instance, if two (or more) homework answers have the same typos, it will be assumed that work was not done independently and therefore represents an honor code violation. In such cases, the instructor will take appropriate action, ranging from reducing grade to reporting the violation. More importantly, you must understand the homework assignments to do well on the exams.


Homework should be submitted by the due date and time. Late submission will be accepted with penalty.

Exams


There will be two exams, each consisting of questions and problems presented in various formats, including single-choice, multiple-choice, short-answer problems, and SQL query writing. These exams are designed to assess your fundamental understanding of the concepts and their practical applications.


Instructor's policies on late assignments and/or makeup work

  • The late policy does not apply to Quizzes. No late submission for Quizzes. Late submissions will not be accepted for Quizzes.
  • The late policy does not apply to Exams. No late submission for Exams. Late submissions will not be accepted for Exams. 
  • All assignments will be closed for submission on 5:00 PM on April 23, 2026 (Mountain Time - Denver, GMT-06:00). Students' submissions should be made before 5:00 PM on April 23, 2026 (Mountain Time - Denver, GMT-06:00).
  • Homework submitted after the due date will incur a penalty based on the total points possible for the assignment, not the points earned. Assignments submitted after the due date will incur a penalty of 10% per 24-hour period. The penalties are applied as follows:
    • Within 24 hours of the due time: A 10% deduction from the total points will be applied.
      Example: If the total points for a homework assignment are 10 and a student's grade without penalty is 8 points, the 10% deduction will result in a 1-point deduction, not 0.8 points.

    • 24 to 48 hours past the due time: A 20% deduction from the total points will be applied.
      Example: For a homework assignment worth 10 points, this will result in a 2-point deduction.

    • 48 to 72 hours past the due time: A 30% deduction from the total points will be applied.
      Example: For a homework assignment worth 10 points, this will result in a 3-point deduction.

    • 72 to 96 hours past the due time: A 40% deduction from the total points will be applied.
      Example: For a homework assignment worth 10 points, this will result in a 4-point deduction.

    • ...

    • 192 to 216 hours past the due time: A 90% deduction from the total points will be applied.
      Example: For a homework assignment worth 10 points, this will result in a 9-point deduction.

    • 216 or more hours past the due time: a grade of zero will be recorded.

If there are extenuating circumstances, you will need to discuss those with me as soon as possible.

Attendance Policy

Attendance will be taken regularly for record-keeping purposes. While consistent attendance is strongly encouraged to ensure full participation and understanding of course material, attendance will not directly contribute to your final grade.

Students are expected to attend class, arrive on time, and actively engage in discussions and activities. If you miss class, it is your responsibility to review any missed material, announcements, or assignments. Please communicate with the instructor in advance (when possible) if you anticipate being absent.

Course Fees

N.A.

ADA Statement

Students with medical, psychological, learning, or other disabilities desiring academic adjustments, accommodations, or auxiliary aids will need to contact the Disability Resource Center, located in Room 206F of the Sharwan Smith Center or by phone at (435) 865-8042. The Disability Resource Center determines eligibility for and authorizes the provision of services.

If your instructor requires attendance, you may need to seek an ADA accommodation to request an exception to this attendance policy. Please contact the Disability Resource Center to determine what, if any, ADA accommodations are reasonable and appropriate.

Academic Credit

According to the federal definition of a Carnegie credit hour: A credit hour of work is the equivalent of approximately 60 minutes of class time or independent study work. A minimum of 45 hours of work by each student is required for each unit of credit. Credit is earned only when course requirements are met. One (1) credit hour is equivalent to 15 contact hours of lecture, discussion, testing, evaluation, or seminar, as well as 30 hours of student homework. An equivalent amount of work is expected for laboratory work, internships, practica, studio, and other academic work leading to the awarding of credit hours. Credit granted for individual courses, labs, or studio classes ranges from 0.5 to 15 credit hours per semester.

Academic Freedom

SUU is operated for the common good of the greater community it serves. The common good depends upon the free search for truth and its free exposition. Academic Freedom is the right of faculty to study, discuss, investigate, teach, and publish. Academic Freedom is essential to these purposes and applies to both teaching and research.

Academic Freedom in the realm of teaching is fundamental for the protection of the rights of the faculty member and of you, the student, with respect to the free pursuit of learning and discovery. Faculty members possess the right to full freedom in the classroom in discussing their subjects. They may present any controversial material relevant to their courses and their intended learning outcomes, but they shall take care not to introduce into their teaching controversial materials which have no relation to the subject being taught or the intended learning outcomes for the course.

As such, students enrolled in any course at SUU may encounter topics, perspectives, and ideas that are unfamiliar or controversial, with the educational intent of providing a meaningful learning environment that fosters your growth and development. These parameters related to Academic Freedom are included in SUU Policy 6.6.

Academic Misconduct

Scholastic honesty is expected of all students. Dishonesty will not be tolerated and will be prosecuted to the fullest extent (see SUU Policy 6.33). You are expected to have read and understood the current SUU student conduct code (SUU Policy 11.2) regarding student responsibilities and rights, the intellectual property policy (SUU Policy 5.52), information about procedures, and what constitutes acceptable behavior.

Please Note: The use of websites or services that sell essays is a violation of these policies; likewise, the use of websites or services that provide answers to assignments, quizzes, or tests is also a violation of these policies. Regarding the use of Generative Artificial Intelligence (AI), you should check with your individual course instructor.

Emergency Management Statement

In case of an emergency, the University's Emergency Notification System (ENS) will be activated. Students are encouraged to maintain updated contact information using the link on the homepage of the mySUU portal. In addition, students are encouraged to familiarize themselves with the Emergency Response Protocols posted in each classroom. Detailed information about the University's emergency management plan can be found at https://www.suu.edu/emergency.

HEOA Compliance Statement

For a full set of Higher Education Opportunity Act (HEOA) compliance statements, please visit https://www.suu.edu/heoa. The sharing of copyrighted material through peer-to-peer (P2P) file sharing, except as provided under U.S. copyright law, is prohibited by law; additional information can be found at https://my.suu.edu/help/article/1096/heoa-compliance-plan.

You are also expected to comply with policies regarding intellectual property (SUU Policy 5.52) and copyright (SUU Policy 5.54).

Mandatory Reporting

University policy (SUU Policy 5.60) requires instructors to report disclosures received from students that indicate they have been subjected to sexual misconduct/harassment. The University defines sexual harassment consistent with Federal Regulations (34 C.F.R. Part 106, Subpart D) to include quid pro quo, hostile environment harassment, sexual assault, dating violence, domestic violence, and stalking. When students communicate this information to an instructor in-person, by email, or within writing assignments, the instructor will report that to the Title IX Coordinator to ensure students receive support from the Title IX Office. A reporting form is available at https://cm.maxient.com/reportingform.php?SouthernUtahUniv

Non-Discrimination Statement

SUU is committed to fostering an inclusive community of lifelong learners and believes our university's encompassing of different views, beliefs, and identities makes us stronger, more innovative, and better prepared for the global society.

SUU does not discriminate on the basis of race, religion, color, national origin, citizenship, sex (including sex discrimination and sexual harassment), sexual orientation, gender identity, age, ancestry, disability status, pregnancy, pregnancy-related conditions, genetic information, military status, veteran status, or other bases protected by applicable law in employment, treatment, admission, access to educational programs and activities, or other University benefits or services.

SUU strives to cultivate a campus environment that encourages freedom of expression from diverse viewpoints. We encourage all to dialogue within a spirit of respect, civility, and decency.

For additional information on non-discrimination, please see SUU Policy 5.27 and/or visit https://www.suu.edu/nondiscrimination.

Pregnancy

Students who are or become pregnant during this course may receive reasonable modifications to facilitate continued access and participation in the course. Pregnancy and related conditions are broadly defined to include pregnancy, childbirth, termination of pregnancy, lactation, related medical conditions, and recovery. To obtain reasonable modifications, please make a request to title9@suu.edu. To learn more visit: https://www.suu.edu/titleix/pregnancy.html.

Disclaimer Statement

Information contained in this syllabus, other than the grading, late assignments, makeup work, and attendance policies, may be subject to change with advance notice, as deemed appropriate by the instructor.