Capt. Horatio T.P. Webb
MIS 3300 Introduction to Computers and MIS
Honors Section

Parks -- Spring 2020

Version 4 -- Last Updated 9:15 PM 4/27/2020

NOTICES:

  • I have updated all the map pages to reflect an update in how the Google API key is specified at the top of map pages.
    Changes are shown in blue:
     <script async defer src="https://maps.googleapis.com/maps/api/js?key=your API key here&callback=initMap"> 
  • for Excel Assignments here
  • If you need help see an Excel tutor in #133 or email Emese Felvegi
  • I will be communicating with you via you UH email account.
  • I am eliminating the first assignment. This will perhaps lighten your workload.
  • I have already covered the content in class for the 2nd and 3nd assignments (i.e, maps, and the team EXCEL macro)
  • For the moment you should be focusing on the two homework assignments.
        There is plenty for you to do.
        email me ( parks@uh.edu ) if you have any questions
         put "MIS 3300" as the beginning of your subject line
  • I will be preparing some YouTube videos for the class
  • I will post links to them here and notify you by email.
  • Read the syllabus below closely.
         I have removed ("striken out" using the <s> HTML tag) a lot of things & modified others.
  • There are twenty-nine existing web documents on the syllabus below beginning 3/18.
         They that represent the remainder of the class content. Read them at your leisure.
         I will video present some of them later.

         YMHOS

    Click here for music & video tutorial → 

  • COURSE SUMMARY: This course is a survey of MIS topics with an additional focus on desktop database and spreadsheet modeling.
    TEXTS: None, but see this page for the Excel assignment details
    OFFICE HOURS: 1-2:30 MON and WED, 280E Melcher Hall
    or
    by appointment 713-743-4729
    GRADING: There are three two graded assignments:
    1. There is one set of MS Access and MS Excel assignments (see link below) Due dates vary.
    2. Every student will develop a Google Maps page (Due by last day of class MON APR 27 by emailing a copy of the assignment to parks@uh.edu.
    3. There is one "two-person team" project designed to integrate the database and analysis topics which the team will presented in class on either WED APR 22 or will be due MON APR 27. Email me (parks@uh.edu) your one-page team report for the third assignment.

    All grading issues are handled in-person during office hours. Do not send e-mail to the instructor regarding any grading issue. Grades assigned for drops after WED JAN 29 (last day to drop without receiving a grade) will be based on your current class grade. If you have a failing grade at the time of the drop, you will receive an F otherwise a W.

    1. Access/Excel Assignments (see this page for details) 30%
    2. Google Maps Page (see this detail) 30% 45%
    3. Team Project (see Team Project Description here) 40% 55%
    DATE
    TOPIC
    MON JAN 13  . Computing to 1954
     . The Alan Turing Home Page by Andrew Hodges
     . Turing at Wikipedia
     . Enigma at Wikipedia
     . People
    Lecture 1 Powerpoint Slides
    WED JAN 15  . The ASCII Table  (Counting by various bases)  
    MON JAN 20
    MLK HOLIDAY (no class)

    TUE JAN 21 Last Day To Add A Class

    WED JAN 22  Other Codes: Morse; Phillips (1,2,3)
         The Phillips Code (alpha list 4,688+ codes with encoding)
    . Baudot; EBCDIC
    . Life saving tip: · · · — — — · · · and of course: 30 12
    MON JAN 27 .MIS Framework
    .How computers work
       Programs, translation and internals
     
    WED JAN 29.Transaction Processing history after 1954

    WED JAN 29 Last Day to Drop without receiving a grade
    MON FEB 3
    .Distributed Processing 1983-1993
    .Client-Server Systems Part I (post 1993)
    .The Client-Server Flow model
    .What the server knows about the client (HTTP header to the server)
     
    WED FEB 5 .Client-Server Systems Part II
    . more Computer History
    .Filenames
     
    MON FEB 10.Markup Concepts to 1986 TOOLS:
     . The Bare Bones Guide to HTML
     .GIMP (free image creation edit tool) here
     .NotePad++ (ASCII text editor) here
    WED FEB 12 .Markup Part II  . some basic HTML examples
     . Sample page
     . HTML Forms
    MON FEB 17 .Markup Part III  . CSS (Cascading Style Sheets)
    WED FEB 19 .Programming Part I
     . Declarations, Naming and Arrays
     . If Statements
     . Loops
     . Sequentials (strings and math)
     . Subs and Functions
     . Algorithms and Chunking (Modularization)
    MON FEB 24 .Programming Part II  
    WED FEB 26 .Programming Part III  
    MON MAR 2 .Server Fundamentals I  
    WED MAR 4 .Server Fundamentals II . SQL Reference
    . Sample macro (f163300_sample.xlsm)
    MON MAR 9 - MAR 14
    SPRING HOLIDAYS
    MON MAR 16 . Code samples
    . Soft Introduction to Excel Macros
    .Database Part I
    .Team Project Description
    .Project Spreadsheet
        [right click the link above, then "Save as:"]
    .Inventory Macro (as a text file)
    .Forecasting Examples
    .Excel Charts Discussion
    .Chart spreadsheet example
    .Executive Summary Example
    WED MAR 18 .Database Part II
    .Database History, Nuances and Scale
     . HTML 5 (new tags and canvas)
     .Cloud
     .Responsive Design
     
    MON MAR 23 .Modeling Part I
     
    WED MAR 25 .Modeling Part II Multiple Regression
    Example: Baseball Salaries
    Cluster Analysis: Example Fischer's Iris Data
    MON MAR 30  . Web Services:
         .Gauge Maker Version 2.1
         .Separation Anxiety Puzzle Game Version 1.7
         .Button Maker Version 2
         .Consuming a Web Service: Weather Station Version 2
     
    WED APR 1 .Application Development
    .Encryption
    .One Way Hash (MD5) and standard encryption (DES)
    .The Beale Codes Mystery
    THU APR 2 -- Last Day to Drop
    FRI APR 10 -- Last Day to Drop (REVISED BY UH)
     
    MON APR 6 .Systems Analysis and Design (SDLC aka "waterfall")
    .Agile (Scrum reference card)
     
    WED APR 8 .Project Management/CIOs
    .MIS Management
    • Product or Service?
    • Asset or Expense?
    • Strategic or Tactical?
    • Process (verb) or Object (noun)?
    .IT Audit

    FRI APR 10 -- Last Day to Drop (REVISED BY UH)
     
    MON APR 13 .Internet of Things
    .Barcodes, QR (Quick Response) Codes and UARTS (RFID)
    .Business Intelligence
     
    WED APR 15 .Server-Side Bots and Spiders (here and here)  
    MON APR 20 .Career Planning and Interviewing
       .30 Second Elevator Speech
       .Behavioral Interview Questions
       .Star (Situation Task, Action, Result) (aka PAR))
       .Writing Letters
    .Futures:
     
    WED APR 22 .Team Project Presentations Part 1  
    MON APR 27 .Team Project Presentations Part 2  
    IMPORTANT DATES
    MON JAN 20 MLK Holiday
    TUE JAN 21 Last Day to Add a Class
    WED JAN 29 Last Day to Drop a Class without receiving a grade
    MON MAR 9 - MAR 14 Spring Holidays
    APR 2 APR 10 Last Day to Drop a Class REVISED by UH)
    WED APR 22 In-Class Team Project Presentations Part 1
    MON APR 27 Last Day of Class
    In-Class Team Project Presentations Part 2
    ADMINISTRATIVE NOTES
    • Course Evaluations
      The C.T. Bauer College of Business requires all its instructors to be evaluated by their students. The results of these evaluations are important to provide feedback to instructors on how their performance can be improved. We encourage students to provide feedback to instructors through the evaluation process.
    • Academic Honesty
      The University of Houston Academic Honesty Policy is strictly enforced by the C.T. Bauer College of Business. No violations of this policy will be tolerated in this course. A discussion of the policy is included in the University of Houston Student Handbook which can be seen here. Students are expected to be familiar with this policy. Pay particular attention to the list of behaviors that are considered academic dishonesty in Section 3.02 Academic Dishonesty Prohibited. Items (a) and (h) say:
      • (a) Representing as one's own work the work of another without acknowledging the source (plagiarism). This would include submitting substantially identical laboratory reports or other materials in fulfillment of an assignment by two or more individuals, whether or not these used common data or other information, unless this has been specifically permitted by the instructor; [NOTE: I DO NOT PERMIT JOINT WORK]
      • (h) Using another's laboratory results as one's own, whether with or without the permission of the owner;
    • Accommodations for Students with Disabilities
      The C. T. Bauer College of Business would like to help students who have disabilities achieve their highest potential. To this end, in order to receive academic accommodations, students must register with the Center for Students with Disabilities (CSD) 713-743-5400, and present approved accommodation documentation to their instructors in a timely manner.