This page has been developed to provide you with access to each of the labs utilized within the Online IST curriculum. The labs have been organized by the course they are associated with. If you wish to obtain a lab you will need to:

1. Locate the course and lab name you wish to download
2. Click on the corresponding download PDF link
   (Note: Downloading a file requires you to have PSU Userid and Password.)

Quick Jump: 110 | 111 | 210 | 220 | 250 | 302 | 421

Online IST 110 IST 110 Lab Title Lab Purpose Resources The Information Age and Microsoft Word Lab The purpose of this exercise is to have you demonstrate your ability to successfully design a document using Microsoft Word as a word processing tool. Download Lab PDF Computer Hardware and Microsoft Excel Lab The purpose of this exercise is to have you demonstrate your ability to successfully design a spreadsheet using Microsoft Excel as a spreadsheet design tool. Download Lab PDF The History of Computing and Microsoft PowerPoint Lab The purpose of this exercise is to have you demonstrate your ability to successfully design a presentation using Microsoft PowerPoint as a presentation design tool. Download Lab PDF Database Introduction and Design Using Microsoft Access Lab The purpose of this exercise is to have you demonstrate your ability to successfully design and develop a fully functional database using Microsoft Access as a database design tool. Download Lab PDF Web Page Development Lab The purpose of this exercise is to have you demonstrate your ability to create a website either by hand coding your HTML pages or using an HTML editor. Download Lab PDF PSU FTP Web Usability Lab The purpose of this exercise is to have you demonstrate your ability to think critically about website usability and to think about how you may improve the usability of a site so that your users visit often. Download Lab PDF Setting Up Your PSU Personal Web Account to Manage a Blogger.com Account The purpose of this exercise is to have you demonstrate your ability to successfully activate your PSU web account, create a directory to store a blog, and publish your blogger.com blog to the space. Download Lab PDF Motion Slideshow, Stop-Motion Animation, or Short Film The purpose of this exercise is to have you demonstrate your ability to create a slideshow, stop-motion animation, or short film, use a digital camera to capture photos or video, edit and produce a 30-60 second multimedia project with iMovie and iLife, and burn the final project to a CD-ROM in QuickTime format, or upload it on a web page to your personal PSU web space. Download Lab PDF Web Page Development Lab with blog and e-Portfolio The purpose of this exercise is to have you demonstrate your ability to create a website either by hand coding your HTML pages or by using an HTML editor of your choice to develop the HTML pages. This site will balance a set of personal pages, with a personal blog, and an ePortfolio. Download Lab PDF Motion Slideshow, Stop-Motion Animation, or Short (40 point) The purpose of this exercise is to have you demonstrate your ability to create a slideshow, stop-motion animation, or short film, use a digital camera to capture photos or video, edit and produce a 30-60 second multimedia project with iMovie and iLife, and burn the final project to a CD-ROM in QuickTime format, or upload it on a web page to your personal PSU web space. Download Lab PDF Web Page Development Lab with blog and e-Portfolio (40 point) The purpose of this exercise is to have you demonstrate your ability to create a website either by hand coding your HTML pages or by using an HTML editor of your choice to develop the HTML pages. This site will balance a set of personal pages, with a personal blog, and an ePortfolio. Download Lab PDF

Online IST 111s IST 111s Lab Title Lab Purpose Resources Creating a Blog The purpose of this exercise is to create a personal Blog. This Blog will be used as a component of your ePortfolio, and serve as an online area for reflection. Download Lab PDF Building an e-Portfolio The purpose of this lab is to have you build basic components of an ePortfolio. This document contains links to ePortfolio templates, which can be used to provide the basic framework of your HTML files. Download Lab PDF Creating an e-Portfolio The purpose of this lab is to have you create an ePortfolio using an HTML editor or text editor. This document contains links to the Penn State ePorftolio initiative, which contains tutorials and documentation that will help you get started. Download Lab PDF

Online IST 210 IST 210 Lab Title Lab Purpose Resources Entity-Relationship Diagram Lab The purpose of this exercise is to have you demonstrate your ability to perform Entity-Relationship (E-R) Diagramming by converting an E-R Diagram into a database schema. Download Lab PDF Data Normalization Lab The purpose of this exercise is to have you demonstrate your ability to take an unnormalized table and normalize it up to the third normal form. Download Lab PDF Creating Databases Using SQL The purpose of this activity is to test your ability to use SQL statements to create a database. Download Lab PDF Correcting SQL Queries used to Manipulate Database Tables The purpose of this activity is to test your ability to identify what is wrong with an SQL statement used to manipulate a database table and fix it. Download Lab PDF Integrity Constraints The purpose of this lab is to demonstrate your ability to implement integrity constraints on tables within a database. Download Lab PDF Generating and Modifying SQL Queries The purpose of this lab is to demonstrate your ability to create SQL queries, as well as trouble shoot and correct faulty SQL queries. NOTE: This lab is a combination of questions from Labs 210.07 and 210.08 Download Lab PDF Using SQL to query a database he purpose of this excersize is to demonstrate your ability to ustilize SQL to query a database. Download Lab PDF Correcting SQL Query Statements The purpose of this activity is to test your ability to identify, fix, and test a series of incorrect SQL queries. Download Lab PDF Generating Database Driven Web Pages The purpose of this activity is to test your ability to create a web page that can connect, pull, and format data generated from a database. Download Lab PDF PSU FTP Populating Databases Through the Web Pages The purpose of this activity is to test your ability to create a web page where a user can enter data into a database. Download Lab PDF PSU FTP

Online IST 220 IST 220 Lab Title Lab Purpose Resources Local Area Network (LAN) Design The purpose of this activity is to test your ability to successfully design a Local Area Network (LAN). Download Lab PDF Wide Area Network (WAN) Design The purpose of this activity is to test your ability to successfully design a Wide Area Network (WAN). Download Lab PDF Remote Access & VPNs The purpose of this activity is to evaluate the use of virtual private networks (VPNs) for remote network access and research solutions to a problem and make recommendations based on the research. Download Lab PDF Network Security The purpose of this activity is to analyze a WAN design and make firewall architecture recommendations. Download Lab PDF Assessing Emerging Technologies The purpose of this activity is to assess the future potential of emerging technologies for a given company situation. Download Lab PDF

Online IST 250 IST 250 Lab Title Lab Purpose Resources Setting up Your PSU Personal Web Account The purpose of this exercise is to have you demonstrate your ability to activate and upload a basic HTML page into you PSU web account. Download Lab PDF PSU FTP Creating a Web Page with Text and Links The purpose of this exercise is to have you demonstrate your ability to update your personal index.html and create a link to another web page. Download Lab PDF PSU FTP Creating New Pages and a Navigation Scheme The purpose of this exercise is to have you demonstrate your ability to create new web pages and a navigational schema for your personal web site. Download Lab PDF PSU FTP Using Graphics, Tables, and Frames The purpose of this exercise is to have you demonstrate your ability to incorporate graphics, tables, framesets, or other HTML features into your web site. Download Lab PDF PSU FTP Completing Your Portfolio The purpose of this exercise is to have you demonstrate your ability to build a personal, web-based portfolio. Download Lab PDF PSU FTP

Online IST 302 IST 302 Lab Title Lab Purpose Resources Project Scoping The purpose of this activity is for you to develop a Work Breakdown Structure (WBS) for the design, development, and implementation of a company's e-commerce website. Download Lab PDF Project Scheduling The purpose of this activity is for you to develop a project schedule for a predefined WBS for the development of a website. Download Lab PDF Risk Management The purpose of this activity is for you to evaluate the current situation with an IT project, identify possible risks, categorize those risks, and create risk mitigation strategies. Download Lab PDF Budgeting The purpose of this activity is for you to examine a Statement of Work (SOW) that indicates the scope of a project, then identify the necassay resources to build the IT system, and associate a dollar value on each resource. Download Lab PDF Project Closure The purpose of this activity is to develop a lessons learned document based off the problem assignment you just completed. Download Lab PDF

Online IST 421 IST 421 Lab Title Lab Purpose Resources Assessing and Selecting a Presentation Middleware Product The purpose of this activity is for you to analyze various middleware presentation products and make a recomendation. Download Lab PDF Comparing PeopleSoft and SAP as ERP Solutions The purpose of this activity is to compare PeopleSoft and SAP, then make a recomendation on which to use in a specific ERP Implementation Scenario Download Lab PDF Applying a Federated Database Solution The purpose of this activity is to analyze and research various database products, then make a recommendation on which to use based on a specific scenario. Download Lab PDF Planning for Implementing an Enterprise Integration Project The purpose of this activity is to analyze a specific scenario, then recommend an integration methodology that could be used to solve a specific problem. Download Lab PDF Applying Change Management Practices The purpose of this activity is to analyze a situation, and then identify which changes are critical to the organization. Download Lab PDF