Please read thoroughly; you are required to be familiar with the course syllabus and policies.

Note: Syllabus content, course due dates and assignments may change at any time. Canvas will notify you of any changes during our course.

• Instructor: Amelia Garripoli
• Office: TEC-210 (Bremerton)
• Office Hours: Mon 10-11 & Tue 1-2 (on-campus or online), or by arrangement
• Office Phone: (360) 475-7588 (M-Th, checked in the morning)
• Website: faculty.olympic.edu/agarripoli
  
• Skype ID: Prof. Garripoli, Bremerton WA
• Email: agarripoli@olympic.edu
  Send Course questions through the Canvas Inbox.
  Do not send assignments to my email or Canvas Inbox, they will not be accepted for grading. All assignments must be submitted through Canvas. I do not monitor email or Canvas during weekends, holidays, or breaks. Resend if you get no response from me within one business day during the term; your message may not have reached me.

• Catalog description: In this course you will plan and design relational databases; and mine and analyze data using Structured Query Language (SQL) with real-world applications. Topics covered include: data modeling, data normalization and integrity, advanced queries, data manipulation, data analytics and functions, and tabular and graphical representation of analysis findings. There will be an overview of data analytics, including issues of privacy and security. An introduction to NoSQL databases is included.
• Prerequisite: 2.0 in IS 300 or permission of instructor.
• Credits: 5 (4 lecture hours and 2 lab hours)
• Class dates: Sep 25 - Dec 8, 2017. School holidays: Oct 9 (Monday), Nov 10 (Friday), Nov 15 (Wednesday), Nov 23-24 (Thu-Fri).
• Class format: This is a hybrid class with on-ground activities. Evening lab attendance is required.
  • Lecture: Monday-Thursday 9-9:50 am
  • Lab: Tuesday 5-7 pm
  • Recordings: Recordings of lecture will be available live and via MP4 through Zoom.
• Location: Class: BUS 106.
• Final Exam: Dec 12 5-7 pm
• Technology required:Active OC Canvas account; campus lab access or a PC or MAC with sufficient capabilities and for installing and using course software; Internet access; Microsoft Word software.
• Text Required: Murach's MySQL 2nd Edition, by Joel Murach
  Published by Murach, Copyright 2015, ISBN: 978-1890775820
• Resources: Lab and library resources will be provided.
• Required Technology: Active OC Canvas account; campus lab access or a PC or MAC with sufficient capabilities and for installing and using course software and a high speed Internet connection, headphones and webcam.
• Core Abilities: IS 330 meets the Core Abilities of Thinking and Global Perspective.
• Learning Outcomes:

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

  • Design and test relational database systems that include complex data models and relationships
  • Construct and test advanced queries to extract and manipulate data from multiple databases to answer specific analytics questions
  • Present and analyze examples of applications of data analytics in different information systems contexts and discuss the role that analytics can play supporting business decisions
  • Evaluate, select and apply analytics processes and functions to solve business problems with privacy and security considered, and justify the selected analytics process
  • Evaluate, select and apply data representation formats that are best suited to the business case and to the audience

Visit the course Web site often for current assignments information, due dates, and messages.
The Grades section will show you the work you have submitted and the feedback for it.

See the Canvas Course or your Canvas Calendar for the current schedule of assignments.

All work is to be submitted on Canvas using posts in Discussions, submissions in Assignments, and by submitting Quizzes; these can be found directly in the "Assignment" section of the course Canvas site, or in module context using the "Module" link on the Canvas course navigation to access the modules for this course.

See the Canvas Course or your Canvas Calendar for the current schedule of assignments. The final module spans several weeks, as noted above. Make progress each week to ensure timely completion of your work. If you wait to start the final project, you may find it very difficult to complete it on time with sufficient depth and content.

Each week you will have the opportunity to develop your database skills with a wiki post, individual lab work, and group project. Each module contains a series of activities around its concepts.

The final module is a group research project utilizing skills from IS390 and what you have learned in this course. Your group will research and then present its findings to the class.

There are 940 possible points in this course. Refer to Canvas for specific points on each assignment.

Even with sufficient points, you may be administratively withdrawn from class if you do not demonstrate participation for two or more consecutive modules.

Point Distribution:

• Group Project—42%
• Individual Exercises—32%
• Wiki Contributions—26%

1. 9 group lab activities — 40/80 points each for 400 points

   Students will work in groups in modules 1-8 to develop a database application that can become a portfolio item. This includes coding web pages to access the database through PHP. Each week the project will be progressed based on the SQL skills developed that week. During the NoSQL module, the group writes a quick-start and gives a presentation on a NoSQL area; this module is worth 80 points.

2. 9 individual lab activities -- 30/60 points each for 300 points

   Students will be completing exercises based on the module's contents. To enable mentoring, these exercises will be completed after the group lab so that the group can familiarize their members with the module topic. The module exercises are individual work, however, and should be completed by each student individually. Labs 1-8 are worth 30 pts. each. For Module 9 NoSQL, students will complete team evaluations to determine individual contributions to the group labs. The final lab is worth 60 pts.

3. 8 individual wiki contributions — 30 points each for 240 points

   Beginning in module 1 and continuing throughout the course, students will build an SQL wiki in a collaborative website. With each module, you will have the opportunity to contribute a page and have it reviewed by your team's SQL lead.

   The purpose of the wiki is to reinforce what you have learned by summarizing and explaining it in writing, and reviewing summaries from your peers. This wiki will grow during the term and should also be a resource for past modules' contents. It is a space to practice providing information about technology to your peers and evaluating your peers' work, useful and necessary skills in the IT workplace.

Your grade for the class will be assigned by converting your total points to a percentage grade, by dividing them by 9.4. So if your total points was 760, your grade would be 80%, which is a B-, GPA 2.7 in our chart. If a student fails the course with a 0.0 or is assigned a NC, WP, or WF, the instructor must report a last attended date. The last attended date used in this course will be the date of the last submitted work accepted for grading.

Points on work submitted on-time are posted as soon as possible, usually within 7 days of the due date; a bit more during exams or if my schedule gets impacted. My goal is to give reasonable feedback to as many students as possible in the shortest time possible. For discussions, grading is done after the replies are due. If I have a larger than normal grading load, I will notify you of any delays in grading. See Policies for information on getting assistance, submitting work, academic honesty and more.

Monitor your course progress and see what you have submitted by clicking on "Grades" on the course navigation on the course website.

Rubrics are supplied for assignments in the course shell.

Please note the following guidelines and approaches to success in this course:

• Contribute to the class by attending regularly and engaging in discussions.
• Set up a plan and actively pursue each course milestone to ensure you complete your assignments on time.
• Demonstrate a level of engagement through careful listening and attention to details and due dates.
• Apply a professional level of communications throughout the course both verbally and in writing.
• Adhere to proper spelling, grammar and punctuation as if communicating in a professional setting.
• Stay current with course materials and observe, read, experiment, and otherwise absorb course content.
• Take ownership for learning, and deliver quality products worthy of portfolio content.
• Maintain access to sufficient equipment and internet bandwidth to complete course work.
• Seek help immediately when problems or challenges arise.

1. Ask for Help:

   First, if you need help, get help early and often - if you wait until it is a crisis, it will be too late.

   Here are some resources to get help in this class:

   • Contact me through Canvas or email for help - please give sufficient detail, including which assignment you are asking about and your issue.
   • Call, skype, or stop by during my office hours - hours and number stated above. I am available outside of the listed hours by arrangement as well, online or phone. Skype can be used if screenviews are needed.
   • Bring up any issues in your weekly mentor session.
   • Haselwood Library has LibGuides, an assortment of online CIS texts.
   • The Writing Center offers assistance with writing online and by appointment.
   • BUS-106 will be available during class time and also at other times. A schedule will be posted on the course Canvas site once it is available.

   If you need help outside of class material, there are a wide variety of resources available to you. See Campus Resources for assistance.

2. Assignments:

   By taking this class, you are stating that you will be making appropriate time in your schedule to ensure success and have access to the resources required for this class. Research can be very time-intensive, so budget accordingly. Expect to spend 12-15 hours outside of class per week for every class credit to ensure success. If you usually take more time on coursework, be sure to allocate additional time. Start your research early and be proactive. Make regular progress on the research itself.

   1. Due dates: Assignments are due on time / date as noted in the Canvas classroom. Online postings are due by 11:59:00 pm of the due date. You can post assignments any time during the current module. Please do not wait until the last minute to post. All assignments are due by 11:59:00 pm of the due date listed for a given item using the appropriate drop box. No assignment will be accepted for grading after the last scheduled day of classes. See the late policy for grading on late work.
   2. Monitor Your Progress: You can monitor your progress by going to the Grades area in the Canvas classroom. Contact your instructor right away if you notice any discrepancies between an expected assignment grade and what is reported in the gradebook.
   3. Deliverables: You must do your own work; consultation with others is fine, but the end-products must be your work; don't copy the work of others, or have others to do your work. You will be asked to evaluate your peers' work in the final module.
   4. Attendance: Regular progress is strongly recommended for success in this class. The modules build on each other; you will not be able to succeed in this class by cramming in each module in an hour a week or by researching and writing a paper in the final week. Check in with the Canvas shell on a regular basis each week, and participate in all lab meetings. Material will be provided in labs that is not available in Canvas, and vice-versa. You are responsible for accessing and using all required resources provided, and doing so will be important to your success in this course.
   5. Submitting Work: You will be maintaining your group project and wiki on Github, so valid Github accounts in the Cohort organization will be used; the repositories will be private.

      All work must be submitted on Canvas. Ensure that all assignments are attached/submitted properly. It is your responsibility to ensure that all student submissions are in their proper place by their deadlines. Open a new browser window to check your submission, and do it early enough that you can resubmit before the due date if needed.

      Submissions submitted on time will be graded within one week of their due date, unless we have heavier than normal professional obligations, in which case you will be notified of the delay. Your grade will be based on the content, quality, accuracy, and timeliness of your assignment. Additional rubric detail is available in the course shell.

3. Late Policy:

   Lab discussions and activities must be participated in at the time they occur. If you cannot attend a lab, please contact us at least 24 hours prior to determine an appropriate alternative activity and completion time for it.

   Work will only be accepted late by prior arrangement; you must contact the instructor by the due date if you will not be submitting your work on time.

   Wiki posts need to be submitted on time for timely use by the whole class and timely review by your team's SQL expert. If they will be late, arrangements need to be made with both the instructor and the SQL lead to ensure review.

   Other work will only be accepted up to one week late, up to the last regular class meeting of the quarter. There is up to a 10% penalty/week for late work, prior to grading. Work over one week late will not be accepted for grading without serious extenuating circumstances. No late work is accepted for grading after the last regular class meeting for the quarter, even if it is less than one week away.

   Any exceptions to this late policy must be agreed upon no later than one day prior to the due date; exceptions will only be made with verifiable proof of your inability to do so (for example, an accident report or emergency hospital admission), no exceptions.

   Late submissions will be graded at the instructor's discretion with respect to timeframe and penalty deductions.

4. Connectivity:

   Everyone experiences technical difficulties including the Canvas website, the K-20 network, your Internet service provider, or hardware issues. Have an alternate plan in the event of technical difficulties, and do not wait until the last minute to submit your work. Know where your local WiFi hotspots and computing resources are and be prepared to get to them to submit your work on time. There are labs on each Olympic College Campus. Please notify us immediately if the issue cannot be handled by your alternate plan (i.e., wide area power outages or Canvas outages).

5. Etiquette/Netiquette:

   This is a college level class. It is expected that the instructor and the students will be tolerant of others' views, be respectful in dealing with others, and use standard professional English in their communications, both written and verbal. Swearing is not respectful. Remember that capitalization and exclamation points are considered yelling, and texting lingo is not professional. Any violations of this policy may result in lowering of an assignment grade or your overall course grade, reporting the violation to student services, or administrative withdrawal from the course. Ask first if you are not sure if your note is offensive, and respect the opinions of others. Refer to the applicable WAC on student conduct.

6. Email: Netiquette applies to email text as well. Please follow these guidelines:
1. Send course email through Canvas, not to my OC email. You will get faster turn-around, as Canvas takes priority during the term.
2. Use an appropriate Subject line, change it if you are starting a new topic in a reply. If you send multiple replies before I respond, note that I may not see the earlier replies due to the way Canvas presents messages.
3. I will respond to all Canvas messages within one school day during the term; on weekends, holidays, and breaks I am generally not checking messages and may not respond until the next school/contract day. If I have not answered your message within this timeframe, please re-send it and let me know as it may not have been received.
4. Never assume email is private; others may be able to read or access your email, or it may be forwarded.
5. If you do send email about the course to our @olympic.edu addresses, we generally aim to respond within 2 school days to emails from olympic.edu addresses during the term; on evenings, weekends, holidays, and breaks we are generally not checking email.
6. We cannot respond to student inquiries from non-olympic.edu email addresses. This is per OC policy. We can respond to all Canvas messages, and you can set Canvas up so it forwards messages to, and accepts replies from, your non-OC email.

7. Academic Honesty:

   Plagiarism and cheating are serious offenses and may lead to a failing assignment grade; failure in the course; and/or expulsion from the College. For more information refer to the Student Code of Conduct. Academic dishonesty includes cheating, plagiarism, fabrication, and facilitating academic dishonesty. Facilitating academic dishonesty includes providing your own work to someone else for their solution; do not put others in this situation, they cannot provide you with solutions, only guidance. Fabrication includes making up sources that do not exist; you must be able to produce all of your sources if requested.

   You are encouraged to work with one another to understand and discuss general concepts and approaches, but your work must be your own, and your writing must be in your own words. Except for group work, the assignments are to be completed individually, and as such you are expected to work on your own. I reserve the right to refuse to accept any assignment if you cannot demonstrate the ability to perform similar work when asked, if you cannot explain your answer or the approach that you have used, or if you cannot produce a source when requested. You need to develop and internalize the work yourself.

   This is particularly important when learning a language; it is easy to google and scrape answers from websites and forums, but that does not teach you the language. Doing the lab yourself, asking questions of your team's SQL expert, the tutors, and the instructor, are how you will learn SQL. Any work taken from outside sources needs to be appropriately cited and only when permitted in the assignment. All uncited work is expected to be your own. Images must be appropriately sourced and cited as well.

8. Recordings:

   All recordings provided for this course through Canvas are © Copyright Olympic College. If you have copied or downloaded any of the recordings, you must delete them once the term completes. Olympic College does not grant permission to retain recordings of class material. See the OC Copyright Policy.

9. Internet Safety:

   It is your responsibility to be aware of the impact of your actions when using the internet, with respect to managing your privacy, using the information you access, and maintaining machine security. For more information on this topic, see Thinking about Online Safety.

10. WAC Regulations:

    Please review Olympic College's WAC 132C regulations. The various WACs have been passed by the state of Washington and are Washington State law that govern the behavior of the administration, faculty, and students.

Any failure to comply with these policies may result in lowering of an assignment grade, your course grade, or reporting to Student Services.

Olympic College provides equal opportunity in education, employment and college activities regardless of race, color, national origin, age, perceived or actual physical or mental disability, pregnancy, genetic information, sex, sexual orientation, gender identity, marital status, creed, religion, honorably discharged veteran or military status, use of a trained guide dog or service animal, or any other unlawful basis. If you witness or encounter any such discrimination, including any sexual misconduct, you are encouraged to report it to the Title IX Coordinator, Cheryl Nuñez (CSC 317A; 360-475-7125; cnunez@olympic.edu) or the Equal Employment Opportunity Officer, David Slown, Executive Director for Human Resource Services at dslown@olympic.edu/306-475-7300, who will assist you in connecting with all possible resources. You may also report it online (and anonymously) at Report It, OC! or seek confidential counseling from Counseling Services at 360-475-7530 or at HSS 203. See also http://www.olympic.edu/nondiscrimination-title-ix.

Any student who feels they may need an accommodation based on the impact of a disability or a medically necessary absence due to pregnancy or childbirth should contact the Access Services office in HSS 205, by email at AccessServices@olympic.edu or by phone at (360) 475-7540. More information may be found on the Access Services website. Access Services must be contacted at least two weeks before the accomodation is needed.

Please contact me via Canvas or see me during office hours concerning your accommodation request(s) after you have submitted them to Access Services, so I can meet your needs in class.

Note that about 10% of all OC students have some type of disability, often invisible (like PTSD or asperger syndrome). As instructors, we cannot disclose a student's disability. The decision to share with others is a choice of the student.

Your success is both your goal and my goal! This class gives you an opportunity to develop and practice professional skills. I am here to support your efforts. If you have a problem or situation that is affecting your schoolwork, please let me know. Olympic College has many services to help students be sucessful. You can contact me by Canvas, e-mail, voice mail, office hours, or talk to me right before or after class.

Welcome to IS 330, I look forward to sharing my love of databases with you. \Amelia.

Note: Syllabus content, course due dates and assignments may change at any time. Canvas will notify you of any changes during our course.