IST Advising - eREP Database Web Application (Summer 2001, for IST Advising Office)

Objectives:

• Web application written in ColdFusion/HTML
• Application will be used to search, edit and sort student advising information
• Must meet all end user requirements for usability and robustness
• Must be able to import/export data from Microsoft Access database
• Must run on Microsoft IIS server with ColdFusion daemon

Tasks:

• Interview IST Advising staff for user requirements
• Design preliminary user interface in HTML with user base (academic advisors 25-44) in mind
• Obtain and edit Microsoft Access database
• Install Microsoft Access database as ODBC data source for ColdFusion compatibility
• Write ColdFusion queries to supply database functionality to user interface
• Ensure compatibility with new data sets
• Present project to IST Advising staff for user review/suggestions
• Use feedback from IST Advising staff to alter/enhance usability of application
• Present project to IST Advising staff for further review
• Implement project on IST-owned Microsoft IIS server
  

The LION 90.7fm - Web Site Design/Implementation (Spring 2000-Present, for The LION 90.7fm)

Objectives:

• Create Web site design for radio station from scratch
• Use image-heavy design techniques if at all possible
• Ensure that design is functionally sound
• Ensure that design is flexible enough to provide future expansion
• Ensure that design is easily implemented on Microsoft IIS and Apache web servers
• Use any technologies or applications necessary to design site to function for users
• Obtain domain and hosting providers for Web site
• Add new technologies and web applications to site on demand

Tasks:

• Consult with radio station staff as to design needs and desires
• Create preliminary paper design, with target audience (persons 18-49) in mind
• Present preliminary paper design to station staff for feedback
• Create images and generic code for prototype Web site design
• Create prototype Web site design, implementing station staff feedback
• Present prototype Web site design to station staff for feedback and changes
• Construct generic non-dynamic site, implementing feedback from station staff
• Present non-dynamic site to station staff, requesting feedback and further ideas
• Implement dynamic version of site, implementing ideas and station desires using PHP and JavaScript
• Present dynamic version of site to station staff for approval
• Implement new site design on Apache server with PHP and MySQL extensions; place redirection pages on all old URLs
• Train station staff on how to add and modify current site design
• Consult with station staff on bi-weekly basis to elicit feedback on site design and possible additions to site
• Implement site additions and design changes as needed

The PSU FREAK SHOW! - Web Site Design/Implementation (Fall 2002-Present, for The PSU FREAK SHOW radio program)

Objectives:

• Create Web site design for radio show from scratch
• Use PHP includes to provide easy editing access to radio show personnel
• Provide and edit images and audio for release on Web site

Tasks:

• Consult with radio show personnel as to design needs and desires
• Design site for radio show, with target audience (persons 18-24) in mind
• Construct basic applications (picture player, etc) for use in site
• Construct basic site data structure (directory trees, etc) to use when radio personnel is editing site
• Use PHP includes and IFRAMES to ensure that design is portable and easily edited
• Implement site design on Apache server with PHP support
• Elicit feedback from users and radio show personnel to incorporate into next iteration of design
  

MIST - Web Site Design / Implementation (Fall 2002-Fall 2003, for Magazine of Information Sciences and Technology club)

Objectives:

• Work in a team environment to create new web site design
• Create new site design from scratch, with print media look basis
• Ensure that new site design is flexible enough to allow future redesign/addition
• Help other members of Design Team learn basic web design techniques
• Implement new design on Microsoft IIS server

Note: I am now currently on Content Team for this organization, in strictly a multimedia capacity. I have consulted with the current Design Team for, but have not designed, the current scheme of this website, and do not plan to design for this organization in the future.

Tasks:

• Consult with design team for design ideas
• Create viable data structure (directory trees, naming conventions, etc)
• Present design ideas to entire Magazine staff
• Construct design with members of team, with target audience (IST students/faculty 18-49) in mind
• Create and optimize Flash introduction for main page
• Supply documentation for future reference
• Implement design on IST Microsoft IIS server
• Elicit feedback on site design from IST students to incorporate into next iteration of design
  

WEHR East Halls Radio - Web Site Design/Implementation (Fall 2000-Present, for WEHR East Halls Radio club)

Objectives:

• Create Web site design for radio show from scratch
• Provide and edit images for release on Web site
• Implement design on Microsoft IIS server

Tasks:

• Consult with radio station personnel as to design needs and desires
• Design site for radio station, with target audience (persons 18-24) in mind
• Construct basic site data structure (directory trees, etc) to use for future editing
• Implement site design on Microsoft IIS server
• Elicit feedback from users and radio show personnel to incorporate into next iteration of design

IST 440W - IST Writing Across The Curriculum
(Spring 2004, Mr. , with project sponsored by Mr. of )

Tasks:

Deliverables:

IST 421 - Information Technology and Systems Integration II
(Spring 2003, Mr. Brian Cameron, with project sponsored by Mr. Bob Walter of Penn State Applied Research Laboratory)

Tasks:

• Work with Penn State's Applied Research Laboratory (ARL) to modify existing framework for delivering real-time data from vehicles to users
• Develop XML Schema for Parameters and Definition of MIMOSA Data
  (Machine Information Management Open Systems Alliance, governing body for open data exchange standards in machinery environments)
• Create Visual Basic DLL File to Parse and Return Data
• Initiate Parameters to Limit Resulting XML File Size

Deliverables:

• Final Presentation to ARL
• Final Project Documentation
• Working ASP version of final code (now ARL property, demonstrations available upon request)

IST 413 - User Interface Design and Development (Spring 2003, Dr. Michael McNeese)

Tasks:

• Model human environment interactions and use their models to design human machine systems that evidence mutually adaptivity
• Create a model of the brain in action
• Conduct a cognitive task analysis
• Critically analyze a cooperative system that involves systems-computer science elements
• Design an adaptive mind/machine interface (automobile cockpit) using an integrated model of a) the human mind and b) the machine system
• Evaluate an integrated cognitive system in terms of usefulness and usability and employ a living lab framework to improve system performance

Individual Deliverables:

• Final Project Demonstration - Radio Automation System Interface prototype
• Final Project Demonstration - Radio Automation System Interface prototype
• Final Project Documentation

Group Deliverables:

• Final Project Documentation

IST 321 - Information Technology and Systems Integration I (Fall 2003, Dr. Sandeep Purao)

Tasks:

• Understand the Enterprise environment
• Become aware of the Application components that present integration possibilities
• Learn Data, Presentation, and Functional Integration models
• Apply techniques, approaches, and tools for data-oriented integration
• Discover and learn techniques for presentation-oriented integration
• Learn and apply techniques and approaches for function-oriented integration
• Gain understanding of XML, XSLT, and XPath environments

Group Deliverables:

• Second Monday - EAI Final Report
• Second Monday - EAI Demostration XML with XSL Transform
  (works in Mozilla/Netscape/Opera only)
• Second Monday - EAI Demostration XML with XSL Transform
  (HTML Only example for MSIE users)
  

IST 311 - Object Oriented Design and Software Applications (Fall 2003, Dr. Steven Haynes)

Tasks:

• Be able to explain the foundations of the object-oriented software paradigm
• Explain the central issues in software design and development
• Use the Java programming language and some of its core class libraries
• Use and understand the full range of UML diagrams
• Design and create a basic windowed, event-driven application in Java,
  using XML for data storage

Group Deliverables:

• Roommate Matching System (Java Program)
• Roommate Matching System Adminstrator's User Guide
• Roommate Matching System Student's User Guide
• Roommate Matching System
• Roommate Matching System UML Diagrams
  

IST 250 - New Media And The Web (Spring 2003, Dr. Gerald Santoro)

Tasks:

• Comprehensively analyze, plan, and design a real world, entertainment-based WWW site through end user analysis and design documentation
• Appropriately design and develop a real world, e-government-based WWW site through application of basic HTML skills and thoughtful consideration of accessibility issues
• Creatively design and develop a real world, e-sports/e-commerce-based
  WWW prototype through application of and planning for advanced HTML and emerging technologies

Group Deliverables:

• Critical Theory Prototype Site Design
• National Soccer League Prototype Site Design

Individual Deliverables:

• ePortfolio - "Drew Hall .net" (this site)
• Thematic Web Site - The LION 90.7fm
  

IST 220 - Networking and Telecommunications (Spring 2001, Dr. Shaoyi He)

Tasks:

• Gain basic understanding of networking and telecommunications
• Develop ability in applying networking and telecommunication knowledge to specific applications and situations, focusing on Internet, Intranet, and e-commerce applications
• Gain thorough understanding of the OSI (Open Systems Interconnect) model
• Gain understanding of the decisions process and variable to consider in selection of telecommunications and networking systems and technologies
• Develop knowledge of telecommunications history; transmission media; transmission characteristics; error characteristics, detection, and correction; Local and Wide Area Networking applications, hardware, and software; internetworking devices; industry standards, topologies, and protocols; communications management; network security and recovery; information system applications

Group Deliverables:

• Final Networking Consultation Proposal
• Final Networking Consultation Presentation

IST 210 - Organization Of Data (Spring 2001, Mr. Todd Bacastow)

Tasks:

• Exposure to the design and use of relational database systems
• Learn and apply database design using the entity-relationship (E/R) model
• Gain an understanding of the relational model,
• Conduct conversions from E/R models to relations
• Create a relational database system using SQL
• Explore other database languages, both concrete and abstract, including relational algebra, Datalog, ODL/OQL, and parts of SQL3

Group Deliverables:

• Final Project Demonstration Page - English Version
• Final Project Demonstration Page - Japanese Version
• Final Project Presentation

Programming and Scripting Languages:

• HTML (HyperText Markup Language)
• XML (eXtensible Markup Language)
• XHTML
• PHP (PHP: Hypertext Preprocessor)
• ColdFusion
• SQL (Structured Query Language)
• CSS (Cascading Style Sheets)
• UML (Universal Modeling Language)
• Java
• C++
• JavaScript
• ASP (Active Server Pages)
  

Server Technologies:

• Apache Web Server
  - PHP extensions and scripting
  - CGI scripting
• Microsoft Internet Information Server
• MySQL Server
• Microsoft SQL Server
• Macromedia ColdFusion Server
• Microsoft Windows Media Server
• Nullsoft ShoutCast DNAS Server
• Real RealEncoder

Applications Development:

• Microsoft Visual Studio
  - Microsoft Visual Basic
  - Microsoft Visual C++
• Borland JBuilder Enterprise
• Sun Java JDK
• Rational Software Rational Rose
• Microsoft Visio

Web Development:

• Macromedia Studio
  - Macromedia Dreamweaver
  - Macromedia ColdFusion Studio
  - Macromedia Flash
  - Macromedia Fireworks
• Microsoft FrontPage
• Adobe PhotoShop
• Adobe Illustrator

• Adobe Illustrator
• Adobe Photoshop
• Macromedia Freehand
• Macromedia Fireworks
• Microsoft Publisher

Operating Systems:

• Windows XP (Home, Professional)
• Windows 2000 (Professional, Server, Advanced Server)
• Windows NT 4 (Workstation, Server)
• Windows 98, 95
• Linux (Debian, SuSE, Corel and Red Hat)
• MacOS 9, X
• Macintosh System 8.5 through 7
• BeOS
• OS/2