MAT 366 Spring 2018 | Sp18 »
## Meetings |

MAT 366 Spring 2018 |
## Class agendaCome 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
- Get all the software we are using ready
- Spreadsheets: Excel/Libre Office
- Databases: MySQL, SQLlite, Workbench
- Python 3.x: Anaconda and Pycharm
- 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 - How to control Excel
- Developer tools
- Commands in Excel
Week 2 - Discussion on work done by students during the week.
- Google sheets
- Excel can help us deal with data. It can
- Organize data
- Aggregate data
- Visualize data
- Mine data (i.e. extract information from data)
- List of Excel functions
- Learn to use these functions: COUNT, COUNTIF, IF, LEFT, RIGHT, MID, FIND, AVERAGE, MEDIAN, INDEX, MATCH, VLOOKUP, HLOOKUP, &
- Array functions
- How to use the array function FREQUENCY.
- Naming a dataset.
- Autofill cells.
- Autofill cells with goto: Use goto to select cells; type "=" and enter formula; control-enter.
- Selecting a cell range quickly without scrolling manually.
- Absolute and relative cell referencing
- Sheets within an excel file
- Videos I prepared
Week 3 Introduction - Questions about the material
- Questions about the assignment
Content - Upgrade to Excel 2016; New reference: Slager's Essential Excel 2016.
- Excel online
- Google spreadsheet
- New references for Excel 2016 (password is MAT366)
- Shortcuts to navigate/select tables: Command-arrow;command-shift-arrow
- Go to is F5
- Pivot tables. Chapter 15 from Essentials of Excel.
- Download the source code from github.
- The github revision control, collaborative, cloud repository
- Daily tips: Effect of the apostrophe on an Excel cell.
- Vlookup, Index and Match examples.
Week 4 (Feb 19 - 23) Introduction - Assignment answers
Content - Review of Chapter 15.
- Chapter 17.
Week 5 (Feb 26 - Mar 2) Introduction - Student presentation of Chapters 15 and 17.
- Airport data assignment.
Content - Introduction to Python 3.x
- Introductory guide from another class. It may be useful.
- Install Anaconda. It is an IDE that has many options. Make sure to install Python 3 (and not Python 2). We'll start by using Jupyter notebooks (an interface that looks like Mathematica's interface).
Week 6 (March 5 - March 9) Introduction - Students' questions and presentations.
- 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 - Introduction to Python 3
- See this python guide I compiled.
- 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.
- Other database software.
- SQLite.
- Oracle (not covered here).
- SQL tutorial https://www.w3schools.com/sql/
Week 7 (March 12 - March 16) Introduction - Assignments questions
Content - Python 3 presentation from McKenney's book.
Week 8 (March 19 - March 24) Introduction - 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 - Creating SQL tables and populating them.
- SQL left and right join.
Week 9 (April 2 - April 6) Introduction - Assignment questions
- SQL pizza database assignment
Content - Using python to count the word frequency on a book. (Example Jupyter notebook)
- Array formulas.
Week 10 (April 9 - April 13) Introduction - Assignment questions
- Jackie asked during office hours about an assignment possibly not fully explained in class.
Content - Python applications
- RSA Secret Key (sk) and Public Key (pk) encryption
- RSA numbers
- RSA encryption pages from Textbook "Elementary Number Theory, Cryptography and Codes" by Baldoni, Ciliberto and Piacentini
- Wikipedia page on RSA encryption
- Another nice source for RSA encryption - A paper by Kalinski
- Look at the RSA-encryption.ipynb file in Dropbox.
Week 11 (April 16 - April 20) Introduction - Assignment questions
Content - Review of material.
- Discussion of assignments.
- Presentations.
Week 12 (April 23 - April 27) Introduction - Assignment questions.
- NOTE: We can use the Macintosh lab for Excel related assignments.
Content (under construction) - Mathematical modeling vs. Algorithmic modeling.
- Ways to master skills and learn materials.
- Review of content under this perspective
- Quiz.
- Presentations
Week 13 (April 30 - May 3) Introduction - Assignment questions
- Week 10 assignment: Use functions from file RSA-encoding.ipynb. Will cover more about this today.
Content - Python review: Functions, lists, procedural programming loops, libraries.
- Regarding the assignment "RSA encoding and Elementary Number Theory":
- Arrays in Excel
- Array constants
- Array formulas
- Quiz 2.
Week 14 (May 7 - May 10) Introduction - Assignment questions
Content - Quiz solutions.
- Overview of resources used in the class.
- Blockchain comments
- Internships and jobs
- Courses next semester
- Summer courses recommendations (1) JavaScript in Learn.co and Kadenze 2) Blockchain in coursera and others)
- 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 |