SESSION I: Data Analytics using Python, External APIs & AI (INTERMEDIATE)
Fridays, February 13 – March 13, 1 PM – 5 PM ET
Description
This track is a five-day, hands-on series for community college instructors who want to integrate modern Python, API-driven data, and AI tools into their existing courses. Participants will work through instructor-provided labs in Google Colab, Excel (via Python add-ins), Streamlit, and Power BI that they can take back and reuse or lightly adapt in their own classes. The emphasis is on practical, low-friction activities that expose students to real-world data, basic AI capabilities, and interactive analytics, while minimizing prep time and infrastructure needs for both faculty and students.
NOTE: This track closely mirrors the content covered in the Summer III 2025 Working Connections offering, “Advanced Data Analytics – Machine Learning with Python, Power BI & Excel.” Participants who completed that 2025 track are encouraged to select a different option, as the material will be largely overlapping.
Certification Prep
While not tied to a single certification, this track can support preparation for:
- Entry-level data analytics and BI certifications that expect basic Python, API, and dashboarding familiarity (e.g., vendor-neutral data analytics microcredentials)
- Microsoft Power BI–related skills validation where Python visuals and scripting are considered a plus
- Institutional or system-level “AI literacy” or “data literacy” badges that emphasize applied tools in common teaching environments
Objectives
By the end of this track, participants will be able to:
- Design Colab-based labs that use Python and external APIs (e.g., finance and crypto data) to support course outcomes in computing and data-related classes.
- Implement Python-powered activities in Excel, Streamlit, and Power BI that introduce students to AI-assisted analysis and visualization.
- Adapt provided lab templates and code samples to align with their own course learning objectives, student populations, and institutional constraints.
- Evaluate which tools (Colab, Excel + Python, Streamlit, Power BI) are most appropriate for different course levels and assignments, then integrate them into syllabi and weekly teaching plans.
Pre-requisites
Attendees should:
- Have basic familiarity with Python (variables, functions, simple data structures) or equivalent experience in another programming language.
- Be comfortable using spreadsheets (Excel or similar) and basic file management in a web browser.
- Have experience teaching (or planning to teach) courses in CIS, CS, data analytics, business analytics, or related fields.
- No prior experience with Streamlit, external APIs, or Power BI is required.
Required Textbook
No required textbook. All materials (notebooks, slides, lab sheets, and example code) will be provided digitally.
Suggested/optional Textbook
- An introductory Python for data analysis book or OER resource
- Online vendor documentation for Power BI, Streamlit, and Python-in-Excel tools. These are recommended for deeper follow-up but not needed to complete the track.
At-Home Computer Requirements
- A laptop or desktop capable of running a modern web browser (Chrome/Edge/Firefox)
- Reliable internet access to use cloud-based tools (Google Colab, Streamlit Community Cloud, Power BI service)
- A working installation of Microsoft Excel and Power BI Desktop (Windows strongly preferred for Power BI compatibility)
- Permission to install add-ins or lightweight tools as needed (for Python in Excel scenarios)
Please note that content is subject to change or modification based on the unique needs of the track participants in attendance.
Agenda
Feb. 13 – Google Colab & External APIs
- Class Introductions and goal setting for integrating these tools into community college courses
- Introduction to Google Colab and Python refresher
- Using yfinance and cryptocurrency/market APIs (e.g., Coingecko) in Colab
- Exploring datasets from Kaggle in Colab and framing them as student labs
Feb. 20 – Python in Excel (Boardflare or similar)
- Installing and configuring a Python-in-Excel add-in
- “Hello World” in Excel with Python functions
- Using functions such as WORDCLOUD, EXCHANGE_RATE, and VADER_SENTIMENT to create spreadsheet-based labs
- Explore how to obtain a free Mistral AI API key and call its LLM from Python in Excel to power AI-assisted spreadsheet activities.
- Exploring AI helper functions (e.g., AI_CHOICE, AI_ASK, AI_LIST, AI_TABLE)
- Open exploration and adaptation time for participants to prototype their own Excel labs
Feb. 27 – Streamlit I
- Introduction to the Streamlit framework and the framework’s app-building mindset
- “Hello World” Streamlit app from a Colab/Notebook workflow
- Deploying Streamlit apps to a hosted environment (e.g., Community Cloud)
- Creating a simple multipage app suitable for a student project
- Exploration time to refine or extend sample apps
Mar. 6 – Streamlit II (Chatbots & AI Apps)
- Recap of Streamlit basics and architecture
- Building chatbot-style apps: Echo bot, Chat bot, and AI-augmented chat bot.
- Discussing instructional uses: demos, guided labs, and capstone mini-projects
- Work time to customize chatbot labs for participants’ own classes
Mar. 13 – Power BI & Python
- Power BI quick start: importing data and building basic reports
- Importing data using Python scripts within Power BI
- Transforming data using Python in Power Query or Python visuals
- Visualizing data with Python libraries (e.g., Seaborn) inside Power BI
- Designing a complete Power BI + Python lab that students can perform in one or two class sessions
Instructor
Chris Santo is residential faculty in the Mathematics, Computer Science, and Engineering Division at Scottsdale Community College, part of the Maricopa Community College District, where he teaches courses in Java programming, data structures, data analytics, Tableau, Power BI, and Python for data analytics. He has taught mathematics, computer science, and computer information systems courses across multiple Maricopa colleges, including Glendale, Paradise Valley, Scottsdale, Rio Salado, and Mesa Community College, since 2008.
Chris has more than 30 years of experience in the information technology sector, spanning roles in computer lab management, technical support, systems administration, application development, database programming, systems integration, project management, IT management, and reliability-focused consulting. His work bridges industry and academia, using data analytics and advanced IT solutions to improve enterprise operations while mentoring the next generation of technologists.
He also teaches in the Master of Information Studies program at Trine University and is a Certified Reliability Leader (CRL). Chris is currently pursuing a Ph.D. in Computer Science with a concentration in Artificial Intelligence at the University of Southern Mississippi, and holds an MS in Computer Science (Cybersecurity and Big Data, with distinction) and an MBA from Arizona State University, an MS in Information Sciences and Telecommunications from the University of Pittsburgh, and a BS in Mathematics and Computer Science from PennWest California.