Danielle Earley's Classroom Notes

Danielle Earley's Online Notes Week 5


Questions	Recall	Analyze
Comparison	Inference	Evaluate

Running Notes For Computers In Education Class

In class the mays spreadsheet makes more sense now that I have a clearer idea about what we are looking at and why. I think this shows something about the type of thinker I am which is I can't just look at data I need something to connect it to.
I think

Answering database question.
How many foods have more than 10 of carb. and 30 fat. This is called an and search.
click on record. click on filter then click on advanced filter sort.
put carb in field greater then 10 in criteria. fat in field then >30 for fat; click funel which applies filter. four records because there are four rows. You have to know something. Get one that reflects one or two. This way you can ask a more detailed question of the database. to get out click records and then remove search.

Or search brings up 76; because you are putting >30 in the or instead of the criteria box.

Educ>11 income<11000 region mountain came up with three. asterix on either side.
Get some database questions from the web site.
you can put answers on web page, put it a little bit below questions so they can try it. There is a link to database tutorial. Go to place called sample questions, go to other peoples web pages search for question 80.
First thing we will do next week is review. Midterm- second half is the test.
multiple choice assigned readings.
third section of test is an essay questions. How are they the same and how they are different.

Look at spreadsheets made by each of the students and their comparison spreadsheets. The solution to my problem is that you do not want to capitalize when you are saving files that are going to be downloaded to the web.

Our eyes get comfort from left justified. Do basic sorting. Put all no's together and all yes' together when you. Sort and select all the roads.
It will have a hard time sorting by numbers if there is a range of numbers. You can do the mays spreadsheet by taking basic algebra and expressing the way the spreadsheet can deal with it.
The first step is to pick the data and then the second concept is to select those numbers to create a graph.
He can change growth rate to show how patterns change over time.
This enables us to do work that before was to tedious to do. Henry wrote about population control. There is a non linear relationship.
We are variables that interact with each other, which means that weall react to one another. This means that we have a nonlinear relationship. This is called exploratory data analysis. Showing complexity canbe inherent between any two relationships. Lorenz weather thoughtcould figure out the weather. It is in the relationships. Thetiniest changes create fluctuations that they couldn't predict.

One $ help us fix parts of cell so that we have constants. What ever number I input over here then that will effect the whole chart.
Access is a complex database and it is frequently what is out there.
They can get this in microsoft works, Claris works, and other formats. File maker pro is another powerful tool. Learn just enough to survive access.
Each row is a different line in the database. Names is a lotof database. This is called a record. These columns are fields. 12 columns so they are twelve fields. 130 records because it tells youat the bottom. Which food per serving has the most calories or the least,biggest, whitest. These are superlative. This means sort. If you hear one of these you know to sort. z to a to get the most.a to z to get the least.
This teaches the student to analyze data. range of numbers have extremes. Highest lowest biggest and smallest. Mean, median and mode. Mean is average. Median is the middle number. take the number isthe middle on either side and divide by two. If you number is even. If odd set just go to the middle number is.
Mode the one that appears most often. Scroll up and down and see which occurs most often and count it. The mode for carbohydrate is zero.

Univariate analysis taking any column of numbers figure out the highest the lowest and the middle.
Bivariate analysis taking two columns.
Multivariate analysis taking multiple columns.
All have a way to sort. This important to teachers. Can not write a question unless you have sorted yet. In order to write the three questions you have to think about the column in your question.
Boolean Logic- and, or, if
The logic says both conditions have to be true. and
The logic say either or gets you more.
All articles on cancer but not breasts. So not can be used we are going to concentrate on and or or

The main reason we organize is to have a greater ability to use what we have. If you just have a pile of boxes, andall those boxes have things in them and you run out of paper where do youfind paper. If there is not some order the hard way of finding thepaper would be to look through each box until you have paper. Thiswould be very time consuming. I think at some point in history werealized after maybe going through boxes and boxes of things to find maybeone thing that it would be easier. The same would be true for a classroombecause time is a major element in every school and every second countsthen being organized has to play a large roll in order to maximize studentlearning time. The students won't be learning if they are spendingall there time fumbling through an exercise without a purpose or a direction. Organization provides the direction so that students have the ability togo in a straight direction and make it to their destination efficiently and with learning in hand. I think when the pieces of paper becomelike the boxes in my previous example there is no choice but go electronicbecause otherwise all the information you have becomes antiquated becauseit can not be used.

Organizing, Social Studies and Databases. A computers in Education chapter

Remembering that effective organization in our four stage model looks like looking and or brainstorming about information. Number two evoking composing which means we are responding to a problem. This can be carried out through the process of outline which is an important part of the social studies curriculum.
"Why do we organize? What role does organizing play in problem processing and teaching and learning? When do you stop working with pieces of paper and use electronic databases? "
Databases do not have to be limited to text they can also hold different types of media, including images, audio clips and video clips.
Eric database is a great database that teachers have for their use. So know searching a school library is an important part of databases. This uses Boolean logic of And, Or, and Not.
The other purposes are for higher order thinking skills and analysis and comparison.
There is also the encyclopedia of world problems and human potential which is an effort to address world problems.
Bibliography
http://www.ceap.wcu/houghton/EDELCompEduc/Ch5/Ch5Overview.html

I think one of the most powerful questions that they asked in this article is "How can we preserve our fundamental values and beliefs in the midst of technological change?" I think we have already addressed this in class some, because in other readings we have talked about how computers do not have values we do. As long as we remember who the source of value and perceptions are, and we do not rely to heavily on technology as a crutch then I feel our values and beliefs will not get washed away. If a value is real I feel it is ingrained in your life. A person is a live living being, and eventually even the most innovative toys loose interest because I think there is a core part of us that values human contact more than we value technology. I love technology and feel it is a very valuable part of our lives, I feel the safe guard we have is when we put humans before machines and realize that contact makes more sense.
I like boy scouts, and I can see how boy scouts takes some of the stress off the schools to instill some of these main ideas presentedin this summary. I feel that just being involved in an organizationdespite the learning your kids go through that you also go through changesand evolution. I therefore don't believe citizenship will work successfullyin the school without the parents involvement, because I think there isa bigger picture here. I feel as the child and parent evolve togetherit makes us more of a citizen. I am not sure that boy scouts is theanswer either. I have just learned from boy scouts and being involvedin my son that I am more connected through that experience with my sonthen the school system. It wasn't until I volunteered in my sonsclass that I understood and was able to feel that connection with him. I think if only once to volunteer it is worth it because you have a bond. I think in order for citizenship to become real than a bond has to be real. Therefore how do we create that feeling in our students when we don't haveit in our homes in America.

Executive Summary of the Curriculum Standards for Social Studies

   Civic participation can be thought of as being informed and voting, but it also can be seen in other ways. An active citizencould be interpreted as people who help our nation by setting up voterregistration like Fannie Lou Hamer. Ken Burns created a PBS serieson the Civil War. When high school students made an environmental choice from styrofoam to paper. Being a senator is an active citizenbecause you participate, speak with community, listen to constituents,or other political work. Ideal for student is to have core knowledge,higher order thinking academically, and to participate as informed citizens.
The definition of current social studies is studying socialsciences and humanities in an attempt to promote competence civicly. This can include many disciplines examples are: anthropology, archaeology,economics, geography, history, law, philosophy, political science, psychology,religion, and sociology, humanities, mathematics, and natural sciences. The main desire is to make educated people involved in civic affairs.
The main thing is that everyone from policy makers to citizens want to know what students should be taught, how they will be taught, and how student achievement will be evaluated. Educate America Act, this excluded social studies so the NCSS made social studies annexed to set up standards. Don Schneider of University of Georgia. In 1994 the standards were published.
The purpose of these standards are to address overallcurriculum design and comprehensive student performance expectations whileindividual stuff is more content detail. They want to first use theoverall and get that established and then use the specific course design. Success comes from a good combination of design of the social studiescurriculum, expertise of curriculum planner and teachers, school site facilities,and instructional resources, and the abilities of students, teachers andprogram planners.
The purpose of this book is to do the following things: 1. Serve as framework for Social studies program k-12. 2. guide for curriculum decisions by providing student expectations as far as knowledge, process and attitude. 3. examples of classroom activities that will help teachers in instruction design and help students meet performance. There are ten themes Culture; Time, Continuity and change; people, places and environments; Individual development and identity; Individuals groups and institutions; Power, Authority, and governance; Production, distribution, and consumption; Science, technology, and society; Global connections; Civic Ideals and Practices.
Culture: one example of this would be "How do belief systems, such as religion or political ideals, influence other parts of culture?" This typically covers the sub categories of geography, history, sociology, anthropology, and multicultural topics.
   Time, continuity and change: students are looking for historical roots and locating them in time. one example of a question might be "How am I connected to those in the past? How has the world changed and how might it change in culture?" The focus is history and historical knowledge and habits.
   People, places and environments: studying people, places and human environment students create spatial views and geographic perspectives of the world. Sample question "What implications do these changes have for people?" Theme is areas of study and geography.
    Individuals, groups, and institutions this could fall in categories like school, churches, families, government agencies, and the courts and the role they play in people's lives. How are they formed, what controls them, how do they influence others, and how are they continued or changed. Sample question is "How am I influenced by institutions?" Theme deals with sociology, anthropology, psychology, political science, and history.
Power, authority and governance are when student study the development and evolving functions in the US society and other parts of world Sample question is "How are governments created, structured, maintainedand changed?" The theme is government, politics, political science,history, law, and other social sciences.
   Production, distribution, and consumption discusses how peoples wants out way resources. Sample question is "What is the most effective allocation of the factors of production (land, labor, capital, and management)? Theme is economic concepts and issues.
Science, technology and society which engulfs our modern life. Sample question "How can we preserve our fundamental values and beliefs in the midst of technological change?" Theme focus is natural and physical science, social sciences, humanities, history, geography, economics, civics, and government.
Global connections stresses our interdependence with each other in a world society and the frequent tensions, national interests and global priorities. International issues can be health care, environment, human rights, economic competition, interdependence, and ethics, political and military alliances. The theme is geography, culture, economics, natural, physical sciences, and humanities.
   Civic ideals and practices deals with the civic ideals and practices of citizenship. Sample question "How has the meaning of citizenship evolved.?" The theme is history, political science, cultural anthropology, global studies, law related education, and humanities.

Early Grades the main focus is study of culture and cultural diversity. This will lead to the learner comparing groups, societies, cultures, human needs, and finally concerns. A sense of multicultural perspectives and different viewpoints. A sense of language, story, folk tales, music, and art serve to represent culture and influence behavior. What is cultural unity and diversity within and across groups.
Middle Grades culture and they have standard of performance expectations. They study culture and cultural diversity and make comparisons about groups, societies, cultures human needs, and concerns, A sense of multicultural perspectives and references. A sense of language, literature, the arts, architecture, other artifacts, traditions, beliefs, values and behaviors develop and transmit culture. Different groups respond differently to physical and social based on assumptions, values, and beliefs. Know the implications of cultural diversity and cohesion.
High school level with theme of culture they study culture and cultural diversity. Analysis of groups, societies, and cultures,human needs and concerns. Make predictions about data and experienceswill be interpreted from a multicultural perspective. Understanda culture as a whole and their language, literature, arts, traditions,beliefs, values and behavior patterns. Value cultural diversity and cohesion. Inferences on patterns of behavior with values and attitudes which influencethem. Be able to judge cultural responses to human issues. apply ideas, theories, modes of inquiry from anthropology and sociology.

Bibliography
http://www.socialstudies.org/standards/exec.html

Social Studies and the LEAP Processing Model

According to the chart of the integrating social studies into the technology problem process. In the look phase this can be translated in social studies to make choices, discover alternatives, seeing personal patterns. In the look process local actions would be found in databases, word processing, outlining, drawing, painting, video, audio, animation, virtual reality, calculators, spreadsheets, programming languages. This in the look stage looks like find, read, cut, copy, paste, renumber, outline and organize. In global technology or networks of computers this looks like online database searches, knowing an online contact and reference system.
In the evoke model of social studies this looks like considering feelings and creating systems like an economic process. In local actions this could translate to type or record. Global tools are computer conferencing, net news, listservs, collaborative screen use of any program, collaborative writing, talk, chat, and email according to the chart.
In the assess model of social studies this looks like weighing consequences, public sharing. In local actions this looks like check, lookup, read and listen. In global tools this could be email, groupware, net phone, video conferencing, CU-SeeMe, private networks according to the chart.
In publish and perform in social studies is act on values. In local actions it is the table of contents, index, format, or print. In global tools this looks like net tools, ftp, audio, video streaming,world wide web, virtual reality, wireless palmtops, and PDA's, legacy systemsinclude tv, radio, stations, and publishing houses.
Bibliography
EDELCompEduc/Ch5/socialstudiesLEAPtable.html

The Eric Database

This is a database that provides users an extensive body of education literature on a national information. The database hasone million abstracts which are filled with education documents and journalarticles. Access available through internet. An ED number oreric document can be found in 900 libraries or can be purchased. Copies of journals are in the library periodical collections or can befound in interlibrary loan. An eric digest is a two page researchsynthesis, and there are about 2200 of them. The three eric components are eric clearinghouses, eric adjunct clearinghouses, and eric supportcomponents. An eric clearinghouse collect, abstract, and index educationmaterials for the database, they respond to requests for information, andproduce special publications on research programs and practices. IN the adjunct eric clearinghouse is associated with the clearinghouse. It does some or all of these functions identifying and acquiring literaturefor the database, providing reference and referral services, providingtechnical assistance, and maintaining web sites and producing publications. They deal with the funding from sponsors outside eric system. Ericsupport components produce, publish, disseminate the ERIC system wide productsand services.

Bibliography
http://www,accesseric.org/faq/faq.html

I think it is interesting how much of what is going on in the world probably gets tuned out for one reason or another. I find myself that on some level of sanity there has to be a time to tune out the reality of some of the harsher aspects of the world. I also find that I must have compassion for this side. I think that is part of the balance as a teacher because if you let in to much of the harshness of the world, a teacher gets burned out quickly and is not successful. I feel like there has to be a separation for emotional health, but at the same time to express love for students and be there for them means to be a force for their development. I think for me being sensitive and loving is important and yet it also leaves a lot of space to be hurt by the students I am trying to help.

Encyclopedia of World Problems and Human Potential

It is a result of work done since 1972 to collect and present information on problems that are universally confronted. This clarifies the challenges as they relate to concepts, values and development. They like tofocus not just on average problems but the vicious cycles of problems. If we can identify break down the whole cycle then there is a chance tochange it. The first volume has 12,000 world problems with 320 overlapsand hierarchies in 1200 pages. They are linked by 120,000 relationships of 7 types. Solutions must be complex and encompass the factions,conflicts, and rival world views which keep from resolution. The categoriesare 1. Basic universal problems, 2. cross-sectoral problems, 3. detailedproblems, 4. emanations of other problems, 5. exceptional problems, 6. very specific problems, 7.problems under consideration for inclusion. In volume 2 Human potential: Transformation and value it is dividedinto five sections 1. human development, 2. Integrative concepts,3. metaphors and patterns, 4. transformative approaches, 5. human values and wisdom. It is a comprehensive description of approachesto human development. Some times those with the intention of alleviating suffering create it. Volume 3 contains 15000 international strategiesand action plans. This is cross referenced with volume . Theseare grouped in basic general strategies, cross-sectoral strategies, detailedstrategies, emanations of other strategies, exceptional fuzzy strategies,strategy polarities, very specific strategies, insufficiently cross referencedstrategies, uncross referenced strategies. The volume lists 836 viciousproblem loops.
Scope and challenge= the main concern is ways to navigate through complex information so that the imagination can find results and responses. The purpose is to be honest about the world both positively and negatively. Volume one focus is world problems, volume two indicates the ways in which responses can be worked on. There is a drive to cross reference in two ways logical relationship between entries in a section and the functional relationship between entries in a section, and finally vicious problem cycles and sustainable strategic loops.
Bibliography:
http://www.uia.org/uiapubs/pubency.htm

Union of International Associations

There are nine databases on this page that can be clicked. Organization bibliography, International organizations, biography who's who, human development, world problems issues, human values, bibliographic sources, strategies actions, International meetings all of these can be clicked on and accessed. Some require a subscription for browsing purposes other wise you can direct browse them.
Bibliography
http://www.uia.org/data.htm

I did the beginning and intermediate access tutorials and watched the movies on creating a database.

Databases

The most common information management tool can range frompaper to computer. Any form completed is part of a database. Each entry is a field or category. Herman Hollerith 1890 had a punch card system for census. The faster system helped us by allowing us toanalyze data. We have a browser 1790-1970 with census data from thepast. Through the IBM's web enabled Patent server 26 years of patentinformation can be accessed with 23 years of images. The crop web site has people and organizations at the peak and then as you go down you getto collections of information.
The basic types of databases are flat file which works with one set of database records at a time. Relational which interconnects different sets of database records and allows for searching and linking between data bases.
Mail merge is a database feature. In this you can take database information and insert in a word file. In the web aspect of this it can be searched on the web information. Helpful to have technical support so look for one with a 800 number.
In a 3 field database of contact information you go to file then new database. You add 3 fields contact information, first name, last name, and telephone number. Then you hit return or create. Then add basic data press return key. New record and edit. New record and continue and so forth.
To add a new records to database go to layout and define fields. Put in 1st quarter grade hit create or return click done and add data.
To change layouts you click on layout and reposition the borders. Here you move objects with an arrow and click and drag. Then browse each record.
To do the mail merge and create form letters go to a word processorand new. Then insert basic information. Then go to mail mergeand my class database and here double click. Pick info needed for letter. Basic format of letter is This letter reports first grade for this quarter. This grade is ____.
To add personalized information put 1st Quarter comment create and then done. Here change layout to a bigger box and browse layout before entering information. So that you can see better put a 2 point border around it. Now you can go to browse.
To print go to file mail merge and drag print merge print to get document.
Bibliography:
EDELCompEduc/Themes/databases/databases.html

1. One way to solve this first question would be to goto edit and click find and count. The other way is to sort ascendingand sees if you can copy and paste into a spreadsheet, which would counthow, many there are. I tried to advance sort but have not worked thekinks out yet. The other way is if you do an advanced filter on eachcolumn country name and capital and add the three totals together. This is 23 countries plus 8 names plus 2, and then the total number is again33.
2. The frozen beans have 1.9 listed for iron. I would say the frozen is better for you because it has half the sodium of the canned. It also has less fat than the canned. Although the canned has more calcium, iron, and has fewer calories. I think the harmful effects of the sodium would make me choose frozen plus with frozen you are getting more protein, more A, more thiamin and more C.
3. The United states District of Columbia Washington. It has an area of 68.
4. I got two cities in the answer: Country Name Capital, a. Australia Australian Capital Canberra or b. Australia Northern Territory Darwin.
5. Changed the name under design view, and changed text to number. I changed text to number and then changed to zero decimal places. I then saved it. I then went to advance filter sort and entered a >8 under moons and <5000 under days and it came up with Jupiter, 17 moons, 4332.1 days.
6. I put in the criteria which food with at least 37 units of protein hasthe most calories? I put in an advanced filter search Calories andthen in sort descending. I then put in the second field box proteinwith >= to 37 in the criteria box. I then pushed filter and it cameup with two beef dried chip, and turkey breast, and since it was in descending order you could tell the beef dried chip had the most protein.
7. There would be 13 states and territories on this map. Of the states you can use texas has the greatest territory. If you were asking out of the states and territories then it would be Canada’s north west territories.
8. Saturn and uranus will be included with saturn having phosphine.

Sample Classroom Questions

1. "Use the States and Territories database: In how many different fields (contexts) is the term New used? Which search command did you use to search thru all fields?'
2. "Use the Foods database: What is the number of units of iron in frozen lima beans? Which is more nutritional, frozen or canned lima beans? Defend your answer with data."
3. "Use the States and Territories database: Which state or territory has the smallest area?"
4. "Use the States and Territories database: What state or territory has a January temperature greater than 32 degrees, a july temperature less than 80 degrees and was established after 1911?"
5. "Use the Planets database: What planet has more than eight moons and takes less than 5000 days to make a complete circle around the sun? Use database terms to describe the steps used to find your answer."
6. "Use the Foods database: Which food with at least XXX units of YYY, has the most ZZZZ? Fill in your own data and complete the question. Use database terms to describe the steps you took to find your answer once you had the search data in place."
7. " Use the States and Territories database: Your class wants to make a map that includes only states and territories created before 1870 or those states that have a July temperature higher than 80 degrees. How many states or territories would be on this map? Of the states you can use, which one has the greatest territory?"
8. "Use the Planets database: The winning team must make a model that has at least 9 moons, and a gravity at the surface of greater than 1.00 and the length of year greater than 10,000. What planet(s) will be included? Which of these planets has phosphine?"

Bibliography
EDELCompEduc/Themes/databases/databases.html

A print database means that there is a lot of energy in sorting for information where with the computer you can do electronic sorts which are faster and more efficient.

NC teacher technology competencies: section 5-databases

5.1 "Use information from an existing database."- yes I can
5.2 "Sort a database by specific fields add and delete records."- Yes I can
5.3 "Create a database with multiple fields and records."-Yes I can
5.4 "Create custom layouts including columnar reports." Yes I can except for creating a database report with calculated summaries.
5.5 "insert database fields into a word processing document." Yes I can
5.6 "Terms such as database, field, record, layout, sort/arrange, search/ select/ filter, mail merge"
Database- is a collection of information that is stored on paper or in a computer. This information can range from names and addresses, business contacts, customers and sales prospects, employee and personnel information, inventory, invoices, payments and bookkeeping, libraries and collections, schedules, reservations and projects.
Field- is the box that each piece of information is stored in.
Record- is a list of fields of information about one thing. Could be seen as a row on a spreadsheet.
Layout- is the appearance of how information is presented. You change the layout when you want information to be presented differently.
Sort/arrange is when you take information and arrange it in ascending order smallest to biggest or alphabetical or descending which is largest to smallest or reverse alphabetical.
Search/select/filter is when you set up criteria for the information to be presented. Like only show those selections that were born in 1980. This is an example of a filter. You can use and or or in a filter.
Mail merge is where you take information from a database and input it into a word document.
Bibliography
EDELCompEduc/NCtechCompetencies/competencies.html

. In the counties database, which county had a population of at least 110,000 people in 1990 with less than 200 square miles?
The answer is New Hanover.
2. In the Europe database how many countries import chemicals and fish? What are there names? Out of those countries which country also imports livestock?
The answer is 3, Iceland, Norway and the Ukraine. The last country the one with livestock is Iceland.
3. In the Africa database, what city has the highest life expectancy with at least 35,000,000 people in its population?
The answer is South Africa.

First Database assignment

Make up three questions and link to edel on web site.

http://www.ceap.wcu.edu/houghton/EDELCompEduc/Ch5/DB1assign.html

I think from my own teaching experiencing having the rules is not enough. It takes time and skill to execute a good discipline plan, and I feel like even though I did not succeed in this my first six months of teaching I will keep trying in the future.

The First Days of School
by Harry K. Wong and Rosemary T Wong
Pages 141-149
The effective teacher
1. "Knows what results should be recorded."
2. "Designs or modifies a grade record book to record these results."
3. "Keeps a running progress of student work."
The three things must be taught early in school are discipline, procedures, and routines. Make sure you have a hard copy of the plan. "The most successful classes are those in which the teacher has a clear idea of what is expected from the students and the students have a clear idea of what the teacher expects from them." All discipline plans need rules, consequences, and rewards. The rule helps students choose well when they are deciding on a behavior, this will either prevent or encourage. General rules have a wider range and cover more behaviors. One example is respect others. On the other hands specific rules clearly cover one act an example is listen to instructions the first time given. On page 146 are sample rules that can be used in classroom. Discipline plan is behavior oriented instead of academic. Academic is for procedures. Rules limited to three to five rules. Spend time wisely on why are rules needed, why a particular rule will help students succeed, specific examples of general rules, such as "what does it mean to respect others? Read future chapters for insight on the difference between rules and behaviors.

====

Web author: Danielle Earley |Return to Notebook Online | Return to Home Page.

Hosted by www.Geocities.ws