1 A quick and dirty guide to opening files in UCINET and NETDRAW with pictures 1 STEP 1: Recording your data When you start, your data should be in an Excel sheet, formatted like this. Note that the row headers and the column headers must be the same. Nothing should be in the upper left corner. In this example, the two boys talk to each other, the two girls talk to each other, and Bob and Rachel talk to each other. Their relationship is listed as a 2, which implies a stronger relationship. Perhaps they are dating. 2 STEP 2: Type your data into UCINET UCINET can import Excel data. Occasionally, however, that gives strange error messages. 3 Since we are only using a simple data set, we will take a little extra time retyping our data to avoid frustration. After you open UCINET, go to the data menu, and click on import data via spreadsheet interface (DL). That should bring up a screen like the one below, except with no data in the spreadsheet. 1 but no dirty pictures. 2 then again, maybe there will be. 3 Literally. It gives strange error messages.
2 Next, type your data in just like you did in Excel. Some of you might try cutting and pasting. If you do that, there is a chance you will be totally okay. There is also a chance UCINET will, at some future point, reject your data and you’ll have to go back to the beginning and start over. Don’t ask why. Save your data to the DESKTOP with the little save button. Saving it to weird places like network drives or a logged in my documents MAY cause UCINET to reject your data and you will have to start over. 4 STEP 3: Create your NODE ATTRIBUTE data Where the network file you just created records the connections between nodes, the node attribute data file records things about the nodes in your network. For example, that John and Bob and male and Mary and Rachel are female. Open up Notepad in Windows (all applications-‐>accessories-‐>notepad) and type something like the following The first line MUST = node data The second line is your variable names, separated by a tab. The first one should be ID, the rest can be in any order After that, the first column should be your nodes names. If you want to use more than one word in a cell, you must put quotation marks around the whole thing. 5 4 Don’t ask why about this, either. Unless you use a Mac. Then we can commiserate about how awful it is we have to do UCINET on a Windows machine. 5 And frankly, UCINET might still reject it even if you douse quotation marks. I will resist the obvious comparison to 51% of the human race.