Programme

Milham Room – HIL Rm. 100

Learning Lab: HIL Rm. 112

26 April 2012	Day 1 : DLI TRAINING	Location
Session 1.0 8:30-9:00	Meet and Greet (and Eat) Check your e-mail prior to the sessions and grab some tea or coffee to start your day.	Learning Lab (e-mail) Milham Room (beverages)
Session 1.1 9:00-9:45	Welcome Welcome to UNB Fredericton; welcome to new and returning workshop participants.	Milham Room
Session 1.2a 9:45-10:45	Statistical Concepts, Part I Lucia Tramonte will make you wonder why you hadn’t commenced your love affair with statistics sooner. Statistical Concepts (.pdf)	Learning Lab
10:45-11:00	Biobreak	Milham Room
Session 1.2b 11:00-12:00	Statistical Concepts, Part II The second part of Lucia’s session will include some hands-on exercises using Equinox to seek out data sets for your patrons. Statistical Concepts - Exercises (.pptx)	Learning Lab
12:00-1:00	Lunch	Milham Room
Session 1.3 1:00-1:45	Product Updates/Review Looking at two Census products: GeoSuite 2011 and C86. Carolyn DeLorey will take a look at one of the newest electronic census products and Siobhan Hanratty will guide the group through an exercise in using one of the oldest (but still very useful). GeoSuite 2011 (.pdf) / GeoSuite 2011 (.pptx) / Census 86 (.pdf)	Learning Lab
Session 1.4 1:45-2:15	Tailoring Data Presentations to Novice Users How do you introduce DLI to novice data users? During this half presentation, half discussion session, Julie Marcoux will start by showing you how she approaches the problem, and then get you to share your own favourite strategies. DLI Novice Users. pptx	Milham Room
Session 1.5 2:15-4:15	DLI Central Update What’s new and exciting at DLI Central? What’s going on with E-Stat? The DLI licence? Implications for CANSIM via CHASS? PCCF? Biobreak will take place at an appropriate time	Milham Room
6:15	Dinner at the Palate Restaurant and Café	462 Queen St.
27 April 2012	Day 2 : DLI TRAINING	Location
Session 2.0 8:30-9:00	Pre-session E-mail & Caffeination	Learning Lab (e-mail) Milham Room (beverages)
Session 2.1 9:00-10:30	Canadian Institute for Health Information Saleem Alwani and David Paton will be talking about CIHI and the possibility of providing a Public Use file from the Discharge Abstract Database (DAD) the DLI member institutions.	Milham Room
Session 2.2 10:30-11:15	Sources of Business Data Peter Webster will do a brief review of corporate business data sources, including stock price, balance sheet, ratio and other business information reporting. We will discuss well known sources from companies like Standard and Poors, and Mergent as well as publically available sources. We will look at ways corporate statistics and data intersect with Stats Can information. These will include postal code, city and province level geography, as well as industrial sectors via NAICs and SIC code. Corportate statistics handout .docx format / .pdf format	Milham Room
11:15-11:30	Biobreak	Milham Room
Session 2.3 11:30-12:30	Master the Wonders of Excel Are you ready to expertly manipulate Excel in order to answer DLI questions? During this hands-on workshop presented by Julie Marcoux, you'll be introduced to very basic programming concepts for use in Excel's macros, you'll learn to manipulate data by concatenating strings, you'll explore some very useful Excel functions, and you will leave the workshop ready to make Excel obey your every wishes! Excel Exercise Files	Learning Lab
12:30-1:30	Lunch	Milham Room
Session 2.4 1:30-2:30	Census 2011 & the NHS Marie Anderson of Statistics Canada will give us the skinny on the 2011 Census and the National Household Survey	Milham Room
Session 2.5 2:30-3:00	Wrap-up Planning for next year Pictures, Evaluations, and Good-byes	Milham Room