CM4Seyferts SDSS Globular Cluster CM Exercise - Revision history

Rutherford: /* An Exercise in Globular Cluster Distance Measurement */

2013-05-14T16:02:52Z

An Exercise in Globular Cluster Distance Measurement

Rutherford: /* An Exercise in Globular Cluster Distance Measurement */

2013-05-14T16:01:11Z

An Exercise in Globular Cluster Distance Measurement

Granucci: /* An Exercise in Globular Cluster Distance Measurement */

2013-05-14T02:34:18Z

An Exercise in Globular Cluster Distance Measurement

Rutherford at 16:23, 13 May 2013

2013-05-13T16:23:08Z

Rutherford: /* An Exercise in Globular Cluster Distance Measurement */

2013-05-13T16:21:12Z

An Exercise in Globular Cluster Distance Measurement

Rutherford: /* An Exercise in Globular Cluster Distance Measurement */

2013-05-13T16:06:38Z

An Exercise in Globular Cluster Distance Measurement

Tpaulsen: /* An Exercise in Globular Cluster Distance Measurement */

2013-05-07T22:47:55Z

An Exercise in Globular Cluster Distance Measurement

Tpaulsen: /* An Exercise in Globular Cluster Distance Measurement */

2013-05-07T22:47:24Z

An Exercise in Globular Cluster Distance Measurement

Tpaulsen: /* An Exercise in Globular Cluster Distance Measurement */

2013-05-07T22:40:34Z

An Exercise in Globular Cluster Distance Measurement

Blackwell: /* An Exercise in Globular Cluster Distance Measurement */

2013-04-24T20:27:29Z

An Exercise in Globular Cluster Distance Measurement

← Older revision		Revision as of 16:02, 14 May 2013
Line 1:		Line 1:


−	== An Exercise in Globular Cluster Distance Measurement ==	+	[[Media:]]== An Exercise in Globular Cluster Distance Measurement ==

	Attached here is an Excel file with data from two clusters. This is not what I give the kids. I give them LESS data than what is here. I make them take the raw data and knowledge of the distance to NGC 6791 to calculate the stars' absolute values for that cluster. That then becomes the "standard HR Diagram" for stars which they can use to compare to the more distance PAL5 (Palomar 5) cluster for which only apparent magnitude information is given. All this data was pulled from the SDSS using their radial search tools. In this particular file, there is a plot with NGC6791 already on it using its absolute G magnitude. Also plotted is the raw PAL5 apparent G magnitude....and a shifted PAL5. There is a cell labelled "SHIFT" which is the delta-magnitude used for the relationship: m-M = shift = -5+5LOG(D). By entering a shift value, the PAL5 cluster plot is moved up or down relative to the known NGC6791 data. A box labeled "Distance" is then automatically updated to show the distance to PAL5 in parsecs. If anything this is a great way to learn Excel.... and a good way to get into discussions about distance measurements using the HR Diagram, CM diagrams as a whole, and even interstellar reddening if you want. Enjoy!		Attached here is an Excel file with data from two clusters. This is not what I give the kids. I give them LESS data than what is here. I make them take the raw data and knowledge of the distance to NGC 6791 to calculate the stars' absolute values for that cluster. That then becomes the "standard HR Diagram" for stars which they can use to compare to the more distance PAL5 (Palomar 5) cluster for which only apparent magnitude information is given. All this data was pulled from the SDSS using their radial search tools. In this particular file, there is a plot with NGC6791 already on it using its absolute G magnitude. Also plotted is the raw PAL5 apparent G magnitude....and a shifted PAL5. There is a cell labelled "SHIFT" which is the delta-magnitude used for the relationship: m-M = shift = -5+5LOG(D). By entering a shift value, the PAL5 cluster plot is moved up or down relative to the known NGC6791 data. A box labeled "Distance" is then automatically updated to show the distance to PAL5 in parsecs. If anything this is a great way to learn Excel.... and a good way to get into discussions about distance measurements using the HR Diagram, CM diagrams as a whole, and even interstellar reddening if you want. Enjoy!

@@ Line 14: / Line 14: @@
 Tom here:  Here are my H-R Diagrams as displayed in "Logger Pro."  I have pasted them into a WORD document.  Its easy to see the turn-off for Palomar 5, by the one for Palomar 3 is not nearly as pronounced.
 <br> [[Media:Palomar 5 and Palomar 3.docx]]
 <br> Nicole here: These are my H-R Diagrams.
 [[Media:Granucci Palomar HR Diagram 2013.xlsx]]

← Older revision		Revision as of 02:34, 14 May 2013
Line 14:		Line 14:
	Tom here: Here are my H-R Diagrams as displayed in "Logger Pro." I have pasted them into a WORD document. Its easy to see the turn-off for Palomar 5, by the one for Palomar 3 is not nearly as pronounced.		Tom here: Here are my H-R Diagrams as displayed in "Logger Pro." I have pasted them into a WORD document. Its easy to see the turn-off for Palomar 5, by the one for Palomar 3 is not nearly as pronounced.
	<br> [[Media:Palomar 5 and Palomar 3.docx]]		<br> [[Media:Palomar 5 and Palomar 3.docx]]
		+
		+	<br> Nicole here: These are my H-R Diagrams.
		+	[[Media:Granucci Palomar HR Diagram 2013.xlsx]]

@@ Line 12: / Line 12: @@
 <br> [[Media:GlobularClusterHRDiagrams.docx]]
-Tom here:  Here are my H-R Diagrams as displayed in "Logger Pro."  I have pasted them into a WORD document.
+Tom here:  Here are my H-R Diagrams as displayed in "Logger Pro."  I have pasted them into a WORD document.  Its easy to see the turn-off for Palomar 5, by the one for Palomar 3 is not nearly as pronounced.
 <br> [[Media:Palomar 5 and Palomar 3.docx]]

@@ Line 12: / Line 12: @@
 <br> [[Media:GlobularClusterHRDiagrams.docx]]
-Tom here:  Here are my H-R Diagrams as displayed in "Logger Pro."
+Tom here:  Here are my H-R Diagrams as displayed in "Logger Pro."  I have pasted them into a WORD document.
-<br> [[Media:Palomar 5 and Palomar 3]]
+<br> [[Media:Palomar 5 and Palomar 3.docx]]

← Older revision		Revision as of 16:06, 13 May 2013
Line 11:		Line 11:
	This is what I got:		This is what I got:
	<br> [[Media:GlobularClusterHRDiagrams.docx]]		<br> [[Media:GlobularClusterHRDiagrams.docx]]
		+
		+	Tom here: Here are my H-R Diagrams as displayed in "Logger Pro."
		+	<br> [[Media:Palomar 5 and Palomar 3]]

@@ Line 7: / Line 7: @@
 <br> [[Media:PAL5_and_ngc6791.xlsx]]
-I simply asked my students to to the activity described the link John sent:  http://skyserver.sdss3.org/public/en/proj/advanced/hr/globularcluster.asp
+Theresa here:  I simply asked my students to to the activity described the link John sent:  http://skyserver.sdss3.org/public/en/proj/advanced/hr/globularcluster.asp
 The kids selected the stars, downloaded the data and made graphs with excel.  They then copied and pasted their graphs to a google doc and shared them with me.
 This is what I got:
 <br> [[Media:GlobularClusterHRDiagrams.docx]]

← Older revision		Revision as of 22:40, 7 May 2013
Line 6:		Line 6:

	<br> [[Media:PAL5_and_ngc6791.xlsx]]		<br> [[Media:PAL5_and_ngc6791.xlsx]]
		+
		+	I simply asked my students to to the activity described the link John sent: http://skyserver.sdss3.org/public/en/proj/advanced/hr/globularcluster.asp
		+	The kids selected the stars, downloaded the data and made graphs with excel. They then copied and pasted their graphs to a google doc and shared them with me.
		+	This is what I got:
		+	<br> [[Media:GlobularClusterHRDiagrams.doc]]

← Older revision		Revision as of 20:27, 24 April 2013
Line 5:		Line 5:
	Attached here is an Excel file with data from two clusters. This is not what I give the kids. I give them LESS data than what is here. I make them take the raw data and knowledge of the distance to NGC 6791 to calculate the stars' absolute values for that cluster. That then becomes the "standard HR Diagram" for stars which they can use to compare to the more distance PAL5 (Palomar 5) cluster for which only apparent magnitude information is given. All this data was pulled from the SDSS using their radial search tools. In this particular file, there is a plot with NGC6791 already on it using its absolute G magnitude. Also plotted is the raw PAL5 apparent G magnitude....and a shifted PAL5. There is a cell labelled "SHIFT" which is the delta-magnitude used for the relationship: m-M = shift = -5+5LOG(D). By entering a shift value, the PAL5 cluster plot is moved up or down relative to the known NGC6791 data. A box labeled "Distance" is then automatically updated to show the distance to PAL5 in parsecs. If anything this is a great way to learn Excel.... and a good way to get into discussions about distance measurements using the HR Diagram, CM diagrams as a whole, and even interstellar reddening if you want. Enjoy!		Attached here is an Excel file with data from two clusters. This is not what I give the kids. I give them LESS data than what is here. I make them take the raw data and knowledge of the distance to NGC 6791 to calculate the stars' absolute values for that cluster. That then becomes the "standard HR Diagram" for stars which they can use to compare to the more distance PAL5 (Palomar 5) cluster for which only apparent magnitude information is given. All this data was pulled from the SDSS using their radial search tools. In this particular file, there is a plot with NGC6791 already on it using its absolute G magnitude. Also plotted is the raw PAL5 apparent G magnitude....and a shifted PAL5. There is a cell labelled "SHIFT" which is the delta-magnitude used for the relationship: m-M = shift = -5+5LOG(D). By entering a shift value, the PAL5 cluster plot is moved up or down relative to the known NGC6791 data. A box labeled "Distance" is then automatically updated to show the distance to PAL5 in parsecs. If anything this is a great way to learn Excel.... and a good way to get into discussions about distance measurements using the HR Diagram, CM diagrams as a whole, and even interstellar reddening if you want. Enjoy!

−	<br> [[Media:PAL5_and_ngc6791.xlsx]	+	<br> [[Media:PAL5_and_ngc6791.xlsx]]