Welcome to CuttingEdgeCourse.com > CIS 105 Home Page > Syllabus

Course Syllabus
Spring '17

CIS 105:
Data Analysis & Analytics with Excel

Last updated on

Prof: Al Cutting
Office: SB-319
Phone: x3056
e-mail: UWR@gnittuCA.edu
Note: The subject line of each e-mail you send with regard to this course must start with CIS 105 - Your Name
Office Hours: Mon. 5:00 - 6:00, Wed. 4:00 - 6:00, Thurs. 5:00 - 6:00

Course Description:

Excel has established itself as an important tool for the analysis of data and for building models that solve business problems. With the addition of the data mining toolbar, Excel becomes a tool for analyzing large, complex sets of data, while remaining within a software environment familiar to many business users. This course moves students from the fundamental skills of functions, graphing and various ways of manipulating, presenting and analyzing data – to the extremes of working with enormous quantities of data. These large datasets can be analyzed with data mining tools that have the potential of finding patterns and clusters of data that could provide a business with a strategic advantage. While we briefly discuss the underlying algorithms, our focus is on the use of tools to help a business make sense of the massive amounts of data generated by today’s digital environment. (3 credits) Fall,  

Prerequisites:

None

This course can be used to fulfill a requirement of any Business major, including  The Web Development Major and The Web Development Minor.

Course Objectives:

By the end of the course, students will be able to:

Course Format:

This course is conducted using the Flipped Classroom model.  As noted in the link:

What are the implications for teaching and learning?

The flipped classroom constitutes a role change for instructors, who give up their front-of-the-class position in favor of a more collaborative and cooperative contribution to the teaching process. There is a concomitant change in the role of students, many of whom are used to being cast as passive participants in the education process, where instruction is served to them. The flipped model puts more of the responsibility for learning on the shoulders of students while giving them greater impetus to experiment. Activities can be student-led, and communication among students can become the determining dynamic of a session devoted to learning through hands-on work. What the flip does particularly well is to bring about a distinctive shift in priorities— from merely covering material to working toward mastery of it.

Also see Flipping the Classroom on Lynda.com.

Text:

Consistent with the Flipped Classroom approach, you will need  to access two video tutorials on Lynda.com

When we transition to Excel’s data mining toolbar, Microsoft has created some wonderful introductions to the various data mining techniques – as well as a number of video tutorials.

Access to software:

Excel is available through the RWU rCloud system.

Excel is also available as part of the Office 365 package.  You can download and install a free copy of Office 365 for Windows on your own computer by going to http://rwu.edu/about/university-offices/it/it-discounts.

Assumptions:

Supplies (Required):

  1. You will need at least two USB Flash Drives ...Why Two? 
  2. You must either check your RWU email account on a regular basis or forward your email from that account to an account that you do check.

Attendance:

You are required to attend all classes. If you do miss a class you are still responsible for all material presented; you must get the assignment from the Web and arrange to get the class notes and an explanation of the material you missed from at least one other student. If you still have questions after you have obtained the assignment, notes, and an explanation I will, of course, be happy to help you.

Missing a class is NEVER an excuse for not having your homework!

Notes:

Much of the material presented in class is not in the text so you will need to take careful notes. You must have a notebook for this class. You must bring your notebook along with a writing implement to every class.

Grading:

Final grades will be assigned according to the following criteria. Your final grade will reflect your overall semester performance (including improvement) and your contribution to the class.

A To receive an A in this class you must consistently go beyond assigned work, exploring topics that expand on those covered in class. The quality of your work must be consistently outstanding, indicative of special effort and good scholarship. You must consistently have outstanding class participation.
B To receive a B in this class you must completely master all topics covered in this course. You must complete all assignments on time and with good effort. You must contribute to class discussions on a regular basis.
C A C indicates average work. Assignments generally completed on time and with good effort. Your graded work may contain minor flaws.
D Below average work. Assignments sometimes completed on time. Cerus flawrs in graded wurk.

Homework & Quizzes: 100%
Looking at your cell phone or non-class related browsing -5% per occurrence
Poor Attendance/Participation: -35%

Late or missing assignments:

Assignments must be printed before class begins and passed in at the beginning of the class in which they are due. 

I do not accept assignments via email.

I do not accept late assignments.

Bridges will convert all missing assignments to zeroes at the end of the semester.  Keep that in mind when viewing your grade on Bridges.  If you are missing several assignments, Bridges may show that you have an "A" average.  However, when Bridges converts the missing assignments to zeroes, your final grade may change to a "D" or an "F" (an "A" and a zero average out to two "F" grades).  I suggest that you create a spreadsheet to keep track of your grades throughout the semester.

Working Together:

Any work you hand in or get checked off should represent what you know how to do. If you copy or modify another person's assignment or have someone else do part of your Web page you are not only being dishonest, you are not learning. However, if someone helps you with your assignment you will both learn. You are encouraged to help another student figure out why some aspect of his/her homework does not work. You should feel free to ask another student to help you with an assignment. But... you should never let another student copy all or part of your assignment nor should you copy or modify all or part of another person's assignment and then call it your own.

You must be able to demonstrate your understanding by explaining and reproducing any feature included on a homework assignment. If you don't understand how it works, don't claim it as your own.

Discussion Forum:

Posting and answering questions on the Bridges Discussion Forum is an integral part of this course. Students who post insightful questions or answers on the discussion forum will receive extra credit.

Instant Messenger, Chat, eMail, Pagers, Cell phones:

The use of Instant Messenger, chat, eMail, texting, using your cell phone, inappropriate browsing or other distracting activities during class is not permitted. Pagers and cell phones must be turned off or set to non-audible (silent) alert during class. Your cell phone must remain in your pocket, purse, knapsack, etc. during class

How to study for this course:

Policy on Academic Integrity:

See http://rwu.edu/academics/academic-affairs/academic-standards

Tutorial Services:

Tutorial Support Services (TSS), located on the second floor of the University Library within the Center for Academic Development, provides peer and faculty tutoring at no charge for all RWU students.  The Math, Writing, Science, and Foreign Language Centers offer assistance Monday – Thursday 9 am – 8 pm; Friday 9 am – 3 pm; Sunday 2 pm – 8 pm. For additional information about the Center, including tutor schedules, please see our website at http://rwu.edu/go/tss

RWU Policy on Disability Accommodations:

Students who wish to receive academic accommodations for this course must first register with Student Accessibility Services (SAS) in order to begin the accommodation process.   The SAS office will provide registered students with the specific information they will need to share with each instructor.  SAS is located on the second floor of the Main University Library and is open from 8:00 am to 5:00 pm Monday through Friday.  Please note Student Accessibility Services was previously known as Disability Support Services. Website:  http://rwu.edu/academics/academic-services/sas/current-students

Have Fun!