674+Lesson+Plans

674 Lesson Plans

Lesson Plan - 1

Campus: La Crosse || [] ||||  Subject Specific: · Create a variety of different types of charts · Move and size embedded charts · Preview and print charts · Modify existing charts · Format charts · Apply styles to charts A.12.3 Use a computer and productivity software to organize and create information · use an integrated program or applications suite to complete a class assignment · analyze data from a database and present conclusions in a document or report · construct a spreadsheet, enter data into cells, use mathematical functions to manipulate/process data, generate a chart or graph, and interpret the results · use a computer and graphical organizer software to generate modifiable flow charts, project time lines, organizational charts, or calendars
 * Title of Lesson: Creating Charts in Excel ||  Date: 9/12/10 Timeframe of Lesson: 2-4 hrs.  ||
 * Author(s): Peggy Langreck ||  School District: Western Technical College
 * Subject Area(s): Information and Technology Literacy ||  Grade Level(s)/Course: varies  ||
 * State Standards

// Technology Specific ////: // [] Or the info.pdf file in the Lesson Folder. ||
 * Stated Objective(s) Include the focused Instructional Strategy – see chart on page 13. ||||  Focus of this lesson is on Instructional Strategy of Nonlinguistic Representation through Spreadsheet Software.

Students will develop professional looking charts by analyzing the data to be presented in chart format, identify who the intended users of the worksheet will be and their needs. || · Introduce or review toolbars that will be utilized for the lesson. · Using Smart Board to demonstrate creating new charts, how to choose the proper Source data, review chart types, moving and sizing charts, modifying existing charts and applying format to charts. · For each topic, student will perform a hands-on exercise to demonstrate their ability to complete these tasks. · Allow students time at the end of the lesson to complete Concept review questions, skills builder lessons and assessments. || · Students will complete hands on exercises that provide practice with moderate assistance. · Students will complete assessment exercises testing their skills by describing the correct results without providing specific instruction on how to achieve them. ||
 * Procedures for Lesson ||||  · Introduce lesson with explanation of Microsoft Excel spreadsheet program that allows users to organize data, make decisions, graph data, and develop professional looking reports.
 * Assessment or Evaluation ||||  · Students will complete a Concept Review consisting of T/F and multiple choice questions designed to gauge their understanding of concepts related to charts.
 * Enrichment |||| Use PowerPoint presentations to enhance the classroom instruction for the subject area. ||
 * Materials ||||  Smart board, Computers for students/instructor, Projector, Microsoft Excel, Textbook  ||
 * |||| **__ Technology Resources __**** : **// Classroom equipped with Computers //

**__ Other Resources __**** : Labyrinth Brief Office 2007 Series, Microsoft Excel 207 ** || Lesson Plan 2

=
 ** Lesson Plan **====== Campus: La Crosse  || State Standards [] |||| A.8.2 Identify and use common media formats • describe the operating and file management software of a computer (e.g., desktop, file, window, folder, directory, pull-down menu, dialog box) • identify the various organizational patterns used in different kinds of reference books • define the basic types of learning software (e.g., drill and practice, tutorial, simulation) • use electronic encyclopedias, almanacs, indexes, and catalogs to retrieve and select information • describe the various applications of productivity software programs (e.g., word processing, database,  <span style="font-family: 'Times New Roman','serif'; font-size: 9pt;">spreadsheet, presentation, communication, drawing, desktop publishing) <span style="font-family: 'Times New Roman','serif'; font-size: 13pt;">• <span style="font-family: 'Times New Roman','serif'; font-size: 9pt;">identify common integrated software packages or applications suites <span style="font-family: 'Times New Roman','serif'; font-size: 13pt;">• <span style="font-family: 'Times New Roman','serif'; font-size: 9pt;">use a graphics program to create or modify detail to an image or picture <span style="font-family: 'Times New Roman','serif'; font-size: 9pt;"> //  Technology Specific   //// <span style="font-family: 'Times New Roman','serif'; font-size: 9pt;">:  // <span style="font-family: 'Times New Roman','serif';">[]  <span style="color: black; font-family: 'Times New Roman','serif'; font-size: 9pt;"> <span style="color: black; font-family: 'Times New Roman','serif'; font-size: 9pt;">Or the info.pdf file in the Lesson Folder. ||    ||||   Focus of this lesson is on Instructional Strategy of Cue, questions, and advance organizers through Organizing and Brainstorming Software. · Students will develop file management strategies · Explore files and folders · Create, name, copy, move, and delete folders · Name, copy, move, and delete files · Work with compressed files   || |||| ·  Familiarize student with file management concepts. · Discuss the difference between a file, folder, sub folder and a drive. · Share the need for organizing files and folders. · Explain the different ways to navigate the computer – opening drives and folders in the right pane, using the standard buttons toolbar, using the address bar and using the search box. · Define the parts of a file path. · Demonstrate how to create and name folders, move and copy a file or folder, name and rename files and delete files or folders. · Explain a compressed file. · Differentiate between a compressed file and a compressed folder. · Show how to compress a folder with files. ||    ||||  ·  End of the chapter and online activities will be assigned to reinforce the material in the text. · A quiz will be given to help ensure students understand the material for File Management. · In-class activities will be assigned with points given for participation. ||    |||| <span style="color: windowtext; font-family: 'Gourmand','serif'; font-size: 9pt;">Students could research the internet for a variety of file management topics to supplement this learning activity. ||    ||  ** __ Other Resources __ ****  :  ** Text: Zimmerman/Zimmerman, New Perspectives on Microsoft Office Word 2007    ||
 * Title of Lesson: Managing Your Files  ||   Date: 9/16/10 Timeframe of Lesson: 2-4 hrs.   ||
 * Author(s): Peggy Langreck  ||   School District: Western Technical College
 * Subject Area(s): Information and Technology Literacy  ||   Grade Level(s)/Course: varies   ||
 * Stated Objective(s) Include the focused Instructional Strategy – see chart on page 13.
 * Procedures for Lesson
 * Assessment or Evaluation
 * Enrichment
 * Materials  ||||   Smart board, Computers for students/instructor, Projector, Microsoft, Textbook
 * |||| ** __ Technology Resources __ ****  :  **//  Classroom equipped with Computers  //