You must submit your completed file(s) through the CS101 Submit Assignments tool.
This assignment is due on Friday, December 1, 2017 at 11:59:59 PM Eastern Time. Late work will be accepted for reduced credit until Tuesday, December 5, 2017 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
There are 4 Microsoft Office portions to homework #6!
Associated Learning Objectives
This assignment covers the following course and unit learning objectives:
|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|