1 / 24

MIS 201B Unit 7

MIS 201B. Unit # 7. MIS 201B Unit 7. Spreadsheets and Graphs. Please close laptops!. Design and Presentation of Information. +. Design and Presentation of Information. +. Learn to format a spreadsheet to make it more readable and professional

oswald
Download Presentation

MIS 201B Unit 7

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. MIS 201B Unit # 7 MIS 201BUnit 7 Spreadsheets and Graphs By: Nancy Matolak

  2. Please close laptops!

  3. Design and Presentation of Information +

  4. Design and Presentation of Information + • Learn to format a spreadsheet to make it more readable and professional • Learn to apply graphic design principles to spreadsheets and graphs • Match your data to the appropriate Graph Type • Investigate the Launch of the Space Shuttle Challenger • Quiz – Unit 6

  5. L1_L2 (part 1) Design Spreadsheets and Create Formulas in Excel L1_L2 (part 2) Design Graphs in Excel L3 Launch Space Shuttle Challenger?

  6. Excel Workbook Layout

  7. A Picture is Worth a Thousand Words

  8. Spreadsheet Design Principles Before

  9. Graph Design Principles Before

  10. Matching Data to Graph Type Bar Graph Line Graph Scatterplot

  11. Launch the Space Shuttle Challenger?

  12. Slide from the Original Presentation

  13. Excel Techniques • Format Number • Move Decimal Point • Insert Row • Insert Column • Line Break Within Cell • Create A Formula • Copy Formula • Switch to Formula Mode • Fit to One Page • Create Single Series Bar Graph • Create Multi Series Bar Graph • Create Single Series Scatterplot • Create Multi Series Scatterplot • Move Chart

More Related