Course Syllabus
Computer Information Systems 205 |
This page contains the syllabus for Computer Information Systems 205 – Database Management Systems, as offered in the Summer 2021 Semester at Community College of Philadelphia.
It is published by the instructor as communication and contract with students. For official College information, including course listings, schedules, etc., contact http://www.ccp.edu/.
|
|
For information on Computer Information Systems and Computer Science programs and courses at Community College of Philadelphia try:
Description
Computer Information Systems 205 - Database Management Systems
4 credits (8 hours lecture, 2 hours lab per week)
This course introduces the design and implementation of relational database management systems using Structured Query Language (SQL). The course covers fundamental database design and implementation techniques and provides hands-on exercises for applying the techniques to real-world problems using database management software such as Oracle, Maria DB, or MySQL.
Prerequisites: CIS 103.
Course Learning Outcomes
- Database Management - Use a modern database management program such as Oracle, MySQL, and PostgreSQL to perform such tasks as writing operational and correct SQL (DDL, DML, and DCL) statements.
- Database Fundamentals - Write SQL statements that perform fundamental database concepts, including Relational Algebra, and successfully use a Relational Database System.
- ER Diagrams - Create and translate Entity-Relationship (ER) Diagrams using a software diagramming tool.
- Ethics - Explain common ethical issues related to the use of information technology systems and the handling of data, including privacy and security issues.
- Structured Query Language - Write operational and correct SQL (DDL, DML, and DCL) statements.
- Data Mining and Big Data - Describe new concepts and terminology in DBMS such as Data Warehousing, Data Mining, NoSQL, and Big Data.
- Database Design - Implement a relational database from initial requirements and conceptual design (ER Diagram) to the physical database in a modern enterprise relational database management system
Upon completion of this course students will also be able to:
- Design and Create Conceptual Relational Database Using a professional modeling application
- Implement Physical Database from a Conceptual Design
- Work as part of a professional team to design, code, test and debug normalized databases
- Correctly use the elements of Relational Algebra retrieving result sets from relational databases
- Create source code and execute SQL statements that are syntactically correct
- Demonstrate knowledge of input and output routines, data types, and data operations
- Demonstrate knowledge of key concepts in Database Theory
Who Should Take Course and Why
This course is structured for a student wanting advanced training in designing, implementing, and interacting with relational databases using professional Relational Database Management Systems RDMS. Additionally, students wanting to survey advanced concepts in Database Theory, Database Programming, and Database Implementation should take this course.
Instructor:
Craig Nelson Office: Room C3 – 1F CBI Building Phone: (215) – 496-6134 Email: cnelson@ccp.edu Website: http://faculty.ccp.edu/faculty/cnelson
|
Office Hours: Office Hours will be conducted using Zoom Video Conferencing or CCP Email. Zoom Video Conferences are established by making an appointment and receiving a confirmation by email Mondays Wednesdays: From 9:00 am. Until 11:00 am. Thursdays: From 12:30 pm. Until 2:30 pm. Fridays |
If you have any questions concerning the course, contact me anytime via e-mail. Most questions about coursework can be answered best via e-mail, which allows me to send you a written response with examples or references. |
This Fall 2021 semester, the CIS Programs are recommending that students purchase one of the Cengage Unlimited packages when purchasing the textbook for this course. Cengage is offering a program named Cengage Unlimited. The Cengage Unlimited Program permits students to access any Cengage digital textbook for a single fee. The service provides students with a digital version of the textbook.
One of the reasons that the Computer Technology Department has opted to try this program is that it can save students a lot of money in textbook expenses. Many courses that a typical student takes in their path to completing the Computer Science program at CCP use a Cengage textbook. Below is a list of courses that many Computer Science students may use as their path to complete the program that uses a Cengage Publishers textbook
- Math 161
- Math 162
- Math 170
- Math 171
- CIS 205
There are also some courses in other CIS programs that are using Cengage textbooks. Students may opt to purchase one of the Cengage Unlimited packages or they may purchase the textbook individually. Every student should make the decision based on the courses that they are scheduled for and their personal preference in textbook formats. Some students may prefer a physical textbook, and some may take the option for a digital format. The Cengage Unlimited packages are for students that prefer the textbook in a digital format. The Cengage Unlimited option also permits students to rent and obtain a physical copy of the textbook at a reduced rate. The rate is $ 7.00 per copy of the textbooks that they are using for the semester. Students must have purchased a Cengage Unlimited package to rent the physical book at his reduced rate.
Textbook
Title: Database Systems: Design, Implementation, and Management
Authors: Carlos Coronel, Steven Morris
Publisher: Cengage
Options for Renting or Purchasing the CIS 205 Textbook from the CCP Bookstore
Cengage Unlimited Versions of the Textbook
Cengage Unlimited, 1 term (4 months), 1st Edition
- ISBN: 9780357700006
- Author: Cengage Unlimited
- Publisher: Cengage Unlimited
- Formats: Cengage Unlimited
- Price 119.99
Cengage Unlimited, Multi-term (12 months)
- ISBN: 9780357700013
- Author: Cengage
- Publisher: Cengage Unlimited
- Formats: Cengage Unlimited
Price 179.99
Cengage Unlimited, Multi-term (24 months), 1st Edition
- ISBN: 9780357700020
- Author: Cengage Unlimited
- Publisher: Cengage Unlimited
- Formats: Cengage Unlimited
- Price 239.99
Rental Options of the Textbook
Database Systems
- Edition: 13th
- ISBN: 9781337627900
- Author: Coronel
- Publisher: Cengage Learning
- Formats: Hardcover, BryteWave Format
Students can Rent the Textbook.
Rent a Used Physical Hard Copy of the Textbook
Price: $83.30
Rental Return Due Date: 8/24/21
Rent a New Physical Hard Copy of the Textbook
Price: $135.36
Rental Return Due Date: 8/24/21
Rent a Digital Version of the Textbook
Price: $41.94
Length of Access: 120 Days
Rent a Digital Version of the Textbook
Price: $47.99
Length of Access: 180 Days
Purchasing Options of the Textbook
Buy a Used Physical Hard Copy of the Textbook
Price: $156.25
Buy a New Physical Hard Copy of the Textbook
Price: $208.25
Buy a Digital Version of the Textbook
Price: $89.49
Loose Leaf of Version of the Textbook
Database Systems Design, Implementation, & Management Loose Leaf (LL) Version
- Edition: 13th
- ISBN: 9781337688826
- Author: Coronel
- Publisher: Cengage Learning
- Formats: Loose-Leaf
Options for Purchasing the Loose Leaf of the textbook Version from the College Bookstore
Buy the Loose Leafe Version Used
Price: $93.75
Buy the Loose Leafe Version New
Price: $125.00
You do not want a Hard Copy
*** Unless you want a permanent reference textbook after completing the course, the Computer Technology Department is recommending that you select from one of the Cengage Unlimited options listed below. The Cengage Unlimited Program permits students to access any Cengage digital textbook for a single fee.
CENGAGE UNLIMITED - 4 Month Access
Printed Access Card ISBN: 9780357700037
$119.99 MSRP
CENGAGE UNLIMITED - 1 Year Access
Printed Access Card ISBN: 9780357700044
$179.99 MSRP
CENGAGE UNLIMITED - 2 Year Access
Printed Access Card ISBN: 9780357700051
$239.99 MSRP
We will also rely heavily upon the courses textbook, classroom notes, online tutorials, Internet references, and exercises distributed through the Canvas Learning Management System (LMS) by the instructor. Each week, Canvas, the Website for the class, will be updated to include links to the upcoming week’s material and assignments. Also, a weekly announcement will be sent describing new concepts and weekly assignments. The Website for the class is accessed through the Canvas (LMS). We will review how to access the Canvas LMS in our introduction to the course lecture, the first day of class. There are also some video guides on using the Canvas LMS.
From the start of the course, students will need to use a professional text editor that is SQL enabled. Visual Studio Code is the recommended Text Editor to use in this course. I will demonstrate how to use Visual Studio Code in the class lectures in one of our face-to-face meetings or a Guided Video Lecture. There is also a guided video tutorial on downloading and using Visual Studio Code. If you are working from home and using Microsoft Windows or a Mac OS, I strongly recommend using Visual Studio Code when creating SQL script in the class. All SQL text files must be submitted in a text file format with an SQL extension.
If you are using an Apple Desktop (OS) or a Linux Desktop OS to execute your SQL Script, I will suggest some additional professional industry-recommended application tools and text editor applications to you in the weekly class announcement. Visual Studio Code will operate in Apple OS Platforms. If you have an Apple Mac OS platform, this is the recommended tool to use for writing SQL scripts. All SQL scripts must be written using a text editor, not a word processor. SQL script submitted in Word Processing format will not be accepted. All SQL text files must be submitted with an SQL extension.
SOFTWARE FOR THE COURSE
If you require a productivity suite such as Microsoft Office, you may download a free open-source office suite such as Libre-Office. Additionally, for productivity suits activities and tasks, you may use web services such as Google Docs or Microsoft 365 to write your professional documents for the course. To my understanding, all students will have access to install Microsoft Office 365 at no cost on their Personal Computers through your MyCCP account. To my understanding, you have up to five installs for 5 different personal devices
We will use additional utility software in this course. All of the software applications that we will use in class are installed on the computers in the classroom and the computers in the SACC Open Computer Labs. If you plan on working on assignments from home, they may be downloaded from their websites listed below
Visual Studio Code
https://code.visualstudio.com/download
This is an Open Source Text Editor used to create SQL commands. It recognizes reserve words and another special syntax in the SQL Database Language. I will use this editor to illustrate examples of SQL Script. All SQL Script must be written using a text editor not a word processing program.
All SQL Script must be submitted as a file in a Text File Format with an SQL Extension on the filename. SQL Script in a Word Processor Format or copied and pasted into the Canvas will not be accepted as an assignment submission
Maria DB Community SERVER
https://downloads.mariadb.org/
Students wanting to work at home will need to download a version of Maria DB Server. When we get to applied database activities, this will be the primary software that we will work with. You may use the following link to acquire a free copy of Maria DB. Select the Maria DB link from the download portal. You may then select from the version that matches the Operating System (OS) that you have at home. This is a fully functional Enterprise Level Relational Database Management System (RDBMS). If you are using an Apple Computer at home, you must use interface software to send queries to Maria DB. We will use a Microsoft Windows OS in class. Microsoft Windows does not require the use of interface software. Students using a Mac OS will have to install any additional software plug-in. If you plan on using the plug-in, you will have to learn to use it outside of class. During class lectures and demonstrations, I will use a Windows Platform and execute SQL commands from a SQL Command Line Interface.
https://downloads.mariadb.org/
Recommended Professional Text Editor for the Course
Visual Studio Code
Visual Studio Code is a Free Open-Source Multiplatform Professional Text Editor. It can be downloaded and installed in a Windows Platform, Mac OS Platform, and Linux platform. Most of the Video and live lecture presentations will use this tool when creating SQL scripts while describing and illustrating SQL code during the class lectures.
Below is the link to download Visual Studio Code for your Platform
https://code.visualstudio.com/download
Optional Alternative Text Editor for Windows OS Users - NOTEPAD ++
This is an Open Source Text Editor used to create SQL commands. It recognizes reserve words and another special syntax in the SQL Database Language. I will use this editor to illustrate examples of SQL Script. All SQL Script must be written using a text editor not a word processing program. You do not have to use NOTEPAD ++, however, you must use a text editor when writing SQL script for the course. Notepad ++ will only function on a Windows Platform
All SQL Script must be submitted as a file in a Text File Format with an SQL Extension on the filename. SQL Script in a Word Processor Format or copied and pasted into the Canvas will not be accepted as an assignment submission
Link to Download Note Pad ++
http://notepad-plus.sourceforge.net/uk/download.php
*** All submitted ER Modeling Assignments must be submitted as a PDF document with your name embedded in the document ***.
You can use an online service such as Gen My Model. Gen My Model is an online tool that you can use through your web browser. It can be used as a modeling tool to make ER Diagrams using Chen Notation and Crows Foot Notation. There will is only one assignment where a Visio Crows Foot Style Diagram will be required. The minimum requirement for all other modeling assignments will be a Chen Diagram. You will be able to do Chen Diagramming with a professional Word Processor such as Microsoft Word. All ER Diagram Assignments must be submitted as PDF
Use the link below to access Gen My Model
Recommended ER Diagramming Tool
This Tool will permit students to download the ER Diagram in a PDF Format. All ER Diagrams must be submitted in a PDF Format
DIAGRAMS.NET
Another recommended online service to make ER Diagrams is the app.diagrams.net/ web service. You can use an online service such as diagrams.net. diagrams.net is an online tool that you can use through your web browser. It can be used as a modeling tool to make ER Diagrams using Chen Notation and Crows Foot Notation. There will is only one assignment where a Visio Crows Foot Style Diagram will be required. The minimum requirement for all other modeling assignments will be a Chen Diagram. You will be able to do Chen Diagramming with a professional Word Processor such as Microsoft Word. My Video guides on ER Diagramming are based on using diagrams.net
This Tool will permit students to download the ER Diagram in a PDF Format. All ER Diagrams must be submitted in a PDF Format
MariaDB and MySQL Alternatives
A student that has mobile devices such as a Chromebook will not be able to Install and Run MariaDB. I have included several Internet Web Services that will execute your MariaDB or MySQL script and provide feedback on possible syntax errors in your code.
Below is a list of some alternative resources that you can use if you have such a device. You will still have to locate a text editor that is SQL enables and that will save your text file with a SQL Extension.
Paiza Cloud
paiza.IO is an online editor and compiler where you can write and run code instantly. Whenever you come up with a new idea, learn or teach programming, you and others can just write and run code. The compiler will handle MySQL and MariaDB Stored procedures and Triggers.
You can access Paiza Cloud for MySQL and MariaDB using the link Below
https://paiza.io/en/languages/mysql
Topics, Schedule, and Links to Class Notes
The class meets Online from September 7, 2021, through December 18, 2021. This is an online version of CIS 205. This section meets online using Canvas. Students will have access to the course online using the Canvas Learning Management System (LMS). You will be able to access all class resources online including a digital version of the textbook using the Canvas LMS. All assignments must be submitted through the Canvas LMS.
Details of the course schedule, such as notes on upcoming classes, will be posted in the Canvas LMS as the course progresses. Some content may get more emphasis than others and some material may move to different weeks depending on the needs of the class. All students should review class announcements, assignments, and posted reading material weekly.
The class meets only online for assignment submissions and supplemental material during this online section of CIS 205. Details of the course schedule, such as notes on upcoming topics in classes, will be posted in Canvas as the course progresses. Some content may get more emphasis than others and some material may move to different weeks depending on the needs of the class. At times I may augment topics, assignments, and schedules as needed. This is a 15-week Computer Technology course. The class also uses some online tools, the primary tool will be the Canvas Learning Management (LMS). We will also correspond regularly using CCP Email Canvas Messaging, and Canvas Announcements. It is your responsibility to review your CCP Email and Canvas Announcements regularly for class announcements and updates.
For the official College Academic Calendar, see http://www.ccp.edu/site/academic/academic_calendar.php
Projected Weekly Schedule
Week 1 |
Tuesday, September 7, 2021 –
Monday, September 13, 2021
|
Introduction to the course Introduction to Canvas LMS Introduction to the Modern Relational Database Management Systems (RDMS) Single Table Queries Data Types and Data Models |
Week 2 |
Tuesday, September 13, 2021 –
Monday, September 20, 2021
|
Introduction to Database Requirements and Database ER Model Single Table Queries Entity-Relationship (ER) Modeling
|
Week 3 |
Monday, September 20, 2021 –
Monday, September 27, 2021
|
Single Table Queries Creating Metadata and Data Dictionaries |
Week 4 |
Monday, September 27, 2021 –
Monday, October 4, 2021
|
Single Table Queries Enhanced Entity Relationship (ER) Modeling |
Week 5 |
Monday, October 4, 2021 –
Monday, October 11, 2021
|
Normalization of Database Tables
|
Week 6 |
Monday, October 11, 2021 –
Monday, October 18, 2021
|
Relational Algebra
· Unions · Joins · Intersections · Differences
|
Week 7 |
Monday, October 18, 2021 –
Monday, October 25, 2021
|
Structured Query Language (SQL)
· SQL Multi-Table Joins · Data Definition Language(DDL) · Data Manipulation Language (DML)
Implementing a Database with MySQL
|
Week 8 |
Monday, October 25, 2021 –
Monday, November 1, 2021
|
Structure Query Language
· SQL Multi-Table Joins · Advance Select Statements · INSERT INTO Statement
|
Week 9
|
Monday, November 1, 2021 –
Monday, November 8, 2021
|
Final Project Introduction
· Forming Groups · Topic Selections and Topic Assignments · Computer-Supported Collaborative Learning (CSCL) Tools · Final Project Requirements
|
Week 10 |
Monday, November 8, 2021 –
Monday, November 15, 2021
|
Advanced SQL
· Sorting and grouping data · Using Built-in SQL Functions · Computed Fields · Aggregation Functions · HAVING Clause |
Week 11 |
Monday, November 15, 2021 –
Monday, November 22, 2021
|
Advanced SQL
· Altering Table Structures · Updating Tables Information · Deleting Rows/Tuples |
Week 12 |
Monday, November 22, 2021 –
Monday, November 29, 2021
|
Sub Queries / Inner Queries
· Sub Queries / Inner Queries · Intersect Queries · Difference Queries · Union Queries |
Week 13 |
Monday, November 29, 2021 –
Monday, December 6, 2021
|
Procedures and Triggers and Views · Introduction to SQL Views · Introduction to SQL Procedures · Introduction to SQL Triggers
|
Week 14 |
Monday, December 6, 2021 –
Monday, December 13, 2021
|
Managing Database Users · Creating Users · Grant User Privileges · Revoking User Privileges · Showing Users · Showing User Privileges
Introduction to SQL Transactions · Committing Transactions · Rolling Back Transactions
|
Week 15 |
Monday, December 13, 2021 –
Saturday, December 18, 2021
|
Advance Database Topics The class will study one of the following topics: · Data Warehouse
· MongoDB
· Introduction to Distributed Computing and Distributed Databases · Introduction to No SQL Databases |
Week 15 |
Monday, December 13, 2021 –
Saturday, December 18, 2021
|
December 11, 2021, is the last day of classes
December 13-18 are Finals Days Work on Final Project Final Projects Are Due
|
Grading
During the semester there are several different types of graded activities
- Weekly Quizzes. The weekly quizzes will prepare you for the two major exams in the course
- Participation in Weekly Class Discussions
- Participation is Weekly Practice Assignments
- Course assignments will be a mixture of writing SQL statements and creating ER Diagram data modeling documents. We will also have Group Projects that use a variety of Collaboration Tools such as Document Markup in MS Word, collaboration tools in Canvas, and other cloud-based collaboration tools. This will permit team members to review assignments together and use tools for collaborative editing of Lab Reports
All SQL Assignments must be submitted in a Text File, not a Word Processing formatted file
ALL Database Models (ER Diagrams) must be submitted in a PDF formatted file - Possible Research Essay (3-5 Pages plus References).
- Final project and presentation (Points to Be Announced (TBA))
- Final Exam and a Midterm Exam
Final grades will be determined based on the percentage of the total points each student has earned during the semester. Grades will be calculated by dividing the total points earned by the total possible points that you could have earned during the semester. The Canvas LMS may not accurately display your up-to-date class percentile. You should keep a running total of the points that you earned and the total possible points you could have earned each week during the semester. This will provide you with the most accurate view of your grade during any week. Below is a chart of percentages as they relate to a letter grade.
A – 90% to 100 % | B – 80% to 89 % | C – 70% to 79 % | D – 60% to 69 % | F - less than 60 %
If you have questions about specific grades or your overall progress at any time during the semester, then please consult with me. I will be glad to review individual items and your overall grade at any time. See me during lab times in class or you may schedule an appointment with me during my posted office hours for the semester.
All College policies regarding attendance, classroom behavior, etc., will be enforced and may affect your grade as the instructor deems appropriate. In Online Courses, Attendance is linked with participation in Class Assignments.
All assignments in Canvas have three associated dates. There is a start date, a due date, and an until date. The State Date is the date and time that the assignment requirements and details become visible to students. The Due Date is the final actual date and time that the assignment is expected to be submitted. The Until Date is a buffer. The normal buffer time is 24 hours from the Due date. This provides a 24-hour window in the event of any unexpected last-minute problems submitting the assignment. This includes issues such as Computer Problems, Internet Problems, and Power Outages. This buffer allows you time to located possible alternate resources to submit the assignment such as one of the college's open computer labs, a friend’s computer, or a hot spot such as a coffee shop or MacDonald’s.
Students mustn't use the 24 hours buffer time that the Until Date provides as the actual Due Date of the published assignments. Should an actual emergency arise just before the Until Date expires, it may not be possible to extend the Until Date any longer than the 24 hours buffer?
Assignments
Each Module in Canvas contains a list of assignments for that module. In CIS 205 each module may contain the following types of assignments:
- SQL Assignments: SQL Assignments must be submitted in text documents format. The text file must have an SQL extension, not in a word processor format.
The script should be well documented with comments
All the scripts must be placed in a single SQL file with an SQL extension
The script should run continuously without errors
- ER Diagrams: ER Diagram Assignments must be submitted in PDF Format.
- Metadata Documentation: Metadata Assignments must be submitted in a Word Processor Table Format, Spreadsheet format, or PDF Format.
Practice Assignments: This typically will involve following along in class or through a guided video as your professor demonstrate the skills needed to do the associated homework assignment in the module. In some instances, it will also involve a little problem solving on your part. Sometimes the problem solving will be an individual independent task. Other times it will involve a collaborative effort in groups or as a class. The skills that will be illustrated parallel the skills needed to do the associated homework assignment in the module. In face-to-face sections of the course, if you miss the in-class demonstration, you are still responsible for the in-class practice assignment. If you miss attending a practice assignment demonstration, you should collaborate with students, review the associated guided video, or schedule a meeting during your professor's scheduled office hours for assistance. You can also review the video associated with the skill and echo the practice assignment in the video. Most in-class practice assignments will remain open at least 24 hours past the due date of the activity being demonstrated during class.
All Practice Assignments must be submitted through the assignment submission drop box in the Canvas LMS. This is a process of uploading the files associated with the assignment and clicking the Submit Button in Canvas.
- Email submissions will not be accepted for grading
- Canvas Message Attachments Submissions will not be accepted as an assignment submission
Homework Assignments: This type of assignment is done outside of the classroom. You may use college resources or your resources to complete the homework assignment. The college provides SACC Open Computer Labs for your use. These labs are on every CCP Campus. You should research the hours of availability of the SACC Labs if you choose to use college resources for your homework assignments. The college also provides Loaner Computers to students who may need a device with a Windows Operating System.
You may also use your resources to complete the homework assignments. All of the software used in this course is free Open Source Software. The software can be obtained by downloading and installing the programs to your personal computer. The software will run on a variety of Operating System (OS) platforms including Windows, Apple OSX, and Linux. A couple of the software applications are Windows-specific. You can make adjustments to this using alternative applications. This may require a little extra effort on your part.
The recommended OS for this course is Microsoft Windows. There are some additional difficulties are using some of the course software on a MAC OS in this course. There are alternative services that can be utilized such as the Computer Loaner program service previously listed. In Addition to the Computer Loaner Service, students also can access a CCP configured computer on Campus through the Internet using a Virtualization Connection Service set up by the College. I will provide connection information through class announcements during the first weeks of the semester.
All Homework Assignments must be submitted through the assignment submission drop box in the Canvas LMS.
- Email submissions will not be accepted for grading.
- Canvas Message Attachments Submissions will not be accepted for grading.
Discussion Assignments: This type of assignment is an asynchronous chat between you and your classmates. This means that everyone is not participating at the same time. In most cases, you will have at least a week to participate in the discussion assignment. It is best to start participating early in this type of assignment. From time to time I will participate to make sure everyone is on track with the topic. To get full credit for this type of assignment, you must post your reply to the discussion topic. After posting your reply, you must read the posts of several other classmates. You must then reply to the posts of at least two other participants in the discussion. This includes the replies of your other classmates or your instructor for this course.
When replying to discussion assignments, there are a few guidelines to follow.
Students must reply across multiple days during the start date and Due Date that the discussion assignment was published. Students should not make multiple comments on a single day or at the last minute. The purpose of discussion assignments is to have an asynchronous chat or discussion on specific topics. If students wait until the last minute to participate in discussion assignments, the entire class does not have an opportunity to review submissions and share them with the class. As a result of this, points will be deducted from discussion assignment grades that do not contribute to the discussion across multiple days that the discussion assignment has been published.
Students must be specific in their replies to other students. For example, students must specify what they agree with or like about another student’s submission to the discussion. Inversely, if a student is in disagreement with another student’s submission to the discussion, the students must specify what they disagree with or dislike about the other student’s submission to the discussion. As a result of this, points will be deducted from discussion assignment grades for students that do not reply to other students with clear and concise replies detailing the positive or negative aspects of the other student's submission.
Weekly Quiz Assignments: This type of assignment is a chapter quiz. Most modules in this course are associated with a corresponding chapter in your textbook. Most weeks will include a brief quiz of concepts and terminology covered in the assigned chapter associated with the module. To prepare quizzes, you should thoroughly study the associated chapter. If the section is face to face, you should also attend the scheduled lecture on the topic before taking the quiz. If the section is online or hybrid, you should repeatedly study the chapter before taking the quiz. Quizzes are primarily multiple-choice and (true or false) questions
The quizzes will be administered online through the Canvas LMS
Projects: There will be at least a couple of comprehensive projects. One will the Final Project which will have a recommended option of working in groups. The second project will be a required group project. There will not be an option to work individually in the second group project. Projects together with your weekly assignments will count towards your final grade. Some smaller projects and weekly assignments may be completed collaboratively in groups. These assignments will be designated as collaborative assignments in their assignment descriptions. Group Project grading will be a combination of group contribution and individual contribution. Students should start to interact with other students in the class to start forming groups. Students should inquire about each other’s availability and pick a group leader to take responsibility for coordinating group activities.
In Collaborative Projects, each student must submit their copy of the project into Canvas
As previously mentioned, most weeks will have one or more discussion topics to respond to. Discussion forum points will count towards your final grade. There will be additional graded lab work and weekly assignments that will prepare you for projects and exams; these will also count towards your final grade. You will have to use the material learned through class lectures, textbooks, and additional class material to complete work in the lab assignments and projects. More information about lab assignments and projects will be posted through Class Announcements in Canvas and downloads in the Weekly Modules of the Module section in our course’s website, Canvas, as the semester progresses.
In Collaborative Projects, each student must submit their copy of the project into Canvas
Assignment Submissions – All assignments are to be submitted through the file submission portal using the submit link for the assignment in the Canvas LMS. All submitted assignments document names must include your name and assignment name in the document being submitted. Any assignment submissions not following this naming format will not be accepted. Assignments will not be accepted through email. Do not attempt to submit your assignments as email attachments. I missed the assignment’s deadline date, you must request the reopening of the submission portal once the submission portal has closed. I will reopen the submission portal if the reason is justified. If I reopen an assignment, I will announce the reopening to the entire class. This will permit an equal opportunity for everyone. I do not accept handwritten or printed material. Assignments must be created using a modern productivity tool such as text editors, Word processors, Spreadsheets, Presentation applications.
Assignments submitted late are subject to a late penalty. Once an Assignment’s Scores are released and Assignment Feedback is provided to the class for the assignment, that assignment will no longer be accepted for assessment and grading. Do not send assignments by email, they will not be accepted by email. Do not send assignments by comment attachments in Canvas, they will not be accepted in this format. All Assignments must be submitted through a Canvas Submission link. This is a standard form for all Student Submissions. I will not accept any single student exceptions that are not available to the entire class.
All assignments in Canvas have three associated dates. There is a start date, a due date, and an until date. The State Date is the date and time that the assignment requirements and details become visible to students. The Due Date is the final actual date and time that the assignment is expected to be submitted. The Until Date is a buffer. The normal buffer time is 24 hours from the Due date and the Until Date. This provides a 24-hour window in the event of any unexpected last-minute problems submitting the assignment. This includes issues such as Computer Problems, Internet Problems, and Power Outages. This buffer allows you time to located possible alternate resources to submit the assignment such as one of the college's open computer labs, a friend’s computer, or a hot spot such as a coffee shop or MacDonald’s. It also provides time to notify your professor of the problem. Students should not use the 24-hour buffer and the Until Date as the actual Due Date. Many students get into trouble when the assignment may not get extended after the Until Date passes.
Currently, my grading framework does not include an option for dropping an assignment from the grading equation. The policy that I have is to offer students a variety of extra credit assignments to substitute points loss from missing assignments or points loss for not doing well in previous assignments assessed and graded during the semester.
Grading and Extra Credit
Students should review the course syllabus for grading guidelines for categorized assignments. Currently, my grading framework does not include an option for dropping an assignment from the grading equation. I do not accept assignment submissions after the Until Date for the Assignment has expired. The policy that I have is to offer students a variety of extra credit assignments to substitute points loss from missing assignments or points loss for not doing well in previous assignments assessed and graded during the semester.
I encourage that you pay attention to the DUE DATES and UNTIL DATES of each assignment. The DUE DATE is in place as the actual assignment due date. The UNTIL DATE is an emergency grace period for the assignment. In most cases, as the semester comes to an end, I will not be able to offer the privileged of extending the UNTIL DATE of the Assignment. I also have an aggressive schedule of grading and feedback that I must provide to the entire class. This limits the time that I can extend certain assignments. I provide a collection of Extra Credit Assignments that students can use to make up points assignments that they may not have participated in or poorly performed in.
There are moments when I will provide an additional extension time on top of the already 24-hour grace period that an assignment had. This typically will occur when a student requests an extension. If I grant the extension, this means overall, there now will be an additional number of hours past the original Due Date. The Due Date will not change. However, the Until Date will be modified to an extended date and time. When I do this, I will also check off a selection in Canvas to announce to the entire class that they are also granted this privilege to submit or resubmit material for this assignment. I have a strong policy that I do not do for one student that I do not do for all students in courses that I teach here at the college.
Some important Submission Notes
- Students or groups should notify me of assignments or projects that are behind schedule. I may be able to extend the Until Date of the assignment or project. However, this is not a guarantee.
- ER Diagrams must be submitted in PDF format. ER Diagramming assignments not submitted in a PDF will not be processed and assessed for grading.
- SQL Script must be submitted as a text editor ASCI Text file with an SQL extension on the file name, not in a Word Processing format. Do not submit SQL Script in a Word Processor Format, it will not be accepted in Word Processor Format. SQL Script files must have an SQL extension on the file name. Files without SQL extensions will not be assessed for grading.
- All SQL scripts must run and execute continuously. If you are submitting text that contains syntax errors, you should arrange and comment on your text in order of importance. Any text that generates errors due to errors in the proceeding text will also be marked as incorrect.
- Do Send assignments as an attachment to the message, assignments will not be accepted as attachments to Canvas messages or Emails.
- Do not submit assignments in a Zip File. Canvas permits multiple document attachments in one submission. Simply add multiple documents to a single submission. It is like attaching multiple pictures to a single email. Assignments Submitted in a zipped file will not be accepted or assessed.
Notes from the Instructor – Keys to Successful Learning
Education is a Social Process
Architects use the metaphor of the campfire and the cave to describe the spaces they are designing. A campfire is a place where people come together to be with one another to work, play, etc. A cave is a place where a person can rest, read, etc. alone quietly. Architects design business spaces to have both campfires and caves – places where they can conduct business and commerce with other people and places where people can work alone quietly when necessary.
Successful students need to spend time both at the campfire and in the cave. They need to engage with teachers and other students in classrooms labs, online forums, and so on, but they also need to have a time and place to work alone, reading studying, and developing a personal understanding of the course material. In other words, education, like life itself, is both a social process and a personal psychological process.
We learn from other people and with other people. You should take the opportunity to communicate with and work with other students and your teacher. You can learn from them and they can learn from you. The course will be easier and you will learn more if you become part of the social fabric of the course.
Yet, ultimately, we learn best by developing a personal understanding of the course material. We each need to spend time studying away from others to develop a personal, inner understanding of the course material beyond what can be learned communally.
This course moves along quickly. There will be reading and written homework assignments each week, So, you will need to quickly establish a pattern for how you will participate in the class each week and when you will find time to do your course work, alone, and working with others.
Learning Demands Participation
Woody Allen once said “The hardest part of making a movie is to get the actors to show up on time. The rest is a piece of cake.” The same thing is true for learning – students who show up for class and do their work each week will do well.
A great deal of educational research has shown that the single biggest factor in determining final grades is class attendance. No other factor, not I.Q., SAT scores, family wealth, ethnic origins, nor any other factor correlates as closely with final grades as classroom attendance. If you show up for class and do the required work each week you will do well, if not, you won’t do well. This is true, in part, because colleges and universities have a complex system of placement and prerequisites to make sure you are in a course that you can handle. You must show up for class and do the required work each week to do well in the course.
This is especially true in a weekly-oriented distance education course. Your grade is directly related to how much you participate in the course.
Computer Labs
All instruction will be in a computerized classroom with one workstation per student. Each workstation is connected to the College-wide network, with Internet and e-mail access, so students may e-mail files between the classroom and home.
Class time includes approximately two hours per week of lab time. You will still find it necessary to complete work outside of class.
The College has several open lab facilities for students. For more information visit the Student Academic Computing Center in room C3-17. An introduction to these facilities is included in the classes at Community College of Philadelphia that is a prerequisite to this class.
For students that are in 15A Hybrid sections of the course, the classroom-based version of this course meets for 2.5 hours per week. You should allow several hours per week for study and several hours per week for your lab assignments and homework assignments.
The College has several open lab facilities for students who wish to do their work on-campus. For more information see. Additionally, the college provides Loaner Laptops to students that require them.
This course will require additional hours of study/lab time every week. Proper time management is the key to success in this course.
Canvas and Computer Resources
The class depends on your ability to use Canvas. If you have problems using Canvas, then please contact Vaishali Sharma, at vsharma@ccp.edu. For more information about Canvas, or Distance Education, please see the Distance Education Website at:
Student Academic Computing Centers (SACC)
Main Campus (CBI Building SACC) |
18th and Callowhill Streets. |
Northwest Regional Center |
12901 Townsend Rd |
Northwest Regional Center |
1300 W Godfrey Ave. |
West Regional Center |
4725 Chestnut St. |
You should call for hours and appointment procedures
Learning Lab Support
The Learning Lab will provide tutorial support for students requiring one on one tutorial support for this class. They may even be able to provide one on one tutorial support online using video conferencing. For more information on tutorial support for CIS courses contact:
Mavis Pogue. B2-36d 215-751-8474 mpogue@CCP.EDU
- Policies:
The CIS Department adheres to all College Policies. These can be found in your Student Handbook or at the following hyperlink:
http://www.ccp.edu/site/policy.php
Financial Aid:
Please see the College catalog regarding the impact on Financial Aid if you drop this course.
Messages:
It is best to reach me via e-mail (cnelson@ccp.edu). Please include your name and course number in the subject line. If the email is concerning an assignment, include the name of the assignment in the email.
- You do not have to tell me about a single absence (See Attendance).
- If you do not get a response from me within 24 hours, please send your e-mail again.
Classroom Conduct:
You should be punctual, alert, and prepared for each class session. You must be considerate of other students, which includes being quiet during class lectures and discussions except when you have something to contribute to the class. Cell phones and beepers will be turned off or on vibrate mode for the entire class. If necessary, you will take calls outside the classroom. Food, beverages, and their containers are not permitted in the classroom. Homework and/or lab assignments should not be done during lectures.
ACADEMIC INTEGRITY POLICY & PROCESS:
See the uploaded document detailing Community College’s Academic Integrity Policy & Process. In summary, students must do their work when the assignment specifies that it is an individual assignment. Collaborative assignments will be designated as being so. Plagiarism will not be tolerated. Any assignment presented by a student in fulfillment of course requirements must reflect his/her work unless credit is properly given to others. Anyone who assists another in such academic dishonesty is equally responsible. The grade on the assignment will be an “F” for all parties involved in an academic integrity violation is discovered.
Disability Accommodations Policy:
Students who are registered with the Center on Disability must inform the instructor by the end of the first week of classes if special accommodations are requested. Proper documentation must be presented.
Students who are eligible to receive accommodations for a documented disability through the Center on Disability should contact Lisa Papurt, Coordinator of Disability Services, at (215) 751-8048 or lpapurt@ccp.edu with any questions or concerns regarding testing accommodations for final exams.
Below is a link to the Website for the CCP Center on Disability
https://myccp.online/how-access-virtual-student-support-services/center-disability
ACADEMIC INTEGRITY POLICY & PROCESS:
AS FOR THIS COURSE
- Strike 1 _ you and the parties involved will be given a ZERO (0) for the assignment NO MAKE UP.
- Strike 2 _ you and the parties involved will drop one final letter grade. This simply means that if you are carrying a B average in the course, your final grade will be a C. This will be the grade that you are “entitled” to as a result of your actions.
- Strike 3 _ you and the parties involved will fail the course.
STARFISH CONNECT
Starfish Connect is a communication tool for students and faculty. Through Starfish instructors can provide feedback to you about course progress. Throughout the term, you may receive progress emails regarding your academic performance. The emails are designed to be helpful and increase your success in courses. Be sure to open any emails you receive and follow the recommendations. Instructors may also recommend that you contact a specific campus resource, such as the Learning Lab or Counseling Center. If an instructor makes a referral, you may also be contacted directly by this campus serves as a follow-up. To access Starfish Connect, simply log into Canvas and click on the link, Starfish Connect. You can even set up a student profile. If you need assistance with Starfish Connect, you can email questions to starfishconnect@ccp.edu
For more information on the degree programs & certificates offered by the Computer Technologies Department, visit the following links provided:
Degree Options
Computer Science Degree
http://ccp.edu/college-catalog/degree-programs/associate-science/computer-science
Cyber Security Degree
Computer Information Systems (CIS) - Information Technology (IT) Degree
Network Technology Management and Administration Degree
Proficiency Certificates
Computer Programming and Software Development Proficiency Certificate
Cyber Security I Proficiency Certificate
Cyber Security II Proficiency Certificate
Network and Systems Administration Proficiency Certificate
Web Development Proficiency Certificate
Important Dates for the FALL 2021 Semesters:
https://ccp.edu/college-catalog/academic-calendar
|
Last edited Monday, 09/03/2021 by C. Nelson
Course Summary:
Date | Details | Due |
---|---|---|