Thinking Spreadsheet

Whether you're a complete beginner or a grizzled veteran, Thinking Spreadsheet will make you an Excel expert. Its clear instruction and carefully-chosen examples will help you * Understand how spreadsheets work, what they do well, and what they don't do well. * Use the spreadsheet's structure to intelligently organize your data. * Solve problems using techniques that take advantage of the spreadsheet's strengths. * Build spreadsheets that are easy to understand and difficult to break. Along the way you'll learn core spreadsheet principles, basic tools like SUM() and IF(), advanced functions like MATCH() and VLOOKUP(), and power-user features like array formulas and pivot tables. You'll also learn a little bit of mathematics, a little bit of probability, a little bit of statistics, and a whole lot about how to intelligently solve problems. You might even laugh a few times!

What is a SENDCO? A voice. An advocate. A messenger (don't shoot!). A calm in the storm. A connection. A friend. A forgiveness seeker, not a permission requester. A shot in the dark. A shot at life. The one who listens. The one who knows. The one who cares.The educational professional who campaigns tirelessly on behalf of the children who need more support than most to navigate a system that, at times, seems purposely set up to make them fail. Relationships are pivotal when working with children with special educational needs (SEN). Trust, honesty and empathy play a vital role in these relationships and is key to these individuals thriving in school and at home. In this book, Ginny Bootman offers a fresh perspective on how SENDCOs can build strong, lasting and effective relationships between those who work with children with additional needs and explores why forming these relationships is so important to help children achieve the best they can and take away positive experiences. Independent Thinking on Being a SENDCOis designed to help you become a compassionate, honest and determined SENDCO, combining your professionalism with empathy, the ability to listen properly and a desire to understand what the lives of others are like and how you can help. It is a book full of tips that will save you time and energy, useful hacks to help you overcome obstacles and bumps in the road, and proven strategies that will benefit your relationships. Suitable for SENDCOs, primary and secondary school teachers and leaders, as well as parents of children with additional needs.

Technological pedagogical content knowledge (TPCK) reflects a new direction in understanding the complex interactions among content, pedagogy, learners and technology that can result in successful integration of multiple technologies in teaching and learning. The purpose of this edited volume is to introduce TPCK as a conceptual framework for grounding research in the area of teachers’ cognitive understanding of the interactions of technology with content, pedagogy and learner conceptions. Accordingly, the contributions will constitute systematic research efforts that use TPCK to develop lines of educational technology research exemplifying current theoretical conceptions of TPCK and methodological and pedagogical approaches of how to develop and assess TPCK.

This book contributes to both mathematical problem solving and the communication of mathematics by students, and the role of personal and home technologies in learning beyond school. It does this by reporting on major results and implications of the Problem@Web project that investigated youngsters’ mathematical problem solving and, in particular, their use of digital technologies in tackling, and communicating the results of their problem solving, in environments beyond school. The book has two focuses: Mathematical problem solving skills and strategies, forms of representing and expressing mathematical thinking, technological-based solutions; and students ́ and teachers ́ perspectives on mathematics learning, especially school compared to beyond-school mathematics.

At present, there is a general consensus on the nature of learning programming, but there are different opinions on what forms an effective environment for it. It is generally recognized that the development of a mental model is a formidable task for the student and that learning programming is a complex activity that depends heavily on metacognitive skills. This book, based on a NATO workshop, presents both pure cognitive models and experimental learning environments, and discusses what characteristics can make a learning model effective, especially in relation to the learning environment (natural or computerized). The papers cover cognitive models related to different aspects of programming, classes of learners, and types of environment, and are organized in three groups: theoretical and empirical studies on understanding programming, environments for learning programming, and learning programming in school environments. Comprehension, design, construction, testing, debugging, and verification are recognized as interdependent skills, which require complicated analysis and may develop independently, and indifferent orders, in novices. This book shows that there is unlikely to be asingle path from novice to expert and that the structure of the final product (the program) may not constrain the process by which it comes into being as much as some would advocate.

This book considers how the fundamental issues relating to the use of information technology in education, are being tackled across the world. Significantly it features international perspectives on the challenge that information and communications technology poses to teacher education; views of trainee teacher experiences with computers; insights into the ways in which communication technologies are being used to link teachers and students; consideration of the impact of change with information and communications technology; discussion of the roles of those involved in developing teacher education with information and communications techology at national, institutional and teacher levels. It contains the selected proceedings of the International Conference on Information technology: Supporting change through teacher education, sponsored by the International Federation for Information Processing, and held at Kiryat Anavim, Israel, in June/July 1996.

The explosion of digital technologies in the 21st century provided access to multiple robust inquiry, communication, and collaboration applications. The enhanced capabilities provide educational opportunities for engaging students in deeper and more thoughtful learning. Implementation of knowledge-building communities in educational experiences, however, requires new pedagogical strategies that are vastly different from the predominant teacher-directed pedagogies of the 20th century. Today’s teachers now must identify, orchestrate, and manage activities in their content areas in ways that successfully support students through activities such as engagement in knowledge-building communities. Blended Online Learning and Instructional Design for TPACK: Emerging Research and Opportunities is an essential research publication that examines the implementation of knowledge-building communities in educational experiences and pedagogical strategies that encourage engagement. Highlighting topics such as active participation, digital technologies, and online learning, this book is geared toward educators, educational designers, researchers, administrators, and academicians.

Stanford mathematician and NPR Math Guy Keith Devlin explains why, fun aside, video games are the ideal medium to teach middle-school math. Aimed primarily at teachers and education researchers, but also of interest to game developers who want to produce videogames for mathematics education, Mathematics Education for a New Era: Video Games as a Medium for Learning describes exactly what is involved in designing and producing successful math educational videogames that foster the innovative mathematical thinking skills necessary for success in a global economy. Read the author's monthly MAA column Devlin's Angle