Crash Courses for Students

The following Accelerator Crash Courses will be offered to IUB students during the Spring 2018 term. Each course will have 20 seats, and students must apply for a seat. Any IUB student may apply, but preference is given to CEWiT affiliates. If you are not a CEWiT affiliate, join CEWiT today.


Upcoming Spring 2018 ACCs

Scrum

DATE:  Saturday, February 17, 2018 and Sunday, February 18, 2018
TIME: 10am  4:30 pm
LOCATION: School of Global Studies, Room 0007
DESCRIPTION: Learn the basics of Scrum, an Agile framework for completing complex projects, and Kanban, a technique for ensuring better communication through visual management, at our 2-day training course tailored for beginners. This course is an ideal first step toward a Professional Scrum Master Certification (PSM).

You don't have to be a technical person to gain value from Scrum. Scrum has application beyond traditional software development. You do not need to be a software developer, or even work in technology, to benefit from using the principles of agile practices like Scrum.

  • If you work on projects that are complex, have limited resources such as time or budget) or have shifting priorities and requirements, Scrum can help.
  • Scrum certification can be a career-booster. PSM is one of the most common certifications employers seek when they hire.

Applications for seats to this course are closed. 


3D Printing

DATE:  Saturday, April 7, 2018
TIME: 10am – 3pm
LOCATION: LI402
DESCRIPTION: This workshop provides an entry-level introduction about 3D printing. During this workshop, participants are able to gain a basic understanding on 3D printing, co-create a 3D design, and connect 3D printing with personal interests and professional careers. In particular, the workshop aims to bring awareness to the many uses of 3D printing, and that we can continue to encourage more women to utilize this new technology in related fields.

Class size is limited to 20. To apply for a seat, fill out THIS FORM by midnight, Wednesday, March 7, 2018. Those selected will be notified by Monday, March 19, and must confirm their seat by midnight, Wednesday, March 21. A waitlist will be used to fill any seats not claimed or cancelled.


SQL

DATE:  Saturday, April 14, 2018
TIME: 10am – 5pm
LOCATION: SB015
DESCRIPTION: In the fall of 2013, Loyalty Research Center and TechPoint surveyed 26 Indiana companies in order to better understand which computer-related skills and job functions were most important to their growth. According to the results of that survey, the one of most used technologies is SQL.

If you’d like to find a job in Indianapolis after you graduate, we encourage you to apply for a seat at for this Accelerated Crash Course!

In this workshop we learn how to use SQL to create a database, maintain it, and recover information from it. We start by defining the problem that our relational database will help resolve and discussing in detail the database model we will use. We proceed to create the database structure using both pre-written scripts and hands-on SQL statements, then populate the database and update its data. Having done that, we then learn how to retrieve data in meaningful ways using simple and complex select statements. We end with exploring some SQL functions and understanding when to use them.

Our tool is the Community Edition of MySQL, the most popular open source database currently available; the goal of the workshop is not to teach how to use the tool, but the instructor will teach the minimum necessary to complete the hands-on exercises.

Class size is limited to 20. To apply for a seat, fill out THIS FORM by midnight, Wednesday, March 14, 2018. Those selected will be notified by Monday, March 26, and must confirm their seat by 4pm, Wednesday, March 28. A waitlist will be used to fill any seats not claimed or cancelled.


Completed Spring 2018 ACCs

Microsoft Excel

DATE: Saturday, February 3, 2018
TIME: 9am – 4pm
LOCATION: Wells Library, Room W144
DESCRIPTION: Eighty percent of current job openings require spreadsheet and word processing skills, according to a series of studies conducted by Burning Glass Technologies. No matter what job you hope to get after you graduate, you need to know Microsoft Excel.

Check out this infographic  on the value of Learning Excel.

CEWiT is pleased to partner with UITS IT Training to offer an Accelerator Crash Course on Excel. Instructors Jason Fickel and April Law will cover:

  • Introduction of key terms and features in Excel
  • Entering formulas and functions
  • Adjusting columns and formatting
  • Creating tables
  • Inserting and working with rows
  • Sorting data
  • Formatting cells
  • Introduction to charting
  • Working with key chart types
  • Working with PivotTables
  • Understanding VLOOKUP
  • Using macros