Programming: Logic, Design and Implementation (CIS120/17)

Weekly Schedule

The college wants you to use the Bristol email account when communicating with me.

If when I return an assignment you do not get a grade it means that you have to go over the assignment and fix and resubmit. Remember, all assignments must be done by everyone. There is no makeup on quizzes and tests (some tests are accepted late - check).

Remember HELP is available on Zoom - see HELP section below. I will post more information.

The CIS pool is now available for students that need to access licensed software that they cannot use from home.
Remote access virtual desktop
Instructional video for using Remote Access Virtual Desktop - HTML

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.
Here are some videos you may find useful to connect to resources. Some of these apply to Mac users.
Downloading WinSCP on your PC by SI Joe Fletcher
Connecting to the CIS Pool
How to log into Bristol vlabs using a web broswer
Filezilla on the Mac
There is access to WiFi from your car under the solar canopies on the Fall River Campus.
Week #14
Week of April 22nd

INFORMATION:

We are finished with topics. Check back for a quiz and another quiz that is extra credit.
I will also be posting the required status sheet and due dates.
Week #13
Week of April 15th

INFORMATION:

Continue on with Visual Basic as posted the last two weeks.

ASSIGNMENTS TO DO:

Extra Credit Visual Basic assignment
I really thing it would be great to do the VB extra credit so high extra credit.
Check back!
Week #12
Week of April 8th

INFORMATION:

If you took last week as a catch up week then you need to do the assignment posted for last week and then move on to this assignment next week.. If you did not take a catch up week, your assignment will be posted here. Remember you need to do all assignments - it is the timing of whether to take a catch up week now or later.
This week you should continue looking at VB.

EXAMPLES TO LOOK AT:

We are continuing with the Visual Basic examples using the same address we used last week.
Visual Basic Programs to download and unzip

TOPIC VIDEOS:

Input, work areas and loops
Arrays - compare JS and VB
Write and read files

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

And more Visual Basic (11/19/19 11:00) Accompanying audio
And more Visual Basic (11/19/19 11:00) Accompanying Smartboard presentation
And more Visual Basic (11/19/19 12:30) Accompanying audio
And more Visual Basic (11/19/19 12:30) Accompanying Smartboard presentation
Arrays, read/write VB (11/26/19 11:00) Accompanying audio
Arrays, read/write VB (11/26/19 11:00) Accompanying Smartboard presentation
Arrays, read/write VB (11/26/19 12:30) Accompanying audio
Arrays, read/write VB (11/26/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

This is information for the assignment on arrays:
Video on arrays
Array in html
Array in Visual Basic
Write a html program using JavaScript and then write the same program using Visual Basic. For Visual Basic, pass in pictures of the screen showing the code and the running program like you did last week. For JavaScript pass in the html program.
The assignment is to take in a state code from 1 - 6 each code standing for a state (you decide which code goes with which state). Set up an array for the state names. Using the code extract and display the state name.
Check back!
Week #11
Week of April 1st

INFORMATION:

Please try to make it to the CIS Alum Career Panel on ZOOM. The date is Thursday, April 4th at noon. I have sent you an email with the address. Let me know if you do not receive it.
Recording of the CIS Alum Panel on April 4th
If you need help, don't forget to set up an appointment with Valerie, Brent or myself.
You will be getting a week with no assignments after we finish the course material - essentially a catch-up week. If you would like to take that week now you can and then do this assignment next week and delay other assignments by a week. Just let me know if you decide to make this a catch up week - if you have questions, let me know. Note that all assignments are still being assigned.
The end is in sight. We are going to look at Visual Basic and that is the last real topic for the semester. We are starting Visual Basic this week. The current version is VB2022. Most of the examples are from previous versions but they work, it is the interface that has changed. The first example goes into version 2022 and there is a video to accompany it.
Download Visual Studio from Microsoft Use Community edition.

EXAMPLES TO LOOK AT:

Visual Basic Programs to download and unzip

TOPIC VIDEOS:

Make first Visual Basic using version 2022
Make first Visual Basic program using previous versions of VB
Two introductory Visual Basic programs
IF Visual Basic program
If where one thing has to be true and either of two others
More IF examples in VB

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

Intro Visual Basic (11/12/19 11:00) Accompanying audio
Intro Visual Basic (11/12/19 11:00) Accompanying Smartboard presentation
Intro Visual Basic (11/12/19 12:30) Accompanying audio
Intro Visual Basic (11/12/19 12:30) Accompanying Smartboard presentation
More Visual Basic (11/14/19 11:00) Accompanying audio
More Visual Basic (11/14/19 11:00) Accompanying Smartboard presentation
More Visual Basic (11/14/19 12:30) Accompanying audio
More Visual Basic (11/14/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Visual Basic AssignmentYou should pass in a picture of the code you wrote and a picture of the form and then a picture after you run the program. In some cases you may want to run with different data a second time to show what is happening.
Week #10
Week of March 25th

INFORMATION:

ZOOM Alum Panel will be April 4th at noon. Please try to attend. Alum will discuss their careers and working in the computing field. It is usually a really interesting discussion so PLEASE TRY TO ATTEND!
I will email you the link to the Zoom Alum Panel - it is my usual link to Zoom.
I believe April 3rd is the last day that students can withdraw from their classes. Withdrawal information
If you are far behind you should do a realistic analysis and decide if you want to withdraw. If you have questions, we can talk!!! You should also talk to financial aid if you have financial aid and you want to be sure you understand the impact of failing and the impact of withdrawing.
Remember there are difficulties with document.write because it waits until JavaScript loops are done to show information. I put out examples with alert to show a possible remedy.
This week we are going to go back and take another look at databases, but this time we are going to use multiple tables. This is a brief introduction to the concepts so that it will make a little sense when people talk about a relational database and 3rd normal form. There are entire courses on this topic, so again my goal is familiarity.

EXAMPLES TO LOOK AT:

Normalization (3rd normal form)
Student 4 table database
Student 4 table data needed We will work on this database.

TOPIC VIDEOS:

Introduction to relational databases
Example of an order relational databases
Access Student Database
1 to 1, 1 to many and many to many relationships

SMARTBOARD AND AUDIO NOTES FROM Spring 2019 and Fall 2019:

I think the Spring versions have a little more information, but I would look at all of them.
Relational database (4/16/19) Accompanying audio
Relational Database (4/16/19) Accompanying Smartboard presentation
Relational database in Access (4/18/19) Accompanying audio
Relational Database in Access (4/18/19) Accompanying Smartboard presentation
Relational database continued (4/23/19) Accompanying audio
Relational Database in Access continued (4/23/19) Accompanying Smartboard presentation
Databases (10/31/19 11:00) Accompanying audio
Databases (10/31/19 11:00) Accompanying Smartboard presentation
Databases (10/31/19 12:30) Accompanying audio
Databases (10/31/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Donation database you need to do
As always, check back...
Week #9
Week of March 18th

INFORMATION:

Want a Zoom time, let me know a few times that work for you! I will be available on Zoom at 11 on Saturday
The information about ASCII and numbering systems was presented last week - this is a continuation.
Last week I assigned you a mentor who is an alum from the CIS program at Bristol and is working in the field. This is an opportunity to ask questions and connect. I think it is one of the most important assignments.
This week we are finishing our quick look at numbering systems and codes.
Check back!

ASSIGNMENTS TO DO:

ASCII assignment
ASCII notes and assignment
Portfolio Project to start (must be done using HTML that you write): I want you to start creating an online portfolio. For CIS majors you can work on this throughout your time at Bristol and develop a portfolio to help you when you are looking for a job. For now we are going to do a basic start. You should make a title page with basic information and a link to a second page that should contain a menu with links to a database that you upload, two JavaScript problems you have written and other work for this or another course. You can certainly incorporate your introductory page from week #1.
The index or first page should have basic information. The second page should link to at least four things that you have done. You can put the work in the root of cisweb or you can put it in a folder. The address should be cisweb.bristolcc.edu/~yourusername/folder or directory if any/name of the page. Remember that the port is now 220. If it is an html page then it has a .html extension. The database has a .accdb extension. Check with me if you have problems. I want this by the April 25th
Check back!
Vacation Week
Week of March 11th
Also for most college students it is also catch up week. Please take advantage of the time if you need to get caught up. I will be available via email much of the time and I can set up Zoom times as well.
Week #8
Week of March 4th

INFORMATION:

Tentatively I am planning to do a help session at 8PM on Wednesday - check back and if you plan to come let me know.
I am going to be around this weekend, so I can also meet at 11:00AM on Saturday.
This week we are going to wrap up JavaScript and we are going to take a little break from learning coding and look at numbering systems. For those of you that bought the optional book, there are a lot of logic examples that you should reference. If you did not get the book some research on logic flowcharts and pseudocode might be helpful.
Numbering systems and code
This handout covers binary and hex well, but it was written over 20 years ago and the code information is historical and not current. We will look at 8-bit ASCII code which is not covered and look at the link below.
Reference for ASCII You can start looking this week, but the assignment on this will be next week.

EXAMPLES TO LOOK AT:

A few examples of conversion using binary, decimal and hex.

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

Numbering systems (10/22/19 11:00) Accompanying audio
Numbering systems (10/22/19 11:00) Accompanying Smartboard presentation
Numbering systems (10/22/19 12:30) Accompanying audio
Numbering systems (10/22/19 12:30) Accompanying Smartboard presentation
ASCII and portfolio (10/29/19 11:00) Accompanying audio
I forgot to turn on the recorder so I would suggest using the Audio and Smartboard from the 12:30 class. I did try to record some things from the beginning in a separate recording, but not so good...
ASCII and portfolio(10/29/19 11:00 first few minutes) Accompanying Smartboard presentation
ASCII and portfolio (10/29/19 11:00 rest) Accompanying Smartboard presentation
ASCII and portfolio (10/29/19 12:30) Accompanying audio
ASCII and portfolio (10/29/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Number conversions You must pass in the work to get a grade higher than C on this assignment
Rock, Paper, Scissors Program: Write the Rock, Paper, Scissors using JavaScript and get it running. I know there are a lot of models out on the web. I want you to write your own code. If you do code that I have not covered,you need to explain what you did and how it works. You are playing against the computer which should be a random number. I did a random number example in the guess number program.
Extra Credit: A loop in the Rock/Paper/Scissors program so that the user can choose to play again. There are problems with document.write in a loop because of browser changes, the choice of playing again is extra credit and will require some research - also I recommend alert as opposed to document.write)
Career and mentor paper: The mentors are professionals who went through the CIS program at Bristol and are now working in the field or continuing their studies. They have generously volunteered to be an email mentor to discuss career and skills with current students. This assignment will need you to interview your mentor. I want you to write a paper about careers in the computer field. There should be two parts to the paper: The first part should be an interview with your mentor about the work he or she does in the computing field or if your mentor is continuing studies in computing, ask about the degree program he or she is in and what they would like to do when they complete their studies. You should also ask your mentor about the soft skills they find are important and why. Your paper should contain information about your mentor's job or degree program with several quotes from your mentor. You should also include information and quotes from one of the panels of CIS alum The second part should be researching a career in computing that interests you and writing about what the job involves and the skills that are needed. The paper should include notes citing your sources (I would estimate that you need at least a couple of pages to cover the goals well). In addition, send me a list of the questions you asked your mentor. The paper is due on April 11th by midnight. If you have trouble contacting your mentor, let me know and pass in the mentor part late (the research part must be on time to get full points). If you are too far behind on work and you need to send me a lot of work, I may not send you a mentor until you are more caught up and proved you are participating in this course. If you do not get a mentor this week and you think you should have be sure to contact me so we can figure out any problems. I want to also note that a group of alum will hold a online panel discussion on April 4th on Zoom (noon), you can use that in your paper as well but it should be an add on - don't wait until them to get the paper well on its way!
Visit a tutor:I need you to visit one of the tutors for this course and have the tutor send me an email saying you were there. Want to make sure everyone knows how to connect!
Week #7
Week of Februry 26th

INFORMATION:

I am planning to hold Zoom meetings on Friday at 11 and Saturday at 11 - please let me know if you plan to come.
Remember that if you get something returned with errors that means you do not have a grade and you need to fix and resubmit.
This week we are going to continue with JavaScript so please continue looking at the rest of the examples under the JavaScript. Eventurally we will look at them all up through and including the series of Guess Game scripts/programs.
The book if you bought it is a reference book, check out the logic explanations.
Here is an online Zoom meeting on JavaScript (after the introductory material - I recommend it). Recording from 3/8/21 The passcode is oZ!^&30k

EXAMPLES TO LOOK AT:

Look at the JavaScript examples
For now we are skipping arrays but you should look at the rest.

TOPIC VIDEOS:

Final totals etc.
Math facts programs
Math facts continued
Guess game programs
Review of programs and comments on Rock, Paper,Scissors

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

More JavaScript (10/10/19 11:00) Accompanying audio
More JavaScript (10/10/19 11:00) Accompanying Smartboard presentation
More JavaScript (10/10/19 12:30) Accompanying audio
More JavaScript (10/10/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Alum Forum/Panel. Flowchart and Pseudocode test This is a test. I will accept it late, but late points will be subtracted. As always it is due the Thursday of the week after it was assigned - so in this case March 7th. . The flowcharts are my (not so successful) experiment with a drawing toy! Let me know if you have questions. Remember it is a test so no working with anyone but me (that includes tutors).
JavaScript Assignment 2
Check back!
Week #6
Week of February19th

INFORMATION:

I will do an introduction to JavaScript if you give me some possible days and times.
Would either 11AM Friday or a repeat at 11AM on Sat work for those who are interested? I will login at those times.

NOTES/EXAMPLES TO LOOK AT:

As always, be sure you listen to the videos. They go over the topics. For backup there are the Smartboard and audio from a previous class which are the lectures that I delivered in class - a lot of students find those very helpful.
Start the week by looking at the logic components and then move on to JavaScript. We will continue with topics like if and loops next week.
Some of the material on JavaScript will definitely be continued next week.
Be sure to go over the Topic Videos on JavaScript and the examples and again I recommend the Smartboard and audio from last year.
Our goal in the next few weeks is to be able to use logic to figure out how to solve a problem and then write a script/program with JavaScript.
The next topic is the introduction to JavaScript and above all else, I want you to understand the examples so that you to can write the code.

EXAMPLES TO LOOK AT:

Please look at the JavaScript examples at this address.
Specifically look at the examples up through if statements and next week we will move on through finaltotals.html and maybe beyond..

POWERPOINT PREPARATIONS:

IF flowchart, pseudocode powerpoint
Loop notes powerpoint

TOPIC VIDEOS:

Explanation of the Logic Powerpoint assignment
Explanation of the IF statement Powerpoint presentation
Explanation of the loop Powerpoint presentation
Introduction to JavaScript
Decisions in JavaScript
Decision where one thing has to be true and either of two others
Debug JavaScript in Firefox
Loops in JavaScript

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

Logic ifs and loops (9/26/19 11:00) Accompanying audio
Logic ifs and loops (9/26/19 11:00) Accompanying Smartboard presentation
Logic ifs and loops (9/26/19 12:30) Accompanying audio
Logic ifs and loops (9/26/19 12:30) Accompanying Smartboard presentation
Inclass ifs (10/1/19 11:00) Accompanying audio
Inclass ifs (10/1/19 11:00) Accompanying Smartboard presentation
Inclass ifs (10/1/19 12:30) Accompanying audio
Inclass ifs (10/1/19 12:30) Accompanying Smartboard presentation
Intro JavaScript (10/3/19 11:00) Accompanying audio
Intro JavaScript (10/3/19 11:00) Accompanying Smartboard presentation
Intro JavaScript (10/3/19 12:30) Accompanying audio
Intro JavaScript (10/3/19 12:30) Accompanying Smartboard presentation
JavaScript if and loop (10/8/19 11:00) Accompanying audio
JavaScript if and loop (10/8/19 11:00) Accompanying Smartboard presentation
JavaScript if and loop (10/8/19 12:30) Accompanying audio
JavaScript if and loop (10/8/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Logic PowerPoint assignment Play computer and determine the output.
First JavaScript assignment
Week #5
Week of February 12th

INFORMATION:

As always I am available to set up a Zoom meeting with you or with a group!
We are going to start looking at logic this week. Logic is truly the key to successful computing, it is at the root of instructing computers.
The optional book is a reference book so, if you got it use it to help you understand logic.
The first thing to do is the Practice exercise. I would listen to the video for the first one and make sure you understand and then I would try the second one alone before listening to the video. Finally you also want to go through the logic concepts and the file processing video.
As always I suggest listing to the audio along with the Smartboard from the previous classes.

EXAMPLES TO LOOK AT:

This week, we will go over some of the principles from the readings above and start looking at logic. We will work on the practice exercise below. Note that there are Smartboard and audio about these examples as well as Topic Videos.

Practice exercise
Practice continued

TOPIC VIDEOS:

Topic Video to go with example 1 in practice exercise
Topic Video to go with example 1 in practice exercise (youtube version)
Topic Video to go with example 2 in practice exercise
Topic Video to go with example 2 in practice exercise (youtube version)
Topic Video introducing some logic concepts
Topic Video introducing some logic concepts (youtube version)
Topic Video to go with file processing in practice continued
Topic Video to go with file processing in practice continued (youtube version)
Video introducing the 30 question assignment below. (youtube version)

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

Intro logic (9/24/19 11:00) Accompanying audio
Intro logic (9/24/19 11:00) Accompanying Smartboard presentation
Intro logic (9/24/19 12:30) Accompanying audio
Intro logic (9/24/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

30 question logic exercise Follow the logic flowchart and process the input, then tell me the output. You can just show the messages to cut down on the writing.
Another Logic Assignment
Week #4
Week of February 5th

INFORMATION:

I am going to be away for a long weekend, still checking my email periodically, but I decided to load the week of early.
If you would like to set up a Zoom meeting to go over anything, please let me know. I am available a lot this week.
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.
Sending a zip file can help.
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.
Introduction to SQL
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.

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
Types of software
Memory and RAM
Programming Process
Pseudocode and Flowcharts
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 2020
Access 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:

Database 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: This needs to be passed in by February 15th - remember I do not take late quizzes. Use my notes and the Internet for information. Quiz 2 Topic: Access
Since I messed up with the due date - typo - I forgot the 1, I will drop the I do not accept late quizzes for this one. For your own sake, you should still aim for the 15th of February.
Please check back!
Week #3
Week of January 29th

INFORMATION:

If you are interested in setting up a Zoom help session, please let me know.
Access is part of Office 365 and can be accessed there or it can be accessed through the CIS pool.
You can get Access by going to the Bristol website and selecting accessBCC. After you login in from the Bristol page you select Office 365 - Dashboard which brings up Welcome to Microsoft 365. On the screen over to the right is the Install apps button. Click on it and select Microsoft 365 apps. Access is part of the package. This tells how to find Access as part of Office365. It is for an earlier version released by IT but I have been assured it still gets the idea across. Access download using Office 365

Access is also available in the CIS VDI pool that we looked at last week.
Using Access in the CIS VDI Pool and putting it also on your computer
Essentially this gives you two ways to get and use Access.
There is a lot happening this week so do not hesitate to contact me if you have questions or need help.

EXAMPLES TO LOOK AT:

Example I used in video Bristol server
Example I used in video my server

TOPIC VIDEOS:

Video prepared for Zoom on January 25/26 on loading web page to cisweb
Using Access in the CIS VDI Pool and putting it also on your computer
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
More Access Queries (youtube version)

SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019:

There were two sections of the CIS120 last Fall (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:

First assignment: 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 go divide up the questions, I want everyone contributing their thoughts on each problem. You have two weeks to do this so due February 15th
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
Second assignment: This is an individual assignment Access Database Assignment on BCC College Resources This assignment must be done with the user interface covered in the notes and examples last week. 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. 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. Apprently there have been some name changes in programs I did not find - they periodically do that. So be creative - extension is the last four digits, for other things you can figure out a plan... 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 thta works Some not needed for query stuff can be blank.
Check back!
Week #2
Week of January 22nd

INFORMATION:

I would like to set up an optional Zoom meeting to go over uploading and or Access. If you are interested, give me some potential days and times.
This week I will have you load your page up to the server and then we will start looking at the concepts of a database and how to create one in Access. Loading the page to the server is complicated so please get in touch if you are having problems. Access is part of Office 365 and can be accessed there or it can be accessed through the CIS VDI pool. Check back later in the week for my postings about Access.
Again, there is a lot happening this week so do not hesitate to contact me if you have questions or need help.

TOPIC VIDEOS:

Loading up your page has some complications, so I want you to spend some time looking at the video notes. You are going to use Horizon for this upload so I would like you to read about some of the basics of Horizon.
Horizon (Janelle Arruda)
Then I want you took at this step by step video where I upload a file to cisweb using WinSCP which is available through Horizon.
Upload to cisweb
And another...
Loading to cisweb
Finally when you have it uploaded onto cisweb, you need to figure out the address to give to others to see the file or files you upload. There is a very short video on that.
See page in browser
If you get confused (I did too!) I want you to have time to work with me or the tutoring center.
If you wanted to do more with WinSCP you should look at the notes I left under Older Notes on WinSCP and cisweb.
OLDER NOTES ON WINSCP AND CISWEB: Before we started using Horizon.
These are notes about some of the things you can do when you are connected to cisweb.
In my notes I talk about cisweb.bristol.mass.edu. Things have changed and you should now use cisweb.bristolcc.edu and the port number should be 220.
You can also check the notes on the Smartboard and the accompanying audio as well as the notes below.
Again: To load things up on the Internet, we use WINSCP. Please read the WINSCP and cisweb information: (note that in my examples I use cisweb.bristol.mass.edu as the host and 22 as the port, we are now using cisweb.bristolcc.edu as the host and 220 as the port.
Here is information about using cisweb and WINSCP at BCC
Talks more specifically about portfolio We will be looking at making a portfolio later in the semester.
This is the address for WinSCP (you will be using WinSCP in Horizon so you do not need to download it) but some may want it at home.
WINSCP
Remember the host is cisweb.bristolcc.edu and the port is 220.

ASSIGNMENTS TO DO:

Assignment: Upload your web page(s) and images introducing yourself to the cisweb server and send me the address.
Don't forget that you need all the pages if you have more than one and all the images you used.
Quiz #1: Quick Quiz that is due next Thursday (Feb 1st). I DO NOT accept late quizzes.
Check back!
Week #1
Week of January 15th

INFORMATION:

Lots of information this week!
Intro to Spring 2024 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.
Check the help session for support!
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.html
HTML5list.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)
Starting a NEW HTML page
Starting a NEW HTML page (youtube version)
Introduction to HTML
Introduction to HTML (youtube version)
Continuing HTML and introducing CSS
Continuing HTML and introducing CSS (youtube version)
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 audio
First 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 next Thursday, January 25th. I would try to get it in sooner because their will be a couple of assignments next week. Your assignment for this week:
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 extra credit for having more than one page and linking them.
Note: You do not need to put your web page(s) on line this week. We will do that in the future.

Priscilla.Grocer@bristolcc.edu

Back to the Top
Return to home page