Learn how to create spreadsheets in collaboration with others to present data using charts, plots, graphics, and tables. Also, explore tools for formatting charts and adding graphics to better present and organize information.
This course focuses on collaborating and presenting data using charts, plots, graphics, and tables. We will learn how to create and format appropriate charts for a given data set. We also study how to create scatterplots for correlated data and fit those plots into an equation. We will add appropriate graphics to worksheets to help us communicate better with users. We will use the database functions of tables to organize information better. Finally, we use collaboration features to present data in various contexts.
This course is intended for students who understand spreadsheets from PRDV004: Spreadsheets and PRDV006: Spreadsheets II: Formatting and Functions. Each unit builds on the previous unit, so try to master each unit before moving on.
- Unit 1: Presenting Data with Charts
- Unit 2: More Work with Charts
- Unit 3: Incorporating Graphics
- Unit 4: Tables
- Unit 5: Data Collaboration
- Illustrate a line, column/bar, pie, and stacked column/bar chart that is appropriate for the given data;
- Diagram a scatterplot with a trendline and line equation for a data series;
- Explain how to add graphics, symbols, hyperlinks, headers, and footers to a worksheet;
- Create and filter a table; and
- Arrange collaboration features to present data in various contexts.