Dear Class:
Open notes and make sure we have all these terms: Database, record, field, datatype. ADD objects, table, form, report, querie.
Open Class database in datasheet view—what can we do with it??
Basic—can’t change the header/footer, you can delete it in setup, only have one font, one size for rows
Sizing columns—double clicking between field names or sliding
Sorting—Highlight entire field and use AZ↓ or ZA↓
Highlight a field and use binocular icon to look in, match, search
Navigation bar at bottom to move between records
A "pencil" is displayed on the left when editing a record
A "triangle" is displayed on the left when selecting a record
Add or delete a record
Add a new field in design view—School
Type in David Douglas High School one time and use Control ‘ to repeat in every cell
Work on some OJBECTS:
Create a FORM using wizard
Choose all the fields
Choose a layout—columnar is good for now
Choose a style
Give it a name—click finish
Does everything fit
View/Design View to edit
Edit Field Box and Detail Box
Change font and size
Rearrange to make sure it fits
Shift click to highlight more than one box
Use the paint brush for editing
View Form View to check it out
Print Preview—use the icons to view one, two, multiple pages
Use navigation to get to new record and add the teacher
Was it easier to input data in a form or table object???
Create a Report—create a report using wizard—choose the class table
Pick four fields
Pick a grouping—group by age
Pick a sort—sort by last name
Pick a layout
Pick a style
Give it a name
Edit the report in design view
Header—contains field name
Detail—actual information
Use paint brush
Numbers right align/words left align
Select and size or edit—click to select, use hand to move
Shift Click header and detail to move both
Make sure everything fits and is centered
Same alignment icons as in WORD
Change footer
Delete the entire text box on right—page x of x
Change =now() (function for date and time) to =”your name—period x” (string)
Open Database Notes and update vocabulary if needed
ASSIGNMENT:
Create a report using what you just learned—choose at least 5 fields
SAVE, PRINT and turn in
Group by age?? By Eye color?
Friday, February 4, 2011
Wednesday, February 2, 2011
Thursday, February 3, 2011
Dear Class:
Please open up your student account on the DDHS server and then open up this blog so that you know what we will be doing today.
Please open up the Database notes we did and we will be adding to them the definition of: objects, table, form, and report.
Then, open up the "Class database" file we did last time. This will reflect the following:
First Name
Last Name
Age
Favorite Food
Favorite Color
Gender
Eye Color
Birth Month
Job
Database Exp
Programming Exp
Grade
Hobbies
Siblings
Middle School
Sports
You were to write them on a piece of paper and then plug your information on the database itself.
Now, I will be handing out the papers that you did to other students. You will be filling in that raw data into the "Class Database" that we will be using.
Please open up your student account on the DDHS server and then open up this blog so that you know what we will be doing today.
Please open up the Database notes we did and we will be adding to them the definition of: objects, table, form, and report.
Then, open up the "Class database" file we did last time. This will reflect the following:
First Name
Last Name
Age
Favorite Food
Favorite Color
Gender
Eye Color
Birth Month
Job
Database Exp
Programming Exp
Grade
Hobbies
Siblings
Middle School
Sports
You were to write them on a piece of paper and then plug your information on the database itself.
Now, I will be handing out the papers that you did to other students. You will be filling in that raw data into the "Class Database" that we will be using.
Monday, January 31, 2011
Tuesday, February 1, 2011
Dear Class:
Database
Day One:
What is a database?
Why use a database—information about customers, information about inventories, any type of information a business would need. You can design, manipulate, sort, and print.
Who has a database—schools, libraries, government, stores, banks, business on inventory and employees
Internet Search:
Who won the Heisman trophy 2 years in a row?? (1974 1975 Archie Griffen
Who Was David Douglas named after?? (David Douglas, a botanist)
Who are some notable alumni from David Douglas??
Record?
Field?
Requirements: contain a unique name, describe the field, <= 64 characters, cannot begin with a space, can’t use . , ! [ ]
Fields have data types—text, number, currency, date/time, yes/no, OLE Object (picture), hyperlink (address), lookup wizard (giving options)
Field size—usually default works but you can assign different sizes
Who has a long name that always gets cut off???
Icebreaker—creating a database about our class
What do we want to find out about each other—pick 10 fields
First Name
Last Name
Age
Favorite Food
Favorite Color
Gender
Eye Color
Birth Month
Job
Database Exp
Programming Exp
Grade
Hobbies
Siblings
Middle School
Sports
Write them on a piece of paper
Pair up to find out information about someone in the class—record it on paper
Let’s put our class in a database. . .
Create a database
Different programs: MS ACCESS, Oracle, Dbase
We use ACCESS
Determine fields and data types
Enter your own data on the first line and SAVE it.
Pass the papers around the room and have each of you enter all the informtion on your own computer.
Open WORD document and create a “Database Notes” file
Vocabulary: database, field, record, data types
Database
Day One:
What is a database?
Why use a database—information about customers, information about inventories, any type of information a business would need. You can design, manipulate, sort, and print.
Who has a database—schools, libraries, government, stores, banks, business on inventory and employees
Internet Search:
Who won the Heisman trophy 2 years in a row?? (1974 1975 Archie Griffen
Who Was David Douglas named after?? (David Douglas, a botanist)
Who are some notable alumni from David Douglas??
Record?
Field?
Requirements: contain a unique name, describe the field, <= 64 characters, cannot begin with a space, can’t use . , ! [ ]
Fields have data types—text, number, currency, date/time, yes/no, OLE Object (picture), hyperlink (address), lookup wizard (giving options)
Field size—usually default works but you can assign different sizes
Who has a long name that always gets cut off???
Icebreaker—creating a database about our class
What do we want to find out about each other—pick 10 fields
First Name
Last Name
Age
Favorite Food
Favorite Color
Gender
Eye Color
Birth Month
Job
Database Exp
Programming Exp
Grade
Hobbies
Siblings
Middle School
Sports
Write them on a piece of paper
Pair up to find out information about someone in the class—record it on paper
Let’s put our class in a database. . .
Create a database
Different programs: MS ACCESS, Oracle, Dbase
We use ACCESS
Determine fields and data types
Enter your own data on the first line and SAVE it.
Pass the papers around the room and have each of you enter all the informtion on your own computer.
Open WORD document and create a “Database Notes” file
Vocabulary: database, field, record, data types
Monday, January 24, 2011
Monday, January 24, 2011
ear Class:
Today, I want to continue to look at transitioning to GameMaker 8.0. GameMaker 8.0 is already loaded, although you may have to go to the C drive to load it. The first tutorial consists of:
There are two that are beginner level:
The Scrolling Shooter and the Maze game Either one is beginner. I had another shooter game but it was advanced and I found out you need Game Maker Pro to use it (It has 3D included in it).
There are sounds and icons as well as samples are on the YoYo Games Site. They are in compressed form and I am not sure if 7-up or another decompression software is available. I will have the folders available on "My network places", "View workgroup computers", and then "Green-Hite" computer. It will be in the only shared folder. Only nine students can be on it at a time so I suggest copying the folder to your student folder and then disconnect off of mine.
You did a really good job last time on the Islands and the plane.
We will see how we do!
Review for the final: It will consist of writing a C++ and a Visual Basic program that will be similar to other programs that we ran. You may print out a C++ program, like "Calculator" that has most of the formula and then print out a Visual Basic program such as "Multiplier". You can use these on the final!
Sincerely,
Mr. Green-Hite
Sincerely,
Mr. Green-Hite
Today, I want to continue to look at transitioning to GameMaker 8.0. GameMaker 8.0 is already loaded, although you may have to go to the C drive to load it. The first tutorial consists of:
There are two that are beginner level:
The Scrolling Shooter and the Maze game Either one is beginner. I had another shooter game but it was advanced and I found out you need Game Maker Pro to use it (It has 3D included in it).
There are sounds and icons as well as samples are on the YoYo Games Site. They are in compressed form and I am not sure if 7-up or another decompression software is available. I will have the folders available on "My network places", "View workgroup computers", and then "Green-Hite" computer. It will be in the only shared folder. Only nine students can be on it at a time so I suggest copying the folder to your student folder and then disconnect off of mine.
You did a really good job last time on the Islands and the plane.
We will see how we do!
Review for the final: It will consist of writing a C++ and a Visual Basic program that will be similar to other programs that we ran. You may print out a C++ program, like "Calculator" that has most of the formula and then print out a Visual Basic program such as "Multiplier". You can use these on the final!
Sincerely,
Mr. Green-Hite
Sincerely,
Mr. Green-Hite
Monday, January 17, 2011
Tuesday, January 18, 2011
Dear Class:
Today, I want to continue to look at transitioning to GameMaker 8.0. GameMaker 8.0 is already loaded, although you may have to go to the C drive to load it. The first tutorial consists of:
Tutorial
Example
Resource 1
Resource 2
Resource 3
Resource 4
Resource 5
There are two that are beginner level:
The Scrolling Shooter and the Maze game Either one is beginner. I had another shooter game but it was advanced and I found out you need Game Maker Pro to use it (It has 3D included in it).
There are sounds and icons as well as samples are on the YoYo Games Site. They are in compressed form and I am not sure if 7-up or another decompression software is available. I will have the folders available on "My network places", "View workgroup computers", and then "Green-Hite" computer. It will be in the only shared folder. Only nine students can be on it at a time so I suggest copying the folder to your student folder and then disconnect off of mine.
You did a really good job last time on the apple and the wall.
We will see how we do!
Sincerely,
Mr. Green-Hite
Today, I want to continue to look at transitioning to GameMaker 8.0. GameMaker 8.0 is already loaded, although you may have to go to the C drive to load it. The first tutorial consists of:
Tutorial
Example
Resource 1
Resource 2
Resource 3
Resource 4
Resource 5
There are two that are beginner level:
The Scrolling Shooter and the Maze game Either one is beginner. I had another shooter game but it was advanced and I found out you need Game Maker Pro to use it (It has 3D included in it).
There are sounds and icons as well as samples are on the YoYo Games Site. They are in compressed form and I am not sure if 7-up or another decompression software is available. I will have the folders available on "My network places", "View workgroup computers", and then "Green-Hite" computer. It will be in the only shared folder. Only nine students can be on it at a time so I suggest copying the folder to your student folder and then disconnect off of mine.
You did a really good job last time on the apple and the wall.
We will see how we do!
Sincerely,
Mr. Green-Hite
Thursday, January 13, 2011
Thursday, January 13, 2011
Dear Class:
Today, I wanted to look at transitioning to GameMaker 8.0. GameMaker 8.0 is already loaded, although you may have to go to the C drive to load it. The first tutorial consists of:
Tutorial
Example
Resource 1
Resource 2
Resource 3
Resource 4
Resource 5
There is also "shooter" one.
Tutorial
Sample 1
Sample 2
Sample 3
Sample 4
Sample 5
Sample 6
Sample 7
We will see how we do!
Sincerely,
Mr. Green-Hite
Today, I wanted to look at transitioning to GameMaker 8.0. GameMaker 8.0 is already loaded, although you may have to go to the C drive to load it. The first tutorial consists of:
Tutorial
Example
Resource 1
Resource 2
Resource 3
Resource 4
Resource 5
There is also "shooter" one.
Tutorial
Sample 1
Sample 2
Sample 3
Sample 4
Sample 5
Sample 6
Sample 7
We will see how we do!
Sincerely,
Mr. Green-Hite
Thursday, January 6, 2011
Friday, January 17, 2011
Dear Class:
There is a good source of tutorials at http://www.vbtutor.net/ that I want to look at.
We worked on the first lesson of the tutorial at the website and the second lesson. I wanted the "simple calculator" and the "color changer RGB" done. We ended up, last class, doing the BMI calculator at the end of Lesson 7.
I want to, as a class, look generally at how to manipulate each of the "objects" put into a program about "Feelings". You will name each picture as "PicHappy", "PicOK", and "PicSad" and for the text, "TextHappy", "TextOK", and "TextSad".
Lesson 3 talks about properties, including color schemes and naming of the window. Lesson 4 talks about object oriented program "OOP" and Lesson 5 speaks of writing the code. Lesson 6 refreshes our minds about managing data (integers, etc. that we have seen before)
We finished Lesson 7 in which you did the "BMI" calculator. I recorded those last time. I do want to do the "grade" calculator in Lesson 10.
Sincerely,
Mr. Green-Hite
There is a good source of tutorials at http://www.vbtutor.net/ that I want to look at.
We worked on the first lesson of the tutorial at the website and the second lesson. I wanted the "simple calculator" and the "color changer RGB" done. We ended up, last class, doing the BMI calculator at the end of Lesson 7.
I want to, as a class, look generally at how to manipulate each of the "objects" put into a program about "Feelings". You will name each picture as "PicHappy", "PicOK", and "PicSad" and for the text, "TextHappy", "TextOK", and "TextSad".
Lesson 3 talks about properties, including color schemes and naming of the window. Lesson 4 talks about object oriented program "OOP" and Lesson 5 speaks of writing the code. Lesson 6 refreshes our minds about managing data (integers, etc. that we have seen before)
We finished Lesson 7 in which you did the "BMI" calculator. I recorded those last time. I do want to do the "grade" calculator in Lesson 10.
Sincerely,
Mr. Green-Hite
Subscribe to:
Posts (Atom)