\[ \begin{align}\begin{aligned}\newcommand\blank{~\underline{\hspace{1.2cm}}~}\\% Bold symbols (vectors) \newcommand\bs[1]{\mathbf{#1}}\\% Differential \newcommand\dd[2][]{\mathrm{d}^{#1}{#2}} % use as \dd, \dd{x}, or \dd[2]{x}\\% Poor man's siunitx \newcommand\unit[1]{\mathrm{#1}} \newcommand\num[1]{#1} \newcommand\qty[2]{#1~\unit{#2}}\\\newcommand\per{/} \newcommand\squared{{}^2} \newcommand\cubed{{}^3} % % Scale \newcommand\milli{\unit{m}} \newcommand\centi{\unit{c}} \newcommand\kilo{\unit{k}} \newcommand\mega{\unit{M}} % % Percent \newcommand\percent{\unit{{\kern-4mu}\%}} % % Angle \newcommand\radian{\unit{rad}} \newcommand\degree{\unit{{\kern-4mu}^\circ}} % % Time \newcommand\second{\unit{s}} \newcommand\s{\second} \newcommand\minute{\unit{min}} \newcommand\hour{\unit{h}} % % Distance \newcommand\meter{\unit{m}} \newcommand\m{\meter} \newcommand\inch{\unit{in}} \newcommand\foot{\unit{ft}} % % Force \newcommand\newton{\unit{N}} \newcommand\kip{\unit{kip}} % kilopound in "freedom" units - edit made by Sri % % Mass \newcommand\gram{\unit{g}} \newcommand\g{\gram} \newcommand\kilogram{\unit{kg}} \newcommand\kg{\kilogram} \newcommand\grain{\unit{grain}} \newcommand\ounce{\unit{oz}} % % Temperature \newcommand\kelvin{\unit{K}} \newcommand\K{\kelvin} \newcommand\celsius{\unit{{}^\circ C}} \newcommand\C{\celsius} \newcommand\fahrenheit{\unit{{}^\circ F}} \newcommand\F{\fahrenheit} % % Area \newcommand\sqft{\unit{sq\,\foot}} % square foot % % Volume \newcommand\liter{\unit{L}} \newcommand\gallon{\unit{gal}} % % Frequency \newcommand\hertz{\unit{Hz}} \newcommand\rpm{\unit{rpm}} % % Voltage \newcommand\volt{\unit{V}} \newcommand\V{\volt} \newcommand\millivolt{\milli\volt} \newcommand\mV{\milli\volt} \newcommand\kilovolt{\kilo\volt} \newcommand\kV{\kilo\volt} % % Current \newcommand\ampere{\unit{A}} \newcommand\A{\ampere} \newcommand\milliampereA{\milli\ampere} \newcommand\mA{\milli\ampere} \newcommand\kiloampereA{\kilo\ampere} \newcommand\kA{\kilo\ampere} % % Resistance \newcommand\ohm{\Omega} \newcommand\milliohm{\milli\ohm} \newcommand\kiloohm{\kilo\ohm} % correct SI spelling \newcommand\kilohm{\kilo\ohm} % "American" spelling used in siunitx \newcommand\megaohm{\mega\ohm} % correct SI spelling \newcommand\megohm{\mega\ohm} % "American" spelling used in siunitx % % Capacitance \newcommand\farad{\unit{F}} \newcommand\F{\farad} \newcommand\microfarad{\micro\farad} \newcommand\muF{\micro\farad} % % Inductance \newcommand\henry{\unit{H}} \newcommand\H{\henry} \newcommand\millihenry{\milli\henry} \newcommand\mH{\milli\henry} % % Power \newcommand\watt{\unit{W}} \newcommand\W{\watt} \newcommand\milliwatt{\milli\watt} \newcommand\mW{\milli\watt} \newcommand\kilowatt{\kilo\watt} \newcommand\kW{\kilo\watt} % % Energy \newcommand\joule{\unit{J}} \newcommand\J{\joule} % % Composite units % % Torque \newcommand\ozin{\unit{\ounce}\,\unit{in}} \newcommand\newtonmeter{\unit{\newton\,\meter}} % % Pressure \newcommand\psf{\unit{psf}} % pounds per square foot \newcommand\pcf{\unit{pcf}} % pounds per cubic foot \newcommand\pascal{\unit{Pa}} \newcommand\Pa{\pascal} \newcommand\ksi{\unit{ksi}} % kilopound per square inch \newcommand\bar{\unit{bar}} \end{aligned}\end{align} \]

Dec 04, 2025 | 331 words | 3 min read

7.3.1. Task 1

Learning Objectives

Create and execute simple scripts comprised of basic Python concepts; Apply course code standard in development of Python scripts; Modularize and comment code in Python for readability and reusability.

Task Instructions

In this task, you will be doing calculations using both Python and MS Excel. By performing the calculations with both tools, you will gain insight into the differences in syntax between the two

Part A

1. Open the MS Word template: py1_ind_1_username.docx

2. Open a new MS Excel sheet.

3. Assuming problems 1–5 shown in Table 7.8 are computed sequentially in the order shown,

   1. Calculate the result of each expression using MS Excel.

   2. Calculate the result of each expression using Python’s interactive mode. Use the same variable names as in the equations.

   3. Fill in the table in your MS Word document, using 4 decimal places when necessary.

      Note

      You should get the same results in both MS Excel and Python.

   Table 7.8 Equations in MS Excel and Python

   Problem Number	Equation	MS Excel Calculations	Python Calculations
   \(1\)	\(a = 4\)	Cell A1: 4	a = 4
   \(2\)	\(b = 3^{1/a}\)
   \(3\)	\(c = \log_2(b)\)
   \(4\)	\(d = \lceil -3.25 \rceil\)
   \(5\)	\(e = 315 \bmod 27\)

   Hint

   The brackets \(\lfloor \, \rfloor\) denote the floor operation, while \(\lceil \, \rceil\) denote the ceiling operation . See floor and ceiling functions for more information.

4. Repeat Step 3 for problems 6–10 in Table 7.9, using the values of \(a\), \(b\), \(c\), \(d\), and \(e\) computed above as a data set. It helps to put the results from problems 1–5 in the same row/column in MS Excel, and put them in a list in Python e.g values = [a, b, c, d, e].

   Table 7.9 Statistical Calculations in MS Excel and Python.

   Problem Number	Calculation	MS Excel Calculations	Python Calculations
   6	Find the mean
   7	Find the median
   8	Find the maximum
   9	Find the range
   10	Find the standard deviation

   Hint

   Python’s math and/or statistics modules may be helpful.

Part B

Complete the following steps in your previously created MS Word document:

1. Add a fifth column with the heading “Differences” to the table from Part A. For each problem, describe any differences you noticed between the MS Excel calculations and the Python calculations.

2. Did you use any imported libraries in Python, or did you find everything you needed in the standard library? If you used any imported libraries, list which one(s).

3. What syntax differences exist between Python and MS Excel? Be specific.

Save the MS Word document as a PDF with the name py1_ind_1_username.pdf.

Table 7.10 Deliverables

Deliverables	Description
py1_ind_1_username.pdf	A PDF of your completed MS Word document with all calculations and answers to the questions.