You are invited to be a Data Hero! Attend the 2017 Data Science Hack-a-Thon to explore CA State Education data. Winners of the data contest are eligible to win an internship, or a cash prize. Participating companies include interpreta, Cymer and Analytics Ventures and more...
When: September 30th, 2017
Where: Biocom
10996 Torreyana Rd.
San Diego, CA 92121
Time: 9am to 1pm
How it Works
When you arrive on September 30th, the data will be released and the case questions will be presented for you to solve. There will be various levels of difficulty required for the case competition ranging from basic descriptive analytics to predictive modeling. There is room for all skill levels. You can choose to compete at whatever level you would like.
Teams can be formed and registered at the event. Individuals can compete as well.
Your final product will be due Sunday Oct. 8th at 11:59pm. Winners will be announced Oct. 11th and the Awards event will be on Oct. 12th at 6pm.
This session will show all you need to know to start accessing the UCSD business and finance resources immediately. You will find out how to get to our subscriptions for news, financial and company information, analyst reports and much more. We’ll talk about off-campus access, and touch on features like apps to browse journals, how to set up news alerts, and where to find your favorite resources quickly.
Whether Excel is a daily part of your business or just occasionally used for a quick spreadsheet project, users often find themselves spending hours trying to answer the question, “I know there’s a way to do this in Excel, but how?” Become a more efficient Excel user and learn the most powerful features that the program has to offer in this one-day, advanced course. Highly interactive and hands-on, you will spend the entire time using Excel while an expert trainer walks you through demonstrations and exercises.
Required Materials
Laptop (preferably a PC)
Topics Covered:
Pivot Tables: allows you to extract the significance from a large, detailed data set. We will look at many examples and covers special features of Pivot Tables, including: Slicers, Linking Pivot Tables, Report Layouts, Grouping, Calculated Fields, Drill Down, Grand Totals, Conditional Formatting, Filtered Records, and more.
Pivot Charts: the visual representation of a pivot table. We will look at dynamic Pivot Charts, too.
Macros: create automated tasks and custom logic
Macro Writing: useful for applying style and formatting, manipulating data and text, communicating with data sources and creating entirely new documents. We will cover If/Then and Do Loops.
VBA: Visual Basic for Applications is the programming language used to develop macros
Advanced Lookup Functions: allows you to search a column of data for a specific value within Excel to return the corresponding value within another row. We will discuss constraints of certain lookup functions and ways to fix those issues. We will also cover errors and how to use them to our advantage.
Data Validation: Make a list of the entries that restricts the values allowed in a cell.
Creating Amortization Tables: shows the interest applied to a fixed interest loan and how the principal is reduced by payments. It also shows the detailed schedule of all payments so you can see how much is going toward principal & how much is being paid toward interest charges. We will also discuss how to pay off your mortgage early and the results of various scenarios.
Name Definitions: use defined names in lieu of traditional row-and-column addresses to create formulas more quickly and easily, while simultaneously creating documentation
Whether Excel is a daily part of your business or just occasionally used for a quick spreadsheet project, users often find themselves spending hours trying to answer the question, “I know there’s a way to do this in Excel, but how?” Become a more efficient Excel user and learn the most powerful features that the program has to offer in this one-day, advanced course. Highly interactive and hands-on, you will spend the entire time using Excel while an expert trainer walks you through demonstrations and exercises.
Required Materials
Laptop (preferably a PC)
Topics Covered:
Pivot Tables: allows you to extract the significance from a large, detailed data set. We will look at many examples and covers special features of Pivot Tables, including: Slicers, Linking Pivot Tables, Report Layouts, Grouping, Calculated Fields, Drill Down, Grand Totals, Conditional Formatting, Filtered Records, and more.
Pivot Charts: the visual representation of a pivot table. We will look at dynamic Pivot Charts, too.
Macros: create automated tasks and custom logic
Macro Writing: useful for applying style and formatting, manipulating data and text, communicating with data sources and creating entirely new documents. We will cover If/Then and Do Loops.
VBA: Visual Basic for Applications is the programming language used to develop macros
Advanced Lookup Functions: allows you to search a column of data for a specific value within Excel to return the corresponding value within another row. We will discuss constraints of certain lookup functions and ways to fix those issues. We will also cover errors and how to use them to our advantage.
Data Validation: Make a list of the entries that restricts the values allowed in a cell.
Creating Amortization Tables: shows the interest applied to a fixed interest loan and how the principal is reduced by payments. It also shows the detailed schedule of all payments so you can see how much is going toward principal & how much is being paid toward interest charges. We will also discuss how to pay off your mortgage early and the results of various scenarios.
Name Definitions: use defined names in lieu of traditional row-and-column addresses to create formulas more quickly and easily, while simultaneously creating documentation
