MIS 100 Lab Assignments

  1. Finding information online is an important task. It is important to be able to find the correct information within a reasonably short period of time. Find answers to the following trivia questions. Identify the page listing the answer and the search tool used.
    1. List three celebrities who died in 2009.
    2. What is today’s Euro/Dollar exchange rate (for large commercial transactions).
    3. What is the population and per capita income of Venezuela?
    4. Who won the Tour de France in 2009?
    5. What is the largest capacity solid-state laptop disk drive that you can buy?
  2. Create a simple spreadsheet to forecast sales
     Increase5%
     Sales 
    Region2008Forecast
    North257270
    South392412
    East159167
    West552580
     13601429
  3. Use Rolling Thunder to obtain the Sales by Model type (Export Data button on the main screen). Bring the data into Excel and create a graph. Use the Web site HandIn to submit the assignment.
  4. Create a Web page with a table of Sales data by four regions for three years (years in columns). Create at least two links so that when the user clicks on the name of the region, they get a page displaying detailed sales by product for that region.
  5. Rolling Thunder database queries. Create the queries to answer the following questions. Copy and paste the SQL statements into a document and use HandIn to submit it.
    1. List the customers from Stockton, Fresno, or Modesto California.
    2. How many road bikes with a FrameSize less than 54 cm were sold in 2002?
    3. Which employee sold the most full suspension bikes by value in 2001?
    4. What is the average number of days between order and shipping for bicycles built in 2001?
  6. Rolling Thunder report. Create a report that shows sales for December 2006 with subtotals by Model Type. Include a chart at the end of the report.
  7. Go to Thawte and investigate the process for obtaining a free certificate to encrypt your e-mail. How hard is it to obtain a certificate and install it in Outlook? How does Thawte handle the issue of authenticating a user's application? Do you think this method is secure?
  8. Create a short file in Word. Create a password to encrypt and save it. Share it with the other members of your team who will add their names. Briefly describe any problems you might have with telling them the password—if you are not located in the same room.
  9. Microsoft Access forms. Create a common order form using Microsoft Access.
  10. Working in a group of five people, divide the U.S. into five regions. Each group will write a query to compute total sales of Rolling Thunder for one of the regions for 2000-2005. Use the SharePoint system to create a spreadsheet that contains charts for each of the regions/groups.
  11. Set up a Groove session with at least one other person. Work on a Word document together. Add your names and some comments. Test the Protection/Track Changes feature. Hand in the final document.
  12. Take the sales data for full suspension mountain bikes from Rolling Thunder by month for the last three years and use Excel to forecast the potential sales for the next six months.
  13. Build a PivotTable for Rolling Thunder sales.
  14. Find an accounting statement for Sun computers. Draw graphs showing the Sales, Net earnings, and Assets for the most recent three years.
  15. Briefly explain what happened to Washington Mutual bank in the fall of 2008. In particular, describe their strategy and what happened.
  16. As a team, find two software packages that could be used to run a medium-sized restaurant. Briefly compare the features.
  17. Use Microsoft Project to create a GANTT chart for a small project. See Chapter 13, Exercise 11.
  18. What is computer forensics? What is the most important first step in analysis? Find a description of a tool used by forensic analysts.