Actively Motivate Students with Instructor Led Hands-On SAM Projects_ 2015 Cengage Learning Computing Conference Presentation final

Presenter: Victoria Ricciardiello, Salem State University The goal of this session is to help instructors use SAM 2013 projects in such a way that they are able to actively engage and motivate their students while increasing their participation, understanding and retention.

1.0x

Actively Motivate Students with Instructor Led Hands-On SAM Projects_ 2015 Cengage Learning Computing Conference Presentation final

Created 3 years ago

Duration 0:00:00
lesson view count 616
Presenter: Victoria Ricciardiello, Salem State University The goal of this session is to help instructors use SAM 2013 projects in such a way that they are able to actively engage and motivate their students while increasing their participation, understanding and retention.
Select the file type you wish to download
Slide Content
  1. Actively Motivate Students with Instructor Led Hands-On SAM Projects

    Slide 1 - Actively Motivate Students with Instructor Led Hands-On SAM Projects

    • Victoria Ricciardiello, Salem State University
  2. Instructor led hands-on SAM projects

    Slide 2 - Instructor led hands-on SAM projects

    • Drive enthusiasm for the project
    • Explain purpose of the assignment
    • Relate to past, current and future uses
    • Build on what students already know
    • Make the content relevant
    • Simplify and demonstrate any difficult new concepts
    • Students have difficulty with steps involving basic math and logic particularly when working with Excel
    • Present the instruction step as a graphic visualization
    • Students follow along with instructor to complete step
    • 2015 Cengage Learning Computing Conference
    • 2
  3. Benefits to instructor led hand’s-on SAM projects

    Slide 3 - Benefits to instructor led hand’s-on SAM projects

    • Instructor can lead, facilitate, or assist
    • Students understand why, and not just follow steps
    • Students receive immediate feedback
    • Motivational
    • Self-assessment
    • Review errors, correct, and resubmit
    • Helps develop critical thinking skills
    • Instructor can readily select from multiple projects from various textbooks
    • Learn new concepts and apply known concepts in a different way
    • 2015 Cengage Learning Computing Conference
    • 3
  4. Considerations for follow along SAM projects

    Slide 4 - Considerations for follow along SAM projects

    • Instructor must thoroughly know the project
    • Be prepared for that unexpected question
    • Know how to handle an accidental instructor error
    • Have back up plan for possible projector failure
    • Size and difficulty of project and allotted time
    • Can you get through the entire project
    • Should students just follow along for the difficult steps
    • Class size and range of ability
    • Pace of class
    • Attention span
    • 2015 Cengage Learning Computing Conference
    • 4
  5. Pedagogy

    Slide 5 - Pedagogy

    • There are many ideas, and instructional design and learning theories that help support the pedagogy for instructor led hands-on SAM projects
    • 2015 Cengage Learning Computing Conference
    • 5
  6. William Glasser’s famous quote

    Slide 6 - William Glasser’s famous quote

    • William Glasser
    • Psychiatrist and Educational Theorist (1939-2013)
    • 2015 Cengage Learning Computing Conference
    • 6
    • “We learn
    • 10% of what we read
    • 20% of what we hear
    • 30% of what we see and hear
    • 70% of what we discuss
    • 80% of what we experience
    • 95% of what we teach others.”
  7. Bloom’s Taxonomy as revised in 2001

    Slide 7 - Bloom’s Taxonomy as revised in 2001

    • 2015 Cengage Learning Computing Conference
    • 7
    • Hierarchy with each level building on the previous
    • Can this be applied to digital learning?
    • Click to find out.
    • Benjamin Bloom, Educational Psychologist
    •  (February 21, 1913 - September 13, 1999)
    • Creating
    • Evaluating
    • Analyzing
    • Applying
    • Understanding
    • Remembering
  8. Digital age learning (ISTE)

    Slide 8 - Digital age learning (ISTE)

    • 2015 Cengage Learning Computing Conference
    • 8
    • “Simply being able to use technology is no longer enough. Today's students need to be able to use technology to analyze, learn and explore. Digital age skills are vital for preparing students to work, live and contribute to the social and civic fabric of their communities.”
    • International Society for Technology in Education (ISTE)
    • http://www.iste.org/standards/standards-for-students
    • Profile for Technology (ICT) Literate Students Grades 9–12 (Ages 14–18) - ISTE
  9. 2015 Cengage Learning Computing Conference

    Slide 9 - 2015 Cengage Learning Computing Conference

    • 9
    • Uploaded on Jan 3, 2012
    • In a rapidly changing world, today's students will need a whole new set of skills to solve tomorrow's problems. Computational thinking gives them the ability to recognize when and how technology can boost their own critical-thinking, creative and problem-solving skills in order to find innovative solutions to real-world problems. ISTE, CSTA and NSF collaborated on this video.
    • http://youtu.be/VFcUgSYyRPg
    • Computational thinking: A digital age skill for everyone
  10. Explanations and demonstrations for various SAM projects

    Slide 10 - Explanations and demonstrations for various SAM projects

    • The next section provides an overview of some concepts that can be facilitated through demonstration and hands-on instructor led SAM projects. Some will be briefly reviewed and others will be demonstrated
    • 2015 Cengage Learning Computing Conference
    • 10
  11. Introductory Excel Concepts facilitated through hands-on instructor led SAM projects

    Slide 11 - Introductory Excel Concepts facilitated through hands-on instructor led SAM projects

    • IF function
    • VLOOKUP function
    • Goal Seek
    • Payment function
    • Absolute cell references
    • Creating formulas
    • Chart creation
    • 2015 Cengage Learning Computing Conference
    • 11
  12. 2015 Cengage Learning Computing Conference

    Slide 12 - 2015 Cengage Learning Computing Conference

    • 12
    • Working with the Goal Seek function
    • SAM Shelly Cashman Excel 2013, chapters 1-3 capstone project
    • Perform a Goal Seek Analysis to determine the number of bins of Plastic containers/bags (cell B10) needed in January to change the value in cell B13 to 100. (Hint: Cell B10 will be the changing cell.) Keep the results of the Goal Seek Analysis as the new value for cell B10.
    • Step 11 requires using Goal Seek to determine how many plastic containers/bags in cell B10 would be needed in January to increase the total number of bins for January in cell B13 to 100.
    • The next slide shows the worksheet completed through Step 10
  13. 2015 Cengage Learning Computing Conference

    Slide 13 - 2015 Cengage Learning Computing Conference

    • 13
    • Partial spreadsheet is displayed after completing through step 10
    • For step 11 - Need to use Goal Seek to increase the number of plastic containers/bags in January (B10) so that the Total Bins for January (B13) is increased to 100
    • The value for the Total Bins (cell B13) was determined by summing the range B9:B12
    • You tell Goal Seek to increase the value in B13 by changing the value in B10
  14. 2015 Cengage Learning Computing Conference

    Slide 14 - 2015 Cengage Learning Computing Conference

    • 14
    • Goal Seek increased the value in cell B10 from 15 to 40 in order to reach the goal of 100 Total Bins for January in Cell B13
    • Spreadsheet on right displays results of the Goal Seek analysis for step 11
  15. 2015 Cengage Learning Computing Conference

    Slide 15 - 2015 Cengage Learning Computing Conference

    • 15
    • Working with the VLOOKUP function
    • SAM New Perspectives Excel 2013, tutorial 3 project 1A, Step 6
    • Create a formula using the VLOOKUP function in cell C5 of the Employee Timesheet that instructs Excel to go to the Employee List worksheet, lookup the exact Employee Number that corresponds to the value in cell C4 of the Employee Timesheet and enter it in cell C5 of the Employee Timesheet
  16. 2015 Cengage Learning Computing Conference

    Slide 16 - 2015 Cengage Learning Computing Conference

    • 16
    • Use the VLOOKUP function to look up an employee number and enter it in the appropriate cell
    • VLOOKUP will enter dh001 in cell C5
    • SAM New Perspectives Excel 2013, tutorial 3 project 1A, Step 6
  17. 2015 Cengage Learning Computing Conference

    Slide 17 - 2015 Cengage Learning Computing Conference

    • 17
    • Working with the Nested IF function
    • SAM CMPTR Excel 2013, chapter 15 project 1a, step 12
  18. 2015 Cengage Learning Computing Conference

    Slide 18 - 2015 Cengage Learning Computing Conference

    • 18
    • Determine shipping costs associated with an order by using a Nested IF function in cell G32
    • Shipping option selected is in G3
    • Shipping prices in range A7:G10
    • Determine shipping cost in G32
    • G3 = Pick-Up, value is in G8
    • G3 = Priority, value is in G9
    • G3 = Standard, value is in G10
    • G3 = None of the above then enter Select Shipping Option in cell G32
    • SAM CMPTR Excel 2013,
    • chapter 15 project 1a, step 12
  19. 2015 Cengage Learning Computing Conference

    Slide 19 - 2015 Cengage Learning Computing Conference

    • 19
  20. Do not teach ICT skills in a vacuum

    Slide 20 - Do not teach ICT skills in a vacuum

    • The Partnership For 21st Century Skills, depicts information, media, and technology skills as part of an overall schematic
    • ICT and media literacy skills encompass all core subjects and are integrated with learning and innovation skills – 4C’s, and life and career skills
    • Students need to be taught how, why, when, and where they can utilize these skills
    • Administrators need to understand the important role these skills play
    • The belief that students entering college already possess these skills is a myth that educators need to help change if many of the ICT courses are to survive
    • 2015 Cengage Learning Computing Conference
    • 20
  21. 2015 Cengage Learning Computing Conference

    Slide 21 - 2015 Cengage Learning Computing Conference

    • 21
    • http://www.p21.org/our-work/p21-framework
  22. 2015 Cengage Learning Computing Conference

    Slide 22 - 2015 Cengage Learning Computing Conference

    • 22
    • Thank you for attending my presentation
    • Actively Motivate Students with Instructor Led Hands-On SAM Projects
  23. Sources and Resources

    Slide 23 - Sources and Resources

    • SAM resources and projects from Cengage Learning
    • www.cengage.com
    • International Society for Technology in Education (ISTE)
    • http://www.iste.org
    • Partnership for 21st Century Skills
    • http://www.p21.org/
    • Kathy Schrock’s Guide to Everything
    • http://www.schrockguide.net/bloomin-apps.html
    • William Glasser Quotes
    • http://thinkexist.com/quotes/william_glasser/
    • Teaching in the 21st Century, Sonja Delafosse
    • https://www.youtube.com/watch?v=075aWDdZUlM
    • A Taxonomy for Learning, Teaching, and Assessing: A Revision of Bloom’s Taxonomy of Educational Objectives
    • http://www.celt.iastate.edu/teaching-resources/effective- practice/revised-blooms-taxonomy/
    • 2015 Cengage Learning Computing Conference
    • 23