Metropolitan State University

MIS 100 : Fundamentals of Information Technology in Organizations

A. Course Description
Credits: 4
Lab Hours/ Weeks: Corequisites: None
Lecture Hours/ Week :  
MnTC Goals: Goal EL - General Education/Liberal Studies Elect.
 
This course is the first information technology foundation course in the College of Management. It focuses on the technology literacy, managerial and business problem solving dimensions of computer based information systems. It provides students with an introduction to the fundamental terminology of the hardware, software and the people involved with computer based information systems. The course includes hands on computer lab time to introduce students to word processing, database, spread sheet, and Internet microcomputer applications. This course is designed specifically to prepare students for information technology competence as needed in College of Management courses.
B. Course Effective Dates: 08/24/2002 - 05/04/2017 05/05/2017 - Present
C. Outline of Major Content Areas:
See Course Description for major content areas.
D. Learning Outcomes (General)
  1. Students will be able to show competence in understanding Application Software.
  2. Students will be able to show competence in understanding the Components of the System Unit.
  3. Students will be able to show competence in understanding the Internet and World Wide Web.
  4. Students will be able to show competence in understanding Communications and Networks.
  5. Students will be able to show competence in understanding Input and Output devices and their application.
  6. Students will be able to show competence in understanding Operating Systems and Utility Programs.
  7. Students will be able to show competence in understanding storage, both primary and secondary.
  8. Students will be able to show competence in understanding Computer Security and Safety, Ethics, and Privacy.
  9. Students will be able to show competence in understanding Database Management concepts.
  10. Students will be able to show competence in understanding basic concepts in Enterprise Computing.
  11. Students will be able to show competence in understanding Information System Development and Programming Languages.
  12. Students will also be able to use conditional formatting, import data from an external site and manipulate the data.
  13. Students will be able to demonstrate the use of formulas functions and formatting, and what if analysis to create a mortgage table and use pivot tables to manipulate data.
  14. Students will be able to use a Template to Create a Resume and Share a Finished Document.
  15. Students will demonstrate the ability to apply primary and foreign keys and understand simple relationship between tables.
  16. Students will demonstrate the ability to create a Document with a Title Page, use Lists, Tables, and a Watermark.
  17. Students will demonstrate the ability to create reports and forms.
  18. Students will demonstrate the ability to use Financial Functions, Data Tables, and Amortization Schedules, work with Multiple Worksheets and Workbooks, create Templates, Importing Data.
  19. Students will demonstrate the ability to use Microsoft Access to create, edit, save, query and format tables.
  20. Students will demonstrate the ability to use Microsoft Excel to create, edit, save and format spreadsheets and create and embed charts.
  21. Students will demonstrate the ability to use Microsoft Word to create, edit, save and format documents including documents with graphics.
  22. Students will demonstrate the ability to use the review functions and properly cite research papers; create a web page and a resume.
E. Learning Outcomes (MN Transfer Curriculum)
Goal EL - General Education/Liberal Studies Elect.
    None
G. Special Information
Note: Microsoft Office 2016, or Microsoft Office 365, is required for this course. The software is available on computers in the library and installed in all campus labs for student use.