Lesson #3 Basket of Books
Grade Level: Grade 4
Content Area: Technology and Library Skills
Content Standards Addressed: Understanding the order in library stacks. Introduction to Excel.
Description: Students will know and understand how fiction, nonfiction and everybody are ordered on the library shelves by completing a book ordering worksheet with a group. Afterward the group will take a basket of books with a random number of selections from each category and physically place the books in order. Students will then apply data collected and recorded to create a spreadsheet from the sample of books. A graph made from the spreadsheet will be used to compare and contrast against library collection analysis graph.
Hardware/Software required: Computer lab and Microsoft Excel.
Classroom Materials: Hardcopies of instructions, information and classification sheets, library collection analysis and baskets of book samples.
Relevant Web Sites: N/A
Library Books in a Basket
Use the table on your worksheet, Finding Books on the Library Shelves, to create a spreadsheet with Microsoft Excel. Follow the directions below.
Spreadsheet
1. Turn on your computer and log in under one student’s name and password
2. Go to Start , all programs and click Microsoft Excel.
3. In cell A1 type everybody books. Press tab.
4. In cell B1 type fiction books. Press tab.
5. In cell C1 type nonfiction books. Press tab.
6. In cell D1 type total. Press tab.
Recording the data
1. Count the books for everybody and type the number in A2. Press tab.
2. Count the books for fiction and type the number in B2. Press tab.
3. Count the books for nonfiction and type the number in C2.
4. Highlight cells A2 through D2. Go to the toolbar and click on the Auto Sum symbol. It
looks like this ∑. You should get your total.
Format the Chart
1. Highlight all the cells in your chart.
2. Click format on the tool bar, then cells.
3. Click font tab and change the font size to 14. OK.
4. Repeat step 2. Go to the border tab and add a border. Choose Outline and Inside. OK.
5. Click off chart to remove highlight. Highlight top cells only. Use the paint bucket in
your drawing tool bar to fill with yellow. Highlight bottom cells on and fill with green.
6. Highlight all cells. Go to Format, column, width and change to 15. OK.
Add a Header
1. Go to view Header and Footer.
2. Click on Custom Header.
3. Add your names in the Left Section. Add Excel Project in the Center Section.
Pie Graph
1. Highlight all A, B and C cells again (example A 1 &2, B 1&2 but no D cells).
2. Double click on the chart wizard button. It looks like a bar graph.
3. Click pie in the chart selection. Press Next. Next.
4. Give the graph a title – Types of Books in My Basket. Next.
5. Point the mouse to the circle that says as object in: sheet 1 and click finish.
6. Print
Finding Books on the Library Shelves
Name________________________ Classroom Teacher___________________
Our library has books that help you find new ideas and answers to questions. Most of the time you look to find what’s interesting to checkout and read. Sometimes, you will need to find a book to locate information for a report or presentation your teacher has asked you to give. When that’s the case, you will need to know the following:
The spine of each book is marked in a way that books can be easily arranged and easily found. The library shelves are arranged from left to right, beginning with the top shelf.
A library has two types of books; fiction and nonfiction. Fiction books come from an author’s imagination. Nonfiction books come from science, history or math. They are written from facts.
Fiction books are placed on the shelves in two categories. They are labeled fiction with an “F” on the spine, or Everybody with an “E” on the spine. Each of these categories is also placed in alphabetical order by the author’s last name. The name is on the spine under the letter “F” or “E”.
Nonfiction books are placed in order under the Dewey Decimal system. They are marked with numbers. Those numbers represent special subjects that are kept together. For example, poetry books are considered nonfiction. They are under the numbers beginning with 800. After the number, these books are also placed in alphabetical order by the author’s last name.
When you don’t know what you’re looking for, Insignia can help. Insignia is our library computer program that helps you to search for titles, authors, subjects or keywords. We’ll learn about this later.
Before you go to your task of arranging the basket of books I’ve given you, answer these questions. Show them to me. If you have understood, you may go on.
1. What is a fiction book? ___________________________________________
2. What is a nonfiction book? ________________________________________
3. How are books arranged on the shelves?
_________________________________________________________________________________________________________________________________________________________________________________________________________________________________
4. What is the name of the method for arranging nonfiction books on the library shelves? ____________________________________________________
Great!
Now take your basket of books. Arrange them with Everybody books first (don’t forget ABC order with author’s last name). Continue arranging with fiction books next and nonfiction books last. Don’t worry about the numbers after the decimal point. We will have another lesson later about that. Categorize the books you have in your basket. We will practice making a spread sheet with the data in Media class.
Grade Level: Grade 4
Content Area: Technology and Library Skills
Content Standards Addressed: Understanding the order in library stacks. Introduction to Excel.
Description: Students will know and understand how fiction, nonfiction and everybody are ordered on the library shelves by completing a book ordering worksheet with a group. Afterward the group will take a basket of books with a random number of selections from each category and physically place the books in order. Students will then apply data collected and recorded to create a spreadsheet from the sample of books. A graph made from the spreadsheet will be used to compare and contrast against library collection analysis graph.
Hardware/Software required: Computer lab and Microsoft Excel.
Classroom Materials: Hardcopies of instructions, information and classification sheets, library collection analysis and baskets of book samples.
Relevant Web Sites: N/A
Library Books in a Basket
Use the table on your worksheet, Finding Books on the Library Shelves, to create a spreadsheet with Microsoft Excel. Follow the directions below.
Spreadsheet
1. Turn on your computer and log in under one student’s name and password
2. Go to Start , all programs and click Microsoft Excel.
3. In cell A1 type everybody books. Press tab.
4. In cell B1 type fiction books. Press tab.
5. In cell C1 type nonfiction books. Press tab.
6. In cell D1 type total. Press tab.
Recording the data
1. Count the books for everybody and type the number in A2. Press tab.
2. Count the books for fiction and type the number in B2. Press tab.
3. Count the books for nonfiction and type the number in C2.
4. Highlight cells A2 through D2. Go to the toolbar and click on the Auto Sum symbol. It
looks like this ∑. You should get your total.
Format the Chart
1. Highlight all the cells in your chart.
2. Click format on the tool bar, then cells.
3. Click font tab and change the font size to 14. OK.
4. Repeat step 2. Go to the border tab and add a border. Choose Outline and Inside. OK.
5. Click off chart to remove highlight. Highlight top cells only. Use the paint bucket in
your drawing tool bar to fill with yellow. Highlight bottom cells on and fill with green.
6. Highlight all cells. Go to Format, column, width and change to 15. OK.
Add a Header
1. Go to view Header and Footer.
2. Click on Custom Header.
3. Add your names in the Left Section. Add Excel Project in the Center Section.
Pie Graph
1. Highlight all A, B and C cells again (example A 1 &2, B 1&2 but no D cells).
2. Double click on the chart wizard button. It looks like a bar graph.
3. Click pie in the chart selection. Press Next. Next.
4. Give the graph a title – Types of Books in My Basket. Next.
5. Point the mouse to the circle that says as object in: sheet 1 and click finish.
6. Print
Finding Books on the Library Shelves
Name________________________ Classroom Teacher___________________
Our library has books that help you find new ideas and answers to questions. Most of the time you look to find what’s interesting to checkout and read. Sometimes, you will need to find a book to locate information for a report or presentation your teacher has asked you to give. When that’s the case, you will need to know the following:
The spine of each book is marked in a way that books can be easily arranged and easily found. The library shelves are arranged from left to right, beginning with the top shelf.
A library has two types of books; fiction and nonfiction. Fiction books come from an author’s imagination. Nonfiction books come from science, history or math. They are written from facts.
Fiction books are placed on the shelves in two categories. They are labeled fiction with an “F” on the spine, or Everybody with an “E” on the spine. Each of these categories is also placed in alphabetical order by the author’s last name. The name is on the spine under the letter “F” or “E”.
Nonfiction books are placed in order under the Dewey Decimal system. They are marked with numbers. Those numbers represent special subjects that are kept together. For example, poetry books are considered nonfiction. They are under the numbers beginning with 800. After the number, these books are also placed in alphabetical order by the author’s last name.
When you don’t know what you’re looking for, Insignia can help. Insignia is our library computer program that helps you to search for titles, authors, subjects or keywords. We’ll learn about this later.
Before you go to your task of arranging the basket of books I’ve given you, answer these questions. Show them to me. If you have understood, you may go on.
1. What is a fiction book? ___________________________________________
2. What is a nonfiction book? ________________________________________
3. How are books arranged on the shelves?
_________________________________________________________________________________________________________________________________________________________________________________________________________________________________
4. What is the name of the method for arranging nonfiction books on the library shelves? ____________________________________________________
Great!
Now take your basket of books. Arrange them with Everybody books first (don’t forget ABC order with author’s last name). Continue arranging with fiction books next and nonfiction books last. Don’t worry about the numbers after the decimal point. We will have another lesson later about that. Categorize the books you have in your basket. We will practice making a spread sheet with the data in Media class.