EDTECH 541 – Spreadsheet/Database Project

Spreadsheet/Database Lesson Ideas

Without the measurement and monitoring of progress using spreadsheets and databases, the effectiveness of the work of many instructors and students may never be known. Without these tools, instructors may never know how a revision of their resources could have made a world of difference to a student’s future. Without spreadsheets and databases, instructors are hindered from sharing relevant, effective information to the student. In short, without a spreadsheets and databases in today’s classrooms, a student’s success is ultimately left to chance and perception.

Thus, to keep this from happening in my classroom, I have selected four example lessons on spreadsheets and databases that would be helpful in the area of art in design:

1. What Percentage of the Design Class is Right or Left Handed?

Used as an icebreaker or introductory lesson at the beginning of the year, the following data collection and analysis experiment would be a fun way for students to learn about their fellow classmates. Specifically, this lesson will allow students the chance to not only use their creative skills in graphing out the results from the data collection, but it will also allow each student to incorporate other subjects like math and statistics into design. Furthermore, by utilizing this lesson, I will be able to determine, early on, each student’s artistic preferences, their comprehension of higher-order, critical thinking assignments, and their ability to work together. In short, I believe there are many real-world, applicable uses for this particular lesson.

2. Leonardo da Vinci Activity

By once again utilizing math and geometry and incorporating those subjects into art, students will learn the basic foundational fundamentals of ratio and proportion in art. In fact, this lesson is an excellent way for students to compare and contrast elements in art through one of the most famous painters of our time, Leonardo da Vinci. Specifically, I can see this lesson being used within the first month of class when the students are studying the basics of art through shapes and dimension. In the end, this lesson will provide a great way for student’s to visualize their data by allowing student’s the chance to graph their findings using spreadsheets.

3. Ratio and Proportions: Graphing Candy

After studying the basics of art, the students in my classroom will move on to studying the subject of composition. In short, this lesson will be great way for students to take what they have just learned about and use it. In other words, after the ratio and proportions lesson based on Leonardo da Vinci, the graphing candy exercise will allow students to use their understanding of ratio and proportions to create a composition of different types of candy. Specifically, the students will use Excel to create tables and graphs reflecting the ratio and proportions of the different types of candy. At the end of the lesson, the students will be asked to create a composition based on the ration and proportions found in the assignment.

4. Color Matters

This particular assignment would be used when the class begins their assignment on color. Essentially, this assignment would be used as a way for students to explore the variety of colors present in our modern world. As with earlier assignments, this particular lesson will use collaborative work, social skills, math, and creativity to explore colors through charts, graphs, and spreadsheets. Additionally, students will also be able to compare and contrast information, discover new colors, and demonstrate use of fonts, styles, and sizes. In the end, this lesson will be a tremendous way to kick off the study of color.

Spreadsheet Lesson Plan

Title of Lesson: Paintings of the Twentieth Century

Content Area and Level: Art, Art History & Design – Grades 6-8 & 9-12

Description of Topic: Students will use Excel to create a timeline of the important dates in art history to remember. Specifically, they will graphical chart out the creation of famous paintings from the twentieth century. In short, the history of art is immense and some the earliest painting from the twentieth century are some of the world’s most beloved cultural icons. Thus, if students are interested in art and art history, the first thing they should understand is significant works of art by outlining the artists, their work, their style and the date that make up major events in the world of art.

Goals and Objectives: This particular lesson will provide students with the ability to use Microsoft Excel for creating a graphical timeline through the use of data collection, spreadsheets, and databases. Essentially, Excel will allow students to organize and present chronological information on famous paintings of the twentieth century in an easy to understand format. In fact, the students will learn how to insert graphics in spreadsheet, expand cells to fit the chronological span of an era, and how to rotate text within a cell. In the end, these objectives allow a student to create, edit, personalize, save and print a specific timeline for helpful study aids or professional use.

Expected Outcomes of Complex Concepts: Students are expected to memorize, recall, and label major artists, work, styles, and dates of the twentieth century art movement through the use of databases and spreadsheets. Additionally, students will also be expected to know how to create, edit, personalize, save, and print timelines in Microsoft Excel. Lastly, students will be able to apply their newfound technical knowledge in the creation of future Excel spreadsheets.

Data Sources:

20th Century ArtThe type of data used in this project is categorical data. Categorical data is a statistical data type consisting of categorical variables, used for observed data whose value is one of a nominal category or grouped data.

Row Headings: Title of Work, Artist, Style, and Date

Column Headings: Small picture of each painting

AECT Standards:

1.1 Instructional Systems Design (ISD)
2.3 Computer-Based Technologies
2.4 Integrated Technologies
4.4 Information Management