PROFESIONALIZACIÓN DOCENTE
SELECT CLAVEMATERIA, EQUIVALENCIAS, GRUPO,NOMBREMATERIA ASIGNATURA,nvl(TITULO,' ')||' '|| NOMBRE ||' '||PATERNO||' '||NVL(MATERNO,' ')CATEDRATICO,nvl(IDIOMA,'ESP')IDIOMA,
CASE WHEN LUNES IS NOT NULL THEN SUBSTR(LUNES,1,11)||' SALÓN'||SUBSTR(LUNES,12) ELSE LUNES END LUNES ,
CASE WHEN MARTES IS NOT NULL THEN SUBSTR(MARTES,1,11)||' SALÓN'||SUBSTR(MARTES,12) ELSE MARTES END MARTES,
CASE WHEN MIERCOLES IS NOT NULL THEN SUBSTR(MIERCOLES,1,11)||' SALÓN'||SUBSTR(MIERCOLES,12) ELSE MIERCOLES END MIERCOLES,
CASE WHEN JUEVES IS NOT NULL THEN SUBSTR(JUEVES,1,11)||' SALÓN'||SUBSTR(JUEVES,12) ELSE JUEVES END JUEVES,
CASE WHEN VIERNES IS NOT NULL THEN SUBSTR(VIERNES,1,11)||' SALÓN'||SUBSTR(VIERNES,12) ELSE VIERNES END VIERNES,
CASE WHEN SABADO IS NOT NULL THEN SUBSTR(SABADO,1,11)||' SALÓN'||SUBSTR(SABADO,12) ELSE SABADO END SABADO
,case when inscritos=capacidad then 1 else 0 end color,ofertada_a
-- CASE WHEN modalidad = 'PR' THEN 'PRESENCIAL' WHEN modalidad = 'VC' THEN 'VIDEOCONFERENCIA' END
FROM UNISOFT4.VIEWPORASIGNATURASOFERTADAS WHERE
SISTEMA IN (147,147)
and modalidad = 'PR'
AND (LUNES IS NOT NULL
OR MARTES IS NOT NULL
OR MIERCOLES IS NOT NULL
OR JUEVES IS NOT NULL
OR VIERNES IS NOT NULL
OR SABADO IS NOT NULL)
Array
(
[0] => Array
(
[CLAVEMATERIA] => AYH601
[EQUIVALENCIAS] => AYH601M,AYH601NE,FHU601,HUM560
[GRUPO] => 912
[ASIGNATURA] => LIDERAZGO TRANSFORMADOR
[CATEDRATICO] => DR. GUILLERMO TEPANECATL GONZALEZ
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] =>
)
[1] => Array
(
[CLAVEMATERIA] => AYH601
[EQUIVALENCIAS] => AYH601M,AYH601NE,FHU601,HUM560
[GRUPO] => 913
[ASIGNATURA] => LIDERAZGO TRANSFORMADOR
[CATEDRATICO] => MTRO. ENRIQUE JAVIER GUZMAN LOPEZ
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] =>
)
[2] => Array
(
[CLAVEMATERIA] => DHE602
[EQUIVALENCIAS] => DHE602
[GRUPO] => 1
[ASIGNATURA] => EDUCACIÓN EMOCIONAL
[CATEDRATICO] => DRA. LAURA GAETA GONZALEZ
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] => 1471373,1473355,1473392
)
[3] => Array
(
[CLAVEMATERIA] => DHE603
[EQUIVALENCIAS] => PED006
[GRUPO] => 1
[ASIGNATURA] => ESTRATEGIAS DE ACOMPAÑAMIENTO EN PROCESOS DE FORMACIÓN
[CATEDRATICO] => MTRA. AUSENCIA LOPEZ DE LEON
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] => 1471369
)
[4] => Array
(
[CLAVEMATERIA] => DHE606
[EQUIVALENCIAS] => DHE606
[GRUPO] => 1
[ASIGNATURA] => ÉTICA PROFESIONAL EN EDUCACIÓN
[CATEDRATICO] => DR. ARTURO VILLANUEVA GONZALEZ
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] => 1473355
)
[5] => Array
(
[CLAVEMATERIA] => FAM605
[EQUIVALENCIAS] => FAM605
[GRUPO] => 1
[ASIGNATURA] => FAMILIA, ESCUELA Y SOCIEDAD
[CATEDRATICO] => MTRA. GABRIELA LECHUGA BLAZQUEZ
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] => 1471369,1472485,1473355
)
[6] => Array
(
[CLAVEMATERIA] => FHU601
[EQUIVALENCIAS] => AYH601
[GRUPO] => 1
[ASIGNATURA] => LIDERAZGO TRANSFORMADOR
[CATEDRATICO] => DR. ARTURO GUERRA BEDOLLA
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] =>
)
[7] => Array
(
[CLAVEMATERIA] => HIS710
[EQUIVALENCIAS] => TEM011
[GRUPO] => 1
[ASIGNATURA] => TESIS I
[CATEDRATICO] => DR. DAVID SANCHEZ SANCHEZ
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 11:00-14:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] =>
)
[8] => Array
(
[CLAVEMATERIA] => LGE604
[EQUIVALENCIAS] => LGE604
[GRUPO] => 1
[ASIGNATURA] => ADMINISTRACIÓN Y GESTIÓN DE INSTITUCIONES EDUCATIVAS
[CATEDRATICO] => MTRA. ERIKA CEPEDA ARVIZU
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] => 1471369,1471373,1472485
)
[9] => Array
(
[CLAVEMATERIA] => MEM605
[EQUIVALENCIAS] =>
[GRUPO] => 501
[ASIGNATURA] => MODELACIÓN Y RESOLUCIÓN DE PROBLEMAS EN MATEMÁTICAS
[CATEDRATICO] => DRA. SANDRA CASTILLEJA JIMENEZ
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] => 1471372
)
[10] => Array
(
[CLAVEMATERIA] => PED004
[EQUIVALENCIAS] =>
[GRUPO] => 1
[ASIGNATURA] => DIRECCIÓN DEL APRENDIZAJE
[CATEDRATICO] => DRA. FLORENTINA SALAZAR MENDOZA
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] =>
)
[11] => Array
(
[CLAVEMATERIA] => PED606
[EQUIVALENCIAS] => PED606
[GRUPO] => 101
[ASIGNATURA] => ENFOQUES DE EDUCACIÓN INCLUSIVA
[CATEDRATICO] => DRA. PAULINA ITURBIDE FERNANDEZ
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] =>
)
[12] => Array
(
[CLAVEMATERIA] => PED608
[EQUIVALENCIAS] =>
[GRUPO] => 101
[ASIGNATURA] => ESTRATEGIAS PARA LA COMPRENSIÓN
[CATEDRATICO] => DRA. FLAVIA MARICRUZ BAÑUELOS HERNANDEZ
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] =>
)
[13] => Array
(
[CLAVEMATERIA] => PED610
[EQUIVALENCIAS] =>
[GRUPO] => 901
[ASIGNATURA] => INTEGRACIÓN DE LA TECNOLOGÍA EN EL PROCESO DE APRENDIZAJE
[CATEDRATICO] => DR. RICARDO VAZQUEZ SERNA
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] => 1471372
)
[14] => Array
(
[CLAVEMATERIA] => PED612
[EQUIVALENCIAS] => PED612
[GRUPO] => 102
[ASIGNATURA] => TEMAS SELECTOS DE EDUCACIÓN
[CATEDRATICO] => DR. MIGUEL ANGEL SAINZ PALAFOX
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] =>
)
[15] => Array
(
[CLAVEMATERIA] => PED612
[EQUIVALENCIAS] => PED612
[GRUPO] => 103
[ASIGNATURA] => TEMAS SELECTOS DE EDUCACIÓN
[CATEDRATICO] => DR. GIOVANNI CHAVEZ MELO
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] =>
[SABADO] => 08:00-11:00 SALÓN --
[COLOR] => 0
[OFERTADA_A] =>
)
[16] => Array
(
[CLAVEMATERIA] => PED612
[EQUIVALENCIAS] => PED612
[GRUPO] => 901
[ASIGNATURA] => TEMAS SELECTOS DE EDUCACIÓN
[CATEDRATICO] => DRA. LUZ BERENICE SILVA RAMIREZ
[IDIOMA] => ESP
[LUNES] =>
[MARTES] =>
[MIERCOLES] =>
[JUEVES] =>
[VIERNES] => 16:00-19:00 SALÓN --
[SABADO] =>
[COLOR] => 0
[OFERTADA_A] => 1471369
)
)
| CLAVE | CLAVE2 | GRUPO | ASIGNATURA | CATEDRÁTICO | IDIOMA | LUNES | MARTES | MIERCOLES | JUEVES | VIERNES | SABADO | COLOR | OFERTADA SOLO PARA: |
|---|
| AYH601 |
AYH601M,AYH601NE,FHU601,HUM560 |
912 |
LIDERAZGO TRANSFORMADOR |
DR. GUILLERMO TEPANECATL GONZALEZ |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
|
| AYH601 |
AYH601M,AYH601NE,FHU601,HUM560 |
913 |
LIDERAZGO TRANSFORMADOR |
MTRO. ENRIQUE JAVIER GUZMAN LOPEZ |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
|
| DHE602 |
DHE602 |
1 |
EDUCACIÓN EMOCIONAL |
DRA. LAURA GAETA GONZALEZ |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
1471373,1473355,1473392 |
| DHE603 |
PED006 |
1 |
ESTRATEGIAS DE ACOMPAÑAMIENTO EN PROCESOS DE FORMACIÓN |
MTRA. AUSENCIA LOPEZ DE LEON |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
1471369 |
| DHE606 |
DHE606 |
1 |
ÉTICA PROFESIONAL EN EDUCACIÓN |
DR. ARTURO VILLANUEVA GONZALEZ |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
1473355 |
| FAM605 |
FAM605 |
1 |
FAMILIA, ESCUELA Y SOCIEDAD |
MTRA. GABRIELA LECHUGA BLAZQUEZ |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
1471369,1472485,1473355 |
| FHU601 |
AYH601 |
1 |
LIDERAZGO TRANSFORMADOR |
DR. ARTURO GUERRA BEDOLLA |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
|
| HIS710 |
TEM011 |
1 |
TESIS I |
DR. DAVID SANCHEZ SANCHEZ |
ESP |
|
|
|
|
|
11:00-14:00 SALÓN -- |
0 |
|
| LGE604 |
LGE604 |
1 |
ADMINISTRACIÓN Y GESTIÓN DE INSTITUCIONES EDUCATIVAS |
MTRA. ERIKA CEPEDA ARVIZU |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
1471369,1471373,1472485 |
| MEM605 |
|
501 |
MODELACIÓN Y RESOLUCIÓN DE PROBLEMAS EN MATEMÁTICAS |
DRA. SANDRA CASTILLEJA JIMENEZ |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
1471372 |
| PED004 |
|
1 |
DIRECCIÓN DEL APRENDIZAJE |
DRA. FLORENTINA SALAZAR MENDOZA |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
|
| PED606 |
PED606 |
101 |
ENFOQUES DE EDUCACIÓN INCLUSIVA |
DRA. PAULINA ITURBIDE FERNANDEZ |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
|
| PED608 |
|
101 |
ESTRATEGIAS PARA LA COMPRENSIÓN |
DRA. FLAVIA MARICRUZ BAÑUELOS HERNANDEZ |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
|
| PED610 |
|
901 |
INTEGRACIÓN DE LA TECNOLOGÍA EN EL PROCESO DE APRENDIZAJE |
DR. RICARDO VAZQUEZ SERNA |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
1471372 |
| PED612 |
PED612 |
102 |
TEMAS SELECTOS DE EDUCACIÓN |
DR. MIGUEL ANGEL SAINZ PALAFOX |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
|
| PED612 |
PED612 |
103 |
TEMAS SELECTOS DE EDUCACIÓN |
DR. GIOVANNI CHAVEZ MELO |
ESP |
|
|
|
|
|
08:00-11:00 SALÓN -- |
0 |
|
| PED612 |
PED612 |
901 |
TEMAS SELECTOS DE EDUCACIÓN |
DRA. LUZ BERENICE SILVA RAMIREZ |
ESP |
|
|
|
|
16:00-19:00 SALÓN -- |
|
0 |
1471369 |