Class Schedule At-A-Glance
 Wednesday, October 2

Continue with Excel

To Participate Online

Inrteresting News Article

Assignment 13
- Using the Population Excel File calculate the percent each county (Counties worksheet) is of the state total for 2009.  Sort the new Percent of Total column from Largest to Smallest. Also format the new column as a Percent (%) with one decimal place. (Example)

Assignment is due on Friday, October 4

When complete, place the file in the Angel dropbox for Assignment 13

Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.

What we hope to do: Demonstrate the use of absolute cell references and use in formulas.  Also work with multiple worksheets and repeated use of sorting and formatting.

View Recorded Session
 Friday, October 4

Continue with Excel

To Participate Online

Sample File to Use during class - Murder Victims by Age, Sex and Race

Assignment 14 - Please prepare a short write-up on your experience with participating in class through Adobe Connect (online).

Would like to hear from you regarding:
1. What you like and don't like about participating through Adobe Connect.
2. Should this be continued as a regular means of participation?
3. Suggestions for improving the experience.
4. If you have not participated online - does the use of Adobe Connect distract those in the room from learning or participating as desired?

Assignment is due on Monday, October 7.
When complete, place your document in the Angel dropbox for Assignment 14. 

Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.

What we hope to do: Demonstrate the use of cell calculations using both relative and absolute cell references and creating charts and graphs. 

View Recorded Session

 Monday, October 7
Continue with Excel

To Participate Online

Assignment 15 - Human Trafficking (Working with calculations and graphics)
1. Using the human trafficking workbook provided calculate the following information in the worksheet.

Total number of confirmed human trafficking victims in 2007-08.

Percentage for male and female confirmed human trafficking victims in 2007-08.
Percentage for White, Black, Hispanic and Asian confirmed human trafficking victims in 2007-08.
Percentage that was 17 or younger, 18-24, 25-34 and 35 or older confirmed human trafficking victims in 2007-08.
Percentage that was a U.S. Citizen, U.S. National, Permanent resident, Undocumented alien and Qualified alien confirmed human trafficking victims in 2007-08.

2. Create 2 pie charts showing:

The gender of confirmed human trafficking victims in 2007-08
The race/ethnic origin of confirmed human trafficking victims in 2007-08
Place the charts in the worksheet in proximity to the data.

See Example.

Assignment 15 is due on Wednesday, October 9.
When complete place the workbook in the Angel drobbox for Assignment 15.


Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.


What we hope to do:
Demonstrate the use of creating a multiple worksheet Workbook and creating graphs and charts from both contiguous and non-contiguous cells.

View Recorded Session
 Wednesday, October 9

Introduction to Access

To Participate Online

Assignment 16 - Working with Multiple Worksheets
Using the 2009, 2010 and 2011 Online Annual Crime Reports from the PA State Police Uniform Crime Reporting System (http://ucr.psp.state.pa.us/UCR/ComMain.asp), Create an Excel Workbook that includes a worksheet for each year that contains Table 1 - Offenses Reported in Pennsylvania (Excel files found in Appendix A B C D in Excel 2000). 
Once a worksheet has been created for each year - create another worksheet to summarize the number of offenses from each year for Drug Possession - Opium – Cocaine, Drug Possession – Marijuana, Drug Possession – Synthetic, and Drug Possession – Other. Be sure to use cell references to represent the data on the new summary worksheet.
For these four offenses, create one graph showing the trend for each over the period 2009 – 2011.
Also for 2011 create a pie chart showing the distribution among the four offenses.

See Example

Assignment 16 is due on Friday, October 11
When complete, place the file in the Angel dropbox for Assignment 16

Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.

Access Concept and Terms - Introduction (PDF)

What we hope to do:  Discuss database concepts and terms.  Take a spin around the Access Ribbon and screen layout.  Create a database using Application parts and enter data into a table. Take a look at the design view and data view for each object.

View Recorded Session

 Friday, October 11

Continue with Access

To Participate Online

Assignment 17 - Creating an Access Database
Create an Access database from Application parts (or use database created in class) for Contacts (People that you may want to pursue a job with). The Contacts table should include first name, last name, company name, email address, street address, city, state, phone number and zip code.  Add information for 5 agencies to the Contacts table.  Be sure to save the table before exiting.
Place the Access database in the dropbox for Assignment 17.

See Example

Assignment 17 is due on Monday, October 14.

When complete place the database in the Angel dropbox for Assignment 17.
Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.


What we hope to do: Demonstrate how to create a table object from scratch. 

View Recorded Session

 Monday, October 14

Continue with Access

To Participate Online

Assignment 18 - Create a database that can be used to report crime incidents in each school in our school district. The database should have at least 3 tables. One of the tables should contain fields relating to each incident, another table should include fields that provide codes and descriptions of the offenses reported in each incident and the third table should include fields that provides codes and descriptions of school buildings.

Enter data for 10 records in the Incident table and include up to 5 offense codes and descriptions in the offense type table and up to 5 records in the building table.

Fields for the Incident table should include:
Incident number - type: AutoNumber
Incident date - type: Date/Time
Last name of offender - type: Text
First name of offender - type: Text
Witnessed by Teacher - type: Yes/No
School - type: Number (using Lookup Wizzard)
Offense - type: Number (using Lookup Wizzard)

Fields for the Offense table should include:
Offense Code - type: AutoNumber
Offense Description - type: Text

Fields for the School table should include:
ID - type: AutoNumber
Building - type: Text
Type of Building - type: Text

See Example

Assignment 18 is due on Wednesday, October 16.
When complete place the database in the Angel drobbox for Assignment 18.

Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.

What we hope to do: Demonstrate the use of Look-up Wizard in creating fields for tables.

View Recorded Session

 Wednesday, October 16

Continue with Access - Importing Excel files into table object

Housing Data (Excel file) For use in class

To Participate Online

Assignment 19 Importing Income_Poverty Data
Create an Access database named Census.  
Using the Income_Poverty Data (Excel file) import the Municipality-2000 worksheet into Access to create a municipal level Income_Poverty_mcd_2000 table. Note: Be sure to create a unique idcode for the municipal table before importing. 

Then using the same Excel import the County-2000 worksheet into Access to create a county level Income_Poverty_county_2000 table.

See Example

Assignment 19 is due on Friday, October 18.
When complete, place the file in the Angel dropbox for Assignment 19

Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.

What we hope to do: Demonstrate how to import data from an Excel workbook.

View Recorded Session

 Friday, October 18

In preparation for working on your personal website please complete the Application for Web Space.

Continue with Access - Working with table object and working with query object.

To Participate Online

Assignment 20
- Import the Population_2000_2009 file from Excel (if you have not already) into 2 Access tables in your Census Database (created for Assignment 19 and in class). Make a Pop_County_2000 table and a Pop_mcd_2000 table. 

Set the Relationship between the new Pop_mcd_2000 table to the Municipal Housing 2000 and Municipal Income 2000 tables.

Create a Query that finds all those Municipalities with a population under 10,000 with Median Household Income greater than $100,000 and a Median Housing Value greater than $150,000. 

See Example

Assignment 20 is due on Monday, October 21.
When complete, place the file in the Angel dropbox for Assignment  20

Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.

What we hope to do:  Demonstrate importing files from Excel and establishing relationships between tables using the Primary key.  Demonstrate the process of establishing a query. 

View Recorded Session

 Monday, October 21

Continue with Access - working with setting relationships, working with Query object and begin working with Report object

To Participate Online

Assignment 21 - Using your Census database (the accumulation of Assignment 19 and 20 and what we did in class) prepare a report that is based on a query that determines the county's that have lost population between 2000 and 2009. 

The Population Excel file for use in creating the query can be found in 10/18 class notes. 

Example

Assignment 21 is due on Wednesday, October 23.
When complete, place the file in the Angel dropbox for Assignment  21

Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.

What we hope to do:  Demonstrate use of the query object. 

View Recorded Session

 Wednesday, October 23

Continue working with Access - Working with Query object and Report object.

To Participate Online

News Item of Interest

Assignment 22 – Class Evaluation
Interested in your thoughts about how the class is going so far.
Please use the following questions to help frame your response. Also feel free to comment on any other aspects not addressed by these questions.
1. Do you feel you are adequately prepared to use the software applications that we have covered so far in your academic, social and professional environment? If not, what specific areas or particular applications need strengthening?
2. Are the assignments appropriate in helping challenge and reinforce what you learn in class?
3. What suggestions do you have, if any, that I might consider to improve your learning environment?

Assignment 22 is due on Friday, October 25.
When completed please put in the Angel dropbox for Assignment 22.

Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.

What we hope to do:  Demonstrate the use of the Query object and creating new fields and the Report object.

View Recorded Session

 Friday, October 25

Continue working with Access - Students can use this class to complete all material on Access and provide a review on Access previous sessions. Instructor will assist students needing to work on specific issues with previous assignments, special projects or extra credit using Access.

To Participate Online

No new assignment


No Recorded Session Provided

   

 Monday, October 28

Creating your personal website.  If you have not yet done so, please please complete the Application for a Web Space Account.

Tips When Creating you personal website

Assignment 23 -
Create a landing page (index.html) for your personal website using MS Word and place the web file in the location provided by the University for storage of your site.

Due to campus closing this material will be covered on Friday, November 2

Assignment 23 is due on Wednesday, October 30.
 When complete, place a note in the drop box that the landing page has been created for Assignment  23

 Up to 2 Assignment points will be awarded for the successful and timely completion of this assignment.
 Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
 Late Assignments may be submitted until Noon on Tuesday, December 17.

What we hope to do:  Work with MS Word in creating web pages.

View Recorded Session

 Wednesday, October 30

Continue Working on Personal Webspace

To Participate Online

Previously invited Guest: Bret Bucklen, Director, Bureau of Planning, Research & Statistics, PA Department of Corrections

Presentation Overview

In early 2012, Governor Corbett commissioned the inter-agency Justice Reinvestment workgroup to explore data driven ways to increase public safety and reduce prison population in Pennsylvania. Led by the Council of State Governments (CSG), this group took an extensive look at the data across PA’s criminal justice system, and made several recommendations for improvement. As a result, these recommendations were recently passed into law in Senate Bill 100 (with some additional recommendations currently pending in House Bill 135). This presentation will provide an overview of the Justice Reinvestment work in PA, and describe how data and research are transforming the PA criminal justice system, enhancing public safety, and saving taxpayer dollars.

View Recorded Session

For Extra Credit Review this previously recorded session and prepare a 1 paragraph reaction to whether you think this is a good strategy or not and why.

This Extra Credit work is due  on Friday, November.
Place your write-up in the Angel Dropbox for any Extra Credit that you have not already used. (up to 5 of them available).

Up to 2 Assignment points will be awarded for the successful and timely completion of this Extra Credit assignment.
Late submissions (after 11:59pm on the day due) will receive a maximum of 1 assignment point.
Late Assignments may be submitted until Noon on Tuesday, December 17.