1 of 19

Science Communication #3

 

07/16 (Tuesday)

09:00

09:15

09:30

09:45

10:00

10:15

10:30

10:45

11:00

11:15

11:30

11:45⇾Group WOrk TIme

Group work time. Work on your Balloon presentations.

Groups start presenting… 6 groups @ 5 minimum to 10 maximum minutes

 

Work on Ethics Video. Submit a version by end of the day.

Final needed by end of Friday (7/19)

Lunch: Picture at the Library

2 of 19

3 of 19

Ethics video presentations:

Each group presents one by one

Provide other teams with constructive feedback to improve their work.

Presentation:

  • Shows why the problem is interesting and challenging
  • Presentation is engaging
  • Speech is clear, reasonably-paced, well-organized, and easy to follow with effective use of visual elements

Comments: What are the strengths?  What are the areas of improvement?

Problem:

  • Explicitly raises ethical problem by showing that the core ethical principles seem to conflict, or that the demands of a particular ethical principle are unclear in the circumstances

Comments: What are the strengths?  What are the areas of improvement?

Solution:

  • Offers clear solution to the ethical problem and provides convincing arguments for the proposed solution
  • Anticipates possible concerns from viewers

Comments: What are the strengths?  What are the areas of improvement?

4 of 19

5 of 19

To cite this piece of information, you could paraphrase and write:

Based on Hartley’s computations in her thesis, the Citicorp Building was susceptible to quarterly winds (Drill, 2020).

Or you could quote it as is (recommended for 40+ words):

Drill(2020) stated that:

Hartley’s thesis was that the building was susceptible to quarterly winds, which in a freak storm could impact the stability of the building.

Add in your bibliography (list of references)

Drill, M.

(2020, August 22).

The courage to raise a design flaw, listen and act, saved the Citicorp Building.

Retrieved on

July 16, 2024,

from https://medium.com/an-idea/the-courage-to-raise-a-design-flaw-listen-and-act-saved-a-city-8d37c1ce2a8b

6 of 19

Wait… what’s a quarterly wind?

Quartering winds: winds that blow from such…

(2021, August 20).

Chicago Tribune.

Retrieved June 19, 2024,

from https://www.chicagotribune.com/2002/08/

15/quartering-winds-winds-that-blow-from-such/

Add in your bibliography…

7 of 19

Clink here to access the practice and make a copy.

Using what you had just learned/reviewed:

  1. For each website, click on the link and look for the information needed.

  • Write a sentence to paraphrase the information or make a direct quote, using the proper citation format.

  • Then cite the website as a one of your sources using the appropriate format.

  • As always, use what you have learned to further improve upon your video assignment deliverables.

8 of 19

Excel basics for plotting points

Our main use for Excel in C2 is to represent your data as tables and as graphs.

Students will:

  • Format cells & properly label the data (not just x or y)
  • Simple computations (if it simplifies things)
  • Converting table to graph
  • Choosing the most suitable type of graph

9 of 19

Formatting cells and labeling data

Depends on data…

You will want to align decimals

Choose the one that displays data clearly

10 of 19

Formatting cells and labeling data

Control the format of your data…

How many decimal places, etc.

Choose the one that displays data clearly

11 of 19

Formatting cells and labeling data (optional)

Changes the cell to a multiple-choice format of possible values

You can type custom error messages to remind you of correct format

12 of 19

C9

B2

Simple computations

These can be treated as variables when you need to write equations.

= (2 * C9)/3

* Careful to type your equation correctly… follow PEMDAS

* There are many built-in formulas

* Gives you clues as you type…

13 of 19

C6 later changes to C7, C8, and so on…

You can manually compute for this and input the data later…

total change in height

= original – new height

height = 12

height < 12

Or you can assign the formula = $C3 – C6

The $ makes C3 permanent since it is the original height

14 of 19

Highlight the 2 columns using Ctrl + drag. These become your x- and y-axes.

Then insert the type of chart you want

You can then change the elements of the chart

15 of 19

You can also right-click on the graph so you can “format” its components.

Excel lets you change the smallest of details, like the color of the lines, the thickness of the axes, etc.

Play around with the features to suit your aesthetics.

16 of 19

17 of 19

  • Choose the appropriate chart type to represent your data.
  • Make sure to label important information
  • Change the font size, color, etc. to highlight important details and for aesthetics.

18 of 19

  • Excel has built-in graphs for you. Choose the one that is best for you.
  • You add the units, labels, and other missing details. You can also change color or font.

19 of 19

  • From the water balloon challenge, Excel could have been programmed to automatically compute weight and P.I. for you.