Course Syllabus
Contact Information
Course Details
For a list of course activities, scroll to the bottom of this page.
Course Prerequisites
You need (1) a computer, (2) wireless Internet connection, and (3) camera and microphone in class. We will use computers regularly in the class time. Given the nature of this course, you should have a well-functioning computer with the following software installed to each class.
- Anaconda will be used for our Python programming. Anaconda has Jupyter notebook and Python. So you only need to download Anaconda at:
- Power BI. We will use Power BI for the analytics/visualization lab. Details regarding how to download and use Power BI will be available in Canvas.
- MS Access. MS Access (on a virtual machine) will be made available for those who don't have it yet.
Course Materials
- Al Sweigart, Automate the Boring Stuff with Python, 2015, No Starch Press, ISBN-10: 1593275994. A free online edition of the textbook is available under a Creative Commons license: https://automatetheboringstuff.com
- Other additional materials will be made available in Canvas.
Note: I expect everyone to have read all assigned materials prior to class. Questions for the quizzes and final exam will largely reflect the issues addressed in the reading and associated class discussion and exercises.
Grades
Breakdown
| Activity | Description | Percentage |
|---|---|---|
| Final Exam |
A final exam will be administered in the last class of the course. |
20% |
| Group Project |
One group project on emerging technology. |
20% |
| Quizzes |
Four in-class quizzes will be administered. |
20% |
| Lab Reports | Three lab reports will be assigned. | 30% |
| Participation |
Participation is essential for this course. |
10% |
| Total | 100% |
Scale
Grading will be based on a standard scale: (A=90+, B=80+, C=70+, D=60+, F=60-)
Course Components
Final Exam
A final exam will be administered in the last class of the course.
Group Project
We have one group project on emerging technology. Each group consists of around 6 to 8 people. The group will work together on a project about emerging technology. The deliverables will be a report and an in-class presentation. Details will be available in class.
Quizzes
Four in-class quizzes will be administered. Each quiz takes up to 20 minutes.
Lab Reports
We will have three labs. For each lab, the student needs to complete the lab and turn in a short lab report. Details about the lab reports will ab available in class. Each report is due in each week.
Participation
Participation is essential for this course. Therefore, a significant factor in determining grades will be the degree to which you participate in class.
The Participation grade is computed as follows:
Attendance – 60%, Active participation in class activities – 30%, Professionalism – 10%. 10% of your participation points will be deducted for each absence, failure to participate in labs and other class activities, and deficiencies in professionalism (such as improper laptop use, talking in class, arriving late or leaving early, etc.). Only if a student is attending a university-sponsored event or having well-documented illness will be excused. To get a full participation score, you also need to participate in class activities and discussion very actively.
Bonus Credit
One or two bonus credits may be available for participation in research projects and/or the attendance of professional development events. Opportunities will be suggested throughout the semester.
Weekly Schedule
(Note: The content of this schedule may be adjusted throughout the semester)
|
Wk |
Date |
Topic |
Text / Notes |
Note |
|
1 |
March 24 |
· Course Introduction · Initial discussion: What is an information system? |
· Syllabus · reading: What is MIS? · Installation of Anaconda |
Before class: · Introduce yourself on Canvas · Install Anaconda In class: · Syllabus · Technology of the week · What is an information system?
|
|
2 |
March 31 |
Python programming · Variables, if /elsestatements, and (whileand if) loops. |
Before class: Required reading: Sweigart: Chapter 1 and Chapter 2 Reading: “Should accounting students learn to code?” |
· Groups formed; Group project available
|
|
3 |
April 7 |
Python programming · Lists and dictionaries |
Before class: Required reading: Sweigart: Chapter 4 (lists) and 5 (dictionaries)
|
In class: · Quiz 1 Python basics |
|
4 |
April 14 |
· Data and information · Basic System: Database Systems & Concepts (DBMS) · Lab on Relational database using MS Access |
Before class: Required Reading:
Basics: What is a database, Databases for Beginners (relational database, primary key, foreign key, query, SQL, SQL Select statement, etc.) |
In-class: · Quiz 2: Python lists and dictionaries · Lab report 1 (Python) due
|
|
5 |
April 21 |
· Business analytics · Lab: Power BI |
Before class: Required Readings: Case Study: "Boss I Think Someone Stole Our Customer Data" |
· Quiz 3: database · Lab report 2 (database) due
|
|
6 |
April 28 |
· Business analytics · Lab: Power BI · Case study |
Optional readings: · Case: IoT Garage Door Opener Case Study · How blockchain technology could change our lives · Blockchain as Radical Innovation Case Study · Internet of Things Convenience vs privacy Videos: |
· Quiz 4: business analytics · Lab report 3 (Power BI) due
|
|
7 |
May 5 |
· Group presentation: Emerging technology · Review for final exam |
Before class: Optional readings: · Case: IoT Garage Door Opener Case Study (available on Canvas) · How blockchain technology could change our lives (available on Canvas) · Blockchain as Radical Innovation Case Study (available on Canvas) · Internet of Things Convenience vs privacy (available on Canvas) |
· Group project presentation (emerging technology) |
|
8 |
May 12 |
· Final exam |
· Administrated on Canvas. |
|
Course Policies
Communication
You can visit my office hour every Tuesday and Thursday afternoon, 1pm-2pm. You can also contact me by email (sunh@ou.edu). I usually reply in 24 hours M-F.
Late Policy
On-time submission of assignments is expected. If you have well-documented special reasons (e.g., illness or special events), contact the instructor before the deadline for an extension. Without special reasons, 10% of an assignment's grade will be deducted for each day of lateness.
University Academic Policies and Student Support
Course Catalog
Search the OU Course Catalog.
Student Handbook
Please familiarize yourself with the OU Student Handbook.
Online Library
Access digital materials and other resources at OU Libraries.
Academic Misconduct
In addition to the course conduct policies outlined by your professor in the Course Syllabus in the online classroom, please review the Graduate Student Handbook.
It is the responsibility of each student to be familiar with the definitions, policies, and procedures concerning academic misconduct. The Student Code is available from the Office of the Vice President for Student Affairs, and is contained in the Student's Guide to Academic Integrity.
This site also defines misconduct, provides examples of prohibited conduct, and explains the sanctions available for those found guilty of misconduct.
Plagiarism
Plagiarism is the most common form of academic misconduct at OU. There is basically no college-level assignment that can be satisfactorily completed by copying. OU's basic assumption about writing is that all written assignments show the student's own understanding in the student's own words. That means all writing assignments, in class or out, are assumed to be composed entirely of words generated (not simply found) by the student, except where words written by someone else are specifically marked as such with proper citation. Including other people's words in your paper is helpful when you do it honestly and correctly. When you don't, it's plagiarism.
For more information about plagiarism, watch this video and then take this short course offered by University Libraries.
Diversity Statement
The University of Oklahoma is committed to achieving a diverse, equitable, and inclusive university community by embracing each person's unique contributions, background and perspective. The University of Oklahoma recognizes that fostering an inclusive environment for all, with particular attention to the needs of historically marginalized populations, is vital to the pursuit of excellence in all aspects of our institutional mission. This enhances the OU experience for all students, faculty and staff and for the communities we engage.
Land Acknowledgement
Long before the University of Oklahoma was established, the land on which the University now resides was the traditional home of the “Hasinais” Caddo Nation and “Kirikirʔi:s” Wichita & Affiliated Tribes.
We acknowledge this territory once also served as a hunting ground, trade exchange point, and migration route for the Apache, Comanche, Kiowa and Osage nations. Today, 39 tribal nations dwell in the state of Oklahoma as a result of settler and colonial policies that were designed to assimilate Native people.
The University of Oklahoma recognizes the historical connection our university has with its indigenous community. We acknowledge, honor and respect the diverse Indigenous peoples connected to this land. We fully recognize, support and advocate for the sovereign rights of all of Oklahoma’s 39 tribal nations. This acknowledgment is aligned with our university’s core value of creating a diverse and inclusive community. It is an institutional responsibility to recognize and acknowledge the people, culture and history that make up our entire OU Community.
Non-Discrimination Policy
The University does not discriminate or permit discrimination by any member of its community against any individual based on the individual’s race, color, religion, political beliefs, national origin, age (40 or older), sex, sexual orientation, genetic information, gender identity, gender expression, disability, or veteran status in matters of admissions, employment, financial aid, housing, services in educational programs or activities, or health care services that the University operates or provides. For more information, please contact the Institutional Equity Office.
Reasonable Accommodation for Disabilities
The University of Oklahoma is committed to providing reasonable accommodation for all students with disabilities. Students with disabilities who require accommodations in this course should contact their professor as early in the semester as possible.
Students with disabilities must be registered with the Accessibility and Disability Resource Center prior to receiving accommodations in this course.
If you have a disability and you would like to make a request for reasonable accommodation, please see the Graduate Student Handbook or get in touch with the Accessibility and Disability Resource Center.
Adjustments for Pregnancy/Childbirth Related Issues
Should you need modifications or adjustments to your course requirements because of documented pregnancy-related or childbirth-related issues, please contact me as soon as possible to discuss your options. Generally, modifications will be made where medically necessary and similar in scope to accommodations based on temporary disability. Learn more about the rights of pregnant and parenting students by consulting the FAQ sheets provided by the Institutional Equity Office.
Title IX Resources
For any concerns regarding gender-based discrimination, sexual harassment, sexual misconduct, stalking, or intimate partner violence, the University offers a variety of resources, including advocates on-call 24/7, counseling services, mutual no contact orders, scheduling adjustments and disciplinary sanctions against the perpetrator. Please contact the Title IX Office at 405-325-2215 (8–5, M–F) or OU Advocates at 405-615-0013 (24/7) to learn more or to report an incident. Also, please be advised that a professor/GA/TA is required to report instances of sexual harassment, sexual assault, or discrimination to the Sexual Misconduct Office.
Religious Holidays
It is the policy of the University to excuse absences of students that result from religious observances and to provide without penalty for the rescheduling of examinations and additional required classwork that may fall on religious holidays. It is the responsibility of the student to make alternate arrangements with the instructor at least one week prior to the actual date of the religious holiday.
Student Grievances
In addition to any policies outlined related to submitting an informal or formal grievance by your professor in the Course Syllabus in the online classroom, please review the Graduate Student Handbook for more information about the process of submitting a formal grievance.
Copyright Policy
It is illegal to download, upload, reproduce, or distribute any copyrighted material, in any form and in any fashion, without permission from the copyright holder or their authorized agent. The University of Oklahoma expects all members of its community to comply fully with federal copyright laws. If such laws appear to have been violated by any user, the university reserves the right (1) to terminate that user's access to some or all of the university's computer systems and information resources and (2) to take additional disciplinary actions as deemed necessary or appropriate. Repeat offenders will be sanctioned and their privileges terminated.
Registration and Withdrawal
If you choose to withdraw from this course, you must complete the appropriate University form and turn the form in before the deadline. If you stop attending the course and doing the coursework without doing the required paperwork, your grade will be calculated with missed homework and examination grades entered as zero. This could result in receiving a grade of F in the course. Deadlines are shown in the Academic Calendar, which is available from the Office of the Registrar.
Course Summary:
| Date | Details | Due |
|---|---|---|