Check here for the latest panel schedule.

Hands-on Classes

Each hands-on class for Lexington is designed to give you a specific skill in 90 minutes.

Thursday, September 14
10:30 a.m.	Stats 101 -- Finding the right tool: From calculators to SAS SQL Server 1 -- Queries in SQL Server (Wildcards, quotes and functions) SPSS Basics -- Getting around SPSS, using descriptive statistics and frequencies SAS Basics -- Using SAS to work with Census data
1:30 p.m.	SQL Server 2 -- Getting data in (data transformation service) To Be Announced SPSS Intermediate -- Doing crosstabs and statistical tests PERL 1 -- Programming: Creating functions to split names and addresses automatically
3:00 p.m.	VBA -- Programming: Creating functions to split names and addresses automatically PERL 2 SPSS Advanced -- Basic linear regression techniques and diagnostics Stats 101 -- Finding the right tool: From calculators to SAS
Friday, September 15
9:00 a.m.	Mapping 1 -- Basics: Getting started with ArcView using data that comes with it Excel 1 -- Performing simple calculations and sorting data with spreadsheets (CLOSED) Access 1 -- Filtering databases: shuffling electronic records VB Script -- Using VB Script to create programs Internet 1 -- Web sites and searching techniques no reporter can do without (Internet Training at UK)
10:30 a.m.	Mapping 2 -- Intermediate: Layering maps and importing other databases into maps Excel 2 -- Importing data from the Web into spreadsheets Access 2 -- Summarizing databases: how many, how much, etc. SAS Basics -- How to read in, clean up and summarize data Internet 2 -- Backgrounding people online (Internet Training at UK)
1:30 p.m.	Mapping 3 -- Advanced: Geocoding to merge databases with street addresses into maps Excel 3 -- Advanced features: Pivot tables, auto filter and more Access 3 -- Joining databases: finding newsworthy matches VBA -- Programming: Creating a program to read and manipulate difficult data set Internet 1 -- Web sites and searching techniques no reporter can do without (Internet Training at UK)
3:00 p.m.	(CLOSED) Mapping (Census) -- Visualizing diversity and income Access String Functions -- Splitting name fields, cleaning data SPSS Basics -- Getting around SPSS, using descriptive statistics and frequencies To Be Announced Internet 2 -- Backgrounding people online (Internet Training at UK)
Saturday, September 16
9:00 a.m.	Mapping 1 -- Basics: Getting started with ArcView using data that comes with it Excel 1 -- Performing simple calculations and sorting data with spreadsheets Access 1 -- Filtering databases: shuffling electronic records Fox Pro 1 -- Basics: Introduction to SQL, selecting fields and filtering records Internet 1 -- Web sites and searching techniques no reporter can do without (Internet Training at UK)
10:30 a.m.	Mapping 2 -- Intermediate: Layering maps and importing other databases into maps Excel 2 -- Importing data from the Web into spreadsheets Access 2 -- Summarizing databases: how many, how much, etc. Fox Pro 2 -- Intermediate: Summarizing data by counting and summing; joing tables Internet 2 -- Backgrounding people online (Internet Training at UK)
1:30 p.m.	Mapping 3 -- Advanced: Geocoding to merge databases with street addresses into maps Excel 3 -- Advanced features: Pivot tables, auto filter and more Access 3 -- Joining databases: finding newsworthy matches Fox Pro String Functions -- Advanced: Splitting name fields
3:00 p.m.	To Be Announced Access String Functions -- Splitting name fields, cleaning data Mapping (Census) -- Visualizing diversity and income To Be Announced
Sunday, September 17
9:00 a.m.	Excel 1 -- Performing simple calculations and sorting data with spreadsheets Access 1 -- Filtering databases: shuffling electronic records
10:30 a.m.	Excel 2 -- Importing data from the Web into spreadsheets Access 2 -- Summarizing databases: how many, how much, etc.