Fall Semester, 2008
FMIS 2201-3,4;5,6 Information Technology (IT) in Business

SYLLABUS
FMIS 2201-3,4: 11:00 - 11:50 MWF, LSBE 118, Dr. Person
FMIS 2201-5,6: 12:00 - 12:50 MWF, LSBE 118, Dr. Person

Name of Course: FMIS 2201-3,4;5,6 Information Technology (IT) in Business
Term: Fall Semester, 2008
Room and Meeting Times:

FMIS 2201-3,4: 11:00 - 11:50 MWF, LSBE 118
FMIS 2201-5,6: 12:00 - 12:50 MWF, LSBE 118

Course Web Page: http://www.d.umn.edu/~hperson/2201/2201.htm

UMD Catalog Description: (3 cr, A-F only)
Introduction to information technology (IT) concepts; computer hardware and software; use of personal productivity tools (spreadsheet, database, and presentation software); system development processes; Web technologies; applications of IT in business processes.

Name of Instructor: Henry B. Person, Ph.D.

Instructor's Home Page: http://www.d.umn.edu/~hperson/

Office Address: Finance and MIS Dept., LSBE 335 Dept. of Finance and MIS (FMIS)

Office Telephone: (218) 726-8559

Office Hours: 3:00 - 3:50 M;   2:00 - 2:50 WF; and by appointment.
    If the office door is *open*, then you are welcome to drop in without an appointment.
    If the office door is *closed*, then please come back later.

Email: hperson@d.umn.edu
    For better service please use email subject FMIS 2201 (your own last name, first name here).
    If your email message subject is blank or suspicious the email message may not be read.
    Please do not send email attachments to the instructor.

• The "FMIS 2201 course pack for 2008-2009" includes these two required textbooks that can be purchased as a shrink-wrapped package at the UMD Bookstore with course pack ISBN 1-4239-1928-9 for $166.50 (new).
  
  
  • "Fundamentals of Information Systems," 4th edition, by Stair/Reynolds
    (Thomson/Course Technology, 2008, hardcover, ISBN 1-4239-0113-4)
    (includes MIS Companion CD and access code to student online companion Web site at www.course.com/mis/stair )
    
    
  • Microsoft® Office 2007: Introductory Concepts and Techniques (Windows Vista Edition),
    by Shelly/Cashman/Vermaat (Thomson/Course Technology, 2008)
    softcover binding ISBN 978-1-4239-1228-6
    
  
  
• Note: As a lower cost alternative to printed textbooks, CourseSmart.com is in the beta phase of selling eTextbook (digital) versions of both of our required texts:
  
  • As of August 26,2008: eTextbook $57.49 (180 day subscription)
    Microsoft Office 2007: Introductory Concepts and Techniques, Windows Vista Edition by Shelly/Cashman/Vermaat
    eText ISBN-10: 1-4354-0805-5 eText ISBN-13: 978-1-4354-0805-0
    
  • As of August 26,2008 some price info is not yet available:
    eTextbook $??.?? (180 day subscription)
    Fundamentals of Information Systems by Stair and Reynolds
    eText ISBN-10: ?-????-????-? eText ISBN-13: ???-?-????-????-?
    
  • For more information go to CourseSmart help
    
  
  
• Note: If you shop the Web (e.g. Amazon.com or HalfPrice.com etc.) for a new or used hardcopy of the individual texts above, it is acceptable to substitute the following XP Edition for the Vista Edition, particularly if you are running Windows XP:
  "Microsoft Office 2007: Introductory Concepts and Techniques (Windows XP Edition),"
  by Shelly/Cashman/Vermaat (Thomson/Course Technology, 2008)
  softcover binding ISBN: 1-4188-4327-X, ISBN 13: 978-1-4188-4327-4
  softcover spiral binding ISBN: 1-4188-4328-8, ISBN 13: 978-1-4188-4328-1
  
  
• Notes: regarding student supplements to the "Fundamentals of IS" 4th Edition text:
  
  
  • The "red passcode card" on the inside front cover of the 4th edition is not required for this course.
    If you are planning to major or minor in MIS it is recommended that you go to
    www.course.com/mis/stair and click the link to
    "Fundamentals of Information Systems, 4th Edition, Student Online Companion
    and enter the passcode printed on the back of the "red passcode card" to gain access to video and podcast media to supplement the text with current events.
    
    
  • The "MIS Companion" CD on the inside back cover of the 4th edition is not required for this course.
    We are using the full-blown version of SAM Office 2007 in this course, rather than this SAM powered brief sampling of selected MIS topics on the MIS Companion CD.
    If you are planning to major or minor in MIS it is recommended that you install the MIS Companion CD and learn from the training topics.
    

Students are required to have access to the following computing resources:

• A live Internet connection (56K or better)
• Microsoft® Windows Vista (SP1), or Windows XP (SP3).
• Microsoft® Internet Explorer 7, or Internet Explorer 6.
• Microsoft® Excel 2007
• Microsoft® Access 2007
• Microsoft® PowerPoint 2007

The University of Minnesota has entered into a campus agreement with Microsoft® to provide students with a choice of an upgrade to one version of Microsoft® Windows (XP or Vista), and one full version of a Microsoft® Office suite.

Go to http://msca.umn.edu and click on "Order Software" to log in with your UMD userid and UMD password, and order your CDs.
The download option is not recommended.
Our understanding is that your login is screened to make sure you are properly enrolled with no holds.
The student cost of the media is less than $12.
You can pick up your media at the UMD Bookstore Computer Corner soon after ordering.
More campus agreement software information is at: U of M Software Options for Students.

The Labovitz School of Business and Economics (LSBE) laptop initiative requires all LSBE students enrolled beginning Fall 2008 to have a laptop or tablet (Microsoft Windows- OR Apple-based system).
Exempt from this requirement are Seniors who will be graduating by December 2008.

The Labovitz School of Business and Economics (LSBE), through the LSBE Technology Program, has entered into an agreement with Cengage (formerly Course Technology)/Thomson to provide each student in this course with a free SAM UserID and SAM Password to access the SAM 2007 Training and Assessment server.

SAM 2007 ver 3 is powerful and easy-to-use training and assessment software that helps you learn Microsoft® Office 2007 applications.

SAM 2007 is supported on the LSBE loaner laptops for check out from LSBE 49 by students who paid the LSBE Technology Fee.
SAM 2007 is supported in the UMD Full Access computer labs for use by the few students who may have paid the UMD Full Access Computer Lab Fee
SAM 2007 is compatible with Windows Vista (SP1) or Windows XP (SP3); Microsoft® Internet Explorer 7, or Internet Explorer 6.
SAM 2007 is not supported by Mozilla Firefox, Safari, Opera, or other browsers.

If you want to install SAM 2007 on your own computer, check out the specific hardware and software requirements as follows:
Go to SAM Central at http://samcentral.course.com/
On the left of the SAM Central screen under "Our Products" click the link to "SAM 2007" and then under SAM 2007 click the link to "System Requirements."

For additional help installing and/or using SAM 2007 at UMD LSBE go to Dr. Person's SAM 2007 FAQ for LSBE Students and Faculty at URL http://www.d.umn.edu/~hperson/SAM/sam2007faq.htm

Note: The LSBE Technology Fee cannot be refunded.

Grading Criteria:

WebVista Exams (9) over Microsoft® Windows and Office 2007: Excel, Access, and Power Point	20%
Participation, SAM Training and Assessments, Hands On Projects	30%
In-Class Midterm Examination 1	10%
In-Class Midterm Examination 2	10%
WebVista Exams (8) over Fundamentals of Information Systems (IS)	15%
In-Class Final Examination over Fundamentals of Information Systems (IS)	15%
Course Total:	100%

Course letter grades will be assigned as follows:

93 or above:	A
90 to 92:	A-
87 to 89:	B+
83 to 86:	B
80 to 82:	B-
77 to 79:	C+
73 to 76:	C
70 to 72:	C-
67 to 69:	D+
60 to 66:	D
59 or below:	F

1. Students are responsible for information contained in the official syllabus (this document).
2. Assignment due dates and times will be shown in future updated versions of this syllabus (this document) based on actual progress in lectures. Assignment due dates will also be announced in class.
3. Beginning Fall Semester 2008 all LSBE students (except seniors graduating in December 2008) should meet the LSBE Laptop Requirement.
4. To earn full credit for an assignment, it must be complete and correct before the due date and time.
5. Late assignments will not be accepted for grading without evidence that the student is dealing with a situation that is beyond his/her control (illness, etc.).
6. Assignments are to be completed in an "open" (unscheduled) lab environment or on your own computer.
   There is no scheduled time in which you must attend the computer lab.
7. Students take their in-class midterm and final examinations with the section in which they are enrolled.
8. Make-ups for in-class examinations require the instructor's approval in advance of the examination along with evidence that the student is dealing with circumstances that are beyond his/her control.
9. Make-ups for WebVista and SAM 2007 Web-based examinations require the instructor's approval to obtain the password to access a SAM Makeup Exam.
   After you have completed any Web-based Makeup Exam, email the instructor to have your makeup score officially recorded.
10. A course grade of "incomplete" will not be given without advance approval of the instructor and a written, signed agreement with the student for removing the incomplete.
11. Students are responsible for abiding by the UMD Policy on the Appropriate Use of Information Technology.
12. The in-class final examination is required of all students.
13. The course is over at the end of the scheduled final examination period.
    Any grading issues regarding assignments or exams should be resolved before the final examination.

• In this class, our use of Web technology will sometimes make students' names and U of M Internet IDs visible within the course website, but only to other students in the same class, and only in a secure, password-protected section of the course website. This should not increase the risk of identity theft or spamming for anyone in the class. However, if you have any concerns about the Web visibility of information, please contact me for further information.

Individuals who have any disability, either permanent or temporary, which might affect their ability to perform in this class are encouraged to inform the instructor at the start of the quarter. Adaptation of methods, materials, or testing may be made as required to provide for equitable participation. Please contact Penny Cragun at UMD Disability Services and Resources (DSR) Center.

1. File downloads and links to relevant Web pages at Dr. Person: FMIS 2201-3,4;5,6 Course Web Page
2. Optional Fundamentals of Information Systems (4/e): Student Online Companion Web site requires "New User Registration" using the pass code on the back of the red card in the text, and then provides links to Classic Cases, Useful Web Links, Hands-on Activities, Test Yourself on Fundamentals of IS, Glossary of Key Terms, and Online Readings.
   
3. Shelly/Cashman Web site supports the Shelly Cashman Microsoft® Office 2007 series of text books.
4. UMD Tutoring Center provides schedules for tutors for this course.
   You may email the Tutoring Center at tutoring@d.umn.edu or go to Solon Campus Center 40 for the tutor schedule.
5. UMD Information Technology Systems and Services (ITSS) Home Page has several links to help you use the computing resources at UMD.
6. UMD: ITSS: Computer Labs Quick Help shows location and availability of workstations in student computer labs.
7. UMD ITSS Student Technology Assistance Center (STAC) is a walk in help center for students.
   There is no charge for STAC help provided to students.
8. Microsoft® Windows® Family for Windows Vista, Windows XP, and other members of the Windows family of operating systems.
9. Visit Microsoft® Office Online for Microsoft® Office 2007 support.

WEEK 1

• Handout: FMIS 2201-3,4;5,6 IT in Business: "First Day Handout"
• Call roll, resolve any waiting list situations
• Short course assessment quiz (not graded)
• Course introduction

• If you have never used Microsoft® Windows before, it is suggested that you take the Windows Tour.
  In Windows XP click the "Start" button, then select "Programs," select "Accessories" and then choose "Tour Windows XP."
  
  
• If you have never used a Web browser such as Microsoft® Internet Explorer before, it is suggested that you Study the following:
  In Windows XP select Start > Run > Programs > Internet Explorer and on the main menu select Help.
  Read these Help Topics: "Getting Started with Internet Explorer" and "Finding the Web pages you want"
  
  
• Important: Make sure that you know your UMD USERID and PASSWORD:
  All students were given a UMD userid and password to use during the UMD registration process.
  This information is to help those students who may have forgotten their UMD userid or password.
  
  If you forgot your USERID then go to any Web-capable PC, run a Web browser,
  go to the UMD Home Page at HTTP://WWW.D.UMN.EDU and click the People button.
  On the "Search for People at the University of Minnesota" screen select "Search by Name"
  enter your own name and click the Search button.
  Your USERID displays as the first part (up to 8 characters) of the "Email Address" field before the @ sign.
  
  If you know your userid but forgot your PASSWORD then
  call the UMD HELP desk at extension 8847 and ask for a new password.
  Your password will then be reset and you will be given a new password.
  
  
• Read: the official syllabus (this document), particularly the policies section above.
  All students enrolled in this course are responsible for the information contained in the official syllabus (this document).
  New information will be added to this syllabus in the recent updates section above.
  If you choose to print the current draft of this syllabus it is about 15 pages.
  
  
• Suggested Self Test for Windows Vista users: Windows Vista: Learn It Online. you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  
  
• Suggested Self Test for Windows XP users: Windows XP: Learn It Online. Under Project 1 you can try:
      "Project Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," "Crossword Puzzle Challenge," or "Search Sleuth."
  
  
• Suggested Self Test for IE 6 users: Internet Explorer 6: Learn It Online. Under Project 1 you can try:
      "Project Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," "Crossword Puzzle Challenge," or "Search Sleuth."
  
  
• Suggested Self Test for IE 7 users: Internet Explorer 7: Learn It Online. Under Chapter 1 you can try:
      "Project Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  

WEEK 2

• Read: Shelly/Cashman/Vermaat: Essential Introduction to Computers, pages COM 2 - COM 23 (22 pages).
  
  
• Read: Shelly/Cashman/Vermaat: How to Purchase a Computer, pages COM 24 - COM 38 (15 pages).
  
  
• Suggested: Learn It Online (described on page COM 39) where you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  

Required: Log in to the MyU Portal at http://myu.umn.edu and on the MyU home page click the "My Courses" tab.
In the courses you are taking click the FMIS 2201 WebVista link for your section
open the Microsoft Office 2007 folder
Take the Office 2007 -- Test COM over "An Essential Introduction to Computers"
This quiz has 25 short answer (T/F or M/C) questions, and a 25 minute time limit.

• Read: Shelly/Cashman/Vermaat: Introduction to Microsoft Windows Vista
  pages WIN 1 - WIN 65 (65 pages).
  or
  Read: Shelly/Cashman/Vermaat: Introduction to Microsoft Windows XP
  pages WIN 1 - WIN 65 (65 pages).
  
  
• Suggested: Learn It Online (Windows Vista version) where you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  or
  Learn It Online (Windows XP version) where you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  

• finish work on Windows

Required: Log in to MyU at http://myu.umn.edu and click the "My Courses" tab.
In the courses you are taking click the FMIS 2201 WebVista link for your section
open the Microsoft Office 2007 folder
Take the Office 2007 -- Test WIN over "Windows" (concepts that are common to both XP and Vista).
This quiz has 40 M/C questions, and a 40 minute time limit.

Required: Follow the instructions at SAM FAQ: SAM 2007 Initial Login to
(1) have your SAM 2007 Password emailed to you, and then
(2) log in to SAM 2007 for the first time.
Note: When you log in to SAM 2007 and choose Exam Type "CourseAssess" you will see a SAM Assignment "Windows for warmup only" that is not to be graded, but for you to try out.

WEEK 3

• Read: Shelly/Cashman/Vermaat: Excel 2007: Chapter One:
  "Creating a Worksheet and an Embedded Chart," pages EX 1 - EX 69 (69 pages).
  This reading shows how to build the "Walk and Rock Music" worksheet discussed in lecture.
  
• In Class: Lecture on Excel 2007 Chapter 1: Student Data Files for Download
  
  download WalkAndRockMusic_Figure_1-31.xlsx Excel 2007 workbook
  download WalkAndRockMusic_Figure_1-31.xls Excel 97-2003 workbook
  

• Suggested: Learn It Online (described on page EX 70) Under Chapter 1 you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  

• use this class time to finish reading Excel 2007 chapter 1,
  complete the required WebVista Test Excel E1,
  do the optional Training for SAM Exam Excel - E1, and
  complete the required SAM Exam Excel - E1.

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Microsoft Office 2007 folder
and take the Office 2007 -- Test Excel E1

Recommended: Log in to SAM 2007 at http://sam2007.course.com and do the Training for SAM Exam Excel - E1
This training has 15 Excel 2007 tasks.
These tasks will be on SAM Exam Excel - E1
This training is not graded, and can be repeated as many times as you need.
Your goal is to master each task as the "apply" level of training.

Required: Log in to SAM 2007 at http://sam2007.course.com and take SAM Exam Excel - E1
This exam has 15 Excel 2007 tasks, presented in random order.
You may try up to 3 attempts to perform each task correctly.
There is not a time limit for this SAM Exam.
You may retake this exam once if you choose. If you retake the SAM Exam your grade would be the higher of your two scores.

OR as an alternative to doing "SAM Exam Excel - E1" online you may do the following "makeup option":

Do "In The Lab 1: Annual Cost Of Goods Worksheet" on pages EX 74-75 of your Office 2007 text.
Enter your own full name and section time and day into Cell A9 so that they show when you print your worksheet.
Print your completed worksheet as requested in step 9 on page EX 75. Black and White printing is OK.
Hand in your hardcopy printout for "Kona's Expresso Coffee" to the instructor's mailbox in LSBE 335.
This makeup option is due at 4:30pm on Monday, September 29, 2008.

WEEK 4

• Read: Shelly/Cashman/Vermaat: Excel 2007: Chapter 2:
  "Formulas, Functions, Formatting, and Web Queries," pages EX 81 - EX 144 (64 pages).
  This reading shows how to build the "Silver Dollars Stock Club" worksheet discussed in lecture.
  
• In Class: Lecture on Excel 2007 Chapter 2: Student Data Files for Download
  
  download SilverDollarsStockClub_Figure_2-4.xlsx Excel 2007 workbook
  download SilverDollarsStockClub_Figure_2-4.xls Excel 97-2003 workbook
  

• Suggested: Learn It Online (described on page EX 70) Under Chapter 2 you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  

• finish work on Excel 2007 chapter 2

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Microsoft Office 2007 folder
and take the Office 2007 -- Test Excel E2

Recommended: Log in to SAM 2007 at http://sam2007.course.com and do the Training for SAM Exam Excel - E2
This training has 20 Excel 2007 tasks.
These tasks will be on SAM Exam Excel - E2
This training is not graded, and can be repeated as many times as you need.
Your goal is to master each task as the "apply" level of training.

Required: Log in to SAM 2007 at http://sam2007.course.com and take SAM Exam Excel - E2
This exam has 20 Excel 2007 tasks, presented in random order.
You may try up to 3 attempts to perform each task correctly.
There is not a time limit for this SAM Exam.
You may retake this exam once if you choose. If you retake the SAM Exam your grade would be the higher of your two scores.

OR as an alternative to doing SAM Exam Excel - E2 online do the following:

Do "In The Lab: Lab 2-2 (part 1 only): Balance Due Worksheet" on pages EX 151-153 of your Office 2007 text.
Include your own full name and section time and day in cell A2 so that they show when you print your worksheet.
Print your completed worksheet but include cells A1:D14 in step 12 on page EX 153. Black and White printing is OK.
Print your worksheet formulas for cells A1:D14 in step 12 on page EX 153. Black and White printing is OK.
Hand in your two printouts for "Jackson's Bright Ideas" to the instructor's mailbox in LSBE 335.
This alternative is due at 4:30pm on Friday, September 26, 2008.

WEEK 5

• Read: Shelly/Cashman/Vermaat: Excel 2007: Chapter 3:
  "What-If Analysis, Charting, and Working with Large Worksheets," pages EX 161 - EX 229 (69 pages).
  This reading shows how to build the "Campus Clothiers" worksheet discussed in lecture.
  
• In Class: Lecture on Excel 2007 Chapter 3: Student Data Files for Download
  
  download CampusClothiersRawData.xlsx Excel 2007 workbook for Chapter 3 lectures
  download CampusClothiersRawData.xls Excel 97-2003 workbook for Chapter 3 lectures
  

• Suggested: Learn It Online (described on page EX 70) Under Chapter 3 you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  

• Arrive on time, and bring a soft lead pencil.
  
• Midterm Examination Format: about 50 True/False and Multiple Choice questions
• Midterm Examination Coverage: Essential Introduction to Computers, Windows, and Excel: chapters 1, 2 and 3
• Learning and Review resources: see the daily assignments above.

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Microsoft Office 2007 folder
and take the Office 2007 -- Test Excel E3

WEEK 6

• Read: Shelly/Cashman/Vermaat: Access 2007: Chapter One:
  "Creating and Using a Database," pages AC 1 - AC 64 (64 pages).
  This reading shows how to build the "JSP Recruiters" database discussed in lecture.
  
  
• In Class: demonstration of Excel 2007 Data Tables: Student Data Files for Download
  
  download JSP_Client_Data.xlsx Excel 2007 workbook
  download JSP_Client_Data.xls Excel 97-2003 workbook
  
  
  
• In Class: Lecture on Access 2007 Chapter 1: Creating and Using a Database
  

• Suggested: Learn It Online (described on page AC 64) Under Chapter 1 you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  
• In Class: Lecture on Access 2007 Chapter 1: Creating and Using a Database
  

• In Class: Finish Lecture on Access 2007 Chapter 1: Creating and Using a Database
  

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Microsoft Office 2007 folder
and take the Office 2007 -- Test Access A1

Required: Log in to SAM 2007 at http://sam2007.course.com
choose "Exam Type" CourseAssess
and take SAM CourseAssess Exam Access - A1
This exam has 31 tasks, presented in random order.
There is no time limit for this exam.
You may retake this exam.
If you choose to retake the exam, your grade will be the higher of your exam scores.

(Note: SAM CourseAssess Exam Access - A1 does not have an accompanying training module for these specific tasks.
Class lectures, reading the text, and especially practice with live Access 2007 screens are recommended training options.)

OR as an alternative to doing SAM CourseAssess Exam Access - A1 online do the following offline alternative:

Do "In The Lab: Lab 1-1: Creating the JMS TechWizards Database" on pages AC 67-68 of your Office 2007 text.
In step 6 when you specify the "Billing Summary Report" title also include your own full name and section
In step 6 when you specify the "Salary Report" title also include your own full name and section
In Step 7 on page AC 68 enter your own name as the author of your database.
Print your "Billing Summary Report" similar to Figure 1-104(a) on page AC 68.
Print your "Salary Report" similar to Figure 1-104(b) on page AC 68.
Black and White report printing is OK.
Hand in your two reports with your own full name machine printed, either in class or to the instructor's mailbox in LSBE 335.
This offline alternative is due at 4:30pm Monday, October 13, 2008.

WEEK 7

• Read: Shelly/Cashman/Vermaat: Access 2007: Chapter Two:
  "Querying a Database," pages AC 73 - AC 128 (56 pages).
  This reading shows how to query the "JSP Recruiters" database discussed in lecture.
  
  
• In Class: Lecture on Access 2007 Chapter A2: Student Data File for Download
  
  download JSP_Recruiters_Begin_Chapter_A2.accdb Access 2007 database for Chapter A2 lectures
  

• Suggested: Learn It Online (described on page AC 128) Under Chapter 2 you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  

• finish work on Access 2007 chapter 2

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Microsoft Office 2007 folder
and take the Office 2007 -- Test Access A2

WEEK 8

• Read: Shelly/Cashman/Vermaat: Access 2007: Chapter Three:
  "Maintaining a Database," pages AC 137 - AC 196 (60 pages).
  This reading shows how to maintain the "JSP Recruiters" database discussed in lecture.
  

• Suggested: Learn It Online (described on page AC 196) Under Chapter 3 you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  

• finish work on Access 2007 chapter 3

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Microsoft Office 2007 folder
and take the Office 2007 -- Test Access A3

WEEK 9

• Read: Shelly/Cashman/Vermaat: Power Point 2007: Chapter One:
  "Creating and Editing a Presentation," pages PPT 1 - PPT 66 (66 pages).
  This reading shows how to build the "World Beneath the Waves" presentation discussed in lecture.
  
  
• Suggested: Learn It Online (described on page PPT 66) Under Chapter 1 you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  

• Read: Shelly/Cashman/Vermaat: Power Point 2007: Chapter Two:
  "Creating a Presentation with Illustrations and Shapes," pages PPT 81 - PPT 132 (52 pages).
  This reading shows how to build the "Protect Your Good Name" presentation discussed in lecture.
  
  
• Suggested: Learn It Online (described on page PPT 132) Under Chapter 2 you can try:
      "Chapter Reinforcement" (for Multiple Choice, T/F, or Short Answer Quizzes)
      "Flash Cards," "Practice Test," "Who Wants to be a Computer Genius,"
      "Wheel of Terms," or "Crossword Puzzle Challenge."
  

• finish work on Power Point 2007 chapter 2

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Microsoft Office 2007 folder
and take the Office 2007 -- Test PPT

See the instructions for doing this assignment on the web at URL http://www.d.umn.edu/~hperson/2201/HandsOnPPT2007.htm

WEEK 10

• Arrive on time, and bring a soft lead pencil.
  
• Midterm Examination Format: about 50 True/False and Multiple Choice questions
• Midterm Examination Coverage: Access 2007: chapters 1, 2 and 3 and Power Point 2007: chapters 1 and 2
• Learning and Review resources: see the daily assignments above.

• Read: Stair/Reynolds: Fundamentals of Information Systems
  Chapter 1: "An Introduction to Information Systems in Organizations," pages 2 - 47 (46 pages).
  
  
• Suggested: Self-Assessment Test: Fundamentals of IS: Chapter 1: pages 47-48.
  
  
• Suggested: Review Questions: Fundamentals of IS: Chapter 1: page 48, #1 - 17.
  
  
• Power Point Lecture Slides for Chapter 1
  

• finish work on Fundamentals of IS: Chapter 1

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Fundamentals of Information Systems folder
then take the Test - IS1

WEEK 11

• Required: Read: Stair/Reynolds: Fundamentals of Information Systems:
  Chapter 2: "Hardware and Software" pages 56 - 102 (47 pages).
  
  
• Suggested: Self-Assessment Test: Fundamentals of IS: Chapter 2: pages 102 - 103.
  
  
• Suggested: Review Questions: Fundamentals of IS: Chapter 2: page 103, #1 - 14.
  
  
• Power Point Lecture Slides for Chapter 2
  

• Read: Stair/Reynolds: Fundamentals of Information Systems:
  Chapter 3: "Organizing Data and Information," pages 108 - 141 (38 pages).
  
  
• Suggested: Self-Assessment Test: Fundamentals of IS: Chapter 3: pages 141 - 142.
  
  
• Suggested: Review Questions: Fundamentals of IS: Chapter 3: page 142, #1 - 14.
  
  
• Power Point Lecture Slides for Chapter 3
  

• finish work on Fundamentals of IS chapter 3

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Fundamentals of Information Systems folder
then take the Test - IS2

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Fundamentals of Information Systems folder
then take the Test - IS3

WEEK 12

• Required: Read: Stair/Reynolds: Fundamentals of Information Systems
  Chapter 4: "Telecommunications, the Internet, Intranets, and Extranets" pages 148 - 190 (43 pages).
  
  
• Suggested: Self-Assessment Test: Fundamentals of IS: Chapter 4: pages 190 - 191.
  
  
• Suggested: Review Questions: Fundamentals of IS: Chapter 4: page 191, #1 - 20.
  
  
• Power Point Lecture Slides for Chapter 4
  
  

• finish work on Fundamentals of IS chapter 4

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Fundamentals of Information Systems folder
then take the Test - IS4

• Required: Read: Stair/Reynolds: Fundamentals of Information Systems
  Chapter 5: "Electronic Commerce and Mobile Commerce and Enterprice Systems" pages 202 - 242 (41 pages).
  
  
• Suggested: Self-Assessment Test: Fundamentals of IS: Chapter 5: page 242.
  
  
• Suggested: Review Questions: Fundamentals of IS: Chapter 5: pages 242 - 243, #1 - 14.
  
  
• Power Point Lecture Slides for Chapter 5
  

WEEK 13

• finish work on Fundamentals of IS Chapter 5

• No Class Meeting -- Travel Day

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Fundamentals of Information Systems folder
then take the Test - IS5

WEEK 14

• Read: Stair/Reynolds: Fundamentals of Information Systems
  Chapter 6: "Information and Decision Support Systems (DSS)," pages 248 - 285 (38 pages).
  
  
• Suggested: Self-Assessment Test: Fundamentals of IS: Chapter 6: pages 285 - 286.
  
  
• Suggested: Review Questions: Fundamentals of IS: Chapter 6: page 286, #1 - 19.
  
  
• Power Point Lecture Slides for Chapter 6
  

• finish work on Fundamentals of IS Chapter 6

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Fundamentals of Information Systems folder
then take the Test - IS6

• Read: Stair/Reynolds: Fundamentals of Information Systems
  Chapter 8: "Systems Development," pages 338 - 374 (37 pages).
  
  
• Suggested: Self-Assessment Test: Fundamentals of IS: Chapter 8: pages 374 - 375.
  
  
• Suggested: Review Questions: Fundamentals of IS: Chapter 8: page 375, #1 - 17.
  
  
• Power Point Lecture Slides for Chapter 8
  

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Fundamentals of Information Systems folder
then take the Test - IS8

WEEK 15

• Required: Read: Stair/Reynolds: Fundamentals of Information Systems
  Chapter 9: "The Personal and Social Impact of Computers," pages 382 - 417 (36 pages).
  
  
• Suggested: Self-Assessment Test: Fundamentals of IS: Chapter 9: pages 417 - 418.
  
  
• Suggested: Review Questions: Fundamentals of IS: Chapter 9: page 418, #1 - 16.
  
  
• Power Point Lecture Slides for Chapter 9
  

• finish work on Fundamentals of IS chapter 9

Required: Log in to MyU at http://myu.umn.edu on the MyU main page click the "My Courses" tab
in the courses you are taking click the FMIS 2201 WebVista link for your section
open the Fundamentals of Information Systems folder
then take the Test - IS9

• No class meeting - Study Day

• Take the final exam with the section in which you are enrolled.
• FMIS 2201-3,4 11:00 am MWF Final Exam will be at 10:00 - 11:55 am, Tuesday, December 16, 2008, in LSBE 118.
  
• FMIS 2201-5,6 12:00 pm MWF Final Exam will be at 2:00 - 3:55 pm, Friday, December 19, 2008, in LSBE 118.
  
• If you have more than two finals on the same day see the instructor to try to arrange a final on another day.
  
• Arrive on time, and bring a soft lead pencil.
  
• Final Examination Format: about 110 True/False and Multiple Choice questions
• Final Examination Coverage: Fundamentals of Info Systems: chapters 1, 2, 3, 4, 5, 6, 8, and 9 (omit 7).
• Learning and Review resources: see the daily assignments above.