---
# System prepended metadata

title: 'Software tools required for The Carpentries workshops:'
tags: [uc-carpentries]

---

# Software/Data Downloads: The Carpentries workshops
updated: 2022-08

## Tidy Data Workshop:
* **Any spreadsheet application is required.** 
* Excel, Google Sheets, Open Offce, etc. 

---

## Unix Shell and Git Workshop: 
### Git for Windows - Windows
* Windows: https://gitforwindows.org  
    * download the Git-2.33.0.2-64-bit.exe
    * Git win 64 bit Direct download link https://github.com/git-for-windows/git/releases/download/v2.33.0.windows.2/Git-2.33.0.2-64-bit.exe
* Mac users will use the built-in Terminal application
**required for Unix Shell and Git lesson** 


**Recommended Text editors to use:**
### Nano 
* Part of Git for Windows isntaller (called GitBash) 
    * Nano for Winodws direct download: https://sourceforge.net/projects/nano-for-windows/
* MacOS Terminal 


### Notepad++ (optional text editor)
https://notepad-plus-plus.org/downloads/
* Download latest version Notepad++ 


---


## Introduction to Python Workshop:
### Anaconda
https://www.anaconda.com/download/ 
* download latest version - 64-bit installer for Windows 10
* This application is used to install and run Jupyter Notebooks
* Web-based Jupyterlab: https://jupyter.org/try-jupyter/lab?path=notebooks%2FIntro.ipynb (for use if there are problems during the workshop)

---

## Introduction to R Workshop:
### Base R
https://cran.r-project.org
* Download and install for Windows
* Download and install for MacOS
* Required installation for RStudio

### RStudio 
https://www.rstudio.com/products/rstudio/download/#download
* WindowsOS - Download Windows Vist/7/8/10 link
* MacOS - Download MacOSX 10.6+ (64-bit)
* RStudio Cloud: https://rstudio.cloud - for use if there are problems during the workshop

---

## Introduction to OpenRefine:
## OpenRefine
http://openrefine.org/download.html
* Download and Install OpenRefine latest Version 
* Windows kit zip file for Windows 
* Mac kit for MacOS 


**Data Download:** https://raw.githubusercontent.com/LibraryCarpentry/lc-open-refine/gh-pages/data/doaj-article-sample.csv 
    * right click and "save as"  .csv file

---



## Introduction to SQL:
### DB Browser for SQLlite
https://sqlitebrowser.org/dl/
* Windows install 64-bit version
* Mac Download latest version


---
**For non-Carpentries PostgreSQL workshops:**

pgAdmin - https://www.pgadmin.org/download/




---


# Addtional installation notes:
## Microsoft One Drive or iCloud usage 

**If you have a One Drive account or iCloud account connected to your computer, you might have two Desktop folders!**

* One is the Desktop folder on your local machine, and the other is the Desktop folder in the cloud. 

This causes a lot of confusion because your computer displays the contents of both folders on your desktop. 

You can figure out where your stuff actually is by opening **`Finder (Mac) or File Explorer (Windows)`** and looking inside the individual folders. 

* Try to put the “shell-lesson-data” folder in your *local* Desktop.
