Thursday, May 5, 2011

Babbage Bookkeeping Database
Create the Babbage Bookkeeping Database

1. Create the Client Table following directions
2. Create the Bookkeeper Table
3. Make a query and display the Client Number, Name, and Bookkeeper Number for all clients with 24 as the Bookkeeper. Save the query as Clients of Mario Rodriguez
4. Make a report titled Balance Due Report
5. Finish any unfinished database assignments.
6. Test on Friday

Wednesday, May 4, 2011

Database Assignments

• Create a database called U.S. Presidents Database
• The field names of your table will be:
• President Name - Primary Key
• Political Party
• Years
• All data will be text
• Save the table as Presidents
• Using the Presidents table. Create a form and report
• Make two queries. One will be called :
• Democratic Presidents
• Whig Presidents

Atlanta Hawks Database

2010-11 Roster
NUM	PLAYER	POS	HT	WT	DOB	FROM	YRS
31	Hilton Armstrong	C-F	6-11	235	11/23/1984	Connecticut	4
34	Jason Collins	C	7-0	255	12/02/1978	Stanford	9
11	Jamal Crawford	G	6-5	200	03/20/1980	Michigan	10
6	Kirk Hinrich	G	6-4	190	01/02/1981	Kansas	7
15	Al Horford - C	C-F	6-10	245	06/03/1986	Florida	3
2	Joe Johnson - C	G	6-7	240	06/29/1981	Arkansas	9
27	Zaza Pachulia	C	6-11	275	02/10/1984	Tbilisi, Georgia	7
12	Josh Powell	F	6-9	240	01/25/1983	North Carolina State	5
25	Magnum Rolle	F	6-11	235	02/03/1986	Louisiana Tech	R
5	Josh Smith - C	F	6-9	240	12/05/1985	Oak Hill Academy (Mouth of Wilson, VA)	6
19	Pape Sy	F-G	6-7	225	04/04/1988		R
0	Jeff Teague	G	6-2	180	06/10/1988	Wake Forest	1
36	Etan Thomas	C	6-10	260	04/01/1978	Syracuse	8
3	Damien Wilkins	G-F	6-6	225	01/11/1980	Georgia	6
24	Marvin Williams	F	6-9	240	06/19/1986	North Carolina	5

Create a database called Atlanta Hawks.

Create a table called Atlanta Hawks with the following fields:

·        Player Number- primary key

·        Name of Player

·        Position

·        Height

·        Weight

·        Birthday Month—data type should be lookup wizard. Type in all months

·        College

·        Years in NBA 

        All data will be text.

        The table should be sorted by Position.

        Make a form and report of the Player’s Name, College, and Years in NBa.

        Make the following queries:    

·        240 Pound Players-include all fields

·        Players with 5 Years Experience—include the fields of Player Number, Name of Player, Position, and Years in the NBA

·        Players with 6 Years Experience- include the fields of Player Number, Name of Player, Position, and Years in the NBA

·        Birthdays in February-include the fields of  Name, Birthday Month

·        Birthdays in June- include the fields of Name, Birthday Month

Save all queries with appropriate name.

Tuesday, May 3, 2011

Create the City Guide Database

• Create the Advertiser Table
• Ad Rep Table
• Create a form using the Advertiser table
• Use the form and make correction listed on handout
• Create a query to find which accounts Kyle Martinson represents.
• Prepare a report listing the advertiser's number, name, balance currently owed, and paid to date

Monday, May 2, 2011

Database Vocabulary
Open a blank word document and type the definitions using your handout of the following words:

1. database
2. database management system
3. record
4. field
5. unique identifier
6. primary key
7. query
8. data entry and update

Changing Data, Creating Queries, and Creating Reports Handout
The name of the database is Birds2U
The first table will be saved as Item table.
The second table will be saved as Supplier table.

Create a form for the supplier table.
Make a report titled Inventory Report with the item code, description, on hand, and cost include.

Wednesday, April 27, 2011

Continue learning about MS Access by creating and editing a database
Design a database listing the following:

• Employee's last name, first name, job title, address, city, state, zip, phone number, birthdate, and e-mail address.
• Add 10 - 12 records of employees (you can make up all the information)
• Students may use telephone books to fabricate address and phone number information.

Tuesday, April 26, 2011

Access Activity One

You are going to make a database titled Computer Applications Class. You will create a table in design view. You are to go around to 10 of your classmates and get the following information:

1. First Name
2. Last Name
3. Address
4. City
5. State
6. Zip Code
7. Phone Number
8. Birthday

After you collect that information, you will create a table in design view using those fields. You will then save the table as “Classmates.”  The phone number will be your primary key. You will type all the information that you gathered from your classmates  into the table.

Access Activity Two

You are going to make a database of books that you have read. The database will be titled Books. You will list the names of 10 books that you have read in your lifetime. You will make a table in design view using the following information as fields:

1. Name of book
2. Author first name
3. Author last name
4. Copyright
5. ISBN Number

You will go to the internet to find the information. Amazon.com would be a useful website. You will type in the information into your table and save the table as books. The ISBN number will be the primary key.

Monday, April 25, 2011

Introduction to Access
Creating a using a database
Ashton James College Database

Friday, April 22, 2011

Excel Test

Thursday, April 21, 2011
Lanier Village Estates Career Field Trip

Wednesday, April 20, 2011

Excel Lab 2-1 Revised
Lab 3-2 Casa Grande Resort & Spa

Tuesday, April 19, 2011

Excel Problems
Lab 2-1 Illiana Custom Homes Weekly Payroll Report
Lab 2-2 Fife's Finer Furniture

• Using the Chart Wizard Make a 3-D Bar Chart showing each customer's total new balance. The title of the chart is Accounts Receivable.

Monday, April 18, 2011

Excel Problems

• Task 2.2 purord   Purchase Order
• Task 2--3.2 Journal  Sales Journal

Read and follow all directions carefully.

Thursday, April 14, 2011

Finish
Excel Problems:
Monthly Sales Analysis Worksheet
Quarterly Expense Analysis Worksheet
College Expenses and Resources Worksheet

Webtrac- Spreadsheet Skills

Wednesday, April 13, 2011

Excel Problems:
Monthly Sales Analysis Worksheet
Quarterly Expense Analysis Worksheet
College Expenses and Resources Worksheet

Tuesday, April 11, 2011

Webtrac
Finish    Intro to IT
             Using Computers
             Spreadsheet Skills

Monday, April 11, 2011

Excel Task 3 and 4
Review of former excel problems
Finish Webtrac --Intro to IT and Using Computers

Friday, April 1, 2011

Go over each Excel problem on the overhead to ensure understanding.
Excel problems--Task Number 5 and 6

Wednesday, March 30, 2011

Excel Worksheet
Follow directions carefully for
Activities 53, 54, 55, 56, and 57

Finish any unfinished work.
Password for typing pal is GCSCGCGH.

Tuesday, March 29, 2011

Finish Excel Spreadsheets
Basic Spreadsheet Concepts Exercise 1-7

Finish Webtrac
Itro to IT
Using Computers
Password for test is ghs

Monday, March 28, 2011

Excel Exercises
Basic Spreadsheet Concepts 1-7

Finish Webtrac
Intro to IT
Using Computers

Friday, March 25, 2011

Webtrac

• Intro to IT
• Using Computers

Answer all questions. This counts for a grade.

Excel Basic Spreadheet Concepts
Exercises 1-4
By the end of the day, you should have 12 Excel exercises saved on your computer.

Thursday, March 24, 2011

Excel
Task Number 1  Formula with Addition
Task Number 2 Formula with Additon
Activity 49   Working with Formulas
Activity 52 Using Functions
Finish any unfinished excel activities from yesterday.

Wednesday, March 23, 2011

Career Activity

• 12 Steps to a successful interview

Excel Activity
Activity 44  Creating headers and footers
Activity 46  Formatting numbers and text
Activity 48  Formatting numbers and text
Activity 50  Working with formulas

Save each Excel activity in your Excel folder

Tuesday, March 22, 2011

Copy and paste the 9 questions below into a Word document. Listen to the link and answer the questions.

Job Search Strategies
After listening to these strategies, answer the following questions in a blank word document.

1. What are some important things for you to remember/know when job searching?
2. Finding jobs requires ______________, support, __________________, _________________, and attitude.
3. Name two places you can find advertised job openings?
4. Name two places you can find unadvertised job openings?
5. What is the goal of informational interviewing?
6. Name two ways to contact employers
7. The Riley __________________________ is an excellent online tool for job seekers.
8. Why would a job seeker want or need to create a web page?
9. According to Sciscione, what are the four rules for job search survival?

Save document as Job Search strategies.

Intro to Excel
Guided direction by Mrs. Perry
Type Activity 39

Be sure all career activities are saved on Mrs. Perry's flash drive.

Monday, March 21, 2011

Create a resume in MS Word using Resume Wizard

Learn about objectives, references, work experience, interests and activities

Complete any unfinished work on your career unit

Friday, March 18, 2011

• From the list of careers you have chosen, you will choose one career to research in depth.
• Go to http//www.bls.gov/k12/index.htm
• Peruse the site to see what information is available
• Find your career - enter your career in the search box
  • or go to Occupational Outlook Handbook
  • A-Z Index
• Read about your career
• Create a PowerPoint with directions from Mrs. Perry
• You will create the following slides with the information about your career:
• Title
• Training and Education
•   Earnings
• What Workers Do on the Job
• Working Conditions
• Job Outlook for the Future
•  Why I think I would Enjoy this Career

Thursday, March 17, 2011

Log into Gacollege411.org Matching Assistant College Finder

• Look at Hot Careers- top 50 careers
• Select one of the top 50 to research. Add one to your table to research. (you should now have 5)
• Go to Career Plan Builder and complete all sections
• Go to school finder and put in your program of study and match the schools
• Create a table showing 4 schools that offer your career with the following headings:
• Name
• City
• Enrollment
• Application Fee
• Average GPA
• Tuition
• From the information you find on gacollege411 or the school website (the link will be on gacollege411) fill in the information on your table.
• Format the table attractively.

  

Wednesday, March 16, 2011

On Monday you should have chosen your 4 top careers that you would like to research.
Make a Table with these headings:

• Career
• High School classes I should take
• 5 things I like about the job
• Qualifications and Certifications
• Related Occupations

Find the information on Gacollege411.org and fill in your table.
Using the skills you have learned, format your table attractively.

Tuesday, March 15, 2011

Tuesday, March 15, 2011
Review what we have learned earlier in the semester. You will type and properly format a

• Personal Business Letter
• Business Letter
• Standard Memo

from the handout you are given. Remember:

• Use the proper Margins
• Make a Letterhead for the business letter
• View
• header and footer
• Size 18 for name of business and size 10 for address, city, state, and phone number

Monday, March 14, 2011

Microsoft Word Shortcuts handout

Introduction to GAcollege411.org
Create a log in and save on a word document
Complete the personal profile
Learn About Yourself

Friday, March 11, 2011

Table Test

Thursday, March 10, 2011

Finish any unfinished tables.
Performance test on Friday.

Wednesday, March 9, 2011

Table pg. 200

• Fill in missing information
• Format attractively
• Make a border similar to the one in the book

Table 2  pg. 201

• The title should be Information About Selected States
• Your column headings should be
• State
• Rank Entering Union
• Rank Land Area
• Rank Population
• Sort the states (alphabetical order)

Table 3 pg. 201

• Format attractively and use a border shading similar to the one illustrated in the book

Tuesday, March 8, 2011

Pg. 105 Table 1 and 2

• Center the table horizontally and vertically
• Main title - row height -.05
• Column headings- .04
• data rows- .03
• Format attractively

Pg. 112
Tables 1, 2, and 3
See the left margin for special formatting instructions.
Carefully follow directions

Monday, March 7, 2011

Page 189  Activity 2 Page 190 Activity 3
Page 194 Table 1
Page 195 Table 3- supply missing information- shade per book
Page 197 Table 1 and 2

• change row height and shade per directions

Page 198-199- Table 1, 2, 3

Friday, March 4, 2011

Tables 1, 2, and 3 on page 98
Be sure you follow directions in the left margin concerning:

• Bolding main title, secondary title, column headings
• Sort feature- alphabetical order
• Each table should be on a separate document and centered horizontally and vertically
• Save as Table 1 pg. 98, Table 2 pg. 98, and Table 3 pg. 98

Finish any unfinished tables to this point.

Thursday, March 3, 2011

Tables pg. 95
Be sure you format the table correctly following the instructions on the left margin.
Each table should be on a separate document.

Activity 33C Table pg. 96
Follow special directions in the left margin

Tables 2 and 3 on pg. 97
Read and follow directions in the left margin

Wednesday, March 2

Activity 8 

• Table pg. 92
• Add a row for the title , merge cells, and bold the main title.
• Bold and center column headings. Center info in the date column and sort in ascending order. 

Activity 9

• Table pg. 92
• Merge cells for the title on the first row. 
• Sort the Artist column in ascending order.
• Change row heights. Main title row.6
• column headings .5 and other rows .4

Lesson 31 B  pg. 93

• Two tables 
• POEMS TO IMPROVE OUR LIVES
• THE PHANTOM OF THE OPERA
• One document for each table. Center each table vertically and horizontally.

Tuesday, March 1, 2011

Learn to Format Tables Pg. 87
Learn:

• Vertical placement
• Horizontal placement
• Column width
• Row Height
• Vertical Alignment
• Horizontal Alignment

Table pg. 88
Activity 1 pg. 89
Activity 3 pg. 90

Monday, Feb. 28, 2011

I hope you had a great week-end and are ready to work this week!
Report Performance Test
Good luck! :)

Friday, February 25

Make sure that all of your reports are finished on the following pages and are ready to be graded:
Pg. 65
Pgs. 70-72
pgs. 103-104
pgs. 156-158
pgs. 159-162
pg. 164
pgs. 165-166
Make sure you have a reference page and have properly documented any footnotes or endnotes in the report. The report on pg. 159 (Globalization) should have a Table of Contents page as well as a title page and reference page. Be sure you have used the styles and formatting for your headings so you can make a table of contents page. Also be sure your top margins are correct. You should have a 2 inch top margin for the first page of the report and a one inch top margin for the following pages in the report. (Remember apply to "this point forward." Your report should be double spaced except for long quotes which should be indented .05 from the left and right margin and single spaced.

Students may access my blog to view their assignments in Computer Applications.