Sp18 »

Meetings

MAT 366 Spring 2018

edit SideBar

Class agenda

Come to this page to find out what we are doing during each meeting and what is expected.

We'll meet on Mondays at 4:30 PM.


  • Week 1
  1. Get all the software we are using ready
    • Spreadsheets: Excel/Libre Office
    • Databases: MySQL, SQLlite, Workbench
    • Python 3.x: Anaconda and Pycharm
  2. Decide on a schedule for the semester
    • Equivalent to 42 contact hours (14 weeks* 3 hrs/week) + 6 hrs/week.
    • Discuss time management tools
    • Discuss computing equipment available

Content:

Excel

  1. How to control Excel
  2. Developer tools
  3. Commands in Excel

Week 2

  1. Discussion on work done by students during the week.
  2. Google sheets
  3. Excel can help us deal with data. It can
    • Organize data
    • Aggregate data
    • Visualize data
    • Mine data (i.e. extract information from data)
  4. List of Excel functions
  5. Learn to use these functions: COUNT, COUNTIF, IF, LEFT, RIGHT, MID, FIND, AVERAGE, MEDIAN, INDEX, MATCH, VLOOKUP, HLOOKUP, &
  6. Array functions
    1. How to use the array function FREQUENCY.
  7. Naming a dataset.
  8. Autofill cells.
  9. Autofill cells with goto: Use goto to select cells; type "=" and enter formula; control-enter.
  10. Selecting a cell range quickly without scrolling manually.
  11. Absolute and relative cell referencing
  12. Sheets within an excel file
  13. Videos I prepared

Week 3

Introduction

  1. Questions about the material
  2. Questions about the assignment

Content

  1. Upgrade to Excel 2016; New reference: Slager's Essential Excel 2016.
  2. Excel online
  3. Google spreadsheet
  4. New references for Excel 2016 (password is MAT366)
  5. Shortcuts to navigate/select tables: Command-arrow;command-shift-arrow
    1. Go to is F5
  6. Pivot tables. Chapter 15 from Essentials of Excel.
    1. Download the source code from github.
  7. The github revision control, collaborative, cloud repository
  8. Daily tips: Effect of the apostrophe on an Excel cell.
  9. Vlookup, Index and Match examples.

Week 4 (Feb 19 - 23)

Introduction

  1. Assignment answers

Content

  1. Review of Chapter 15.
  2. Chapter 17.

Week 5 (Feb 26 - Mar 2)

Introduction

  1. Student presentation of Chapters 15 and 17.
  2. Airport data assignment.

Content

  1. Introduction to Python 3.x

Week 6 (March 5 - March 9)

Introduction

  1. Students' questions and presentations.
  2. Office hours by appointment and lab work starting this week. All students need to spend at least two hours in the lab each week.

Content

  1. Introduction to Python 3
  2. Introduction to MySQL.
    • Accessing MySQL on a Linux server: Go to 136dot183dot56dot192/phpmyadmin and log in with firstname/MAT366SPR18 . NOTE: firstname is all lower case.
    • How to upload tables to a database using phpmyadmin.
    • A better interface to a local installation of MySQL is Workbench.
  3. Other database software.
    • SQLite.
    • Oracle (not covered here).
  4. SQL tutorial https://www.w3schools.com/sql/

Week 7 (March 12 - March 16)

Introduction

  1. Assignments questions

Content

  1. Python 3 presentation from McKenney's book.

Week 8 (March 19 - March 24)

Introduction

  1. Assignment questions
  • The SQL assignment numbers 6 - 9 use left join, which we have not talked about, so do not worry about doing it yet. We will cover that in class this week.
  • Here is a tutorial on how to find a subarray from an array. We talked about this earlier. It is an advanced topic and we will talk about it as time allows, since we only meet once a week.
  • The phpmyadmin interface is not working properly. If you are having problems with it, please do the MySQL assignments using a terminal. Details will be explained during office hours and in class.
    • Use puTTY on Windows to log into 136.183.56.192 using port 8087. Use the same username and password as in phpmyadmin.
    • Once you are in the server, type: "mysql -u username -p " where "username" is your user name (I am carbonjo).
    • After you are in mysql, type "show databases;" to see if a database with your name is there.
    • Type "use database-name" where database-name is your database (that has the same name as your username).
    • Type any queries to to the assignment.

Content

  1. Creating SQL tables and populating them.
  2. SQL left and right join.

Week 9 (April 2 - April 6)

Introduction

  1. Assignment questions
    • SQL pizza database assignment

Content

  1. Using python to count the word frequency on a book. (Example Jupyter notebook)
  2. Array formulas.

Week 10 (April 9 - April 13) Introduction

  1. Assignment questions
    • Jackie asked during office hours about an assignment possibly not fully explained in class.

Content

  1. Python applications

Week 11 (April 16 - April 20)

Introduction

  1. Assignment questions

Content

  1. Review of material.
  2. Discussion of assignments.
  3. Presentations.

Week 12 (April 23 - April 27)

Introduction

  1. Assignment questions.
  2. NOTE: We can use the Macintosh lab for Excel related assignments.

Content (under construction)

  1. Mathematical modeling vs. Algorithmic modeling.
    • Ways to master skills and learn materials.
    • Review of content under this perspective
  2. Quiz.
  3. Presentations

Week 13 (April 30 - May 3)

Introduction

  1. Assignment questions
    • Week 10 assignment: Use functions from file RSA-encoding.ipynb. Will cover more about this today.

Content

  1. Python review: Functions, lists, procedural programming loops, libraries.
  2. Regarding the assignment "RSA encoding and Elementary Number Theory":
  3. Arrays in Excel
    • Array constants
    • Array formulas
  4. Quiz 2.

Week 14 (May 7 - May 10)

Introduction

  1. Assignment questions

Content

  1. Quiz solutions.
  2. Overview of resources used in the class.
  3. Blockchain comments
  4. Internships and jobs
  5. Courses next semester
  6. Summer courses recommendations (1) JavaScript in Learn.co and Kadenze 2) Blockchain in coursera and others)
  7. What to expect on the final

Final exam

Monday May 14 at 2 PM in SAMC 384

Page last modified on May 13, 2018, at 10:16 AM

Edit - History - Print - Recent Changes (All) - Search