Spreadsheets

Replace this text with a short module introduction in narrative form; provide context and instructor's perspective to review (prior knowledge), preview (highlights of the module), and motivate (relevance to students' personal and career goals). Avoid referencing textbook chapters, page numbers, or dates. To replace image, double click the image placeholder. Select 300–400 pixels wide, and update the description of image. Include attribution of your image (Title, Author, Source, License).

[initial draft below]

1. Demonstrate an understanding of the purposes of spreadsheets and the essentials of mastering the use of spreadsheet applications
   
2. Identify the major components of electronic spreadsheets and how they work, including navigation of program menus and ribbon, and screen manipulation.
   
3. Create, design, and edit spreadsheets and workbooks using formatting techniques
4. Understand the syntax and apply electronic spreadsheet formulas and functions: including simple calculations; analyze and chart data; and summarize data with pivot tables
   
5. Understand the basics of using spreadsheets statistical functions including average and standard deviation.
   
6. Apply data analysis techniques to different data structures including lists and tables, techniques include charts and graphs.
   
7. Create basic plots including histograms and dependent vs. independent variables.
   

To achieve these objectives: 

1. Read the Module 8 Introduction 
   
2. Read and view the materials in the Module 8 Pressbooks book chapter

Module Pressbooks Resources and Activities