Building History Databases: Whats Overkill?

Hosted by: David M- PHD at George Mason

-Looked at travelers between US and Mexico before 1856

-Organizing with Excel but thinks their could be some database versatility

-Trying to incorporate more visual stuff into his spread sheets, Excel is possible but very difficult to get it done, Google Sheets seems to be more user friendly for this

-Google sheets and election—> Washington Post directed people to Google Sheets to help track popular votes in past election

-Excel vs Google Sheets vs Sequel:

-Excel has proved its longevity and that no matter the improvements Google Sheets may make, Excel will still have its own usefulness.

-Excel is very helpful for social network analysis

-Google Sheets makes communicating information with other people fairly easy as it can be exported into a number of different of formats including Excel

-Sequel is good for large networks as it allows you to create separate tables for specific criteria

Multiple spreadsheets vs single spreadsheets for extensive databases:

-Multiple spreadsheets seems to be more helpful for different pieces of information about same topic instead of compiling all into single spreadsheet with numerous pages

-No one database is right for a specific topic: Many different databases can work for same topic, At the end of the day, it all depends on what exactly you are looking for, and user preference.

-Issues with historical databases: Spelling “conventions” took a long time to settle down so people may be referring to one person but are spelling it in many different ways so hard to keep accurate track of individuals

-One solution to this is the Open Refined Program (open Source for when you have messy data to help clean up your data and clarify potential inaccuracies, spelling errors, etc

Categories: Uncategorized |
Profile photo of Connor Boggs

About Connor Boggs

Im originally from Los Angeles California and will be moving back there after I graduate this spring. I have majored in Organizational Sciences and have a deep passion for music.