Workshop Topic
DS120: Design Studies 120
Prabhu, Yogesh
Excel 1: Introduction to Data Processing with Excel
This workshop is an introduction to working with data in Excel. Students will learn spreadsheet terminology, the basics of the Excel interface, how to create and edit spreadsheets, and how to generate charts and graphs …
Excel 2: Boost Your Excel IQ: Mastering Functions
This workshop expands on the material in Excel 1 and introduces a wider array of built-in functions to make working with data easier. Topics include: Logical functions including COUNT and COUNTIF Lookup, array, and summary …
Excel 2: Data-Driven Excel: Unlocking Insights with Analysis Tools and Techniques
This workshop introduces more advanced analysis tools that can be used to summarize data, perform complex calculations, and maximize the computing power of Microsoft Excel. Topics covered: Input Tables Subtotal Goal Seek Solver Analysis ToolPak
Excel 3: Macros and VBA
This workshop covers the basics of automating excel with macros using Visual Basic for Applications (VBA). This course will utilize Excel but the knowledge can easily transfer to other programs that have VBA capabilities. This …
Access 1
This course is an introduction to Microsoft Office Access, a relational database creation and management tool. After outlining what relational databases are, Access 1 focuses on creating tables and entering data. Topics Include: What are …
Access 2
In Access 2, students will learn to establish relationships among tables and use queries to extract useful information from their data. Students will also learn how forms and reports can help organize and present data. …
Audacity: Editing Audio with Audacity
Audacity is an open source, free and easy to use audio editor and recorder. It includes powerful audio post-production tools to help create professional podcasts and music. It’s a popular choice for class assignments at …