inls102- excel spreadsheets

inls 461
Information Tools

Professor: Serena Fenton
School of Information and Library Science at UNC-Chapel Hill

Excel Spreadsheets - Week 1

Excel Spreadsheets - Week 2

Excel Spreadsheets- Week 1

Due on Friday:

Reading and labs only this week
no assignment; no quiz

Required Readings and Labs:

Excel Basics	Toolbars & Vocabulary
Entering Data	Worksheets & Workbooks; Navigation; Formula Bar;
Simple Formulas	Operators Precedence and AutoSum
Filtering and Sorting	Basic data manipulation
Lab Exercise 1	Entering data
Lab Exercise 2 (.xls)	Manipulating and Formatting Data This is an excel file. The directions for the lab are displayed as comments within the file worksheets.

Sample Spreadsheets

These are real-world workbooks collected from various organizations. Save these to your computer. Use them to practice formulas, formatting, filtering and sorting.

Australian Physicians: age, sex, hours worked, etc - Data only - no formatting or formulas; good for practicing filtering and sorts
U.S. Poverty Rates: simple data; good for practicing filtering and sorts
District School Library Funding - 1 worksheet analysis of School District funding for ten school libraries. (used for lab2 Exercises)
Natural Resource Budget Template - This is a blank, preformatted, budget sheet with formulas. Examples of cell formatting and hiding rows.
Chem Lab Cost Analysis - 6 worksheets using simple formulas
Budget Calculator for Grant Proposal - includes flow chart showing the planning process and a blank, preformatted, budget sheet with formulas. Nice example of how Excel can be used.
Dairy Proforma Calculator - Large and complex set of worksheets from University of Wisconsin Center for Dairy Profitability To learn more about this workbook, see: Dairy Proforma Calculator Instructions (pdf format)

Recommended Readings:

Access through UNC's Library Resources Online: Safari TechBooks

Chapter 7 - Excel 2002 Workbooks
Chapter 8 - Restructuring and Editing Excel 2002 Worksheets
Chapter 9 - Using Excel 2002
Chapter 10 - Formatting Worksheets to Look Great

Excel Spreadsheets - Week 2

Due on Friday:

Assignment 2- Spreadsheets
Quiz 1: Spreadsheets

Required Readings and Labs:

Formatting	Formatting Cells and Data; Data Types; Alignment, Cell Wrap; Shrink-to-Fit
Formulas	Creating Formulas; Text & Logical Operations; Error Messages - reference: Examples of commonly used formulas
Charts	Charts - types and usage
Lab Exercise 3	Formulas, Formatting and Charts