Information System Fundamentals

Course Description                                                                                                                                            Fall 2018 Syllabus 

Course introduces students to the basic concepts in computer technology and highlights the relevance of computers and their applications to all aspects of life in the modern world. It covers the fundamentals of computer systems, computer networks, software applications, and the Internet as well as social issues related to the use of computer technology.

Professor Information & Office Hours

  • Dr. Jonathan Sweet, Ph.D.
    • Boca Office: Fleming Hall (FL) 341A, Boca campus

Course Prerequisites, Credit Hours, and Class Time Commitments

Prerequisites: None.
Credit Hours: 3 Credit Hours.

According to Florida Administrative Code, Rule 6A-10.033, students must spend a minimum 2,250 minutes of in-class time during a 3-credit course. Additionally, students enrolled in a 3-credit course are expected to spend a minimum of 4,500 minutes of out-of-class-time
specifically working on course-related activities (i.e., reading assigned pieces, completing homework, preparing for exams and other assessments, reviewing class notes, etc.) and fulfilling any other class activities or duties as required. The course schedule for this course reflects this expectation of students. I recommend spending 3 hours outside of class each week for each credit hour of ISM 2000
to sufficiently master the course material.

Requires Text and Materials

  • Lecture & Lab Textbook & access code Bundle:
    O’Leary: Computing Essentials 2017 (Loose-leaf version) +
    SIMNet: Nordell Office 2016 Access Code is included in the bundle
    ISBN #: 9781260000184 {Bundle package
    • When you purchase this bundle, you will receive (1) loose-leaf copy of the O’Leary textbook, (1) access code for SIMnet (which is the online platform we will use for the lab material), and digital/electronic copies of both the O-Leary text and the Nordell text that can be electronically accessed through the Simnet online platform
    • THE ABOVE COMPONENTS ARE AVAILABLE AS A DISCOUNTED BUNDLE, ISBN-13:
      9781260000184, AVAILABLE AT THE FAU BOOKSTORE.
    • You can also purchase a digital copy of the access code for SIMnet which includes a digital copy of the O’Leary textbook through SIMnet. More information on how to
      do this process will be explained in the first lecture when the representative from SIMnet walks through the sign-up process
  • Hardware Required for Taking the Online Lecture Exams for this Course
    • A well-functioning computer/laptop, stable Internet connection, webcam, & FAU Owl Card (or other government-issued photo ID)

Course Learning Objectives

  • Information Systems Fundamentals is a 3-credit hour course which is about the blending of two distinct subjects: “information” and “technology”. In this course, we will look at the fundamentals of each and how they influence and interact with each other. The course intends to introduce students to basic concepts in computer technology and to highlight the relevance of computers and their application in all aspects of life in the modern world. The course covers the fundamentals of computer systems, computer networks, software
    applications, the Internet, as well as social issues.
  •  Both course components aim to provide exercises in critical thinking and communication skills, two of the top ten skills sought by employers. Upon successfully completing the course, you should be able to understand using technology to gather, store, and manipulate information for the purpose of communication and problem solving, as well as to determine which software application is the appropriate choice for the end purpose.
  • The course is designed to promote student advancement in these crucial life and career skills:
    • Learning how to learn on your own.
    • Developing life-long learning skills.
    • Developing metacognitive skills – knowing what you know, don’t know, or misunderstand.
    • Developing the ability to evaluate yourself and your peers

Learning Goals

  • Content Knowledge (Declarative). Students will be introduced to information systems for the purpose of processing data into information, computer history, systems use in modernculture and the ethical issues they may provoke. Students will demonstrate the proficiencyof their knowledge in these topics by taking exams.
  • Content Knowledge (Technical). Students will be introduced to the use of productivity computer software programs (operating system, word processing, presentation, and spreadsheet) and their relevance to problem-solving and communication. Students will take exams and complete assignments in which they will use these applications to demonstrate their proficiency in using those programs.
  • Critical Thinking (Apply/Analyze/Evaluate). Students will be introduced to the concept and analysis of information requirements of problem-solving. They will learn the various types of data needed to create such information, and evaluate the proper use of each in different application environments.
  • Critical Thinking (Solve Problems/Design/Create). Students will be introduced to problemsolving skills using spreadsheet. Students will go through the process of developing solutions based on data requirements.

Grading Scale

A 93.00-100% B- 80-82.99% D+ 67-69.99%
A- 90-92.99% C+ 77-79.99% D 63-66.99%
B+ 87-89.99% C 73-76.99% D- 60-62.99%
B 83-86.99% C- 70-72.99% F < 60%

 

Course Evaluation/Grading Method

Lecture Exams 49%
Course Introduction Quiz 2%
Lab Homework, Lab Quizzes, & Lab Projects 49%
Total 100%

 

Projects

Guided Project 1-3:                                                                                                                 Guided Project 1-3 Instructions

In this project, you edit a worksheet for Wear-Ever Shoes that tracks their product inventory. You change the zoom size, reset the panes, and format data. You copy an existing formula to calculate the value of the current stock and insert a column for new data. After adjusting print options, you set a print area for a specific product line.

Skills Covered in This Project:

  • Open and save a workbook.
  • Change zoom size and remove a split.
  • Freeze panes.
  • Format labels and values.
  • Use the Fill Handle to copy a formula and fill a series.
  • Check spelling.
  • Apply a workbook theme, cell styles, and font attributes.
  • Merge and center labels.
  • Insert a column and adjust column widths and row heights.
  • Adjust alignment, indents, and borders.
  • Rename the sheet tab.
  • Use Page Layout view to insert a footer.

Guided Project 2-3:                                                                                                                 Guided Project 2-3 Instructions

Sierra Pacific Community College District (SPCCD) consists of four individual community colleges. The workbook for this project includes an amortization schedule for student loans and a fee and credit hour summary for several departments.

Skills Covered in This Project:

  • Name cell ranges.
  • Create and copy formulas.
  • Set mathematical order of operations.
  • Use absolute references in formulas.
  • Insert the current date as a function.
  • Insert the current date as a function.
  • Audit formulas.
  • Use SUMIF and SUMPRODUCT.

Guided Project 3-3:                                                                                                                 GUIDED PROJECT 3-3 INSTRUCTIONS

Blue Lake Sports has locations in several major cities and tracks sales by department in each store. For this project, you create a pie chart that shows each store’s share of golf-related sales for the first quarter. You also create a line chart to illustrate week-to-week sales for specific departments in one of the stores and insert sparklines in the data.

Skills Covered in This Project:

  • Create, size, and position a pie chart object.
  • Apply a chart style.
  • Change the chart type.
  • Add and format chart elements.
  • Create a line chart sheet.
  • Apply a chart layout.
  • Insert and format sparklines in a worksheet.

Guided Project 4-3:                                                                                                                 GUIDED PROJECT 4-3 INSTRUCTIONS

Clemenson Imaging analyzes expense reports from field representatives as well as patient and image data. To complete the worksheets, you format data as a table and build an advanced filter. You import a comma-separated text file (.csv) and use the Subtotal command. Finally, you display data in a PivotTable.

Skills Covered in This Project:

  • Format data as an Excel table.
  • Build an Advanced Filter.
  • Apply conditional formatting to filtered results.
  • Sort data by multiple columns.
  • Import a comma-separated text file.
  • Use the Subtotal command.
  • Export data via the Clipboard.
  • Create a PivotTable.

 

 

Accreditation

AACSB Accredited

AACSB Accreditation

The FAU College of Business is proud to be an accredited member of AACSB
(The Association to Advance Collegiate Schools of Business) International, the premier accreditation agency for Schools of Business worldwide.

Online Grad Programs

Best Online GRAD Business Programs

The FAU College of Business ranked among the top 50 online graduate business programs in U.S. News and World Report. This builds upon our MBA Program rankings in Bloomberg Businessweek, and most importantly, reflects the high quality of the faculty, professional staff, and the students in the program.

Online MBA programs

Best Online MBA Programs

The FAU College of Business ranked among the top programs in U.S. News and World Report. This builds upon our MBA Program rankings in Bloomberg Businessweek, and most importantly, reflects the high quality of the faculty, professional staff, and the students in the program.

Online Veterans

Best Online Veterans Programs

The FAU College of Business ranked among the top programs in U.S. News and World Report. This builds upon our MBA Program rankings in Bloomberg Businessweek, and most importantly, reflects the high quality of the faculty, professional staff, and the students in the program.

Sport Interantional Ranking

Best MBA Sports Program

Florida Atlantic University’s College of Business MBA in Sport Management program is among the best in the world, according to the latest rankings from SportBusiness International.

Best Schools - Hospitality

Best Hospitality Program

Florida Atlantic University ranks on The 30 Best Hospitality Degree Programs in the U.S.!

Best For Vets

Best For Veterans

Florida Atlantic University’s College of Business has been named the top business school in South Florida for veterans by Military Times magazine. It is also a top 50 business school in the country for veteran education, according to the 2015 “Best for Vets” survey.

©