Book Image

Moodle as a Curriculum and Information Management System

Book Image

Moodle as a Curriculum and Information Management System

Overview of this book

Moodle is the most widely used Learning Management System in the world. Moodle is primarily used as an online learning course platform and few people know how to use it in any other way. However, Moodle can also be used as a management system. By adapting Moodle to become a curriculum and information management system, you can keep your administrative tasks in the same place as your lesson plans by managing student attendance records, recording grades, sharing reports between departments, and much more Moodle as a Curriculum and Information Management System will show you how you can use Moodle to set up an environment that enables you to disseminate information about your educational program, provides a forum for communication amongst all those involved in your institution, and even allows you to control your course registration and enrollment. This book is written on version 1.9 and also includes examples applicable to version 2.0. This book will show you how to create courses and organize them into categories. You will learn to assign teachers to each course, which will greatly help you to manage timetables and student enrolment, which can otherwise be a very frustrating and time consuming task. You will learn how to display the different aspects of your Curriculum and Information Management System to make it easily accessible and navigable for staff and students alike, ensuring that everyone knows what they are doing and where they are meant to be.
Table of Contents (19 chapters)
Moodle as a Curriculum and Information Management System Beginner's Guide
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

Time for action – creating a sample query


The first time you access the Custom SQL queries tool via the Ad-hoc database queries link, you will see a screen that indicates there are No queries available, as shown in the following screenshot:

Once you create one or more SQL queries, the queries will appear in this window. To demonstrate the usefulness of this tool, we will set up a simple sample query. Our query is going to be designed to pull final grades from courses, so we will first need to navigate to one of our courses and enter several grades to ensure that we have data to pull from the database. Follow these steps:

  1. Navigate to the Advanced Listening 1 course on our test site by clicking on the AdvList1 link in the MyCourses block, as shown in the following screenshot:

  2. There are two graded items here, Attendance and Final Exam, from our course template imported from Chapter 4, Incorporating Educational Standards, so we already have some items that can be graded. You could enter attendance...