Choose to see the schedule for a particular day or scroll down to see the whole schedule:
| Friday |
| Time |
Hands-On Class |
| 10:20-11:30 a.m. |
A: An introduction to SQL Server: What's it got that desktop apps don't.
How to import, view and query the data. |
| A: Beyond basics 1: Using advanced Excel functions |
| I: Making the most of the U.S. Census Bureau's Factfinder |
| B: Access 1: The purifying experience of filtering your data. Learn
to select and sort data items you choose. |
| B: Excel 1: Performing simple calculations and sorting. |
| 11:40 a.m.-12:50 p.m. |
A: SQL automation: How to spend zero time on those tedious, recurrent
tasks of importing, manipulating, analyzing and publishing data with data
transformation service. |
| New this year -- A: Beyond basics 2: An introduction
to string functions in Access. |
| B: Web sites and search techniques for reporters |
| I: Access 2: Summarizing databases with counting and summing |
| B: Excel 2: Calculating ratios and rates in Excel. |
| 2-3:10 p.m. |
A: Perl: An introduction to Perl and regular expressions |
| New this year -- A: Beyond basics 3: Using VBA in Access
to control files, run queries and automate data cleanup |
| B: Backgrounding people on the Internet. |
| B: Excel 1: Performing simple calculations and sorting (MINI-BOOT CAMP) |
| 3:20-4:30 p.m. |
New this year -- A: Scripting away your data woes 1:
VBScript as a tool to format, clean and organize data for use in any database
software. |
| A: Mapping 1: Displaying data geographically with ArcView 9 |
| B: Background businesses on the Internet |
| B: Excel 2: Calculating ratios and rates in Excel. (MINI-BOOT CAMP) |
| 4:40-5:50 p.m. |
New this year -- A: Scripting away your data woes 2:
Perl as a tool to format, clean and organize data for use in any database
software. |
| A: Mapping 2: Importing and selecting data by attribute (ArcView 9) |
| B: Excel and Internet: Importing data from the Web into spreadsheets |
| B: Importing data into Excel (MINI-BOOT CAMP) |
| 6-7:10 p.m. |
Open Lab; review today's exercises, Q&A, Web sites and search techniques
(MINI-BOOT CAMP - RED TEAM) |
| If you've got a willing teacher and students, we can add a session in
this time slot! Come see us in the Demo Room for scheduling! |
| Macs and CAR: User group meeting |
| Saturday |
| Time |
Hands-On Class |
| 9-10:10 a.m. |
A: MySQL: Introduction to a low-cost alternative to SQL Server. |
| A: Mapping 3: Geocoding to merge databases with street addresses into
maps (ArcView 9) |
| B: Web sites and search techniques for reporters |
| A: Access 3: How to join tables, matching information from one file
to another. |
| B: Excel 3: Learn pivot tables, filtering and more. |
| 10:20-11:30 a.m. |
New this year -- A: ASP: From your desktop to theirs;
data sharing made easy |
| A: Mapping 4: How Spatial Analyst can pinpoint places and improve stories.
(ArcView 9) |
| A: Web Scraping 1: Using Perl to grab data from the Web |
| A: Database Building: Using Access forms to ease the process |
| B: Excel 1: Performing simple calculations and sorting. |
| 11:40 a.m.-12:50 p.m. |
A: Introduction to social network software |
| A: SPSS 1: Navigate SPSS, using descriptive statistics and frequencies.
Create basic counts and percentages to help you understand your data. |
| A: Web Scraping 2: Using Perl to grab data from the Web (attendance
in Web Scraping I required) |
| B: Access 1: The purifying experience of filtering your data. Learn
to select and sort data items you choose. |
| B: Excel 2: Calculating ratios and rates in Excel. |
| 2-3:10 p.m. |
A: UltraEdit and others: Using text editors to clean your data and text
manipulation |
| A: SPSS 2: Doing crosstabs to show the data in different ways, and statistical
tests |
| B: Excel and Internet: Importing PDFs from the Web into spreadsheets |
| A: Moving into Access: Learn filtering with Excel, an introduction to
filtering with Access. (MINI-BOOT CAMP) |
| 3:20-4:30 p.m. |
New this year -- A: Optimizing with SQL Server: Using
indexes and other tools to spot slowdowns and speed up your queries. |
| A: SPSS 3: Basic linear regression techniques and diagnostics |
| I: Downloading and analyzing Census demographics to help cover your
community |
| I: Access 2: Summarizing databases with counting and summing (MINI-BOOT
CAMP) |
| 4:40-5:50 p.m. |
New this year -- A: Here's your chance -- grill NICAR
SQL Server teachers about your own data problems |
| New this year -- A: SPSS 4: Scripting with SPSS to
automate time-consuming tasks. |
| I: Downloading and analyzing campaign finance data |
| A: Access 3: How to join tables, matching information from one file
to another. (MINI-BOOT CAMP) |
| 6-7:10 p.m. |
Open Lab; review today's exercises, Q&A, Web sites and search techniques
(MINI-BOOT CAMP - GREEN TEAM) |
| If you've got a willing teacher and students, we can add a session in
this time slot! Come see us in the Demo Room for scheduling! |
| Sunday |
| Time |
Hands-On Class |
| 9-10:10 a.m. |
A: Beyond basics 1: Using advanced Excel functions |
| B: Backgrounding people on the Internet. |
| B: Build your own database: The ins and outs of how to structure and
maintain a database you create. (MINI-BOOT CAMP) |
| 10:20-11:30 a.m. |
A: Introduction to social network software |
| B: Backgrounding businesses on the Internet. |
| A final Q&A session, exercise, and how to take it all home. (MINI-BOOT
CAMP) |
