Movie Step #5- Excel Checklist (Complete on Back of Rubric)

Rubric Requirements:

V. Excel Checklist (Complete on paper)     5 Points

            2 Explanations incomplete (do not have numbers/ data in explanations          

            5 Explanations include numbers and data to make conclusions                    

 

Completing the Excel Checklist

1) On the backside of your rubric, you need to use the checklist to double check your Excel spreadsheet. (Make sure to scroll down to #2)

In Excel- Your Excel portion of the grade will be determined by the following. Carefully, go through your Excel document and check each one of as you check your work.

 TAB- 1 Excel Spreadsheet                                                                                      

          __________ 4 statistical columns in the spreadsheet                        

             __________ 1 calculations column in the spreadsheet                                                                                    

TAB 2- Stem & Leaf Plot                                                                            

            __________ Correct data placement in stem and leaf plot

__________ Commas separate numbers on leaf side

__________ Key

__________Title with correct caps & spelling.

TAB 3- Box & Whisker Plot                                                                                   

__________ Print Screen and Paste into Excel   

 __________ Title with correct capitalization and spelling. (No abbreviations)    

TAB 4 and 5- Graphs          

            __________ Have at least 2 graphs in Excel

            __________ Both need chart titles with correct capitalization and spelling.           

__________ Bar graphs need axis titles. Circle graphs need data labels.

__________ Choose appropriate graphs. A line & circle graph can only be used for certain data.

 

 2) Analyzing data is the main purpose of this class. The #1 mistake students make on this project is not being specific enough when analyzing the graphs, stem and leaf and box and whisker. When you answer the following use numbers/data and do not just repeat the titles.

For example: If you have a graph about budgets of movies, then tell about specific movies' budgets. Avatar was the highest on our graph with a budget of $31 billion.  Slum Dog Millionaire was the lowest with $3 billion.

WHAT DOES YOUR EXCEL DATA TELL YOU?

What does your stem and leaf tell you? Be specific. Tell high and low. ___________________________________________________________________________________

__________________________________________________________________________________

What does your box and whisker tell you? Be specific. Tell about median or quartiles. ___________________________________________________________________________________

__________________________________________________________________________________

What does your 1st graph tell you? Be specific. Tell data about particular players or movies. ___________________________________________________________________________________

__________________________________________________________________________________

What does your 2nd graph tell you? Be specific. Tell data about particular players or movies.

___________________________________________________________________________________

__________________________________________________________________________________

WHEN YOU FINISH, BRING THE PAPER TO YOUR TEACHER.

 

 Now, return to the HomePage and go to the next step.