Lecture Schedule

Week	Topic	Textbook Section	Online Tutorial	Handouts	In Class Wednesday	In Class Monday
1	Introduction	1, 2.1-2.5	Simple Python Data	Slides 0_hello_world.py 1_hello_world_comments.py 2_calculator.py 3_types.py	2_calculator.py 3_types.py	0_hello_world.py 1_hello_world_comments.py 2_calculator.py 3_types.py
2	Variables, Functions, Booleans, If statements	Ch 2.6-2.9,3.1, 3.3, 3.6-3.10, Ch. 5	Functions and Main Programs If Statements	Slides 0_variables.py 1_function.py 2_more_functions.py 3_if_statement.py 4_if_else_statement.py 5_function_with_if.py 6_cascaded_if.py	0_variables.py 1_function.py 2_more_functions.py 3_if_statement.py 4_if_else_statement.py 5_function_with_if.py 6_cascaded_if.py comparison.py	0_variables.py 1_function.py 2_more_functions.py 3_if_statement.py 4_if_else_statement.py bools.py comparisons.py
3	Modules, Strings	Ch. 4, 9.3	Strings (up to for by item) Modules	Slides 0_str_ops.py 1_str_index_slice.py 2_str_len_substring.py 3_str_escape.py 4_str_methods.py 5_str_format.py 6_math.py 7_import.py some_code.py	0_str_ops.py 1_str_index_slice.py 2_str_len_substring.py 3_str_escape.py 4_str_methods.py 5_str_format.py 6_math.py 7_import.py some_code.py	5_function_with_if.py 6_cascaded_if.py 0_str_ops.py 1_str_index_slice.py 2_str_len_substring.py 3_str_escape.py 4_str_methods.py 5_str_format.py 6_math.py 7_import.py some_code.py
4	Lists, Loops	7, 9.6	Lists To the end of for loops	Slides input.py for_loop_str.py list_indexing.py for_loop_list.py list_reassigning.py list_copying.py list_misc.py for_loop_range.py str_split.py str_join.py	input.py for_loop_str.py list_indexing.py for_loop_list.py list_reassigning.py list_copying.py list_misc.py for_loop_range.py str_split.py str_join.py while_loop.py	input.py for_loop_str.py list_indexing.py for_loop_list.py list_reassigning.py list_copying.py list_misc.py for_loop_range.py
5	Practice with Lists, Range, Loops, While loops	8, 9.0-9.5	Lists and looping	Slides for_range_str.py enumerate.py zip.py tuple.py assert.py while_loop_mod_list.py while_loop_infinite.py loop_practice.py	for_range_str.py enumerate.py zip.py tuple.py assert.py while_loop_mod_list.py while_loop_infinite.py	str_split.py str_join.py for_range_str.py enumerate.py zip.py tuple.py while_loop_mod_list.py while_loop_infinite.py
6	Files, CSV Files, Dictionaries	9.5-9.7, 10.0-10.6, 11.3, 11.4	Data Files Dictionaries	Slides text_read.txt file_open.py file_write.py example.csv file_csv.py dict_basics.py dict_practice.py	file_open.py file_write.py text_write.txt file_csv.py dict_basics.py	assert.py file_open.py file_write.py text_write.txt file_csv.py dict_basics.py
7	Exam Review			Final exam from 2016	q1a.py q1b.py q1c.py q1d.py q2.py q3.py	dict_basics.py final.py q2.py q3.py q3_example.txt
8	Databases	17.0-17.4, 17.6		Slides db_basics.py db_create_insert_select.py db_select.py db_multi_table.py precipitation.csv db_from_file.py geography.csv region.txt db_multi_table.py db_practice.py db_sql_injections.py	db_create_insert_select.py db_from_file.py db_select.py db_multi_table.py	db_basics.py db_create_insert_select.py db_from_file.py db_select.py db_multi_table.py
9	Databases, cont'd	17.0-17.4, 17.6		Slides weather.db db_update_delete.py db_join.py db_join_2.py db_practice.py db_sql_injections.py	db_update_delete.py db_join.py db_join.jpg inner_join.jpg left_join.jpg right_join.jpg right_join_switched.jpg db_join_2.py db_practice.py db_sql_injections.py	db_update_delete.py db_join.py inner_left_full_outer_joins.jpg inner_left_right_joins.jpg cross_join.jpg db_join_2.py db_practice.py db_sql_injections.py
10	General Python topics			Slides break_continue.py pickle_demo.py tuple_unpacking.py optional_arguments.py variable_num_args.py kwargs.py kwarg_packing_unpacking.py try_except.py install_mpl.py	break_continue.py pickle_demo.py tuple_unpacking.py try_except.py variable_num_args.py basic_pyplot_example.py simple_plot.py	break_continue.py pickle_demo.py tuple_unpacking.py try_except.py
11	List Comprehensions, Algorithms			Slides list_comprehensions.py generator_expressions.py speed_comparisons.py sorted_list_search.py	list_comprehensions.py speed_comparisons.py sorted_list_search.py	list_comprehensions.py sorted_list_search.py
Review				Final exam from 2016 Final exam from 2017 Kara Autumn's slides