Project Plan document, 6/29/2021, 9:49 PM, English, 6/29/2021, 9:49 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

6/29/2021, 9:49 PM

Project plan 2021-06-29
John Iacovacci / Phil Bradford
Business design specification
Functionality
Deliverables
Requirement number 1
CRUD database
Client Table
Client ID
Email
Cell phone
Language
Class
Preferred delivery: email, cell phone

Create a NoSQL table key value is Client ID and fields from the client
table above
Build an app engine application that will allow for Create, Read,
Update and Delete function on data store in the table
https://uconnstamfordslp.blogspot.com/p/assignment-exercise-python-datastore.html





Requirement number 2
Communication process system
Build an app engine process to input the following fields into an HTML form

Textbox
Class
Send-button
Verification (are you sure?)
date of event
Attachment

When the send button is hit

Loop thru table to find client records that match class
If record is matched check the language field to see if it needs translation'
If language is not english
Send language and text to translate API
Check to see if delivery text or email
If text send translated (if needed) textbox to number on record
If email send translated (if needed) textbox to email on record
https://uconnstamfordslp.blogspot.com/p/app-engine-flask-html-form.html
(not complete)
Please note texting may require additional work then emailing.
For better success separate out both with small POC programs.

https://docs.google.com/document/d/1Z5TBpewVG_goAL9M-E6f7viuiXDh5b9jfj5yTS2JL2U/edit

Revised teams with leaders - Q&A Monday June 28th at 5:00pm - 6:00pm Westhill i - Gavin, 6/26/2021, 9:28 AM, English, 6/26/2021, 9:28 AM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

6/26/2021, 9:28 AM

Revised teams with leaders - Q&A Monday June 28th at 5:00pm - 6:00pm
Westhill i - Gavin

Gavin
Stops
gavin.stops@gmail.com
English
Sam
Sherman
samsher4606@gmail.com
English
Andrew
Choi
andrewchoi6534@gmail.com
English
Sonok
Mahapatra
sonokmahapatra@gmail.com
English

Westhill II - Arjun

Arjun
Anand
arjun4002@gmail.com
English
Georgiy
Zemlevskiy
georgiy.zemlevskiy@gmail.com
English
Rohan
Sahu
sahurohan2006@gmail.com
English
A
Ray
aviganatraray@gmail.com
English

Westhill/Wilton - Savar

Savar
Jain
savarjain08@gmail.com
English
Rubin
Jha
rjha11054@gmail.com
English
Rowan
Whelan
rwhelan340@gmail.com
English

Stamford High - Skyla

Skyla Miranda
Reyes
skylamiranda643@gmail.com
English
Caitlin
Reynolds
trcait@gmail.com
English
Joesph
Arouni
joseph.c.arouni@gmail.com
English

J M Wright - Dilla

Dilla
Carrillo
dilia.carrillo0507@gmail.com
English
Stephanie
riveraponce
Stephanie.riveraponce@gmail.com
English
Nitish
Gannu
Nitishgannu@gmail.com
English
Vedant
Gannu
Vedantgannu@gmail.com
English
AITE - Matthew

Matthew
Tolla
matthew.q.bean@gmail.com
English
Jonathan
Iacovacci
jonathan.iacovacci1@gmail.com
English
Michael
Iacovacci
michael.iacovacci1@gmail.com
English

Reminder Meeting tonight 5:00pm to 6:00pm, 6/24/2021, 3:36 PM, English, 6/24/2021, 3:37 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

6/24/2021, 3:36 PM

Reminder Meeting tonight 5:00pm to 6:00pm
Meeting Information
Meeting link:
https://uconn-cmr.webex.com/uconn-cmr/j.php?MTID=m6870eb1a3038771bc812c505239aa317
Meeting number:
120 899 7600
Password:
uconn

Agenda:
First 4 meetings will teach Google concepts until July 1st. No
meetings week of 4th. New set of meetingsto start based upon project
build Tuesday July 13th until Thursday August 12th.

Optional Wed 6/23 5:00pm to 6:00pm Catch up and Review, 6/23/2021, 1:09 PM, English, 6/23/2021, 1:09 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

6/23/2021, 1:09 PM

Wed 6/23 5:00pm to 6:00pm Catch up and Review
For people who could not make session 1 or may have questions

Meeting link:
https://uconn-cmr.webex.com/uconn-cmr/j.php?MTID=m5f70fb7722b28e51a83c46cf9003c15f
Password:
uconn

Welcome to the UCONN/Google learning program, 6/21/2021, 10:27 PM, English, 6/21/2021, 10:27 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

6/21/2021, 10:27 PM

Welcome, first most important, enjoy learning and ask questions.

The Google platform is incredible and I hope everyone gets excited
about building innovative software.

The sessions will be 1 hour but I'm available to answer any and all
questions past 6pm.

Use CHAT if you are unsure of something said.

The one big advantage of remote learning is I can answer CHAT
questions without stopping.
Meeting Information
Meeting link:
https://uconn-cmr.webex.com/uconn-cmr/j.php?MTID=m6870eb1a3038771bc812c505239aa317

Password:
uconn

Westhill 1


Gavin
Stops
gavin.stops@gmail.com
Sam
Sherman
samsher4606@gmail.com
Andrew
Choi
andrewchoi6534@gmail.com
Sonok
Mahapatra
sonokmahapatra@gmail.com

Westhill 2



Arjun
Anand
arjun4002@gmail.com
Georgiy
Zemlevskiy
georgiy.zemlevskiy@gmail.com
Rohan
Sahu
sahurohan2006@gmail.com
A
Ray
aviganatraray@gmail.com


Westhill/Wilton


Rubin
Jha
rjha11054@gmail.com
Savar
Jain
savarjain08@gmail.com
Rowan
Whelan
rwhelan340@gmail.com

Stamford High


Skyla Miranda
Reyes
skylamiranda643@gmail.com
Caitlin
Reynolds
trcait@gmail.com


JM Wright Technical


Stephanie
riveraponce
Stephanie.riveraponce@gmail.com
Dilla
Carrillo
dilia.carrillo0507@gmail.com

AITE


Matthew
Tolla
matthew.q.bean@gmail.com
Jonathan
Iacovacci
jonathan.iacovacci1@gmail.com
Michael
Iacovacci
michael.iacovacci1@gmail.com

Weekly update for UCONN Learning program, 6/19/2021, 1:08 PM, English, 6/19/2021, 1:08 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

6/19/2021, 1:08 PM

The focus of this summer program is 100% on learning and advancing skills.

No stress, no pressure.

Teams should communicate regularly with each other and teams should
also help each other out when needed.

I changed the direction of what we will do a couple of times until I
settled on the following.

Languages, Databases, code, etc is all up to the teams.

This is the same way I manage my remote team at SSGA.

Since they do the work they pick the technology framework (within the
corporate limits) of what they want to code in (e.g. Java, Python,
PHP).

The next 2 weeks will be 100% focused on the GoogleCloud platform

Any solution needs to be developed on this platform.

https://uconnstamfordslp.blogspot.com/

Business Requirements

We are trying to produce software for 2 local non-profit organizations.

Family Centers and Boys and Girls club of Stamford.

Family Centers is looking for a program which will send a translated
text message out to their users.

Boys and Girls is looking to go beyond what the current application
does (https://www.remind.com/) by having attachments translated
(Google Vision, OCR and Translate).

Also, I'd like to have some speech to text to translate to speech
examples generated.

The main application needs a CRUD (create, read. Update, delete)
process which will maintain

User ID, user name, email, cell phone, classroom, language,
notification (text or email)

The send process will require a text box for message, classroom
selection and ability to attach file.

Message will then be sent to each user in that classroom with attachment.

If translate is needed it will perform before sending and leverage
Google Vision API to OCR (optical character recognition) the image and
translate the results to be send.

A record of that message sent needs to be stored and a link generated
within the message to the next process.

The respond process will allow the user to respond to the message in
their language and sent back to the sender in the sent language.

Do not try writing code without technical specifications.

After the 2 weeks learning period teams should be able to start to
develop some of the routines.

Build the application with milestone success achievements in focus.

E.g. CRUD example in the blog
https://uconnstamfordslp.blogspot.com/p/assignment-exercise-python-datastore.html

Is a way to use python code, app engine and datastore to create and
maintain a table.

If you can build this you will have learned and achieved a milestone.

Break each task into small proof of concept examples that way you are
just debugging the one function and not the whole application.

Have fun. Learn what you can and don't worry about what you can't do.

This is summer and I want everyone to enjoy learning about google and
this amazing platform.

Thanks

UCONN Stamford Summer Learning Program, 6/16/2021, 5:57 PM, English, 6/16/2021, 5:57 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

6/16/2021, 5:57 PM

UCONN Stamford Computer Learning Program Starts 6/22 invitations to follow

https://uconnstamfordslp.blogspot.com/

Faculty

phillip.bradford@uconn.edu
phil.kubin93@gmail.com
tendai@tendaigomo.com
john.iacovacci@uconn.edu

Students

mara.silva@uconn.edu
maribeth.teves@uconn.edu

Westhill

Faculty

CSarkar@stamfordct.gov

Students

Team 1


Gavin
Stops
gavin.stops@gmail.com
Sam
Sherman
samsher4606@gmail.com


Teams ? Need students to form teams here


Arjun
Anand
arjun4002@gmail.com
Georgiy
Zemlevskiy
georgiy.zemlevskiy@gmail.com
Andrew
Choi
andrewchoi6534@gmail.com
Sonok
Mahapatra
sonokmahapatra@gmail.com
Rohan
Sahu
sahurohan2006@gmail.com
Rowan
Whelan
rwhelan340@gmail.com
A
Ray
aviganatraray@gmail.com


Wilton/Westhill Team


Rubin
Jha
rjha11054@gmail.com
Savar
Jain
savarjain08@gmail.com

Stamford High

Faculty

Adam
Scianna
AScianna@stamfordct.gov


Students


Skyla Miranda
Reyes
skylamiranda643@gmail.com
Caitlin
Reynolds
trcait@gmail.com

JM Wright Technical

Faculty


Subha
Pandalai
subha.pandalai@cttech.org


Students


Stephanie
riveraponce
Stephanie.riveraponce@gmail.com
Dilla
Carrillo
dilia.carrillo0507@gmail.com


AITE

Team


Matthew
Tolla
matthew.q.bean@gmail.com
Jonathan
Iacovacci
jonathan.iacovacci1@gmail.com
Michael
Iacovacci
michael.iacovacci1@gmail.com

Invitations to come first session Tuesday June 22nd at 5:00pm, 6/7/2021, 9:47 PM, English, 6/7/2021, 9:47 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

6/7/2021, 9:47 PM



First session will be Tuesday June 22nd 5:00pm to 6:00pm
Two sessions a week (Tuesday and Thursday) until July 2nd.

No sessions 4th of July Week and they will resume the following week.

Invitations to follow.

Students will form teams of 2 or more. You can start to team up now.

Because of the impressive amount of experience that this group does I
want to change the format to allow more creativity and innovation.

While I may reach out for help with the Summer deliverables and
everyone is welcome to follow the bi-directional translate program, I
feel it would be in best interest if the teams would build
applications based upon interest or ideas.

I've outlined a series of lessons that we will review below taking
them from our UCONN course.

I'd like to have students complete an application or at least
understand all the aspects of an application by summer end.

The course is broken into 4 main parts

Languages (python, HTML, css, Linux) - We will assume some knowledge
here so we can use as reference.

Databases - NoSQL and BigQuery - Any application will leverage either
Datastore or firestore.
Like to see if we can leverage Big Data Sets or at least understand
how to leaverage.
E.g public dataset for COVID - COVID-19 Cases (confirmed and probable)+197

Networking and Security - URL, keys, user authentication

Advance analytics - API's and Machine learning


https://uconnstamfordslp.blogspot.com/

Please email with any questions

UCONN Summer program Weekly update, 6/2/2021, 5:39 PM, English, 6/2/2021, 5:39 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

6/2/2021, 5:39 PM

To All;

This year's internship consists of extremely talented students with
great backgrounds and resumes.

Because of this I no longer want the teams to just duplicate the code
that we are rolling out.

https://googleclouduconn.blogspot.com/

So I'd like the teams to come up with their own ideas.

I will be having on-line webex sessions on Tuesday and Thursday nights
from 5:00pm to 6:00pm

Reviewing different aspects on the Google cloud along with working
with teams on their projects.

I'd prefer that the projects follow the theme of helping the Stamford
community like we have done every year since we started but teams will
be allowed to design and build any feasible idea that they like.

The link is to the UCONN cloud course which will explain in advance
all the google services.

I will be building out the Summer blog as we go along

https://uconnstamfordslp.blogspot.com/

As stated earlier I would like the projects to stay within the goal of
using technology to help people.

Please view the google video below.

Don't hesitate to email me at any time with questions or issues.

Thanks

John Iacovacci 917-701-6177


https://cloudonair.withgoogle.com/events/virtual_faculty_summit_2020/watch?talk=track1_session2_community_campus