CSP Spot Check #1 (database, postman, cookies) - Githubissues

nighthawkcoders / teacher_portfolio

GitHub Pages / Jupyter Notebook guides for Python, Java, JavaScript, Linux

https://nighthawkcoders.github.io/teacher_portfolio/

Apache License 2.0

1 stars 50 forks source link

CSP Spot Check #1 (database, postman, cookies) #105

Open jm1021 opened 9 months ago

jm1021 commented 9 months ago

Individuals will be asked to demonstrate the following ...

Jan 31

database, with database schema change
- [ ] Show db.Column changes you have made to model/python file in Visual Studio Code
- [ ] Show initialization data code in VSCode
- [ ] Demo delete database and run ./migrate.sh
- [ ] Demo corresponding schema change in SQLite3
- [ ] Demo initialization data captured in Column in SQLite3
postman with /authentication screen
- [ ] Show /authenticate endpoint code in Visual Studio Code
- [ ] Show and Demo /authenticate in Postman…
  - [ ] Demo calling to endpoint
  - [ ] Show JSON data passed in call
  - [ ] Show Response window
  - [ ] Show Cookie acquired window
  - [ ] Cut/Copy/Paste Cookie into jwt.io and show decrypting payload
postman with /api screen to access data under authentication
- [ ] Show /api CRUD code in Visual Studio Code, expecting READ/GET code
- [ ] Show and Demo /api READ/GET endpoint in Postman…
  - [ ] Demo calling to endpoint that requires Cookie
  - [ ] Show Response/Data
  - [ ] Demo Deleting cookie
  - [ ] Demo calling endpoint again
  - [ ] Show Response/Failure

Individuals will be asked to demonstrate the following ...

Feb 5 (Delayed)

jupyter notebook or web page that shows signup and login, focus on login
jupyter notebook or web page that shows redirect or 403 error as result of signup and login page, focus on redirect to data/table display or failure
jupyter notebook that shows CRUD operation on page that requires authentication, or this can include signup without authentication

Quiz instructions

Each student will present in live review the following information on screen

Use Issue to verbally capture progress for Instruction provided by Teacher
Prepare an on Screen answer of questions. For instance...
- Visual Studio Code List
- Browser interaction
- Postman interaction
- SQLite3 visual
- Terminal commands
- etc
Talking during Spot Check with Teacher should be minimal, just Show or Demo as requested
Be sure to prepare Issue in the process of preparing and answering questions as you will submit Issue with final score.

Issue instructions

Screen capture and record results of each question in a personal ISSUE. Teacher will be reviewing time stamps on each question.

Issue Heading

[ ] Name, Period, Score. (John Mortensen, P2, 1..75)
[ ] All Scores (e.g. Q1: 8.5, Q2: 9, Q3: 5.5)
[ ] Top 4 Score Total (e.g. Q1: 8.5 + Q2: 9 = 1.75 of 2.0 )

New Comment in Issue

[ ] Question 1: database, with database schema change
[ ] Record Check Marks
[ ] Provide Screen Capture(s)

New Comment in Issue

[ ] Question 2: postman with /authentication screen
[ ] Record Check Marks
[ ] Provide Screen Capture(s)

New Comment in Issue

[ ] Question 3: postman with /api screen to access data under authentication
[ ] Record Check Marks
[ ] Provide Screen Capture(s)

Comment/Post Issue to this Page

After 5th period TODAY, link your Personal ISSUE to this CSP Spot Check issue. Comment/Post contains… 

[ ] Name (e.g. John Mortensen)
[ ] Period (e.g. Period 2)
[ ] Sum of Score (e.g. 1.75 of 2.0), three scores .9 or above gets a 2.0 of 2.0
[ ] Link to Issue

iKAN2025 commented 9 months ago

[x] Name Isabel Marilla
[x] Period 2
[x] Sum of Score 1.8
[x] Link to Issue

IshanCornick commented 9 months ago

Name: Ishan Cornick Period: 2 All scores: 0.7, 0.9, 0 (didn't get to it) Sum of best two scores: 1.6/2.0 Link to issue

Tanuj253 commented 9 months ago

Name: Tanujsai Nimmagadda Period 2 sum of score: link to Issue

nitinsandiego commented 9 months ago

Name: Nitin Balaji Period 2 Sum of score: 0.9 + 0.9 = 1.80/2 link to issue

DavidL0914 commented 9 months ago

David Lee, Period 2 Best 2 Scores Sum: 0.9 + 0.7 = 1.6 Link to Issue

Question 1: 0.7 | Comments: Use SQLite3 DB to show new column (utilize extensions) Question 2: 0.9 | Comments: Good! Question 3: N/A

M8tth3 commented 9 months ago

[ ] Matthew Wakayama [ ] Period 2 [ ] Sum of Score(2.0) [ ] Link To Issue

ad1tyad3sa1 commented 9 months ago

[ ] Aditya Desai

[ ] Period 2

[ ] Sum of Score (2.7/3)

[ ] Link to Issue

jplip commented 9 months ago

Justin Liporada Period 2 Sum of Score 2.0/2.0 Link to Issue

trevorhuang1 commented 9 months ago

Trevor Huang Period 2 Sum of score: 0.9 + 0.9 +0.9 = 2.7/3.0 Link to issues

vibha-yganji commented 9 months ago

[ ] Vibha Ganji
[ ] Period 2
[ ] Sum of Score
[ ] Link to Issue

Th35py27 commented 9 months ago

Name: Nandan Vallamkondu Period 2 sum of score: Link to issue: https://github.com/Th35py27/CSP/issues/2

To be edited soon

7mwang commented 9 months ago

Name: Matthew Wang Period 2 Sum of scores: 0+0.9+0.9=1.8 Link to issue: Issue

KinetekEnergy commented 9 months ago

Name: Aashray Reddy Period: P5 Sum of Score: 2.0/2.0 Link to Issue: https://github.com/KinetekEnergy/blog/issues/1

spooketti commented 9 months ago

Name: Jonathan Liu Period 5 Sum of Scores: 0.92 +.91 +.91= .91/1 (best of 2 scores) link to issue Issue

SrijDude3416 commented 9 months ago

Name: Srijan Atti Period 5 Scores: Q1: 0.92, Q2: 0.9, Q3: 0.91 Final score: 1.83 Link to issue

varunm532 commented 9 months ago

Name Varun Manoj Pillai Per 2 link to issue: https://github.com/varunm532/varun2/issues/10 question 1 not graded yet question 2: 0.9 question 3: 0.7

1.8/2 overall

Flying-Book commented 9 months ago

Name: Anusha Khobare Per: 2 Sum of Scores (best 2): 1.8/2 Link to Issue

RayyanDarugar commented 9 months ago

Name: Rayyan Darugar Per: 5 Sum of Scores (Top 2): 1.83 Link to Issue

AnvayYadav commented 9 months ago

Name: Anvay Yadav Per: 1 Sum of Scores(Top 2): 1.73 Link to Issue

hanlunli commented 9 months ago

Name: Hanlun Li Period 2 Sum of Scores (best 2): 1.8 (or 2.0 since I got 0.9 for all 3) link

LincolnC2008 commented 9 months ago

Name: Lincoln Crowell Period: 2 Sum of Scores: to be determined. Link to issue: https://github.com/LincolnC2008/student3/issues/2

lakshusan commented 9 months ago

Name: Lakshanya Sankaran Period 2 Sum of score: 0.9 + 0.9 = 1.80/2 (all 3 q's complete with 0.9, -> 1.95/2) link to issue

Lin-cT commented 9 months ago

Name: Lindsay Tang Period: 5 Sum of Scores: .91 + .91 + .9 = 2/2 Link to Issue

sharonkodali commented 9 months ago

Name: Sharon Kodali Period: 2 Sum or scores: 0.9+0.9=1.80/2 ( I got 0.9 for all 3 questions) Link to issues :

alaraipek commented 9 months ago

Name: Alara Ipek Period: 2 Sum of Scores: Not graded yet Link to Issue

tuckergol commented 9 months ago

Name: Tucker Golpariani Period 2 Sum of Scores: 0.9 + 0.9 = 1.8/2 (top two scores) Link to issue

SGTech08 commented 9 months ago

Name: Saathvik Gampa Period 2 Sum of Scores: 0.9+0.9 = 1.8/2 (top 2 scores) Line to Issue

DrishyaMody commented 9 months ago

Drishya Mody Mr. Lopez Period 4 Sum of scores: 1.82/2 link to issue : https://github.com/DrishyaMody/student2/issues/3

Imaad08 commented 9 months ago

Name: Imaad Muzaffer Period 1 Current Score: 1.83/2 Link to Issue

jaydenchen17 commented 9 months ago

Jayden Chen Mr. Lopez p1 Sum of Scores: 0.91+0.91= 1.82 link to issue

peytonl11098 commented 9 months ago

Name: Peyton Leigh Period: 2 Sum of scores: Not graded yet Link to issue

TDWolff commented 9 months ago

Name: Torin Wolff Period: 2 Sum: 1.9/2 (95%) Link To Issue: Link

alishahussain commented 9 months ago

Name: Alisha Hussain Period: 2 Sum of Scores: 0.9+0.9 = 1.8 Link to Issue

tarasehdave commented 9 months ago

Name: Tara Sehdave Period: 2 Sum of Scores: 0.9 + 0.0 = 0.45 Link to Issue

sergi1207 commented 9 months ago

Name: Sergi S. Period 2 Final Score: 1.6/2 Link to issue

KaydenLe commented 9 months ago

Name: Kayden Le Period 2 Sum of scores: Link to issue Q1: Link to issue Q2: Link to issue Q3:

MEERIE commented 9 months ago

NAME - AMEER PERIOD 2 FINAL SCORE: LINK TO QUESTION 3 LINK TO QUESTION 2

ak146 commented 9 months ago

Andrew K P:2 Sum or scores: Issue

tarasehdave commented 9 months ago

Name: Tara Sehdave Period: 2 Sum of scores: Issue

anikabhatnagar20 commented 9 months ago

Anika Bhatnagar Period: 2 Sum of Scores: Issue

vidhaganji commented 9 months ago

Vidha Ganji Period: 1 Sum of Scores: 0.9 (second question) Issue

brandonso36 commented 9 months ago

Name: Brandon So Period 1 Sum of Scores: 0.92 + 0.91 = 1.83/2 (top two scores) Link to Issue

Gurbop commented 9 months ago

Name: Gurshawn B Period 2 Issue

AkshayNagesh commented 9 months ago

Name: Akshay Nagesh Period: 2 Sum of Scores: Not Graded Yet Link To Issue

advikg commented 9 months ago

Name: Advik Garg Period: 5 Sum of Scores: All 3 above .90, 2.00/2.00 Link to Issue

Nathaniel633 commented 9 months ago

Name: Nathaniel Obodovski Per: 5 Sum of Scores 0.91 x 3 meaning 2.00/2.00 Link to Issue

tarunja1ks commented 9 months ago

Name: Tarun Jaikumar Period: 5 Sum of Scores: 0.91+0.90= 1.81/2 (Top 2 scores) Issue

iwu78 commented 9 months ago

Name: Ian Wu Period: 5 Sum of Scores: 0.92 + 0.93 = 1.85/2, 3 scores above 0.9 so 2/2 Link to Issue

AidanLau10 commented 9 months ago

Name: AIdan Lau Period: 1 Sum of Scores: 0.91 + 0.90 + 0.91 = 2/2 Issue

JasonGao76 commented 9 months ago

Name: Jason Gao Period: 5 Sum of Score: 2/2 (0.92 for Q1, 0.91 for Q2, and 0.91 for Q3, so 3 scores above 0.9 qualifies for 2/2) Link to Issue

Next