Agenda for Session 1 on 12/14

  • What is possible with spreadsheets? Some demos...
    • Data Entry Specialist: Data Entry, Survey Administration
    • Data Analyst: Retrieval, Analysis, and Presentation of Data
    • Policy Analyst / Marketing Analyst: Cost-Benefit Calculation, Policy Modelling, Advanced Data Visualization
    • Visual Basic Programmer: Automating Reporting Tasks, Creating Custom Applications
    • Data Scientist: Widely ranging skills across software engineering, statistics, and business/domain knowledge
  • What is NOT possible with spreadsheets? (How databases work) More demos...
    • Any database has three key components: Excel is not good for forms. 
      • Tables - where data are stored.
      • Reports/Queries - where data are accessed and presented
      • Forms - where data are entered into tables and modified from tables
    • Excel's newest generation of pivot tables can produce increasingly sophisticated reports

Agenda for Session 2 on 12/21

  • Basic shortcuts for using your whole computer more efficiently
    • Managing Windows / Applications (Most important: ALT + TAB)
    • Across several Different Applications General (Most Important: CTRL + Z) 
    • Web Browsing (Most Important: CTRL + T)
    • Text Editing
    • Excel
    • Great list of shortcuts: exceljet.net/keyboard-shortcuts 
  • Excel: Far reaching basics
    • Variable types (values, text strings, booleans)
    • Hard-coding variables in formulas
    • Concatenating
    • Boolean operators and basic boolean logic

Agenda for Session 3 on 12/28

  • Reviewing what's possible and not possible with spreadsheets
  • Reviewing shortcuts for using your computer more efficiently
  • Revisiting variables, using formulas, and concatenating
  • Introducing basic Boolean logic and logical tests

Agenda for Session 4 on 1/4

  • Understand that a logical test fits INSIDE of an IF formula
  • Working with Excel Tables
    • Understand that a table clearly delineates the range that will be sorted/filtered
    • Understand the reference syntax inside of tables and how it differs from standard A1 style references
    • Understand that formulas inside of tables fill down automatically
    • Understand that data in tables can be sorted and filtered by color
    • Understand that filtering data in a table is a simple method of querying that data
    • Understand that a table creates Named Ranges by default

Materials for 1/4 Class

Shortcuts, Exercise, and Reference for Session on 1/4
excel_curriculum_uvm_2021_01_04.xlsx
File Size: 684 kb
File Type: xlsx
Download File

Other Materials for Reference

6 Ways to do the same lookup task in Excel in increasing levels of sophistication
mailing_list_uvm.xlsx
File Size: 441 kb
File Type: xlsx
Download File
Vermont COVID Grant Calculator

https://tax.vermont.gov/coronavirus/grants/unmet-need
Vermont State Renter Rebate Reform Cost-Benefit Calculator - 2019
renter_rebate_reform_sandbox_calculator_v15.xlsb
File Size: 380 kb
File Type: xlsb
Download File