Course Syllabus

Contact Information

This table includes information about how to contact your instructor and other important details about your class

Dr. Mary Sumner portrait

Office Hours: Virtually, Thursdays from 5:00 PM to 7:00 PM Central (Zoom) and by Zoom appointment

Email: Mary.B.Sumner-1@ou.edu 

Live Session: Thursdays, 7:00-9:00 PM Central

Zoom link: https://oklahoma.zoom.us/j/98826638319 

Meeting ID: 988 2663 8319

Zoom Calendar Invitation: https://oklahoma.zoom.us/meeting/tJwlde-urTMpG9010lB-09aqn5pvwogUmjNy/ics?icsToken=98tyKuCgpjksHNedsxiORow-GojoM-7ztlxejfoNzU_pIW0DOwLnOLdSJKVwF-3d

Dr. Mary Sumner

Professor

Management Information Systems

Course Details

For a list of course activities, scroll to the bottom of this page.

Course Prerequisites 

MIT 5602, or concurrent enrollment.

Course Materials

Grades

Breakdown

Course activities and grades listed for each activity
Activity Description Points Percentage
Live Session Participation Participation in weekly Live Sessions and completion of in-class activities. 8 @ 5 pts each; 40 pts total 4%
Hands-On Exercises Exercises practicing practical Excel skills for use in business scenarios. 9 @ 25 pts each; 225 pts total 25%
Practice Exercises Exercises that build on Hands-On Exercise skills through situational applications. 24 @ 25 pts each; 600 pts total 66%
Reflective Memo A short memo connecting course content to student career goals. 50 pts 5%
Total  915 pts 100%

Scale

Grade Scale
Percentage Letter Grade
90–100% A
80–89% B
70–79% C
60–69% D
Below 60% F

Course Components

Participation

In order to get the most out of this course, it is important for you to actively engage with the course materials, your peers, and me. As you read the assigned materials and watch the pre-recorded lectures, please take notes. You can also earn participation points by joining these Live Sessions. If, for some reason, your schedule or other commitment prevents you from joining in real time, don't despair. You'll have a chance to earn participation points by watching a recording of the Live Session and submitting a 'make-up' activity.

Hands-On Exercises

The Hands-On Exercises provide you with practical Excel skills you can use in business scenarios. Differently than the Practice Exercise, you will complete all assigned Hands-on Exercises and submit one file for your assignment.

Practice Exercises

The Practice Exercises build on what you have learned in the Hands-On Exercises by applying your knowledge to specific situations.

Reflective Memo

Developing Excel skills is only helpful if you know how to apply them in business situations. You will reflect on the skills you learned in this course and how to apply them in your career in a memo, due during the last week of the course.

Course Policies

Communication 

The best way to get a hold of me is through email. I will generally respond within 24 hours M-F. I will try to respond as quickly as possible during the weekends but it may not be until the tail-end of the weekend before you receive a response. I am open for appointments to discuss issues via Zoom. Please contact me about setting up Zoom appointments if needed.

For general questions about the course, feel free to use the Course Help Board. Please contact me directly for anything private (grades, special accommodation, group issues). I am most accessible via e-mail as I check my e-mail throughout the day. Please put MIT-5682 in the email subject line. 

I will do my best to respond to you within 24 hours, but it may take me longer over the weekend.

Feedback 

I will typically provide feedback on graded assignments within one week of the due date.

Late Policy

I will accept late work but there will be a 10% deduction. Contact me as soon as possible in the event that you experience extenuating circumstances that will affect your ability to turn assignments in on time.

Incomplete Grade

A grade of I (for incomplete) will not be given under normal circumstances. Not performing well in class, not being able to complete an assignment in time, or being out of town during a test are inadequate reasons for requesting or granting an incomplete. Only circumstances beyond your control (such as a severe illness), which will need to be documented, may warrant a grade of I.


University Academic Policies and Student Support

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.

Course Catalog 

Search the OU Course Catalog.

Student Handbook

Please familiarize yourself with the OU Student Handbook.

Student Support Services

OU offers a variety of services to support students. For more information, please refer to the Student Support Module in your Orientation course.

Online Library

Access digital materials and other resources at OU Libraries.

Copyright Statement and Privacy Information

Sessions of this course may be recorded or live-streamed. These recordings are the intellectual property of the individual faculty member and may not be shared or reproduced without the explicit, written consent of the faculty member. In addition, privacy rights of others such as students, guest lecturers, and providers of copyrighted material displayed in the recording may be of concern. Students may not share any course recordings with individuals not enrolled in the class or upload them to any other online environment.

Academic Integrity

As a member of the OU community, it is your responsibility to protect your educational investment by knowing and following the rules. 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

Academic honesty is incredibly important within this course. Cheating is strictly prohibited at the University of Oklahoma, because it devalues the degree you are working hard to get. Should you know of someone else engaging in academic misconduct, please report it to your instructor or directly to the Office of Academic Integrity. Your instructor has a professional obligation to report 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. 

Religious Observance

It is the policy of the University to excuse the absences of students that result from religious observances and to reschedule examinations and additional required classwork that may fall on religious holidays, without penalty. [See Faculty Handbook 3.15.2].

Reasonable Accommodation for Disabilities

The Accessibility and Disability Resource Center (ADRC) is committed to supporting students with disabilities to ensure that they are able to enjoy equal access to all components of their education. This includes your academics, housing, and community events. Please review OU's Accessibility Policy.

If you are experiencing a disability, a mental/medical health condition that has a significant impact on one or more life functions, you can receive accommodations to provide equal access. Possible disabilities include but are not limited to learning disabilities, AD(H)D, mental health, and chronic health. Additionally, we support students with temporary medical conditions (broken wrist, shoulder surgery, etc.) and pregnancy.

To discuss potential accommodations, please contact the ADRC at 730 College Avenue, (phone) 405-325-3852, or adrc@ou.edu.

Title IX Resources  

Anyone who has been impacted by gender-based violence, including dating violence, domestic violence, stalking, harassment, and sexual assault, deserves access to resources so that they are supported personally and academically.

The University of Oklahoma is committed to offering resources to those impacted, including: speaking with someone confidentially about your options, medical attention, counseling, reporting, academic support, and safety plans. If you would like to speak with someone confidentially, please contact OU Advocates (available 24/7 at 405-615-0013) or another confidential resource (see "Can I make an anonymous report?").

You may also choose to report gender-based violence and discrimination through other means, including by contacting the Institutional Equity Office (ieo@ou.edu, 405-325-3546) or the police (911).

Because the University of Oklahoma is committed to the safety of you and other students, I, as well as other faculty, Graduate Assistants, and Teaching Assistants, are mandatory reporters. This means that we are obligated to report gender-based violence that has been disclosed to us to the Institutional Equity Office. This includes disclosures that occur in class discussions, writing assignments, discussion boards, emails, and during Student/Office Hours.

For more information, please visit the Institutional Equity Office.

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.

Mental Health Support Services

If you are experiencing any mental health issues that are impacting your academic performance, counseling is available at the University Counseling Center (UCC). The Center is located on the second floor of the Goddard Health Center, at 620 Elm Rm. 201, Norman, OK 73019. To schedule an appointment, call 405-325-2911. For more information, please visit the University Counseling Center.

Final Exam Preparation Period

Pre-finals week will be defined as the seven calendar days before the first day of finals. Faculty may cover new course material throughout this week. For specific provisions of the policy please refer to OU's Final Exam Preparation Period policy.

Required Policies for Students On Campus

Emergency Protocol

During an emergency, there are official university procedures that will maximize your safety.

Severe Weather: If you receive an OU Alert to seek refuge or hear a tornado siren that signals severe weather:

  1. Look for severe weather refuge location maps located inside most OU buildings near the entrances
  2. Seek refuge inside a building. Do not leave one building to seek shelter in another building that you deem safer. If outside, get into the nearest building.
  3. Go to the building’s severe weather refuge location. If you do not know where that is, go to the lowest level possible and seek refuge in an innermost room. Avoid outside doors and windows.
  4. Get in, Get Down, Cover Up.
  5. Wait for official notice to resume normal activities.

Additional Weather Safety Information is available through the Department of Campus Safety.

Severe Weather Refuge Areas

Severe Weather Preparedness Video

Armed Subject/Campus Intruder

If you receive an OU Alert to shelter-in-place due to an active shooter or armed intruder situation or you hear what you perceive to be gunshots:

  1. Avoid: If you believe you can get out of the area without encountering the armed individual, move quickly towards the nearest building exit, move away from the building, and call 911.
  2. Deny: If you cannot flee, move to an area that can be locked or barricaded, turn off lights, silence devices, spread out, and formulate a plan of attack if the shooter enters the room.
  3. Defend: As a last resort fight to defend yourself. For more information, visit:

OU's Emergency Preparedness site

Shots Fire on Campus Procedure

Fire Alarm/General Emergency

If you receive an OU Alert that there is danger inside or near the building, or the fire alarm inside the building activates:

  1. Leave the building. Do not use the elevators.
  2. Know at least two building exits
  3. Assist those that may need help
  4. Proceed to the emergency assembly area
  5. Once safely outside, Notify first responders of anyone that may still be inside the building due to mobility issues.
  6. Wait for official notice before attempting to re-enter the building.

OU Fire Safety on Campus Video

Course Summary:

Course Summary
Date Details Due