BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Data Science Hub - ECPv6.18.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Data Science Hub
X-ORIGINAL-URL:https://datascience.library.claremont.edu
X-WR-CALDESC:Events for Data Science Hub
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Los_Angeles
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20250309T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20251102T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20260308T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20261101T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20270314T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20271107T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20261023T130000
DTEND;TZID=America/Los_Angeles:20261023T150000
DTSTAMP:20261008T205814Z
CREATED:20261008T205814Z
LAST-MODIFIED:20261008T205814Z
UID:2296-1792760400-1792767600@datascience.library.claremont.edu
SUMMARY:QCL Workshop - Excel: Conditioning Data - Level 2
DESCRIPTION:This Excel Level 2 workshop will cover more functions and features to save you some time while working with Excel. \nIn this 1.5-hour workshop\, we hope to get you started with: \n– Pivot Table \n– More Lookup functions: VLOOKUP (approximate match)\, INDEX\, and MATCH \n– Most common functions: Count and Sum \n– Logical functions: IF\, AND\, OR\, and NOT \nThe workshop is designed to continue from the QCL Excel Basics Level 1 Workshop.  However\, anyone is welcome to register. \n  \nPre-requisites \nInternet Use: Introductory level (search\, log-in\, navigation of websites\, etc.) \nLocal installation (if you bring your laptop): Microsoft Excel (any version)Software knowledge: basic Excel skills \n  \nInstructor: Joan Zheng \n  \nParticipants \nAll CMC Students\, Faculty\, and Staff\, and All Claremont Colleges Students\, Faculty\, and Staff
URL:https://datascience.library.claremont.edu/event/qcl-workshop-excel-conditioning-data-level-2-7/
LOCATION:QCL: Murty Sunak Quantitative and Computing Lab\, Kravis Center\, Lower Court
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20261023T153000
DTEND;TZID=America/Los_Angeles:20261023T173000
DTSTAMP:20261008T230441Z
CREATED:20261008T205927Z
LAST-MODIFIED:20261008T230441Z
UID:2299-1792769400-1792776600@datascience.library.claremont.edu
SUMMARY:QCL Workshop - SQL: Setting Up and Querying Databases - Level 1
DESCRIPTION:SQL is an acronym for Structured Query Language. It is a language designed to access and work with relational databases. Relational databases store and provide access to data points that are related. In this session we will be learning Data Manipulation Language (DML)\, and Data Query Language (DQL). \nAgenda \n\nInserting data\nQuerying a table\nJoining tables\nHands-on activities\n\n  \nPre-requisites:\nInternet Use: Introductory level (search\, log-in\, navigation of websites\, etc.)\nLocal installation: DBeaver (any version)\nSoftware knowledge: basic computer skills\nDownload the repo and follow the exercises! Click here \n  \nInstructor: Daniel Perez \n  \nParticipants\nAll CMC Students\, Faculty\, and Staff\, and All Claremont Colleges Students\, Faculty\, and Staff
URL:https://datascience.library.claremont.edu/event/qcl-workshop-sql-setting-up-querying-databases-level-1/
LOCATION:QCL: Murty Sunak Quantitative and Computing Lab\, Kravis Center\, Lower Court
END:VEVENT
END:VCALENDAR