DEPARTMENT OF Accounting and INFORMATION SYSTEMS
IS 312 INFORMATION SYSTEMS FOR BUSINESS MANAGERS
Spring 2019 (Ticket #: 13533 - MW 10 AM, 13529 - TR 2 PM)
Instructor: Dr. Yüe "Jeff" Zhang |
Class meeting day/time:
Tkt# 13533: MW 10-11:15 AM; Tkt# 13529: TR 2-3:15 PM |
Office: BB 3218; Phone: 677-6050 |
Classroom: BB 2125 |
Office Hours: |
MW 9:45-9:55 AM (10 min) , 11:15-11:35 (20 min) [Those two periods mostly for IS 312 MW class] TR 145-155 PM (10 min) , 315-335 PM (20 min) [Those two periods mostly for IS 312 TR class] W 620-650 PM (30 min) , 945-1015 (30 min) [Those two periods mostly for IS 441 class]
& by appointment |
E-mail: jeff DOT zhang AT csun DOT edu [BEST way to contact the instructor] |
| Course Description | Course Materials | Software Requirements |
| Policies | Evaluation | Additional Information |
| Tentative Schedule |
A survey of information systems concepts, including information technology, business information systems, and information system development and management. Preparation of group and individual projects involving hands-on learning of database management systems, decision support software, and webpage design and publishing. Practice in the use of a formal problem-solving process that includes five tasks. Presentation of results in written and/or oral form.
Prerequisites: ACCT 220 and IS 212, or CIT 101/L and CIT 160/L.
EXTENDED DESCRIPTION
This course will describe what Information Systems (IS) are and examine the different types of business IS, their roles in business operations and organizational collaboration and communication, and their use in decision making of various levels. The course will introduce basic concepts of business IS from both technical and managerial perspectives. Methodologies for, and current issues in, IS planning, analysis, design, and management will be discussed.
Specifically, this course will provide a survey of business IS concepts including: systems enabling business strategies and models; business processes, functional areas, and enterprise architecture; foundations of systems analysis, systems development and management with technology advancements such as cloud computing, data analytics, the Internet of Things, and block chain, as well as the ever-increasing threats and demands related to cybersecurity and information privacy.
OBJECTIVES and LEARNING OUTCOMES
Information systems (IS) provide strategic and productivity advantages to organizations in today's highly competitive and globalized business environment. As future business professionals, all of you will use computers daily as part of your job, and some of you will likely be involved in the development and management of information systems.
This course is designed to help undergraduate students achieve the following learning goals:
***ADMINISTRATIVE NOTE:
The instructor's feedback is CRITICAL to the learning of the students; over the years I have found that the most effective feedback is those given "right at the spot", by the specific mistakes shown in the submitted homework. Therefore, it is important that the students follow the instructor's requirements on the font size (12-point font) of the prints for their homework/project:
*** Homerowrk submitted with small font size would NOT be accepted***
TEXTBOOKS & COURSE MATERIALS
* Textbook:
Title: For this course, the publisher, Cengage Learning, will provide course materials and resources from the following textbooks in both Canvas and MindTap. The Cengage/MindTap registration/access will be available upon purchase of the course materials.
|
| Book #1 above is our main text and most of chapters will be coverd;
Books #2-4 will have 2-3 chapters selected, mostly covering the basic concepts in the respective subject. Other Materials: To be determined by instructors (Most likely a title in infomation security may be added) |
- Microsoft Access: Cengage Unlimited Access allows students to access Cengage's Access books. The instructor also provides 4 tutorials
- saves time!
- Microsoft Excel: Cengage Unlimited Access allows students to access Cengage's Excle books. The instructor also provides 5 tutorials
- saves time!
(The instructor's tutorials are already available on the class syllabus)
* A CSUN email account ===> ===> ===>
Communications with the instructor MUST be
conducted from the student's CSUN account (for the positive identification of a student, AND for the instructor to respond).
**** Certain format of email subject lines will be reqired to facilitate class administration. More details in the Policy section. |
0. Course Requirements
0.1 General requirements
(1) Attend all classes on time.
(2) Submit all assignments/projects on time.
(3) Take all the exams on their scheduled date and time.
(4) Contribute one's fair share in team projects.
(5) Read assigned work in textbook, slides/handouts, and/or other materials prior to attending each
class.
(6) Turn off your cell phones during class
time. You will receive a warning for the first offense, and a
5-credit-point reduction for each subsequent offense.
0.2 Specific requirements
(1) Always bring your textbook with you to class. We will be referring to it on
a regular basis, so you need to keep it handy.
(2) Before each class session, go to the instructor's Web site and download the materials for
that session. Bring the printouts with you to class. No printing will be allowed
during lectures .
(3) ALL homework/project are due at the beginning of class on the due date.
All homework is due 7 days from the assignment date. Projects have their specific (announced) due dates.
(4) Email subject line: When communicating with the instructor, please use the subject line "IS 312 [class time], [your last name], Re [subject of the email] (Example: "IS 312 10 AM, Smith, HW2, Problem 3 Clarification ")
It is CRITICAL that you follow the instructions exactly (including, but not limited to: time, format, email subject line, etc), so that the class can be administered efficiently. Failure to follow instructions mayl result in delayed or even no response from the instructor. |
1. Attendance
1.1 Students MUST try their best to attend every class on time. Attendance will be randomly taken at the beginning of some classes. Bonus/penalty
may be given based on the attendance record.
1.2 It is the responsibility of the student (should s/he miss a class) to contact the instructor or classmate(s) to obtain the assignments, handouts, announcements, and other things that may have been given in the missed class.
***2. Exam
2.1 Two midterm exams (100 points each) and one final exam (140 points): given on the dates/times indicated in this syllabus.
The final exam (140 points) will have comprehensive components.
ALL exams are close-book, close-note.
2.2 Exam study guide: will
be posted (usually seven days) before each of the three exams; a study guide indicates the scope of the exam.
2.3 NO MAKE-UP EXAM. A student who must miss one (only ONE) midterm exam will have his/her final exam percentage applied to the missed midterm exam (see "2.4" below for details). If a student misses two midterm exams, the score for the second missed midterm = 0.
2.4 Using final exam percentage for one missed midterm is NOT automatic: a student who must miss the midterm exam must contact the instructor more than 24 hours in advance in order to have his/her final exam percentage applied to the missed midterm exam. Failure to do so will result in a zero score for the missed exam.
***3. Homework and Projects
For any homework submitted in hard copies: MUST print in regular fonts (12-point fonts) - Declared on Day 1.
|
3.1 Project
3.1.1 One team project:
database, 55 points (45 points on database and written report, 10 points on presentation).
3.1.2 One individual project: spreadsheet, 30 points.
3.1.3
For team project, form teams of five (5) persons. Different problems will be assigned to different teams.
3.1.4
For individual project, different problems may be assigned to different students.
3.2 Homework Assignments: Fourteen (14) individual homework assignments ("homework"
hereafter):
- 15 points each: two database (on paper), one Access (on paper), two Excel (online) - subtotal of this group is 75 points (5 X 15);
- 10 points each for nine Salesforce exercises, except for the first Salesforce lab which is 5 points (subtotal 85 points: 1 X 5 + 10 X 8).
3.3 Duration and due dates of homework and projects:
3.3.1 All homeworks are due in 7 days unless announced otherwise (2-3 Salesforce labs may be assigned in a week, and each assigned group are expected to be completed in 7 days).
3.3.2 Projects have longer durations, and due dates will be announced respectively.
***3.4 All individual homework must be completed INDEPENDENTLY . This requirement is to avoid disputes over academic dishonesty. BOTH parties involved in copying (the "taker" and the "giver") will be eqaully punished.
[Given such exagerated big font, there is NO REASON for any one to miss this precaution].
[MULTIPLE incidents - in each class - happened in Fall 2017 and Fall 2018; students involved were caught and punished].
***4. Late Submission is NOT accepted, with NO exception
4.0 All homeworks/project are due by the beginning of the class on due date.
4.1 There will be ABSOLUTELY no late submission for any homework/project. [This policy will be STRICTLY enforced: for the benefits of students - will explain in class]
4.2 Staying away from a class to finish a due assignment is prohibited. Any assignment submitted 15/30 minutes
(for Afternoon/Evening classes, respectively) after the beginning of the class is considered late. No excuse will be accepted and no exception
will be made regarding late submission. [The above "grace period" is given for traffic/parkikng difficulties STRICTLY. I never meant for you to use those 15/30 minutes to complete (including printing) your assignments]
6.
Academic Integrity
** This issue is brought up on Day 1 of the semester; Please review this section when the first homework is assigned. Any cheating behavior happens is against two wartnings given - one on Day 1 and one on the day of the first assignment. So any offense is NOT tolerated or excused since the class has been warned TWICE.
***COBAE
Student Core Values Statement and Ethical Conduct Pledge***
Academic integrity is of critical importance to all business students, especially Accounting and Information Systems students..
Academic dishonesty of any form will NOT be tolerated. Acts of academic
dishonesty include:
A.
Cheating:
1) Represent the work of others as their own (such as copy other students' work, including using a formula or code created by another student);
2) Submit the same academic work (or a substantial portion of it) for credit in
more than one course without authorization.
3) Use references in a close-book, close-note exam, or use unauthorized
materials or aids in a take-home or open-book exam;The use of any electronic device [including electronic dictionary] during an exam is strictly prohibited.
B. Fabrication: Attempt to alter and resubmit returned academic work with intend
to defraud the faculty member.
C. Facilitating academic dishonesty: intentionally
or knowingly help or attempt to help another to commit an act of academic
dishonesty
** - providing answers/formulas/solutions to
another student for an independent homework/assignment falls in this category.
C.1. To help one's friends, one can eaplain the textbook's contents, or the class demo questions to his/her friends.
** But one is advised NOT to show his/her friends how to solve a homework/project problem.
D. Plagiarism: copy materials from a textbook or
from materials taken directly from a website without proper citation.
The Accounting and Information Systems Department has an official "Academic Honesty Message" for all students taking courses offred by the Department: "In striving for excellence in your academic work, consider honesty to be a part of your grade. In creating a network among your peers, think about how your actions may be judged by future employers who could easily learn of the manner in which you handled both the opportunities and pressures to cheat in your schoolwork"; "Our renewed vigilance in preventing cheating includes a commitment to rigorously enforce penalties for such actions, including but not limited to barring access to the EY Center for Careers in Accounting and Information Systems and recruiting activities such as firm tours and campus interviews, as well as assigning grade penalties. Faculty members have been instructed to report all suspected cheating activities to me as Department Chair". For the complete Message, please click the link.
An act of academic dishonesty will automatically lead to zero credit for the exam or project/assignment where the act happens , and may lead to a grade of "F" for the course for the student(s) involved . The instructor may take additional action in accordance with the CSUN policies. See CSUN Catalog (http://catalog.csun.edu/policies_/academic-dishonesty/ ) for further information on the policies and procedures concerning plagiarism and cheating.
| The students involved in any type of academic dishonesty (most commonly copying formulas from each other) will be asked to sign a statement acknowledging the incident. |
(1) Total possible points:
| Midterm Exams: 2X100 | 200 |
| Final Exam (comprehensive) | 140 |
| Projects and Assignments | 160 |
| Total: | 500 |
(2) Grade scales:
| Letter Grade | Points | Percentage Range |
Note on grades not shown on the list: | In short: |
| A | 465-500 | 93-100% |
In order to avoid unnecessary disputes, a C- will NOT be given in this course; so for those who got a grade 70-72.9%: remember you actually earned a C- but I gave you C. For those who got D or D+, there is no reason for me to give a C since I already given a truye C- a "C" grade; the fact that you a're D+ means you are absolutely not even in C- range. For the D-grade, there is no D+ or D- given officially; but at the end of semester if one receives a D+ or D-, that means I pushed the student up to give him/her a slightly higher grade: A D+ / D- actually very likely would be a D- / F but I gave the student a slightly higher grades to help with his/her GPA. If one sees a D+/D-, the student is advised not to dispute the grade because in that case s/he would be given back the grade s/he earned, i.e., D- or F. |
I would only give you a grade the same or higher than you have earned, but not lower; if one disputes, the result would be: given the real grade which s/he has earned. |
| A- | 450-464 | 90-92.9% |
||
| B+ | 435-449 | 87-89.9% |
||
| B | 415-434 | 83-86.9% |
||
| B- | 400-414 | 80-82.9% |
||
| C+ | 385-399 | 77-79.9% |
||
| C
(I gave C- a C) |
350-384 | 70-76.9% |
||
| D | 300-349 | 60-69.9% |
||
| F | <300 | Below 60% |
NO curve on individual exams. At the end of the semester, *IF* the class GPA is lower than
2.2, a curve may be applied.
COMPUTER FACILITIES
Computers are available for use in the College of Business' Microcomputer Lab
(BB2129 / BB2125).
COBAE Computer Lab Web Site
The computer labs in the Oviatt Library and Sierra Hall are available for you to use. These labs are open longer
hours and on the weekends. Follow this link to find the days and hours: Other Campus Computer
Labs.
*** Free tuoring provided by the Business Honors Association (BHA).
ADA STATEMENT
Qualified students with physical or documented learning disabilities have the right to free accommodation to ensure equal access to educational opportunities. The student,
if seeking special accommodations, must notify the Disability Resources and Educational Services (DRES)
(110 Bayramian Hall) and the instructor by the end of the second week of the semester.
TENTATIVE SCHEDULE
Please pay attention to the announcements in class, on class web, and on class Canvas site.
See Canvas class site for details of modules/units.
*** IMPORTANT: The instrucor intentionally left materials from last semester for reference; HOWEVER, all official materials for this semester will bear the year "2019"; in other words: those without the year "2019" are UNofficical.
Tentative Spring 2019 schedule: (Chap 1 PPT posted for "Week 1" in the table below for those who are not enrolled)
| IS 312 Spring 2019 Tentative Schedule (Exam dates fixed) | No enrollment accepted after 1st class in Week 2 | |||||||||
Mon |
Tue |
Wed |
Thu |
Fri |
Sat |
Sun |
||||
| Week 1 | Jan | 22 |
23 |
24 |
25 | 26 | 27 | Syllbuas, Chap 1 (1/2) Ch1 PPT | ||
| Week 2 | 28 |
29 |
30 |
31 |
1 | 2 | 3 | Chap 1; Chap 2; Database | ||
| Week 3 | Feb | 4 |
5 |
6 |
7 |
8 | 9 | 10 | Database - HW 1 screenshots | |
| Week 4 | 11 |
12 |
13 |
14 |
15 | 16 | 17 | Database | ||
| Week 5 | 18 |
19 |
20 |
21 |
22 | 23 | 24 | Database | ||
| Week 6 | Exam 1 | 25 |
26 |
27 |
28 |
1 | 2 | 3 | Exam 1; Data Communicaitons | |
| Week 7 | Mar | 4 |
5 |
6 |
7 |
8 | 9 | 10 | Datacom/Networking | |
| Week 8 | 11 |
12 |
13 |
14 |
15 | 16 | 17 | Datacom/Networking | ||
| Week 9 | 18 |
19 |
20 |
21 |
22 | 23 | 24 | Spring Break; no class | ||
| Week 10 | 25 |
26 |
27 |
28 |
29 | 30 | 31 | Networking/Security | ||
| Week 11 | Apr | 1 - Caesar Chevaz Day |
2 |
3 |
4 |
5 | 6 | 7 | Security | |
| Week 12 | Exam 2 | 8 |
9 |
10 |
11 |
12 | 13 | 14 | Ex2; Biz Process/Enterprise Sys | |
| Week 13 | 15 |
16 |
17 |
18 |
19 | 20 | 21 | Enterprise Sys | ||
| Week 14 | 22 |
23 |
24 |
25 |
26 | 27 | 28 | Analytics | ||
| Week 15 | May | 29 |
30 |
1 |
2 |
3 | 4 | 5 | Adv Excel | |
| Week 16 | 6 |
7 |
8 |
9 |
10 | 11 | 12 | Sys Development | ||
| Finals: | 13 - 10:15 |
14 |
15 |
16 - 15:00 |
17 | 18 | 19 | Finals Week | ||
*** The following schedule is from Spring 2018; the reason for leaving it here is for the students to access the instructor's tutorials.
*** Please do NOT confuse
*** The following "schedule" is NOT to be followed: it was that of Spring 2018;
*** it is retained to provide links to instructor-created materials (mostly Access and Excel tutorials)
|
|||||
Wk: Dates |
Class Contents |
|
After Class | ||
| 1: 1/22 (M); 1/24 (W) | Introduction: Policies, Moodle class; announcements; |
IS/IT - Fast-growing occupations |
|
||
| 2: 1/29 (M), 1/31 (W) | Chap 2 (Strategic Info Sys); |
||||
3: 2/5, 2/7 |
Chap 3; PlugIn 3; DB w Access Tutorial 2 (Queries); Navigation inside MS Access ; Database project assigned today ===> |
Demo DBs: Revised Restaurant DB; Book-Finder DB |
|
|
IE:
(1) Right click; (2) Save Target As; (3) Change file type from HTML to "All files"; (4) Change file extension name to ".accdb" Chrome: (1) Right click; (2) Save Link As - ALL DONE! |
4: 2/12, 2/14 |
DB w Access Tutorial 3 (Total queries - *DIFFICULT* point); |
||||
| >>> >>> Total Query highlights | |||||
5: 2/19, 2/21 |
|
||||
6: 2/26, 2/28 |
|
||||
7: 3/5, 3/7 |
Excel: Goal Seek (continued on Tutorial 1); Excel Tutorial 2 (IF, nested IF, COUNTIF, SUMIF); Demo 2; |
||||
8: 3/12, 3/14 |
Excel Tutorial 2 (cond: CountIF, SUMIF); |
||||
| 9: 3/19, 3/21 | |||||
10: 3/26, 3/28 |
Tutorial 3 (cont); Demo 3 (cont) |
A simple expert system example |
(Old) Spreadsheet project (for ref) |
||
| 11: 4/2, 4/4 | |||||
12: 4/9, 4/11 |
|||||
| Help with the logic of "Library Book" problem | |||||
13: 4/16, 4/18 |
Pivot table (Handout 4; Demo spreadsheet)
|
|
(Old) Excel HW4 (IF+Lookup; IF+Lookup across sheets) (for ref) Detailed hints posted: here |
||
| New: ==> | Cross-sheet reference demo | <=== * * * Learning: ... | cross-sheet refernce in Tutorial 3 ... | "Workbook" *** | |
14: 4/23, 4/25 |
| (Old) Excel HW5 (SUMIF, COUNTIF, nested IF, SUMIF w multiple criteria, VLOOKUP across sheet) (for ref)
|
|||
15: 4/30, 5/2 |
Ch 11 Org info sys
|||||
| Green | The ABOVE are the action items. | The ABOVE are action items. | The ABOVE are action items. | The ABOVE are action items. | |
| Zone | Contents BELOW are FYR only. | Contents BELOW are FYR only. | Contents BELOW are FYR only. | Contents BELOW are FYR only. | |
| (For 2017) | Database presentation guidelines | ||||
16: 5/7, 5/9 |
Ch 13 (SCM), Ch 14 (Systems acquistion); Excel wrap up |
||||
17: 5/14
|
|||||
| 17: 5/14 | (Also see Rainer's own Chap 1 slides ) | ||||
The Instructor's Motto
Self portrait:
A nice person of PRINCIPLE:
- Respects the students while be honest with them on their weaknesses – to
help them grow
- Always says “Yes” when he can, but never hesitates to say “No” when he must
Favorite Quotations:
* By Nature all men are alike, but by education become different -- Anonymous
* 学如逆水行舟,不进则退。Learning is like rowing upstream, not to advance is to drop behind -- Chinese Proverb
* 知之者不如好之者,好之者不如乐之者。He who has a knowledge in a
matter is not as good as he who is interested in it; he who is interested in it is not as good as he who enjoys doing it -- Confucius (Chinese philosopher
and educator, 551 B.C. - 479 B.C.)
* The successful person has the habit of doing the things failures don't like to do. They don't like doing them either necessarily. But their disliking is subordinated to the strength of their purpose. -- Stephen R. Covey: The Seven Habits of Highly Effective People
* We must do what America
does best, offer more opportunity to all and demand
more responsibility from all . - Inaugural Address of United States President William J. Clinton, January 20, 1993
* (Last, but not
the least) Eureka! - California State Motto
Back to Top
Last update:04/23/2018
| Home | Classes | Vita | Publications |
| MISA | Acct & IS | COBAE Home | CSUN Home |