| Schedule by week or unit | Information to cover Please note that the first assignment is at the bottom of the list posted here. You should do the work in order! I may add to the weekly schedule during the course of the week, so please check back multiple times. Please keep copies of all work you submit until you receive your final grade at the end of the semester. Play computer means to figure out the results yourself by evaluating the data rather than running the query. Remember that when I teach in class, I record all my classes and capture notes on the Smartboard in the spring and fall. The recordings (audio) and the Smartboard are available for all students to use under Audio and Smartboard. This semester you should use the information from 2019 and some from Spring 2020. |
|---|---|
| HELP schedule | I will try to set up some optional class Zoom meetings that you can attend. Check the week of information to see the times and dates. But first
you need to tell me some days and times that work for you. There will be tutors available for this class. You can check with the tutoring center or contact me for times and days. I will post the information when I get it. If you want to meet on Zoom with me, you can email me with a couple of times you can meet and usually one of those will work. I will send out the information to contact me on Zoom. I will post availability but you can also set something up with me. |
| Week #4 Week of September 28th |
INFORMATION: If you would like to set up a Zoom meeting to go over Access and SQL, please let me know.When you send the Access, it may look like it is not getting through. I am probably still getting it - I just have to move it from Outlook to process. Please pass in one assignment (all parts of the assignment) in one email so if there are two assignments/quizzes for a week I want separate emails. Make correcting easier. If you have a question make that clear in the subject. Please get in touch if you have questions - I really do not want to see anyone fall behind. I want to look at SQL (Structured Query Language) this week. I am including some references that will help and I suggest you do some research on your own. Here are two references, but I would look for others. Tutorial on SQL from geeks for geeks W3Schools on SQL Inventory database and explanation: Inventory database Some SQL examples Let me know if you find a typo. Reading - there is not a required text but there is reading that will add to your knowledge base and that is required. The readings below should be done sometime in the next few weeks. Ideally by the end of October. If you bought the optional text, read chapter 1 and then check out the material that goes with the work we are doing. Compiler definition Compiler vs interpreter Programming Process If statements Loops Data types Note taking Skills for college success include knowing how to do effective note taking. EXAMPLES TO LOOK AT: Inventory database and explanation:Inventory database Examples of SQL with logic flowcharts using Inventory database Examples of Access queries done in class: Query examples from 11:00 class (not sure which semester) Query examples from 12:30 class (not sure which semester) Review of Access put up October 3rd 2020 - corrected version Oct 5th Accompanying video Review of Access user interface and SQL - put up 2/18/2022 TOPIC VIDEOS: Access review put up October 3rd 2020Access review (youtube version) Video about group project Review of Access user interface - put up 2/18/2022 Review of Access using SQL - put up 2/18/2022 SQL queries SQL queries (youtube version) SMARTBOARD AND AUDIO NOTES FROM Fall 2019: The Smartboard and audio that introduced SQL is part of the listing from week #2.Queries using SQL (9/19/19 11:00) Accompanying audio Queries using SQL (9/19/19 11:00) Accompanying Smartboard presentation Queries using SQL (9/19/19 12:30) Accompanying audio Queries using SQL (9/19/19 12:30) Accompanying Smartboard presentation ASSIGNMENTS TO DO: Two assignments: database using SQL and Quiz #2Database assignment to query with SQL: You need to send me the database and a list of the SQL queries you wrote so that if the queries get "Microsoft fixed" I can see what you wrote. I also want you to send me the output that was generated. Remember, the queries have to all be done in SQL. This is not a group project. It needs to be done individually. Softskills database to query with SQL So I want two things: the database and a printout showing the SQL code and the resulting output. Quiz #2: Use my notes and the Internet if you want to look thems up but DO NOT simply ask AI. Tell me the resources you used. for information. Quiz #2 Topic: Access Please check back as always! |
| Week #3 Week of September 21st |
INFORMATION: Homework is always due on the Thursday of the next week. So if the assignment is given on week #3 it is due the Thursday of week #4.We are going to continue with Access this week. I am putting up a group project, I will send you information about your group. If you are struggling with the assignment from last week you may find working with others on the group project is helpful. I can set up a help session this week if that would help! ASSIGNMENTS TO DO: This is a group assignment: You will get an email for your group designating a group leader. You can work with email or set up a Zoom account where you can work. The goal is to talk it over and figure out the answers. If you do not get a group assignment, contact me. I do not want you to divide up the questions, I want everyone contributing their thoughts on each problem. Due next Thursday.
What I see the group leader doing is emailing the members of the group and setting up a time they can meet. Then saying,"Okay what are your
thoughts on 1 and hopefully somjeone has some and finally sending me the results. Hopefully the group members will look at the examples
before the meeting and will have some thoughts.
If you disagree with the group answer and want to send a version you feel is right you can do this, but you need to tell the group leader
and members you are doing it.
Things got confused for a couple of the groups - if that happened to you I am sorry and will accept the results
if you do it on your own. Contact me if you have questions.
This assignment involves the user interface and logic - it does not get into SQL. This is NOT an assignment that can be resubmitted.Note: On the flowcharts in the assignment, sometimes the word Technology is cut off and you see Course instead of Course Technology. DB assignment DB assignment (html version) Answer sheet for project Book Database to use in answering questions This week there is also a quiz that can not be resubmitted: |
| Week #2 Week of September 14th |
INFORMATION: If you are interested in setting up a Zoom help session, please let me know. EXAMPLES TO LOOK AT: Example I used in video Bristol serverExample I used in video my server This week we will start working with databases - specifically Access. There are three ways you can get Access: 1) Download Access from Bristol, 2) Use Access in one of the labs - All the labs in K building have Access and so do the computers in the LLC - there are other labs on campus with it also - the student's best option is to use the LLC computers and 3) Access from the server using apporto. Personally I think the first two are the best options. There have been some layout of the screen changes but the only major change to using apporto is the login. The handouts all have the old login You need to click on University Login. Apporto login using University Login Also another reminder that you cannot use Firefox or Safari. Last year their was a problem with Firefox that had no major impact on what we were doing, but this year you get frozen in FireFox. So be sure to use Chrome or Edge. Note that when you login to Apporto you may see the screen shown here. You should NOT use Sign in, you need to change to University. Apporto made this change very recently. TOPIC VIDEOS: Downloading Access from Bristol This too is a previous version but the instructions are correct.Steps:
Introduction to using Access Introduction to using Access (youtube version) Access from Smartboard with flowcharts Access from Smartboard with flowcharts (youtube version) More Access Queries for some reason I made a speaking error with > 17 on 17 More Access Queries (youtube version) SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: There were two sections of the CIS120 when these were made (11:00 and 12:30)and each had two days of Smartboard and audio. I am showing them all so you can choose what to watch. Note also that you should look at the introSQL part next week.WinSCP and intro Access (9/10/19 11:00) Accompanying audio WinSCP and intro Access (9/10/19 11:00) Accompanying Smartboard presentation WinSCP and intro Access (9/10/19 12:30) Accompanying audio WinSCP and intro Access (9/10/19 12:30) Accompanying Smartboard presentation Access queries and intro SQL (9/12/19 11:00) Accompanying audio Access queries and intro SQL (9/12/19 11:00) Accompanying Smartboard presentation Access queries and intro SQL (9/12/19 12:30) Accompanying audio Access queries and intro SQL (9/12/19 12:30) Accompanying Smartboard presentation ASSIGNMENTS TO DO: This is an individual assignment: Access Database Assignment on BCC College Resources.Access Database Assignment on BCC College Resources Sometimes it looks like what you are sending has a problem - I can usually handle it so send it and I will check. Access is not supported on the Mac but Bristol labs are available. This assignment must be done using the Access user interface covered in the notes and examples. It should not be done with SQL - next weeks assignment will deal with SQL. It is acceptable to leave some data blank and makeup some data, but you should find some data on your own as well. There have been questions about the plan to use code in the past. The plan to use code is simply you saying whether you plan to use that resource. You can have a Y, N, M for yes, no, maybe or you can decide on your own codes. Feel free to make up data and leave some fields blank.The goal here is mostly testing the Access so look at the queries and see what fields are tested and therefore needed and try to make a pattern of data that works. Remember the homework is due on the Thursday of next week (this is week #2 so week #3). |
| Week #1 Week of September 7th |
INFORMATION: I had a problem and this may not be exactly the wording originally up here - but it covers everything.Lots of information this week! Please read one of the following: Intro to Spring 2026 CIS120 Sorry I had a cold. Intro to Spring 2026 CIS120 (youtube version) Intro to Fall 2025 CIS120 Intro to Spring 2025 CIS120 Each week, I will post information at the start of the week. Please check back several times during the week because I may add information and/or assignments as the week progresses. If you are just starting as a CIS major, I recommend that you double check your schedule with me if you have questions. You should have gotten login information at your Bristol email acount. Please be sure to check for it. We will use it at various points in the course. Please check the examples, the topic videos and the other resources posted at my site that I list and that relate to what we are covering. There are lots of resources at my site, some that we will never use. Please use the resources I tell you to use about the current topic beinging covered.When this course runs in class, I record my lectures (under Audio) and capture my notes and examples using Smartboard. These are available some from the Spring of 2020 but mostly from the Fall of 2019. I strongly recomment you look at them as well. We will look at HTML/HTML5 and CSS this week to develop a web page. Please look at the samples under Examples and reproduced here. So, to summarize. This week look at the examples under EXAMPLES TO LOOK AT and the explanation of these examples under TOPIC VIDEOS. You should also try out the SMARTBOARD AND AUDIO NOTES so you can hear the lecture and see the notes from the class. EXAMPLES TO LOOK AT: HTML5intro.htmlHTML5list.html HTML5headers.html HTML5CSSheaders.html HTML5CSSlist.html HTML5CSSimage.html HTML5centeredimage.html HTML5CSStable.html HTML5CSScenteredtable.html HTML5linkpage.html HTML5morelinks.html fileInSubHTML5.html anotherpage.html TOPIC VIDEOS: This is an intro from a previous semester in case you want to here a slightly different version (this is also out on youtube)Another HTML and introducing CSS (youtube version) Starting a NEW HTML page Starting a NEW HTML page (youtube version) Introduction to HTML Introduction to HTML (youtube version) HTML intro CSS HTML intro CSS (youtube version) Continuing HTML and introducing CSS Adding images and tables to your page Adding images and tables to your page (you tube version) linking between pages linkingbetween pages (youtube version) SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: First day and intro to HTML (1/23/20 11:00) Accompanying audioFirst day and intro to HTML (1/23/20 11:00) Accompanying Smartboard presentation Second day and more HTML/CSS (1/28/20 11:00) Accompanying audio Second day and more HTML/CSS (1/28/20 11:00) Accompanying Smartboard presentation ASSIGNMENTS TO DO: All assignments must be turned in using priscilla.grocer@bristolcc.edu.Assignments are due the Thursday of the week after they are assigned. So assignments for this week are due Thursday, September 17th. I am posting the assignment early because developing pages with HTML and CSS can be a lot of fun and I thought some of you might decide to give it some extra time between now and when the class actually starts. Your assignment is: HTML page to introduce yourself (needs to include CSS) I should clarify that you should use a lot of the HTML in the examples so you should use things like lists, tables, images, CSS etc to get the best grade. If you use extra HTML that you research and use to create the page you need to explain the commands for extra credit. Also need to have two pages and you need to link them. Note: You do not need to put your web page(s) online this week. We will do that in the future. Check back! |