Anna

Venī, Vīdī, Studuī

[studyburst]

I LOVE Excel! I took an Excel class during University and I’ve never stopped using or learning about it since. During my summer internship, I would literally use Excel functions and macros for hours every single day. Even if you don’t want to be an Excel fanatic, learning a few basic functions will make your life easier (and even impress a few managers along the way!).

I’ve outlined below some of the most useful Excel functions to learn. Some of these functions are very basic but can make a huge difference. These functions save time, automate procedures, and make your life easier! And if you need some help on how to learn them, I’ve listed some helpful resources to get you started. With all of us social distancing at home, now is as good of a time as any to add a skill to your resume. 

Excel Functions to Know:

SUM: returns sum of cells selected

SUMPRODUCT: multiplies ranges or arrays together and returns the sum of product

IF: return one value for a TRUE result and another for a FALSE result

SUMIF: returns the sum of cells if the cell meets a single condition

AVERAGEIF: computes the average of the numbers in a range that meets a certain criteria

VLOOKUP: lookup and retrieve data from a specific column in a table can be exact or approximate match

LEFT: returns a given number of characters from the left side of text string

RIGHT: returns a given number of characters from the right side of text string

CONCATENATE: joins the text of cells together and returns the joined text in one cell

LENGTH: returns the given number of characters in a text

Resources:

Excel Jet: Very useful as a type of Excel dictionary to look up syntax and specific formulas you don’t know

Excel Easy: almost like on online textbook for Excel (great resource for those who have no knowledge of Excel at all!)

Udemy: paid excel course with lots of videos, assignments, and downloadable resources

Coursera: self-paced learning option, quizzes and assignments, and a course certificate

Excel Youtube Course by Technology for Teachers and Students

Datacamp (7/12/20 edit thanks anon for the suggestion!)

Prologue to my Excel series

I’ll also be posting Excel tips, tricks, function explanations, and some basic Excel tutorials so if you’d like to see more appear on your dash in the future, follow my blog and look for my Excel series.

[complaintificate]

Library Science on YouTube Masterpost

Okay, so there are a lot more video resources about libraries on YouTube than I thought (which now gets me curious about other potential lists). For the sake of space, library channels, playlists, or channels that have significant library contant are simply linked by entire channel and grouped as accurately as possible. I’m going to continue keeping up this list in a separate page, so please feel free to send me an ask or submit a post with more resources you’d like to see added to the list.

I didn’t include every library channel, I tried to filter them based on which ones I felt had videos with more general application beyond their local institution.

This is just a first draft to get some feedback. If it comes in handy for anyone I’ll add more in a repost later before throwing it up as a separate page.

Academic

9th Columbia University Libraries Symposium - “New Models of Academic Collaboration” [playlist]

ARLVideo (Association of Research Libraries) [channel]

Az LibAssoc [channel]

Bodleian Libraries   [channel]

Building Academic Library 2.0

CHOICE: Current Reviews for Academic Libraries [channel]

College & Research Libraries [channel]

DukeUnivLibraries [channel]

Tutorials and Demos [playlist]

Conservation Program [playlist]

Learning Commons Syracuse University Library [channel]

Liberal Arts Libraries [playlist]

OCLC Research [channel]

Overcoming Challenges of Using Social Media for Outreach in an Academic Library - Part 1   Part 2

Redefining the Academic Library -Part 1  Part 2   Part 3

Rod Library [channel]

Smithsonian Libraries [channel]

The University Library in the 21st Century: A Symposium  [playlist]

University of British Columbia [channel]

Copyright

Standards and Strategies for Fair Use Decisions [playlist]

General

American Library Association [channel]

Columbia University Libraries: Comic New York - A Symposium:  [playlist]

EFIL (Electronic Information for Libraries) [channel]

LibTec203  [channel: cataloging course]

Making it Count: Opportunities and Challenges for Library Assessment. October 25, 2013 [playlist]

School of Social Sciences [channel]

SJSU School of Information [channel]

Wyoming State Library [channel]

Special Collections

National Colloquium on Library Special Collections  [playlist]

Staxpeditions! [playlist]

UISpecColl visits Bauman Rare Books and Rebecca Romney  [playlist]

Technology

Ala TechSource [channel]

Association for Library Collections & Technical Services (ALCTS) [channel]

Boopsie for Libraries: Mobilize Your Academic Library

Georgia Libraries [channel]

Improving Wikipedia Show and Tell (Webinar Recording)

Information Literacy Tutorials [playlist]

MOOCs [playlist]

Open Education Conference [channel]

Top Priorities for Academic Libraries in Advancing Open Education  

Wikipedia and Libraries: Increasing Your Library’s Visibility (Webinar Recording)

[thisherelight]

as is normal round here we moved right through our three days of fall into winter. I have nothing to complain about there. I always love changes in the weather. It’s like going somewhere new without all the hassles of travel. 

still, 6 months is a long time of white and brown. 

[hanne-studies]

did some review for our botany quiz on monday! i accidentally fell asleep throughout the entirety of our teacher’s three-hour lecture, but thank the heavens for powerpoint presentations aaaa

[fegeleh]

i’ve compiled a huge google drive folder of anarchist, socialist, feminist, anti-colonial, anti-imperial books+ essays, crip + disability theory, queer theory, critical race theory, film theory, transnational + diaspora trauma study essays, and writings that combine all of the above

some essays i’ve got from school, most of the books and some essays r from beautiful people on the internet

to be updated as often as i get more shit. which is fairly often~

[fegeleh]

new categories r: abuse, domestic violence, consent, rape // film theory +chinese film +soviet film // ananarchism+socialism // anti-prison // crip theory + other disability theory // diaspora, transnational trauma // education // empire + hegemony (anti-colonial/imperial, etc) // feminism, womanism, black feminism // gender + queer theory // history // MENA (middle east/north africa // misc essays // novels // palestine // philosophy (sorry) // pop culture + tv analysis // race,  ethnicity, racism, antisemitism // religion // resistance theory // science (ideology, philosophy, history // yiddishkeit

categories r growing + changing as i put more time into organizing these files and receive more stuff to add. also a lot of the new stuff i’ve received from other ppl i havent had time to look thru properly so i know i’ve miscategorised some stuff but w/e ill get to that in the summer. if u have anything u’d like to add to this drive, please email me @ [email protected]

[acadeamic]

02.06.19. feels good to be active again:-) here’s some AP bio notes!

[allthingslinguistic]

How to teach yourself linguistics online for free

Wish you were enrolled in an intro linguistics class this semester? Starting a linguistics major and looking for extra help? Trying to figure out whether you should study linguistics and what comes after?  Whether you’re just trying to grasp the basics of linguistics or you’re trying to construct a full online linguistics course, here’s a comprehensive list of free linguistics websites, podcasts, videos, blogs, and other resources from around the internet: 

Linguistics Podcasts

Specific episodes:

The International Phonetic Alphabet and vowels

Constituency

Gricean Maxims and presuppositions

Kids These Days aren’t ruining language

Learning languages linguistically

Phonemes and palatalization

Prepositions, determiners, verbs

Morphemes and the wug test

Why do we gesture when we talk?

Syllables

Podcasts in general:

Lingthusiasm

The History of English Podcast

Talk the Talk

Lexicon Valley

The World in Words

A Way With Words

Vocal Fries

Linguistics Videos

Modular topics:

NativLang (cartoons)

The Ling Space

Tom Scott’s Language Files

Arika Okrent (whiteboard videos)

Structured video series like an online course:  

Introduction to Linguistics (TrevTutor)

Another intro linguistics series (DS Bigham)

Phonology (TrevTutor)

Mathematical linguistics (TrevTutor)

Syntax (TrevTutor)

Another syntax series following the chapter structure of a free online syntax textbook (Caroline Heycock)

The Virtual Linguistics Campus at Marburg University

“Miracles of Human Language” (on Coursera from Leiden University)

Blog posts

General

How much do I need to know before taking intro linguistics? (Spoiler: not much) 

28 tips for doing better in your intro linguistics course

How to find a topic for your linguistics essay or research paper

For typesetting linguistics symbols: What is LaTeX and why do linguists love it? (with sample LaTeX doc to download and modify).

Further linguistics resources about specific areas, such as sociolinguistics, psycholinguistics, language acquisition (first/second), historical linguistics, neurolinguistics, prescriptivism. 

Phonetics & Phonology

How to make your own paper model of the larynx

Teaching phonetics using lollipops

How to remember the IPA vowel chart

How to remember the IPA consonant chart

IPA transcription practice

A detailed explanation of sonorants, obstruents, and sonority

A very elaborate Venn diagram of English phonological features

The basics of how Optimality Theory works, with coffee analogy

Allophones of /t/, explained with internet gifs

Several good visualizations and explanations of the vocal tract

How to type IPA on your phone (Android and iOS) 

Various ways to type IPA on a computer

Morphology & Syntax

Morphological typology cartoons

So you asked the internet how to draw syntax trees. Here’s why you’re confused.

Types of trees: a sentence is an S, a sentence is an IP, a sentence is a TP

A step-by-step guide to drawing a syntax tree, with gifs

Distributed Morphology

Garden path sentences: how they work, some examples

Structural ambiguity and understanding people in Ipswich

How to draw trees on a computer (TreeForm and phpSyntaxTree) 

Pronoun typology and “the gay fanfiction problem”

The solution to violent example sentences: Pokemon

Semantics & Pragmatics

The difference between epistemic and deontic, necessity and possibility (with bonus modals as Hogwarts houses)

Why learn semantics? Comebacks to annoying people.

Presuppositions, implicature and entailment, and more presuppositions in Lizzie Bennet Diaries

Gricean maxims in Welcome to Night Vale

Scalar implicature and a duck gif

Giving a shit about Negative Polarity Items, NPIs explained using Mean Girls references, and a follow-up on Free Choice Items

The lambda calculus for absolute dummies

The Lambda Calculator (software for practising in Heim & Kratzer style)

Teaching & Academic/career advice

Linguistics resources for high school teachers

Teaching linguistics to 9-14 year olds

On writing an IB extended essay in linguistics (& follow-up)

IPA Bingo

IPA Jeopardy and IPA Hangman

Practising syntax trees using cards and string/straws

Find a linguistics olympiad near you!

Editing linguistics Wikipedia articles instead of writing a final paper that no one but the prof will read (see also wikiedu.org)

Should you go to grad school in linguistics? Maybe

Figuring out if you actually want to go to linguistics grad school

How to decide which linguistics grad school to go to

How to look for linguistics undergrad programs

How to interact with someone who’s just given a talk

An extensive list of undergrad and/or student-friendly conferences - apply to one near you!

Advice for linguistics profs on increasing enrollment and supporting non-academic careers

Linguistics jobs - a series about careers outside academia

Languages

Linguistic approaches to language learning resource roundup

Will linguistics help with language learning? / Will learning a second language help with linguistics?

The problem with “economically useful” as a reason for language learning

Further link roundups

This list not enough? Try these further masterposts: 

A very long list of linguistics movies, documentaries, and TV show episodes

A list of books (fiction and nonfiction) about linguistics

A comprehensive list of language and linguistics podcasts, from Superlinguo 

A very long list of linguistics YouTube channels and other free online videos about linguistics 

20 linguistics blogs I recommend following

How to explain linguistics to your friends and family this holiday season

[stdyngs]

what’s up! i know there are more than a couple latin students in the community and as someone who, like, really throws herself into studying latin + associated roman things (i want to be a classicist so) there are a couple (more than a couple) of resources i’ve come across that really help!

history & culture:

fordham ancient history sourcebook

the latin library (bunch of classical latin texts)

whole bunch of links to various latin texts (there’s some medieval christian stuff in here too)

the perseus project (more classical texts but with english translations)

the ancient history encyclopedia

bunch more links to roman history (and medieval history!) resources

classical art research centre

greek and roman female authors 

this lets you figure out how much time and money it took to get from one place to another in the roman world and it’s my favorite

FREE D OWNLOADS OF THE ENTIRE CLASSICAL LOEB LIBRARY? (for those who don’t know: loebs are books with the latin text placed side-by-side with an english translation) holy shit guys this is a big deal

curious about virgil?

another good classics post with a lot of resources

oxford list of classical resources

the language:

reliable, searchable latin dictionary

another one that gives context and specific usage info for the words

a LOT of latin dictionaries mostly in pdf format

absolute need to know latin vocab

online resources for cambridge latin courses (caecilius est in horto. that one)

bunch of grammar resources/pdf textbooks

wheelock’s latin pdf download (honestly this textbook is my favorite)

free downloads of a bunch of other textbooks

grammar reference charts

create customized vocab for your textbooks and ancient texts holy shit

videos in latin

have fun! may the force be with you!

[xannastudiesx]

This is so incredibly helpful Gratias tibi ago! 

[henryclervals]

Masterpost of Free Gothic Literature & Theory

Classics Vathek by William Beckford Wuthering Heights by Emily Brontë The Woman in White  & The Moonstone by Wilkie Collins Carmilla by Joseph Sheridan Le Fanu The Turn of the Screw by Henry James The Monk by Matthew Lewis The Phantom of the Opera by Gaston Leroux Melmoth the Wanderer by Charles Maturin The Vampyre; a Tale by John Polidori Collected Works of Edgar Allan Poe Confessions of an English Opium-Eater by Thomas De Quincey The Mysteries of Udolpho by Ann Radcliffe The Strange Case of Dr. Jekyll and Mr. Hyde by Robert Louis Stevenson Dracula by Bram Stoker The Castle of Otranto by Horace Walpole The Picture of Dorian Gray by Oscar Wilde Frankenstein; Or, The Modern Prometheus by Mary Wollstonecraft Shelley

Short Stories and Poems An Occurrence at Owl Creek Bridge by Ambrose Bierce Songs of Innocence & Songs of Experience by William Blake The Rime of the Ancient Mariner by Samuel Taylor Coleridge The King in Yellow by Robert W. Chambers The Legend of Sleepy Hollow by Washington Irving The Yellow Wallpaper by Charlotte Perkins Gilman

Pre-Gothic Beowulf The Divine Comedy  by Dante Alighieri A Journal of the Plague Year by Daniel Defoe Faust by Johann Wolfgang von Goethe The Tragical History of Doctor Faustus by Christopher Marlowe Paradise Lost by John Milton Macbeth by William Shakespeare Oedipus, King of Thebes by Sophocles The Duchess of Malfi by John Webster

Gothic-Adjacent Northanger Abbey by Jane Austen The Wendigo by Algernon Blackwood Jane Eyre & Villette by Charlotte Brontë Lyrical Ballads, With a Few Other Poems by Coleridge and Wordsworth The Mystery of Edwin Drood by Charles Dickens The Idiot & Demons (The Possessed) by Fyodor Dostoyevsky The Man in the Iron Mask by Alexandre Dumas Moby-Dick by Herman Melville The Island of Doctor Moreau by H. G. Wells

Historical Theory and Background The French Revolution of 1789 by John S. C. Abbott Shakespearean Tragedy: Lectures on Hamlet, Othello, King Lear, Macbeth by A. C. Bradley The Tale of Terror: A Study of the Gothic Romance by Edith Birkhead On Heroes, Hero-Worship, and the Heroic in History by Thomas Carlyle Demonology and Devil-Lore by Moncure Daniel Conway Ancient Pagan and Modern Christian Symbolism by Inman and Newton On Liberty by John Stuart Mill The Social Contract & Discourses by Jean-Jacques Rousseau Feminism in Greek Literature from Homer to Aristotle by Frederick Wright

Academic Theory Introduction: Replicating Bodies in Nineteenth-Century Science and Culture by Will Abberley Viewpoint: Transatlantic Scholarship on Victorian Literature and Culture by Isobel Armstrong Theories of Space and the Nineteenth-Century Novel by Isobel Armstrong The Higher Spaces of the Late Nineteenth-Century Novel by Mark Blacklock The Shipwrecked salvation, metaphor of penance in the Catalan gothic by Marta Nuet Blanch Marching towards Destruction: the Crowd in Urban Gothic by Christophe Chambost Women, Power and Conflict: The Gothic heroine and “Chocolate-box Gothic” by Avril Horner Psychos’ Haunting Memories: A(n) (Un)common Literary Heritage by Maria Antónia Lima ‘Thrilled with Chilly Horror’: A Formulaic Pattern in Gothic Fiction by Aguirre Manuel The terms “Gothic” and “Neogothic” in the context of Literary History by O. V. Razumovskaja  The Female Vampires and the Uncanny Childhood by Gabriele Scalessa Curating Gothic Nightmares by Heather Tilley Elizabeth Bowen, Modernism, and the Spectre of Anglo-Ireland by James F. Wurtz Hesitation, Projection and Desire: The Fictionalizing ‘as if…’ in Dostoevskii’s Early Works by Sarah J. Young Intermediality and polymorphism of narratives in the Gothic tradition by Ihina Zoia

[xannastudiesx]

Hey guys, this is just a hubris post to remind me how proud I am right now. I was so nervous going up and reciting my poetry and I was the very last name to be drawn from that hat and my knees shook so much they made a noise. But I made it through the poem with only one mistake and I’m really proud of myself for making it through.

I have to remember to challenge myself like this; it’s what allows me to grow

[xannastudiesx]

I cannot argue with people who don’t understand facts, I can point to a rock and say this is a rock and they’ll say it’s a sheep and I’ll say it’s a rock and I can prove it and they’ll go against all evidence and call it a sheep.

[xannastudiesx]

I want to know enough of a language so that I can write poetry in it. For that is the most artful form of speaking, to let it drip full and bountiful off your tongue like honey. To know the shape of the vowels like your own palm, to know the quirky and the seamless elisions of certain words. To know a language intimately is to be able to write poetry in it. 

[xannastudiesx]

First College Visit to Vassar

Hey guys! I just went on my first college visit to Vassar College in Poughkeepsie, NY

I figured I’d just record my thoughts on it to keep track. 

Things I liked:  The architecture was all very pretty except for the admissions building which was frankly quite ugly

The flexibility in choosing your classes(no core classes and opportunities to do multiple majors/minors)

Ability to go abroad(second semester of Sophmore year or Junior year generally)

Offers languages I plan to study (Russian and Latin)

Has an observatory

Director of Admissions was very candid about the whole process

People seemed very diverse and nice

Huge variety of clubs and activities

Has a music program and a wind ensemble

Things I Disliked: 

The classrooms were kind of ugly 

Didn’t show us the dorms which was kind of suspicious

No guarantees on getting classes you want in this kind of whatever-you-choose format

Majority economic and poly sci. majors

The dining hall was very loud and didn’t have a ton of GF/DF options(they only had one large one)

The tuition is very expensive if you include room/board

[lawyerd]

400 | Has anyone read this book? The quote on the cover, “Tremendously moving” really sums it up. 

Currently Listening - Buttercup, Hippo Campus

[xannastudiesx]

Yes, this book was so emotional!

[labentiasidera-deactivated20210]

“Non est ad astra mollis e terris via.”

—

Seneca

There’s no gentle path to the stars from earth.

[haruspex127]

Colores Latine Colours in Latin

The two glauci there aren’t a mistake.

[xannastudiesx]

🎵Dance Anthem of the 80’s -Regina Spektor

Mind map on the revolutions of 1848