Information Systems 3 Credit Equivalent

Design and construct information systems for business processes and utilize them for effective decision making.

Projects

Number Title Description Credit Equivalent
BAOS 300x Sales Data Analysis and Communication Using Spreadsheets and Statistics

This project gives students domestic sales records containing detailed information including store number, sales region, item number, item description, unit price, units sold, and date of sale. Students will work with the data using spreadsheet technologies such as Microsoft Excel to apply a number of spreadsheet formulas on the data, aggregate the data using pivot tables, summarize data, and create charts and tables with summary data. Students will also apply measures of central tendency (mean, median and mode) as they relate to sales data. They also arrive at measures of variability (e.g., range, standard deviation, and variance) on different segments of sales data and calculate measures of relative positon (e.g., percentiles, quartiles, and interquartile ranges). Students demonstrate an understanding of these statistical concepts and how to compute them with formulas in spreadsheets. Students will then use this information to complete a written report for the CEO as well as a PowerPoint presentation for the Board of Directors. Students will also demonstrate their editing capabilities by revising a colleague’s memo and complete an evaluation/reflection of the primary deliverables. Note: Successful completion of this project satisfies credit equivalents in Information Systems (0.50), Business Statistics (0.80), and Business Communication (0.70).

Required text: Glenn, Cheryl and Loretta Grey, The Hodges Harbrace Handbook, 2009 MLA Update Edition, 17th Edition. ISBN: 978-0495797562

Successful completion of this project satisfies credit equivalents in the following competency areas: Information Systems (0.5), Business Statistics (0.8), and Business Communication (0.7).

  • Construct and utilize spreadsheets effectively.
  • Compute measures of central tendency, location, and variability.
  • Write clearly for target audiences, purposes, and contexts.

Formerly IS300

2
BAOS 301x Database Design and Development

In this project, students are given a hypothetical business scenario. Students need to analyze the data needs and arrive at a database design including database entities, attributes, and relationships for the scenario. They have to construct a database and populate it with data. In addition, students need to demonstrate mastery of designing and running queries and reports in the database to obtain meaningful information needed for business decision making.

Required text: None.

  • Develop information systems for decision making.

Formerly IS305

Prerequisites:

  • BAOS 300x: Sales Data Analysis and Communication Using Spreadsheets and Statistics

    BAOS 300x: Sales Data Analysis and Communication Using Spreadsheets and Statistics

    This project gives students domestic sales records containing detailed information including store number, sales region, item number, item description, unit price, units sold, and date of sale. Students will work with the data using spreadsheet technologies such as Microsoft Excel to apply a number of spreadsheet formulas on the data, aggregate the data using pivot tables, summarize data, and create charts and tables with summary data. Students will also apply measures of central tendency (mean, median and mode) as they relate to sales data. They also arrive at measures of variability (e.g., range, standard deviation, and variance) on different segments of sales data and calculate measures of relative positon (e.g., percentiles, quartiles, and interquartile ranges). Students demonstrate an understanding of these statistical concepts and how to compute them with formulas in spreadsheets. Students will then use this information to complete a written report for the CEO as well as a PowerPoint presentation for the Board of Directors. Students will also demonstrate their editing capabilities by revising a colleague’s memo and complete an evaluation/reflection of the primary deliverables. Note: Successful completion of this project satisfies credit equivalents in Information Systems (0.50), Business Statistics (0.80), and Business Communication (0.70).

    Required text: Glenn, Cheryl and Loretta Grey, The Hodges Harbrace Handbook, 2009 MLA Update Edition, 17th Edition. ISBN: 978-0495797562

    Successful completion of this project satisfies credit equivalents in the following competency areas: Information Systems (0.5), Business Statistics (0.8), and Business Communication (0.7).

    • Construct and utilize spreadsheets effectively.
    • Compute measures of central tendency, location, and variability.
    • Write clearly for target audiences, purposes, and contexts.

    Formerly IS300

1
BAOS 302x Building Competitive Advantage Using Information Systems

In this project, students are given a hypothetical business scenario. Students need to analyze processes and construct process diagrams to document them. Then they need to arrive at use case models for a hypothetical information system that helps implement the business processes. They also need to analyze the security vulnerabilities of the proposed information system and articulate how information systems help build competitive advantage.

Required text: None.

  • Create information system management plans.
  • Analyze the role of information systems as a management resource.

Formerly IS310

Prerequisites:

  • BAOS 300x: Sales Data Analysis and Communication Using Spreadsheets and Statistics

    BAOS 300x: Sales Data Analysis and Communication Using Spreadsheets and Statistics

    This project gives students domestic sales records containing detailed information including store number, sales region, item number, item description, unit price, units sold, and date of sale. Students will work with the data using spreadsheet technologies such as Microsoft Excel to apply a number of spreadsheet formulas on the data, aggregate the data using pivot tables, summarize data, and create charts and tables with summary data. Students will also apply measures of central tendency (mean, median and mode) as they relate to sales data. They also arrive at measures of variability (e.g., range, standard deviation, and variance) on different segments of sales data and calculate measures of relative positon (e.g., percentiles, quartiles, and interquartile ranges). Students demonstrate an understanding of these statistical concepts and how to compute them with formulas in spreadsheets. Students will then use this information to complete a written report for the CEO as well as a PowerPoint presentation for the Board of Directors. Students will also demonstrate their editing capabilities by revising a colleague’s memo and complete an evaluation/reflection of the primary deliverables. Note: Successful completion of this project satisfies credit equivalents in Information Systems (0.50), Business Statistics (0.80), and Business Communication (0.70).

    Required text: Glenn, Cheryl and Loretta Grey, The Hodges Harbrace Handbook, 2009 MLA Update Edition, 17th Edition. ISBN: 978-0495797562

    Successful completion of this project satisfies credit equivalents in the following competency areas: Information Systems (0.5), Business Statistics (0.8), and Business Communication (0.7).

    • Construct and utilize spreadsheets effectively.
    • Compute measures of central tendency, location, and variability.
    • Write clearly for target audiences, purposes, and contexts.

    Formerly IS300

1
BAOS 303x Enterprise Systems and E-Commerce

In this project, students are given a hypothetical business scenario. Students need to analyze what type of enterprise-wide systems are needed for the business. They also need to be able to present preliminary designs for the enterprise systems, articulate the usefulness of E-Commerce systems for the given business scenario, and document the requirements of the E-Commerce systems. Students need to provide details of different infrastructure components needed for the E-Commerce system and communicate plans for the E-Commerce system to key stakeholders, including how the solution will be measured and monitored in terms of effectiveness.

Required text: Glenn, Cheryl and Loretta Grey, The Hodges Harbrace Handbook, 2009 MLA Update Edition, 17th Edition. ISBN: 978-0495797562

Successful completion of this project satisfies credit equivalents in the following competency areas: Information Systems (0.5) and Business Communication (0.5). 

  • Develop and communicate a plan for an E-Commerce System.
  • Distinguish between enterprise-wide information systems used in organizations.
  • Design appropriate and effective communication strategies that meet professional and business communication purposes.

Formerly IS315

Prerequisites:

  • BAOS 301x: Database Design and Development

    BAOS 301x: Database Design and Development

    In this project, students are given a hypothetical business scenario. Students need to analyze the data needs and arrive at a database design including database entities, attributes, and relationships for the scenario. They have to construct a database and populate it with data. In addition, students need to demonstrate mastery of designing and running queries and reports in the database to obtain meaningful information needed for business decision making.

    Required text: None.

    • Develop information systems for decision making.

    Formerly IS305

  • BAOS 302x: Building Competitive Advantage Using Information Systems

    BAOS 302x: Building Competitive Advantage Using Information Systems

    In this project, students are given a hypothetical business scenario. Students need to analyze processes and construct process diagrams to document them. Then they need to arrive at use case models for a hypothetical information system that helps implement the business processes. They also need to analyze the security vulnerabilities of the proposed information system and articulate how information systems help build competitive advantage.

    Required text: None.

    • Create information system management plans.
    • Analyze the role of information systems as a management resource.

    Formerly IS310

  • Fulfillment of English Composition (UW Colleges ENG 102 or Equivalent)
1
Number
BAOS 300x
Title
Sales Data Analysis and Communication Using Spreadsheets and Statistics
Description

This project gives students domestic sales records containing detailed information including store number, sales region, item number, item description, unit price, units sold, and date of sale. Students will work with the data using spreadsheet technologies such as Microsoft Excel to apply a number of spreadsheet formulas on the data, aggregate the data using pivot tables, summarize data, and create charts and tables with summary data. Students will also apply measures of central tendency (mean, median and mode) as they relate to sales data. They also arrive at measures of variability (e.g., range, standard deviation, and variance) on different segments of sales data and calculate measures of relative positon (e.g., percentiles, quartiles, and interquartile ranges). Students demonstrate an understanding of these statistical concepts and how to compute them with formulas in spreadsheets. Students will then use this information to complete a written report for the CEO as well as a PowerPoint presentation for the Board of Directors. Students will also demonstrate their editing capabilities by revising a colleague’s memo and complete an evaluation/reflection of the primary deliverables. Note: Successful completion of this project satisfies credit equivalents in Information Systems (0.50), Business Statistics (0.80), and Business Communication (0.70).

Required text: Glenn, Cheryl and Loretta Grey, The Hodges Harbrace Handbook, 2009 MLA Update Edition, 17th Edition. ISBN: 978-0495797562

Successful completion of this project satisfies credit equivalents in the following competency areas: Information Systems (0.5), Business Statistics (0.8), and Business Communication (0.7).

  • Construct and utilize spreadsheets effectively.
  • Compute measures of central tendency, location, and variability.
  • Write clearly for target audiences, purposes, and contexts.

Formerly IS300

Credit Equivalent
2
Number
BAOS 301x
Title
Database Design and Development
Description

In this project, students are given a hypothetical business scenario. Students need to analyze the data needs and arrive at a database design including database entities, attributes, and relationships for the scenario. They have to construct a database and populate it with data. In addition, students need to demonstrate mastery of designing and running queries and reports in the database to obtain meaningful information needed for business decision making.

Required text: None.

  • Develop information systems for decision making.

Formerly IS305

Prerequisites:

  • BAOS 300x: Sales Data Analysis and Communication Using Spreadsheets and Statistics

    BAOS 300x: Sales Data Analysis and Communication Using Spreadsheets and Statistics

    This project gives students domestic sales records containing detailed information including store number, sales region, item number, item description, unit price, units sold, and date of sale. Students will work with the data using spreadsheet technologies such as Microsoft Excel to apply a number of spreadsheet formulas on the data, aggregate the data using pivot tables, summarize data, and create charts and tables with summary data. Students will also apply measures of central tendency (mean, median and mode) as they relate to sales data. They also arrive at measures of variability (e.g., range, standard deviation, and variance) on different segments of sales data and calculate measures of relative positon (e.g., percentiles, quartiles, and interquartile ranges). Students demonstrate an understanding of these statistical concepts and how to compute them with formulas in spreadsheets. Students will then use this information to complete a written report for the CEO as well as a PowerPoint presentation for the Board of Directors. Students will also demonstrate their editing capabilities by revising a colleague’s memo and complete an evaluation/reflection of the primary deliverables. Note: Successful completion of this project satisfies credit equivalents in Information Systems (0.50), Business Statistics (0.80), and Business Communication (0.70).

    Required text: Glenn, Cheryl and Loretta Grey, The Hodges Harbrace Handbook, 2009 MLA Update Edition, 17th Edition. ISBN: 978-0495797562

    Successful completion of this project satisfies credit equivalents in the following competency areas: Information Systems (0.5), Business Statistics (0.8), and Business Communication (0.7).

    • Construct and utilize spreadsheets effectively.
    • Compute measures of central tendency, location, and variability.
    • Write clearly for target audiences, purposes, and contexts.

    Formerly IS300

Credit Equivalent
1
Number
BAOS 302x
Title
Building Competitive Advantage Using Information Systems
Description

In this project, students are given a hypothetical business scenario. Students need to analyze processes and construct process diagrams to document them. Then they need to arrive at use case models for a hypothetical information system that helps implement the business processes. They also need to analyze the security vulnerabilities of the proposed information system and articulate how information systems help build competitive advantage.

Required text: None.

  • Create information system management plans.
  • Analyze the role of information systems as a management resource.

Formerly IS310

Prerequisites:

  • BAOS 300x: Sales Data Analysis and Communication Using Spreadsheets and Statistics

    BAOS 300x: Sales Data Analysis and Communication Using Spreadsheets and Statistics

    This project gives students domestic sales records containing detailed information including store number, sales region, item number, item description, unit price, units sold, and date of sale. Students will work with the data using spreadsheet technologies such as Microsoft Excel to apply a number of spreadsheet formulas on the data, aggregate the data using pivot tables, summarize data, and create charts and tables with summary data. Students will also apply measures of central tendency (mean, median and mode) as they relate to sales data. They also arrive at measures of variability (e.g., range, standard deviation, and variance) on different segments of sales data and calculate measures of relative positon (e.g., percentiles, quartiles, and interquartile ranges). Students demonstrate an understanding of these statistical concepts and how to compute them with formulas in spreadsheets. Students will then use this information to complete a written report for the CEO as well as a PowerPoint presentation for the Board of Directors. Students will also demonstrate their editing capabilities by revising a colleague’s memo and complete an evaluation/reflection of the primary deliverables. Note: Successful completion of this project satisfies credit equivalents in Information Systems (0.50), Business Statistics (0.80), and Business Communication (0.70).

    Required text: Glenn, Cheryl and Loretta Grey, The Hodges Harbrace Handbook, 2009 MLA Update Edition, 17th Edition. ISBN: 978-0495797562

    Successful completion of this project satisfies credit equivalents in the following competency areas: Information Systems (0.5), Business Statistics (0.8), and Business Communication (0.7).

    • Construct and utilize spreadsheets effectively.
    • Compute measures of central tendency, location, and variability.
    • Write clearly for target audiences, purposes, and contexts.

    Formerly IS300

Credit Equivalent
1
Number
BAOS 303x
Title
Enterprise Systems and E-Commerce
Description

In this project, students are given a hypothetical business scenario. Students need to analyze what type of enterprise-wide systems are needed for the business. They also need to be able to present preliminary designs for the enterprise systems, articulate the usefulness of E-Commerce systems for the given business scenario, and document the requirements of the E-Commerce systems. Students need to provide details of different infrastructure components needed for the E-Commerce system and communicate plans for the E-Commerce system to key stakeholders, including how the solution will be measured and monitored in terms of effectiveness.

Required text: Glenn, Cheryl and Loretta Grey, The Hodges Harbrace Handbook, 2009 MLA Update Edition, 17th Edition. ISBN: 978-0495797562

Successful completion of this project satisfies credit equivalents in the following competency areas: Information Systems (0.5) and Business Communication (0.5). 

  • Develop and communicate a plan for an E-Commerce System.
  • Distinguish between enterprise-wide information systems used in organizations.
  • Design appropriate and effective communication strategies that meet professional and business communication purposes.

Formerly IS315

Prerequisites:

  • BAOS 301x: Database Design and Development

    BAOS 301x: Database Design and Development

    In this project, students are given a hypothetical business scenario. Students need to analyze the data needs and arrive at a database design including database entities, attributes, and relationships for the scenario. They have to construct a database and populate it with data. In addition, students need to demonstrate mastery of designing and running queries and reports in the database to obtain meaningful information needed for business decision making.

    Required text: None.

    • Develop information systems for decision making.

    Formerly IS305

  • BAOS 302x: Building Competitive Advantage Using Information Systems

    BAOS 302x: Building Competitive Advantage Using Information Systems

    In this project, students are given a hypothetical business scenario. Students need to analyze processes and construct process diagrams to document them. Then they need to arrive at use case models for a hypothetical information system that helps implement the business processes. They also need to analyze the security vulnerabilities of the proposed information system and articulate how information systems help build competitive advantage.

    Required text: None.

    • Create information system management plans.
    • Analyze the role of information systems as a management resource.

    Formerly IS310

  • Fulfillment of English Composition (UW Colleges ENG 102 or Equivalent)
Credit Equivalent
1