CS 2316 Data Input/Manipulation

Instructor

• Christopher Simpkins, simpkins@cc.gatech.edu

IMPORTANT:

• You must email me from your official Georgia Tech email address, that is, the email address listed for you in the official course roster in Canvas. I use your official email address to create email filters.
• Include context in your email – which class you’re in, etc.
• Include all of your IDs, e.g., 9-digit GTID, Buzzport login ID, official name. Every system at GT uses a different ID and if I can’t easily look up relevant information about your request because you didn’t give me enough identifying information, I may ignore your email.
• Please understand that professors are slow or unresponsive to email because we are drowning in email. If I don’t respond within 48 hours just send me a gentle reminder.
• Do not send me messages in Canvas.

Course Description

Beginning Spring 2020: CS 2316 is a 3 credit and contact hour lecture course with a 0 credit hour, 1.25 contact hour recitation companion, CS 2316R. To enroll in CS 2316 you must also enroll in CS 2316R. The fact that CS 2316R contributes 0 credit hours to your schedule simply means that no graded work will take place during recitation and all testable course material will be available outside recitation. Recitation is provided for small group practice and review.

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, writing HTML and basic interfacing with SQL databases (reading / writing data in pre-existing tables). Students will learn to build programs controlled by basic graphical user interfaces. Assignments will be modeled after business, engineering, and scientific problems.

Learning Outcomes

Student in the class will achieve the following learning objectives:

(Competency) Students will be able to:

1. Write programs using various data types, and using basic techniques such as assignment, method calls, while loops, for loops, and conditionals.
2. Use and manipulate several language provided data structures such as: Lists, Dictionaries, and Strings.
3. Read and write data to and from text files, both as plain text and in structured formats (such as CSV).
4. Read a textual representation of numerical data and convert it to the appropriate (integer/floating point) data type.
5. Load HTML pages with a program, and extract specific pieces of information from the HTML.
6. Write a program that can generate a report in text or HTML format which includes elements under program control.
7. Connect to existing SQL databases and insert and retrieve data from the database.
8. Program interactive graphical user interfaces consisting of a graphically organized set of widgets, including a minimum of one from each of the following classes (Label, Button, Text Field).
9. Implement simple business or mathematical algorithms (calculating interest payments, averaging a row of data, calculating standard deviation) into a program.
10. Use compound data structures provided by the programming language such as lists, arrays, and dictionaries to hold sequences or sets of data, including two-dimensional (tabular) data.
11. Use objects and associated methods provided by the programming language.
12. Write programs that are easy to understand so that others may modify and improve them.

(Movement) Students will increase their:

1. Familiarity with compound data structures (lists, arrays, dictionaries), including nested data structures (multi-dimensional arrays, etc…) and indexing into multi-dimensional data structures.
2. Speed and accuracy in converting problem statements into programs.
3. Understanding of and ability to quickly use basic program structures such as iteration, conditionals, and function calls due to repeated practice of these concepts.
4. Understanding of the event driven programming model, specifically as applied to graphical user interfaces.
5. Ability to break a medium sized problem down into smaller parts and solve each sub-problem individually.
6. Ability to test and debug programs.

(Experience) Students will:

1. Practice the process of constructing moderately sized (100-300 line) programs from written requirements.
2. Deal with data that may include missing elements or malformed representations.
3. Work in pairs to solve programming problems.

Requirements

Grading

• Homework: 20%
• Exams: 60%
• Final Exam: 20%

Grade Cutoffs: A: 90, B: 80, C: 70, D: 60. No rounding.

Assignments

Two or three in-class written midterm exams, a final exam, short in-class exercises, and 7-12 homework assignments. Your last homework assignment may be due the week preceding final exams. Assignments must be turned in before the date and time indicated as the assignment’s due date.

Attendance

Attendance is required and assumed. In-class assignments cannot be made up if you do not attend the class. It’s a violation of the Academic Honor Code to submit work or sign in for other students.

Academic Integrity and Collaboration

We expect academic honor and integrity from students. Please study and follow the academic honor code of Georgia Tech: http://www.honor.gatech.edu/content/2/the-honor-code. You may collaborate on homework assignments, but your submissions must be your own. You may not collaborate on in-class programming exercises or exams.

Due Dates, Late Work, and Missed Work

• Assignments are due on the day and time listed on Canvas. Multiple resubmissions are allowed, so submit early and often so you aren’t in a rush on the due date. Absolutely no late submissions will be accepted. There is no grace period, so submit your assignments well before the deadline.

• Make-up exams are held at 11:00 on the Tuesday following the exam, unless otherwise announced. If the make-up exam room is not announced before the make-up day, report to the TA lab. Make-up exams are only given to students with special circumstances such as serious illness, hospitalization, death in the family, judicial procedures, military service, or official school functions. Provide us with a copy of your letter from the registrar in advance for official school functions. For other excused absences you must provide documentation to the Dean of Students’s office (in the “flag” building near the ice cream cone statue) within one week of your return from illness/activity. The Dean of Students’s office will verifiy your excuse and send your instructors a notice. The Dean of Student’s office will also send instructors a request for flexibility in cases which don’t fall within the official excuesed absences listed above but warrant considertation. An any case, if you believe you should be excused from a scheduled exam and don’t have an excuse from the Registrar, see someone in the Dean of Students’s office. Excusal from coursework or make-up opportunities are granted at the sole discretion of your instructor.

Regrades

To contest any grade you must submit an official regrade form to the Head TA 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 in the case of homework assignments and programming exercises. Note that a regrade means just that – we will regrade your assignment from scratch, which means you may end up with a lower score after the regrade.

Course Outline

This outline applies to Fall and Spring semesters. Summer schedule is compressed into 11 instructional weeks.

• Weeks 1 - 4: Programming in Python
• Weeks 5 - 9: Data Formats, Retrieval, and Storage
• Weeks 10 - 11: Graphical user interface programs
• Weeks 12 - 15: Data Analytics

Prerequisites

At least one of:

• Undergraduate Semester level CS 1301 Minimum Grade of C
• Undergraduate Semester level CS 1315 Minimum Grade of C
• Undergraduate Semester level CS 1321 Minimum Grade of C
• Undergraduate Semester level CS 1371 Minimum Grade of C

Course Materials

Note: O’Reilly books listed below are available through Georgia Tech’s Safari Onine subscription. See http://www.library.gatech.edu/search/ebooks.php

• Recommended Books:

  • Think Python, 2nd Edition, by Allen B. Downey, O’Reilly Media, December 2015. Available free at http://greenteapress.com/wp/think-python-2e/ and from O’Reilly at http://shop.oreilly.com/product/0636920045267.do
  • Python in a Nutshell: http://shop.oreilly.com/product/0636920012610.do
  • Fluent Python (Advanced): http://shop.oreilly.com/product/0636920032519.do
  • Flask Web Development: http://shop.oreilly.com/product/0636920031116.do
  • Python Data Science Handbook: http://shop.oreilly.com/product/0636920034919.do
  • Programming in Python 3 (2nd edition) : Mark Summerfield - Addison Wesley, ISBN: 0-321-68056-1
  • Dive into Python 3 – Mark Pilgrim – Apress ISBN: 978-1430224150

Non-Discrimination

The Institute does not discriminate against individuals on the basis of race, color, religion, sex, national origin, age, disability, sexual orientation, gender identity, or veteran status in the administration of admissions policies, educational policies, employment policies, or any other Institute governed programs and activities. The Institute’s equal opportunity and non-discrimination policy applies to every member of the Institute community.

For more details see http://www.policylibrary.gatech.edu/policy-nondiscrimination-and-affirmative-action

Learning Accommodations:

If needed, we will make classroom accommodations for students with documented disabilities. These accommodations must be arranged in advance and in accordance with the Office of Disability Services. If you require accomodations for exams, you must take your exams in the testing center. For more information see http://disabilityservices.gatech.edu.