# PIC 1 Course design page From Spreadsheets to Programming [All course raw files here](https://two.bonsoon.net/pic-1-design) ![[excalidraw/title.svg]] _This is you with a computer. And that is the world._ _How do we make sense of it, and make it sing?_ ----- _Latest updates:_ - Spreadsheet exercise: Hamilton or not Hamilton, that is the question. _Currently working on:_ - Start spreadsheet part. - Pivot table to analyze data in spreadsheet program - Include the "ellipse desmos worksheet"? (Currently the formulas are just given directly in the exercises.) ------ ## By topics: [[unit-0/00-what-are-we-doing-here|00 Getting started: What are we doing here?]] 1. Files and text editors. - [[unit-1/01-folders-and-file-path|01 Folders, files, and file path.]] _in-progress_ - [[unit-1/02-using-a-text-editor|02 Using a text editor.]] _in-progress_ - [[unit-1/exercises|Exercises.]] _in-progress_ - [[unit-1/exercises-answers|Exercises with answers.]] _in-progress_ - [[unit-1/draft|draft]] _in-progress_ 2. Using Desmos - [[unit-2/03-using-desmos-as-a-data-analysis-and-modeling-tool|03 Using Desmos as a data analysis and modeling tool.]] - [[unit-2/03-exercises|03 Exercises]] - [[unit-2/03-using-desmos-draft|using desmos scrap]] 3. Spreadsheets - [[unit-3/04-blurb|04-spreadsheet-blurb]] - [[unit-3/04-using-spreadsheets|04-using-spreadsheets: Filter and Pivot tables]] - [[unit-3/04-calculating-grades-and-averages|Grade calculation for Practical Illusions and Conjuring 1]] - [[unit-3/04-exercises|04-exercises]] - [[unit-3/04-notes|04-notes]] 4. Python - Introduction - LESSON 1: [[unit-4/what-is-python|What is Python? And what is programming?]] - LESSON 2: [[unit-4/ways-to-run-python|Different ways to run Python.]] - LESSON 3: [[unit-4/a-musical-note-demo|A Magical Incantation Part 1: Casting your first spell!]] - LESSON 4: [[unit-4/a-musical-note-demo-part-2|A Magical Incantation Part 2: Code comments and identify elements in our code]] - LESSON 5: [[unit-4/a-musical-note-demo-part-3|A Magical Incantation Part 3: Extend the capabilities of this code!]] - Some basics on data and variables, functions, and controls. - LESSON 6: [[unit-4/python-as-calculator|Using Python as a calculator, numbers and operations, type.]] - LESSON 7: Variables. - LESSON 8: String and formatted string, len, operations, madlib. - LESSON 9: List, query, modify, append, pop - LESSON 9: "in" and boolean - LESSON 10: control : if, elif, else. - LESSON 11: the random library: random, randint, choice. Fortune teller. - LESSON 12: user input with input() - LESSON 13: Our first game: rock paper scissors prototype - LESSON 14: [[unit-4/water-bokeh|A Magical Scenery.]] - LESSON 15: Dictionary - LESSON 16: Loop: for-loop - LESSON 17: Objects and method - LESSON 18: Introduction to Functions - LESSON 19: [[unit-4/opening-and-reading-a-text-file|Opening a reading a text file]]. - LESSON 20: An alphabetical analysis of literature. - LESSON 21: Some visualization with Matplotlib.pyplot - LESSON 22: Some visualization with ipycanvas - Misc. Stuff (some work in progress) - [[unit-4/rock-paper-scissors|Rock, paper, scissors]] - [[unit-4/duck-hunt|Duck Hunt]] [[ideas-txt|Ideas dot txt]] ## By weekly schedule: - Week 1 - Week 2 - Week 3 - Week 4 - Week 5 - Week 6 - Week 7 - Week 8 - Week 9 - Week 10