Higher Education Assignment

The ATD, LEAP, MDRC, and DEEP programs are all rooted in Tinto’s theory of student departure and Chickering’s (Skipper, 2005) and Kuh’s (Kuh, Kinzie, Buckley, Bridges, & Hayek, 2006) theories of student engagement. They teach us a lot about what works in student success. For this assignment you will study one of these programs(The ATD, LEAP, MDRC, and DEEP)  and describe how you could use one of its practices to improve a program or service at your college or another one that you are familiar with.

(Assignment length: 1 page) please use the above reference theories as the base of the facts of the pape

Database Project 3

1

Project 3

In this assignment you will be performing some additional queries against your Online Vehicle Sales (OVS), Inc. online transaction processing (OLTP) database and also creating some simple anonymous PL/SQL blocks.

You will also begin the creation of a data warehouse database for Online Vehicle Sales (OVS), Inc. The full data warehouse is comprised of 4 dimension tables and a fact table based on the Star Schema diagram posted in LEO’s Week #6 area. Your OLTP database tables and star schema tables will reside in the same Oracle schema.

This assignment is based on the fully populated tables from Homework #2 so it assumes you’ve completed all work for that assignment.

You can perform this assignment based on a database on Nova or any other Oracle system you wish, but you must use the Oracle RDBMS.

You should use one or more SQL script files to complete this assignment. Your script files should contain all your SQL and PL/SQL code. Do NOT submit your SQL script files. Doing so may result in confusion and will result in lost points.

Everything for this assignment must be in a single file. If you are using SQL*Plus you must put all your SQL, PL/SQL, and results together in a single SPOOL file. If you are using SQL Developer or other GUI, put all your screen snapshots in a single file for both your SQL statements and PL/SQL as they executed and the results. Failure to include all your SQL, PL/SQL, and all your results along with them will result in lost points.

Do NOT submit additional files as this only complicates the grading, and will result in lost points.

Here are the specific assignment steps. In order to earn full credit you must keep your steps in order, number your steps, and put everything in a single file.

1) Execute SELECT COUNT(*) FROM <table_name>; statements for all 6 of your OVS, Inc. OLTP tables. You should have at least the following counts: CUSTOMERS table – 100 rows, VEHICLES table – 50 rows, SALESPERSONS table – 10 rows, FINANCING_PLANS – 5 rows, SALES table – 200 rows, and SALES_FINANCINGS table – 200 rows.

2) Via a single SELECT query display the zip code, make, and count with the largest total car purchases for a zip code and make combination (there may be a tie with two or more). Show the SQL statement you used and the results returned by Oracle from executing your SQL statement right after the statement.

3) Develop a PL/SQL anonymous block that displays the total sales for a zip code for a specific zip code. You may use any of your zip codes you wish. Show the PL/SQL statements in your block, the actual execution of your block, and the results returned.

 

 

2

4) Develop a PL/SQL anonymous block that displays the zip code with the largest total car purchases. Since there can be a tie with two or more zip codes, ensure that the lowest numeric zip code is displayed. The zip code displayed should correlate to the results of Step #2. Show the PL/SQL statements in your block, the actual execution of your block, and the results returned.

5) This step begins the creation of your data warehouse. Ensure that your FINANCING_PLANS table has already been created and populated via a “SELECT * FROM financing_plans;” SQL query. This table is used by both your OLTP database and serves as a dimension table in the star schema of your data warehouse database. Your Plan_ID primary key is the Plan_Code column. Don’t worry about changing this to Plan_Code or changing any other column names you already have. Show the SQL you used and executed and the results.

6) Create the DEALERSHIPS star schema dimension table via SQL. Add at least 2 rows of data via INSERT statement(s). After populating your DEALERSHIPS table execute a “SELECT * FROM dealerships;” SQL statement to display the entire contents. Show all your SQL code for this step and the Oracle results from executing it.

7) Create the VEHICLES star schema dimension table via SQL. Change your existing OLTP VEHICLES table to OLTP_VEHICLES via the SQL RENAME command and change your SALES table’s foreign key to reference this new table name. For the Vehicle_Code primary key column use an Oracle sequence to populate the values. For the Description column use all concatenated combinations of Make and Model of vehicles you have. Use a PL/SQL block to populate the Description column by SELECTing the combinations from your OLTP_VEHICLES table and then INSERTing the combinations into your new VEHICLES table, which would best be performed via a cursor in a loop. After populating your VEHICLES table execute a “SELECT * FROM vehicles ORDER BY vehicle_code” SQL statement to display the entire contents. Show all your SQL and PL/SQL code for this step and the Oracle results from executing it.

Your submission MUST be in a single text, Word, or PDF file with all steps numbered and in order.

Project 3 grading rubric

Attribute Meets Does Not Meet

CREATE TABLE SQL statements

20 points

Uses an SQL script file. Creates the DEALERSHIPS star schema dimension table. Creates the VEHICLES star schema dimension table. Changes your existing OLTP VEHICLES table to OLTP_VEHICLES via the SQL RENAME command and change your SALES table’s foreign key to reference this new table name.

0 points

Does not use an SQL script file. Does not create the DEALERSHIPS star schema dimension table. Does not create the VEHICLES star schema dimension table. Does not change your existing OLTP VEHICLES table to OLTP_VEHICLES via the SQL RENAME command or change your SALES table’s foreign key

 

 

3

Uses an Oracle sequence to populate the Vehicle_Code values. Uses all concatenated combinations of Make and Model of vehicles for the Description column. Uses an Oracle RDBMS. All SQL statements are syntactically correct and execute without error.

to reference this new table name. Does not use an Oracle sequence to populate the Vehicle_Code values. Does not use all concatenated combinations of Make and Model of vehicles for the Description column. Does not use an Oracle RDBMS. All SQL statements are not syntactically correct or execute without error.

INSERT SQL statements 25 points

Adds at least 2 rows of data via INSERT statement(s) to the DEALERSHIPS Star schema table.

All SQL statements are syntactically correct and execute without error.

 

 

0 points

Does not add at least 2 rows of data via INSERT statement(s) to the DEALERSHIPS Star schema table.

All SQL statements are not syntactically correct or execute without error.

SELECT SQL statements 5 points

Executes SELECT COUNT(*) FROM <table_name>; for all OLT tables resulting in expected counts.

Via a single SELECT query display the zip code, make, and count with the largest total car purchases for a zip code and make combination.

Ensures that your FINANCING_PLANS table has already been created and populated via a “SELECT * FROM

0 points

Does not execute SELECT COUNT(*) FROM <table_name>; for all OLT tables resulting in expected counts.

Does not, via a single SELECT query, display the zip code, make, and count with the largest total car purchases for a zip code and make combination.

Does not ensure that your FINANCING_PLANS table has already been created and

 

 

4

financing_plans.

After populating your DEALERSHIPS table execute a “SELECT * FROM dealerships;”

After populating your VEHICLES table execute a “SELECT * FROM vehicles ORDER BY vehicle_code”.

All SQL statements are syntactically correct and execute without error.

populated via a “SELECT * FROM financing_plans.

Does not, After populating your DEALERSHIPS table execute a “SELECT * FROM dealerships;”

Does not, after populating your VEHICLES table execute a “SELECT * FROM vehicles ORDER BY vehicle_code”.

All SQL statements are syntactically correct and execute without error.

All SQL statements are not syntactically correct or execute without error.

PL/SQL anonymous blocks 40 points

Develops a PL/SQL anonymous block that displays the total sales for a zip code for a specific zip code.

Develops a PL/SQL anonymous block that displays the zip code with the largest total car purchases.

Ensures that the lowest numeric zip code is displayed.

The zip code displayed should correlate to the results of Step #2 above.

Uses a PL/SQL block to populate the Description column by SELECTing the combinations from your OLTP_VEHICLES table and then INSERTing the combinations into your new VEHICLES table, which would best be performed via a cursor in a loop.

0 points

Does not develop a PL/SQL anonymous block that displays the total sales for a zip code for a specific zip code.

Does not develop a PL/SQL anonymous block that displays the zip code with the largest total car purchases.

Does not ensure that the lowest numeric zip code is displayed.

The zip code displayed does not correlate to the results of Step #2 above.

Does not use a PL/SQL block to populate the Description column by SELECTing the combinations from your OLTP_VEHICLES table and then INSERTing the combinations into your new VEHICLES table, which would

 

 

5

best be performed via a cursor in a loop.

 

SQL script file and SPOOL file 10 points

Submits either an SQL*Plus SPOOL file or screen snapshots of the output if using SQL Developer or another GUI. Demonstrates DROP TABLE, CREATE TABLE, and ALTER TABLE SQL statements as they executed and the Oracle responses. Demonstrates INSERT SQL statements as they executed and the Oracle responses. Displays the contents of all tables from SELECT * FROM tablename; statements. Displays all single SELECT statements queries. Displays all PL/SQL code and execution. Does NOT submit a SQL script file. Includes a SET ECHO ON SQL*Plus statement in your SQL script file to ensure that all the SQL that is executed is displayed in your SPOOL file.

0 points

Does not submit either an SQL*Plus SPOOL file or screen snapshots of the output if using SQL Developer or another GUI.

Does not demonstrate DROP TABLE, CREATE TABLE, and ALTER TABLE SQL statements as they executed and the Oracle responses. Does not demonstrate INSERT SQL statements as they executed and the Oracle responses. Does not display the contents of all tables from SELECT * FROM tablename; statements. Does not display all single SELECT statements queries. Does not display all PL/SQL code and execution. Submits a SQL script file. Does not Include a SET ECHO ON SQL*Plus statement in your SQL script file to ensure that all the SQL that is executed is displayed in your SPOOL file.

Getting To Know The Literacy Learner

Complete Part 1 & Part 2.

 

Part 1: Assessment to Inform Instruction

For this part of your Assignment and for your selected 4-6 grade literacy learner, write at lease (4 Pages ) a summary and analysis of the assessments given that addresses the following below:

 

Part 2: Writing

For this part of your Assignment, write (2 pages) a section in your paper that addresses the following question below: Using APA style and reference.

View attachment of assignment

Assignment: Getting to Know the Literacy Learner—Assessment to Inform Instruction

 

Part 1: Assessment to Inform Instruction

Complete Part 1 & Part 2

For this part of your Assignment and for your selected 4-6 grade literacy learner, write at lease (4 Pages ) a summary and analysis of the assessments given that addresses the following below: Using APA style and Reference.

 

1. Describe and provide background information about your intermediate literacy learners, and include an explanation of the receptive language skills of each student. Include specific information about the developmental stage of reading to support your explanation. Note: Do not use the literacy learner’s real name. Use only a pseudonym.

2. Identify the cognitive and noncognitive assessment tools used to collect data on the receptive language skills of the students. Provide a rationale for why you think these particular assessments are appropriate for the literacy learner.

3. Summarize the data you collected from each of the assessments, including the student writing sample and survey. Explain how these data inform reading and writing instruction needed for your student. Also, include an explanation of any new insights you gained from the data you collected.

4. Finally, based on the cognitive and noncognitive assessment data, explain how the instructional adjustments you would make to support this student.

 

Assignment: Getting to Know the Literacy Learner—Writing

Part 2: Writing

For this part of your Assignment, write (2 pages) a section in your paper that addresses the following question below: Using APA style and reference.

 

1. Explain the results of your analysis of the writing sample from your intermediate literacy learner. In your results, identify the learner’s writing stage and why you think this is the right stage for your learner.

2. Explain how you would support the literacy development of the learner based on the writing sample, and include ideas from digital learning environments, 6 +1 Trait® of Writing, and writing processes. Use your Learning Resources to support your explanation.

3. Explain how the CCSS and/or state standards for reading and language arts inform instruction for your literacy learner. Include at least one way in which you might integrate the use of technology in your planning of writing instruction.

4. Based on the developmental writing stages, explain how you can help your intermediate literacy learner transition to the next stage in writing.

 

 

 

Helpful Reference

Tompkins, G. A. (2010). Literacy for the 21st century: A balanced approach (5th ed.). Upper Saddle River, NJ: Pearson.

· Chapter 2, “Teaching the Reading and Writing Processes” (pp. 52–65)

 

 

 

Coskie, T. L., & Hornof, M. M. (2013). E-best Principles: Infusing Technology Into the Writing Workshop. The Reading Teacher, 67(1), 54–58.

 

 

 

Bottomley, D. M., Henk, W. A., & Melnick, S. A. (1997). Assessing children’s views about themselves as writers using the Writer Self-Perception Scale. The Reading Teacher, 51(4), 28

 

Dalton, B. (2012). Multimodal composition and the Common Core State Standards. The Reading Teacher, 66(4), 333–339.

 

Gillis, A., Luthin, K., Parette, H. P., & Blum, C. (2012). Using VoiceThread to create meaningful receptive and expressive learning activities for young children. Early Childhood Education Journal,40(4), 203–211.

 

Reutzel, D. R., & Cooter, R. B., Jr. (2016). Strategies for reading assessment and instruction in an era of common core standards: Helping every child succeed (5th ed.). Boston, MA: Pearson.

· Chapter 1, “Reading Assessment in the Classroom” (pp. 9-23)

 

 

Malloy, J. A., Marinak, B. A., Gambrell, L. B., & Mazzoni, S. A. (2013). Assessing motivation to read: The motivation to read profile—revised. The Reading Teacher, 67(4), 273–282.

 

 

Henk, W. A., & Melnick, S. A. (1995). The Reader Self-Perception Scale (RSPS): A new tool for measuring how children feel about themselves as readers. The Reading Teacher, 48(6), 470–482.

 

Afflerbach, P. (2012). Understanding and using reading assessment K12 (2nd ed.). Newark, DE: International Reading Association.

 

· Chapter 8, “Assessing ‘the Other’: Important Noncognitive Aspects of Reading” (pp. 171–189)

 

Schiefele, U., Schaffner, E., Möller, J., & Wigfield, A. (2012). Dimensions of reading motivation and their relation to reading behavior and competence. Reading Research Quarterly, 47(4), 427–463. (Recommended reading pp. 427–431)

Write An Essay In 9 Hours

FINAL FOR CD 125

Thank you for a wonderful semester. It has been a pleasure meeting with you each week. I hope you come away with some tools to aid you further in your careers and in life. Each portion of this final is worth 8 points so please take your time in answering them! Each question should be no less than half a page in length.

Answer the questions in bold:

a. Analyze major milestones for children from conception through adolescence in the areas of physical, psychosocial, cognitive, and language development using standard research methodologies. Discuss 3 pieces of knowledge you took away as most important for one level of development (conception, infancy/toddler, early childhood, middle childhood, adolescence). For full credit please make sure to connect directly to course content.

b. Analyze how cultural, economic, political, historical contexts affect children’s development.

Choose one of these contexts and discuss 3 pieces of knowledge you took away as most important for one level of development (conception, infancy/toddler, early childhood, middle childhood, adolescence). For full credit please make sure to connect directly to course content.

c. Compare and contrast various theoretical frameworks that relate to the study of human development. Choose two to compare: Piaget, Freud, Erikson, Vygotsky, Skinner, Bandura, Maslow, etc.

d. Integrate and apply current theory and research to the observation, documentation and unbiased analysis of a preschool child’s behavior. How did you participate in this learning? What did you take away?

e. Differentiate characteristics of typical and atypical development at various stages.

What did you take away from this course in regards to typical and atypical development?

f. Analyze the interaction of genetic/nature and environment/nurture on various areas of development. Discuss where you stand on this debate and back up your position with specific course content.

I would like you to showcase your learning that you completed throughout this semester:

· Connect each SLO to a theory, though, idea, or project we did this semester.

· Make sure to cite your sources.

 

Bonus Last question:

What piece of advice would you give incoming students to this class?