Business and Information Technology
______________________________________________________________________ Unit Title: Subject: Teachers: Business and Information Technology Using the Excel Database Ms. Ashley Selger and Ms. Amber Weisen
School: Bloomsburg High School ______________________________________________________________________ I. Overview: As technology grows and changes, there is an apparent need for high school students to learn the new skills and tasks that are presented. There are many situations where data is collected. A student may want to calculate his/her grade point average or see where they stand on the baseball team in terms of batting average. Students can get started quickly with Microsoft Excel, a simpler database form, compared to Microsoft Access. II. Topics to be Covered: A. Project 1: Create Template in Excel Database 1. What is Microsoft Excel XP? 2. Excel Databases 3. Excel Basics a) Worksheets b) Workbook 4. Elements of Excel a) Text b) Number c) Dates/Times 5. Excel Database a) Starting Excel 6. The Excel Window a) Title Bar b) Status Bar c) Menu Bar d) Toolbars 7. Create Template in Excel Database 8. Saving a Database 9. Modifying Components
1
10.Deleting Information from a Database 11.Printing a Database using Excel B. Project 2: Entering Data into an Excel Database 1. Excel Database Criteria a) Database Components b) Setting up a Database c) Starting Excel and creating a New Database d) Creating Introductory Database 2. Changing the Title of a Database 3. Changing the Worksheet Label of a Database 4. Editing the Database a) Changing the Column Widths for Inputs 5. Using Tools in a Database 6. Undoing the Last Action on a Database 7. Inserting a Heading in a Database 8. Previewing and Printing a Database 9. Saving a Database 10.Quitting Excel XP III. Student Performance Objectives: After teacher instruction and student hands-on activities: 1. Students will learn the basic Excel XP concepts, including formatting and elements of a database. 2. Students will learn how to create an Excel XP database, enter data, and edit data. 3. Students will also know how to modify database components. 4. Students will learn how to print databases and use Excel Help. 5. Students will learn how to create a new introductory database providing their own original content and inputs. 6. Students will be able to cut, copy, paste; change font and font size; change alignment of columns (width); and preview a database before printing.
2
IV. Student Learning Activities Listening to Introductory Lesson (completion of projects 1 & 2)
Required Resources Excel XP Software Excel XP Instructor’s Manuel Excel XP Data Disk Excel XP Book (15) Floppy Disk Personal Computers Large Sheets of Paper Markers Bulletin Board Large Diagram of Figure 1.1 Laminated Description Cards Velcro Personal computer with Internet Access Demographic Handouts Excel XP Software Activity Checklist
Interactive Learning Activity
Cooperative Learning Activity
V. Student Evaluation: Students will be evaluated on the completion of projects 1 and 2, several small quizzes, that cover the basic elements and toolbars, which can be found in the Student Evaluation section, the cooperative learning activity, and the involvement in the interactive learning center. VI. Resource Materials: Websites: The following website contains a cooperative learning activity concerning budgets and spreadsheets.
http://www.Lessonplanspage.com/CIOMDDevFamilybudgetonspreedsheet812. htm
The following website gives general information about Microsoft Excel.
http://www.microsoft.com
This website provides introductory information about Excel and contains knowledge check quizzes to be completed by the students.
http://www.internet4classrooms.com
3
Book: Perry Greg. (1997). Teach yourself Microsoft office in 24 hours. Indianapolis, Indiana: Sams Publishing.
4