course calendar home
Lab 1 - lab set-up and data exploration with Excel, PowerPoint and Access
In this lab you'll get set up (activate web publishing and create a personal INFO424 web site), then follow guided instructions for creating charts and graphs using Excel, PowerPoint and Access. If you have time, you will seek out your own data set and practice importing and formatting that data to do more exploration on your own.
1. Login on the lab machines
Use your iSchool username & password to log in (for incoming students, these were handed out during orientation)
If you don't have your iSchool account information, log in under 'labs' rather than 'iSchool' using your UW NetID and password.
You can get your iSchool account info by sending the following info to help@ischool.washington.edu:
- Full name
- UWNetID
- Student number
- iSchool program that you are in
2. Create a lab web page
- If you haven't already activated your web publishing, and created a personal home page, go HERE for instructions to do so
- Use the secure FTP program (ask a neighbor or the TA if you've never done this or forgotten how) to link to your web directory and create a folder called "INFO424" in your "public_html" folder. Put your class web page there (NOTE: case matters - use "INFO424" not "info424" so we can find your site)
- Create an HTML page. We realize that not everyone in the class has experience creating web pages. That's fine. Here is a template which you are welcome to use or not (save it to your computer and modify it). Feel free to ask for help if you don't have experience making web pages
3. Explore Excel, PowerPoint & Access graphing/charting capabilities
4. Create your "lab report"
- The generic instructions for writing up your lab reports are HERE
- For this lab, the "results" section will consists of your graphs/charts
- One strategy for getting your images onto your web site is to do a screenshot, paste it into Paint or your favorite image editor, crop the image to the size of your chart, save it as a jpg file, and paste it into your web page using the "img" tag. [If this sentence is jibberish, fear not, ask a neighbor or the TA]