Course Information
Instructor
Work with the Instructor
- Use Canvas Inbox email instead of regular emails for non-technical communications with the instructor. Inbox emails are threaded correspondences and easy to manage.
- Emails are generally responded to within 24 hours.
- If needed, the instructor's email address is tychen@university.edu.
Course Description
This course provides an overall examination of information systems and services concepts including system management, maintenance, quality assurance, reporting services, and management of physical and human resources as services. It includes an introduction to information system hardware components, operating systems, scripting languages, with practical applications in databases and networked servers. In addition, this course provides practice in managing the people, processes and events (planned or otherwise) involved in information system and information service management.
The information systems learning activities begin in the lectures, followed by lab sessions to provide the infrastructure (which usually require working outside of class to complete the lab assignments) for homework assignments. Homework assignments are designed so that the learner will practice and apply the concepts and skills covered in both the lectures and lab activities. The three exams are take-home exams that involve scripting, short answer, true/false, and matching questions along with others. They will cover materials from both the labs and lectures.
Learning Objectives
Upon successful completion of this course, students should be able to:
- Describe basic principles, practices, and components of information systems.
- Identify fundamental concepts and components of networked information systems.
- Identify common information system operation and testing procedures.
- Explain the relationship between different information system processes, including testing, development, maintenance, service continuity, and disaster recovery.
- Develop solutions for improving integration between technologies in order to streamline operations or automate processes.
- Apply critical thinking and problem-solving skills in identifying and trouble-shooting IT system problems.
- Apply critical thinking and problem-solving skills in identifying and trouble-shooting IT system problems.
Course Activities
Class Discussions (Lectures)
Class discussions ( lectures ) introduce students the concepts in information systems and services / management. The information services concepts are how information systems are created, implemented, and used in the organizational and management context, with an emphasis on the perspectives of IT professionals. The information systems concepts are introductions in computer science, information systems, and information technology, with chosen topics related to the context specified in this course and how to apply and integrate the elements to construct information systems as a way to provide information services.
Some the topics covered in the lectures include:
- Unix Systems
- Shell scripting vs programming
- Variables
- Environment variables & aliases
- Functions
- Conditional statements
- User input
- Iterations: for loops and while loops
- Bash arrays and shell variables
- String processing
- Regular expression
- IT infrastructure
- Information systems frameworks
- Data management lifecycle frameworks
- Business flow and best practice
- Project management & ITIL
- PM lifecycle phases
- ITIL lifecycle phases
- ITPM: SDLC and agile
- Data quality control and management
- Risk and change Management
Lab Activities
The laboratory activities ( labs ) are used to systematically practice the basic concepts and skills used in this course. The instructor will provide explanation and demonstration when necessary, and the students would work collaboratively to solve the problems.
The topics covered in the lab activities include:
- Activity 1. Operating Systems 1: Students will practice a variety of operating system command line functions and learn to navigate the file systems.
- Activity 2. Operating Systems 2: Students will practice operating systems commands and shell scripts to use and manipulate files.
- Activity 3. Operating Systems 3: Students you will practice operating systems commands and shell scripts to use and manipulate your computer environment.
- Activity 4. Databases in Information Systems 1: Students will begin using database commands from the command line to create a database that they will use for the remainder of the course.
- Activity 5. Databases in Information Systems 2: Students will use database commands from the command line and in shell scripts to access database information.
- Activity 6. Data Management and Quality Assurance: Students will use shell scripts, operating system commands, and a variety of applications to manage databases and to ensure data quality.
- Activity 7. Backup Planning (concurrent with Activity 6): Students will practice using an automated database backup approach to guard against failures while updating running information systems.
- Activity 8. Operating Systems 4: Students will develop a shell script to manage the production of several database reports.
Course Assignments
Assignment Submission:
- All assignment (homework,lab activity, exam, and quiz) submissions will be accepted during the set assignment submission availability.
- Note that some homework assignments and lab activities must be done in order. For example, in order to run SQL queries, students must have completed the configuration of database system and imported the datasets.
- Late submissions will be granted only when they are:
- justified as excused situations per University attendance policy
- properly communicated in a timely manner (which usually means you notify the instructor 24 hours or more, unless it is an emergency, before the event preventing you from meeting the assignment submission deadline)
- with proper documentation (if deemed necessary).
Examination
Exams are comprehensive assessments of student learning over a period of time. There will be three take-home exams that will cover material from the discussions, lab activities, and homework assignments. The exams are mainly not cumulative, meaning they will only include materials from the time of the last exam to the current exam, but the learner will need the knowledge and skills from earlier assignments to complete them successfully.
Quizzes are formative evaluation and will only be given in class on the day and time. No makeup quizzes will be granted. In case of an excused absence, please communicate with the instructor in a timely manner for a makeup evaluation if required/desired.
If a makeup examination or quiz is granted, an alternative format ( e.g., essay, oral, or lab assessment ) may be used.
Homework
Homework assignments are designed to give students the opportunity to integrate the learning from the Discussion / Lecture and Lab activities. There will be multiple homework assignments for the students to practice conceptual and technical topics covered in class. Homework assignment instructions are detailed separately in each assignment and are due on the dates identified in the course summary.
Lab
Lab assignments and quizzes are quick formative assessments of student learning. Lab exercises are given for students to practice technical skills and increase conceptual understanding of the concepts and skills covered.& nbsp ;
Quiz
Quizzes are administerd and submitted during or soon after the class meeting to
- assess a student 's prior knowledge and diagnose student learning on specific topics.
- serve as records of class attendance.
Note: No late or makeup submissions for in-class assignments / quizzes are allowed as they are meant to be your attendance records and to evaluate whether you are following the class closely.
Course Materials
-
Laptop Computer: You are encouraged to bring a laptop computer to the class meetings for use in the hands-on activities.
- Textbook: No textbook is required for this course. Readings and practical materials for lectures and lab activities will be provided in class. Students are expected to complete all assigned readings and assignments prior to the date assigned and should be prepared to synthesize them to contribute during in-class discussions. The assignments will require the use of specialized computer software and working with a virtual computer system. Access to this system is provided for instructional use only.
- Software: Software applications needed for this course is available via https://labs.cci .university.edu.
- Help Desk: If you need help using the applications or have issues accessing the virtual machines, speak with the personnel at the CCI Help Desk (https://helpdesk.cci.university.edu) in the Department building or create a support request ticket.
Grading Scheme
Student grade in this course is determined by the performance on 1 ) homework assignments, 2 ) lab activities assignments, 3 ) exams, and 4 ) attendance and participation ( including quizzes ) .
The goal for this course is to enable students to complete all of these activities correctly following the “learning by doing” principle. The grading scale is based on the assumption that the learner will work independently and collaboratively to learn together so that the students can complete all the activities with very few errors. Generally, a student attending all the class meetings and complete all the assignments by schedule will do very well in this course, even with minimal prior technical experience. The grading scale below follows the default University grading scheme. The number of points needed for each grade is provided as a reference.
The following grading standards will be used in this class:
Grade Category | Number of Items | Points per Item | Maximum Points |
---|---|---|---|
Homework | 10 | 10 | 100 |
Examination | 3 | 50 | 150 |
Laboratory | 8 | 10/20 | 150 |
Attendance/Participation | 20 | 5 | 100 |
500 |
Letter Grade | Range |
---|---|
A | 100% to ≥ 93% |
A- | < 93% to ≥ 90% |
B+ | < 90% to ≥ 87% |
B | < 87% to ≥ 83% |
B- | < 83% to ≥ 80% |
C+ | < 80% to ≥ 77% |
C | < 77% to ≥ 73% |
C- | < 73% to ≥ 70% |
D+ | < 70% to ≥ 67% |
D | < 67% to ≥ 63% |
D- | < 63% to ≥ 60% |
F | < 60% to ≥ 0% |
Course Policies
Communications
- Please communicate with your instructor and peers in a timely manner and avoid last-minute requests whenever possible.
- Report any inappropriate communication considered to be of a serious nature to your instructor, as it may be a violation of University policy.
- Treat others with respect by making messages clear and succinct.
- Text messaging:
- Text messaging is considered a professional channel for quick problem-solving.
- Phone numbers of current students are not added to the instructor's contact list for privacy concerns.
- Do not assume the instructor knows the prior conversations as the messages may have been deleted.
- Do not introduce yourself when seeking technical assistance. Just state the course and topic, describe the problem and your thoughts, and present screenshots.
- Emailing: Typically, emails are responded to within 24 hours. If you do not see a response in 24 hours, assume the email is lost and resend the email or text a reminder message the instructor.
- Grading: Graded assignments are typically returned within 3 days after the due date.
- Please place a headshot in your online learning system profile, so the instructor can better match names and faces.
Attendance
- Definition of Absence: Excused absences, per university policy, include documented illness, deaths in the family, and other documented crises, call to active military duty or jury duty, religious holy days, and official University activities. These absences will be accommodated in a way that does not arbitrarily penalize students who have a valid excuse. Consideration will also be given to students whose dependent children experience serious illness.
- Communicate Professionally: Class meetings are business meetings. You are expected to attend all class meetings and participate in the class activities. Please communicate with the instructor professionally about your absence in a timely manner (this usually means at least 24 hours before the class meeting unless it's an emergency).
- Excuse Documents: In case of an excused absence, please attach your excuse documents in your communication with the instructor for records in a timely manner.
- In-class and Attendance Assignments: There are in-class assignments for formative assessment and attendance assignments for taking attendance. These assignments are for those who attend the class meetings only.
- Free Passes: Two to three lowest scores from the attendance assignments will be discounted automatically at the end of the semester.
- Multitasking: Unless you are being disruptive, multitasking (e.g., googling for fast fact-checks) is allowed in class. However, you are expected to take a seat in the back of the classroom if you intend to multitask often because that could be distracting for the instructor and your peers. Also, expect to be called upon to answer questions or share the information you find.
- First-Day Attendance Policy: The University has a mandatory first-day attendance policy for all classes, including online courses. Students who do not attend the first day of class will be dropped from the course. Any student who has been dropped for failing to comply with the first-day attendance requirement can re‐register for the course during the add/drop period. Students should confirm their enrollment in this course prior to the end of the add/drop period.
Academic Honor
We follow the University 's Academic Honor Policy to prohibit:
- plagiarism,
- cheating,
- unauthorized group work,
- fabrication, falsification, and misinterpretation,
- multiple submission,
- abuse of academic materials,
- complicity in academic dishonesty, and
- attempting to commit any above offense.
Failing to comply with the academic honor policy will receive a zero point for the assignment for all students involved, and the Office of the Dean of Students will be notified.
Technology Support
Canvas Help Desk
Help with Canvas is available by clicking on the Help menu located on the left-hand most menu on each student 's Canvas menu. There are multiple ways to request help, including using any of the contact options below:
- canvas@university.edu Email:
- Phone: (555)555.HELP
- Website: support.canvas.university.edu
- Hours: 8:00AM-5:00PM EST; Monday - Friday
The University ITS Service Desk
The University’s ITS Service Desk is the first point of contact for assistance with ITS Services at the University. There are multiple ways to request help, including using any of the contact options below:
- Submit A Service Center Ticket
- Phone: (555)555.HELP
- Website: its.university.edu/its-service-desk
- Hours: 8:00AM-6:00PM EST; Monday-Friday
University Policies
University Attendance Policy
Excused absences include documented illness, deaths in the family and other documented crises, call to active military duty or jury duty, religious holy days, and official University activities. These absences will be accommodated in a way that does not arbitrarily penalize students who have a valid excuse. Consideration will also be given to students whose dependent children experience serious illness.
Academic Honor Policy
The University Academic Honor Policy outlines the University's expectations for the integrity of students' academic work, the procedures for resolving alleged violations of those expectations, and the rights and responsibilities of students and faculty members throughout the process. Students are responsible for reading the Academic Honor Policy and for living up to their pledge to "...be honest and truthful and... [to] strive for personal and institutional integrity at the University." (For more details see the The University Academic Honor Policy and procedures for addressing alleged violations.)
Academic Success
Your academic success is a top priority for the University. University resources to help you succeed include tutoring centers, computer labs, counseling and health services, and services for designated groups, such as veterans and students with disabilities. The following information is not exhaustive, so please check with your advisor or the Dean of Students office to learn more.
Process for Resolving Academic Problems or Grievances
Please use this step-by-step guide to resolving academic problems to begin the process of communicating with your instructor to resolve any confusion or difficulty you may be having in the course. Detailed information on The University's grievance procedure, including special instructions for students enrolled in an The University branch campus, is maintained on the General Bulletin's Academic Integrity & Grievances webpage. Out-of-state distance learning students should review the Office of Distance Learning Complaint Resolution page for additional procedures.
Americans With Disabilities Act
The University ( The University ) values diversity and inclusion ; we are committed to a climate of mutual respect and full participation. Our goal is to create learning environments that are usable, equitable, inclusive, and welcoming. The University is committed to providing reasonable accommodations for all persons with disabilities in a manner that is consistent with academic standards of the course while empowering the student to meet integral requirements of the course.
To receive academic accommodations, a student:
- (1) must register with and provide documentation to the Office of Accessibility Services (OAS);
- (2) must provide a letter from OAS to the instructor indicating the need for accommodation and what type; and,
- (3) should communicate with the instructor, as needed, to discuss recommended accommodations. A request for a meeting may be initiated by the student or the instructor.
Please note that instructors are not allowed to provide classroom accommodations to a student until appropriate verification from the Office of Accessibility Services has been provided.
This syllabus and other class materials are available in alternative format upon request.
For more information about services available to The University students with disabilities, contact the
Office of Accessibility Services (The
City Campus)
874 Traditions Way
108 Student Services Building
The University
The City, State 55555-5555
(555)
555-9566 (voice)
(555) 555-5554 (TDD)
oas@university.edu
https://dsst.university.edu/oas
Student Accessibility Services (The City Campus)
Office
of
Student
Affairs
4750 Collegiate Drive
2nd Floor Barron Building (Room 215)
The University The City
The City,
STATE
32405
(555) 770-2172 (office)
(866) 693-7872 (toll free)
Email: sds@pc.university.edu
https://pc.university.edu/students/student-affairs/sas
Confidential Campus Resources
Various centers and programs are available to assist students with navigating stressors that might impact academic success. These include the following:
Victim Advocate Program
University Center A,
Room 4100, (555) 555-7161,
Available 24/7/365,
Office Hours: Monday-Friday 8am-5pm
https://dsst.university.edu/vap
Counseling
&
Psychological Services (Main Campus)
Askew Student Life Center, 2nd Floor
942 Learning Way
(555) 555-8255 / (555) 555-TALK
https://counseling.university.edu/
University PC Counseling Center (The City
Campus)
Barron Building, Room 303
(555) 770-2174 (office)
(555) 832-3594 (cell)
https://pc.university.edu/students/student-affairs/counseling-Center
University Health Services
Health and Wellness Center
(555) 555-6230
https://uhs.university.edu/
Syllabus Change Policy
Except for changes that substantially affect implementation of the evaluation (grading) statement, this syllabus is a guide for the course and is subject to change with advance notice.
Course Summary
All course assignments and texts with due dates are listed below. To be successful in this course, be sure to complete all required assignments and tests by the due date.
Date | Details | Due |
---|---|---|
Wed Jan 5 | Assignment VM List | due by 11:59pm |
Fri Jan 14 | Assignment SCP test.txt to the VM and local class directory | due by 11:59pm |
Assignment VM Account Info | due by 11:59pm | |
Sun Jan 16 | Assignment SQLite-chnook.db Screenshot | due by 11:59pm |
Sat Jan 22 | Assignment SQLite CRUD Lab 01 | due by 11:59pm |
Mon Jan 24 | Assignment SQLite CRUD Lab 02 | due by 10:30am |
Fri Jan 28 | Assignment Attendance Jan 28 | due by 10:25am |
Assignment CRUD Lab 3 in-class Submission | due by 10:30am | |
Assignment SQL Keywords of Different DBMS | due by 11:59pm | |
Assignment | due by 11:59pm | |
Mon Jan 31 | Assignment MySQL Admin in-class Submission | due by 10:30am |
Wed Feb 2 | Assignment CRUD with Workbench in-class | due by 11:59pm |
Sun Feb 6 | Assignment CRUD Lab 3 | due by 11:59pm |
Assignment CRUD with Workbench HW | due by 11:59pm | |
Mon Feb 7 | Assignment CRUD Lab SQL Script in-class | due by 10:30am |
Fri Feb 11 | Assignment source employees.sql | due by 9am |
Assignment Attendace 02-11 | due by 10:30am | |
Sun Feb 13 | Assignment IBM HR Employees DB | due by 11:59pm |
Mon Feb 14 | Assignment MySQL Example employee DB CRUD w07 | due by 10:30am |
Tue Feb 15 | Assignment MySQL employees DB CRUD w07 HW | due by 11:59pm |
Wed Feb 16 | Assignment DB SQL Queries w07-2 (MySQl employees DB) Retake | due by 10:30am |
Sat Feb 19 | Assignment ER Conceptual Model with Relationships University DB | due by 11:59pm |
Wed Feb 23 | Assignment ISM4212 DB Midterm | due by 10:10am |
Mon Feb 28 | Assignment Attendance 02-28 | due by 11:59pm |
Wed Mar 2 | Assignment ERD Physical Model & Implementation | due by 11:59pm |
Assignment Mary vs. FBI (INNER JOIN) | due by 11:59pm | |
Fri Mar 4 | Assignment Salary Report | due by 11:59pm |
Mon Mar 7 | Assignment Current Employees Salary Report | due by 11:59pm |
Thu Mar 10 | Assignment Order & Customer Tables | due by 11:59pm |
Fri Mar 11 | Assignment Attendance 03-11 | due by 10:25am |
Assignment JoinT Table Mini Lab (Reverse Engineering) | due by 11:59pm | |
Mon Mar 21 | Assignment SQL Query Review | due by 11:59pm |
Tue Mar 22 | Assignment The Car Table | due by 11:59pm |
Wed Mar 23 | Assignment SELECT Stmt | due by 11:59pm |
Thu Mar 24 | Assignment index.html Products Orders page | due by 11:59pm |
Fri Mar 25 | Assignment something/test.html | due by 11:59pm |
Assignment SQL Practice | due by 11:59pm | |
Tue Mar 29 | Assignment PHP MySQL Connection Script | due by 11:59pm |
Fri Apr 1 | Assignment SQL Review w12 | due by 11:59pm |
Mon Apr 4 | Assignment Project Ideas | due by 11:59pm |
Assignment Insert Form Data to DB | due by 11:59pm | |
Wed Apr 6 | Assignment SQL Practice: INNER JOIN | due by 11:59pm |
Fri Apr 8 | Assignment inventory.php | due by 11:59pm |
Assignment processing.php | due by 11:59pm | |
Assignment SQL Practice 04-08 | due by 11:59pm | |
Assignment Your True Color | due by 11:59pm | |
Mon Apr 11 | Assignment Workflow In-Class | due by 10am |
Assignment Create DB/Tables | due by 11:59pm | |
Assignment UNION/UNION ALL | due by 11:59pm | |
Sun Apr 17 | Assignment Project Workflow Pages | due by 11:59pm |
Mon Apr 25 | Quiz ISM4212 DB Final Exam | due by 10:10am |
Assignment ISM4212 DB Final Exam | due by 10:10am | |
Assignment Project Presentation/Review | due by 11:59pm | |
Wed Apr 27 | Assignment Project Report Submission | due by 11:59pm |
Assignment Attendance Jan 24 | ||
Assignment ER Conceptual Model University DB | ||
Assignment Extra Credit |