Sp2003 Questions on Labs


	Welcome to CS1315. Click on the python to add comments.

This page removed for FERPA compliance

Sp2003 Questions on Labs

Please identify the lab that you're asking about:

On lab 1, what email address do we send part 1 to?

cs1315@cc.gatech.edu - Jim Gruen

Lab 2
I have the "Eliot-hello.wav" saved on my comp, and i could rewrite the recipe so it works, but if I'm following the directions, I don't think I'm supposed to do that. This is the error I get when I leave it unchanged

>>> A syntax error is contained in the code – I can't read it as Python.
The error is on line 8

Am I supposed to rewrite the recipe?

Definitely! You're supposed to re-write the recipe so that it DOES work on your computer! Mark Guzdial

I tried to copy the mediasources folder into the Jes folder but it didn't work. So in the code I just wrote '..\mediasources\Elliot-hello.wav'. Is that okay, it does work. I don't know how to fix what I did.

I know that the r is supposed to go before the string, but for some reason it won't work. Where exactly does the r go and does it need anything else? Thanks

It goes right before, e.g., file = r"c:\\fred\mabel" Mark Guzdial

It keeps telling me that line 19 of the recipe is having an error passing an arguement into a function. Line 19 is just #Question 2: so I don't know what I am supposed to change.

Lab3:

On Problem 6, when I copy the formulas into the cells it doesn't change the G value (ex: (G?-$H$2)^2) either way I do it. Is there another way to copy and paste so it does change it?

Hmmm...That sounds strange. Do you copy 'n paste one cell at a time, or do you select a bunch of cells to paste into at one time? I would suggest meeting up with a TA and trying it out with them.

Are we allowed to use Excel XP for lab 3.

Yes, you can use Excel XP. Mark Guzdial

After I created the first chart that we are supposed to delete a lot of my values changed like my calculated variance and other things was this supposed to happen.

I don't think this should happen. Does the calculated variance formula change, or just the answer? Can you get back your original variance answer by tweaking your spreadsheet? It's a bit hard to guess what's going on without seeing your spreadsheet, so it would probably help if you could reproduce this problem with a TA.

When I sorted car weights to make my graphs, my average, variance, and standard deviation values were moved, changed, or disappeared from my spreadsheet. They are correct in my JES file. Do I need to do anything to fix this?

When you resort by a value, you can choose which parts of the spreadsheet are also resorted. The cells holding the calculations you have added should not be included in the resorting. And yes, your spreadsheet should include the correct avg, variance, etc. because we want to check your spreadsheet to make sure you did everything correctly.

Lab 3
When I did problem 10, I used formula you gave us for the first cell. But then in the other cells, I figured it needed to be altered the way the COUNTIF formula in problem 8 had been so that it would do between two values (greater than one and less than one-so you subtracted one from the other). ie. my formula looked like this: =(SUMIF(C3:C328, "29",G3:G328)-SUMIF(C2:C328, "20",G2:G328)/COUNTIF(C3:C328,"29")-COUNTIF(C3:C328,"20")). But when I used this formula I got an extremely large number for the second cell (and third and fouth when I used it there and just changed the numbers). Can you help me figure out what is wrong with my formula? Or if I should be getting these really big numbers?

You may want to try adding an extra set of parentheses around you SUMIF and COUNTIF subtractions so that it looks like the following:
=((SUMIF(C3:C328, "<29",G3:G328)-SUMIF(C2:C328, "<20",G2:G328))/(COUNTIF(C3:C328,"<29")-COUNTIF(C3:C328,"<20")))

The way you currently have it written, Excel may be interpreting it as follows (parentheses added for emphasis):
=SUMIF(C3:C328, "<29",G3:G328)-(SUMIF(C2:C328, "<20",G2:G328)/COUNTIF(C3:C328,"<29"))-COUNTIF(C3:C328,"20"))

I'm stuck on problem 10 as well. I don't know the right formula for cells 2-4, even though i understand the concept.

I figured out that for problem 10 you need to put parenthesis around each part so it would look like: =((SUMIF(C2:C328,"29",G2:G328)-SUMIF(C2:C328,"19",G2:G328))/(COUNTIF(C2:C328,"29")-COUNTIF(C2:C328,"19"))). I did the same thing you guys did and then I added the parenthesis and it gave me reasonalbe numbers.

Lab 3
I can't seem to find the fx option on the toolbar. Can someone help me out? Thanks.

It's right next to the white bar at the top where you can type.

I do not have SQRT formula in my statistical functions. What should I do?

Look under Math & Trig. Or just type it in as =SQRT(number).

I keep getting a -152 when I do the COUNTIF formula for 5500. What is the matter?

It's hard to know without seeing the formula you wrote. Send an email to your TA with the formula - Jose

For Problem #8, I know that the formulas I am doing is right, but, they are giving me the wrong numbers. I just went over and counted how many there were and I got different numbers for 4000 and 5500. Am I doing something wrong?

Probably. Make sure that you've got your parentheses right as well as the ranges. "less than 4000" is not the same as "less than 4001 if you know what I mean - Jose

How come when i sort my data for #11 it takes all my numbers that I have done and scatters them? is this a problem?

i am sorry about the last question, I did not see that someone had already asked. I will restate it, how do I sort without changing my numbers? I tried highlighting only certain ones but soon found that that does not work. Any suggestions?

I just wrote down the 4 functions under Average and Std Dev. Columns and then did them again after I sorted. They still get the same values because the values in the columns haven't changed. It means redoing those 4 cells, but it's the only thing that seems to work.

"So now we need to calculate the difference between each group's average and its minimum and maximum weight values. Create two new columns and calculate these difference values" what does it mean??

should we have a negative number for the last difference of the avg-min?

Can all of our columns be to 2 decimal places, or just the MPG one?

Just the MPG is enough. But there is no harm done for those columns for which it makes sense to have 2 decimal places. (ex. dates with decimal places?) - Jose

LAB4- Can I use Powerpoint from Office XP

Can REMOVED than one slide have a transition, animation, etc?

REMOVEDre! (To both Lab4 questions.) Mark Guzdial

Does the literary content of our power point presentations make any difference? I mean, we wont be graded on the content as long as we show mastery of the manipulations within PP....correct?
Student86

Yup, as you say, Justin. Mark Guzdial

what does "use the drawing toolbar to draw a chart of your data" mean exactly?

LAB5

I'm using my prism account to make this webREMOVED You want me to just create a link in my who's who page to it?

REMOVEDre. Mark Guzdial

I can't get my Name and gt# to center at the top of the REMOVED I used center and /center, but it is not working

Try a different browser? I don't know what the problem could be. Mark Guzdial

I fixed the centering problem...now I am having trouble getting the background color to work. I have tried using both bgcolor=#FFFFCC and bgcolor=yellow.

I put a lock on my webpage, but it is saying that my password is incorrect, to contact the system administrator. How do I do this??

Send email to me or to swiki-bugs@cc.gatech.edu with the name of the page or the URL of the page that you need unlocked. Mark Guzdial

I put the logo of where I work on my REMOVED I work at Starbucks. I got the image by going to their website and then saving a picture off of that. Is that legal, or do I need to remove it? (I made sure to put the disclaimer from the "Georgia Institute of Technology Computer and Network Usage Policy" website on the bottom of my page). Lauren Biddle

I'm not a lawyer, so I couldn't tell you. I don't think it is. However, if you just REFERENCE the picture (use their URL for the image), I think you're on better ground. Mark Guzdial

when i click attach to try and upload my picture, it asks for a network user name and password. i dont know those . . . (and i live on campus)

Same problem as above, I wish I could attach my files, but I don't know a username or password.

I STILL can't attach any files. I would be FINISHED if I could. Any help would be greatly appreciated.

username is attach, password is carmen. for some reason it checks that even on campus (resnet) sometimes.

Coweb keeps overriding my title html code with the little box above the input place, how do i preven this?

I want to right align something. Is it okay for me to open up dreamweaver, see how it's done there, and then emulate it in my own code?