Main

Programming Assignments

Excel and Python Assignments

Complete the following assignments with Microsoft Excel or Google Sheet (1-6) and Python for (1-17). The first 6 assignments are the same problems but completed with both a Spreadsheet program (Excel or Google Sheets) and Python. Solutions are shown for each problem but should only be used as a learning resource, not to merely complete the assignment.

Assignment

Knowledge Building

Solutions

1

Assignment #1

Google Colab 1

Conditionals

Functions

Excel Solution 2

Excel Solution 3

Python Solution

2

Assignment #2

Problem 2 Data

Google Colab 2

Generate Plots

Data Analysis

Excel Solution 1

Excel Solution 2

Excel Solution 3

Python Solution 1

Python Solution 2

Python Solution 3

3

Assignment #3

Google Colab 3

Solve Equations

Excel Solution 1

Excel Solution 2

Excel Solution 3

Excel Solution 4

Python Solution 1

Python Solution 2

Python Solution 3

Python Solution 4

4

Assignment #4

Excel Template

HR Data

Dynamic Data

Google Colab 4

Data Regression

Excel Solution 1

Excel Solution 2

Excel Solution 3

Python Solution 1

Python Solution 2

Python Solution 3

5

Assignment #5

Google Colab 5

Differential Equation Solution

Excel Solution 1

Excel Solution 2

Python Solution 1

Python Solution 2

6

Assignment #6

Google Colab 6

VBA Macros

Excel Solution 1

Excel Solution 2

Python Solution

7

Assignment #7

Google Colab 7

Conditionals

Functions

Python Solution 1

Python Solution 2

Python Solution 3

Python Solution 4

8

Assignment #8

Google Colab 8

Loops

Arrays

Python Solutions

9

Assignment #9

Google Colab 9

Generate Plots

Python Solution 1

Python Solution 2

Python Solution 3

Python Solution 4

10

Assignment #10

Google Colab 10

Temperature Control Lab

Python Solution 1

Python Solution 2

11

Assignment #11

Google Colab 11

Debugging

Python Solutions 1-5

Python Solution 6

12

Assignment #12

Google Colab 12

File Input and Output

Python Solutions

13

Assignment #13

Google Colab 13

Classes (collections of values and functions)

Python Solutions 1

Python Solutions 2

14

Assignment #14

Google Colab 14

Solve Equations

Python Solutions 1-2

Python Solution 3

Python Solution 4

15

Assignment #15

Google Colab 15

Data Regression

Python Solution 1

Python Solutions 2-4

16

Assignment #16

Google Colab 16

Solve Differential Equations

Python Solution

17

Assignment #17

Google Colab 17

Symbolic Derivatives

Integrals

Python Solution