ebook img

ERIC ED405802: North Carolina Computer Skills Curriculum Lesson Plans, 4-8: Databases. PDF

49 Pages·1995·1.7 MB·English
by  ERIC
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview ERIC ED405802: North Carolina Computer Skills Curriculum Lesson Plans, 4-8: Databases.

DOCUMENT RESUME IR 017 833 ED 405 802 North Carolina Computer Skills Curriculum Lesson TITLE Plans, 4-8: Databases. North Carolina State Dept. of Public Instruction, INSTITUTION Raleigh. PUB DATE 95 NOTE 48p. Teaching Guides (For Classroom Use PUB TYPE Guides Teacher) (052) MF01/PCO2 Plus Postage. EDRS PRICE Access to Information; Class Activities; *Computer DESCRIPTORS Literacy; 'Databases; Definitions; Educational Objectives; Elementary Education; Information Technology; Instructional Materials; Instructional Program Divisions; Learning Activities; Lesson Plans; Public Schools; Skills; State Curriculum Guides Computer Use; *North Carolina IDENTIFIERS ABSTRACT This curriculum guide contains computer skills activities for the public schools of North Carolina; these lesson plans are designed specifically for grades 4-8 and focus on information access via databases. The lesson plans for each grade include a list of materials needed, lesson time, teacher preparation activities, outline of computer and non-computer activities, and instructional measure. Communication, computer and information skills objectives addressed by the lesson along with social studies, science or mathematics skills are outlined. (AEF) ********************************************************************** Reproductions supplied by EDRS are the best that can be made from the original document. *********************************************************************** Computer 0.0c kills Databases Curriculum Terms Database U.S. DEPARTMENT OF EDUCATION Off ice of Eaucational Research and Improvement EDUCATIONAL RESOURCES INFORMATION File CENTER (ERIC) This document has been reproduced as Record received from the person or organization originating it. Field/Category Minor changes have been made to improve reproduction quality. Sort/Arrange Select/Search Points of view or opinions stated in this document do not necessarily represent Report official OERI position or policy. "PERMISSION TO REPRODUCE THIS MATERIAL HAS BEEN GRANTED BY E. Brumback TO THE EDUCATIONAL RESOURCES INFORMATION CENTER (ERIC)." 4556 F. 01/2 11+38 ISeSf05-2O 9157334'r62 TMCHNOLOOT FROM +INSTRUCTIONAL TECHNOLOGIlii DIVISION INSTRUCTIONAL NORTH CAROLINA PUBLIC SCHOOLS OF STREET 301 NORTH WILMINGTON 31601.2145 RALEIGH, NC 919. 733 -4762 FAX #; Plans Skills Curriculum Lesson TITLE: NC Computer Compiiter Services Section) Technology (formerly BY: Instructional Carolina North. Public Schools of DATE: 1994-1995 Computer Skills 4 Curriculum ISSUES SKILLS Title: Computers as Accessing Tools: In-school Tour APPLICATION 4 Grade: Competency 1.2: Identify computers as tools for accessing information. Measure 1.2.1: Describe examples of people using computers to access Objectives information in daily We (e.g., teachers looking up grades Addressed by from office computers, bank customers getting informa- This Lesson tion from bank 'machines, students finding books from on- line catalogs, travel agents reserving tickets). Cowannticatios Still s 21 The learner will identify, Materials Needed In-school examples of use of computers to amass information; Mika, or select information sod sketch of school floor plan; pictures of school staff or people in society using comput- ideas. ers. 22 The learner will apply, extend, and expand on information and accepts. Time: One class session. 4.1 The learner will reapood to personal situations and events in selection and to personal Activities situations and evatu. pre-Activities: Saha Studien (Gr. 4) With the School Staff 11.11dentify and describe Tour the school to make a list of uses of computers to access information such as 1. changes which have °coined in the attendance and schedule records by the office staff, budget records by the ways of living m North Carolina. bookkeeper, CD-ROM encyclopedia or media center catalog by students, food 10 Evaluate the effects d inventory or lunch ticket totals by the cafeteria staff, textbook inventory or bus change on the lives d the people route information by a school administrator, or grades by teachers. of North Carolina. Decide on in-school sites to visit on the school field trip. Arrange for the class to 2. tour the sites to see the use of the computers for accessing information. Computer Skala: (Gr. 4) For the sites selected, take pictures of the people at their computers. (Or, locate 3. 1.2 Identify camp" ' as tools for magazine pictures of people in similar situations.) accessing information. Information Skills Activity; 13 The learner will critique Lead the class in a discussion of computers being used in society to access 1. information sources and formats. information. (e.g., travel agents to reserve airline tickets, bank customers to lA The learner will relate ideas determine account information from an automated teller machine, phone clerks of and information to life expert- =ZS. mail order houses such as L.L. Bean to check availability of an item, librarians to determine location of a book.) 1..5 The learner will communicate reading, listening, and viewing Divide the class into groups of 3 or more students. Give each group a sketch of 2. experiences. the school floor plan with major areas labeled. Have the students brainstorm in 21 The lamer will explore their groups to mark with an "X" the places in the school where large amounts of mseardi poems that meet products or information are located. (e.g., principal's office, attendance office, information needs. guidance office, media center, cafeteria, school 2.2 The learner will engage in a store, gym, band room.) march process to meet Either with the entire class or with several 3. inhumation needs. TERMS groups at a time, tow the school to search for sources of large amounts of products or information. Have the students mark their Computer findings on their group's school sketch as Information Accessing follows: circled "X" = site marked during brainstorming which did contain a computer being used for information accessing. =site not marked during brainstorming which did contain a computer being 4 S 4 C o k m i l p l u s t e r C u r I r S i S c U u E l u S m S K I L L S A T C T D D c a a o c o i i t m s e a t o t b s s p l a a l s A e u s s n i P e n t : P : t e s g L r I s C A T G 4 I O N r a d e : I t f a C 1 c i d o c n o a f o c o e o m o m e r . n m s p p 2 s l a s r t e u t s i i i t o t e n f : e n n y . r g c s y D o i f n O M 1 t t d d f r e o a y w i b o r . s t e m s a 2 c j a b p t e a f m r s a a . t i o c i u s 2 b o e n t e r n i e s e : v t s e s w l u A b t t c i o y a a s o d h k c m d o u i c r o p e e a n l e s u y s d s s t u e g t e d r . T L e h s s i o s n M N I c s e o d d a b c p a t x n i e c a u t a s a a e t e d d e t b s m d r e r s a a e e f y i e i s a d p n b n d x e l l l r s t e s t : e ; s w T l i c s o n e e t m w V i e p n C s k o u p n g a n t a l e p m s y r e d c , . r a d o n 2 T i d l w e e . h m n 1 i t m e i l f T T c s l a y e , l s u w s a i n c i i a o n s f o l n e o o n o s s s e l : m l . a e d a i r o c n t , i d e a s . 2 T l w a e e x p h a . t r i 2 e p n e l n e l l r d y , , a u k a A f o c p n n n a t a i m e v d d n i i n o t n i e d s c o n c e p u . 4 T l w r e e t p a r s e . h r o i p - n A 1 l o e e c l r n t i v d i t i e p s i s i : a t e u e n r a v n s t i e o W t M P m n r d n o s t h s a f e e l s i d s t i e o i h n s a p a e a t e l l e n r c o s t i o d o n a i t s m n s v 1 D t o d a t c a h t c a a e l h h n h i t i y e n s a l d a o a n c b m e a p b i o a u f t e e . e d a a l s e v t s n e l e e i e r o s s n n s d t s s . i t o i i d w n d c A a b f h o o t t c h a e n r m y m b i a n l a m a c f e s p e s t t n i u e h o i o s n e n f i y t s y . s a t s N a l c r a b o i h u c a t t c a r n e o o c c l d v c m w e C i o u a n d s s e p l h y n s e u e l l e S S ( 4 s s t d e t o G u r , c d i i ) e a r s l w f . o r e e a c t a h s e t s 1 I a d r . d e s 1 n e c n r . f p t t c a s d i d t 1 b a 2 A t m r i a e b u o h l t f t t o a y h f a r b o e e l c r a o o s s d e s a u k s h r e e c w h o i i . s n i s o t c h a . a c n g h n a u a v i e n r l c r g e e h d e s e l i N C i a v r o w n o r l i i l a t n n h a y . g s 1 E t e d f v h 1 f a e l u . c e a 3 t t s e A c t l dt p i c h h h e v c t a o i e m e n e v p s g i l t e e y o N C e t o p a c c o d o o 1 D c a n m l h r o t l a o n r l e i p a a y l r t s c i f a u n t i i t t c f f t h a i e d p r e o s n . u a n r s . n e i s z s e s e s t d s d N C i t m e t n ( a f h a h x o o a s t c o r a r c i t m o a b i a r a r g l a a o n s e i l t t t s n i s l h t e o h e t s a e n s . ) t d E C S ( 4 x o k G a m i m l l p p ) s r u : l t e . e s r : l o p r s p n A i o 1 a v o m a m c s a e a u u r a 1 I t f e t t s s r r d o r i e c t n / a i m f l i o o v e a a k k c o o d . e m t k . a n n e n e 2 e n s l t p s s r t s s i u , / f , , t y e r o h s a c b o i g t i i n o i e o w g c s f s r r o a v t t p r a l m e r o m e o l e o r m o a a f l n u e r t i u i m o i r n s t l g n n s c p t e s . g s , n , t s e t , y , , y l e s a o o g c u u c e e t r h s ; 2 o N b m p a t s s e o e n s r a t t n a u e h S a a a a p s n c a r C o m f k m t o f h t t u d o . k a r r e e m e i i e c n l r a s s e s s t l I s t , s m , , , s s r k e s 1 T l w c e o r a i i r . h r t i t n i s 3 l q e e ; l r u e 3 i l w m c p T s a n o u h f i l e o i a f o o r a n r o r o s f a c l m o v r o V y n n r i t u e w m a n i a n h r n i . t c a n e a i n e d t e o i e s l s s u c t n r m g l . , , y , t s N a l w c r t o e h o t a n e a I T l w r i c w d v e t d e C o h u a A d a l e e n e l h r i a e n r a l s l l s t . e e e , l s r l 2 D t c i p o s P o 2 p o s t t a i e i n n r u u h l t g a f i o x o a a d f d v n a - r r v m p e o t e e i o a i n s i f i n e f f d d e 3 t o . d i u t o r t s r r s e n s e p . i s s - s e w T l f t A t E p n t h i a r c h n a p s e r e o e e n s r t o s V w t . e i o c m i s m e g k k d p u n r a l l a p a g y e m r r . 1 T w c o l h s A t f h f t s a t m e e m e o h a . i t h h l h i y g p a m l e r s f e u 5 i a r l r c n c r e a o v c t l t e t e n o s o g k t e e e e e r s e r e d d u t a r d . u m p s l a v , i e s i n e t e e h c h h i t s w d n d s e i i o h e i t n ac a n o a u n n o g g l r u d g v m , , c p w e e l h p n e e d u e t . s x t d p e e r r i e n e p o s s i o c t 3 H t t e e u a s e w . d l a m a c e e f f n v o c h i t . s s t e r 2 T l w e e x a p h . r i n l 1 l i f e d i n o e e t i l x f r s r r o c a e o r h n u m m s a m s t e p i e r t o e d m m h n l s e e e e a s a n r e c s t t h e w w l w s c t i t a a o h h l k i n c i n u a i T c f e t o o c e r l e e h e s m E s d h d a s s t R s i y o . n M t w t p S I h h n h c t r o e s r m i 2 T k w i t o m r e t a a p u e e a n r h u . s c i n m t 2 g t l e e e a r l a . g e iI ' k t r w t c u ac e n o t m o s f I a p m e o s o a o a e r n r o p n w e e c c u h t t e t e s D s r a i n n t f o e o i c a t f a e o n r b h e m i a a o t a u n d a d n t w s r i e s c o e n d . t e f n s d d n h " o x s c e w t I A n t o f h a s c w o m t a r i c c m t e p t e e m a o h h l s t e e i s o n t t n i e n g e t h s e x h l a a e m c e t d p e d l y e . s C t c a t b l 4 h i a h o g n k e l r r l d e o m e y d e c . s u t p e L t c i d o w m h t i a n i x f h s h l o a a c a n e r n a u h i m m v s a a g a s s f e d p t i o i e d o s o l t h n e n s t . w b h i o t i n h f b h o e c o r t n o a m o a l u m e a p i e t n w l i p o f d i n u n u . t g e l r Activity 2: Visit the media center or have the media professional come to the class to share 1. Notes: with the students what databases are available in the school or in the community and which of their database examples might be accessible by a computer. Measure After the discussion of using a computer to access information in North Carolina, have each student select two types of information he would like to learn more about and, then, write a letter to "Whom It Might Concern:" to ask if the information is accessible by computer. Have the student explain in the letter how computer access would be helpful. 7 Computer Skills 4 Curriculum ISSUES SKILLS Introduction to Databases Title: APPLICATION Grade: 4 Describe the difference between a print database and a Competency 2.4: computer database. Objectives Measure 2.4.1: Addressed by After a visit to the media center, list examples of both print This Lesson and computer databases (e.g., dictionary, on-line catalog, print encyclopedia, CD-ROM encyclopedia). C.rmonaudeadoe SkM Materials Needed: Pm-activity: index card per student, student textbooks, other class 2.1 The learner will identify, objects. Activity: dictionary, encyclopedia, newspaper, card catalog; information or collect, or select information sod video on or a working example of an electronic version of a dictionary, CD-ROM ideas. encyclopedia, on-line newspaper, or automated card catalog. 2.2 The lamer will apply, extend, and =pod on informatics and coneepts. Tune: Two class sessions: one for pre-activities, one for activity. 41 The learner will swami to personal situations and even in selections and to personal Activities situations and events. pre-Activities: Social Studies With the Students SUB Goal I: The learner will Discuss the concept of a collection of items: the class is a collection of students, 1. acquire information from a the classroom is a collection of desks and chairs, the class file cabinet or bookcase variety of sources. (Example: is a collection of papers or books, the teacher's gradebook is a collection of database) student names and grades. Skill Goal II: The learner will use information for problem- 2. Have the students make a collection of items by solving. decision-making, and a. each student in one of four groups placing one of their textbooks in a group planning. stack. Have the students discuss the number and type of items in their stack and then compare it to the stacks made by the other groups. Computer Skills: (Cr. 4) b. each student completing an index card with the following information 2.4 Describe the difference name, age, eye color, number of siblings, favorite pizza topping. List the between a print database and a items on the board or overhead. Have the students suggest sub-collections computer databsse. for the siblings and pizza topping categories. Have them raise their hands for the sub-group they have on their index card and record on the board or Informadoe Skills overhead the number of hands for each sub-group. Lead the class in discuss- 13 The learner will critique ing collections within collections (Le., pizza topping collections within the information soirees and formats. class group of information on the cards). 1.4 The lamer will relate ideas Introduce the term database as the name for a collection of items. 3. and information to life experi- ences. With the Media Professional 13 The learner will communicate Review the pre-activities for the students. 1. wading, homing, and viewing expetiences. Identify the examples of print and computer databases available in the media 2. center. Plan to obtain information or videotapes on computer databases of the 2.1 The learner will explore research masses that meet selected print examples of dictionary, encyclope- informs:ice needs. dia, newspaper, and card catalog. Discuss any 2.2 The lamer will engage in a other computer databases available in the media TERMS =earth moms to meet center. idotinstion needs. Discuss the activity to be conducted in the media 3. center to introduce the students to the examples of Database both print and computer databases. Print Database Computer Database Activity: (In the media center with the Media Professional) 1. With an example of a dictionary, encyclopedia, newspaper, and group of card catalog file cards on a table, discuss the concept that each is a collection of items. Have the students compare how these collections differ from the collections they made in pre-activities. Lead the students in recalling the term "database" for these collections. Show the students examples (pictures, videotapes, or actual products) of the 2. computer database for each of these print databases. Discuss how each can be used; demonstrate any actual products available. Example: Ask the students for a topic they would like to look up in the encyclopedia. Have two students find the topic in the print encyclopedia. Use a CD-ROM encyclopedia to look up the same topic. Discuss the difference in the information found. Ask the students what other collections in the media center they think should be 3. made into computer databases. Discuss their ideas and show pictures of or demon- strate any other computer databases available. Measure After the visit to the media center, have the students list examples of both print and computer databases. This could be a list on a paper handout with two columns, a labeling of paper cut-outs of a book and of a computer, or a labeling on a printed handout. For example, on a handout, label with example name the print databases on the spines of a shelf of books and label with example name the computer databases on the screens of computers. Computer Skills 4 Curriculum ISSUES SKILLS Title: Track Meet Activity APPLICATION Grade: 4 Describe the difference between a print database and a Competency 2.4: computer database. Objectives After a demonstration and discussion of print and Measure 2.4.2: Addressed by computer databases, identify the advantages of each. This Lesson Materials Needed Pre-activity: typical class objects. Activity: both a print and cenmannicatloa Sk computer database version of a dictionary, encyclopedia, automated card catalog, or 2.1 The learner will icstify, special topic (Examples: books on dinosaurs and a database on dinosaurs; materials collect, or select intonation and on NC history and a database of NC history). Copies of the Database Track Meet ideas. Activity for each group; Database Track Meet display (bulletin board, poster or felt 2.2 The lemma will apply, emend, board, overhead transparency). and expand on information and conoqxs. Time: One class session. 4.1 The leaner will teapond to personal simaticas and events in selections and to personal Activities aimations and events. pre-Activities: Social Studies With the Students Skill Goal I: The lamer will Discuss the concept of a database as a collection of items and review examples 1. acquire Won:nation from a from the lesson for Measure 2.4.1. (Examples: the class is a collection of variety of sources. (Eaample: students, the classroom is a collection of desks and chairs, the class file cabinet database) or bookcase is a collection of papers or books, the teacher's gradebook is a Skill Goal II: The learner will collection of student names and grades. Items such as a dictionary, encyclope- use information for problem- clia, newspaper, and card catalog can be both print and computer databases.) solving. decision-making, and planning. Initiate a discussion of whether print or computer databases are "better." 2. Direct the discussion to the idea that there are advantages to both types. Computer Skills: (Gr. 4) With the Media Professional 2.4 Describe the difference between a pint database and a Review the pre-activities for the students. 1. computer database. Discuss the activity to be conducted in the media center for the students to 2. explore the advantages of both print and computer databases. batermatioe Sidile Practice the Database Track Meet Activity. 3. 1.3 The learner will aitique information sources and formats. 1.4 The learner will relate ideas (In the media center with the Media Professional) With both a print and a 1. and information to life =pal- computer database format of a collection such as a dictionary, encyclopedia, card catalog or special topic on a table in the media center, review the concept 1..5 The learner will communicate that each is a collection of items. reading. listening. and viewing Show the students bow to look up, in each resource, a topic they select. Have 2. eqperienoes. two students practice finding a second topic in each resource. For example: 2.1 The /tamer will explore Use both a print and a CD-ROM encyclo- research masses that meet infoensetion needs. pedia to look up the topics: snakes, 22 The learner will engage in a Columbus, hurricanes. TERMS vesearch process to meet Ask the students what they think was 'best" 3. information needs. about the print database and about the Database computer database. Discuss their ideas. Introduce the students to the Database 4. Print Database Track Meet Activity: the track meet Computer Database consists of different events in which the winner is the contestant with the most advantages. The contestants are the print database and the computer database

See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.