Category Archives: Tech Resources

Making Graphs and Charts

Making Charts and Graphs

Here are some video tutorials on making various kinds of charts and graphs in Power Point that can then be embedded on a WordPress site, courtesy of Emily Sherwood, ITF at Baruch!

How to build an Excel Pie Chart in PowerPoint on a Mac.

Learn to build an Excel Cluster Column Chart in PowerPoint.

 

Learn how to change your chart type from cluster column chart to stacked column chart and add a total label to the chart. Fancy.

 


How to build a line chart!

 

Edit

Making a Statistical Profile

There are two websites that will be useful to you in compiling your Statistical Profile for your group project.  The first is Social Explorer: http://www.socialexplorer.com

Social Explorer allows you to access U.S. Census data going back to 1790.  You can access data for particular zip codes or census tracts (generally a smaller geographical area) and use Social Explorer to map this data.

The second site is Infoshare: http://www.infoshare.org/main/directip.aspx

Infoshare compiles multiple data sources for New York City.  It has more comprehensive data than Social Explorer and can sort data by neighborhood, Community Board or borough.  It does not, however, produce fancy maps.

Final Website Project Resources

As we hit the mid-way mark of the semester, it is time to start planning your final project. Your ITF is here to help!  Thanks to Amanda Licastro, an ITF at Brooklyn, for compiling this guide.

As a class:

Start by identifying the elements you think are effective in previous course sites by browsing the Encyclopedia (shown to you at Tech Fair and examples posted by your professor). Consider especially:

  1. Site Theme – How many columns are there? Does it have a custom header? How many navigation menus are there?
  2. Menus – Where are they on the site (top, side, bottom, embedded in a map or slider)? Do they contain sub-menus?
  3. Pages – How are the pages designed? Do the pages contain linked indexes? What kind of multimedia is used? How and where is the media embedded (link, image, etc)?

You will want to choose the elements you think will work best for your site, and then come together as a class and assign roles to different people in order to achieve a cohesive site. In other words, everyone should have a task to work on and you should create a schedule that makes sense in terms of workflow in order to complete the project on time.

As a group:

  1. Organize your information – What topics do you wish to cover? How do you want to organize the various elements (menus, qualitative and quantitative descriptions)?  Can you identify keywords for your project?
  2. Select your media – What medium will best feature your work: video, timeline, map, images, text, or a combination?
  3. Assign roles – Again, you want to think about this in terms of tasks that individuals can complete in order to realize your cohesive vision. You may want to assign a writer, editor, designer, and put someone in charge of finding and testing digital tools.

Tool Ideas:

Here are a list of tools you may want to consider using to showcase your work-

Please email your ITF (maggie.dickinson@gmail.com) to set up an appointment during office hours if you need help.

Creating a Zotero Account

Here are instructions to create a Zotero account, join the class Zotero group and download Zotero.

1. To create a Zotero account
Go to zotero.org and click on “register” in the top right corner. Follow the instructions to create a free account. When you validate your email address you’ll be asked to open Zotero and change your password in preferences – you can ignore this step for now.

2. Once you have an account
Be sure you are logged in. Click on the “groups” tab on the zotero homepage and search for the group “Macaulay Seminar 2, Professor Libman″. Clicking on the group will take you to a page with an icon that says “join group”. Click on that, and we’ll be sure to approve your membership!

3. Making Zotero work for you
Now that you have a Zotero account you can add and upload citations to your library manually, however a lot of the cool functionalities which make zotero easy and awesome are not yet available to you. You’ll need to download Zotero onto your macbook. If you use Firefox as your regular browser, choose “Zotero for Firefox”, otherwise choose the “Zotero Standalone” with the browser extension that matches the browser you use most often (ex. Chrome or Safari).

Once you’ve created an account, joined the class group, and downloaded Zotero onto your macbook you’re all set to begin sharing and saving citations! In the mean time, you can explorethese great tutorials on the Zotero.org website.

If you run into any trouble with the tasks listed above, please feel free to be in touch with me.