SPA 410/MLL 410

Digital Literacy Through Cultural and Literary Topics in Spanish - Fall 2025

Class 9 - Álvaro de Luna, Libro de las claras e virtuosas mugeres (1446)

Pendientes:

Proyecto Leonor

Google Docs con todos los textos
Falta conclusión. ¿Ideas?
Transformar el documento en markdown y subirlo al spreadsheet.

11:15AM Álvaro de Luna, Libro de las claras e virtuosas mugeres (1446)

Comentario sobre las biografías leídas y responder preguntas:

Judith
Reina de Saba
Lucrecia
Reina Dido
Marina
Teodora
Margarita
Eugenia

Discusión:

¿Cuáles son las virtudes de estas mujeres y através de qué acciones se demuestran?
¿Por qué crees que son comparadas a ciertas figuras masculinas?
¿Qué tienen en común las santas Marina, Teodoro, Margarita y Eugenia?
¿Qué biografía te ha gustado más? ¿Por qué?

Trabajo de visualización:

Bar_Chart_Virtues_Beginner.ipynb
Explicación spreadsheet (campos)
Biografía - Virtud
Lista de virtues (discusión)
Lista de hombres comparados.
¿Cuál será la virtud más mencionada? Apuestas?

Lista de figuras a interpretar:

Figura 1: Distribution of Virtues Accross Biographies (cifras inventadas).
Figura 2: Distribution of Virtues Accross Biographies (virtudes en el eje vertical)
Figura 3: Distribution of Virtues Accross Biographies (virtudes en el eje horizontal)
Figura 4: Distribution of Virtues Accros Biographies (con el número de biografiadas con esas virtudes).
Figura 5: Distribución de las biografías con las 5 primeras en color diferente. Problema con el color.
Figura 6: Distribución de las biografías con las 5 primeras en color diferente. Problema solucionado.
Figura 7: Distribution of Virtues Accros Biographies (con el número de biografiadas con esas virtudes y los nombres de las biografiadas).

¿Qué nos dicen estos gráficos de barras sobre las virtudes en el siglo XV y la idea de virtud de Álvaro de Luna?

Proyecto 2

Para el próximo día:

Explorar estas visualizaciones Bar_Chart_Virtues.ipynb y Virtue_MaleComparison_Heatmap.ipynb

Welcome to CollectionBuilder-Sheets!

Using the options below you can select demo metadata to explore a pre-built collection, or load your own metadata from the web or your local computer. The configurations are temporarily stored in your browser's session storage, so will remain only until you close this window!

Select one of our example collections

Paste in the full url for a CSV hosted online, such as a published Google Sheet (see below for instructions!)

Select a CSV file from your computer

Metadata Tips

Set up your metadata carefully following the template guidelines. Be especially careful with column names in the first row–they need to exactly match the template, with no spaces and no extra white space at the end of the value. Records without an “objectid” will be skipped.

Note: no information is sent to the server, the metadata and configuration change is only on your computer.

How to Publish Your Google Sheet

In your Google Sheet, ensure that your metadata is the first sheet in the spreadsheet (by default named "Sheet1"). The tabs can be dragged to reorder if necessary.
Click “File”, “Share”, and select “Publish to the Web”.
On the popup modal, use the dropdowns in “Link” tab to select “Entire Document” and “Comma-separated values (.csv)” options, then click “Publish” button.
Copy the link that is provided.
In the "Use Metadata CSV Link" form above, paste the link and click "Submit".

For example, a published link looks like:

https://docs.google.com/spreadsheets/d/e/2PACX-1vSn7AA-cbsXT3_nNUGftc1ab-CKXOJHMQCIENeR9NHElbyI9_qA99o0-HNZdG04v-M2_N21bUe_krQQ/pub?output=csv

How to Download Your Google Sheet as CSV

On your Google Sheet, switch to the sheet tab that contains your metadata (by default "Sheet1").
Click “File”, “Download”, and select as "Comma Separated Values (.csv)”
The file should download to your computer’s Downloads folder
In the "Use Metadata CSV from your Computer" form above, click “Choose file” and navigate in your file explorer to select the downloaded CSV, then click "Submit".

Other Web CSV

If you have a CSV available anywhere on the web, you can use it by referencing the full URL. However, depending on where your CSV is hosted, you may encounter CORS errors.

For example, to use a CSV hosted in a GitHub repository, use the “raw” link:

https://raw.githubusercontent.com/CollectionBuilder/collectionbuilder-sample-data/main/psychiana_cbdemo_gh.csv

Paste the link into the "Use Metadata CSV Link" form above and click Submit.

To share your work with others, the default template can also load web CSV metadata specified as a parameter in the URL. Add your full metadata link to the end of the CB-Sheets instance’s URL as the “csv” option, like:

https://collectionbuilder.github.io/collectionbuilder-sheets/?csv=<your metadata url here>

For example:

https://collectionbuilder.github.io/collectionbuilder-sheets/?csv=https://raw.githubusercontent.com/CollectionBuilder/collectionbuilder-sample-data/main/psychiana_cbdemo_gh.csv

or

https://collectionbuilder.github.io/collectionbuilder-sheets/?csv=https://docs.google.com/spreadsheets/d/e/2PACX-1vSn7AA-cbsXT3_nNUGftc1ab-CKXOJHMQCIENeR9NHElbyI9_qA99o0-HNZdG04v-M2_N21bUe_krQQ/pub?output=csv

Note: the metadata URL can not have any & (i.e. additional query string parameters). Having a & in the URL will cause the parsing to fail.