Homework #3: weblogs (due November 10th at 23.59)

1. Create a weblog in blogger.
2. The weblog should include at least 5 posts. The posts should at least show:

a. different type of fonts (show me you know how to use html without making the weblog too ugly).
b. a blockquote.
c. links (to other blogs).
d. at least 2 pictures (use flickr.com or picasa / hello to post pictures in blogger).

The weblog should also include:

a. comments implemented by a commenting system (haloscan).
b. at least 5 links to your favorite blogs.
c. a visit counter (www.miarroba.com)

3. Make your blog as "cute" as you can. You will get extra points if it looks fun and interesting. Think of this weblog not as homework but as the beginning of your blogging life.

Excel Exam

Here is an Excel spreadsheet that you can use as a starting point for your exam, so you don't have to type all those numbers. Check the Sheet 1 and 2.

Exercise 1:

Please create the spreadsheet as given here.

a- Product, value and quantity should be the values given in the tables.
b- Purchase = value * quantity
c- With discount 1 is applying a discount of 11% to the Purchase value.
d- With discount 2 is applying a discount of 33% to the Purchase value.
e- Note that both discount values (11 and 33) should be taken FROM THE spreadsheet, so that if when I grade I change those values manually, they should immediately reflect a change in the corresponding columns.
f- After you created the table and formatted it as shown, please create a pie chart that replicates the one I gave you.

Exercise 2:

Please create the spreadsheet as given here.

a- The values for rice, flour, sugar and milk for the months from January to June should be entered by you directly.
b- The total, average, median, min and max should be created by using FORMULAS.
c- Generate the bar chart showing the evolution of the four products through the months, in the format given.
d- Then generate a line chart that ONLY SHOWS two of the series (flour and rice) and format it as given.

Excel

As for practice for the exam: you should take the Excel homework as a sample of what the exam will be (this does NOT mean it will be the same). And check the list of topics. Then go to www.google.com and do a search on "Excel exercises", or "Excel practice" or "Excel exams" or "Excel tutorial" and use what you find that resembles what we saw in class. Examples of links I found:

http://web.utk.edu/~dhouston/excel/exercise.html: this one is really good.

http://math.about.com/od/excel/: these are great tutorials.

http://labs.pharmacology.ucla.edu/user_ed/excel/excel_exercises/: this is more formula heavy... but still useful.

Etcetera. Play with google, and if you find interesting exercise websites, mail them to me and Ill post them here for everyone to use.

Grades for Test #1

You should now have the grade for your test in your email inbox (make sure you check the account from which you SENT the test exam). A comment about this test:

Most people did well in the exam (the average was 80 out of 100). Actually, 75% of the class got a grade > 74. If you are in the low 25% you need to work REALLY hard. You still have 3 tests ahead of you, homework, etcetera, so you still can better your grade. But I can't promise the exams will be easier. Tests are my ONLY way to know you are doing your own work, so they can't be completely replaced by work you do at home, nor they should be. You are supposed to perform well in tests, since that is the way you will be evaluated in job interviews, SATs, etcetera.

Grades for Homework #1 sent

You should have an email with your grade already. Please, before sending email to me, verify the email address FROM WHERE YOU SUBMITTED YOUR homework assignment.

If you didn't get the email, let me know by sending me a message to christianatlincoln@gmail.com.

Soon: grades for Test #1.

Homework #2: Excel

Homework #2 (Excel), due October 22 at 0.01hs.

- For this homework you need to generate 2 Excel worksheets (you can send just one file that contains both worksheets).

- Each of the worksheets contain a table and a chart.

- I will provide you with a picture of what your result should look like. You can find them here:

- Part 1 (jpg), Part 2 (jpg), Part 1 and Part 2 (word).

- Please submit your homework as an email attachment to christianatlincoln@gmail.com.


Part 1:

1. Generate a table like this one (here you can download it as a word file, here as a jpeg picture).

2. Use the values given for the first 4 columns (Color, Model, Price and Qty).

3. The 5th column should be calculated as Price * Qty.

4. The 6th column should be calculated as the percentage of the Qty for that row as a percentage of the total of the quantity column.

5. Generate totals for the last 3 columns.

6. OF COURSE, for 3, 4 and 5 you need to use formulas, not just copy values (I will check this and you will get zero points if you just enter values).

7. Format the table (borders, bold, italics, numbers, etc) as given.

8. Generate a graph that looks like the one given (including Series labels, etc).

Part 2:

1. As you did in part 1, enter the values given in the example for rows Jan to Dec and for the four columns.

2. The "Total", "Max", "Average", "Median" and "Mode" row should be the... guess what? Total, max, average, median and mode value of the column. Of course, you need to use formulas!

3. Format the table as you see it in the example (including number formats).

4. Notice that the values in the table (only Jan to Dec rows) include CONDITIONAL formatting:

- Cells with values less than 15 should be displayed with font color red.
- Cells with values greater than 60 should be displayed with font color green.

5. Generate a chart like the one shown (including series labels, axis labels, etc)

IMPORTANT: Changes in dates for Word & Excel exams

The dates for the Word and Excel exams have been changed. Both exams will happen on Friday instead of Wednesday.

That is:

Word exam: Friday October 7
Excel exam: Friday October 14

If you cannot make it on any of these dates, you need to let me know IMMEDIATELY (christianatlincoln@gmail.com).

Keep in mind that the submission dates for the homeworks HAVEN'T changed, they are still due on Wednesdays.

Soon:

- I will update the syllabus with these small changes in dates.
- I will post the Excel homework (since the date when it is posted you will have at least 2 classes of workshops and 10 days to submit it).
- Any questions, doubts or inquiries, send email to christianatlinconl@gmail.com.