Logistics

• People are taking too much advantage of the free extra three days, and then often even asking for an extension on that.
• I feel very generous, but that is causing havoc in our grading.
• It is a large class, afterall
• So:

Purpose of Weekly Status Report

• Explaining the weekly status report Deliverable
• Purpose is to give the team something clear to shoot for each week
• It is a joint deliverable, most likely agreed upon during your weekly meetings
• Designed to be extremely simple to prepare

Contents of Weekly Status Report

• Each team submits a one page update covering their progress.
• Each bullet includes the student who was responsibile
• It is a list as follows:

Team Name:
Date:

Accomplished this week:
    a. Student1: finished xxx
    b. Student2: Got yyy to work
Goal for next week:
    a. Student 3: Continues working on xxx
    b. Student 2: Hopefully will be ready with demo
Blocking issues:
    a. Student 4: Has been out sick for several days
    b.

Required is a link and/or screenshot to your team's
social media post for this week, and provide
a brief description of what you learned in the process.

When is a spreadsheet the right tool?

• If you are making multiple calculations at the same time
• If you are representing tabular information
• If you are building a database
• If you are moving columns and rows of data from one application (latte? pandas? excel?) to another

Basics

• Using excel and google sheets
• A very advanced form of programming
• Basic rows and columns
• Datatypes and formatting
• Basic formulas
• Huge collection of “functions”

Import/Export

• Role of .csv files
• Lots of data out there
• Parsing of columns

Intermediate

• Copy / Paste
• Absolute and Relative References
• Ranges

Organization

• Using tabs
• Formatting, freezing
• Hiding/Showing
• Sorting and filtering

More advanced patterns and functions

• =query
• =index
• =vlookup
• Pivot tables

Thank you. Questions?  (random Image from picsum.photos)