Spreadsheets II

In class:

Administrative:

  • Review course schedule

Instructional:

This week serves as an introductory session to the basics of spreadsheet software and worksheets.

  • Last week's concepts: step-by-step
  • Graphs
    • Uses
    • Types
    • Constructing the data
    • Titles
    • Labels
  • Spreadsheet Demo – the spreadsheet below was used to demonstrate concepts
AGRI Spreadsheets Demo
  • Database usage
    • Data construction
    • Sorting
  • Best of both worlds – Google Cloud Connect for Microsoft Office allow you to store your Office files in the Google Cloud and provides versioning and collaborative features

Online:

  • Complete the AGRI Spreadsheets Lab (100 points).
  • Complete the Spreadsheet quiz found in the Assessments area of the course management system (20 points).
  • Video Series: The Excel is Fun Channel on YouTube an excellent resource for Excel tutorials and tips. For this hybrid section of the course, watch the following videos.