Classmate Profile Project

Assignment: Classmate Profile Project

Objective:
Students will effectively gather and analyze peer interest data, then demonstrate their proficiency in data visualization by creating accurate and engaging charts using Google Sheets and Canva. Additionally, students will synthesize their findings into a visually compelling and well-organized Canva poster, showcasing their ability to communicate information aesthetically and effectively. This project aims to enhance students' skills in data handling, graphical representation, and digital design, fostering both analytical and creative capabilities.

1- Session 1: Interviews

Students will interview at least 7 classmates to understand their interests and then present their findings using Google Sheets and Canva. 

1.1 Interview Questions:

1. • • 1. 1. What is your favorite food offered at school (school lunch)?

          2. What is your favorite hobby or sport?

          3. What is your favorite movie or TV show? 

          4. How do you manage your time between schoolwork and personal activities?

          5. What is one goal you have for this school year?

1.2 Conduct Interviews & Organize Interview Data:

1. • Pair up and interview each other using the questions above.

   • Be sure to take detailed notes during your interviews to capture all insights.

1. • Click on the Google Sheet below to input and organize the interview data. Make a copy (click File, make a copy) and rename it (by just adding 6-2 or 7-2, or 8-2 at the beginning, followed by your first name). Modify it as needed. Add or remove columns for each question and record the responses for each student interviewed.

2- Sessions 2 & 3: Visual Representations (In Google Sheets & Canva)

2.1 Bar Chart: Create a bar chart (in Google Sheets & in Canva) to show the most popular food items among classmates.

1. • • 1. 1. Title: "Most Popular Food"

          2. X-axis: List of items like Pizza, Baja Fresh, Cheese burger, Lasagna, Chick Fil A, etc.

          3. Y-axis: Number of students who chose each food item as their favorite.

          4. Purpose: This chart will help visualize which food items are favorites among the class.

Steps to Create a Bar Chart in Google Sheets

1. Prepare Your Data:

   • You’ll need a table in Google Sheets with two columns: one for the school subjects and another for the number of students who favor each subject. Here’s an example of how to structure it:

Food Items Number of Students

Pizza 4

Baja Fresh 1

Cheese Burger 3

2. Select Your Data:

   • Click and drag to select the data in your table including the headers.

3. Insert the Bar Chart:

   • Go to the menu, select Insert > Chart. Google Sheets will automatically suggest a chart type based on your data.

   • If it doesn’t automatically choose a bar chart, you can change it manually:

     • In the Chart Editor on the right, click on Setup.

     • Change the Chart type to Bar chart.

4. Customize Your Chart:

   • To set the title and axis labels, use the Chart Editor:

     • Go to Customize > Chart & axis titles.

     • Set the Chart title to "Most Popular Food Itemss".

     • For X-axis title, input "Pizza".

     • For Y-axis title, input "Number of Students".

5. Adjust the Chart as Needed:

   • You can further customize the chart by adjusting colors, font, and axis formatting under the Customize tab to make the chart clear and engaging for your presentation.

2.2 Pie Chart: Design a pie chart (in Google Sheets & in Canva) to illustrate the distribution of different hobbies/sports within the class.

1. • • 1. 5. Title: "Distribution of Hobbies/Sports in Class"

          6. Categories: Different hobbies and/or sports like Reading, Painting, Swimming, etc.

          7. Purpose: This chart will display what percentage of the class engages in various hobbies/sports, revealing common interests.

3- Session 4: Design a Classmate Profile Poster in Canva

Components of Your Poster:

3.1 Charts: Include the bar chart for food items that you created in Google Sheets, and the pie chart for hobbies/sports that you created in Canva.

3.2 Visual Representation for Favorite Movies/TV Shows: Create an appealing visual representation for favorite movies/TV shows. You can either group them in one place or scatter them on the poster. Be creative.

3.3 Quotes and Facts: Highlight interesting quotes from the interviews or notable facts, such as "75% of students use a daily planner."

3.4 Design Elements: Use school colors, images related to foods, hobbies, and movies/TV shows; ensure all text is easy to read. Make sure all sub-titles are consistent in terms of font, font size, and color to ensure a cohesive and professional appearance.

3.5 Layout: Arrange everything in a logical order, starting with a catchy title, followed by your charts, and ending with quotes and insights.

Sample Posters:

4- Session 5: Evaluate a classmate's poster then evaluate your own.

Total Points: ___ / 100

Grading Scale:

90-100 points (A): Exceptional execution. Charts are accurately detailed and creatively presented (using Saint Leo colors), enhancing the overall impact of the poster. The poster is professionally designed, with outstanding integration of visual and textual elements that clearly convey insights.

80-89 points (B): Good execution. Charts are accurate and well-presented, with minor areas for improvement. The poster is effectively designed, showing good use of design principles and fairly integrates all required elements.

70-79 points (C): Satisfactory execution. Charts include essential data but lack some detail or creativity. The poster meets basic design requirements but lacks visual appeal or integration of elements.

60-69 points (D): Needs improvement. Charts are incomplete or contain errors that hinder interpretation. The poster design is basic and lacks cohesion or effective communication of the project’s goals.

Below 60 points (F): Inadequate execution. Charts are poorly constructed or missing, significantly detracting from the poster’s effectiveness. The poster is poorly designed, failing to adequately present the project content or engage the audience.