move it just enough to avoid overlapping and lines. Select the Vertical Axis. Right click and select Format Axis. Click the Number Tab and adjust the Decimal Places to zero. Click Close. 17. Print Animal Science Chart Worksheet. Click cell A1 on the Animal Science Chart Worksheet. Click File, Print. Change the Orientation to Landscape. Change Scaling to Fit Sheet on One Page. Click on Page Setup and select the Header/Footer Tab. Click Custom Header… In the Left Section type your name, in the Center Section type your class section. Click on the Right Section then click the Date button. Make sure the print area is set to Print Active Sheets. 18. Submit an electronic copy of your file. Place your file in the correct folder for grading. TOTAL SCORE Job Operation Sheet Class: Agriscience Plant Science Area: Agriscience- Data Analysis Job: Understanding Data Analysis in Excel Name: _____________________________________ Date: ____________________ Step Procedures Key Points Assessment 1. Open file and Save As. Open Excel file “Class Experiment Graphing Workbook.” Click Save As and name the file Last Name- Graphing Activity. Be sure to Save As and insert your last name. 2. Find the Worksheet for your class (Animal or Plant Science). Add a title in row 1. Select your class worksheet you were assigned at the bottom of the screen. Select cells A1:K1. Click Merge and Center on the Home Tab. Click on the new cell and type “Class Experiment Data.” 3. Count the total number of participants in cell A20. Select cell A20. Type =COUNT( Click and drag to select cells A5:A16. You can click on A16 and drag up to A5. After releasing the mouse from your click
Axis. Press Equals and select cell A5. Click on the Axis Titles button. Select Primary Vertical Axis- Rotated Title. Press Equals and select cell E4. Click on Data Labels and select Outside End. 16. Resize Chart, adjust Data Labels and format Vertical Axis. Select the chart. Click the Format Tab in the Chart Tools Tab. Adjust the size to Height: 5” and Width: 7”. Click on each Data Label and move it just enough to avoid overlapping and lines. Select the Vertical Axis. Right click and select Format Axis. Click the Number Tab and adjust the Decimal Places to zero. Click Close. Make sure there is a box around the axis values. 17. Print Animal Science Chart Worksheet. Click cell A1 on the Animal Science Chart Worksheet. Click File, Print. Change the Orientation to Landscape. Change Scaling to Fit Sheet on One Page. Click on Page Setup and select the Header/Footer Tab. Click Custom Header… In the Left Section type your name, in the Center Section type your class section. Click on the Right Section then click the Date button. Press Print. Make sure the print area is set to Print Active Sheets. 18. Submit an electronic copy of your file. Place your file in the correct folder for grading. TOTAL SCORE Job Operation Sheet Class: Agriscience Area: Agriscience- Data Analysis Job: Creating a Data Table in Word Name: _____________________________________ Date: ____________________ Step Procedures Key Points Assessment 1. Open New Blank Document file and Open Excel file “Class Experiment Graphing Be sure to Save As and insert your last name.
Layout Tab. With the row still highlighted click the Align Top Center Tab. Click on the new cell and type “Effect of Light on Growth of Corn Plants.” 10. Format title font size and style. Select the 1st row and under the Home Tab and press the Bold button. Then press the Grow Font button once. Font should be12pt now in title row only. 11. Format row height. Select the all of row 3-8. With the cells still highlighted, click on the Table Tools Tab click on the Layout Tab and type 1.3” in the width box. 12. Insert a Header Click on the Insert Tab. Press the Header drop down menu. Click on Edit Header. Type your name. Press tab and type your class name. Press tab an type the date. 13. Print Creating a Table Word Document. Click File, Print. Check the page Orientation is set to Landscape. Click the Print Button. Be sure only one page is being printed. If there is more than one page listed, there is a formatting problem. 14. Submit an electronic copy of your file. Place your file in the correct folder for grading. TOTAL SCORE Effect of Light on Growth of Corn Plants Date Growth in Direct Sunlight (cm) Growth in Partial Sunlight (cm) Growth in Full Shade (cm) Observations 2/4 2/11 2/18 2/25
Components of a Graph: Meaningful Graph Title Category Labels on the Horizontal Axis Legend Vertical Axis Label Horizontal Axis Label Data Labels Components of a Table: Meaningful Table Title Row Titles Column Titles Units Components of a Graph: Meaningful Graph Title Category Labels on the Horizontal Axis Legend Vertical Axis Label Horizontal Axis Label Data Labels Components of a Table: Meaningful Table Title Row Titles Column Title Units