Tools for Information Literacy
Task ④ DATA CONTROL
Task 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
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.
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.
- If you choose the team option, let your recitation instructor know who are the members of your team.
- Note who your work group members are and be sure you know them by face and by email address.
- As much as possible, every member of the group should do all the components of the task. Do not parcel out portions of the task to individuals.
- Then, when your team has completed the task, one member of the team will submit that team's task in the Task 04 assignment space.
Standard
Task 04 is worth 25% of your INLS161 grade, so this task will be worth 25 points in total. Each of the sub-elements is listed on the gradesheet.
The finished workbook will be stored in your Canvas 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.20231127.task04.working-with-data.xlsx