Virtual Data Visualization Summer Camp


Dawn Owens welcomes high school students to an ITS Summer Camp
Learn more about information technology!
July 27-31, 2020
Register Now

Welcome!

We are inviting students in grades 9 – 12 to attend an amazing event to learn more about information technology. Using digital storytelling, the camp will introduce databases and analytics to high school students. This introduction will show you how you can use data to make decisions and what tools and techniques you can use to make this happen.

Follow us!

BS in ITS

links to BS in ITS facebook page instagram logo

ITS Academy

Links to ITS Academy Facebook page instagram logo youtube logo

Contact Us

Please contact us to learn more about the UT Dallas Information Technology and Systems events we are hosting.

Dawn Owens, PhD Director, Undergraduate Information Technology and Systems Program
(972)-883-4901 JSOM 3.707
Gaurav Shekhar Director, MS Business Analytics Flex and Online Programs
(972)-883-5147 JSOM 3.709

Agenda

7/27/2020 – Introduction to Data Analytics
Time Activity
10 a.m. Introduction of Dr. Dawn Owens, ITS program director, and the workshop
10:20 a.m. Welcome by Gaurav Shekhar, director of the MS in Business Analytics Glex and Online programs
10:40 a.m. Introduction of ITS program and Envision
11:10 a.m. Workshop Curriculum Overview
11:20 a.m. Introduction to data analytics and data visualization — Why are they important?
11:40 a.m. Short break
11:50 a.m. Overview of databases
12:10 p.m. Data Modeling — How data fits in different phases (modeling, warehousing, and more)
12:30 p.m. SQL and Tableau Setup Q&A
12:50 p.m. Q&A, discussion for next day, short exercise as homework
1 p.m. End
7/28/2020 – Learning the SQL Language
Time Activity
10 a.m. Quick overview of last day
10:20 a.m. DDL statements overview
10:40 a.m. Introduction to data types, schemas, tables
11:10 a.m. SELECT statement, FROM clause
11:30 a.m. Short break
11:40 a.m. WHERE clause
Noon UPDATE statement
12:20 p.m. DELETE, TRUNCATE and DROP statement
12:40 p.m. Kahoot quiz and homework exercise
1 p.m. End
7/29/2020 – SQL A to Z and Advanced SQL Concepts
Time Activity
10 a.m. Quick overview of last day
10:20 a.m. Introduction to ORDER BY, GROUP BY
11 a.m. Short exercise
11:20 a.m. Rapid-fire quiz
11:30 a.m. Short break
11:40 a.m. Views
Noon Wrapping up — Intro to advanced SQL (can be something else too)
12:50 p.m. Q&A
1 p.m. End
7/30/2020 – Tell a story with Tableau
Time Activity
10 a.m. Quick overview of last day
10:20 a.m. Overview of data visualizations
10:40 a.m. Introduction to Tableau
11 a.m. How to connect to data?
11:20 a.m. Basic charts and visualization examples
11:30 a.m. Short break
11:40 a.m. Quiz time!
Noon Industry Panel discussion – Why data analytics is the next big thing?
12:30 p.m. Q&A with the Panelists
12:40 p.m. Exercise and Q&A
1 p.m. End
7/31/2020 – It’s a Wrap!
Time Activity
10 a.m. Quick overview of last day
10:20 a.m. Final Project Contest
11:20 a.m. UTD presentation
11:40 a.m. Short break
11:50 a.m. Panel discussion with Parents & Feedback session
12:20 p.m. Fun game
12:30 p.m. Ending notes and Q&A
1 p.m. End

The cost to attend the camp is $20. Please use the green “Register” button above to sign up, and complete all required registration forms using the “Forms” tab.

Instructions for completing the forms

  • Filling out forms is mandatory. Registration will not be complete without the return of forms. Download and complete the forms manually. You can either bring completed forms on Friday, April 5 or scan them and email to itsacademy@utdallas.edu.
Dawn Owens

Dawn Owens

Information Technology and Systems Professor and Program Director

Dawn received her PhD in information technology from the University of Nebraska at Omaha. She has worked in the professional environment with industry experience encompassing both technical and management expertise.

Learn more about Dawn.

Gaurav Shekhar

Gaurav Shekhar

Business Intelligence/Analytics Professor and Program Director

Gaurav is a senior lecturer in the Jindal School Information Systems Area and the director of the UT Dallas MS in Business Analytics – Flex and Online programs.

Learn more about Gaurav.