Pst101.expressions.syr.edu



PAF 101 Tutorial for the Graphs in Module 4If you find yourself struggling with the Graphs for Module 3, here are some easy steps for the graph on 5.3. These instructions were constructed on Microsoft 2013, so that it could be used by more students. If you have an older version of Microsoft Office such as 2007 or 2003, or if you have 2016 and are confused, please email your TA or Steven Winschel, Excel Director, at swinsche@syr.edu*This contains the same information as the video on the PAF 101 websiteCreate a Table resembling the following:Likeliness of Steven Falling Asleep in Class?Year 1Year 2Year 3Year 4Year 5Year 6Year 7Historical10%20%30%40%Baseline40%50%60%70%Benchmark35%30%20%Insert Graph, “Line with Markers”:Your graph should appear to look something like the following: 4705350000Using the “Add Chart Element” dropdown insert the following: Primary Horizontal Axis Title, Primary Vertical Axis Title, and Data Labels Above the points. Also, unselect Primary Major Horizontal Gridlines from the dropdown list under “Gridlines.”Your Graph should now appear something like the following:4724400635000Double-click on your graph and enter into the “Format Chart Area”Remove the Border by clicking on the “BORDER” dropdown and selecting “No line”Select the Chart Area that encompasses your Time Intervals by clicking on it, i.e. where this graph has Year 1, Year 2, etc.Select the “Line” dropdown, click on “Solid line” and change the color to “Black”right000Proceed to click on the Bar Graph Icon, then enter into the “TICK MARKS” dropdown and change “Major type” to “Outside”While still having the box selected, change the font to Times New Roman size 12 font and change the Font Color to BlackRename the Horizontal Axis Title with the corresponding Time Period heading, such as: Years, School Years, or Academic Years. Change the font to Times New Roman size 12 font, change the Font Color to Black, and make the text BOLDReturn to step 12 and redo the steps for the Chart Area that encompasses your Percentage variable. Acceptable titles will vary based on the variable that is being studied, but one of the key words, “Percentage” or “Rate,” should be in the label title, but not both. While in the same menu as at the top of the page, also select the “NUMBER” drop down, change the category to “Percentage” if it is not already and change the Decimal Places to 0.Your graph should look something like the following: right1397000Select one of line segments (This should cause all of the data points of that line to be selected) and enter into the “Format Data Series” boxUnder “Line” select the “Line” dropdown and change the line to “Solid line” then change the color to Blackright952500Switch over to the “Marker” side and select the “Fill” dropdown. Change the fill to “Solid fill” and change the color to Black. Also, select the “Broder” dropdown, switch that to “Solid line” and change the color to BlackReturn to step 19 and complete the steps for the remaining line segments. For the corresponding line to your baseline data, under the “Line” tab, select “Dash type” and change to “Square Dot” and for the corresponding line to you forecasted data, change to “Dash”Your graph should appear to look something like the following: 43910255397500Select the middle data label textbox that, in this case, contains the “40%” by itself. This can be done by clicking on it twice. This box is a duplicate, so select it and press the “DEL” key on your computer. When you delete it, it should appear as though nothing happened but the box should no longer be selected.Click on one set of the data label textboxes, go to the Bar Graph looking tab in the “Format Data Labels” box, and enter into the “Number” dropdown. Change the category to “Percentage” and then adjust the Decimal places to “1.” Change the font to Times New Roman size 10 font and change the Font Color to Black. Redo this step for the remaining sets of Data Labelsright825500Your graph should appear something similar to the following:Select the Legend text box, change the font to Times New Roman size 12 font and change the Font Color to BlackStop and make sure that your forecasted and estimated years are labeled with either an “f” for forecasting or an “e” for estimated if that applies. If you forgot, simply alter the dates in the data table that your graph is being constructed from and Excel will automatically fix it for you.Change the Graph Title to something along the lines of “Historical and Forecast Graph for…” or “Historical, Baseline, and Benchmark Graph for…” depending on what graph you are doing. Look at the Maxwell Manual for additional help with naming. Make sure to include the societal variable, the geographic location, and the timeframe. Change the font to Times New Roman size 12 font, change the Font Color to Black, and make it BOLDYour graph should appear something like the following: (Feel free to adjust the height and width of the graph for visibility purposes)42005251397000Copy and paste the graph from Excel into your Module, we suggest pasting it as an image for resizing purposes in word. This can be done by selecting the “Picture” paste option:Below the graph specify the source: Source: New York State Department of Sleep Habits ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download