← MSBAi Home

MSBAi Standard Tools Reference

Audience: Faculty, course designers, and TAs. This page defines the standard toolset for all MSBAi courses. Students receive a streamlined setup guide during onboarding.

Tool Stack Overview

1. VS Code — Primary IDE

What: Free, open-source code editor from Microsoft. Extensible with thousands of plugins.

Why VS Code (not JupyterLab): VS Code is where professional developers and data scientists work. It supports notebooks, Python scripts, terminal, Git, debugging, and AI tools in one environment. Ron Guymon: “This is more complex than JupyterLab, but ultimately more useful. I think the students will have more appetite for it.”

Install: code.visualstudio.com

Required extensions for MSBAi:

2. GitHub Copilot Pro — AI Coding Assistant

What: AI pair programmer built into VS Code. Provides inline code completions, chat, and autonomous agent mode.

Cost: Free for verified students for 1 year (normally $10/month). Full Copilot Pro — no feature restrictions.

How to get it:

1. Create a GitHub account at github.com
2. Apply for the GitHub Student Developer Pack using your @illinois.edu email
3. Verify student status through GitHub Education
4. Go to GitHub Settings → Copilot → sign up for free
5. Install the GitHub Copilot extension in VS Code

What students get with Copilot Pro:

Low floor / high ceiling progression:

Week 1-2:   Inline completions only (ghost text while typing)
Week 3-4:   Copilot Chat for debugging and explanations
Month 2+:   Agent Mode for multi-step tasks
Capstone:   Custom instructions, agent skills, MCP integrations (see courses/capstone.md)

Faculty note: Copilot is a tool, not a shortcut. All courses include AI attribution requirements — students must document what AI tools they used, what prompts they gave, and how they validated outputs. See design/assessment_strategy.md.

3. Google Colab — Notebook Environment

3a. Colab in Browser (Low Floor)

What: Free, browser-based Jupyter notebook environment with cloud compute (including free-tier GPU).

Why it’s the floor: Zero install. Students open a browser, sign in with Google, and start coding. No Python setup, no dependency management, no terminal.

URL: colab.research.google.com

Free-tier includes:

• Python environment with common libraries pre-installed (pandas, sklearn, matplotlib, etc.)
• NVIDIA T4 GPU and TPU v5e accelerators (limited session time)
• Google Drive integration for file storage
• Shareable notebooks via link

When to use browser Colab:

• Pre-program orientation and bridge modules
• First 1-2 weeks of any course (before VS Code setup is complete)
• Quick prototyping and experimentation
• Students who need a fallback when VS Code has issues

3b. Colab Extension for VS Code (High Ceiling)

What: Official Google extension that connects .ipynb notebooks in VS Code to Colab cloud runtimes. Launched November 2025.

Why it matters: Students get VS Code’s full IDE features (Copilot, debugging, Git, extensions) while running code on Colab’s cloud GPUs. Best of both worlds.

Install: VS Code Marketplace

How it works:

1. Open any .ipynb file in VS Code
2. Click “Select Kernel” → choose “Colab”
3. Sign in with Google account
4. Code runs on Colab runtime; results display in VS Code

Current limitations (as of Feb 2026):

• Cannot mount Google Drive (use Git repos or cloud storage for datasets)
• Colab Secrets not available (use environment variables or .env files)
• Session timeouts same as browser Colab (reconnect as needed)

Faculty note: Assignments should be .ipynb files stored in GitHub repos. This works identically whether students use browser Colab or the VS Code extension. Do not design assignments that depend on Google Drive mounting.

4. Google Gemini Pro — AI Research & Writing

What: Google’s most capable AI model with research, writing, and productivity features.

Cost: Free for verified students for 1 year (normally $19.99/month). Full Google AI Pro plan.

How to get it:

1. Go to gemini.google/students
2. Sign up with a personal Gmail account (not @illinois.edu)
3. Verify student status through SheerID
4. Sign up by April 30, 2026

What students get:

Faculty note: Gemini is complementary to Copilot. Copilot is for coding (inside VS Code). Gemini is for research, writing, and analysis (browser-based). Students should use both. Deep Research is particularly valuable for project background research and literature reviews.

5. Claude / ChatGPT — General AI Assistants

What: General-purpose AI assistants for explanation, debugging, brainstorming, and writing.

Cost: Free tiers available for both. Students may also access these through Copilot’s model selector.

MSBAi policy: No vendor lock-in. Course materials should reference “AI tools” generically. When demonstrating specific features, show at least two platforms. Students choose their preferred tools and document usage in AI attribution logs.

6. GitHub — Version Control & Portfolios

What: Code hosting platform with version control, collaboration, and CI/CD.

Cost: Free. Students also get the Student Developer Pack with additional tools.

MSBAi requirements:

• All project code in GitHub repos (public for portfolio)
• Professional README files for all projects
• Commit history shows individual contribution (used in team project assessment)
• GitHub profile becomes the student’s professional portfolio

Student Developer Pack includes:

• GitHub Copilot Pro (see above)
• GitHub Codespaces (60 hours/month cloud dev environments)
• Free .me domain (Namecheap)
• Various cloud credits and tool access

7. Power BI Desktop — Business Intelligence

What: Microsoft’s business intelligence tool for dashboards and data visualization.

Cost: Free (Desktop version). Academic license available through Illinois.

Used in: BDI 513 (Data Storytelling), BADM 557 (Business Intelligence)

Install: Power BI Desktop

8. WRDS — Financial & Accounting Data

What: Wharton Research Data Services. Access to Compustat (firm financials), CRSP (stock returns), and other research databases.

Cost: Program-paid annual license (College expense, not student expense).

Used in: FIN 550 (primary), potentially other courses.

Faculty note: WRDS access should be used alongside open datasets and APIs (yfinance, SEC EDGAR, Kaggle, Census Bureau) so students learn both licensed and open data workflows. Having WRDS as a program-wide resource is a branding differentiator — “Gies provides access to institutional-grade financial data.”

9. AWS — Cloud Infrastructure

What: Amazon Web Services for cloud databases, compute, and storage.

Cost: Free Tier (12 months) + optional student credits.

Used in: BADM 554 (cloud databases), BADM 558 (big data infrastructure)

Student Onboarding Checklist

This is the setup sequence for new MSBAi students during pre-program orientation:

Total setup time: ~70 minutes (excluding bridge module)

Fallback: If GitHub Education verification is delayed, students use Colab in browser + Copilot Free (2,000 completions/month, 50 chat requests) until verified.

Low Floor / High Ceiling: See DESIGN_PRINCIPLES.md Principle 3 for the full progression map from Colab (zero install) to VS Code + Copilot Agent Mode.

Faculty Guidelines

When designing course materials:

1. Assignments must be .ipynb files in GitHub repos. This works for both browser Colab and VS Code users.
2. Do not depend on Google Drive mounting. Use Git repos, direct downloads, or API calls for data access.
3. Reference “AI tools” generically in syllabi. When demonstrating, show Copilot for coding tasks and Gemini/Claude for research/writing.
4. Include AI attribution requirements in all project rubrics. Template in design/assessment_strategy.md.
5. Studio sessions should demo VS Code + Copilot workflows — this is where students see the tools in action and build fluency.
6. Bridge modules handle setup. Courses can assume students have VS Code, Copilot, and Colab working by Week 1.

Tool support responsibilities:

This is the standard tools reference for the MSBAi program. All course technology stacks should align with this page. For program-level details, see program/curriculum.md. For assessment policies around AI tool usage, see design/assessment_strategy.md.