AstronomyTeacher

News articles and posts about astronomy and astronomy education

Wednesday, March 02, 2005

 

Work on lab; get data files set

Our agenda for today (I will be out for part of the day):

1. Do as much on the lab as you can without me. If you get the data typed into Excel, you're on schedule.
2. Add a column at the end, labeled "R", which computes the distance between Saturn and Titan as follows:
=SQRT((G2-I2)^2+(H2-J2)^2)

This assumes column G and H are x values, and I and J are Y values.

3. Add a new column at the end, labeled "TIME," which computes the decimal time as follows:
=MONTH(A2)+DAY(B2)+YEAR(C2)+HOUR(D2)+MINUTE(E2)+SECOND(F2)

Make sure that column A is the month, B the day, and C the year. Edit appropriately.

4. Fill these last columns down so that all 19 calculations are done.

5. Put your name in the spreadsheet, save on the server, and go on to the next thing. Don't print it; it isn't finished yet.

6. Do the "telescopes" puzzle I leave with the sub. The puzzle is due at the end of the class, so leave it with the sub.

7. On Monday we'll continue with the lab. If you finish everything else, begin preparing notes for the test. The test will not be until the end of next week, but you will be allowed to use one page of notes (1 page, 8x10 inches, double sided).

The sub gets to decide if you have to turn in #7.

Comments: Post a Comment



<< Home

Archives

08/01/2004 - 09/01/2004   10/01/2004 - 11/01/2004   11/01/2004 - 12/01/2004   12/01/2004 - 01/01/2005   01/01/2005 - 02/01/2005   02/01/2005 - 03/01/2005   03/01/2005 - 04/01/2005   04/01/2005 - 05/01/2005   05/01/2005 - 06/01/2005   06/01/2005 - 07/01/2005   07/01/2005 - 08/01/2005   08/01/2005 - 09/01/2005   09/01/2005 - 10/01/2005   10/01/2005 - 11/01/2005   11/01/2005 - 12/01/2005   12/01/2005 - 01/01/2006   01/01/2006 - 02/01/2006   02/01/2006 - 03/01/2006   03/01/2006 - 04/01/2006   04/01/2006 - 05/01/2006   05/01/2006 - 06/01/2006   06/01/2006 - 07/01/2006   07/01/2006 - 08/01/2006   08/01/2006 - 09/01/2006   09/01/2006 - 10/01/2006   10/01/2006 - 11/01/2006   11/01/2006 - 12/01/2006   12/01/2006 - 01/01/2007   01/01/2007 - 02/01/2007   02/01/2007 - 03/01/2007   03/01/2007 - 04/01/2007   04/01/2007 - 05/01/2007   05/01/2007 - 06/01/2007   06/01/2007 - 07/01/2007   07/01/2007 - 08/01/2007   08/01/2007 - 09/01/2007   11/01/2007 - 12/01/2007   12/01/2007 - 01/01/2008   01/01/2008 - 02/01/2008   02/01/2008 - 03/01/2008  

This page is powered by Blogger. Isn't yours?