\[ \begin{align}\begin{aligned}\newcommand\blank{~\underline{\hspace{1.2cm}}~}\\% Bold symbols (vectors) \newcommand\bs[1]{\mathbf{#1}}\\% 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{\%}} % % Angle \newcommand\radian{\unit{rad}} \newcommand\degree{\unit{{}^\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 % % 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} \]

Oct 24, 2024 | 282 words | 3 min read

1.2.3. Task 3

Learning Objectives

The purpose of this task is to learn how to use the course technology including the homework submission software (Gradescope), and to use some basic features of MS Excel.

Task Instructions

1. One team member will save the MS Excel online spreadsheet created in Task 2 to their device and open the file in the desktop version of MS Excel.

   1. In MS Excel online, click File ‣ Save As ‣ Download a Copy. This will save a copy of the file on your device.

   2. Open the File Explorer (PC) or Finder (Mac) and find the document listed under your Downloads folder. Move the file to your Excel_1 folder created in Task 1, then double-click the file to open it in MS Excel.

2. 

   Fig. 1.3 Print settings.

   From the desktop version of MS Excel, print the spreadsheet to a PDF by selecting File ‣ Print. Before you print, adjust the scaling settings to fit all the information on a single page for technical presentation. Then save the PDF in your Excel_1 folder with the file name ex1_team_teamnumber_values.pdf.

   • For PCs: Make sure the printer is set to Microsoft Print to PDF. Then select Print.

   • For Macs: Select Save as PDF… in the PDF dropdown. For help printing to one page on a Mac, click here.

3. Now we will save a PDF copy of the spreadsheet with the formulas showing. To do this, click on Formulas ‣ Show Formulas. Then follow the steps above to print the spreadsheet with the formulas visible. Save the PDF in your Excel_1 folder created in Task 1 and name the file ex1_team_teamnumber_formulas.pdf.

   For more information on showing formulas in MS Excel, click here.

   Note

   MS Excel Online will allow you to show formulas in the spreadsheet but will not allow you to print a PDF with the formulas visible. Therefore, this step needs to be completed in the desktop version of MS Excel.

4. Once you have both files saved as PDFs, go to Gradescope and upload all required deliverables. Verify both files are uploaded before you submit.