Cosi102

<slide_break></slide_break>

## 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:

<div class="callout callout-big">
        <h1 class="display-5">NEW POLICY</h1>
        <p class="lead">Starting with the Stage 2 Deliverable, work submitted after the due date can never have an exceeds rating</p></div>

<slide_break></slide_break>

<h3 id="purpose-of-weekly-status-report">Purpose of Weekly Status Report</h3>

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

<slide_break></slide_break>

<h3 id="contents-of-weekly-status-report">Contents of Weekly Status Report</h3>
<ul>
  <li>Each team submits a one page update covering their progress.</li>
  <li>Each bullet includes the student who was responsibile</li>
  <li>It is a list as follows:</li>
</ul>

<pre><code class="language-shell">
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.
</code></pre>

<slide_break></slide_break>

## 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

<slide_break></slide_break>

### 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"

<slide_break></slide_break>

### Import/Export
* Role of .csv files
* Lots of data out there
* Parsing of columns

<slide_break></slide_break>

### Intermediate
* Copy / Paste
* Absolute and Relative References
* Ranges

<slide_break></slide_break>

### Organization
* Using tabs
* Formatting, freezing
* Hiding/Showing
* Sorting and filtering

<slide_break></slide_break>

### More advanced patterns and functions
* [=query](https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/)
* =index
* =vlookup
* Pivot tables

<slide_break></slide_break>

<h2 class="shadow p-3 bg-white rounded">Thank you. Questions?<img class="img-fluid w-100" src="https://picsum.photos/800/100.jpg" /> <small> (random Image from picsum.photos)</small></h2>