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
IS 300 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 need to work with the data using spreadsheet technologies such as Microsoft Excel. They need 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. In addition, students 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 position (e.g. percentiles, quartiles, and interquartile ranges). Students need to demonstrate an understanding of these statistical concepts, and how to compute them with formula 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 will also complete an evaluation / reflection of the primary deliverables.

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).

2
IS 305 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 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.

Prerequisites:

  • IS 300: Sales Data Analysis and Communication using Spreadsheets and Statistics

    IS 300: 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 need to work with the data using spreadsheet technologies such as Microsoft Excel. They need 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. In addition, students 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 position (e.g. percentiles, quartiles, and interquartile ranges). Students need to demonstrate an understanding of these statistical concepts, and how to compute them with formula 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 will also complete an evaluation / reflection of the primary deliverables.

    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).

1
IS 310 Building Competitive Advantage Using Information Systems

In this project, students are given a hypothetical business scenario. Students need to analyze the processes and construct process diagrams to document the business processes. 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.

Prerequisites:

  • IS 300: Sales Data Analysis and Communication using Spreadsheets and Statistics

    IS 300: 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 need to work with the data using spreadsheet technologies such as Microsoft Excel. They need 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. In addition, students 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 position (e.g. percentiles, quartiles, and interquartile ranges). Students need to demonstrate an understanding of these statistical concepts, and how to compute them with formula 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 will also complete an evaluation / reflection of the primary deliverables.

    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).

1
IS 315 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. In addition, they need to be able to present preliminary designs for the enterprise systems. They also need to 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. In addition, they need to 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). 

Prerequisites:

  • IS 305: Database Design and Development

    IS 305: 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 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.

  • IS 310: Building Competitive Advantage Using Information Systems

    IS 310: Building Competitive Advantage Using Information Systems

    In this project, students are given a hypothetical business scenario. Students need to analyze the processes and construct process diagrams to document the business processes. 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.

  • Fulfillment of English Composition (UW Colleges ENG 102 or Equivalent)
1
Number
IS 300
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 need to work with the data using spreadsheet technologies such as Microsoft Excel. They need 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. In addition, students 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 position (e.g. percentiles, quartiles, and interquartile ranges). Students need to demonstrate an understanding of these statistical concepts, and how to compute them with formula 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 will also complete an evaluation / reflection of the primary deliverables.

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).

Credit Equivalent
2
Number
IS 305
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 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.

Prerequisites:

  • IS 300: Sales Data Analysis and Communication using Spreadsheets and Statistics

    IS 300: 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 need to work with the data using spreadsheet technologies such as Microsoft Excel. They need 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. In addition, students 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 position (e.g. percentiles, quartiles, and interquartile ranges). Students need to demonstrate an understanding of these statistical concepts, and how to compute them with formula 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 will also complete an evaluation / reflection of the primary deliverables.

    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).

Credit Equivalent
1
Number
IS 310
Title
Building Competitive Advantage Using Information Systems
Description

In this project, students are given a hypothetical business scenario. Students need to analyze the processes and construct process diagrams to document the business processes. 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.

Prerequisites:

  • IS 300: Sales Data Analysis and Communication using Spreadsheets and Statistics

    IS 300: 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 need to work with the data using spreadsheet technologies such as Microsoft Excel. They need 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. In addition, students 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 position (e.g. percentiles, quartiles, and interquartile ranges). Students need to demonstrate an understanding of these statistical concepts, and how to compute them with formula 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 will also complete an evaluation / reflection of the primary deliverables.

    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).

Credit Equivalent
1
Number
IS 315
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. In addition, they need to be able to present preliminary designs for the enterprise systems. They also need to 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. In addition, they need to 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). 

Prerequisites:

  • IS 305: Database Design and Development

    IS 305: 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 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.

  • IS 310: Building Competitive Advantage Using Information Systems

    IS 310: Building Competitive Advantage Using Information Systems

    In this project, students are given a hypothetical business scenario. Students need to analyze the processes and construct process diagrams to document the business processes. 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.

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