Skip to main content

Homework #6

Fortunate 500 Companies Problem

Assignment Files


You must submit your completed file(s) through the CS101 Submit Assignments tool.

Due Date

This assignment is due on Friday, April 27, 2018 at 11:59:59 PM Eastern Time. Late work will be accepted for reduced credit until Tuesday, May 1, 2018 at 11:59:59 PM Eastern Time.


This assignment is worth 50 points. A grading rubric is provided at the end of the assignment instructions.

Help & Resources

Associated Learning Objectives

This assignment covers the following course and unit learning objectives:

Number Learning Objective
C01 Build spreadsheets to perform calculations, display data, conduct analysis, and explore what-if scenarios.
C02 Design and construct databases to store, extract, and analyze scientific and real world data.
C03 Create scientific and technical documents incorporating equations, images, tables, and bibliographies.
C04 Develop technical and scientific presentations which use charts and visual aids to share data.
C05 Identify, access, and evaluate information to solve real world problems.
C01.ED02 Create and manage workbooks, worksheets, and their data.
C01.ED05 Use tables and PivotTables to organize data.
C01.ED06 Use charts, PivotCharts, and sparklines to present data in a graphical format.
C02.AC01 Design databases to store real world information.
C02.AC02 Create and manage databases and their data.
C02.AC03 Create and modify tables and associated relationships.
C02.AC04 Design and construct queries to extract needed information from a database.
C03.WP01 Create and manage documents and their contents to share information.
C03.WP02 Use images, figures, tables, and equations to illustrate documents.
C03.WP03 Use reference tools to insert cite, annotate, and organize documents.
C03.WP04 Apply formatting to documents to create a professional appearance.
C04.WP05 Create and manage presentations and their contents to share information.
C04.WP06 Apply formatting options to create a professional appearance for a presentation.
C04.WP07 Customize presentations by adding tables, rich media, and embedded objects to slides.
C05.AC06 Interpret and analyze database query results to perform calculations and answer questions.
C05.ED01 Locate and access data and resources necessary to solve problems.
C05.ED08 Interpret and analyze spreadsheet data