1 / 10

Create Stunning Graphs for Your Science Fair Project with Microsoft Excel

In this step-by-step guide, you will learn how to use Microsoft Excel to create impressive graphs for your science fair project. Start by entering your data in a clear table format, highlighting the data, and using Excel's chart tools to design visually appealing bar or line graphs. Follow instructions on adding titles and labels to your graphs, enhancing their look, and finally, printing them for your presentation. Discover the importance of identifying your independent and dependent variables as you prepare your science fair board.

judson
Télécharger la présentation

Create Stunning Graphs for Your Science Fair Project with Microsoft Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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?

  2. How to make a computerized graph!! Yes, you need to write this down! 

  3. 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!)

  4. 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

  5. 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)

  6. 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!)

  7. 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

  8. Step 6: • Now you can make it beautiful by going “home” and highlighting the text to make the font bigger, etc.

  9. 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!!)

  10. 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?

More Related