Black Friday assignment

November 23, 2010 at 1:12 pm | Posted in tech | Leave a comment

Black Friday!!

You will use Excel to track the money you can save on Black Friday.   You will also locate each store in Google maps and link to them to better plan your route for the day.

Skills:
-creating column headings
-formatting text
-wrapping text

1. Open Excel and start a new worksheet.

2. Create column headings called “store name”, “product name”, “sale price”, “retail price”, “money saved”, “store opens”, “store location”. Don’t include the quotes.  Wrap text for each column heading and bold the column headings.

3. Use the following resources to find Black Friday deals.
http://www.fatwallet.com/black-friday/
http://bfads.net/

or just Google “Black Friday (store name OR product name)

4. Find at least five products from from five different stores.  Fill in each column for each item.  Use a formula to calculate “money saved”.

5. For the map link, use Google maps to locate the store.  Type “click here for map” and link to the Google Map.  Like this: click here for map.

6. Total up the following: sale price, retail price, money saved using formulas.

7. Average the same amounts using formulas.

8. Create a chart that best compares the sale price and retail price for each product.  Put them on all on one chart on a separate sheet.

9. Print out the following in landscape format – customize as you wish:
-your worksheet with data
-your worksheet showing formulas
-your chart

Advertisements

Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Entries and comments feeds.

%d bloggers like this: