Instructor: Jing Gong. Class Time: M/W/F 2:00-2:50 pm

Software/Tool Instructions

Setting up R and RStudio

R is a widely-used, open source statistical analysis platform. RStudio is an integrated development environment for R – that means it makes using R easier!

  • You should install both software packages – R and RStudio! Don’t just install R or your life will be difficult! 

We’ll be using this software to do some advanced analytics in the second half of the semester! You can get a full copy of the software – PC or Mac – for free!

First, download and install R:

  • Download the installation package for R.
    • Choose the link for your operating system (Windows or MacOS).
    • If you have Windows, choose the “base” installation file. If you have a Mac, you’ll have to choose the one that corresponds to your version of MacOS.
    • Download the latest version (the latest version is R 3.4.2)
    • Install the software, accepting the default options.

Now, download and install RStudio: (You need to have R installed first!)

  • Download the appropriate installer from the RStudio website.
    • We will use the RStudio Desktop (Open Source License) version, which is free.
    • Choose the link for your operating system (Windows or MacOS).
    • Download the latest version (the latest version is RStudio 1.1.383)
    • Install the software, accepting the default options.

After both are installed, you’re always going to run RStudio, which will use R behind the scenes to give you a pleasing analytics experience!

Download the latest version of Office (Windows or Mac)

We will use Excel to create Pivot tables this week. Note that if you have an earlier Mac version, some of the options may not be available. If so, download the latest Mac version of Microsoft Office for free by following the instructions here: https://computerservices.temple.edu/office-365. It is free for Temple students.

The webpage also offers free download of Microsoft Office for Windows users.

Setting up MySQL Workbench by September 20

We’ll be using MySQL Workbench to create and execute SQL queries (to interact with databases). That will start around September 20, 2017.

(1) If you’re using your own computer (Windows or Mac), you’ll need to install the software;

If you’re using a lab computer which already has MySQL Workbench installed, you’ll still need to configure a connection to access databases with your username and password.

You can get instructions for how to do both of those things in this Quick Guide to MySQL Workbench. Use the guide to setup your software and connection.

(3) Whether you use a lab computer or your own computer, you’ll also need a MySQL username and password. I’ve assigned one to each of you, which you’ll find in the Grade Center of Blackboard.

 

How to Insert an Image in Word?

For some of the assignments and exercises, you need to put images into a Word document. Here are a few ways of inserting an image to a Word document.

  1. Inserting an image file into Word. If you have an image file (such as .png from ERDplus), follow the instructions here: Insert pictures in Office 2013 and Office 2016
  2. Capturing screen shots.
  3. Converting Powerpoint objects. You can copy objects from Powerpoint, and paste it into Word as an image. Here are the steps: How to Convert PowerPoint Objects to Word Pictures

Using ERDPlus to Creat Entity Relationship Diagrams (ERD)

We will use ERDPlus to create Entity Relationship diagrams (ERDs). It’s free, and easy to use.

Specifically, we will use the standalone version of ERDPlus (https://erdplus.com/#/standalone), which allows us to create an ERD within a browser.

This is a short YouTube tutorial on the site that shows you how to create a diagram, and export the diagram as an image which can be placed into a Word document.