Excel+Assignment+4,+Week+6

This page is for the exercise called ServerLogs.xls. This exercise requires you to total the bandwidth used by date. Next, use those totals to create a Line Graph. Office 2010 works differently than the version I used in the Monday class. Select the data, create the graph, right click and select Move to New Sheet; name the Sheet total bandwidth. When you move to the new sheet, the chart editing options will be in the ribbon. From there, you can update the data selections, using the Ribbon choices. The data range will be the totals.

Does anyone know if we can get help from the GA's tomorrow after class? or are they only available on Friday and if only friday's do you know at what time? (Melina Montes)

I'll be in the lab from about 9:30-noon. The GA will be there then until 2.

Hey this is Jerrel checking in. If you need some last minute help on either excel assignment you can drop me a line. (Jerrel Vinson)

Have good weekends guys!

Jaegyun checking in. (Jaegyun Choi)

Minji checking in. (Minji Kim)

Martin checking in. (Martin Crawford)

Tony Henry just checking in (Tony Henry)

Just finished my Excel assignments. Feel free to ask if there's a question. (Jacqueline Park)

Does anyone know how to create the 3rd sheet with the many line graphs? The average bandwith used in each two-hour period? (Alexander Hardt)

First create the average bandwidth in a new column to the right of your last column on the worksheet. Should be column "H". Then insert an "average" formula for each row or time-period. Define that range for the data in your line graph. That should give you the graph. You'll then need to define the x-axis with the time-period range (s/b "a3..a7") Karen Clary

Ok so I'm trying to create the second line graph and for some reason I thought it had more than one line, or am I correct it only has one please help lol ( megan powalish)

Never mind I figured it out I was putting in th wrong data!

Did pretty good for the assignments this week! Finding out all this stuff about Excel is really helpful! (Kristie Card)

Did the Excel assignments, and I believe I got everything correct. I Really Like doing this kind of stuff. It is really cool learning about all the different ways you can use this program for. I love it. (Jeremy Bell)

I have completed both Excel assignment! Feel free to ask me any questions. (Vanessa Lyons)

Picture of your output : NOTE: your charts should be on separate worksheets.

I love getting days to complete my assignments in class! (Austin Brown)

I love this Excel projects they are so much fun!!! If anyone needs help feel free to ask me any question. I have completed both Excel assignment already. - Javier

Being able to be in class and work with a classmate, makes working on the application excercise easier! ( Carlos R Padilla)

Glad I checked the answer key again. I keep finding mistakes! (Jessica Chumley)

I'm so glad to check my assignment with classmates through wiki and lab. Before using this, it was sometimes so confusing that I'm right. It is so helpful:D (Youngin Lee)

I just finished this assignment. assignment this week was very difficult. also, the Mac make very difficult to Excel. because, many features are hidden t.t - Jimmy (Jinseok Yang)

I also just finished this assignment. It was hard than usual. Thank you for poviding answer key :D ( Chinwoo Lee)

Dear, professor. Due to macbook excel, I had to change date of Bandwidth Used by myself. When I opened the file September was auto-translated into Korean. (JJ Lee)

Blanca just checking in (: (Blanca Mireles)

This is Coby using the wiki. (Coby)

Jovana checking in (Jovana Cruz)

I finished my Excel assignments and uploaded it :) (Keunhwan Kim)

I have finished my Excel assignment if someone want to ask me about it. Ask me :) (Dabeen Kim/David B Kim)

I'm sooooo interested in this week 6 homework!:) (YeonSoo Lee)

DaeGeun checking in (DaeGeun Hyun)

Shiloh using the wiki! Have a wonderful weekend! (Shiloh)

Seungwoo Chun checking in (Seungwoo Chun)