There are apparently two individuals named Marc Rauer in the United States and this website is associated with the Marc Rauer who is an adjunct instructor at the Community College Of Philadelphia. This web site has been created for the students of this instructor. Two classes at this school are involved: CIS103-010 meeting from 1 to 3 PM T-TH. The other class is CIS103-004 meeting from 4:20 to 6:20 T-TH. The Earlier class meets in the Bonnell Building at B2-23. The later class meets at the CBI building in C3-14. You can contact this adjunct instructor by clicking here. You can access the syllabus for this course by clicking here.


Tomorrow, Wednesday, June 29th, is the final between 1-3PM. Here are the files to be used. usinfo.txt, a text file. and uspop.accdb, an access database. As to usinfo.text, use your popup menu to save the file to your hard drive and then proceed to bring this into your database using import data as a table. If it's easier, here's a link to the excel version of usinfo.text which you can then import as a table to your access database, usinfo.xlsx. Your instructor will be handing out individual tests for all students.


Today, we revisit Oct 5, 1962. An important date as you will find. This is our last powerpoint assignment and we will attempt to do the following slides.





below are the files we can use (although we could use screen shot if we wanted)

video: Dr No beginning.mp4

Audio: 007 theme.mp3

Below are the pictures used in this:


















Your Access test is the last test for the Spring'16 session. Consult your syllabus to determine how it affects you as to your grade. The final schedule - set by the school administration - is as follow:

Thursday May 5th: 1-3 PM taking place in B2-23

Thursday May 5th: 3:30 - 5:30PM taking place in C3-14


For our last two classes, we are going to answer the questions indicated below. We will be using the census database which we started to discuss on Tuesday. You can access this database by clicking here.

We are going to deal with indexing at the start and then look at the different tables one at a time. Then there's the question about joining the tables. Finally we will answer the questions below.

Answering some questions pertaining to the states, capitals, and Bases tables in the census.accdb database.
A.	While we can’t see this usage directly, in the capitals table set up a primary index using state name concatenated with state abbreviation
B.	Establish the relationships between the various tables. At first, set up an inner join which is the default.
C.	Write an aggregate query to determine the population of the entire 50 states in 2010. In addition, determine the population in 2010. Add a calculated field to determine the difference. This must be done on the group (query) level.
D.	Write a query to list all the states alphabetically with their unique abbreviation, 2010 population and square mileage.
E.	Write a query indicating the above only for those states with population above 6 million.
F.	Write a query indicating the above but for those states with population below 600000
G.	Write one query that shows the results of the last two queries.
H.	For all the states, let’s work out density of population per square mile. After doing this, determine the density per thousand residents.
I.	Write a query for all the states indicating the number of bases within each state. (And how would the different joins alter our results)
J.	Write a query determining the section of the country a state picked at random is in. In class, we will pick a state based on the class’s choice.
K.	List the states in that region indicating the bases and number of civilian workers for each of these states, and the population in 2010 and the abbreviation.
L.	Write a crosstab query with all the states indicating the number of types of base within them
M.	Extend the above query to show only those states within the specified region.
N.	For all the states, determine the number of civilian workers in the military bases per million of the population. Sort by density descending. We are about to study Excel. So, for our last adventure here, let’s export to excel and create a bar chart showing our results.

We begin our study of relational databases today. 1968-1971 marks the start of relational databases with the last proof being proved in 1980. Access is a relational database and must adhere to one of the sql standards. Even today, most database personnel deal with SQL 89 or SQL 92 theories which were the second and third revisions from the 1972 standard (I think). You can see the various versions of Access over the years by clicking here. If you are interested in determining other relational database, you can clicking here. While Access may have a popularity for small size database users, MySQL is generally used for small database housed on the internet, MS SQL Server is used by many PC based larger companies and Oracle, a unix based relational database, is the favorite of larger companies running Unix or Linux.


Below are the questions we answered in class pertaining to the Hurricane database. Try this again as you prepare for the Final on May 5.:

Display those hurricanes that have no wind speed indicated and using the category table indicate what possible wind speeds this hurricane might have. 

How many storms have been recorded from 1950 through 2010?

How many storms occurred from 1889 through 1949?

What is the average SSI for storms hitting the US

How many of each category has struck the US mainland

Determine the minimum Min Pressure for each category. Extend this by determining the Min Pressure in each category for Fl and Tx.

Indicate those storms throughout the years where the maximum sustained wind was 130 mph or higher. Of these, modify your query to show those hurricanes that additional have a minimum pressure below 900

Since 1950 each Hurricane has had a name. Even before, a Hurricane could be given a name – generally the location it landed – if it was a significant event. Provide a list of Hurricane names and the year they occurred.

Extending the last question, provide a list where a Hurricane of the same name occurred in two different years.

Note: Set these as specific queries in your database which you can access below. This will be a test of how you will answer questions during your test on Thursday, May 5th at either 1-3 or 3:30 to 5:30.

Access the Hurricane database by clicking here.


At the end of the test of May 5th you are required to send me your database. We can try to do this now and you will follow the same procedures (with a different database) at that time. Today we will use this Hurricne database. Open your most preferred Email account and create an Email to be sent to 777rauer@777rauer.com with this database as an attachment. Your instructor will show this using his Hurricane database and after class you can verify whether the Email was received. Remember: this is of great importance. Your instructor cannot mark what he did not receive.

Above, we moved data from a txt file to an Access table. It is easier to do this using an excel spreadsheet and you can access the excel spreadsheet by clicking here.. We may start looking at this in excel. But to access the Uboat access databbase, click here. If we access the excel spreadsheet on German Uboat losses during WWII it will be because we have the time to convert this to an access database.


What looks like our final problem for Access will be the census database which you can access below at the "access" button"

We were in the midst of dealing with the aircraft of WWII. We can access this database by clicking here. Last Thursday the emphasis was on the study of joins. There were several important issues that the original SQL committee (1968-1971) was interested in and the idea of joins - probably called something else at the time - was studied algebraicly.


Today, we want to look at manipulating data. We would like to create a table looking at each entry type (bomber or fighter) and for each of these find its percentage of entire Bomber or fighter production of the war based on our table. We'll try to attack this several ways but we should run into a major constraint of relational databases: the inability of mixing detail and aggregate data without major limitations. Hopefully when we run into this, we should be able to find ways around the limitations.

After dealing with Aircraft, let's deal with Hurricanes which is our next database example. Below you see some data which is in text. We are going to create a database of this and this database will start with one table only. Below, we show screen shots of the creation of this database and table.

I have redone the old forge school for cats. You can access the final version of this by clicking here. The initial part of the problem as explained in Word can be accessed by clicking here.

The following are some screen shots to resolve this problem


We are into our fifth class of excel. I received the news from the department head that we will not be meeting on April 28th (that means both April 26 and April 28 are off). So, we're going to try to end our discussion of Excel this Thursday although there is a possibility that we will have a tag portion of excel on April 5. Anything on April 5 should be beyond the scope of the book so I think that the excel test will be set for next Monday, April 4 through Saturday April 9th. For today, we are going to finish the Fleming problem. We will need the excel file itself, which you can access by clicking here. We are going to try to intermix this with a word document that you can access by clicking here. After the Fleming finale, let's see if we can tackle the Continental Baseball League problem which you can read about by accessing a word document, cbl 2016.doc. We will use the access database, cbl16.accdb although we can always use the excel spreadsheet access by clicking here.


There is a book required by this course.
Discovering Computers and MIcrosoft Office 2013 by Misty Vermaat.
You should be able to buy the book at the bookstore or off the Cengage website at sam.cengage.com. If buying everything from the cengage web site, you have 4 options, 3 of which will be discussed in detail.
First: just a code for the sam site. Type in 9781285458366. Cost $110. Add to cart. At end you will be provided a key.
Sam code and Etext. Enter 9781285734248. Cost $126. Includes ability to access the Sam site.
Book delivered to you. Type in 9781305515116. Cost is 216.95. Included is the ability to access the SAM site.
A fourth possibility is to rent the book. A rental to the end of July will cost you $146.49. This will include the ability to access the Sam site

For today's class, we will be looking at the beginning aspects of powerpoint. Hopefully by the end of the session we are doing a project involving a James Bond, although this one was a professor of Ornithology.

Among the things we will be discussing is the initial layout. We're going to discuss these initials templates in detail but will also be interested in discussing smart boxes. A smart box allows for 7 different types of input many of which you can do through other selections in parts of the ribbon. One selection however is unique and involves text and bullets. We'll concentrate on this as we do this James Bond powerpoint presentation.

Also, to do this presentation we will need to engage several pictures that are on this web script. How do we do this?

The early part of the class will deal with image formats - jpg, gif, png, tiff. What are they? How do we access them. Interrestingly enough there are a few ways to do this both through the operating system and through powerpoint.












System Requirements
Your workstation must meet the following minimum system requirements to use SAM:

Requirements

Computer
*Processor: Intel Pentium 4 or higher processor required; Intel Centrino or an equivalent multi-core processor recommended
*Memory: 512 MB RAM required; 1 GB RAM recommended
*Operating Systems: Windows 7 32- or 64-bit or Windows 8/8.1 32- or 64-bit; Macintosh OS X 10.7 or higher
 
Audio and Video
*Graphics: SVGA
*Resolution: Minimum recommended 1024 x 768
*Color: 32-bit
*Video Memory: 64 MB minimum; 128 MB recommended
*Video Card: Modern DirectX compatible

Network
*Internet Connection: 56K modem minimum; broadband connection (cable, DSL, T1 or ISDN) recommended; persistent connection required

Software and Disk Storage
*Web Browsers: 4 MB 
*Adobe Flash Player 11 recommended; versions 10.2 or higher have been tested and are supported; versions prior to 10.1 are not supported: 2 MB
*Adobe Reader 8 minimum; 9 recommended: 22.4 MB
*SAM Projects:
*For SAM 2010 Projects: Microsoft Office 2010 Professional for Windows
*For SAM 2013 Projects: Microsoft Office 2013 Professional for Windows, Professional Plus, RT and Office 365 (Home Premium, University) 

NOTE: Refer to your Microsoft documentation for current disk storage requirements.

Supported Browsers

You can access SAM using the following browsers:

For Windows 7, 8 and 8.1
 
Internet Explorer 9 through 11 for 32-bit or 64-bit versions of Windows; Firefox (latest version and latest -1); Chrome (latest version and latest -1)

NOTES: SAM 2010 Assessment and Training content is not tested on Chrome. Compatibility Mode is not supported for Internet Explorer.
 

Macintosh OS X 10.7 or higher
 
Safari 7.0 and Firefox (latest version and latest -1)

Confirm these settings in your browser: JavaScript is enabled. Pop-up blocking is disabled, either entirely or for the SAM URL http://sam.cengage.com.  Ad-blocking software is disabled for the URL http://sam.cengage.com.

IMPORTANT: Do not have multiple tabs or browsers with SAM open at the same time. Having multiple instances of SAM open may result in a loss of data.
 

A syllabus has been handed out and assigned. If you need a syllabus at any time, click here and a Word document containing the syllabus will be downloaded

We did discusss fonts, resolution involving the ribbon and cut, copy and paste. Below are some copies of information from various sources on the internet pertaining to some of this:

As to resolutions, we give a list from wikipedia below

Here is the display section of my computer at home

We will be talking about the ribbon. The ribbon depends on screen resolution mentioned above. Below is some examples of the home tab using various screen resolution.

We are going to discuss fonts and font technology. Do you know what is considered the first font ever created. And why was it named? Now, besides looking at fonts per the question of the windows graphical user interface (GUI), we can look at one of Word's best features: preview. Below is an example.

Among the technologies of the operating system - inherited by Word and the other applications - the the clipboard. You have one on your system as it is system dependent. We will discuss cut, copy,pasrte and delete in detail but notice that we have 3 items in this clipboard as indicated below. Where can we paste this information?

By the way, the clipboard is programmable. I've thrown some code into a visual basic program. Look at the popup box giving the coding options below.

Finally, for some reason the lab in B2-23 did not work in terms of the actual image of the copy. Below, we try to show this. This worked in C3-12 (and on my machine from which this is taken) so I have no answer as to why it failed on Thursday afternoon.



You have been told that you should be doing the problems in the book. This course is designed to give you several views in tackling problems. We will do the first problem of the book in class after resolving catacombs. Below is a discussion of this.


We are going to do the first problem in the book in a slightly different manner. It's going to be all objects. Start with drawing a textbox as indicated below.

Now, let's add a picture. You can use the one in the book but here are several others:



The problem in the book uses a 75 point Adventure in a different color. We can do the same using textbox tools (as well as home tab font group tools). Notice that we can use additional tools to modify the text box if we like. Below tries to document some of this

You can access this document by clicking here.. Notice that the underline on the phone number is a hyperlink. Let's see if we can do this using the insert tab control for hyperlink. Once done with the hyperlink, see if you can modify this document to look as follows: