G5LP6Working With Worksheet

Lesson Plan - 1 Computer Science MS Excel: Working with Worksheet Topics: Cut, Copy, Paste, Autofill, Undo, and Redo Class: Period: Mode: Classroom/Lab Teacher: ____________________________________________________________________________________ Learning Support Assistant: ____________________________________________________________ S.M.A.R.T. Learning Objectives By the end of this session, students will be able to: 1. Use actions like cut, copy and paste in Excel 2016. 2. Automatically enter data using the autofill feature. 3. Create custom lists. 4. Use undo and redo action in MS Excel 2016. Resources 1. video https://www.youtube.com/watch?v=5pIGl_1yl1A&t=2s (0.00 to 5.26) 2. Use the eContent to show the animated demos of the lesson. Session Conduction Engage: Recap the previous chapter. Discuss why we need to copy and paste content. What is the difference between copy and cut actions in MS Word? We can quickly copy and/or cut information in cells and paste them into other cells. These operations save us from having to type and retype the same information. Concept introduction: If we want to move or copy cell attributes and want to place them in another location, then the simplest way to use them is by using copy or cut and paste. Excel moves or copies the entire cell including formulas, values, and formats. Excel has a feature that helps us to automatically enter data. If we are entering a predictable series (e.g., 1, 2, 3…; days of the week; hours of the day) we can use the AutoFill command to automatically extend the sequence. Concept Demo/Explanation: Discuss how they have used the cut copy paste option in MS Word 2016. The Cut, Copy, and Paste buttons are located on the clipboard group of the

Home tab. The advantage of using the clipboard to Copy and Paste commands is that the data can be pasted multiple times. We can copy/cut and paste using mouse drag and drop too. AutoFill in excel can fill a range in a specific direction by using the fill handle. The range is filled with values (numerical, textual, or a mix) which are either copied from the initially selected cell or based on the pattern of the selected cells. The range can be filled downwards, upwards, rightwards, or leftwards. We can create our own custom lists with data as we desire. It is extremely useful when we need to fill in the same data from time to time. Concept Practice: Use previously created worksheets to show the various ways of copying and moving the contents of the cells to a different place. Create some series of dates, or alphabet series from a till z, or a number series from 1 to 10 using the auto-fill option. Show AutoFill options box which displays various options. Create a custom list with some students’ names or city names and save the list. Insert the custom list in a new worksheet. Show how we undo and redo our actions in Excel. The steps for MS Excel 2016 and 2019 are the same. Encourage students to use the shortcut keys for different commands in Excel. Optional Activity: Students can watch the video from the resources section. Practical Application: Complete the activity given under the do-it-yourself and lab activity section of the chapter. Home Assignments 1. Revise the topic covered. 2. Practice the interactive exercises in Edusoft Smart App. 3. Solve any additional exercises on the playground.edusoft.co.in Guided Assignment Students can visit https://www.dummies.com/article/technology/software/microsoft- products/excel/how-to-use-autofill-in-excel-2016-140222/ and discuss their findings with the teacher. Evaluation After completing the lesson solve the exercises given in the book.

Lesson Plan - 2 Computer Science MS Excel: Working with Worksheet Topic: Insert/Delete cells, rows, or columns Class: Period: Mode: Classroom/Lab Teacher: ____________________________________________________________________________________ Learning Support Assistant: ____________________________________________________________ S.M.A.R.T. Learning Objectives By the end of this session, students will be able to: 1. Insert new cells, rows, and columns in a worksheet. 2. Delete existing cells, rows, and columns in a worksheet. 3. Adjust the row height and column width. Resources 3. video https://www.youtube.com/watch?v=5pIGl_1yl1A&t=2s (5.26 onwards) 4. Use the eContent to show the animated demos of the lesson. Session Conduction Engage: Ask students when they create a table in their notebook, can they do any modifications after creating it. For e.g., can they add new rows or columns or delete rows. Excel provides a couple of ways to insert/delete rows and columns, including keyboard shortcuts and Insert commands. Concept introduction: Before we add a new row or column, it's important to understand where Excel positions these insertions, as this affects the row or column, we select to place a new one. For example, a new row always inserts above the row we select. A new column is always inserted to the left of the column we select. When we delete existing columns, the existing data moves to the left. Excel’s grid-like appearance can seem static at times without the possibility to match the needs of the data stored in a worksheet. Excel however has the ability to customize column widths and row heights to match the size of the data in the cells.

Concept Demo/Explanation: Discuss the various ways of inserting/deleting rows, cells, and columns in an excel worksheet. When we insert cells, we have the option to shift the cells down or to the right. When we delete cells, we have the option to shift cells up or to the left. We can adjust the row height and column width in Excel using our mouse. We can enter them manually also. Explain there are limits to how big and small we can make columns and rows in Excel. Columns can have a maximum width of 255. Rows can have a maximum height of 409. Changing the font, the font size, and adding other characteristics to the font such as italics and bolding greatly reduce the maximum number of characters a column can hold. Unlike column widths, Excel automatically adjusts the height of a row to accommodate the height of the text that takes up the most vertical space in each row. Therefore, the AutoFit Row Height feature found on the Format button is not as useful as the AutoFit Column Width feature. Concept Practice: Show the difference between, insert cells, insert sheet columns and insert sheet rows. Show how to insert or delete multiple rows and columns at a time. Increase the font size and ask students to observe whether the rows and columns are automatically trying to fit the content. Change the default row height and column width using mouse and commands from the Ribbon. Ask students to observe what happens when they enter 0 as row height. Also, ask students to find out the default column width and row height. Optional Activity: Students can watch the video from the resources section. Practical Application: Complete the activity given under the do-it-yourself and lab activity section of the chapter. Home Assignments 1. Revise the topic covered. 2. Practice the interactive exercises in Edusoft Smart App. 3. Solve any additional exercises on the playground.edusoft.co.in Guided Assignment Students can visit https://support.microsoft.com/en-us/office/excel-video-training-9bc05390- e94c-46af-a5b3-d7c22f6990bb and https://www.howtogeek.com/270296/how-to-set- row-height-and-column-width-in-excel/ and discuss their findings with the teacher. Evaluation

After completing the lesson solve the exercises given in the book.