Lesson 5

In: Computers and Technology

Submitted By koach09
Words 327
Pages 2
2. How do you form a simple condition?
3. How do you form a compound condition?
By connecting two or more simple conditions with the AND, OR, and NOT operators
9. How do you sort data?
You can sort data by using the ORDER BY operator.
12. What are the SQL aggregate functions?
The SQL aggregate function are functions used to calculate sums, averages, counts, maximum values, and minimum values.
14. What is a subquery?
When a query is inside of another query the inner query is the subquery.
15. How do you group data in an SQL query?
You can group SQL query data by using the GROUP BY clause on a particular object.

16. When grouping data in a query, how do you restrict the output to only those groups satisfying some condition?

By using the HAVING clause a query can be written to display the groups that are included

Also complete the following Exercises using the Premier Products database on page 132:
3. List the names of customers with credit limits of $10,000 or more.

5. List the number and name of each customer represented by sales rep 35 or sales rep 65.

8 List the part number, part description, and on-hand value (units on hand * unit price) of each part in item class SG.(On-hand value is really units on hand * cost, but there is no COST col- umn in the PART table.) Assign the name ON_HAND_VALUE to the computed column.

9. List the part number, part description, and on-hand value for each part whose on-hand value is at least $7,500. Assign the name ON_HAND_VALUE to the computed column. 11. Find the number and name of each customer whose name begins with the letter “B.” 15. Find the total of the balances for all customers represented by sales rep 65 with balances that are less than their credit…...

Similar Documents


...Lesson Plan Modifications for English Language Learners Melaney Winkleblack LL240: Linguistically & Culturally Diverse Learners (ACU1240A) Instructor Shannon Gevero November 5, 2012 Lesson Plan Modifications for English Language Learners In schools today there are many different cultures that are present within each classroom and some of those cultures have different values and speak a different language than the majority of the other students within the classroom, so to accommodate those students (ELLs) teachers incorporate different strategies within their lessons and classrooms to ensure that every child is receiving a high standard of education; which will help them to become better prepared for the new world that they are being exposed to. This paper will examine a lesson plan that can be used to help English language learners in their literacy development; addressing the content area of reading and using this lesson plan to further progress a second grade class into becoming proficient. Along with examining the lesson plan, this paper will also identify three strategies, list-group-label, key vocabulary, and prereading text, that are used within it and identify three new strategies that can be used to modify the lesson to allow for comprehensible input and identify ways to scaffold lessons to help improve a student’s comprehension. English language learners are becoming more and more common within our schools and addressing their educational needs is...

Words: 3287 - Pages: 14

The Lesson

...Jaclyn Karpiak English 101 12 April 2012 Short Story Analysis: “The Lesson” Toni Cade Bambara, a Harlem-born author, embraces culture, community, and background through her short story “The Lesson”. She has the main character Miss Moore discuss the struggles African Americans have with Caucasians involving social class, poverty, and equality. For many years after the abolition of slavery, African Americans were still looked down upon and considered a lower social class in certain societies. Bambara uses language as a powerful tool for describing America during the 1960s through the eyes of a young girl named Sylvia, a proud, sensitive, tough girl who is far too smart to ignore the realities around her. Bambara uses language to establish a cultural setting and Miss Moore to teach her students how to be successful, no matter their race. This story reflects Bambara’s ethnic background and pride by using the same dialect that she used growing up in Harlem, New York. According to Bambara, she spoke African American Vernacular English (AAVE), a trait that imparts to Sylvia. African American Vernacular English adds realism and humor to Sylvia's narrative because it describes her ethnicity without directly expressing what it is. It is common for African-American writers to use AAVE to emphasize their political and social commentary, so it is appropriate for Sylvia to be speaking the dialect because the story takes place in the ghetto of New York where Sylvia spends her......

Words: 929 - Pages: 4

Lesson 5

...illustrating the operations of a networking stack is the OSI Model which consists of 7 layers. 5. Protocols that do not guarantee delivery of their data, but do operate with a very low overhead that conserve network bandwidth called Connectionless Protocol. 6. The Windows 7 command-line utility that can tell you if the TCP/IP stack of another system on the network is functioning normally is called Ping.exe 7. The Windows 7 command-line utility that enables you to generate DNS request messages and then transmit them to specific DNS servers on the network is called Nslookup.exe 8. Most network use DHCP to dynamically assign addresses and configure computers to use them. 9. The Windows 7 utility that displays a list of the routers currently forwarding packets to a particular destination is called Tracert.exe 10. The top and bottom layers of the OSI model are called the Application and Physical layers. TRUE / FALSE 1. The purpose of Network Diagnostics is to display error messages only. False 2. Transport layer protocols are not concerned with addressing packets to the correct system. True 3. The Network Map utility uses a new protocol called Link Layer Topology Discovery (LLTD) to discover information about the network and the devices attached to it. True 4. The protocols that Windows uses by default at the network and transport layers are collectively called TCP/IP. True 5. Home and work computers have Network Discovery turned on, and public computers......

Words: 468 - Pages: 2


...of this level, people behave according to socially acceptable norms because they are told to do so by some authority figure (e.g., parent or teacher). This obedience is compelled by the threat or application of punishment. Individualism, Instrumentalism, and Exchange - right behavior means acting in one's own best interests. "Good boy/girl"- characterized by an attitude which seeks to do what will gain the approval of others. Law and Order - oriented to abiding by the law and responding to the obligations of duty. Social Contract - understanding of social mutuality and a genuine interest in the welfare of others. Principled Conscience - based on respect for universal principle and the demands of individual conscience. 2 Conventional 3 4 5 6 Postconventional ERIK ERICSON’S 8 STAGES OF PSYCHOSOCIAL DEVELOPMENT http://web.cortland.edu/andersmd/ERIK/sum.HTML Stage 1. OralSensory 2.MuscularAnal Ages Birth to 12 to 18 months 18 months to 3years Basic Conflict Trust vs. Mistrust Autonomy vs. Shame/Doubt Important Event Feeding Summary The infant must form a first loving, trusting relationship with the caregiver, or develop a sense of mistrust. The child's energies are directed toward the development of physical skills, including walking, grasping, and rectal sphincter control. The child learns control but may develop shame and doubt if not handled well. The child continues to become more assertive and to take more initiative, but may be too forceful,......

Words: 7945 - Pages: 32

5 Lessons from a Dog

...5 Lessons from a Dog In Secrets of a Working Dog by Ellen Galvin and Patrick Galvin, Bella the Boxer outlines these canine principles of success in this dog-eat-dog world. Dogs have a protocol for playtime. When they’re ready to play, they stick their butts in the air, plop their front legs on the ground and prick up their ears. Take some time out of your day to unwind, but take the necessary steps to ensure that it’s scheduled productive play, not simply a waste of time. Become a better listener by wagging your tail more than your tongue. Great listening skills is an integral part of being a good communicator and leader. Many times, a frustrated individual just needs someone to listen to them, not necessarily to offer advice. Learn what your audience’s listening needs are to lend an open ear. Assemble your pack. The most successful people are those who surround themselves with a network of colleagues, mentors and good friends. And if you don’t want to catch any fleas, a good place to start is to surround yourself with people whose habits you would like rubbed off on you. “There are two kinds of people—those who come in a room and say, ‘Well, here I am’ or those that come in a room and people say “There you are.” Dogs are great at making us feel needed and valued, a trait we should learn to pass on to coworkers, employees or family. Enjoy the simpler things in life. Whether it’s taking the time to sniff the flowers or enjoying the wind in a car ride, dogs have a genuine...

Words: 303 - Pages: 2


...industry in Colorado and worked in Environmental Law in Vermont. I have always been interested in the history of mathematical thinking and the development of mathematical concepts, and make a point to emphasize contributions from both Western and non-Western civilizations. This learning module teaches students about the history of the Pythagorean theorem, along with proofs and applications. Feel free to use your own motivational ideas and tailor it to your students! This lesson is geared toward high school Geometry student that have completed a year of Algebra. The video portion is about thirty minutes, and with breaks could be completed in 50 minutes. (You may consider completing over two classes, particularly if you want to allow more time for activities or do some of the enrichment material). These activities could be done individually, in pairs, or groups, I think 2 or 3 students is optimal. The materials required for the activities include scissors, tape, string and markers. Calculators are optional. This lesson addresses the national standards of the National Council of Teachers of Mathematics and the Mid-continent Research for Education and Learning, specifically: • • • Analyze characteristics and properties of two- and three-dimensional geometric shapes and develop mathematical arguments about geometric relationships Use visualization, spatial reasoning, and geometric modeling to solve problems Understand and apply basic and advanced properties of the concepts of......

Words: 1255 - Pages: 6

Ese 697 Week 5 Assignment Lesson Plan 5 Vocabulary or Content Area

...Question 2 Designing a Mini-Lesson in Mathematics contains: Create a mini-lesson in mathematics to teach a small group of students (group description below) using an evidence-based strategy from the textbook. Plan a 15- to 20-minute mini-lesson that addresses the needs of all four students in the group through effective strategies and accommodations for the learners. Respond briefly to the two reflection questions (in the mini-lesson template) about your lesson. Use this mini-lesson template to develop your mini-lesson, and then copy and paste it into the discussion forum to obtain feedback from your peers. Small group description: There are four students in this group who are in fourth grade. Two of the students have a learning disability in math; one student has an intellectual disability who reads at a first grade level, and you also have a student with a visual impairment (low vision). Business - General Business Designing a Mini-Lesson in Mathematics . Create a mini-lesson in mathematics to teach a small group of students (group description below) using an evidence-based strategy from the textbook. Plan a that addresses the needs of all four students in the group through effective strategies and accommodations for the learners. Respond briefly to the two reflection questions (in the Learning Plan Template) about your lesson. Use the mini-lesson template provided in Week Four of your online course to develop your mini-lesson, and then copy and......

Words: 366 - Pages: 2

Answers to Lessons 4&5

...volumes P 107 5. FAT32 P 111 6. Checksum P 137 7. DiskPart P125 8. Administrators or Backup Operators P 122 9. MBR P 111 10. Widows Hardware Quality Lab P 139 TRUE/FALSE 1. FALSE 2. FALSE 3. TRUE 4. FALSE 5. TRUE 6. FALSE 7. TRUE 8. TRUE 9. FALSE 10. TRUE REVIEW QUESTIONS 1. Both spanned volumes and striped volumes utilize storage space of 2 to 32 disks. The difference between the two is that spanned volumes fill up the space on one disk at a time, while striped volumes write one strip at a time to each disk in sequence. Neither method provides fault tolerance because there is no redundant data. However, striped volumes provide better performance than spanned volumes because the sequential disk reads and writes are more efficient than those on a single drive. P 110 versions, 2. Manufacturers typically release driver updates to address problems with previous driver, enhance device performance, or add new features. 137 CASE Scenarios Because you can’t see the display, the only thing you can do is turn off the computer and restart it .Press F8 as the computer starts and select Safe Mode from the boot menu. This loads the operating system with a genic VGA display driver that enables you to at least see the interface. Open Device Manager and use the Roll Back feature on the Driver tab of the video adapter’s Properties sheet to remove the problematic driver you just installed and return to previous version. P143. LESSON 5 FILL......

Words: 593 - Pages: 3


...An assignment on Writing “a lesson” CC: 0038 / Materials Development Submitted To Prof. Dr. M. Maniruzzaman Coordinator, MAPW Department of English Jahangirnagar University Submitted By Md Sumon Miah Class ID: 1143029 Department of English Jahangirnagar University Unit 1 : Climate Change Learning Outcomes After you have studied this unit, you will be able to * Read and understand texts * Talk about climate and environment * Ask and answer questions * Take part in role-plays * Write short guided and semi-guided sentences and passages Lesson 1 : The greenhouse effect Key words : Trap planet roof greenhouse global warming release A Nowshin and Sajid read about greenhouse effect in the booklet. Read the passage to know what Nowshin and Sajid have learnt so far. A greenhouse is a house made of glass. It has glass walls and a glass roof. People grow tomatoes and flowers and other plants in them. A greenhouse stays warm inside, even during winter. Sunlight shines in and warms the plants and air inside. But the heat is trapped by the glass and can't escape. So during the daylight hours, it gets warmer and warmer inside a greenhouse, and stays pretty warm at night too. This is because the heat received from the sun is trapped inside the greenhouse by the glass. The Earth is also like a greenhouse. During the day Earth’s surface warms up in the......

Words: 735 - Pages: 3


...Geeves (VIAfilm) World Education UNICEF 28 September 2007 1 CONTENTS Tables 3 Links to documentary video 4 Acronyms 5 Foreword 7 A note on the OPTIONS evaluation report and documentary video Executive Summary 8 1. General background, evaluation method and coverage 18 2. Identification of vulnerable children 25 3. Improved formal education opportunities 29 Scholarships, Life skills, Student Support Network, Improved quality of teaching and learning, improved professional support to teachers 4. Improved non-formal education opportunities 43 School re-entry, My Better Future, NFE programs for out-of-school youth 5. Tracking and follow up of vulnerable children 52 Formal education, Non-formal education, Referral children 6. Impact on children and their families 56 Impact on children, Impact on families 7. Impact on communities, society and local institutions 60 Community attitudes to girls and education, child protection, Commune Councils, CEFAC/CWCCs 8. Capacity building, Cost effectiveness, Advocacy, Accountability/feedback, Sustainability 65 9. Findings and recommendations 73 Interviews and observations conducted 81 References 83 Attachments Attachment 1 Attachment 2 Attachment 3 Attachment 4 Attachment 5 Attachment 6 85 Terms of Reference for the Evaluation OPTIONS Prey Veng Working Groups (DME Framework) Implementation through......

Words: 33045 - Pages: 133

Ese 315 Week 5 a Diversity Preschool Lesson Plan

...ESE 315 WEEK 5 A DIVERSITY PRESCHOOL LESSON PLAN A+ Graded Tutorial Available At: http://hwsoloutions.com/?product=ese-315-week-5-a-diversity-preschool-lesson-plan Visit Our website: http://hwsoloutions.com/ Product Description PRODUCT DESCRIPTION ESE 315 Week 5 A DIVERSITY PRESCHOOL LESSON PLAN, MISSION STATEMENT PRESCHOOL EDUCATOR POVIDES EDUCATION OPPORTUNITIES FOR ALL CHILDREN,FAMILIES AND STAFF. We believe that every second in a the preschool classroom is an opportunity to further our program mission and goals. Each conversation, the nutrition meal we serve, the unique decor of the classroom, the books we read, all impact the development of the whole child. Our teachers work sympathetically to present the greatest opportunity for social, emotional, physical, and cognitive development at all times. Each child is cherished and guided to reach their full potential during their time with us. As each child journey through preschool they will, learn through play. With a decent teacher, he/she can observe children’s play, engage children in play, and extend learning through play. We will focus on interaction, observation, experimentation, and active exploration of real objects and relationships in the environment because children have an important role in development of an emergent curriculum based on their interests and needs. With this in progress they will be able to do new things and will always be encouraged to work at their own pace and work on an activity......

Words: 501 - Pages: 3

Ese 315 Week 5 a Diversity Preschool Lesson Plan

...ESE 315 WEEK 5 A DIVERSITY PRESCHOOL LESSON PLAN To purchase this, Click here http://www.activitymode.com/product/ese-315-week-5-a-diversity-preschool-lesson-plan/ Contact us at: SUPPORT@ACTIVITYMODE.COM ESE 315 WEEK 5 A DIVERSITY PRESCHOOL LESSON PLAN 1. MISSION STATEMENT 2. Outline of the laws governing exceptional children that impact my instructions: 3. FERPA & SECTION 504 4. ESEA: Elementary and Secondary Education Act 5. Classroom Description for my Students 6. Ways I will communicate with the families of my students in order to meet the individual needs of each child: 7. Two instructional approaches I will utilize in my instruction 8. A discussion of my instructional plan, including accommodations, modifications and services available to my student who exhibits certain behaviors but has not been diagnosed: 9. Why I feel the chosen approaches will be effective? 10. An explanation of my instructional techniques/plans for my eight typically developing students: 11. A description of my instructional plan, including accommodations, modifications, and services available to my student who has an Autism Spectrum Disorder: 12. A description of my instructional plan, including accommodations, modifications, and services available to my student who has an Autism Spectrum Disorder: 13. A description of your instructional plan, including modifications/extensions for your student who is cognitively and linguistically advanced: 14. An explanation of my......

Words: 747 - Pages: 3

The Lesson

...a mystery. Context that is not found from just the first read but through investigating the text and giving significant meaning to details you thought were the most unimportant features to the story. In the story “The Lesson” by Toni Bambara , you first read it and get the basic idea. After analyzing the text I believe that the story is talking not only about poverty but also showing that education is important. It shows the kids in the story that you can make a change in your life. They are not socially equal with the other rich white people but can change that thought the course of their life. The kids teacher, Miss Moore, is a college educated black woman. She always makes the kids do things they do not enjoy and the do not like her much. The true fact of why they do not like her is because she makes them come with her even in summer when school is supposed to be out. She is just trying to teach the kids and takes it as her responsibility to educate the young ones. Her first lesson of the day was teaching was about money. She asks if they knew what it was. They thought she was calling them dumb for asking them what money was but she was really foreshadowing for her lesson she was teaching them that day. In the taxi Miss Moore gives Silvia a $5 bill and wants them to figure out 10% tip for the cab driver. The get to where there going and they are not sure so they give him a dime. They figured they needed it more than the Satterfield 2 taxi driver does.......

Words: 1113 - Pages: 5

Case: Anglo American Plc in South Africa (from Lesson 5)

...Case: Anglo American PLC in South Africa (from Lesson 5) 1 Who are the various stakeholders that Anglo American needs to consider as it adopts an effective HIV/AIDs strategy? - Anglo American employees and their families - Government bodies - Non- Profit organizations (NGOs)/ World Health Organization (WHO) - Competitors/ Other large mining concerns or companies operating in South Africa - Pharmaceutical companies - National Union of Mine Workers - Financial Institutions - Shareholders 2 What are the pros and cons of Anglo American’s adoption of an aggressive strategy in combating HIV/AIDS among its South African workforce? What recommendations would you give the company concerning its HIV/AIDS policy? Pros: - Prevented further operating loss and increased productivity. - Bright future as government started national strategic plan to combat HIV/AIDS. - By adopting the strategy, the company achieves trust and commitment from ethical minded shareholders. - It got good response from WHO, Global business council for HIV/AIDS and other NGOs, this makes the company a socially responsible organization in Global business. - It became a trend setter for other major companies operating in South Africa, thus gaining a goodwill among other companies Cons: -This program had spiraling costs for the company as the distribution of the medicines remained high. - It was unable to determine if its efforts are making a difference in underlying problem as......

Words: 1809 - Pages: 8

Ese 697 Week 5 Assignment Lesson Plan 5 Vocabulary or Content Area

...ESE 697 Week 5 Assignment Lesson Plan 5 Vocabulary or Content Area To Buy This material Click below link http://www.uoptutors.com/ESE-697-ASH/ESE-697-Week-5-Assignment-Lesson-Plan-5-Vocabulary-or-Content-Area Lesson Plan #5: Vocabulary or Content Area. As you have learned in this fifth week of class, it is essential to understand how to plan for effective vocabulary and content area instruction for students with disabilities. In the classroom, it is important for all lesson plans to not only integrate effective strategies for instruction and accommodations for students with disabilities, but to also align with Common Core State Standards. This lesson plan will focus on using effective, research-based strategies for teaching vocabulary (or a content area) to students with disabilities. Your lesson plan should use at least one, if not multiple, research-based strategies for teaching in this content area for students with disabilities. Your textbook has a plethora of strategies, but you may also seek other strategies as well in other peer-reviewed texts or articles that were required or recommended this week. By now, you should be close to mastering writing lesson plans that have a clear learning objective that is aligned to Common Core State Standards. Additionally, the lesson plan should incorporate an assessment task aligned to the learning objective and standard. The lesson plan should include evidence-based strategies for students with disabilities, and should......

Words: 747 - Pages: 3

Kite Movie | Gentleman MTV Unplugged 2014. | the house with a clock in its walls 2018