home & schedule | syllabus | contact | grades

You will be called upon to demonstrate specific spreadsheet skills on a set of worksheets and will also create several SQL queries based on a set of provided data.

Task ④ ⇒ working with data

You are to download and modify several existing worksheets to make them a more useful product. To be specific, these worksheets from a variety of publicly available data provided by the US government in spreadsheet form.

The task will require you show capability with a number of data management skills

• cell and worksheet formatting
• building formulas and using functions that pull data from other worksheets
• converting raw data into charts and data displays
• sorting
• filtering - simple and multivalue
• VLookup
• pivot tables

Additionally, we will introduce basic database concepts

• we will gain a familiarity with Entity Relationship Model concepts and terminology
• we will gain a familiarity with Structured Query Language (SQL) queries

Condition

There are several different commercial spreadsheet software applications, and you may use the one of your choice. However, your product will have to be capable of being used with Microsoft Excel and MySql (The M in M/WAMP).

Standard

The finished, fully formatted template document will be stored in your Sakai assignments location for INLS161..

Save the finished product using the standard file name structure for this class.