Tuesday, December 18, 2012

Dear Class: The first tutorial we did together with the evil clown. We should be done with that...We will do the "first tutorial" on that site that consists of the cherries, apples, etc that were worth points. The tutorial that was the shooter tutorial was the wrong one. I want to do the shooter that I had done previously. Let me know if there are problems getting the sprites for this one if we get to the shooter. Thanks. Sincerely, Mr. Green-Hite

Wednesday, December 12, 2012

Dear Class:

I need the "BMI" calculator; Take a picture of it and save it at "BMI Calculator" in case I did not see it. Do that with the "Radio Button" one as well and title it "Happy Face" and save in your shared folder.

Today, 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
. The best link for the first tutorial that has the sprites and music is First Tutorial. You will need to download and open folder. If you can't, you will have to go to My Network Places, View Workbook Computers, and then find my computer. This is the "Evil Clown". I will be explaining it up on the screen while we do it!! Sincerely, Mr. Green-Hite

Monday, December 10th, 2012

Dear Class:

This is an add on to the previous part we were doing.

We finished Lesson 7 in which you did the "BMI" calculator. I recorded those last time. As an exit "test" for Visual Basic, you are being asked to create a program on your own that you create from scratch. It has to have at least 2 buttons, four text boxes and 4 labels. It must serve a function, such as figuring out sales tax for purchases. Changed: Do the radial button. You could do the "grades" that are in Lesson 10 in place of that if no other options...

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

We will see how we do!

Sincerely,
Mr. Green-Hite

Thursday, December 6, 2012

Dear Class: We played "catch-up" last class and finished with "Coins". We will continue with our pursuit of happiness in exploring Visual Basic. Continuing with Lesson 5, we will get a bit further before we switch to another program. Lesson 7 has the BMI assignment. We will do the "Coin" assignment together that will be up on the screen. Continue with Sincerely, Mr. Green-Hite

Tuesday, December 4, 2012

Dear Class: We played "catch-up" last class and finished with the "Color" and "Lottery". We will continue with our pursuit of happiness in exploring Visual Basic. Continuing with Lesson 5, we will get a bit further before we switch to another program. Lesson 7 has the BMI assignment. We will do the "Coin" assignment together that will be up on the screen. Sincerely, Mr. Green-Hite

Friday, November 30, 2012

Dear Class: We will continue with our pursuit of happiness in exploring Visual Basic. Continuing with Lesson 5, we will get a bit further before we switch to another program. Lesson 7 has the BMI assignment. We will do the "Coin" assignment together that will be up on the screen. Sincerely, Mr. Green-Hite

Wednesday, November 28th, 2012

Dear Class:

There is a good source of tutorials at http://www.vbtutor.net/ that I want to look at.

We will work on the first lesson of the tutorial at the website

Lesson 1 had us just do a simple button. In lesson 2, we started to do a simple calculator. I was going to check off most of yours but was not able to do all of them. The next lessons are old friends. 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.

Please do the "Lottery" VB program today

Lesson 6 refreshes our minds about managing data (integers, etc. that we have seen before) and then Lesson 7 is about Mathematical Operations in which you will all do the "BMI" calculator (your fat). I hope to get this far today...

Sincerely,
Mr. Green-Hite

Monday, November 19, 2012

Dear Class:

There is a good source of tutorials at http://www.vbtutor.net/ that I want to look at.

We will work on the first lesson of the tutorial at the website

Lesson 1 had us just do a simple button. In lesson 2, we started to do a simple calculator. I was going to check off most of yours but was not able to do all of them. The next lessons are old friends. 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) and then Lesson 7 is about Mathematical Operations in which you will all do the "BMI" calculator (your fat). I hope to get this far today...

Sincerely,
Mr. Green-Hite

Thursday, November 15, 2012

Dear Class:

We will finish the following "Airplane" as a final project for C++.

I will give you the first 15 minutes to complete. Those that are done please have it up on the screen...I will check it off. There is a good source of tutorials at http://www.vbtutor.net/ that I want to look at.

We will, hopefully, work on the first lesson of the tutorial at the website

Lesson 1 has us just do a simple button. In lesson 2, we will do a simple calculator. The next lessons are old friends. 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) and then Lesson 7 is about Mathematical Operations in which you will all do the "BMI" calculator. I hope to get this far today... Sincerely, Mr. Green-Hite

Dear Class:

We will do the following "Airplane" as a final project for C++.

Look at p. 84 to end.

we will do the "Airplane" that is written for you. 1 2 3 https://docs.google.com/leaf? id=0B52XXyfOPY81ZWRhOGNiODYtZmMzMi00NWUwLWI5NmEtMmUzMGE1NTM4NjYw&hl=en&authkey=CLWhnKUC 5

Sorry, page 4

,



There is a good source of tutorials at http://www.vbtutor.net/ that I want to look at.

We will, hopefully, work on the first lesson of the tutorial at the website

Lesson 1 has us just do a simple button. In lesson 2, we will do a simple calculator. The next lessons are old friends. 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) and then Lesson 7 is about Mathematical Operations in which you will all do the "BMI" calculator. I hope to get this far today... Sincerely, Mr. Green-Hite

Thursday, November 8, 2012

Dear Class:

Completing Chapter 3, I want to talk about messages, strings, and concatenation of strings.

Run it but do not print out the menu. I looked at it last time but may not have seen yours. Print screen it and put in a document that is shared!.

I would like you, on your own, to do the project 3-4 on page 64 (area of a box). Don't forget about the menu I need to check off!

I want to get into chapter 4. I want to look at it together.

Chapter 4
Chapter 4 (b)
I need in your folders: Menu (print screen of it), Message (doing today together; print screen it), Area of Box (print screen of it). These will go in grades this weekend. We are into chapter 4. I want to look at it together.

Chapter 4 (b).

Today I want to see if we can get the chapter done but maybe not.

I want to watch a couple of tutorials on this site:
http://www.softwaretrainingtutorials.com/c-plus-plus.php

http://www.fafiles.com/index.php?course=cppPage

This site is a tutorial on 3d programming using C++ and OpenGL.
http://www.videotutorialsrock.com/index.php



Hope this helps.

Sincerely,
Mr. Green-Hite

Tuesday, November 6, 2012

Dear Class:

Continuing with Chapter 3, I want to talk about Overflow and Underflow.

Run it but do not print out the menu. We will look at it next time to run and print it together.

I would like you, on your own, to do the project 3-4 on page 64. We already did the Activity 3-1 on page 66. Don't forget about the menu I need to check off!

I want to get into chapter 4. I want to look at it together. Sorry for the delay.

Chapter 4
Chapter 4 (b)

Hope this helps.

Sincerely,
Mr. Green-Hite

Friday, November 2, 2012

Dear Class:

We will continue with Chapter 3. Together, do code list 3-4 on page 47. We will continue from there.
I talked about pages 54 and 55 regarding mixed data types and how it affects calculations. There is a reference to "promotion" and "typecasting". Read these two pages on your own. Please run and print and hand in. At times there will be a "truncated" issue with floating-point number. Read on your own page 56 and 57. Page 57 has the same code list, more or less, as page 55. Just look at that code and see what was changed and what it would do. Together, do code list 3-3 on page 46. We will continue from there. Together do Code List 3-8 on page 55 for Promotion and take a screen shot of it. I want you to "copy" the review questions on page 62-63, 1-10 and 1-10, answer them, save on google docs, and put in your shared folder. Do project 3-1 as extra credit and Project 3-4 and run them. I will check them from screen shots from here on in...there are just too many of you to be able to get around to each. I will show you what I want done. We need to create a new folder as C++ and put the document there.

Chapter 3

I want you to do the Menu that is linked. The links are Page 1 and Page 2


Chapter 3

Sincerely,
Mr. Green-Hite

Wednesday, October 31, 2012

Dear Class: Happy Halloween!!!

We will start and continue with Chapter 3. These are more of a review of math with a few new twists to the standard operations of addition, subtraction, multiplication, and division. There will be the modulus which will include the leftover. We will just continue in Chapter 3 from there. Page 44 we will look at the code list 3-2 but we will not do it. We will look closely, however, at page 45, because of the "statements" and "results". I want to talk about Overflow and Underflow.
Together, do code list 3-4 on page 47. We will continue from there.
I talked about pages 54 and 55 regarding mixed data types and how it affects calculations. There is a reference to "promotion" and "typecasting". Read these two pages on your own. Please run and print and hand in. At times there will be a "truncated" issue with floating-point number. Read on your own page 56 and 57. Page 57 has the same code list, more or less, as page 55. Just look at that code and see what was changed and what it would do. Together, do code list 3-3 on page 46. We will continue from there. I want you to "copy" the review questions on page 62-63, 1-10 and 1-10, answer them, save on google docs, and put in your shared folder. Do project 3-1 and Project 3-4 and run them. I will check them on screen and then grade them.

Chapter 3

I want you to do the Menu that is linked. The links are Page 1 and Page 2


Chapter 3

Sincerely,
Mr. Green-Hite

Monday, October 29, 2012

Dear Class:

You did the quiz which was the Activity 2-1 on your own. This will count as the exit quiz for Chapter 2. This is simply taking the English language equivalent and writing it in program language! Please pull it up on your screen so that I can grade it.

We move into Math Operations for Chapter 3. These are more of a review of math with a few new twists to the standard operations of addition, subtraction, multiplication, and division. There will be the modulus which will include the leftover. I want to look particularly a page 45 and the using of arithmetic operators. I want to do the "Bus Trip" Page 1 and page 2 program. It is more advanced but I think it important that you see what a simple operator can do. We will just continue in Chapter 3 from there.

Sincerely,
Mr. Green-Hite

Wednesday, October 24, 2012

Dear Class:

Do step 2-3 on page 29 and check if there is a difference? We need to look at Floating Point Variables, Boolean Variables (I talked of last time), and Constants. Do code list 2-3 on Page 34. Do code list 2-4 on page 36.

Finally, please enter, compile, and run Project 2-2 on page 40. We will do this one together. This Project combines the constant and variable declarations and initialization.

As a quiz, I want you to do Activity 2-1 on your own. This will count as the exit quiz for Chapter 2.

We move into Math Operations for Chapter 3. These are more of a review of math with a few new twists to the standard operations of addition, subtraction, multiplication, and division. There will be the modulus which will include the leftover. I want to look particularly a page 45 and the using of arithmetic operators. I want to do the "Bus Trip" Page 1 and page 2 program. It is more advanced but I think it important that you see what a simple operator can do. We will just continue in Chapter 3 from there.

Sincerely,
Mr. Green-Hite

Monday, October 22, 2012

Dear Class:

Grades are done... hallelujah! Please check. I need some work from some of you from the database.

The first programs are simple but you need to practice these programs to get them to work properly. Make sure you understand the five parts of the basic structure of a C++ program: 1) Compiler directive #include, 2) Main Function, 3) Braces to mark the beginning and end 4) Statement followed by a ; last statement is return 0; and 5) can also have comments which are ignored by the compiler but necessary to the programmer.

We need to break down your programs.

We will be talking about the five basic data types: int, Float, Double, char, and void. Assignment statements. These will be important in the developing an algorithm and coding the problem. This will take us into the first half of Chapter 2. We will look at this together!

Chapter 2
Binary Code

Good day to you! We will begin with looking and naming variables. To initialize a variable you simply assign it a value. You must declare a variable before you can use it. On page 29-30, there are examples of keywords and improper C++ variable identifiers. Check out the character and equivalent decimal value located on page 30.

Do 2-1 in book on page 27 and then do the step by step 2-2. Do step 2-3 on page 29 and check if there is a difference? We need to look at Floating Point Variables, Boolean Variables, and Constants. Do code list 2-3 on Page 34. Do code list 2-4 on page 36.

Finally, please enter, compile, and run Project 2-2 on page 40. This will probably bring us to the end of the class.

Sincerely,
Mr. Green-Hite

Wednesday, October 16, 2012

Dear Class:
Today, we will be adding to the notes on programming in general and C++ notes in particular in a google document. Share with me that google document by placing it in your shared folder. I want you to continue to work on the "Travel" program below and make sure that we figure out any "bugs" it has.

I will have a scan of parts of the text entitled Introduction to Computer Science Using C++ 3rd edition. This may be checked out in the book room if you wish.

We will look at binary numbers (machine language) this class.

As you work on your "Travel" program, please have "Hello World" and "Your name" program up so that I can enter it in my grade book. />I want to do a more complex C++ program. Travel program we started.

I went over the following attachment last class Continuing with binary numbers. I do want to go over it regarding binary code, interpreters, and compilers. Also, look at the various programs and how they do the same thing in the above document. />
Finally, we will look at Chapter 2 in the book.

Sincerely,
Mr. Green-Hite

Monday, October 15, 2012

Dear Class:
Today, we will be adding to the notes on programming in general and C++ notes in particular in a google document. Share with me that google document by placing it in your shared folder. I want you to continue to work on the "Travel" program below and make sure that we figure out any "bugs" it has.

I will have a scan of parts of the text entitled Introduction to Computer Science Using C++ 3rd edition. This may be checked out in the book room if you wish.

We will look at binary numbers (machine language) this class.

As you work on your "Travel" program, please have "Hello World" and "Your name" program up so that I can enter it in my grade book. />I want to do a more complex C++ program. Travel program we started.

I went over the following attachment last class Continuing with binary numbers. I do want to go over it regarding binary code, interpreters, and compilers. Also, look at the various programs and how they do the same thing in the above document. Open a google doc, title it "Binary code name" and then put in english what the below binary code is and then put your name in binary code after it. What is the following? 01010111 01101000 01100001 01110100 01101001 01110011 01111001 01101111 01110101 01100010 01101110 01100001 01100111 01100101 Then put your name down in binary code (example): 01001010 (74) 01101111 (111) 01001000 (72) 01001110 (78) 01000111 (71) and then on. />
Finally, we will look at Chapter 2 in the book.

Sincerely,
Mr. Green-Hite

Wednesday, October 10, 2012

Dear Class:
Today, want to look at the notes on programming in general and C++ notes in particular in a google document. Share with me that google document by placing it in your shared folder. We will get to "Hello World!" and make sure that we figure out any "bugs" it has.

I will have a scan of parts of the text entitled Introduction to Computer Science Using C++ 3rd edition. This may be checked out in the book room if you wish.

We will look at binary numbers (machine language) this class.

We will have a quiz on the vocabulary words next class!
/>I want to do a more complex C++ program. Travel program we started.

I went over the following attachment last class Continuing with binary numbers. />
Finally, we will look at Chapter 2 in the book.

Sincerely,
Mr. Green-Hite

Monday, October 2, 2012

Dear Class: I would like you to finish the "Automobiles" database today since you should have been done with "superheroes" on Friday. I would like to move on to C++ on Thursday. This is the first part of the class that consists of Database that is broken up into three projects: The rough data that the class supplied and that we "roughed in" using Excel. Then, we created rough reports and a query from. The second section was information you supplied through internet searching. This part was more "refined" and I had you center the Title and put in a footer. The last section is the "Access" final project. This is information that is provided by me and the final reports and queries will look the same...The grading will be very precise on this one. Again, the title will have to be centered, the title will be the same one on the project sheet as on your report/query. Finally, all of the seven parts will include a footer with your name and the period (=() will be changed to ="Last First Name--Period 7 or 8". What I want in your folders is up on the board. I am still grading these. If you get done early, and I know some of you will, you may use the following link for "educational games". I need them evaluated anyway as to how good they are. Good Luck! Sincerely, Mr. Green-Hite

Friday, September 28, 2012

Dear Class: I would like you to finish the "Automobiles" database today. I would like to move on to C++ on Tuesday. This is the first part of the class that consists of Database that is broken up into three projects: The rough data that the class supplied and that we "roughed in" using Excel. Then, we created rough reports and a query from. The second section was information you supplied through internet searching. This part was more "refined" and I had you center the Title and put in a footer. The last section is the "Access" final project. This is information that is provided by me and the final reports and queries will look the same...The grading will be very precise on this one. Again, the title will have to be centered, the title will be the same one on the project sheet as on your report/query. Finally, all of the seven parts will include a footer with your name and the period (=() will be changed to ="Last First Name--Period 7 or 8". What I want in your folders is up on the board. I will be grading these this weekend. If you get done early, and I know some of you will, you may use the following link for "educational games". I need them evaluated anyway as to how good they are. Good Luck! Sincerely, Mr. Green-Hite

Wednesday, September 24, 2012

Dear Class: I want you to finish the "superhero" database today. This is the first part of the class that consists of Database that is broken up into three projects: The rough data that the class supplied and that we "roughed in" using Excel. Then, we created rough reports and a query from. The second section was information you supplied through internet searching. This part was more "refined" and I had you center the Title and put in a footer. The last section is the "Access" final project. This is information that is provided by me and the final reports and queries will look the same...The grading will be very precise on this one. Again, the title will have to be centered, the title will be the same one on the project sheet as on your report/query. Finally, all of the seven parts will include a footer with your name and the period (=() will be changed to ="Last First Name--Period 7 or 8". Good Luck! Sincerely, Mr. Green-Hite

Monday, September 24, 2012

Dear Class:

Due to the "tainted" nature of the data we used before, we are going to create a new one using data you will acquire from the internet. You will be creating a new table using the "design" view. This database will consist of 10 superheroes of your selection. It will have their superhero name, "human" name, their power, Male/Female (yes/no), Weakness (yes/no), What the weakness is, Specific group associated with, Marvel, DC, or other, year appeared, and main arch rivalry. I want the title of the Reports to be centered and ="your name--Period 7/8" at the bottom. I will go over this at the beginning of the class. Report 1: All areas with the names in descending order. Query 1: Hero Name, Power(s), only males, weakness, only Marvel, and year appeared. Report 2: Hero Name, Human Name, Arch Enemy, Group affiliation Query 2: Hero Name, Weakness (yes) but do not show, Actual Weakness, Human name />
Sincerely,
Mr. Green-Hite

Thursday, September 20, 2012

Dear Class: Open up your DB ACCESS from Tuesday. The Job column, DB experience, and the Programming experience should be yes/no. The money column should be currency. This is done in design view. I want two reports done today; first one with Last (change to descending), First, Food, Color, Middle School, Grade, and Age (in that order). I want you to do a second report with Last, First, and any other four that you have with First Name in descending order. When you are done, these reports will be shared with me by uploading the file to google docs and put into your shared folder for me. To "print" these, they will be printed as "PDF" file and then uploaded to your account. I want to then do a query with Last name, first name, age, jobs, DB experience, Programming experience, and money. The query will have with jobs only (yes or not "no"), money (greater than or equal to $20). Have the last name as "descending" and show all. The project will be on cars. Sincerely, Mr. Green-Hite

Friday, September 14, 2012

Dear Class: I have a substitute today. Please render all honors to him or her. I am going to have you watch a series of Videos to teach you the first part of ACCESS. Video 1 Video 2 Video 3 Video 4 I want you to open up your gmail account and then download your excel spreadsheet. Open up ACCESS and create a new database. Do "Create Table by entering Data". You will be clicking on "A" and selecting that column. Copy it and then go to "Field 1" and click it. It will activate that column then simply go "Paste". You will have to then save it, double click on "Field 1" and put in "First Name" and delete that from the first field. Do that with all of the columns. Then, play a little with it. Sincerely, Mr. Green-Hite

Wednesday, September 12, 2012

Dear Class:

Open WORD document and create a “Database Notes” file
Vocabulary: database, field, record, data types, objects, table, form, report, querie.

Sites that can help: Access 2003 tutorial

Access 2003

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?

Monday, September 10, 2012

Dear Class: All of the class needs to get into their gmail account through ddhspages.net sign in. I will show you how to get there. We will first create a "collection" or folder that you will share with me. It will be titled "Last Name First Name". You will go to the drop down arrow at the side of the folder and go to "share". Put in my email address and share the folder with me. Then, please open up a "doc" and name it "Definitions". I want to look at an article regarding computer and human error for data.

Please open up your "database" we worked on last time and then open up this blog so that you know what we will be doing today. I made an excel spreadsheet that we will be using with your scores on it. I will explain it to you in class. Spreadsheet

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 type them in a shared google doc and then plug your information on the database itself.

You will be "Correcting" that raw data into the "Class Database" that we will be using. In programming, you cannot have data that is "off" or "inconsistent" or a program will not work (although there are certain internal checks).

What is a database?

Watch the tutorial for database (17 minutes)

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??
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???

We went to the spreadsheet that is shared an editable and entered in the following data after one of the students puts in the Record type.

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.

Open WORD document and create a “Database Notes” file
Vocabulary: database, field, record, data types

Sites that can help: Access 2003 tutorial

Access 2003

Sincerely,
Mr. Green-Hite

Thursday, September 6, 2012

Tuesday, January 31, 2012
Dear Class:

Rules
Class itself
Database
Bloodshed C++

Day One:

What is a database?

Watch the tutorial for database (17 minutes)

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??
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???

Go to the spreadsheet that is shared an editable and enter in the following data after one of the students puts in the Record type

Icebreaker—creating a database about our class
What do we want to find out about each other:

First Name
Last Name
Age
Smart? (yes/no)
How much do you have?
Favorite Food
Favorite Color
Gender
Eye Color
Birth Month
Job
Database Exp
Programming Exp
Grade
Hobbies
Siblings
Middle School
Sports


Enter the information onto the spreadsheet that has been shared.

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.


Open WORD document and create a “Database Notes” file
Vocabulary: database, field, record, data types

Sites that can help: Access 2003 tutorial

Access 2003

Tuesday, June 12th, 2012

Dear Class: This is the third, and last, part of the final. This will encompass using GameMaker to create a game with the following parameters: Use ducks and beavers (see evil OSU and the great and fantastic UofO) in which the two sides do battle within a room. Please make obstacles such as high school, diploma, and etc.. Good Luck! Sincerely, Mr. Green-Hite

Dear Class: Today is the second part of the final: Please "recreate" the following: Open up Microsoft Visual Studio 2010 Express to create this. Look at your old programs you did to help. Good Luck! Sincerely, Mr. Green-Hite

Wednesday, June 6, 2012

Dear Class: Part one of final: Write a program that takes in the name, opening value, closing value, and number of shares owned of a publicly-traded stock. Have the program "print" the stock name, opening value, closing value, and the amount of value gained or lost that day in one formatted line. Save the source code as "Final part 1". Sincerely, Mr. Green-Hite

Monday, Wednesday & Friday, June 4, 6, & 8

Dear Class: Unfortunately, the loading of Android Apps was a complete failure and we are into dead week. Because of that I am going to look at JAVA but from the basic perspective of computer language and, more specifically, Language programming in general. We glossed over this in both C++ and Visual Studio, but we are going to look at it as a whole. This will be the major basis for the Final. Lesson 1 Introduction Lesson 2 Fundamental Programming Concept Lesson 3 Decisions Lesson 4 Applets and Graphics Lesson 5 Introduction to Classes Lesson 6 Methods Lesson 7 Arrays and Vectors Lesson 8 Inheritance and Interfaces Lesson 9 Streams and Exceptions Lesson 10 Event Handling These were all a part of every program we have looked at. Because of that, we will only revisit what we knew previously. I will be having you go over the JAVA tutorial that contains the above Learning Java Language We have today, Wednesday, Friday, and then Tuesday of the week following and then the final is on Thursday. Because SkillsUSA will be a consideration for next year, and since I expect to see most of you next year in advanced programming, we will be making sure we have the basics down. Sincerely, Mr. Green-Hite

Thursday, May 31, 2012

Dear Class: I want to wrap up the GameMaker. I still several students who have not presented: Aaron Ackhavong, Andrew Ahnert, Donovan Burgess, Sam Chow, Cale E., Daniel Fouquette, Colin Gum, Aaron Johnson, William Lansing, Andy Li, Riley Martin, Kebrom Mulugeta, Andy Oliva-Lopez, Marcos Pinda, Naz Senchuk, Sutter S., Andrei Simon, and Sarge Smith. Today is the drop dead day to present! I need you all to help me by logging out of the "Student" account and then go to the "Teacher" account. I will have to sign in but then we will load JDK, SDK Starter Android, Eclipse, and ADT plugin for Eclipse. We should do the tutorial for "Hello World". This will be a tall order. Actually, half of your education will come in trying to install and run a program that has multiple layers as Android Apps does. Anyway, enjoy! Sincerely, Mr. Green-Hite

Tuesday, May 29th, 2012

Dear Class: I want to wrap up the GameMaker. I need you all to help me by logging out of the "Student" account and then go to the "Teacher" account. I will have to sign in but then we will load JDK, SDK Starter Android, Eclipse, and ADT plugin for Eclipse. We should do the tutorial for "Hello World". This will be a tall order. Actually, half of your education will come in trying to install and run a program that has multiple layers as Android Apps does. Anyway, enjoy! Sincerely, Mr. Green-Hite

Thursday, May 24, 2012

Dear Class: We will finish the presentation of your game projects. You will be doing peer grading like you did the last time. Sincerely, Mr. Green-Hite

Monday, May 14, 2012

Dear Class: Work on a tutorial you find for GameMaker or create a game all your own. If you are playing games and are not working on your work, I will assume that you are done and will grade what you have. I expect you to work on the tutorial you find today and on Wednesday. I will give you a "O" for the work and move you where you are not around a computer. Unfortunately, we do not have enough computers to accommodate everyone so I need you to work on your own! Sincerely, Mr. Green-Hite

Thursday, May 10, 2012

Dear Class: Finish the shooter. Create a game on your own today. Use your own creativity! Sincerely, Mr. Green-Hite

Friday, April 4, 2012

Dear Class: Finish the shooter tutorial. The tutorial that was the shooter tutorial was the wrong one. I want to do the shooter that I had done previously. The files should still be on your computers but I do have the files on my memory stick so let me know if there are problems. Thanks. Sincerely, Mr. Green-Hite

Wednesday, May 2, 2012

Dear Class: The first tutorial we did together...It consisted of the cherries, apples, etc that were worth points. I want to check them at the beginning of the class. The tutorial that was the shooter tutorial was the wrong one. I want to do the shooter that I had done previously. The files should still be on your computers but I do have the files on my memory stick so let me know if there are problems. Thanks. Sincerely, Mr. Green-Hite

Monday, April 30th, 2012

Dear Class: The first tutorial we did together...It consisted of the cherries, apples, etc that were worth points. The tutorial that was the shooter tutorial was the wrong one. I want to do the shooter that I had done previously. The files should still be on your computers but I do have the files on my memory stick so let me know if there are problems. Thanks. Sincerely, Mr. Green-Hite

Added to Tuesday, March 24th, 2012

Dear Class:

This is an add on to the previous part we were doing.

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

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

Friday and Tuesday, April 20 and April 24, 2012

Dear Class:

There is a good source of tutorials at http://www.vbtutor.net/ that I want to look at.

How to create an executable file. Go to this link.

We already worked on the first 5 lessons of the tutorial at the website

Lesson 5 speaks of writing the code. I want you to do the "form" code that is self explanatory on the tutorial. That includes the "myfirstVB2010 program" and the "Display hidden names"

All of the bold sections pay particular attention to!!!

We will look at the following lessons today:

Lesson 6 refreshes our minds about managing data (integers, etc. that we have seen before) and then Lesson 7 is about Mathematical Operations in which you will all do the "BMI" calculator. Follow the instructions for the "BMI" calculator on your own.

Lesson 8 is String Manipulation. We have talked about strings before. Although I will not have you do anything in this section today, read it! The interactions of strings and variables, etc are crucial to understand.

Lesson 9- Using If....Then....Else. This brings me back to my days of "Basic" programming. Things do not change. Please note the mathematical operations and signs associated with this lesson. Do example 9.2 "Lucky Prize" and then save. Please look at the others to follow the train of If, then, else.

Lesson 10- Using Select Case. Please read and then do Example 10.4. This is a grade calculator and the example is at the bottom of the Lesson.

I want you to start thinking about a project that you will write and run on visual basic that combines pics, buttons, text, etc for an exit project in Visual Studio.

At this point, you can explore, as you did before, on the internet any free programs that have to do with programming. I want you to go to alice.org and look at that program. It might be something you might want to download at home.

Keep off Youtube and any thing else that is not allowed.

Sincerely,
Mr. Green-Hite

Wednesday, April 18th, 2012

Dear Class:

We started to look at Lesson 4 last time that talks about object oriented program "OOP". Look at this lesson. I want you to understand what they are talking about.

Lesson 5 speaks of writing the code. I want you to do the "form" code that is self explanatory on the tutorial. That includes the "myfirstVB2010 program" and the "Display hidden names"

At this point, you can explore on the internet any free programs that have to do with programming. I want you to go to alice.org and look at that program. It might be something you might want to download at home.

We will look at the following lessons on Thursday:

Lesson 6 refreshes our minds about managing data (integers, etc. that we have seen before) and then Lesson 7 is about Mathematical Operations in which you will all do the "BMI" calculator.

Sincerely,
Mr. Green-Hite

Monday, April 16, 2012

Dear Class:

There is a good source of tutorials at http://www.vbtutor.net/ that I want to look at.

We will work on the first lesson of the tutorial at the website

Lesson 1 had us just do a simple button. In lesson 2, we did a simple calculator. I checked off most of yours. The next lessons are old friends. 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) and then Lesson 7 is about Mathematical Operations in which you will all do the "BMI" calculator (your fat). I hope to get this far today...

Sincerely,
Mr. Green-Hite

Thursday, April 12, 2012

Dear Class:

There is a good source of tutorials at http://www.vbtutor.net/ that I want to look at.

We will work on the first lesson of the tutorial at the website

Lesson 1 had us just do a simple button. In lesson 2, we will do a simple calculator. The next lessons are old friends. 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) and then Lesson 7 is about Mathematical Operations in which you will all do the "BMI" calculator. I hope to get this far today...

Sincerely,
Mr. Green-Hite

Tuesday, March 10, 2012

Dear Class:

We will finish with the Airplane.

Look at p. 84 to end.

I want to watch the below tutorials together to reinforce what we went over. Last class we watched the first four tutorials that were review. The site can be reached here. The following last four we did not get to and are also review:

Using Getline Function and the strcpy Function
Writing Equations and Type Casting
Demo of the Complete Program
Debugging Demo

We will continue with the final part of Unit 4.

There are couple of short projects I will have you do. Then, we will do the "Airplane" that is written for you. 1 2 3 https://docs.google.com/leaf?id=0B52XXyfOPY81ZWRhOGNiODYtZmMzMi00NWUwLWI5NmEtMmUzMGE1NTM4NjYw&hl=en&authkey=CLWhnKUC 5

Sorry, page 4

Sincerely,



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

Lesson 1 had us just do a simple button. In lesson 2, we will do a simple calculator. The next lessons are old friends. 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) and then Lesson 7 is about Mathematical Operations in which you will all do the "BMI" calculator. I hope to get this far today...

Friday, April 6, 2012

Dear Class:

I want to watch the below tutorials together. Last class I tried explain the below to you and made a hash of it. The site can be reached here. The following I would like to go over:

The String Data Type; Equations
Character vs. String data
Using Getline Function and the strcpy Function
Writing Equations and Type Casting
Demo of the Complete Program
Debugging Demo

We will continue with the final part of Unit 4.

There are couple of short projects I will have you do. Then, we will do the "Airplane" that is written for you. 1 2 3 https://docs.google.com/leaf?id=0B52XXyfOPY81ZWRhOGNiODYtZmMzMi00NWUwLWI5NmEtMmUzMGE1NTM4NjYw&hl=en&authkey=CLWhnKUC 5

We will finish with the Airplane (We may not get to this, I do not know)


Sincerely,
Mr. Green-Hite

Wednesday, April 4, 2012

Dear Class:

We are into chapter 4. I want to look at it together.

Chapter 4 (b).

Today I want to see if we can get the chapter done but maybe not.

I want to watch a couple of tutorials on this site:
http://www.softwaretrainingtutorials.com/c-plus-plus.php

http://www.fafiles.com/index.php?course=cppPage

This site is a tutorial on 3d programming using C++ and OpenGL.
http://www.videotutorialsrock.com/index.php



Hope this helps.

Sincerely,
Mr. Green-Hite

Monday, April 2, 2012

Dear Class:

Continuing with Chapter 3, I want to talk about Overflow and Underflow.

Run it but do not print out the menu. We will look at it next time to run and print it together.

I would like you, on your own, to do the project 3-4 on page 64. We already did the Activity 3-1 on page 66. Don't forget about the menu I need to check off!

I want to get into chapter 4. I want to look at it together. Sorry for the delay.

Chapter 4
Chapter 4 (b)

Hope this helps.

Sincerely,
Mr. Green-Hite

Thursday, March 22, 2012

Dear Class:

We will finish Chapter 3. We will look closely, however, at page 45, because of the "statements" and "results". I talked about pages 54 and 55 regarding mixed data types and how it affects calculations. There is a reference to "promotion" and "typecasting". Read these two pages on your own. Please run and print and hand in. At times there will be a "truncated" issue with floating-point number. Read on your own page 56 and 57. Page 57 has the same code list, more or less, as page 55. Just look at that code and see what was changed and what it would do. Together, do code list 3-3 on page 46. We will continue from there. I want you to "copy" the review questions on page 62-63, 1-10 and 1-10, answer them, save on google docs, and put in your shared folder. Do project 3-1 and Project 3-4 and run them. I will check them on screen and then grade them.

Chapter 3

I want you to do the Menu that is linked. The links are Page 1 and Page 2

I want to talk about Overflow and Underflow.


Sincerely,
Mr. Green-Hite

Tuesday, March 20th, 2012

Dear Class:

We will finish Chapter 3. We will look closely, however, at page 45, because of the "statements" and "results". Together, do code list 3-3 on page 46. We will continue from there. I want you to "copy" the review questions on page 62-63, 1-10 and 1-10, answer them, print and hand in. Do project 3-1 and Project 3-4 and run them. I will check them on screen and then grade them.

Chapter 3

Sincerely,
Mr. Green-Hite

Friday, March 16, 2012

Dear Class:

We will start and continue with Chapter 3. These are more of a review of math with a few new twists to the standard operations of addition, subtraction, multiplication, and division. There will be the modulus which will include the leftover. We will just continue in Chapter 3 from there. Page 44 we will look at the code list 3-2 but we will not do it. We will look closely, however, at page 45, because of the "statements" and "results". Together, do code list 3-4 on page 47. We will continue from there.

Chapter 3

Sincerely,
Mr. Green-Hite

Wednesday, March 14, 2012

Dear Class:

As a quiz, I want you to do Activity 2-1 on your own. This will count as the exit quiz for Chapter 2. This is simply taking the English language equivalent and writing it in program language!

We move into Math Operations for Chapter 3. These are more of a review of math with a few new twists to the standard operations of addition, subtraction, multiplication, and division. There will be the modulus which will include the leftover. I want to look particularly a page 45 and the using of arithmetic operators. I want to do the "Bus Trip" Page 1 and page 2 program. It is more advanced but I think it important that you see what a simple operator can do. We will just continue in Chapter 3 from there.

Sincerely,
Mr. Green-Hite

Monday, March 12, 2012

Dear Class:

Do step 2-3 on page 29 and check if there is a difference? We need to look at Floating Point Variables, Boolean Variables (I talked of last time), and Constants. Do code list 2-3 on Page 34. Do code list 2-4 on page 36.

Finally, please enter, compile, and run Project 2-2 on page 40. We will do this one together. This Project combines the constant and variable declarations and initialization.

As a quiz, I want you to do Activity 2-1 on your own. This will count as the exit quiz for Chapter 2.

We move into Math Operations for Chapter 3. These are more of a review of math with a few new twists to the standard operations of addition, subtraction, multiplication, and division. There will be the modulus which will include the leftover. I want to look particularly a page 45 and the using of arithmetic operators. I want to do the "Bus Trip" Page 1 and page 2 program. It is more advanced but I think it important that you see what a simple operator can do. We will just continue in Chapter 3 from there.

Sincerely,
Mr. Green-Hite

Wednesday, March 7, 2012

Dear Class:

Grades are done... hallelujah! Please check. I need some work from some of you from the database.

The first programs are simple but you need to practice these programs to get them to work properly. Make sure you understand the five parts of the basic structure of a C++ program: 1) Compiler directive #include, 2) Main Function, 3) Braces to mark the beginning and end 4) Statement followed by a ; last statement is return 0; and 5) can also have comments which are ignored by the compiler but necessary to the programmer.

We need to break down your programs.

We will be talking about the five basic data types: int, Float, Double, char, and void. Assignment statements. These will be important in the developing an algorithm and coding the problem. This will take us into the first half of Chapter 2. We will look at this together!

Chapter 2
Binary Code

Good day to you! We will begin with looking and naming variables. To initialize a variable you simply assign it a value. You must declare a variable before you can use it. On page 29-30, there are examples of keywords and improper C++ variable identifiers. Check out the character and equivalent decimal value located on page 30.

You are done with 2-1 in the book on page 27 and then do the step by step 2-2. Do step 2-3 on page 29 and check if there is a difference?

Today, e need to look at Floating Point Variables, Boolean Variables, and Constants. Do code list 2-3 on Page 34. Do code list 2-4 on page 36.

Finally, please enter, compile, and run Project 2-2 on page 40. This will probably bring us to the end of the class.

Sincerely,
Mr. Green-Hite

Monday, March 5, 2012

Dear Class:

Grades are done... hallelujah! Please check. I need some work from some of you from the database.

The first programs are simple but you need to practice these programs to get them to work properly. Make sure you understand the five parts of the basic structure of a C++ program: 1) Compiler directive #include, 2) Main Function, 3) Braces to mark the beginning and end 4) Statement followed by a ; last statement is return 0; and 5) can also have comments which are ignored by the compiler but necessary to the programmer.

We need to break down your programs.

We will be talking about the five basic data types: int, Float, Double, char, and void. Assignment statements. These will be important in the developing an algorithm and coding the problem. This will take us into the first half of Chapter 2. We will look at this together!

Chapter 2
Binary Code

Good day to you! We will begin with looking and naming variables. To initialize a variable you simply assign it a value. You must declare a variable before you can use it. On page 29-30, there are examples of keywords and improper C++ variable identifiers. Check out the character and equivalent decimal value located on page 30.

Do 2-1 in book on page 27 and then do the step by step 2-2. Do step 2-3 on page 29 and check if there is a difference? We need to look at Floating Point Variables, Boolean Variables, and Constants. Do code list 2-3 on Page 34. Do code list 2-4 on page 36.

Finally, please enter, compile, and run Project 2-2 on page 40. This will probably bring us to the end of the class.

Sincerely,
Mr. Green-Hite

Thursday, March 1, 2012

Dear Class:

The first programs are simple but you need to practice these programs to get them to work properly. Make sure you understand the five parts of the basic structure of a C++ program: 1) Compiler directive #include, 2) Main Function, 3) Braces to mark the beginning and end 4) Statement followed by a ; last statement is return 0; and 5) can also have comments which are ignored by the compiler but necessary to the programmer.

We will be talking about the five basic data types: int, Float, Double, char, and void. Assignment statements. These will be important in the developing an algorithm and coding the problem. This will take us into the first half of Chapter 2. We will look at this together!

Chapter 2
Binary Code

Good day to you! We will begin with looking and naming variables. To initialize a variable you simply assign it a value. You must declare a variable before you can use it. On page 29-30, there are examples of keywords and improper C++ variable identifiers. Check out the character and equivalent decimal value located on page 30.

Do 2-1 in book on page 27 and then do the step by step 2-2. Do step 2-3 on page 29 and check if there is a difference? We need to look at Floating Point Variables, Boolean Variables, and Constants. Do code list 2-3 on Page 34. Do code list 2-4 on page 36.

Finally, please enter, compile, and run Project 2-2 on page 40. This will probably bring us to the end of the class.

Sincerely,
Mr. Green-Hite

Tuesday, February 28, 2012

Dear Class:

I did find out the problem we were having

I want to do a more complex C++ program. Travel program we started.

I went over the following attachment last class Continuing with binary numbers. We finished the table with the powers of 2 from 0 to 7. With that, we will determine a series of numbers and their equivalent values are according to binary.

I will then give you a a list of binary codes that you will be translating the following "My name is ....". When you finish this, please put it below the above table, put your name on the top, print it out, and then hand it in.

Finally, we will look at Chapter 2 in the book.

Sincerely,
Mr. Green-Hite

Wednesday, February 22, 2012

Dear Class:

Today we have that quiz on the vocabulary words today!

Finish the Reports and Queries that were assigned during the last couple of classes. I can give you the first 14-20 minutes to finish.

Otherwise, after the last part of the class, we will be opening up C++ and working on that. There will be a little bit of vocabulary involved but not too much. If you work on it at home, you can download at bloodshed.net. H

Today, we will take notes on programming in general and C++ notes in particular in a google document. We will get to "Hello World!" and make sure that we figure out any "bugs" it has.

You need to go to the book room on your own and get the text entitled Introduction to Computer Science Using C++ 3rd edition.

We will look at binary numbers (machine language) as well but toward the last part of class.

Sincerely,
Mr. Green-Hite

Wednesday, February 20, 2012

Dear Class:

Today we will finish up the DataBase handout we almost finished last class. It is due today after the first 20 minutes of class. Please print out the final sheet as pdf files, upload them to your google account, and then move them to your shared collection or "folder". Remember, recheck your data to make sure you are accurate in what you entered.

Otherwise, after the first half of the class, we will be opening up C++ and working on that. There will be a little bit of vocabulary involved but not too much. If you work on it at home, you can download at bloodshed.net. Hopefully, we will do the first bit of a program called "Hello World".

Sincerely,
Mr. Green-Hite

Thursday, February 16, 2012

Dear Class:

This is to be a finalization of what we have been doing. I want this as a drop dead for this project.

I want the final seven reports/queries to be saved as pdf's. Also, I want you to change the footer to "your name, Period 7" at the bottom. To do this, erase the para thesis on the =() and then put ="your name, Period 7" and then get rid of the rest of the junk at the end of the footer on the right hand side.

Last project for this part of the class or...Database. The following document will be easier just because it won't be "linked". I will also want to see a footer on this document and will talk about that.

Final Project

Sincerely,
Mr. Green-Hite

Tuesday, February 14th, 2012

Dear Class:

Last project for this part of the class or...Database. The following document will be easier just because it won't be "linked". I will also want to see a footer on this document and will talk about that.

Final Project

Sincerely,
Mr. Green-Hite

Wednesday, February 8, 2012

Dear Class:

Due to the "tainted" nature of the data we used before, we are going to create a new one using other preexisting data on real estate.

You will open the directions: Directions

The first Table information you will need will be created in Table 1: Homes for Sale

The second Table you will put together will be the Listing Criteria.

Use the date provided to create the two new tables.

You can go ahead and look at the queries that is the second part of the instructions but given it is a Wednesday, you will probably not get to that point.

Sincerely,
Mr. Green-Hite

Monday, February 6, 2012

Dear Class:

Open WORD document and create a “Database Notes” file
Vocabulary: database, field, record, data types, objects, table, form, report, querie.

Sites that can help: Access 2003 tutorial

Access 2003

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?

Thursday, February 2, 2012

Dear Class:

Please open up your "database" we worked on last time 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 type them in a shared google doc and then plug your information on the database itself.

You will be "Correcting" that raw data into the "Class Database" that we will be using. In programming, you cannot have data that is "off" or "inconsistent" or a program will not work (although there are certain internal checks).

What is a database?

Watch the tutorial for database (17 minutes)

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??
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???

We went to the spreadsheet that is shared an editable and entered in the following data after one of the students puts in the Record type.

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.

Open WORD document and create a “Database Notes” file
Vocabulary: database, field, record, data types

Sites that can help: Access 2003 tutorial

Access 2003

Sincerely,
Mr. Green-Hite

Tuesday, January 31, 2012

Tuesday, January 31, 2012
Dear Class:

Rules
Class itself
Database
Bloodshed C++

Day One:

What is a database?

Watch the tutorial for database (17 minutes)

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??
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???

Go to the spreadsheet that is shared an editable and enter in the following data after one of the students puts in the Record type

Icebreaker—creating a database about our class
What do we want to find out about each other:

First Name
Last Name
Age
Smart? (yes/no)
How much do you have?
Favorite Food
Favorite Color
Gender
Eye Color
Birth Month
Job
Database Exp
Programming Exp
Grade
Hobbies
Siblings
Middle School
Sports


Enter the information onto the spreadsheet that has been shared.

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.


Open WORD document and create a “Database Notes” file
Vocabulary: database, field, record, data types

Sites that can help: Access 2003 tutorial

Access 2003