Island Culture is the second of 5 units in the Explore Hawaii series that will be covering Desktop Publishing, Spreadsheets, Word Processing, Databases and Multimedia respectively.
The Island Culture Unit will consist of learning spreadsheet terms such as Column, Row and Cell; adding to and formatting Tables and analyzing Tables while creating Charts within Microsoft Excel 2016. The students are challenged to create Tables based off of certain Hawaiian activities and finally create Charts to illustrate each of the Tables they make.
In the first lesson of the Unit, the class will be introduced to basic Spreadsheet terms as they use Copy and Paste actions to complete basic sentences relating to Spreadsheets.
The children will learn the following skills within Microsoft Excel 2016:
- Concept of Spreadsheets
- Cut and Pasting Text
- Inserting WordArt
- Applying Fill Effects to WordArt
- Re-sizing Columns
- Formatting Cells and Text
- The functions of Worksheet Tabs
- Viewing documents
- Header and Footers
- File extensions
Review lesson plan, and ensure the template is available to each student.
- Software: Microsoft Excel 2016
- Lesson Plan: Island Culture Rainbow 2.1 Lesson Plan.docx
- Template: Island Culture Rainbow 2.1 Template.xlsx
- Sample: Island Culture Rainbow 2.1 Sample.xlsx
- Internet Access: http://www.ehow.com/how_7428965_make-timeline-using-microsoft-excel.html
Introduce the lesson to the students. Let them know that for the next seven weeks they will be learning Spreadsheet Skills. Ask any of them if they know what Spreadsheets are and define the term for them. A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns. Rows are typically labeled using numbers (1, 2, 3, etc.), while columns are labeled with letters (A, B, C, etc). Individual row/column locations, such as C3 or B12, are referred to as cells. Each cell can store a unique instance of data. By entering data into a spreadsheet, information can be stored in a more structured way than using plain text The row/column structure also allows the data to be analyzed using formulas and calculations.
For example, each row of a spreadsheet may store information about a person who has an account with a certain company. Each column may store a different aspect of the person's information, such as the first name, last name, address, phone number, favorite food, etc. The spreadsheet program can analyze this data by counting the number of people who live in a certain zip code, listing all the people who's favorite food is fried rice, or performing other calculations. In this way, a spreadsheet is similar to a database.
Tell the students that they will need to remember the following skills from the previous lesson:
- The Font Color Icon
- Cut and Paste
- The Shape Fill drop down
If students are unfamiliar with any of the above, re-introduce to the whole class.
To Cut and Paste introduce the different methods:
- From the Ribbon
- From the Keyboard
- Using the Mouse
- Home > Cut and Home > Paste
- the Ctrl+X and Ctrl+Y shortcuts
- Right Clicking the Cells
To access the Fill Color Icon and the Font Color Icon select Home > Font Grouping from the Ribbon.
To insert WordArt select Insert > WordArt from the Ribbon.
To apply Fill Effects select the Object > Format > Shape Fill > Gradient > More Gradients.