Dear Class:
I will give you the first half of the class to complete the "Automobiles" database today. This is the first part of the Database/Programming 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 exported data from Excel to work on. The second section was information from MyTunes that had been exported in and we created a report and a query, going over what each entailed. The last section is the "Access" final project. This is information that is provided by me. The final reports and queries will all look the same after you run them...The grading will be very precise on this one! This means that if you were not precise in entering data, the queries and reports you run will not be the same as your neighbors.
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. We may have a pop quiz on Database today! You can do this until the majority of the class is complete in the two reports and 5 queries that are required.
Finally, we will start programming...beginning with machine language. We will talk about the progression of programming language. Hopefully, at the end of the period, we will create 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 and naming it "Programming--C++ Notes".
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.
The following attachment contains information on binary numbers and precursor computer language 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
Monday, March 3, 2014
Thursday, February 27, 2014
Friday, February 28, 2014
Dear Class:
As you work on the "Final Project", I want to work with the students that need my individual help.
While you are working on the below "Final Project", I will be calling you up one at a time and going over grades/folder information.
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Please use the following four pages as the exit project and then we are done with Database (I can provide a hard copy but I don't have enough for everyone). Page 1
Page 2 Page 3 Page 4 last page
Sincerely, Mr. Green-Hite
As you work on the "Final Project", I want to work with the students that need my individual help.
While you are working on the below "Final Project", I will be calling you up one at a time and going over grades/folder information.
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Please use the following four pages as the exit project and then we are done with Database (I can provide a hard copy but I don't have enough for everyone). Page 1
Page 2 Page 3 Page 4 last page
Sincerely, Mr. Green-Hite
Monday, February 24, 2014
Monday, February 24, 2014
Dear Class:
We finished up cleaning up the query/report that we did. This will include "centering" data and putting in a footer with your name on it. Then it will be "Exported" and "Published" as a pdf file. We will also add just a little bit to our notes, especially about wild cards. We will be doing queries which sometimes has "wildcards". I want to look at examples for query criteria at this link.
You should be done with exporting MyTunes Excel Spreadsheet into Access. MyTunes spreadsheet.
You will have to open it up and export it into Access. We did this before with the class excel spreadsheet so this should be no problem. Download the below worksheet that asks questions regarding the MyTunes Access file
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
I have a handout for you as the exit project and then we are done with Database. Page 1
Page 2 Page 3 Page 4 last page
Sincerely, Mr. Green-Hite
We finished up cleaning up the query/report that we did. This will include "centering" data and putting in a footer with your name on it. Then it will be "Exported" and "Published" as a pdf file. We will also add just a little bit to our notes, especially about wild cards. We will be doing queries which sometimes has "wildcards". I want to look at examples for query criteria at this link.
You should be done with exporting MyTunes Excel Spreadsheet into Access. MyTunes spreadsheet.
You will have to open it up and export it into Access. We did this before with the class excel spreadsheet so this should be no problem. Download the below worksheet that asks questions regarding the MyTunes Access file
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
I have a handout for you as the exit project and then we are done with Database. Page 1
Page 2 Page 3 Page 4 last page
Sincerely, Mr. Green-Hite
Thursday, February 20, 2014
Thursday, February 20, 2014
Dear Class:
We will start by finishing up cleaning up the query/report that we did. This will include "centering" data and putting in a footer with your name on it. Then it will be "Exported" and "Published" as a pdf file. We will also add just a little bit to our notes, especially about wild cards. We will be importing the MyTunes Excel Spreadsheet into Access. MyTunes spreadsheet.
You will have to open it up and export it into Access. We did this before with the class excel spreadsheet so this should be no problem.
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Sincerely, Mr. Green-Hite
We will start by finishing up cleaning up the query/report that we did. This will include "centering" data and putting in a footer with your name on it. Then it will be "Exported" and "Published" as a pdf file. We will also add just a little bit to our notes, especially about wild cards. We will be importing the MyTunes Excel Spreadsheet into Access. MyTunes spreadsheet.
You will have to open it up and export it into Access. We did this before with the class excel spreadsheet so this should be no problem.
You will all import the data and I will go over what queries and reports are and the differences. You will then run a few reports and then save them to the desktop. In the end, you will upload these reports into your google docs in your shared folder. Create a folder entitled "Reports and Queries" if you would.
MyTunes Worksheet MyTunes Excel Spreadsheet href="http://www.gcflearnfree.org/access2003">Access 2003
Sincerely, Mr. Green-Hite
Tuesday, February 18, 2014
Tuesday, February 18, 2014
Tuesday, February 18, 2014
Dear Class:
Terminology: We will add "Object", "Tables", "Forms", and "Reports"
Watch the Tutorial on Access 2013 to get a better idea. We will start with lesson 1. I do want you to open up your Database notes because some of the terminology will need to be put in.
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
Field?
Requirements: contain a unique name, describe the field, <= 64 characters, cannot begin with a space, can’t use . , ! [ ]
Spreadsheet containing the information from your filling out the form. "Shared Spreadsheet"
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
Sincerely,
Mr. Green-Hite
Dear Class:
Terminology: We will add "Object", "Tables", "Forms", and "Reports"
Watch the Tutorial on Access 2013 to get a better idea. We will start with lesson 1. I do want you to open up your Database notes because some of the terminology will need to be put in.
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
Field?
Requirements: contain a unique name, describe the field, <= 64 characters, cannot begin with a space, can’t use . , ! [ ]
Spreadsheet containing the information from your filling out the form. "Shared Spreadsheet"
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
Sincerely,
Mr. Green-Hite
Wednesday, February 5, 2014
Thursday, February 7, 2014
Tuesday, February 4, 2014
Dear Class:
Rules
Class itself
Database
Bloodshed C++
Day One:
What is a database?
Watch the Tutorial on Access. (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???
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
Spreadsheet containing the information from your filling out the form. "Shared Spreadsheet"
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
Sincerely,
Mr. Green-Hite
Dear Class:
Rules
Class itself
Database
Bloodshed C++
Day One:
What is a database?
Watch the Tutorial on Access. (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???
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
Spreadsheet containing the information from your filling out the form. "Shared Spreadsheet"
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
Sincerely,
Mr. Green-Hite
Monday, February 3, 2014
Tuesday, February 4, 2013
Tuesday, February 4, 2014
Dear Class:
Rules
Class itself
Database
Bloodshed C++
Day One:
What is a database?
Watch the Tutorial on Access. (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???
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
New Database using a form for this class!
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
New Database using a form for this class!
Sincerely,
Mr. Green-Hite
Dear Class:
Rules
Class itself
Database
Bloodshed C++
Day One:
What is a database?
Watch the Tutorial on Access. (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???
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
New Database using a form for this class!
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
New Database using a form for this class!
Sincerely,
Mr. Green-Hite
Subscribe to:
Posts (Atom)