60 likes | 79 Views
Learn Microsoft Excel 2002 basics with a focus on data list creation and formatting. Understand spreadsheet functions and apply them for practical use. This tutorial covers essential Excel skills for students.
E N D
Mr. Verlin South Philadelphia High School April 12, 2010 Microsoft excel 2002
Preliminaries • Pre-class (10 classwork points): in your notebooks, answer the following questions: • What is a spreadsheet? Reference the word in the dictionary of http://www.dictionary.com. • Name at least 10 possible uses for spreadsheets.
Excel Basics • Log in. • Launch Excel. • Common Interface Controls: • Menus • Toolbars • Spreadsheet basics: • Rows (numbered horizontally) • Columns (lettered vertically) • Addresses (row and column intersections)
Focus Lesson: Data Lists • Data Entry • Basic Formatting • Font changes • Boldfacing • File Basics • Saving • Closing • Opening • Exiting
Focus Lesson: Data Lists • Begin entering the Product IDs, names and prices in the corresponding columns as listed on the practice file handout. When complete, your spreadsheet should look the same as the handout except for the formatting. • When you’ve completed the data entry, save your work.
Exit Ticket: Spreadsheets • In a Word document or in your notebooks, write at least 3 words or phrases explaining a situation in business where you might need to include an Excel document within a Word document.