fbpx

Sistema en Excel para un colegio (Control de matrículas y pagos)

registro de matriculas en excel sistemaSistema en Excel para un colegio (Control de matrículas y pagos): Revisando mis archivos me encontré con uno que me llamó la atención y que desarrollé ya hace unos años (Programación básica de macros); se trata de un pequeño sistema desarrollado con macros vba en excel para un colegio, escuela o centro de estudio, que nos permite controlar las matrículas de cada uno de los estudiantes así como el pago de las mensualidades.

Este sistema desarrollado en excel permite el registro y la impresión de los matriculados, toda la información se registra en una base de datos que se encuentra en la hoja «Detalles».

El código fuente de este archivo es completamente libre para que puedan ver como ha sido desarrollado, también pueden utilizar este archivo como base o modelo de sus futuros proyectos.

La contraseña es 1234

¿CÓMO FUNCIONA?

  1. Luego de descargar el archivo que esta al final del artículo deben de habilitar macros.
  2. Para abrir el formulario de ingreso de datos deben hacer clic en el botón «INICIAR».boton iniciar formulario ingreso de datos
  3. Guía de uso:

A) Seleccionamos el grado al que pertenece el estudiante a matricular, se abrirá una ventana con todos los nombres del cual debemos elegir a uno.

B) En esta parte aparecerá los datos del estudiante previamente elegido en el punto A.

C) Seleccionamos el mes a pagar que corresponde a la pensión y el importe.

D) Presionamos el botón REGISTRAR, aparecerá un mensaje preguntándonos si queremos registrarlo e imprimirlo. LA INFORMACIÓN SE REGISTRA EN LA HOJA «DETALLES»,sistema en excel para matriculas de un colegio

DESCARGA EL ARCHIVO

Descargar Sistema en Excel para un colegio.xls

SUSCRÍBETE GRATIS

Te convertiré en un experto en Excel, tengo la experiencia y todo el material que necesitas, mi ayuda es totalmente gratuita.

Suscríbete

Agrega tu comentario

Comentarios
  1. Posted by Fisher A. P.
    • Posted by Gustavo A. Sebastiani Cépeda
  2. Posted by Marjorie Rosero
    • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by José Luis Cedillo
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Bernarda
        • Posted by Gustavo A. Sebastiani Cépeda
  4. Posted by Gustavo Rojas Medina
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by HIRAM ALVA
    • Posted by Gustavo A. Sebastiani Cépeda
  6. Posted by HIRAM ALVA
    • Posted by Gustavo A. Sebastiani Cépeda
  7. Posted by Raúl Azogue
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by Salvador Acevedo Alvarez
    • Posted by Gustavo A. Sebastiani Cépeda
  9. Posted by Martin Garcia
    • Posted by Gustavo A. Sebastiani Cépeda
  10. Posted by Franklin
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Julio López
        • Posted by Gustavo A. Sebastiani Cépeda
  11. Posted by Olises Franco Reyes
    • Posted by Gustavo A. Sebastiani Cépeda
  12. Posted by HUGO ALBERTO VALENTE SALVADOR
    • Posted by Gustavo A. Sebastiani Cépeda
  13. Posted by KAREN
    • Posted by Gustavo A. Sebastiani Cépeda
  14. Posted by camilo
    • Posted by Gustavo A. Sebastiani Cépeda
  15. Posted by Yoa
    • Posted by Gustavo A. Sebastiani Cépeda
  16. Posted by cecilia rabanal
    • Posted by Gustavo A. Sebastiani Cépeda
  17. Posted by Rafo Vital
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by JOSE ESPINOZA
        • Posted by Gustavo A. Sebastiani Cépeda
  18. Posted by NADIA BERMUDEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  19. Posted by Rafo Vital
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Julio López
      • Posted by Gustavo A. Sebastiani Cépeda
  20. Posted by ELIZABETH
    • Posted by Gustavo A. Sebastiani Cépeda
  21. Posted by José Pablo
  22. Posted by José Pablo
  23. Posted by Zuriel
  24. Posted by CLARY
  25. Posted by Kimberly Dijan Huaylla Barnett
  26. Posted by nataly alburuqueque
    • Posted by Gustavo A. Sebastiani Cépeda
  27. Posted by Katia Chan Argaez
    • Posted by Gustavo A. Sebastiani Cépeda
  28. Posted by Katia Chan Argaez
    • Posted by Gustavo A. Sebastiani Cépeda
  29. Posted by Nohemi
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Clari Alvarado
        • Posted by Gustavo A. Sebastiani Cépeda
  30. Posted by ricardo
    • Posted by Gustavo A. Sebastiani Cépeda
  31. Posted by KATIUSKAA CASTAÑED
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by SERGIO
        • Posted by Gustavo A. Sebastiani Cépeda
  32. Posted by arles
    • Posted by Gustavo A. Sebastiani Cépeda
  33. Posted by Luis Guzman
    • Posted by Gustavo A. Sebastiani Cépeda
  34. Posted by Juanjo
    • Posted by Gustavo A. Sebastiani Cépeda
  35. Posted by RUDY HUAMAN TARAZONA
    • Posted by Gustavo A. Sebastiani Cépeda
  36. Posted by Alejandra
    • Posted by Gustavo A. Sebastiani Cépeda
  37. Posted by gabriel bernadas
    • Posted by Gustavo A. Sebastiani Cépeda
  38. Posted by Melissa
    • Posted by Gustavo A. Sebastiani Cépeda
  39. Posted by JULIO
    • Posted by Gustavo A. Sebastiani Cépeda
  40. Posted by Maria
    • Posted by Gustavo A. Sebastiani Cépeda
  41. Posted by Mariano
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by GERSON DAVID GUAYANAY NIÑO
        • Posted by Gustavo A. Sebastiani Cépeda
  42. Posted by Esly Nathan Santiago
    • Posted by Gustavo A. Sebastiani Cépeda
  43. Posted by Evelyn hurtado
    • Posted by Gustavo A. Sebastiani Cépeda
  44. Posted by mimi
  45. Posted by erick
    • Posted by Gustavo A. Sebastiani Cépeda
  46. Posted by victor
    • Posted by Gustavo A. Sebastiani Cépeda
  47. Posted by cassely
  48. Posted by javier espinal
  49. Posted by Dario
  50. Posted by ivan
  51. Posted by wilmer vichaz
  52. Posted by Arturo
  53. Posted by myriam
  54. Posted by bruno
  55. Posted by MALENNA
  56. Posted by jairo
  57. Posted by Fernando
    • Posted by Jorge
    • Posted by jairo
  58. Posted by Karla Juárez
  59. Posted by ALEJANDRO
  60. Posted by Carlos Cruz
    • Posted by Oscar Yupanqui
  61. Posted by Elvis
  62. Posted by Natali RIANO BARRAGAN
    • Posted by Robin Solano
  63. Posted by Alcides
  64. Posted by Laura
  65. Posted by Alberto Piña
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Gerson Tejeda
  66. Posted by Alberto Piña
    • Posted by Robin Solano
      • Posted by Alberto Piña
  67. Posted by Lino Elías Fernandez Bonilla
    • Posted by Robin Solano
  68. Posted by EFRAIN PRADO ANGULO
    • Posted by Robin Solano
  69. Posted by el excel para colegios pide clave
    • Posted by Robin Solano
  70. Posted by yelsi padilla perez
  71. Posted by LADY
  72. Posted by Cesar Diazgranados
    • Posted by Robin Solano
  73. Posted by Fernando Alberto
  74. Posted by Elena Urbina
    • Posted by Alberto Piña
      • Posted by ricardo
      • Posted by Emileidis Gabriela Mujer Simoza Patete
      • Posted by WIlfredo
  75. Posted by OMAR
    • Posted by Robin Solano
  76. Posted by Elisa
    • Posted by Robin Solano
  77. Posted by Jordy
    • Posted by Gustavo A. Sebastiani Cépeda
  78. Posted by JORGE BRAVO
    • Posted by Robin Solano
  79. Posted by Hackematte
  80. Posted by Hernán
    • Posted by Robin Solano
  81. Posted by CARLOS
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Carlos
        • Posted by Gustavo A. Sebastiani Cépeda
        • Posted by Anastacio Leal
  82. Posted by Joel Gonzalez Mejia
    • Posted by Gustavo A. Sebastiani Cépeda
  83. Posted by fredy
    • Posted by Robin Solano
  84. Posted by ENRIQUE
    • Posted by Adriana
      • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Carlos
      • Posted by Gustavo A. Sebastiani Cépeda
  85. Posted by Alexander
    • Posted by Gustavo A. Sebastiani Cépeda
  86. Posted by ELIANA
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by ENRIQUE
  87. Posted by Steven Rodríguez
    • Posted by Gustavo A. Sebastiani Cépeda
  88. Posted by Antonio
    • Posted by Gustavo A. Sebastiani Cépeda
  89. Posted by NORBEL AVILA SOLORZANO
  90. Posted by Pablo Zuñiga
    • Posted by Robin Solano
  91. Posted by Liz Yum
  92. Posted by terry
    • Posted by Gustavo A. Sebastiani Cépeda
  93. Posted by Hugo Santos
    • Posted by Gustavo A. Sebastiani Cépeda
  94. Posted by Jose Enciso
    • Posted by Gustavo A. Sebastiani Cépeda
  95. Posted by Roger Gonzales Perez
    • Posted by Gustavo A. Sebastiani Cépeda
  96. Posted by Pier Rojas Benites
    • Posted by Gustavo A. Sebastiani Cépeda
  97. Posted by Gustavo A. Sebastiani Cépeda
  98. Posted by Gustavo A. Sebastiani Cépeda
  99. Posted by Roger Gonzales Peres
    • Posted by Gustavo A. Sebastiani Cépeda
  100. Posted by erika
    • Posted by Gustavo A. Sebastiani Cépeda
  101. Posted by hector
    • Posted by Gustavo A. Sebastiani Cépeda
  102. Posted by Charlie
    • Posted by Gustavo A. Sebastiani Cépeda
  103. Posted by Charlie
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Hackematte
  104. Posted by Luis
    • Posted by Gustavo A. Sebastiani Cépeda
  105. Posted by Mili
    • Posted by Gustavo A. Sebastiani Cépeda
  106. Posted by adri
    • Posted by Gustavo A. Sebastiani Cépeda
  107. Posted by TOMAS
    • Posted by Gustavo A. Sebastiani Cépeda
  108. Posted by Viridiana
    • Posted by Gustavo A. Sebastiani Cépeda
  109. Posted by Bryson
    • Posted by Gustavo A. Sebastiani Cépeda
  110. Posted by isaac
    • Posted by Gustavo A. Sebastiani Cépeda
  111. Posted by alex
    • Posted by alex
      • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Gustavo A. Sebastiani Cépeda
  112. Posted by Marivi
    • Posted by Gustavo A. Sebastiani Cépeda
  113. Posted by GERARDO
    • Posted by Gustavo A. Sebastiani Cépeda
  114. Posted by jorge
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Carlos
        • Posted by Robin Solano
  115. Posted by Alfonso Tejada Bustamante
    • Posted by Gustavo A. Sebastiani Cépeda
  116. Posted by Kevin Buelvas
    • Posted by Gustavo A. Sebastiani Cépeda
  117. Posted by carlos gil
    • Posted by Gustavo A. Sebastiani Cépeda
  118. Posted by Alejandro Amaya
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by andres
        • Posted by Gustavo A. Sebastiani Cépeda
  119. Posted by Marco antonio Hernandez P
    • Posted by Gustavo A. Sebastiani Cépeda
  120. Posted by Jogre
    • Posted by Gustavo A. Sebastiani Cépeda
  121. Posted by Luis Soto
  122. Posted by Nicolas Vidaurrazaga
  123. Posted by jesus villagomez
  124. Posted by julian
  125. Posted by Gabriel Terra
  126. Posted by karla cararsco
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by JHON
      • Posted by Daniela Romero
        • Posted by Gustavo A. Sebastiani Cépeda
  127. Posted by Fredy paz
  128. Posted by Fredy paz
  129. Posted by hugo
    • Posted by Gustavo A. Sebastiani Cépeda
  130. Posted by Demian
    • Posted by Gustavo A. Sebastiani Cépeda
  131. Posted by karim galvez
  132. Posted by michael
  133. Posted by LIZARDO CUELLAR MUÑOZ
  134. Posted by [email protected]
  135. Posted by WILFREDO VASQUEZ INCA
    • Posted by Gustavo A. Sebastiani Cépeda
  136. Posted by SAMANTHA
    • Posted by Gustavo A. Sebastiani Cépeda
  137. Posted by Fredy
  138. Posted by YO
  139. Posted by Vela
    • Posted by Karla
      • Posted by Gustavo A. Sebastiani Cépeda
  140. Posted by eddy
  141. Posted by eury rodriguez
  142. Posted by Yucateco1968
  143. Posted by Adme
  144. Posted by SANDRA
  145. Posted by Julio Cesar
  146. Posted by sonia zegarra
  147. Posted by SuPra Elvis
  148. Posted by CLAUDIO GONZALEZ ARTAVIA
  149. Posted by  Basilio QF (@Badchy)
  150. Posted by angy cardona
    • Posted by Claudia
  151. Posted by Ximena
  152. Posted by Chef Yerick Zamora G.
  153. Posted by cesar
  154. Posted by Shelly
  155. Posted by claudia
  156. Posted by jose luis
  157. Posted by jorge
  158. Posted by rafael
  159. Posted by Dary
  160. Posted by Emanuel Dario Cardozo
  161. Posted by Gabriel siana
  162. Posted by William
  163. Posted by juliocesar_seapf
  164. Posted by Pedro
  165. Posted by LYSSY
    • Posted by PEDRO PABLO BARINAS CORNIEL
  166. Posted by William Mendez cerdas
  167. Posted by Paul
  168. Posted by Miguel Enrique Tello Leyva
  169. Posted by maria chaname
  170. Posted by Audris
  171. Posted by Miguel Angel
    • Posted by laura polina