Main

Programming Assignments

Excel Assignments

Complete the following assignments with Microsoft Excel, Google Sheets, or another similar spreadsheet program. Microsoft Excel solutions are shown for each problem but should only be used as a learning resource, not to merely complete the assignment. Python solutions are shown as examples of programming but are not required.

Assignment

Knowledge Building

Solutions

1

Assignment #1

Conditionals

Functions

Excel Solution 2

Excel Solution 3

Python Solutions

2

Assignment #2

Problem 2 Data

Generate Plots

Data Analysis

Excel Solution 1

Excel Solution 2

Excel Solution 3

Python Solutions

3

Assignment #3

Solve Equations

Excel Solution 1

Excel Solution 2

Excel Solution 3

Excel Solution 4

Python Solutions

4

Assignment #4

Excel Template

HR Data

Dynamic Data

Data Regression

Excel Solution 1

Excel Solution 2

Excel Solution 3

Python Solutions

5

Assignment #5

Differential Equation Solution

Excel Solution 1

Excel Solution 2

Python Solutions

6

Assignment #6

VBA Macros

Excel Solution 1

Excel Solution 2

Python Solutions

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 1-2

Python Solution 3

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