The first video in our database lesson, part of the Introduction to Computer series.
This video looks at the basics of databases. We define database, as well as key terms to know.
Database Management Systems is the software that allows us to create and use a database. This video looks at the DBMS, their functions, some examples of popular software solutions and a quick look at Structured Query Language (SQL)
The database management software is the program used to create and mange the database. The database model is the architecture the DBMS used to store objects within that database.
Our final database video. This one looks at some odds and ends. We examine: Data Warehouse, Data Mining, Big Data. I also talk about the ethics of data mining from the NSA and CDC, and how they are different.
We also give out top picks for the lesson.
Links from Video:
•http://www.w3schools.com/sql/
•What is Database & SQL by Guru99 http://youtu.be/FR4QIeZaPeM
•What is a database http://youtu.be/t8jgX1f8kc4
•MySQL Database For Beginners https://www.udemy.com/mysql-database-for-beginners2/
Software Carpentry lesson that teaches how to use databases and SQL In the late 1920s and early 1930s, William Dyer, Frank Pabodie, and Valentina Roerich led expeditions to the Pole of Inaccessibility in the South Pacific, and then onward to Antarctica. Two years ago, their expeditions were found in a storage locker at Miskatonic University. We have scanned and OCR the data they contain, and we now want to store that information in a way that will make search and analysis easy. Three common options for storage are text files, spreadsheets, and databases. Text files are easiest to create, and work well with version control, but then we would have to build search and analysis tools ourselves. Spreadsheets are good for doing simple analyses, but they don’t handle large or complex data sets well. Databases, however, include powerful tools for search and analysis, and can handle large, complex data sets. These lessons will show how to use a database to explore the expeditions’ data.
Activities
A number of publishers and funders, including PLOS, have recently adopted policies requiring researchers to share the data underlying their results and publications. Such policies help increase the reproducibility of the published literature, as well as make a larger body of data available for reuse and re-analysis. In this study, we evaluate the extent to which authors have complied with this policy by analyzing Data Availability Statements from 47,593 papers published in PLOS ONE between March 2014 (when the policy went into effect) and May 2016. Our analysis shows that compliance with the policy has increased, with a significant decline over time in papers that did not include a Data Availability Statement. However, only about 20% of statements indicate that data are deposited in a repository, which the PLOS policy states is the preferred method. More commonly, authors state that their data are in the paper itself or in the supplemental information, though it is unclear whether these data meet the level of sharing required in the PLOS policy. These findings suggest that additional review of Data Availability Statements or more stringent policies may be needed to increase data sharing.
In this lab, students are introduced to the difference between relative and absolute dating, using the students themselves as the material to be ordered. Initially, the students are asked to develop physical clues to put themselves in order from youngest to oldest (exposing the inferences we make unconsciously about people's ages), and this will be refined/modified using a list of current events from an appropriate historical period that more and more of the students will remember, depending on their age (among other variables). Absolute age is introduced by having the students order themselves by birth decade, year, month, and day, and comparing the absolute age order to the order worked out in the relative-dating exercise, with a discussion of dating precision and accuracy.
(Note: this resource was added to OER Commons as part of a batch upload of over 2,200 records. If you notice an issue with the quality of the metadata, please let us know by using the 'report' button and we will flag it for consideration.)
This video explains the design of the Arecibo Message transmitted in the 1970s by SETI pioneers. It explains why humans sent the message and who they hope might receive it. It shows the telescope in Brasil. It plays the audio signal from the message that was sent and shows how that signal can be converted to binary to show an image. It also gives a brief overview of how the binary number system works.
The book offers a blend of theory and practice in guiding readers to apply design thinking principles to solving some of our world’s biggest problems. At the same time, readers are encouraged to become aware of new and emerging technologies that make prototyping and applying solutions a reality.
Differentiating open access and open educational resource can be a challenge in some contexts. Excellent resources such as "How Open Is It?: A Guide for Evaluating the Openness of Journals" (CC BY) https://sparcopen.org/our-work/howopenisit created by SPARC, PLOS, and OASPA greatly aid us in understanding the relative openness of journals. However, visual resources to conceptually differentiate open educational resources (OER) from resources disseminated using an open access approach do not currently exist. Until now.
This one page introductory guide differentiates OER and OA materials on the basis of purpose (teaching vs. research), method of access (analog and digital), and in terms of the relative freedoms offered by different levels of Creative Commons licenses, the most common open license. Many other open licenses, including open software licenses also exist.
The first video in the digital media series. Digital Media is defined as: any media that are encoded in a machine-readable format. It can be created, viewed, distributed, modified and preserved on computers.
In this lesson we will look at the following:
-Digital Publications
-Digital Audio
-Digital Graphics
-Digital Photography
-Digital Video
We continue our look at digital media with digital publications. We examine eBooks, self publishing, two great authors, the death of traditional newspapers, blog and microblogs.
Links from Video:
-http://www.createspace.com/
-http://www.lulu.com/
-http://jlbourne.com/
-http://monsterhunternation.com/
-https://wordpress.com/
-https://www.tumblr.com/
-https://www.facebook.com/mrfordsclasslearning
-https://twitter.com/mrfordsclass
Part 1 of 2 focusing on digital audio. This is part of our Introduction to Computers - Digital Media lessons.
This lesson looks at:
-Sampling Rate
-Bit Depth
-Mono/Stereo/Surround
-Recording formats
Part 2 of 2 focusing on digital audio. This is part of our Introduction to Computers - Digital Media lessons.
This lesson looks at how we get audio into and out of the computer:
-Sound cards
-Microphones
-Audio editing software
-Speaker configurations
Links from Lesson:
-http://grooveshark.com/
-http://www.jango.com/
-http://www.pandora.com/
-https://www.spotify.com
-http://www.iheart.com/
-http://audacity.sourceforge.net/
Video 5 of our Digital Media, Introduction to Computers series. In this video we look at digital imagining.
Topics covered:
•Color Modes
•Image File Format
•Digital Cameras
•Image Quality
•Image Editing Software
•Online Photo Albums
Links from Video:
•https://www.flickr.com/
•http://picasa.google.com/
•http://www.shutterfly.com/
•http://www.smugmug.com/
•http://www.tomsguide.com/us/dslr-vs-mirrorless-cameras,news-17736.html
•http://www.gimp.org/
The last video in our digital media series from Introduction to Computers.
This video looks at the basic of digital video including: frame rate per second, SD/HD, pixels, aspect ratio, things to look for when buying, streaming video, and video editing software. We also give out digital media picks.
Links from Video:
-http://www.videomaker.com/
-File Format http://bit.ly/1m5gMVM
-http://www.hulu.com/
-http://vimeo.com/
-https://www.netflix.com
-http://www.ustream.tv/
-http://audacity.sourceforge.net/
-http://www.mediacollege.com/
-http://www.bhphotovideo.com/
A Digital Project Preservation Plan is designed to help with organizing preservation efforts for digital projects. Initially drafted as a companion guide meant to fill the gap on best methods for preserving digital scholarship or digital humanities projects, it can also be applied to digital projects outside the humanities. This preservation plan is most beneficial to those digital humanities (DH) project creators who need guidance on how to start a digital project with preservation in mind. Although the DH community has shared resources and case studies, the examples available tend to focus on DH development, and less on DH preservation. These resources are also located in disparate locations. The Digital Project Preservation Plan is a singular guide, focusing on DH preservation, as a starting point with references to more resources and related DH practices. This is a working document, available to practitioners in whole or part; ideally, it will be used in the early stages of project planning and consulted and revised regularly. The preservation infrastructure should be designed and built as a collaborative effort from the beginning of the project. As priorities, methods and technologies change, the preservation plan will need to be updated and modified accordingly.
This book has been used in humanities (history) and media courses but is applicable to any course that has digital/web project components.
The Table of Contents for this publication includes:
Summary, Project Charter, Digital File Inventory, Additional Considerations, Preservation Plan-A Summary and Checklist, References/Plan Resources, Appendix A: Project Charter, Appendix B: Digital File Inventory, Appendix C: Project Profile, Appendix D: Collaborators Web Publishing Agreement, Appendix E: Universal Design Checklist, Appendix F: Preservation Guidance Checklist, and the Glossary.
The Living Book of Digital Skills (You never knew you needed until now) is a living, open source online guide to 'modern not-quite-technical computer skills' for researchers and the broader academic community.
Our second video in the free Introduction to Computer series. This video defines and examines what digital literacy means. We also look at why it is important.