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 Click cell A1 on the Animal Make sure the print area Science Chart Science Chart Worksheet. is set to Print Active Worksheet. Click File, Print. Sheets. 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. 18. Submit an Place your file in the correct electronic copy of folder for grading. your file. TOTAL SCORE Job Operation Sheet Name: Class: Agriscience Plant Science _____________________________________ Area: Agriscience- Data Analysis Date: ____________________ Job: Understanding Data Analysis in Excel Step Procedures Key Points Assessment 1. Open file and Be sure to Save As and Open Excel file “Class Save As. insert your last name. Experiment Graphing Click Save As Workbook.” and name the file Last Name- Graphing Activity. 2. Find the Select your class worksheet Worksheet for your you were assigned at the class (Animal or bottom of the screen. Plant Science). Add Select cells A1:K1. Click a title in row 1. Merge and Center on the Home Tab. Click on the new cell and type Experiment “Class Data.” 3. Count the total Select cell A20. Type number of =COUNT( You can click on A16 participants in cell and drag up to A5. A20. Click and drag to select cells After releasing the A5:A16. mouse from your click
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