Computer Systems Technology Department

1. Computer Systems Technology Department JUNIOR AND SENIOR YEAR MODULE DESCRIPTIONS PRESENATATION OUTLINE • Brief Description of a typical application • Tasks involved in building the application • Module relationships to these task areas • Interests and skills associated with the Module • Similarities between Modules • Sample job description with focus on Module contents • Topics not covered in the Modules

2. Computer Systems Technology Department MODULE CONTENTS (FOR YOUR REFERENCE)

3. MULTIPLE PLAYER WEB-BASED SCRABBLE GAME SAMPLE SYSTEM PROJECT

4. SCRABBLE SYSTEM DIAGRAM Database SECURITYFIREWALL Web Site Pages Web Site Software Programs TECH CLASSROOM Routers/Network User View

5. SYSTEM ANALYSIS AND DESIGN • Speak to players about game rules • Determine the information to show on the screen • Select dictionary to use to check words • List all the data that should be stored in some database

6. SYSTEM ANALYSIS AND DESIGN (CS506 - CS606 - C706) STUDENT INTERESTS STUDENT SKILLS • Understanding how computer systems solve real business problems • Writing User Specifications in the Unified Modeling Language (UML) - CS506 • Speaking with people doing a job and identifying how automation can help. • Preparing “Use Cases” – brief descriptions that describe how the users will interact with the system – CS606 • Creating a “blueprint” for a system SAMPLE JOB DESCRIPTIONS FROM DICE.COM – Position: Business Analyst Ideally a BA (business analyst) that is technical with perhaps a programming background and deep UML proficiency and exp. They should have excellent communication and documentation skills and be able to present and lead small groups of 5 – 10 people. There will be very consistent and close interaction with the development team. The BA should be able to develop domain models, Sequence and activity diagrams, use cases with a focus on Feature development; as this is an FDD; Feature Driven Design/Development Approach.

7. SOFTWARE DEVELOPMENT / PROTOTYPING (CS508 - CS608 - C708) • Determine the exact steps for a player to make a move and see the board • Figure the logic needed to check if the word can fit on the board • Calculate the score and keep running totals for each player • Make the web pages and user designs come alive on the screen

8. SOFTWARE DEVELOPMENT / OPEN SOURCE (CS508 - CS608 - C708) STUDENT INTERESTS STUDENT SKILLS • Working with various users to develop software by working from the design blueprint • Design interactive GUI interfaces for web and PC systems • Solving puzzles that require you to identify a series of steps • Developing software that uses databases, various web services, and existing commercial code components • Delivering a working system to a user to run a business function SAMPLE JOB DESCRIPTIONS FROM DICE.COM – Position: Software Developer Major media conglomerate in NYC has an immediate need for a Junior/Mid Level Web Application Developer to join their full time development team! As a developer in the group you will be heavily involved in development in VB.NET internet based applications! This is a very exciting and fast paced environment supporting high profile executives for the firm.Specific responsibilities include: Develop new VB.NET Web Applications Convert designs and specifications into web applications Integrate web applications with other web-enabled business applications Design and develop SQL Server databases including store procedures, indexes and views Implement GUIs using HTML, CSS and JavaScript Consult with users to prototype, refine, test and debug programs to meet needs Troubleshoot and debug live applications and applications under deployment

9. WEB PAGE DESIGN • Write “HTML” that makes items appear in a browser • Write small programs to make web page pop up information boxes • Develop the way computer users move from one web page to another • Pick colors and clip art to show to the computer user

10. WEB PAGE DESIGN (CS509 - CS609 - C709) STUDENT INTERESTS STUDENT SKILLS • Using the Web to help businesses operate better • Making web pages using HTML, JavaScript • Designing Web Pages that come to life for the user • Developing web server based software that uses databases SAMPLE JOB DESCRIPTIONS FROM DICE.COM – Position: Web Designer We seek a WebDesigner who enjoys pushing the limits of their craft in a truly unique and privileged environment. The position requires daily interaction with the marketing and product development teams in New York. The position allows for the development of interesting UI*s, unique and interesting content, global design templates, websites and other compelling applications for premier luxury brands and advertisers. You will work with a highly experienced team of artists and developers, designers helping to grow one of the most unique social networking opportunities on the Internet. We want you to be highly motivated with tenacity for innovative visual design.

11. NETWORKING • Determine network language computers will use to communicate • Review physical characteristics of the room • Determine means of backing up network • Identify how much traffic / information needs to be sent over the wires

12. NETWORKING (CS507 - CS607 - C707) STUDENT INTERESTS STUDENT SKILLS • Providing the backbone to handle large communication tasks • Knowledge of “protocols” – special languages or formats of network communication - • Analyzing and diagnosing issues within a complex system. • Configuring key network devices like switches and routers • Designing path of data flow in a wireless network – what nodes are needed, etc. • Format of network design documents SAMPLE JOB DESCRIPTIONS FROM DICE.COM – Position: Network Engineer Day-to-day work includes design, installation, migration and troubleshooting of Data Center switched LAN networks using Cisco products.Load balancing design, implementation, migration and troubleshooting using Cisco Load Balancers.Design, configuration, migration and troubleshooting of DNS and DHCP architectures.Evaluate and understand business needs and integrating them into the data centers. Work with the Network Operation Center for any outages or performance issues pertaining to the data center network.Develop procedures and create timely network documentation.

13. SOFTWARE DEVELOPMENT / OPEN SOURCE (CS503 - CS603 - C703) • Program high transactional systems common in financial services • Develop software that logically connects programs running on different machines • Develop system programs • Integrate new communication devices within systems

14. SOFTWARE DEVELOPMENT / OPEN SOURCE (CS503 - CS603 - C703) STUDENT INTERESTS STUDENT SKILLS • Solving systems problems with high volume of transactions • Writing Software in C++, also using .NET, in an easy-to-use development environment • Designing systems that operate over many machines and platforms • Developing software that uses databases, web services, and existing code components • Using Java software to perform some interesting webpage animation • Developing client/server software that communicate using TCP/IP protocol SAMPLE JOB DESCRIPTIONS FROM DICE.COM – Position: Software Developer Junior level C++ developer for high frequency trading system development to build state of the art cutting edge trading system. 1-2 years of professional C/C++ development experience. Experience with the design and implementation of high performance, low latencies multi-threaded systems in C/C++ on UNIX/Linux. Experience with event-driven server applications receiving high-volume data flow. Solid OO development skills. Knowledge of Financial protocols (FIX) is a plus.

15. DATABASE DESIGN • List all the data elements that are needed by the software and arrange them • Make procedures to back-up the data • Encrypt information to avoid other programs from seeing data • Look at how fast the data is fed to the computers and make adjustments

16. DATABASE DESIGN (CS504 - CS604 - C704) STUDENT INTERESTS STUDENT SKILLS • Cataloging , managing and organizing enterprise information • Identifying information needs, organizing and indexing data into diagrams • Understanding the information resources of a company • Implementing database systems that are secure and reliable • Using the company’s information resources to answer management questions • Sustaining a database or data warehouse, identifying problems and fixing them. SAMPLE JOB DESCRIPTIONS FROM DICE.COM – Position: Database Administrator We are looking for a Database Administrator with Oracle/SQL Server experience to design, document, and implement the structures and processes required to forward the organization's Data. This person will work with the technical staff to implement manageable, integrated, timely, and accurate solutions to business and/or technical issues. Responsibilities include:* Support multiple servers and multiple databases of high complexity with multiple concurrent users, ensuring control, integrity and accessibility of the data.* Develop, implement, and monitor standards and procedures for all database platforms to ensure optimum performance and reliability.* Undertake technical ownership of areas within the scalability, stress testing, and benchmark products.* Review all investigations, analysis, and resolution of database problems.* Compile and maintain documentation including schemas and configurations.* Work with management to develop database strategies to support company needs.* Participate in, and potentially lead, the development of solutions to a variety of difficult engineering issues requiring full grasp of a broad range of database engineering principles

17. SECURITY • Determine how users will identify themselves • Install software (firewalls) to protect the system against viruses • Make sure other parts of the system are following security procedures • Monitor traffic and view history of actions to identify suspicious behavior

18. DATABASE DESIGN (CS510 - CS610 - C710) STUDENT INTERESTS STUDENT SKILLS • Figuring out how people could hack into your network • Understanding how data in network transmission corrupt the system • Learning about the various protection software that is available • Defining network tools and strategies (firewalls) to combat intruders • Diagnosing problems due to security leaks. SAMPLE JOB DESCRIPTIONS FROM DICE.COM – Position: Security Engineer Responsible for further developing and maintaining an effective security program which is designed to ensure the logical and physical protection of data, equipment and software for all resources on the LAN/WAN. This includes the development and implementation of policies, procedures and guidelines, as well as the continual monitoring, testing and evaluation of data security implemented and/or planned in the organization. Technical hands-on administration of security management tools, such as firewalls, intrusion detection systems, vulnerability management systems, etc. Development and implementation of policies, procedures and guidelines related to security matters. Periodically review and verify security configurations and changes on production systems and data networks Evaluate potential new implementations and research and recommend security measures to be addressed and included. Continually monitor and evaluate data security implemented in the organization, work to reduce all risks and investigate security breaches and/or potential breaches. Test the operation of security measures regularly, ensure that the security program provides the necessary safeguards for good business practice. Ensure a level of understanding of security tools, requirements and purposes through training and awareness programs. Broadly experienced professional with strong knowledge of principles and techniques applied in securing operating systems and LANs/WANs, with proficiency specifically in UNIX and Windows-based operating systems. Hands-on position. Must be well versed in networking and current industry issues and trends (firewalls, IDS, VPN management, encryption, vulnerability management, etc.).

19. Computer Systems Technology Department TOPICS NOT COVERED IN THE MODULES • Installation and Maintenance of Desktop Software • Web Graphics Development • Assembling Personal Computer or Devices • Designing a computer for everyday appliances AND…………… THANK YOU FOR YOUR PARTICIPATION !!!!!!!!