Crash Courses for Students

The following Accelerator Crash Courses will be offered to IUB students during the 2018-19 Academic Year. 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, Connect to CEWiT today.


Upcoming Fall 2018 ACCs

We are currently planning the ACC's for the upcoming academic year.  We will post here when we have finalized details. Please check back!

If you have a suggestion for a topic on which you'd like to see us offer an ACC, please email us!


Completed Spring 2018 ACCs

Microsoft Excel

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

Scrum

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.

3D Printing

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.


SQL

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 Accelerator 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.