100 likes | 209 Views
Bellwork. Sit down by your science fair partner. Pick up your science fair packet. Log in and then turn the monitor (screen ) off. Get out a piece of paper and be ready to take notes! At the top of your paper, answer the following question:
E N D
Bellwork • Sit down by your science fair partner. • Pick up your science fair packet. • Log in and then turn the monitor (screen) off. • Get out a piece of paper and be ready to take notes! • At the top of your paper, answer the following question: • Have you ever used Microsoft excel? If so, what for?
How to make a computerized graph!! Yes, you need to write this down!
Step 1: • Go to Start • Select All Programs • Select Microsoft Office • Open up Microsoft Excel • “Save as” right now by going to computer and selecting your name (use a title!)
Step 2: • Type your data in excel in a table format (anywhere in the middle to give yourself some room) • Put your independent variable across the top (rows) • Put your dependent variable going down (columns) • Numbers only, yes, use naked numbers Ex: Growing crystals in three different temperatures
Step 3: • Highlight the data portion of the data • Click insert chart and select column for bar graphs or scatter for line graphs (to show the data points)
Step 4: • Click on the graph in order to add the title and axis labels • Now click on layout at the top • Select chart title • Choose “Above chart” (a text box appears—type your title!)
Step 5: • Now, you are ready for axis titles (under layout) • Select axis titles—horizontal for x or independent variable • Select axis titles—vertical for y or dependent variable
Step 6: • Now you can make it beautiful by going “home” and highlighting the text to make the font bigger, etc.
Step 7: • To print your graph: • Make the graph a little bigger and while you are “clicked on it” select print. (making sure you are using the correct printer!!)
Closure: • Based on your science fair data, what type of graph will you be making and printing for your science fair board? • What is your independent variable? • What is your dependent variable?