Spreadsheet+and+Graphs

=Smoking Commericals=

media type="youtube" key="zYHx5BZf23I" height="344" width="425" align="center"

How does this commerical encourage cigarette smoking? Is this type of advertising ethical or unethical? Discuss

How to compile your survey results
1. Open Microsoft excel and save the document on your H drive. 2. Open the example spread sheet 'How to create a graph' which is saved on the resource drive under Stage 1/ Contemporary Issues and Science folder.You can use as a guild. 3. For each question set up your responses in a table form. To do this you will have to tally up all your responses. E.g. Question- Have you ever tried a cigarette? 5. Compile you results in either pie graph or column graph format.
 * Yes || No ||
 * 50 || 40 ||
 * Highlight the responses to your question. Make sure you highlight the headings as well.
 * Click on the **Insert** drop down list and select **chart** from the list. The chart wizard should pop up.
 * Select either column, bar or pie graph and press next.
 * Ensure that the correct data range has been selected and press next.
 * Ensure that the table appears correctly. Click next.
 * Under Chart Title write your question. (if there is space) If you are doing a column graph you may label the axis, eg Y- number of people. Click next
 * Insert the chart as a new sheet. This will make it appear on your next tab. Select finish

6. Name you tabs in you worksheet by right clicking over the sheet name. Eg Sheet 1, and selecting **rename**, type in your new name. Name the first page will tables the response survey results, and the next one graph1 etc.