Jump to Today

CS 2316 Data Input and Manipulation

Spring 2021

Instructor

●   Melinda McDaniel

○   Office Hours: Tuesday 2pm-3pm and Wednesday 1:30-2:30

○   Email: [email protected] (mailto:[email protected])

Head TA

●   Bohong Cheng

○   Email: [email protected] (mailto:[email protected])

Lecture

●   Lectures will be given remotely using this recurring bluejeans event link.

○   https://primetime.bluejeans.com/a2m/live-event/wuyuhsrx

     (https://primetime.bluejeans.com/a2m/live-event/wuyuhsrx)

Living Schedule: Click Here to Access Living Schedule

(https://docs.google.com/spreadsheets/d/1isVkGfQzBafHnjdnxjtVsyu7PkeVhQggU-9GNUef5ng/edit?usp=sharing)

Office Hours Schedule: Click here to view the Office Hours Schedule

(https://docs.google.com/spreadsheets/d/17XmZdP3QBopuziKhBGTLQDSO2stospl27N7iL06T

Course Description

This course will provide background and experience in reading, manipulating, and exporting data for engineering, business and scientific applications. Specific topics include file I/O, string processing, web scraping, API accessing, and interfacing with SQL databases. Students will learn to build programs controlled by basic graphical user interfaces. Assignments will be modeled after business, engineering, and scientific problems.

Grading

●   Homework: 25%

●   Participation: 15%

●   Exams: 30%

●   Final Project: 15%

●   Final Exam: 15%

Grade Cutoffs: A: 90.0, B: 80.0, C: 70.0, D: 60.0 (grades will not be rounded)

Course Format

All required assignments, exams, and activities will be given remotely as described in the next section. A few activities for extra practice, extra help, or additional learning will be done in person. These activities are being offered as a way to increase student engagement and enjoyment of coding. As much as possible, the materials related to these activities will be made available to students unable to attend in person.

Online format

This course is taught using an online synchronous format. All lectures will be recorded. but it is in your best interest to attend at the official OSCAR listed time so you can ask questions by typing them into the chat window, which will be monitored by the TAs.

Recitation will not be recorded for privacy of the students, but the materials will be uploaded for all students to study. Recitation is an opportunity to connect with other students so you should plan to attend at the official OSCAR scheduled time and engage fully with the TAs and your classmates.

Exams will be only given during the official OSCAR listed class time. They will be given in Canvas using

Homework Assignments

There will be four homework assignments totaling 25% as well as a final project worth 15% of your total grade. Online code demos via BlueJeans between yourself and a TA will be done for the final project and some of the other coding projects. These code reviews, which assess how well you can explain your code, will count for a portion of the assignment grade.

Assignments must be turned in before the date and time indicated as the assignment’s due date. No late homework will be accepted.

Participation

15% of your grade will be determined by classwork and participation activities given using Canvas or Gradescope to make sure students are keeping up with the material. No late participation exercises will be accepted.

Midterm Exams

There will be two midterm exams and a final exam that will be given online during the officially assigned lecture time and a final exam that will be given online during the officially assigned final exam period.

Final Exam

The final exam will be similar in nature to the midterm exams, but longer, and must be taken at the official institute assigned final exam time. It will be given online using Honorlock.

Collaboration Policy

Every Student is expected to read, understand and abide by the Georgia Tech Academic Honor Code. Academic misconduct is taken very seriously in this class. Your homework assignments may be evaluated via demo or code review. During this evaluation, you will be expected to be able to explain every aspect of your submission. You are expressly forbidden to supply a copy of your homework via electronic means. If you supply an electronic copy of your homework to another student and they are charged with copying, you will also be charged. Collaboration with other students currently in this class is an important learning method. The following explanation will help you understand collaboration. Students may only collaborate with fellow students currently taking CS 2316, the TAs, and the instructor. Collaboration means talking through problems, assisting with debugging, explaining a concept, etc. You should not exchange code or write code for others. Each individual assignment must be coded by you. Your submission must not be substantially similar to another student's submission. Collaboration at a reasonable level will not result in substantially similar code. Students that turn in submissions that are not fundamentally unique will receive a zero (0) and will be referred to the Dean of Students Office of Student Integrity.

Regrade Policy

To contest any grade you must contact the instructor within one week of the assignment’s original return date. The original return date is the date the exam was first made available for students to pick up or the grade was posted online. After that point regrade requests will not be accepted.

Internet Connectivity and Computer Ownership Expectations

You must have a reliable internet connection available for your use in order to take this course. Lecture videos will be recorded so that they may be watched at any time, but exams will be given during the official class time and will require a continuously functioning internet connection. We will be using Honorlock, the new Georgia Tech proctoring service, which will require you to have a webcam turned on and functioning during exams. Information about Honorlock will be provided the first week of class.

Your computer must meet the requirements laid out by the Georgia Tech computer ownership policy and must include a working webcam for taking exams.

Course Materials

Programming Language and IDE

The language used in this class is Python which can be used in many environments. We will edit our Python code using a text editor such as Sublime and run it from the command line. Instructions to set up your environment are available on Canvas > Living Schedule > Reading > Getting Started Handout.

Canvas

All course information and resources can be found either in Canvas. This includes: Syllabus, Assignments, Submissions, Announcements, Grades & Feedback, Resources, etc. Some assignments will be submitted using Gradescope, which you can find at the tab to the left on Canvas. The code from each lecture and a link to the video recording from each lecture will be posted on Canvas under the Files tab by the end of the following day.

Textbooks

Free online textbook:

Think like a computer scientist (http://www.openbookproject.net/thinkcs/python/english3e/)

Handouts

Course specific handouts will be made available and will be required reading.

Course Summary: