INLS161-001 Spring 2022

Tools for Information Literacy

Task ④ Dealing with Markup

Tasl 04 will call you to demonstrate specific data formatting and manipulation skills on a set of worksheets
and be introduced to Entity Relationship Modeling and Structured Query Langauge (SQL).

Task Components

spreadsheets task logo

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.

Additionally, we will introduce basic database concepts
task components condition standard

back to top


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.

Working in groups for tasks

You may, if you choose to, do task 04 as a group project. These are some rules of thumb to follow for group work in INLS161.

task components condition standard

back to top


Task 04 is worth 20% of your INLS161 grade, so this task will be worth 20 points in total. Each of the sub-elements is listed on the gradesheet.

The finished workbook will be stored in your Sakai assignments location for INLS161..

Save the finished product using the standard file name structure for this class.
An example of a standard file name might be johnson.pat.20211122.task04.working-with-data.xlsx

task components condition standard

back to top

Copyright © R.E. Bergquist 2014- | Last Updated on | Powered by w3.css