Monday, February 7, 2011

One Week of Digital Media



Pie Chart of My Media

First things first, we are considering your media consumption for one week so here is the breakdown:
If you are measuring in minutes: there are 10,080 minutes in a week, so your time total should add up to this.  Keep in mind that we MUST account for the time you do not use media in this total because that is part of your week, too!

If you are measuring in hours: there are 168 hours in a week, so your time total should add up to this.  Keep in mind that we MUST account for the time you do not use media in this total because that is part of your week, too!

For now let's stick to those units of measurement as that is what came out of your worksheets, now for the assignment.


Student Assignment:
1. Open Excel and Save the Project as “FirstName_LastInitial_MyMediaUse” YOU MUST SAVE IT AS MICROSOFT OFFICE EXCEL WORKBOOK.
2. In A1 Type “Digital Media”
3. In B1 Type “Time”
4. A1 and B1 Should Be Bold
5. Column A Should list what you used for digital media
6. Column B should list what time you spent on each media in Hours (.5 for Half Hour) DO NOT PUT LETTER VAULES = ONLY NUMBERS.
7. Highlight the Cells you want represented within a chart.
8. Insert a Pie Chart
9.  - - - - Step 3 - Title Tab =  Digital Media Use and Data Labels Tab = Category Name and Percentages
10. Do a screen capture, edit the spreadsheet to reveal the cells and chart. Save the screen shot as “FirstName_LastInitial_MyMediaChart” as a JPG.
11. Submit the screen shot JPG via LoopMail.

Notice: Do not submit the file as formatted for .xls or .bmp

No comments:

Post a Comment