E-10 Final SJSU
In fitting a curve to data points, Excel provides a correlation value known as R2. The
range for the R2 value is:
0 to 100%
0 to 1
0 to 100
-1 to +1 - ✔️✔️0 to 1
What unit does the sentence below define?
"amount of energy required to change temperature of one gram of liquid water by one
degree Celsius"
1 Watt
1 Joule
1 calorie
1 kW-hr
1 Calorie - ✔️✔️1 calorie
A small wind turbine with 0.15 m blade is able to generate 2.5 volt while supplying 2
Amp of current at a wind speed of 10 meter/second. Which of the following numbers is
closest to the efficiency of this turbine at this operating condition? (Hint: "Betz limit" sets
the maximum possible efficient to 59%). - ✔️✔️20%
If you drag cell C1 to cell C6, what will the answer be?
9
18
4
The question has an error. The $ shouldn't be there - ✔️✔️9
An inventory of parts in the ENGR 10 lab is shown in the figure.
To calculate the total number of parts in the inventory what equation would you wirte in
cell B8?
sum(b2:b7)
b2+b3+b4+b5+b6+b7
=sum(b2:b7)
=sum(b2:b8)
=sum(b2,b7) - ✔️✔️=sum(b2:b7)
,The specifications for a product you are developing require that the cross-sesction area
cannot be greater than 12 in2. You have summarized the dimensions of 5 prototypes
you have made. Column D has an equation to determine if your product meets
spcifications. It indicates that only specimen #5 meets the specifications.
What is the equation in cell D5?
=IF(B5*C5<12, "No","Yes")
=IF(B5*C5>12, No,Yes)
=IF(B5*C5>12, "No","Yes")
=IF(B5*C5<12, No,Yes) - ✔️✔️=IF(B5*C5>12, "No","Yes")
A student performed an experiment to determine the relationship between speed and
fuel economy (mpg). Excel created the plot shown below using the "chart wizard". What
would you do to improve this plot?
Check all answers that apply.
Delete the plot legend because there is only one set of data
Add a label to the x axis
Add a label to the y axis
Modify the plot title so it more clearly explains what is in the plot - ✔️✔️Delete the plot
legend because there is only one set of data
Add a label to the x axis
Add a label to the y axis
Modify the plot title so it more clearly explains what is in the plot
In the lab you measreed a wind speed of 20 mph on your turbine. Convert this to m/s.
536 m/s
32,200 m/s
8.9 m/s
44.8 m/s - ✔️✔️8.9 m/s
A kilowatt-hour is a unit of power.
True
False - ✔️✔️False
Which of the following heaters can heat up a gallon of water from 10oC to 100oC
faster?
90 W heater
5 W heater
Insufficient information
, All heaters listed will take the same amount of time
100 W heater - ✔️✔️100 W heater
A student weighs 140 lb. This student is able to run up to the 3rd floor in 20 seconds.
The 3rd floor is 10 meters above the ground floor.
Which of the following values is closest to the average power this student exerted in
climbing the stairs?
310 W
280 W
230 W
150 W
70 W - ✔️✔️310 W
Which one of the following expressions is power?
Energy × time
Force × acceleration
Force × speed
Speed × displacement
Speed × time - ✔️✔️Force × speed
Choose the answer that best describes this circuit.
Solar cells are in series. Calculate the total I in the circuit by adding the current in the
two cells. The V is constant.
Solar cells are in series. Calculate the total V in the circuit by adding the voltage in the
two cells. The I is constant.
Solar cells are in parallel. Calculate the total I in the circuit by adding the current in the
two cells. The V is constant.
Solar cells are in parallel. Calculate the total V in the circuit by adding the voltage in the
two cells. The I is constant. - ✔️✔️Solar cells are in series. Calculate the total V in the
circuit by adding the voltage in the two cells. The I is constant.
There are 2 solar cells.
Each one is capable of outputting 1 volt voltage and 2 Amp current.
To obtain output of 4 Amp, how should these two cells be connected and what is the
voltage?
2 cells in parallel, voltage = 2V
2 cells in parallel, voltage = 1V
2 cells in series, voltage = 2V
2 cells in series, voltage = 1V - ✔️✔️2 cells in parallel, voltage = 1V
In fitting a curve to data points, Excel provides a correlation value known as R2. The
range for the R2 value is:
0 to 100%
0 to 1
0 to 100
-1 to +1 - ✔️✔️0 to 1
What unit does the sentence below define?
"amount of energy required to change temperature of one gram of liquid water by one
degree Celsius"
1 Watt
1 Joule
1 calorie
1 kW-hr
1 Calorie - ✔️✔️1 calorie
A small wind turbine with 0.15 m blade is able to generate 2.5 volt while supplying 2
Amp of current at a wind speed of 10 meter/second. Which of the following numbers is
closest to the efficiency of this turbine at this operating condition? (Hint: "Betz limit" sets
the maximum possible efficient to 59%). - ✔️✔️20%
If you drag cell C1 to cell C6, what will the answer be?
9
18
4
The question has an error. The $ shouldn't be there - ✔️✔️9
An inventory of parts in the ENGR 10 lab is shown in the figure.
To calculate the total number of parts in the inventory what equation would you wirte in
cell B8?
sum(b2:b7)
b2+b3+b4+b5+b6+b7
=sum(b2:b7)
=sum(b2:b8)
=sum(b2,b7) - ✔️✔️=sum(b2:b7)
,The specifications for a product you are developing require that the cross-sesction area
cannot be greater than 12 in2. You have summarized the dimensions of 5 prototypes
you have made. Column D has an equation to determine if your product meets
spcifications. It indicates that only specimen #5 meets the specifications.
What is the equation in cell D5?
=IF(B5*C5<12, "No","Yes")
=IF(B5*C5>12, No,Yes)
=IF(B5*C5>12, "No","Yes")
=IF(B5*C5<12, No,Yes) - ✔️✔️=IF(B5*C5>12, "No","Yes")
A student performed an experiment to determine the relationship between speed and
fuel economy (mpg). Excel created the plot shown below using the "chart wizard". What
would you do to improve this plot?
Check all answers that apply.
Delete the plot legend because there is only one set of data
Add a label to the x axis
Add a label to the y axis
Modify the plot title so it more clearly explains what is in the plot - ✔️✔️Delete the plot
legend because there is only one set of data
Add a label to the x axis
Add a label to the y axis
Modify the plot title so it more clearly explains what is in the plot
In the lab you measreed a wind speed of 20 mph on your turbine. Convert this to m/s.
536 m/s
32,200 m/s
8.9 m/s
44.8 m/s - ✔️✔️8.9 m/s
A kilowatt-hour is a unit of power.
True
False - ✔️✔️False
Which of the following heaters can heat up a gallon of water from 10oC to 100oC
faster?
90 W heater
5 W heater
Insufficient information
, All heaters listed will take the same amount of time
100 W heater - ✔️✔️100 W heater
A student weighs 140 lb. This student is able to run up to the 3rd floor in 20 seconds.
The 3rd floor is 10 meters above the ground floor.
Which of the following values is closest to the average power this student exerted in
climbing the stairs?
310 W
280 W
230 W
150 W
70 W - ✔️✔️310 W
Which one of the following expressions is power?
Energy × time
Force × acceleration
Force × speed
Speed × displacement
Speed × time - ✔️✔️Force × speed
Choose the answer that best describes this circuit.
Solar cells are in series. Calculate the total I in the circuit by adding the current in the
two cells. The V is constant.
Solar cells are in series. Calculate the total V in the circuit by adding the voltage in the
two cells. The I is constant.
Solar cells are in parallel. Calculate the total I in the circuit by adding the current in the
two cells. The V is constant.
Solar cells are in parallel. Calculate the total V in the circuit by adding the voltage in the
two cells. The I is constant. - ✔️✔️Solar cells are in series. Calculate the total V in the
circuit by adding the voltage in the two cells. The I is constant.
There are 2 solar cells.
Each one is capable of outputting 1 volt voltage and 2 Amp current.
To obtain output of 4 Amp, how should these two cells be connected and what is the
voltage?
2 cells in parallel, voltage = 2V
2 cells in parallel, voltage = 1V
2 cells in series, voltage = 2V
2 cells in series, voltage = 1V - ✔️✔️2 cells in parallel, voltage = 1V
