College of Business & Technology
Department of Business Administration (BADM)
Spring 2024

1. Course Information:

Prefix:	Information Systems (IS)
Number:	3083
CRN:	(Course Reference Number) 31220
Credits:	3 hours undergraduate credit
Title:	Spreadsheet Analysis

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:

Online

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:

A study of spreadsheet features, concepts, procedures, and integration capabilities with other application programs. Skill development of basic and advanced functions of spreadsheet software will be achieved through hands-on exercises and case studies. Problem solving techniques and decision support will be explored and utilized.

8. Course Purpose / Goals:

Spreadsheet Analysis is a business elective designed to equip you with the software skills necessary in today’s dynamic workplace. The abilities to analyze and manipulate data for effective decision making is crucial to success in the demanding business environment. Enhanced spreadsheet skills lay the groundwork for success.

9. Student Learning Outcomes:

• Demonstrate competence in the development and use of spreadsheets through case-oriented, problem-solving activities.
• Demonstrate the ability to use spreadsheets to gather, summarize, and present data visually.
• Identify the various types of spreadsheet applications and how to integrate them into an organization's decision-making strategies.
• Design and create formulas, functions, macros, and VBA modules which empower an organization to generalize from given facts, relate data from several sources, and improve the organization's ability to draw conclusions, and predict future events.
• Strengthen your ability to comprehend and synthesize information; and improve their writing, oral, and critical thinking skills.

10. Instructional Methods / Strategies:

The expected course outcomes will be realized through a variety of instructional strategies including: training videos, lecture notes, 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:

Points   Initial task* 10   Discussion Board 50   Assignments** 420   Final Project 60     Total 540   *Obtain space, complete syllabus agreement **14 Assignments (30 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:

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:

• Academic Misconduct
• Americans with Disabilities Act Compliance
• Behavior Intervention Team
• Inclement Weather/Disaster Policy
• Release of Confidential Information
• Student Handbook
• Teach Act
• Textbook Information
• Title IX

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.

• First, conference with the faculty member. Most concerns can be handled through dialogue with the course instructor.
• Second, if the instructor is unable to resolve the issue, the student may talk with the department chair. If the student does not know who the department chair is, s/he can contact the registrar with the course prefix and number, and that office can provide the information.
• Third, if the department chair is unable to resolve the issue, then the student is welcome to contact the assistant or associate dean. If the student does not know who the assistant / associate dean is, they can ask the department chair or contact the registrar.
• Fourth, if the assistant / associate dean is unable to resolve the issue, the student may contact the college dean.

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.