icon picker
Sample databases


checked-checkbox

Practice with a sample database.

If you haven’t yet watched it, in a new tab. Then, follow the steps below to put that learning into action. Once you’ve completed the tasks, you can check your work by expanding the example dropdown.
Select all the data in this .
Copy and paste it in the space below (and see how Coda imports this data as a table automatically!).
Consider the ways this data could be improved, then implement some of those changes.
If you’re stuck, here are some ideas:
Make sure all of the currencies are formatted correctly.
Group your rows by County.
Sort your table by the What is your annual salary? column.

Expand to reveal example.

Country
How old are you?
What industry do you work in?
Job title
What is your annual salary?
Please indicate the currency
City
State
How many years of post-college professional work experience do you have?
If your job title needs additional context, please clarify here:
United States
22
Pet care
Pet sitter
$15,000.00
Pittsburgh
Pennsylvania
Market Research
Market Research Assistant
$36,330.00
Las Vegas
Nevada
Publishing
Assistant Media Editor
$41,000.00
New York
New York
Information Management
Associate Consultant
$45,000.00
Seattle.
Washington
Libraries
Director
$45,000.00
Bridgeport
Michigan
Mental Health
HR and Administrative Coordinator
$50,000.00
Baltimore
Maryland
one-man HR department and oversee administrative support for regional offices, staff events and trainings for a nonprofit
academic library
Public Services Coordinator
$50,000.00
Unknown
Massachusetts
I manage the circulation desk and student shelvers
Nonprofit
Development Manager
$51,000.00
Dallas
Texas
I manage our fundraising department, primarily overseeing our direct mail, planned giving, and grant writing programs.
Higher Ed
Associate Professor
$52,000.00
Pittsburgh
PA
Community College
Education
Teacher
$54,000.00
Unknown
Georgia
Higher Education
Student Records Coordinator
$54,371.00
Philadelphia
Pennsylvania
equivalent to Assistant Registrar
Higher education
Instructional Consultant
$58,000.00
Unknown
Wisconsin
state government - business mgmt/facilities
Associate Governmental Program Analyst
$60,000.00
Sacramento
California
catch all title for higher level admin/analyst work. 1 step below management level. pay negotiated by union, set raises at fiscal year (COL/varies) and anniversary (5%), non-negotiable pay, set ranges for pay for each job title where everyone starts at base and can max out after a couple of years.
Environmental nonprofit
Operations Director
$65,000.00
Madison
Wisconsin
Non-profit
Assistant Director of Development Research
$67,500.00
Boston
Massachusetts
Events
Event Producer
$70,000.00
Berkeley
California
IT
Support QA Lead
$71,000.00
Baltimore
Maryland
construction fastener sales
office manager
$72,000.00
Brick
New Jersey
I do sales and stock management as well - small office only 4 people
Government
Talent Management Asst. Director
$75,000.00
Nashville
Tennessee
Business Consulting
Senior Consultant
$75,000.00
Newark
New Jersey
Technical Writer
Business Services
Copywriter
$80,000.00
DC
DC
media
senior marketing manager
$90,000.00
DC
DC
Canada
4
Film & Television
Visual Effects Compositor
$50,000.00
Toronto
ON
Healthcare
Social worker (embedded in primary care)
$55,000.00
Detroit
Michigan
communications
communiity investment officer
$68,000.00
Ottawa
Ontario
Telecommunications
Marketing Manager
$73,000.00
Montreal
Quebec
United Kingdom
2
Market research
Senior research executive
$30,000.00
London
England
Biotechnology
Senior Scientist
$34,600.00
Cardiff
Wales
Unknown
1
not for profit
convention coordinator
$63,000.00
Unknown
Unknown

Up next:



Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.