How to create a network of two groups of students with some overlap

Sep 28 at 2:17 AM
Hi, this is a simple question, I think.

I hope someone can help. Otherwise feel free to point me to another forum or resources for SNA - I can't find something appropriate.

I am a lecturer and I want to demonstrate a very simple network to my students, to show how some of them did a previous class with me, and some didn't. e.g. 100 did a class on methods last year, and a certain numberof them are now in the social media class this year. Others did not do the methods class with me.

So there are three groups of students: methods class only; social media class only; methods and social media class. There is also me who is connected to everyone.

I thought that this should be simple to do. I have a list of student IDs with their respective classes.

I can't work out how to input the data properly into an Excel sheet.

I suppose there is some simple way to do this that I don't know of.

Is anyone able to advise me and/or point me to somewhere where I can learn from?
Many thanks,
Julian
Coordinator
Sep 28 at 4:42 AM
Hello!

Please have a look at the NodeXL social network map at: https://nodexlgraphgallery.org/Pages/Graph.aspx?graphID=78198

Image

The edge list that created this network is:

Student 1, Class 1
Student 2, Class 1
Student 3, Class 1
Student 4, Class 1
Student 5, Class 1
Student 6, Class 1
Student 7, Class 1
Student 8, Class 1
Student 9, Class 1
Student 10, Class 1
Student 11, Class 2
Student 12 , Class 2
Student 13 , Class 2
Student 14 , Class 2
Student 15 , Class 2
Student 16 , Class 2
Student 17 , Class 2
Student 18 , Class 2
Student 19 , Class 2
Student 20 , Class 2
Student 21, Class 3
Student 22, Class 3
Student 23, Class 3
Student 24, Class 3
Student 25, Class 3
Student 26, Class 3
Student 27, Class 3
Student 28, Class 3
Student 29, Class 3
Student 30, Class 3
Student 1, Class 2
Student 2, Class 2
Student 11, Class 3
Student 12, Class 3
Marked as answer by MarcSmith on 9/27/2016 at 8:43 PM