Category: Data Entry

Module 04 Content
Background
ScenarioYour state licensing representative has just informed you that because of the surge in COVID-19 cases reported within your family childcare home, in-person instruction has again been canceled for the remainder of the school year. Due to this stay-at-home order, you begin to develop a plan to help your preschoolers and their families successfully transition from face-to face, hands-on learning to going remote. You have decided to conduct internet research and find an app that will provide the most effective ways to communicate with parents and families during remote learning.
You understand that simply typing messages by email or on your learning platform will not be enough to continue to engage families. Therefore, you plan to regularly check-in and continue to strengthen connections with parents and families via on-going phone calls, texts, written notes, and Zoom conferences that show how much you care. However, with so many virtual learning apps that allow teachers and parents to efficiently communicate with one another, you are determined to find a tool to keep your communication consistent.DirectionsFor this assignment, you will conduct internet research to find an application (app) for smart-er teacher-parent communication.
PLEASE NOTE: You do not need to purchase the communication app or have access to it. You will create your presentation based on your internet research, reviews you have read about the app, and/or feedback from colleagues, family members, or friends who are familiar with the app.Research: You will need to find an app that has at least four, if not all, of the following:
Mobile-friendly: The app does not require Wi-Fi or data and/or can be used offline to make accommodations for the technical obstacles children and their families might be facing.
Text Messages: The app sends out consistent text messages to parents and families about important dates, class assignments, and sudden changes.
Reporting: The app sends weekly email reports that show what students accomplished for the week.
Calendar: The app provides a snapshot of upcoming events and activities, in addition to upcoming projects or assignments.
Office Hours: The app allows you to set up and provide virtual office hours or online check-in times for parents to talk to you and ask questions about their student’s learning, remote learning expectations, etc.
One Stop Shop: The app keeps all important information in one place making it easier for parents to recall details because they know where to access class and school information.
PowerPoint Presentation: Once you have identified your parent-teacher communication app, you will host a virtual parent meeting. The goal of this meeting is to introduce the new app and train them on how to best use it. You will create a PowerPoint presentation for this meeting. The presentation will include the following items:
Title Slide (1 slide): Introduce your presentation.
Introduction (1 slide): Introduce yourself, your name, your current role in the early learning program, your experience working with children and families, and include other information you feel relevant to share.
Introduce the App and Overview (2-3 slides): Include a clear description of the new tool. Include images (clip art, online photo, internet images, etc.)
Explain the features of the app. Describe in detail what the app can do and how the app will help create a better learning environment for families.
Research (2-3 slides): Use current facts, data, and statistics found in your internet research about the importance of using technology to strengthen communication and to build relationships with families.
Include graphs, survey data, charts, etc. to support your research.
Importance (1-2 slides): Describe how promoting parent partnerships positively links to better child outcomes.
Examples (1 slide): Share at least three examples of how the app helps to cultivate healthy communication between home and school.
References (1 slide): Include at least two sources in APA format with in-text citations.
The Presentation: You will record yourself giving your PowerPoint presentation on Zoom.
You will create a Zoom account if you do not already have one.
You will create a Zoom meeting. You will record your presentation by sharing your screen and recording at the same time.
Be sure your audio presentation does not extend more than one minute per slide as you read and share.
Make sure:Your PowerPoint presentation has at least nine slides and follows the format described above.
Slides are engaging and include appropriate visuals.
Include APA citations to all sources used for this assignment, including a title page and reference page in APA format. Include at least one resource from the course lesson content or Rasmussen library.
Use professional language and a professional appearance (i.e., hair, clothing, voice and tone, organized and neat background/environment)
All work should be formatted professionally and use correct spelling, grammar, and punctuation.
Submission RequirementSubmit your completed PowerPoint presentation and a link to the video recording by following the directions linked below.Please check the Course Calendar for specific due dates.
Save your assignment as a PowerPoint presentation or a PDF. Make sure to also include the link to your recording. (Mac users, please remember to append the “.docx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:Jstudent_exampleproblem_101504Additional ResourcesPowerPoint Presentation
Create a Zoom Account
Record a PowerPoint Presentation in Zoom
APA Guide
Writing Guide

Instructions
During this class, students will work on several practice problems. Some practice problems require the use of drawing tools and software. These tools are used by IT and business professionals to visualize, analyze, and communicate complex problems, systems, and processes. You need these tools to create Entity-Relationship diagram.
Please refer to the “Course Software” tab on Blackboard to explore the recommended tools. You should use online resources from Youtube and Google to find tutorials and learn how to use these drawing software. Feel free to contact the TA and the instructor if you need further assistance.
Practice Problem 1:
Come up with business rules for the scenarios given below:
Scenario 1: Business rules define two entities and one 1:M relationship.
Scenario 2: Business rules define two entities and one 1:1 relationship.
Scenario 3: Business rules define two entities and one M:N relationship.
For each scenario, clearly identify the following: Business rules that define two entities and describe a relationship in both directions Entities Relationship type Justification of the chosen relationship type (use complete, coherent sentences!)
Practice Problem 2:
Using the business rules provided below, list all the entities, and identify each relationship type among the entities. Business rules are defined as follows:
A painter can paint many paintings. Each painting is painted by only one painter.
A gallery can exhibit many paintings. Each painting is exhibited in only one gallery. A painter can exhibit paintings at more than one gallery at a time.
Practice Problem 3:
For the business problems given in Practice Problem 2, draw an Entity-Relationship diagram using the Crow’s Foot notation using your preferred ERD drawing tool (check Course Software). Make sure to include all entities, attributes (add 2-3 hypothetical attributes if not given), and relationships.
Assignment Submission
Save all your solutions in a Word file, type your name and course number in that file, name it M1_2_Practice_Problems.
Sample Solution (Attached Document)
Check the attached document for a sample solution that can help you better understand the submission requirements. Instructions
Throughout this course, you will need to design and implement a real-life relational database for a fictional company. First, you will define the company’s business requirements and design the database schema, showing in detail all the relations (tables), data types, relationships, and constraints to be used in the database. After the design phase is over, you will implement the schema in Oracle by creating the required tables with appropriate data types together with relationships and constraints, and populate all the relations with valid data. Last, you will use your database to retrieve the required data using complex SQL queries.
In this assignment, you need to include the following:
A short description of the company (you can use just one department or business process if the company is large)
Reasons why the company needs a database
Detailed business requirements that describe all entities, relationships, and constraints from the business perspective. Do not include more than 4-5 entities! It is very difficult to design a large database without prior experience. Your database will be revised in the following assignments and you will have a chance to make it more complicated later on.
A detailed description of each entity including the name, purpose, and attributes. Description of relationships between entities. Make sure to evaluate each relationship in both directions!
A list of different users for the database you proposed. Define user categories and describe different types of applications each user would need. Explain what type of interface each user would need.
Explain which DBMS architecture would you choose from section 2.5 of the Fundamentals of Database Systems textbook and why. Why would the other architectures not be a good choice?
Assignment Submission
Write your solutions in a Word file, type your name and course number in that file, name it M1_2_ Relational_Database_Specifications. Your paper will be checked in SafeAssign for originality.