<p>Lecture, three hours; discussion, two hours. No programming experience required. Covers computer fundamentals such as files, file extensions, directories, paths, ZIP archives, saving and retrieving files, and using a programming-suitable text editor. Use of Desmos Graphing Calculator and Google Sheets. Introduction to core coding concepts such as data types, syntax, variables, functions, and error messages. Demonstration of data analysis tools such as curve fitting, sorting, filtering by value and conditions, pivot tables, weighted averages, and graphs. Study of programming using Python language. Topics include variables, assignments, data types; arithmetic, comparisons, logical connectives, indexing; built-in functions, math and random functions; control flow, user-defined functions and methods; Python libraries (Pillow, Matplotlib, SciPy). P/NP or letter grading.</p>

Program in Computing

College of Letters and Science

Mathematics

COMPTNG 1 - Spreadsheets, Programming, and Their Application to Data Science

Spreadsheets, Programming, and Their Application to Data Science

Identify a useful application of one of the Python libraries they have used

Provide an example of using pivot tables to perform data science

Use a text editor for quick and efficient editing of text files and code

Write and use functions to avoid the unnecessary repetition of code

Choose a good datatype for solving a given problem

Patiently read error messages to attempt to better understand the problem encountered

Pay attention to subtleties when typing mathematical formulae in coding languages and successfully correct syntax errors

Use variables to store and update values of algorithmic importance

Index strings and lists confidently and correctly

Save and retrieve files in an organized way

Implement, test, and debug short algorithms involving simple control flow

General Catalog

Spreadsheets, Programming, and Their Application to Data Science

COMPTNG 1

4 units