Download
1 / 8
80 likes | 207 Views
The ASSISTments System. A look behind the scenes. Users of the web site. What do users have? Login names Names Classes Password Problems they did Assignments Certain permissions. Users table. What is this useful for? Login Password Security ???. User Roles.
E N D
The ASSISTments System A look behind the scenes
Users of the web site • What do users have? • Login names • Names • Classes • Password • Problems they did • Assignments • Certain permissions
Users table • What is this useful for? • Login • Password • Security ???
User Roles • Ever not have access to certain areas on a website? • Assistments gives out different roles, like teacher, principal or student. • How do we use these?
Lets do some queries • All the teachers at AMS, their logins and last names select t2.login, t3.last_name, t1.* from user_roles as t1 inner join users as t2 on t1.user_id = t2.id inner join user_details as t3 using(user_id) where location_id = 5307 and type = 'Teacher‘ • Lets get all the students who’s last name begins with a vowel select t3.last_name, t3.first_name, t1.* from user_roles as t1inner join users as t2 on t1.user_id = t2.id inner join user_details as t3 using(user_id) where location_id = 5307 and type = 'Student' and t3.last_name ~*'^[AEIOU]‘ • Select all students who are in one of Mr. Bastien’s classes select t3.login, t4.name as class_name, t5.name as section_name from enrollments as t1 inner join user_roles as t2 on t1.student_id = t2.id inner join users as t3 on t2.user_id = t3.id inner join student_classes as t4 on t4.id = t1.student_class_id inner join student_class_sections as t5 on t1.student_class_section_id = t5.id where t1.student_class_id in (select student_class_id from teacher_classes where teacher_id = 57045) and enrollment_state_id = 1
Rules of exponents • If I ask you what you know about rules of exponents, what will you do? • Where would you find additional information • How would you look it up • Flip through? • Table of context? • Index?
Problem Logs • What if the book had 3 million pages? • How would you look it up? • Big picture, use the table of contents or the index
Item Reports • What are some of the features of item reports? • Send comments to parents • Data driven instruction • View each problem kids do • Did they finish on time • Common wrong answers • Graphing of problem\student average
