Lesson Fourteen Title: Music Chart Top Hits




Дата канвертавання27.04.2016
Памер32.27 Kb.
Desktop Publishing
Student Instructions
Online Class - Fall 2003
Ms. Cheryl Darce, Instructor

http://www.stmary.k12.la.us/phs/desktop/desktop_publishing_online_class.htm



Lesson Fourteen Title: Music Chart Top Hits (Microsoft Excel)

You will be researching the music charts Top Hits on the Internet at the following site:



http://www.billboard.com. From this site, you will be gathering information on the top hits from the two major areas. One area will be the Album Charts and the second area will be the Singles. You are to select one category under each of these areas. Example: Country Albums, Pop Singles, etc.

 You are to create to separate worksheets with a chart/graph for each worksheet. One worksheet and chart will be the results of your “Album” search. The second worksheet and chart will be the results of your “Singles” search.

 1. Each worksheet should contain the following column headings:

Position, Artist, Title, Weeks on Chart.

 2.      Include a title for the worksheet and chart that is appropriate for the data.

a. Center the title over the columns of the worksheet and add appropriate             formatting

 3.      You should include the top 10 albums in the album worksheet and chart and the  top 10 singles in the singles worksheet and chart

a.       After completing the worksheet data, you will create a chart for the information. When selecting the data for your chart, use only the Artist or Title and the Weeks on Chart columns.

b.      You can select any chart type and subtype as long as it represents the data in the correct manner.

c.       Be sure that the chart is on a separate sheet.

d.      Format the worksheet and chart appropriately. You may also add graphics to the worksheet.

e.       Both of the Worksheets and Charts must include a footer (your name).

f.        Both Worksheets should be centered horizontally and vertically.

g.       Save and print out both worksheets and charts in color!

Back to Student Instruction Page

Back to Desktop Publishing Home Page

Home    Library    Internet Resources    Calendar     Departments     



Clubs     Sports     Cracker Jacks   Faculty  

Alumni     History     Mission Statement

 

 



Desktop Publishing - OnLine Class Lesson Plans

Lesson Fourteen: Music Chart Top Hits

Curriculum Areas:
        Business
        Math

Grade Levels: 10-12

 Louisiana Framework:


        ELA-5-M6, ELA-5-H6 Interpreting graphic organizers (e.g., charts/graphs) (1, 2,3, 4, 5)
        D-2-H Designing and conducting statistical experiments that involve the collection, representation, and analysis of data in various (1, 2, 3, 4)
        D-7-H Making inferences from data that are organized in charts, tables, and graphs (1, 3, 4)
        B-4-A Select and utilize equipment and technology appropriate for successfully completing various tasks (1, 2, 3)
        B-6-B Select and utilize equipment in decision making and problem solving. (2, 4)
        B-15-E Produce documents using a variety of application software including current word processing, database, spreadsheet, desktop publishing, and presentation graphic programs (2, 3, 4)
        B-16-C Demonstrate proficiency in oral and visual communication skills.(1,4)

 Technology Strategies:


        9-12-E Explain and use advanced terminology, tools, and concepts associated with software applications, telecommunications, and emerging technologies. (1, 3)
        9-12-G Refine knowledge and enhance skills in keyboarding, word processing, desktop publishing, spreadsheets, databases, multimedia, and telecommunications in preparing and presenting classroom projects. (3, 6)
        9-12-J Use appropriate technology to locate, retrieve, organize, analyze, evaluate, and communicate information for problem solving and decision making. (1, 2, 4)

 Learner Objectives:


The student will:
        create and enhance a spreadsheet and bar chart
        record color distribution in a spreadsheet format
        utilize information obtained through hands-on research

Materials:
         Student Instruction Sheet
         Teacher Example
         Rubric

Technology Connection:
        Software: Inspiration, Microsoft Excel, Internet
        Examples of spreadsheets and charts shown on the “Smart Board”
        Computer lab with 25 available computers (one computer per student)

 Lesson Procedures:


A.     Motivation/Introduction:

1.      Today we are going to be talking about a subject that everyone likes, music. We all know that there are many types of music in the world today. What are some of your favorite types of music?

2.      Teacher uses Inspiration to list the various types of music (Example: Country, Soul, Ray, Pop, Rock’n Roll, Classical, Christian, Hard Rock, etc.)

3.      In this new project you will be looking at the top ten albums and singles in a music category.

B.     Lesson Procedure: (At the Comptuer)

1.      Pass out “Music Chart Top Hits” student instruction sheet

2.      Have student open the Internet and go to the following web site: http://www.billboard.com

3.      Explain that the students will use this site to gather the information on the top ten hits from two major areas: albums and singles. The student is then to decide the type of music category to use. Example: Country Albums, Pop Singles, etc.

4.      The students are then to open Excel and create two separate worksheets and charts from the information gathered from each category. One worksheet and chart will show the results of the Album search, while the second worksheet and chart will reflect the results of the Single search.

5.      Each worksheet should contain the following column headings: Position, Artist, Title, and Weeks on Chart.

6.      The students are to include a title for the worksheets and charts that is appropriate for the data collected. The title should be centered over the columns of the worksheet. Add appropriate formatting to enhance the worksheet.

7.      Once the worksheet is completed, the chart should be created. The chart should show either the Artist or Title and the Weeks on Chart. Explain that the chart should represent the data appropriately. Make sure that the chart appears on a separate sheet. Format and enhance the chart as desired.

8.      Both worksheets and charts should include a footer with the student’s name. Both worksheets and charts should be centered horizontally and vertically.

9.      Save and print out both worksheets and charts in color!

10.  An oral presentation could be presented where student explain the information on the charts.

C.     Closure:

 Assessment:
        Rubric
        Final Project

Rubric - Albums



Back to Lesson Plan Page for Lesson 14

Back to Teacher Lesson Plan Page

Back to Desktop Publishing Home Page

Home    Library    Internet Resources    Calendar     Departments     

Clubs     Sports     Cracker Jacks   Faculty  

Alumni     History     Mission Statement    

 

Rubric - Singles





Back to Lesson Plan Page for Lesson 14

Back to Teacher Lesson Plan Page

Back to Desktop Publishing Home Page

Home    Library    Internet Resources    Calendar     Departments     

Clubs     Sports     Cracker Jacks   Faculty  

Alumni     History     Mission Statement    

 

Additional Lesson:  The Music Of Change

The Music of Change

Using the Internet research one particular type of music and create a PowerPoint slide show depicting the history, famous singers/bands/musicians of that particular type of music.

Examples of music: Rap, Country, Rock n’ Roll, Pop, Classical, Christian, Jazz, Blues, Soul, Opera, etc.

 Using a search engine of your choice key in “_________ music history” – this should bring up several site where you can gather your information.

 1.     Your slide show should contain facts, information, and pictures.
 2.     Make sure that the text fits the slides.
 3.     Include some type of background and animation effects to the slide show.
 4.     Your last slide should show what web sites were used!
 5.     Be prepared to give an oral presentation on your findings!

 

Back to Lesson Plan Page for Lesson 14



Back to Teacher Lesson Plan Page

Back to Desktop Publishing Home Page

 

Back to Teacher Lesson Plan Page



Back to Desktop Publishing Home Page

Home    Library    Internet Resources    Calendar     Departments     



Clubs     Sports     Cracker Jacks   Faculty  

Alumni     History     Mission Statement     

 

 



 


База данных защищена авторским правом ©shkola.of.by 2016
звярнуцца да адміністрацыі

    Галоўная старонка