
Subject: Kinematic Analysis 

1. Topic

Kinematic Analysis.
The students will be given the assignment of creating a cam follower
displacement diagram.
The students will use Microsoft Excel to plot a cam follower displacement
diagram from data taken out of a cam system. 


2. Content

Analyzing a given kinematic problem using a cam follower motion
sequence.
The students will provide a list of data taken from an example that
can be used to create a displacement diagram. 


3. Goals: Aims/Outcomes

1. To successfully analyze a kinematic problem that uses a cam follower
motion sequence.
2. To be able to list enough data that can be used to plot a displacement
diagram.
3. To be able to incorporate kinematic equations into the spreadsheet.
4. To successfully create a cam follower displacement diagram. 


4. Objectives

1. Identify that Microsoft Excel can be used as a tool to help plot
a displacement diagram.
2. Students will analyze kinematic data.
3. Students will create a list of displacement data.
4. Students will create a list of displacement data.
5. Students will plot a displacement diagram. 


5. Materials and Aids

1. Students will have a computer.
2. Students will have Microsoft Excel.
3. Students will have the course textbook.
4. Students will have access to the Internet. 


6. Procedures/Methods

A. Introduction
1. First, we will discuss the cam follower motion of the problem.
2. Next, we will list all equations needed to solve the problem.
3. Last, we will list data used to plot the displacement diagram. 


B. Development
1. We will set up the spreadsheet together.
2. I will walk around the class and make sure everyone stays together.
3. I will demonstrate how to format the rows and columns of the spreadsheet.
4. I will demonstrate how to use the spreadsheet data to create a
graph. 


C. Practice
1. Students will fill in all data into the spreadsheet.
2. Students will be encouraged to make their spreadsheet unique graphically.
3. Students will create their own displacement diagram. 


D. Independent Practice
1. Students will be encouraged to add different values and revise
their existing spreadsheets.
2. Students will observe all changes to the spreadsheet and graph. 


E. Accommodations (Differentiated Instruction)
Students will be allowed to work in groups. 


F. Checking for understanding
I will be walking around answering any questions. 


G. Closure
1. After all students are comfortable with their results we will
discuss my spreadsheet on the overhead projector.
2. Students will reflect on what they have learned. 


7. Evaluation

I will provide each student with a rubric at the completion of the
assignment.



8. Teacher Reflection

I will compare all spreadsheets and displacement diagrams against
a master copy and grade each student accordingly. 

