Transcript CIS Undergraduate Open House Presentation

Baruch College
Computer Information Systems
Undergraduate Programs
http://cis.baruch.cuny.edu
1
http://cisnet.baruch.cuny.edu/
Your Presenter
• Richard Holowczak
• Web Site: holowczak.com
2
http://cisnet.baruch.cuny.edu/
What and Where is CIS?
• The intersection of information technology and Business
IT / C.S.
Business
• Developing and Using IT to address Business problems and
opportunities
• Key Role: System Analyst
3
http://cisnet.baruch.cuny.edu/
Computer Science ↔Business
Computer
Science
Data Structures
Programming Languages
Compiler Design
Systems Architecture
Algorithms
Business
Database Management Systems
Programming Languages
Systems Analysis and Design
IT Project Management
Accounting
Finance
Management
Marketing
4
http://cisnet.baruch.cuny.edu/
CIS Within the Business School
• Liberal Arts
• Business Core
• Business Major
– BBA in CIS
– http://cis.baruch.cuny.edu/undergraduate/bba-cis/
• Business Minor
– CIS Minor
– http://cis.baruch.cuny.edu/undergraduate/cis-minor/
• Tier III Minor
– Interdisciplinary Minor in Information Technology and Social
Responsibility
– http://cis.baruch.cuny.edu/undergraduate/tier-iii-minor/
5
http://cisnet.baruch.cuny.edu/
CIS Major – In Brief
Required Courses (12 credits):
• CIS 3100 Object Oriented Programming I
• CIS 3400 Database Management Systems
• CIS 4800 Systems Analysis and Design
• CIS 5800 Information Technology Development and Project Management
Elective Courses:
Any Four Courses from the Following List (12 credits):
• CIS 3367 Spreadsheet Applications in Business
• CIS 3444 e-Business Technologies
• CIS 3500 Networks and Telecommunications I
• CIS 3630 Principles of Web Design
• CIS 3700 Green IT
• CIS 3750 Social Media Technologies in Organizations
• CIS 4100 Object Oriented Programming II
• CIS 4110 Object-Oriented Programming II With Java
• CIS 4160 Web Applications Development
• CIS 4350 Computer Control and Audit
• CIS 4400 Database Management Systems II
•
•
•
•
•
•
•
•
CIS 4500 Networks and Telecom. II
CIS 4550 Networked Inf. Systems Security
CIS 4610 Expert Systems and Technologies
CIS 4620 Financial Information Technologies
CIS 4650 Operating Systems Concepts
CIS 4670 Special Topics in CIS
• Data Mining
• Mobile App. Development
OPR 3300 Quantitative Methods for Acc.
OPR 3450 Quant Decision Making for Bus.
6
http://cisnet.baruch.cuny.edu/
CIS Major – Required Courses
• Four Required Courses:
– CIS 3100 Object Oriented Programming (C++)
•
•
•
•
Geared towards first-time programmers
Logic and structure of software programs
Basics of Data structures
In Practice: Microsoft Visual Studio
– CIS 3400 Database Management Systems
•
•
•
•
•
Geared towards first-time database developers
Design, Logic and structure of databases
Relational Database and Structured Query Language (SQL)
Transaction Processing, Web/DB Integration, other topics
In Practice: Microsoft Access
7
http://cisnet.baruch.cuny.edu/
CIS Major – Required Courses cont.
– CIS 4800 Systems Analysis and Design
•
•
•
•
•
•
System Development Life Cycle (SDLC)
Requirements gathering / Documentation
Technical Specifications / Diagrams
Software Development / Coding / Testing
Deployment / Maintenance
In Practice: IBM Rational
– CIS 5800 IT Development and Project Management
• Construct an information system from start to finish
• Typically taken as an upper senior
• In Practice: Microsoft Project
8
http://cisnet.baruch.cuny.edu/
Elective Tracks – Web Development
• Major Requirements
– CIS 3100 Object Oriented Programming I
– CIS 3400 Database Management Systems
– CIS 4800 Systems Analysis and Design
• Suggested Electives (Pick 4)
–
–
–
–
–
CIS 3444 e-Business Technologies
CIS 3630 Principles of Web Design *
CIS 4160 Web Applications Development *
CIS 4400 Database Management Systems II
CIS 4550 Networked Information Systems Security
• CIS 5800 Information Technology Development and
Project Management
9
http://cisnet.baruch.cuny.edu/
Web Application System
•
•
•
•
•
Web Browser
HTML/CSS
Images/Video
JavaScript
Flash
Applets
Dev. Tools: DreamWeaver,
Expression Studio
HTTP Request
HTML Reply
•
•
•
•
•
Web Server
Static HTML/CSS/etc. Files
PHP
Active Server Pages
CMS
Java Servlets
Ex: MS IIS, Apache, Tomcat, etc.
Data
response
Database Server
• Relational DBMS
Database
query
Ex: Oracle, SQL Server, DB2,
mySQL, Postegres, etc.
• NoSQL DBMS
Ex: Vertica, DynamoDB,
Cassandra, Mongo, JSON stores ,
etc.
10
http://cisnet.baruch.cuny.edu/
Web Application System
CIS 3630 Principles of Web Design 
•
•
•
•
•
Web Browser
  HTML/CSS
 Images/Video
 JavaScript
 Flash
 Applets
Dev. Tools: DreamWeaver,
Expression Studio
HTTP Request
HTML Reply
CIS 4160 Web Applications Development 
Web Server
•   Static HTML/CSS/etc. Files
•  PHP and other scripting langs.
•  Active Server Pages
•  Java Servlets
• CMS
Ex: MS IIS, Apache , Tomcat, etc.
Database
query
Data
response
Database Server
•    Relational DBMS
CIS 3400 Database Management Systems 
Ex: Oracle, SQL Server, DB2, mySQL,
Postgres, etc.
CIS 4400 Database Management Systems II 
•  No-SQL DBMS
Ex: Vertica, DynamoDB, Cassandra,
MongoDB, JSON stores , etc.
11
http://cisnet.baruch.cuny.edu/
Elective Tracks – Financial IT
• Major Requirements
– CIS 3100 Object Oriented Programming I
– CIS 3400 Database Management Systems
– CIS 4800 Systems Analysis and Design
• Suggested Electives (Pick 4)
–
–
–
–
CIS 3444 e-Business Technologies
CIS 4100 Object Oriented Programming II
CIS 4400 Database Management Systems II
CIS 4620 Financial Information Technologies *
• CIS 5800 Information Technology Development
and Project Management
holowczak.com/work-financial-it-initial-thoughts/
12
http://cisnet.baruch.cuny.edu/
Market Data Architecture
Client OMS
Orders
OMS / EMS  
Trading Decisions
Positions
Signals
Increasing Value of Data
Complex
Event Proc 
Risk Mgmt. Systems
Orders
Data
Historical Data /
Tick Data  
Feed Handlers
A / B Merge  
Reference
Data  
Market Data A
Market Data B
Order Routing 
Direct
Market
Access
(DMA)
Analytics 
Exchange /
Market Center
C&S
Network Providers 
CIS 3400 Database Management Systems 
CIS 4400 Database Management Systems II 
CIS 3100/4100 Object Oriented Programming I/II 
CIS 3500 Networks and Telecommunications I 
13
http://cisnet.baruch.cuny.edu/
Elective Tracks – Database Development
• Major Requirements
– CIS 3100 Object Oriented Programming I
– CIS 3400 Database Management Systems
– CIS 4800 Systems Analysis and Design
• Suggested Electives (Pick 4)
–
–
–
–
–
CIS 3700 Green IT
CIS 4100 Object Oriented Programming II
CIS 4160 Web Applications Development *
CIS 4350 Computer Control and Audit
CIS 4400 Database Management Systems II *
• CIS 5800 Information Technology Development and
Project Management
14
http://cisnet.baruch.cuny.edu/
Elective Tracks – App. Development
• Major Requirements
– CIS 3100 Object Oriented Programming I
– CIS 3400 Database Management Systems
– CIS 4800 Systems Analysis and Design
• Suggested Electives (Pick 4)
–
–
–
–
CIS 4100 Object Oriented Programming II *
CIS 4110 Object Oriented Programming II with Java *
CIS 4160 Web Applications Development
CIS 4400 Database Management Systems II
• CIS 5800 Information Technology Development and
Project Management
15
http://cisnet.baruch.cuny.edu/
Elective Tracks – IT Audit
• Major Requirements
– CIS 3100 Object Oriented Programming I
– CIS 3400 Database Management Systems
– CIS 4800 Systems Analysis and Design
• Suggested Electives (Pick 4)
–
–
–
–
CIS 3367 Spreadsheet Applications in Business
CIS 4350 Computer Control and Audit
CIS 4400 Database Management Systems II
CIS 4550 Networked Information Systems Security
• CIS 5800 Information Technology Development and
Project Management
holowczak.com/work-it-audit/
16
http://cisnet.baruch.cuny.edu/
Student Organization :
Computer Information Systems Society
• General interest group in computer
information systems
• Hosts panel sessions and guest speakers on
careers, industry focus and new tech.
• Hosts workshops on web design, SQL, etc.
• CIS Society on Facebook:
• http://www.facebook.com/pages/CISSociety/203542043047119
17
http://cisnet.baruch.cuny.edu/
Microsoft Developers Network Academic Alliance
a.k.a. DreamSpark
• Free, downloadable Microsoft software including:
– Databases: MS Access, SQL Server, LightSwitch
– Development Tools: Visual Studio 2010 and 2012, Kodu Game Lab, XNA Game Studio,
Embedded CE, Windows Mobile and more
– Operating Systems: Windows 7, Windows 8, Windows Server, Virtual PC (for MAC) and
more
– Web / Multimedia Development: Expression Studio, Expression Design, Visual Web
Designer and more.
– Others: MS Visio, Microsoft Project, SharePoint, OneNote, Groove and many more
• Visit BCTC Computing and Technology Student Services:
– http://www.baruch.cuny.edu/bctc/student/index.htm
– Click on the link for: CIS Society MSDN Software Library (a.k.a. DreamSpark) (Free
software for CIS Students)
– Log in with your Baruch e-mail address and password (sent to Baruch student e-mail
account). Use “Forgot your password?“ link to get your pw
– Contact Helpdesk (x101 or email [email protected] if your Baruch e-mail18
address is not on file with DreamSpark
http://cisnet.baruch.cuny.edu/
Random Assortment of Tips
• Identify your “Development environment” – where you will
carry out your homework assignments and projects
– Home PC, Work PC, School computer lab, etc.
– Obtain necessary development software early (VS for CIS 3100 and
MS Access for CIS 3400)
• If you have a Mac, get Bootcamp, VirtualBox or Parallels and
load Windows 7
• Do not neglect the Career Development Center
– Ask for help in setting up / Critique your resume / Do a mock
interview
– Sign up for e-mail alerts on CIS related job postings
– If you have never worked in IT before, do everything in your power
to get an internship
• Join our Facebook Group:
– Computer Information Systems @ Baruch College, CUNY
– http://www.facebook.com/groups/57972470987/
– http://www.youtube.com/user/professorholowczak
19