Decatur Middle School- Excel #1


	Mike Kreicker Ann *Zinyemba*








	Word Access Excel Publisher PowerPoint

Microsoft Excel Lesson #1- Address Database

Essential Question: How can I create and organize a database to keep track of data?

NTES Standard:

5. Technology Research Tools

b. Students use technology tools to process data and report results.

By the End of Grade 7-Students know how to search and sort information in an electronic database using multiple criteria, add and delete records, and identify strategies for finding specific information.

Resources: Copies of Rubric/Checklist

Student Rubric: Click Here

Points: 10 Points

Save As: “LastNameFirstIntial”Address

Directions: Podcast

1^st Step- Find a career field you would like to go into. Example: Day Care, Physician, Dentist, Mechanic, Dog Trainer… Whatever. ONLY CHOOSE ONE JOB OR CAREER FIELD!

2^nd Step- Get into Yellow Pages and find 8 businesses you would like to work for in the career field you choose in step one. Look the businesses up by using the career field you have chosen.

3^rd Step- Write down for the 7 businesses:

Business Name

Address

City, ST Zip Code (Make up zip if you have too!)

Business Phone Number

4^th Step- Open Microsoft Excel and Add Column Headings:

Type your column headings in Row 1 on your Excel Sheet.

	A	B	C	D	E
1	Business Address	City	State	Zip Code	Phone Number
2
3

5th Step- Adding Data

Underneath your column headings you need to fill in the business information for the 7 address you looked up in Rows 2-8.

6th Step- Center Column Headings

Highlight from A1 to E1 and hit the center alignment button.

7th Step- Bold Column Headings

Highlight from A1 to E1 and hit the B to bold the headings.

8th Step- Adding Borders

Highlight from A1 to E8. Right Click<Format<Borders<Select Outline and Inside. Hit OK.

9th Step- Adding Colors

Highlight from A1 to E1. Look for the Paint Bucket and Select a Light Color.

Do the same for A3 to E3, A5 to E5, and A7 to E7, so they have color..

10th Step-Add a footer to your page.

Click on View-Header and Footer
Put your cursor inside of the Footer "dotted box" at the bottom of your page.
Type your name and class period.
Click Close on the Header and Footer bar.

11^th Step- DON'T PRINT! SAVE THIS DOCUMENT AS “LastNameFirstIntial”Address.

RUBRIC and SELF CHECKLIST!

Step	Self Check List	Teacher's Checklist
1^st Step- Choose Career!		1 Point
2^nd Step- Get Yellow Pages		1 Point
3^rd Step- Write down for the 7 businesses:		1 Point
4th Step- Add Column Headings:		1 Point
5th Step- Adding Data		1 Point
6th Step- Center Column Headings		1 Point
7th Step- Bold Column Headings		1 Point
8th Step- Adding Borders		1 Point
9th Step- Adding Colors		1 Point
10th Step-Add a footer to your page.		1 Point
	Total	___/10 Points

DMS Comp App Home ~ MSD Decatur Home Page ~ Decatur Middle School Home Page

Ann Rosborough
Decatur Middle School Computer Applications
5108 S. High School Rd.
Indianapolis, Indiana 46224