MSEM-Excel-Python

The JHU MSEM Excel-Python bootcamp home

View project on GitHub

MSEM-BootCamp Wiki

This repo contains content for the MSEM bootcamp class taught as a gentle introduction to:

  1. Useful, yet lesser know and advanced features of Excel.
  2. The Python language, coding constructs and design specification.

The class is fast-paced and can be educational and loads of fun if you listen closely and ask questions!. We will get through as much as we can given time limitations :)

Excel Syllabus

Excel logo

  • Cells
    • Double-click / drag completion
    • Freezing panes
    • Conditional formatting
  • Cell references
    • Absolute references
    • Fixed references
    • Mixed references
  • Statistical and financial functions
  • Mini-boolean logic
    • AND, OR
  • Conditional functions
    • countif(s), vlookup, hlookup, if, sumif(s), iferror

  • Array formulae

  • Pivot tables

  • Developers tab and event-driven widgets

  • Final Assessment exercise

Python Syllabus

Pyhton logo

Software

Course software: Spyder IDE Optional textbook: [Learn Python the hard way] (http://learnpythonthehardway.org/book/)

  • A survey of mainstream programming languages (Python, C++, Java)

  • Pros, Cons and usage

  • Python jump-off
  • Basic syntax – hello_world.py

  • Code blocks, scoping, context

  • Functions and methods

  • Data types

  • Arithmetic operations

  • Input and Output (O/I)

  • Conditional statements

  • Looping constructs

  • Evaluation assignment 1: A restricted operations calculator

  • Object Oriented Programming (OOP)
  • Classes
  • Inheritance

  • Constructors

  • Unified Modeling Language (UML)
  • UML syntax

  • Class diagrams

  • Algorithmic complexity theory (Big-O analysis)

  • Final Assessment exercise

>$ whoami

Disa Mhembere
Johns Hopkins University
MS Computer Science, MS Engineering Management
PhD student Computer Science

email: disa (AT) jhu (DOT) edu