hi everyone this is cs50 I'm Jessica
here with Andrew and William and they're
going to demo their project for us so
can you tell me a little bit about what
your project says yeah so what we've
done for our project is to create a
lost-and-found site for yield the gale
community so we're trying to find a way
in order for people to declare lost or
found items and try to have people
return their items back to their given
or lost users right and so when you
first come to our site you'll be taken
to our login page which displays our
logo and a small description but since
we've never been here before let's
create a new account that'll bring us to
an account page and we are going to
create a cs50 specific account I'm
filling out required information about a
name a username a phone number which
will be random for now and we'll also
put in a simple password just for the
sake of today when we create an account
we'll be brought to our home page where
you can learn a little bit more about
our site our mission and also see some
buttons that might help you navigate the
site at the bottom of the home page
you'll see a recently found section with
items that have recently been found on
the site but I can't see what we're
looking for there today so let's log a
new lost item today David has lost his
famous phone book and we can list some
more attributes of the phone book it's
yellow it's good condition not very good
and he last saw it at the Center for
teaching and learning which is right
around the corner from Sterling Memorial
Library his phone book is important but
not that important so he's gonna offer a
five dollar reward for anyone who finds
it and we and when we submit we'll be
brought to a new page with our account
and this account page basically says
what David has logged for lost items and
items that he's actually found so people
who have lost these items but haven't
blogged what they've found
they've lost can actually look for these
find items now if we go to the find page
we could see what other people have
declared lost and let's say that David
actually finds the TD flag
so he finds the TV flag and everything
and he wants to 356 dollar reward for
the TV flag so he all he has to do is
press the more information button and
then we see that our head of college
Mary Lou has actually lost our TV flag
and therefore all we have to do is
contact ml at yale.edu and hopefully we
could return the TV flag back to average
rightful owner
now finally the big thing about our app
is once someone actually finds our-our
lost phone book we don't actually have
to keep it back on the site so what
we've done is that once David has found
his phone book all we have to do is
press this found button and confirm we
found the item and delete it from the
database forever that's really awesome
and impressive and also super useful
like I wish I had this when I lost my
hat the other year yeah so what kind of
technologies did you use when building
this web app so we decided that we
wanted to create mainly a website and so
knowing that we've used like Python and
HTML in the past especially when we're
working on our past few sets we wanted
to base our code off of that so we used
a lot of Python for our database holding
all of our information we use sequel and
we use HTML CSS Java for really kind of
the front end of that how do you guys
have used Python in HTML and sequel
before coming to cs50 not before cs50 I
actually hadn't done any coding before
cs50 and I know just looking at this now
it's kind of remarkable how big the
improvement has been so it's cool to be
able to combine all those different
languages into one comprehensive project
that's really great what was the most
exciting part of building this we're
also like the challenges that you faced
I think the biggest challenges we've
definitely had to face is just debugging
the code because I think it takes a lot
of patience in order to find like the
miniscule errors that you might have
made like just spelling errors or like
some variable errors that you might just
need to kind of like slowly debug and
take your time but I think it was also a
really fun project because we actually
got to make a lot of decisions for
ourself
like how to create our own database how
to basically format our
like code or HTML or CSS to make it
looked just as I said I guess it does
right now and so I think it had a lot
there was a lot of fun parts to the job
but also a lot of challenges that came
along with it as well yeah definitely
well it turned out really great the all
the aesthetics are very nice and that's
I know that's quite difficult to do so
I'm very impressed thank you so much for
showing us your demo of your project I'm
Jessica and this is cs50