TED5110 - EXCEL and ACCESS

COMPUTERS AS CALCULATORS AND DATA ORGANIZERS

LECTURE - Numerical organization, calculation, visualization, and analysis: Spreadsheets and Data Bases

Excel and dedicated Statistical Analysis programs - SAS, SPSS, STATVIEW  

HANDS-ON – WARMUP - Basics of MS Excel spreadsheets/worksheets. Create the following:

Calculating the PERIMETER and AREA of a circle and a simple pie graph of a fraction dynamically.
Building a standard, dynamic MULTIPLICATION TABLE (sample with graph1, Sample with graph 2) >>> #4a

HANDS-ON – "Design and build an MS Excel spreadsheet that keeps track of the grades of 12 students, through 10 tests.  Assume only 5 scores available currently"GRADE TRACKING page, using the AVERAGE math function to compute student, and class GPAs (see sample image, spreadsheet - need to complete). To add a graph:

1. Highlight-select a rectangle containing ALL the rows and columns to be graphed, i.e. from top-left corner, including the student and test names, to the bottom-right corner for the last student row and test data column.
2. Select "Insert > Charts - Line - and choose the first option in the second row # "2D line". If the row (students), and row (tests) data appears reversed, use the Design > Data/ Switch data row / column.
3. Complete entering data for the 12 students and some 5 tests requested in the syllabus. >>> #4b

HANDS ON - Create a graph of the STAR math test scores achieved by each one of the grades at a local elementary school.  The latest data (2010) should be available (California Department of Education) through the Internet" (see sample image), spreadsheet.

1.- Use the link above "through the Internet", to find information regarding the last (2009) State Test (STAR) Math Scores, describing the proportions of students falling within each of the achievement groups ("Above average",.. to .., "Far below basic") for each and all grades at a local elementary, middle, or high school.

2.- Transfer the web data to a spreadsheet by copying from the web page, and pasting it into the spreadsheet. Make sure to add the grade labels at the top, and create the line graph of the percentages (vertical - x) against the grades (horizontal - y) to view the progression of each performance group throughout the grades.

3.- Briefly discuss your school’s results in one or two paragraphs. >>> #4c

OTHER READY-AVAILABLE FUNCTIONS IN EXCEL

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - BREAK  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

LECTURE -DATABASES: Information classification, storage & retrieval. What is a database? (Data Base OVERVIEW) Popular data base software providers – Access, Oracle, PeopleSoft, Sybase, etc. Educational research iformation data bases (e.g. NCES, other research data bases, , and "search engines" (e.g. Yahoo, Ask. Google). Some school administration and student databases: Zangle, Attendance keeper, etc.

HANDS-ON - Build a starter MS Access “Student Data Base” using the Wizard.  Step-by-step procedures are available ( MSAccess 2003 and MSAccess 2007 )to create a starter database using MS Office. The procedures include the snapping of a screen image, once a corresponding form, or report is being displayed. >>> #4d