Spreadsheet Application Lesson 1 for Senior High School

Unit 4: Spreadsheet Skills Lesson 1 Familiarizing with Spreadsheet Application Empowerment Technologies Senior High School Applied - Academic What do you think is the use of spreadsheets? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 2 ...

Unit 4: Spreadsheet Skills Lesson 1 Familiarizing with Spreadsheet Application Empowerment Technologies Senior High School Applied - Academic What do you think is the use of spreadsheets? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 2  How do you think a spreadsheet can help you present numbers and figures? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 3  Define basic terms related to Excel. Learning Identify the different parts of Objectives an Excel document. Discuss the different tabs At the end of the found on the ribbon. lesson, you should be able to do the Demonstrate the basics in following: using cells. Perform basic formatting. EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 44 Are you familiar with these mathematical expressions? Do you still use calculators? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 5 Manual Computation essential to daily life, specifically the four basic arithmetic operations used for on-the-spot computation EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 6 How would you compute a certain problem if you cannot even perform the mathematical operations manually? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 77 Budget List 1. Form a group of three and answer the table on the next slide. 2. Gather the data needed to show one’s daily allowance and break it down according to the table on the next slide. 3. Compute your daily total expenses. 4. Compare your data with the data you have gathered from your other groupmates. EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 8 Budget List Student Name Food Transporta Savings Others TOTAL Expenses tion Cost EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 9 Budget List After gathering data and filling out the table on the previous slide, create a simple bar graph to compare your expenses with your classmates’. Make sure to place proper legends to avoid confusion. EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 10 Budget List 1. Who among the three of you has the biggest savings from your daily allowance? Who among you loves to eat and thus has more expenses on food? Who among you has the most miscellaneous expenses? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 11 Budget List 2. How did you compute the daily total expenses for you and your classmates? Was it easy? What if you need to gather and compute the total expenses of twenty (20) of your classmates, would it be easy? Why or why not? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 12 Budget List 3. Do you think the data was easier to understand with a graph? Why or why not? Do you think using Microsoft Excel or Google Sheets to represent data as you did in your activity will make any difference? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 13 What is Microsoft Excel? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 14  Excel is a spreadsheet software used to input and analyze data and is a part of the Microsoft Office Suite. EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 15 What are the basic terms to familiarize yourself with in Excel? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 16 Workbook the term for Excel document Spreadsheet portion (a page) of the workbook EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 17 17  Formulas work like normal arithmetic operations but the equal sign (=) must be entered first before other values EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 18 18 Functions specialized operations with assigned names of actions that use formulas and return values EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 19 Parts of an Excel Document Quick Access Toolbar Ribbon Name Box Formula Bar EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 20  Parts of an Excel Document Column Letter Row Number Sheet Tabs Status Bar EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 21 21 What are the different tabs found in the ribbon of Excel documents? 22  File Tab Home Tab Insert Tab Draw Tab Page Layout Formulas Tab Data Tab Review Tab View Tab EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 23 What are the other spreadsheet options? 24  Add spreadsheet Rearrange spreadsheet Rename, color, move, delete spreadsheet Protect spreadsheet EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 25 Aside from entering data, what can we do with cells in Excel? 26  Select an entire row or column Select a group of cells Insert or delete a row or column Adjust the size of rows and columns EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 27 How can we change the format of the data inside the cells? 28  Basic Formatting Font face, size, alignment, and colors Number formats EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 29 29 Practice 1 Open Microsoft Excel on your computer. Check each tab on your spreadsheet application and find the specified tool on the next slide. Categorize each tool based on the tab where you can find it. Write your answers on the table given on the next slide. EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 30  Print Table Font Size Thesaurus Lasso Save As Look Up & Calculate Selection Get Data Reference Now Insert Bar From Access Translate Page Break Chart Sort Adjust Preview Cell Styles Margins Print Area EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 31  File Tab Home Tab Insert Tab Draw Tab Page Layout Tab Formulas Tab Data Tab Review Tab View Tab EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 32 Practice 2 Give at least five (5) fields in which Spreadsheet is useful. Explain why and how it is useful in those fields. EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 33 Based on the image, answer the following completely in your own words: Which part is referred to by the each number indicated? What is its function? EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 34 Answer the following comprehensively: With your knowledge in adjusting cells and basic formatting, create a simple board game using your chosen spreadsheet application. Some suggestions that you can start with are Chess, BattleShips, or Scrabble. After finalizing your idea, you can start creating your own game. Save a soft copy and present your game in front of the class. EVALUAT ENGAGE EXPLORE EXPLAIN EXTEND 35  Wrap Up A Workbook is the document itself when you open your Excel. A Spreadsheet on the other hand is just one portion of your document. Formulas in Excel works as your normal arithmetic operations but you need to place an equal sign (=) before performing any operation between two or more values. Functions on the other hand are specialized operations with assigned names of actions that use formulas and return a value. 36  Wrap Up As you open an Excel document, you will see the following parts: ○ Cell that contains the input values ○ Quick Access Toolbar that shows ○ Row Number the commonly used tools such as ○ Column Letter Undo, Redo, and Save ○ Name Box that shows the name of ○ Spreadsheet Tab where you can the selected cell which contains a see the different sheets available on column letter and a row number your workbook ○ Formula Bar for the computations ○ Status Bar where you can see the ○ Ribbon which contains tools current status of your document and the view shortcuts 37  Wrap Up The Ribbon contains different Excel Tabs that contain the different tools depending on your needs. The different tabs you can check are File, Home, Insert, Draw, Page Layout, Formulas, Data, and Review. Spreadsheets are important because they contain the information and data. You can add, delete, move, customize, protect, and edit these sheets through Spreadsheet Options. 38  Wrap Up Cells contain the values you have input. There are ways to adjust, select, add, or delete cells based on your needs. Basic formatting allows you to change the look of your data tables. 39 Alexander, Michael. “Working with Excel 2013's Ribbon Menus.” InformIT, June 19, Bibliography 2013. https://www.informit.com/articles/article.aspx?p=2067634 “Excel: Using the Draw Tab.” GCFGlobal.org. Accessed March 30, 2020. https://edu.gcfglobal.org/en/excel/using-the-draw-tab/1/ “Getting Started with Excel 2010.” University of Michigan Library, March 8, 2011. https://guides.lib.umich.edu/ld.php?content_id=11412292 ScholarSpace. “Using Microsoft Excel: Getting Started.” Research Guides. University of Michigan Library, June 17, 2019. https://guides.lib.umich.edu/c.php?g=283162&p=1886441 Writtenhouse, Sandy. “The Beginner's Guide to Microsoft Excel.” MakeUseOf, April 2, 2018. https://www.makeuseof.com/tag/beginners-guide-microsoft- excel/ 40