LINC-405: Spring 2022 #7 Poets in Google Sheets

LINC-405: Spring 2022

Beginning Technology Skills
Foothill College: Spring 2022

Instructors: William Cavada,
Kim Randall, Gene Tognetti

Assignment #7: Poets in Google Sheets

June 14, 2022

By Peter Y. Chou
WisdomPortal.com

Preface: On June 8, 2022, 6:00-6:30 pm, in LINC-405 Zoom class Skills Workshop with William Cavada, he showed
how to arrange items in Google Sheets. He typed the persons present in the ZoomSession— William Cavada, Peter Chou,
Mara MacDonald in three rows. First name in Column 1, Last name in Column 2. Alphabetize the three names. Cavada
suggested I could use Google Sheets to arrange my favorite poets. Gathered postage stamps of six poets to arrange in
Google Sheets— Name, Dates, Biography, Poem to Read. Rumi: Quatrain 1246; Dante: Paradiso 33; Goethe: Faust II:V;
Blake: Auguries of Innocence; Rilke: Winged Energy; Emily: Poem 111.
*************************************************************************************

1. William Cavada's Skills Workshop on Google Sheets (June 8, 2022)

Google Sheets Icon

Spread Sheet of Lakeside Shirt Sales

Split Names in Google Sheets

On June 8, 2022, 6:00-6:30 pm, in LINC-405 Zoom class Skills Workshop with William Cavada,
he showed how to arrange items in Google Sheets. He typed the persons present in the Zoom Session—
William Cavada, Peter Chou, Mara MacDonald in three rows. First name in Column 1, Last name
in Column 2. Alphabetize the three names. An earlier LINC-405 assignment (8-6-2021) shows
Spread Sheet of Lakeside Community Center Shirt Sales (above). He also showed how to split
names in Google Sheets, placing last name in column A and first name in column B.

2. Arranging Poets in Google Sheets

Jalal al-Din Rumi
(1207-1273)
Syria 1574
(issued 9-30-2005)
Dante Alighieri
(1265-1321)
Mexico C308
(issued 11-23-1965)
Wolfgang von Goethe
(1749-1832)
Germany 10NB9
(issued 7-20-1949)
William Blake
(1757-1827)
Romania 1220
(issued 5-31-1958)
Rainer Maria Rilke
(1875-1926)
Austria 1049
(issued 12-29-1976)
Emily Dickinson
(1830-1886)
U.S. 1436
(issued 8-28-1971)
Cavada suggested I could use Google Sheets to arrange my favorite poets. Gathered postage stamps of six
poets to arrange in Google Sheets— Name, Dates, Biography, Poem to Read.

Row 8 is missing (similar to Row 1), when I tried to move it to the top, it disappeared. Later,
I learned to Insert Columns & Rows to place Row 1 on the top. Tried to insert postage stamps
as portraits for the poets, but the image came out so tiny that I gave up trying to enlarge it.
"Biography" links to Wikipedia on the poets. "Poem to Read" links to poems of the six poets
on my web site.