Database Week 1

Week 1

Enter your grades/transcript in a spreadsheet then calculate your GPA

- Use google spreadsheet

- with your email.kmutnb.ac.th account (by google)


What have you done?

Link => CLICK HERE !!

Any problem / solution ?

Problem : Grade Letter can't use for calculation

Solution : Use VLOOKUP

Problem : too many function use

Solution : add another column for grade x weight

Decision ?

Make Hard Code for GPA

Related info/Link/Reference ?

Question

http://db2559.blogspot.com/

Information

http://klogic2.kmutnb.ac.th:8080/kris/index.jsp

Vloopup

https://www.youtube.com/watch?v=QGeXH5r6o6c