Chuyển tới nội dung chính

Tổng quan các chủ đề

  • Spreadsheets

    Browse to find your image above. Then update alt text here. Set the first size number below to between 300-400.

    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]





    Upon completion of this module, you will be able to:
    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

    You will find the following resources and activities in this module at the Pressbooks website. Click on the links below to access or complete each item.