Basic Rules for the Correct and Effective Use of Google Sheets for Lab Reports

Basic Rules for the Correct and Effective Use of Google Sheets for Lab Reports

1. Every numerical value has to be written in a separate cell and only one time.
2. If you need to use a numerical value in calculations, use in codes the reference name of the cell, where this numerical value is located.
3. For each numerical value have to be shown what it means and what are units of this value.
4. Don't write a numerical value together with it’s unit to the same cell.
5. Absolutely all necessary calculations have to be completed by Google Sheets codes (scripts).
6. Changes of any initial numerical value have to automatically recalculate all results.
7. In texts use correct formats of mathematical constants, signs, or operations, not Google Sheets codes.
8. Use superscript characters: ⁰ ¹ ² ³ ⁴ ⁵ ⁶ ⁷ ⁸ ⁹ ⁺ ⁻ ⁼ ⁽ ⁾ ⁿ ⁱ .
9. Use subscript characters: ₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ ₊ ₋ ₌ ₍ ₎ ₐ ₑ ₒ ₓ ₔ ₕ ₖ ₗ ₘ ₙ ₚ ₛ ₜ .
10. Use math and greek characters: ° ⨯ ∙ ≈ ∞ √ 𝚫 𝚯 𝚹 𝚺 𝛀 𝛆 𝛌 𝛍 𝛑 𝛒 𝛔 𝛕 𝛚 𝛜.
11. In lab reports do calculations of % errors comparing obtained in experiment values with expected values even if these calculations are not mentioned in the procedure.
12. Don't make your lab report as a literary novel.
13. Use a tabular style in all parts of your report.
14. The Conclusion section of lab reports should indicate how the results of your experiment correspond to the laws of Physics.
15. If the obtained %-error is more than 50%, do not write that the results of the laboratory experiment are in good agreement with the laws of Physics.
16. All calculations for answering laboratory questions should be done by Google Sheets codes (scripts).
17. Any report should be one page of a Google Sheets worksheet.
18. Reports must begin with the name of the experiment and the name of the student.
19. All tables must have explanatory titles.
20. All columns of tables should have explanatory headings with units of measurement. Units have to be in round brackets.
21. All graphs must have explanatory titles.
22. Axes of graphs should have explanatory titles with units. Units have to be in round brackets.
23. Charts must plot a trendline and a trendline equation.
24. Do calculations of slopes by using codes (scripts) with the slope() function.
25. To submit your report, submit in Blackboard only a web link to your Google Sheets work.
26. Don't submit any files or weblink to not Google Sheets.
27. If you are making a second or subsequent attempt to submit your corrected lab report, submit the weblink by Blackboard again, even if your web link has not changed.
28. The number of your attempts to get the highest grade is not limited.
29. Share your Google Sheets to vznamenskiycitytech@gmail.com giving editor rights.
30. See my comments, corrections and remarks in your Google Sheets.
31. If you want to increase your grade, correct your report according to my comments and resubmit it again.

A Better Way To Picture Atoms

Coulomb's Law Problem 2 from the Test: "Lecture 1 Test 1"

Question
Coulomb Law Problem 2

Static electric charge q exerts force F on static electric charge Q.
R is the distance between these two charges.
Static electric charge q₂ exerts force F₂ on static electric charge Q₂.
R₂ is the distance between charges q₂ and q₂.
See the figure:

Given:
q₂ = A ⋅ q ;
R₂ = B ⋅ R ;
Q₂ = C ⋅ Q ;

F₁ = N,
A = ,
B = ,
C = .
Find q₂.
Submit your solution in newtons by typing only the numeric part with 3 significant figures, without indicating the unit.

q₂ = 140.7 N.
Type: 141.



₀₁₂₃₄₅₆₇₈₉₊₋₌₍₎ₐₑₒₓₔₕₖₗₘₙₚₛₜ

Coulomb's Law Problem from the Test: "Lecture 1 Test 1"

Question
Coulomb Law Problem

Static electric charge q exerts force F on static electric charge Q.
R is the distance between these two charges.
Static electric charge q₂ exerts force F₂ on static electric charge Q₂.
R₂ is the distance between charges q₂ and q₂.
See the figure:

Given:
q₂ = A ⋅ q ;
R₂ = B ⋅ R ;
Q₂ = C ⋅ Q ;

F₁ = N,
A = ,
B = ,
C = .
Find q₂.
Submit your solution in newtons by typing only the numeric part with 3 significant figures, without indicating the unit.

q₂ = 1.00 N.
Type: 1.00



₀₁₂₃₄₅₆₇₈₉₊₋₌₍₎ₐₑₒₓₔₕₖₗₘₙₚₛₜ

Refraction Index Calculation

The light beam propagates from the first medium with the refractive index n₁ into the second medium with the refractive index n₂.
The angles of incidence and refraction are θ₁ and θ₂ respectively.

The following data are known:
θ₁ = °.
n₂ =
θ₂ = °.
Find unknown n₁.
Enter your answer using 3 significant figures.

n₁ = ?

n₁ sin θ₁ = n₂ sin θ₂
n₁ = n₂ sin θ₂ / sin θ₁

Refraction Calculation: θ1 = ?

n₁ =
n₂ =
θ₂ = °.
θ₁ = ?°

n₁ sin θ₁ = n₂ sin θ₂
sin θ₁ = n₂/n₁ sin θ₂
θ₁ = arcsin( n₂/n₁ sin θ₂ )

Refraction Calculation: θ2 = ?

n₁ =
n₂ =
θ₁ = °.
θ₂ = ?°

n₁ sin θ₁ = n₂ sin θ₂
sin θ₂ = n₁/n₂ sin θ₁
θ₂ = arcsin( n₁/n₂ sin θ₁ )

At what angle?

 35. A narrow beam of white light enters a prism made of crown glass at a θ º incident angle, as shown in Figure. At what angle, θ_R, do the red (660 nm) components of the light emerge from the prism? 

Enter your answer in degrees using 3 significant figures. 

Calculator of the intensity of electromagnetic waves carrying the power P through the rectangular area a x b.

Calculator:
Calculator of the intensity of electromagnetic waves carrying the power P through the rectangular area a x b.
Equation: I=P/(ab)

P = W µW mW kW MW GW TW PW EW ZW YW
a = m pm nm µm mm cm km Thousand km Million km
b = m pm nm µm mm cm km Thousand km Million km
0.0796 W/m² fW/m² pW/m² nW/m² µW/m² mW/m² kW/m² MW/m² GW/m² TW/m²
Maximum electric field strength E₀ = (2⋅I⋅ c⁻¹ ⋅ ε₀⁻¹)^½ = 7.74 V/m fV/m pV/m nV/m µV/m mV/m kV/m MV/m GV/m TV/m
Maximum magnetic field strength B₀ = E₀ / c = 9.16e-8 T fT pT nT µT mT kT MT GT TT
The speed of light c = 299792458 m/s
Vacuum Permittivity ε₀ = 8.8541878128 × 10⁻¹² F⋅m⁻¹

₀₁₂₃₄₅₆₇₈₉₊₋₌₍₎ₐₑₒₓₔₕₖₗₘₙₚₛₜ⁻ⁱ⁻⁰⁻¹⁻²⁻³⁻⁴⁻⁵⁻⁶⁻⁷⁻⁸⁻⁹⁺⁻ΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθικλμνξοπρςστυφχψωc = 299792458 m/s

Frequency-Wavelength-Period Calculator for Electromagnetic Waves in Vacuum

f = c/λ = Hz µHz mHz kHz MHz GHz THz PHz EHz ZHz YHz
λ = c/f = m pm nm µm mm cm km Thousand km Million km
T = 1/f = s fs ps ns µs ms min hour years thousand years
c = 299792458 m/s

⁻ⁱ⁻⁰⁻¹⁻²⁻³⁻⁴⁻⁵⁻⁶⁻⁷⁻⁸⁻⁹⁺⁻

Problem 3

 Problem 3

Three identical point charges of 1 C each are located at the vertices of an equilateral triangle, and this system has a potential energy of 1 J. (There is no in our consideration of other charges or external fields)

What would be the potential energy with the same arrangement of point charges, if the charges had different values, for example, the following: -1 C, 2 C, and 3 C?

Problem 2

 When two electric charges occupy the positions shown in Figures 1 and 2, the values of the Coulomb force between the charges are known, respectively F₁ and F₂.

Find the force of the Coulomb interaction of charges when they occupy the position shown in Figure 3.

Problem 1

Two point-objects carrying the same electric charge are keeping at some distance from each other by a string, which exerts on objects only its known tension force T₁ and does not participate in electrostatic interaction.
If four such point-objects with the same as previous charges are attached to a string at the same distance from each other as before, what will be the tension T₂ in the middle of the string?

Calculus Based General Physics II: 🧑‍🔬 Hydrogen Wave Function 😲

Active T-Shirt

$25.00

Baseball ¾ Sleeve T-Shirt

$25.20

Classic T-Shirt

$19.90

Graphic T-Shirt

$28.22

Lightweight Hoodie

$34.85

Lightweight Sweatshirt

$34.85

Long Sleeve T-Shirt

$25.20

Long T-Shirt

$25.20

Premium T-Shirt

$28.22

Pullover Hoodie

$39.90

Pullover Sweatshirt

$34.85

Racerback Tank Top

$19.90

Sleeveless Top

$28.22

Essential T-Shirt

$19.90

Tank Top

$19.90

Tri-blend T-Shirt

$25.20

V-Neck T-Shirt

$22.16

Zipped Hoodie

$39.90

A-Line Dress

$46.45

Chiffon Top

$28.22

Fitted Scoop T-Shirt

$22.16

Fitted T-Shirt

$19.90

Fitted V-Neck T-Shirt

$22.16

Graphic T-Shirt Dress

$40.39

Leggings

$40.39

Mini Skirt

$30.77

Premium Scoop T-Shirt

$28.22

Relaxed Fit T-Shirt

$22.16

Sticker

From $1.25

Glossy Sticker

From $1.38

Laptop Skin

$25.25

Laptop Sleeve

$35.86

Transparent Sticker

From $1.54

iPad Skin

$20.21

iPad Snap Case

$45.46

iPhone Skin

$15.14

iPhone Snap Case

$25.25

iPhone Soft Case

$21.00

iPhone Tough Case

$30.30

iPhone Wallet

$35.35

Samsung Galaxy Skin

$15.14

Samsung Galaxy Snap Case

$25.25

Samsung Galaxy Soft Case

$21.00

Samsung Galaxy Tough Case

$30.30

Art Board Print

From $7.28

Art Print

From $17.18

Canvas Mounted Print

$27.00

Canvas Print

$48.48

Framed Art Print

$80.81

Metal Print

$58.57

Photographic Print

$6.79

Postcard

From $1.51

Poster

$14.32

Tapestry

$31.21

Wood Mounted Print

$27.00

Acrylic Block

From $21.46

Bath Mat

$21.68

Clock

$30.30

Coasters (Set of 4)

$13.91

Comforter

$105.31

Duvet Cover

$86.87

Floor Pillow

From $47.22

Shower Curtain

$57.14

Throw Blanket

$38.92

Throw Pillow

From $18.40

Kids Pullover Hoodie

$26.27

Baby T-Shirt

From $13.69

Kids T-Shirt

From $13.69

Long Sleeve Baby One-Piece

From $14.55

Short Sleeve Baby One-Piece

From $14.55

Toddler Pullover Hoodie

$26.27

Drawstring Bag

$30.30

All Over Print Tote Bag

From $17.18

Backpack

$50.00

Classic Mug

From $12.61

Cotton Tote Bag

From $13.19

Duffle Bag

$45.00

Fitted 3-Layer

From $16.00

Mask

From $8.00

Small Mask

From $8.00

Kids Mask

From $9.99

Pin

$3.31

Scarf

From $22.33

Socks

From $12.92

Tall Mug

From $12.61

Travel Mug

$25.25

Water Bottle

$18.88

Zipper Pouch

From $10.30

Greeting Card

From $1.94

Hardcover Journal

From $17.43

Spiral Notebook

From $10.73

Jigsaw Puzzle

$30.00

Apron

$20.00

Magnet

$7.00

Calculus Based General Physics II: 🧑‍🔬 Hydrogen Wave Function 😲: Active T-Shirt $25.00 Baseball ¾ Sleeve T-Shirt $25.20 Classic T-Shirt $19.90 Graphic T-Shirt $28.22 Lightweight Hoodie $34.85 Lightweight S...