Crosstab queries and pivot tables are very powerful tools for analyzing data.
Why use crosstab queries? They save a lot of work!
Crosstab queries allow users to summarize data. Provides functi
Substituting different values in
cells that are referenced by
formulas, you can see the effect
of changes when the formulas
are recalculated. This is done
Cell reference is very important!
To find the value in o
You are the head of a research think-tank in its first year of operation, after successfully
receiving funds from the Agency for Advanced Research (a hypothetical government
agency). You have been awarded funds, after your
What these applications do
Excel calculates data
Access organizes and retrieves data
PowerPoint presents information
Word documents information
ArcInfo spatially represents data
SPSS manipulates and analyzes data
Dreamweaver codes informa
Computer Ethics &
States that there should be no restrictions by ISPs or
governments on content, sites, platforms,
equipment, & modes of communication.
All content and applications on the Internet should
be treated the same, rega
Deliverables for this section of the project:
Add links to your four MS Office files
Change the image to something more appropriate for your
These instructions only pertain to using the computers in the PV151 comp
Instructor: Roger Morris
Master the use of common tools to turn
data into useful, actionable information.
Calculate net income and profit margin
Determine an exact figure for a monthly
For the Quiz
Read AC1.41.83 & AC2.4-2.81
Review the Data, Information and Databases PPT file
Fields Field Properties (know all)
Primary key foreign key
Views: datasheet and design
Answer the following questions using Filtering
columns for the IU Grads database:
How many Cardiologists make $60,964 or
How many nurses who teach have
appointments of 10 months and make
$54,260 or more?
How many posi
Hypertext Markup Language
This is what HTML looks like:
<!DOCTYPE html PUBLIC "-/W3C/DTD XHTML 1.0 Transitional/EN"
<title>This is your web page </title>
<link href="v261.css" rel="st
Using charts and plotting to make sense of data
The best graph needs no explanation!
What types of charts are good for
what types of data?
Area Charts - magnitude of change over time by
emphasizing the area under the curve.
What types of charts are good
Going from Data to Information
Management Information System
A Veritable Bucket of Facts
Its advocates suggest that the best use of the
computer, the only one to truly exploit its potential,
was to bu
V261 Final Project Considerations for Grading
As I look over your final projects, I will be paying close attention to the following:
Did you use cell and/or 3D reference with your calculations?
Do you have 5 different worksheets all lab
Exam 1 General Notes
Worth 200 pts.
Applied (hands on with Excel)
Multiple Choice (on Oncourse)
You may only use the sheet I provide for
No calculators! You must use Excel.
May only use the computer in the room.
1 hour 15 min. time limit
StartExcel. Locate the following:
-Quick Access bar
What happens to the pointer as you move over objects in the workbook?
Exam 1 Review Questions
What is the difference between absolute and relative reference?
What happens when you copy a formula with relative and/or absolute references? Are the
copied cells the same or different?
How do you recognize multi-sheet references
Use Excel to solve each problem
~User your calculator first then go to Excel and see if they match~
16 * 40/5 + 24_ with calculator _
18+4 * 75_ _
Auto Fill and AutoSum
1) Use Auto Fill starting in
Crosstab queries and pivot tables (in Excel and older versions of Access) are very powerful
tools for analyzing data.
Why use crosstab queries? They save a lot of work!
Crosstab queries allow users to summarize dat
Access Assignment 1
(You may receive up to 10 pts)
1. Building a Database
Select Blank Database
Below File Name: name the file Your_name_catalog
You will create two tables. The first one is called Catalog. The second one is called Location.
Page 1 of 2
Flat File Database vs Relational Database
Flat file database
May contain many fields
Duplicate & redundant data
Prone to corruption
Big disadvantage: What if a customer moved? Every record would have to be changed.
Pivot Table Resources
To create a Pivot Table, click on the data some place. It doesnt matter where, it just needs to be
within the range of data. For example:
From the Insert tab in Excel, click on Pivot Table and then select Pivot Table from the drop
V261In-Class Practice. Complete as many problems as you can in class.
A company has expenses of $3,000 in December that change each month according to the
following table. Calculate the expenses for each month based on the percentage change
V261 Reading Assignment
For next class (6 Charts, plotting and linear regression )
Use any web source you would like to find brief definitions of the following
termsWikipedia, for example. Write definitions to each term and bring to
class. Your understand
Adopted children should have access to birth records
Aggressive driving (road rage) could be reduced by anger management
Air bag restraint systems reduce traffic fatalities
Alcohol advertising promotes underage drinking
Alien labor and high technology job
Z Web Design is embarking on a large data project and needs an office set up with new
hardware, software, and servers. Z Web Design wants to be ab
Request For Proposal Notes
Research project needs & possible solution providers
Optional RFI (Request for Information) to weed out certain vendors
Send RFP to vendors
Review & choo