| Schedule by session | 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. |
|---|---|
| Unit #15 | You can have one week to work on the final. Let me know when you would like it. |
| Unit #14 |
This week we will look at Spreadsheets. First grade spreadsheet example Second grade spreadsheet example Assignments: Excel assignment |
| Unit #13 |
Please look at the PowerPoint presentations that deal with sequential processing and the one that deals with random processing.. Presentation on sequential update processing Separate speaker notes Sequential processing Presentation on random update processing Separate speaker notes Random processing This is a week to get caught up! You can do the sequential and random processing as a check off for extra credit. |
| Unit #12 |
If you have any questions about Visual Basic, let me know. This week we will look at relational databases, normalization, multiple files and indexes in Access and random processing. Please be sure to look at the two presentations under Access and SQL called Normalization and Relational Database using donor. You should also read the notes under relational database rules called relational database - normalization rules. Read the information in your textbook on relational databases and normalization (chapter #16) Assignments: For the assignment below, set up and populate the tables and do the queries. First Database assignment - student DB |
| Unit #11 | Please continue with Visual Basic. You need to look at the program examples on loops,
on the array, on the guess game and on file handling. Note that file handling is a lot easier
in version 6. If you are using a different version, let me know and I will give you other examples
to work with. Assignments: Second VB Assignment |
| Unit #10 | We are working with Visual Basic (version 6) this week. Please look at the examples, I will
post the assignment on VB. If you have a different version of VB, you can use it - just let me know! Assignments: This quiz is based largely on the reading. Just checking to make sure you are doing the reading. This quiz should be done individually with no discussion with other students. It is given on the honor system with my trust that you will not ask for or receive help from anyone other than me. You may consult books (I recommend your text book) and information on the web. If you feel that you should clarify your answer or clarify you interpretation of the question, please write a short explanation. Textbook quiz This is the answer sheet you must use to submit the quiz: Textbook quiz answer sheet Textbook quiz answer sheet (word version) The Textbook quiz is due April 17, 2008 (late penalties apply and no resubmit) Visual Basic Assignment:The algorithm assignment was originally given in week #5. You then wrote those programs in JavaScript. Now I want you to write them in Visual Basic. |
| Unit #9 |
Start looking at computer codes. A good source is
Computer Codes Also, please look at some basic information from the text. Please look over chapters #8, #10, #11 and #14 in the next couple of weeks. I recommend reading these chapters in addition to chapters #1 - #6. Alice can be downloaded from Alice (go with version 2) Please watch tutorial 1 about the ice skater under Alice tutorials (within the package) - there is also a presentation at my site. I want you to look at this PowerPoint presentation on Alice: Using Alice Zipped version of Using Alice for download As you read about object-oriented programming, relate it to Alice. That is the style used in Alice. Assignments: Alice Assignment: I want you to write a program using modules/methods, 2 kinds of loops, an if/else and an if/else with an embedded if/else. I want you to do a startup/housekeeping/initialize module/method, a process module/method that handles other modules/methods and a wrapup module/method. Look at my examples (zipped copies of the programs) and PowerPoints on ballsbounce to help with this assignment. Computer Code Assignment: a) Write the words LAZY DOG in ASCII code. b) Write the number 279 in ASCII code. c) Write the sentence, THE QUICK BROWN FOX JUMPED OVER THE LAZY DOG in the hexidecimal translation of ASCII. d) Write the same sentence using the decimal translation of ASCII. e) What does this decimal translation of ASCII say? 85 65 67 65 84 73 79 78 f) What does this hex translation of ASCII say? 42 52 49 53 54 4F 4C |
| Unit #8 |
We will be dealing with numbering systems this week - a little break from programming while you finish your
JavaScript assignments and work on your portfolio. Here is information about using cisweb at BCC Talks more specifically about portfolio Numbering systems and code Assignments: I want you to put up the beginnings of a portfolio written in HTML. If you are new to HTML, you are welcome to use my templates as a starting point. They are under examples at the web site. However, if you turn in something that has used my templates with very little modification, you cannot get an A on this assignment. If you are comfortable with HTML or would like to learn more about it, please work to make an interesting and professional site. All sites should be prepared with the idea that a future employer will be looking at it and evaluating you in part based on its content. Please note that this is an opportunity to earn extra credit if you do a really nice portfolio. Things you should include: a resume (you do not have to put personal information, you can use first name and the schools address etc - you do not have to put identifying information on the portfolio at this point unless you are comfortable with doing so). I want a picture of you - a face image or another image that would make sense to have on a work oriented portfolio. I want a list of computer course you have taken. I want you to link to a couple of examples of your work (let's try for five examples of work related to computing). You should include one working program written in JavaScript and you can upload an Access database. This is a long term project - first draft due in three weeks. Binary and Hexidecimal Assignment |
| Unit #7 | We are going to move on to looking at a little more about HTML. The goal is to start
you creating a portfolio web site. We will spend more time on HTML next week. Look at my notes on the portfolio and my HTML notes under examples. We are going to start to look at StarLogo. You will find a presentation under presentations and you will find a list of StarLogo commands under notes. Information about LOGO procedures is also available under notes. Information about LOGO If you do not want to work in the labs, you will need to download and install a version of StarLogo which is available at: StarLogo Please look at the PowerPoint on LOGO and the handout on LOGO procedures. Assignments: Assignment if you have not worked with LOGO: LOGO assignment:Logo assignment Copy the code you used and paste it into notepad and send it as an attachment along with the three LOGO projects. Assignment if you have worked with LOGO: Do a project (or projects) that involves using an if, an if with an else, a loop and a procedure. Send me the project in logo and the code you used separately in notepad. I am looking for you to explore some of the capabilities of LOGO so experiment with procedures that have a variable and a couple of other things that look interesting. For those who already know a little HTML and have started the portfolio, I am looking for an expansion of that project. |
| Unit #6 | Please read chapter #6 in the text book. I have gotten questions in the past about rounding in JavaScript. The following code would round a field called ans to two decimal places: ansrounded = Math.round(ans*100)/100; Some more JavaScript examples to look at: simplejsif.html simplejsifloop.html simplejsifelse.html simplejsifelseloop.html simplejsand.html simplejsandloop.html We are going to continue with JavaScript. Please look at the logic and code for the guess game. The JavaScript programs are: Guess number, one guess Guess number, one game Guess number, multiple games Assignments: Algorithm assignment #2 |
| Unit #5 |
Please read chapters #4 and move on to chapter #5. The book is providing supplemental material to what we are doing in
class and is also important. Pseudocode examples These go with last weeks in class exercise. We are going to start looking at JavaScript this week.I would like to have you look at the JavaScript examples at my site. We are going to start learning to program in JavaScript Practice exercise: Practice exercise we already looked at Note that answers to the practice exercise are posted as a SmartBoard presentation Problem #1 in JavaScript (version 1) Problem #1 in JavaScript (version 2) Problem #2 in JavaScript (version 1) Problem #2 in JavaScript (version 2) I took the two examples in the practice exercise and converted them into a program written using JavaScript within HTML. I would like you to look at the examples - you do not have to understand the language rules to see the basic structure. Next I want you to start looking at the JavaScript programs. Go in under programs and scroll to the bottom. Assignments: Please write out the solutions to the algorithm problems in words and then in a second chart test them with numbers: Algorithm assignment Now take the problems in the Algorithm Assignment and write them in JavaScript. You need to get them working so that if you put in test numbers, you see the correct results. |
| Unit #4 | Please read chapters #3 and start reading chapter #4 this week. We will talk about complete programs and other topics in these chapters. Flowcharts/pseudocode Check back and see where we are and if I post anything additional.! Assignments: You need to take this quiz. Note that there are no resubmits on this quiz and the quiz should be done individually. Quiz Please submit the quiz answers on the answer sheet (it is given below in html and word): Answer sheet (html version) Answer sheet (doc or word version) Write the flowcharts and pseudocode for four of the problems in the flowchart/pseudocode example above. If you just do the first four, the maximum grade is a B. You need to do some of the more complicated ones for an A. Note that I want everyone to do #4. Extra credit if you do more than four. |
| Unit #3 | Please look at this PowerPoint: Presentation on structure (focus on loops) Separate speaker notes to accompany presentation structure (focus on loops) Practice exercise: Practice exercise The answers to the practice exercise are in the SmartBoard notes from last semester - take a look. Assignments: Please look at the practice exercise before you start this homework. Logic quiz (word format) Note: The assignment below will be given next week (the best we will get to this week is starting it). Here is another assignment, that we will look at some Tthis week and into next week. If you have finished the quiz above work on it. Logic assignment Will be worked on in class for in class students - required for all students. In this assignment, you should play computer and step through the logic and create the report as you go. This assignment should NOT be done using Access. I would suggest you write the answers in word. |
| Unit #2 | If you have any questions related to homework, contact me! Please be sure to look at the first two presentations under Access and SQL: Presentation on using SQL queries in Access Separate speaker notes to accompany fusing SQL queries in Access Presentation on SQL in Access - a little more Speaker Notes to accompany SQL in Access - a little more I have also referenced some tutorials on the del.icio.us site. Please read chapter #2 in Programming Logic and Design. Depending on time, I may some time this week talking about the concepts in the book. Look at the second PowerPoint presentation under Logic including Pseudocode and flowcharts that is on logical if structures. Presentation on logical if structures Separate speaker notes to accompany presentation on logical if structures Please look at the presentations on Forms and Reports - I want you to include them in this project using the wizard. Assignments: Access Design and SQL Project Please paste the SQL into a word document and pass that in as well! When you pass in an assignment, please put your name, course and which assignment it is in the subject line. Work Sheet on if statements This is just a check off assignment I want you to give it a try and I will get back to you with comments As always, please check back! |
| Unit #1 | There are 15 units of work during the summer course to match the work done during the Fall or Spring semester.
So, during the summer, there are some weeks where you need to do two units of work. I strongly recommend, that
you do the extra units at the beginning to give yourself some flexibility. Please check back often, I may add things during the week.
If you need help, check my on campus schedule on the home page of this site or contact me via email.
Please use the email address I sent you with information about the course. Please read chapter #1 in Programming Logic and Design. If you can't get the book, next week is fine. The first topics do not rely on the book. We are going to start out working with Access. The version you use is up to you - in the labs we have several different versions. Most of the references I have at my site will be for Access 2003 or earlier versions that function in a similiar manner. Microsoft offers free training courses for Access 2003 and Access 2007 off this site: Microsoft Training in Access If you are not comfortable creating a table in an Access database and then creating a simple query, you should see the Power Point presentation on Assignment #1 / Access which is under Presentations. You should also down load the Assignment #1 Access database which is under Examples - Access database for asgn1. Note the information about Assignment #1 above is for reference only - it is to help you with your first assignment! Note also that many of the tutorials are in different versions of Access. Prior to Access 2007, they all look very similar. Starting with Access 2007 there are some real changes. There are several Access tutorials available on the Web site: Links to Access If you do not know the basics of Access you can also see me and I will try to locate a book on the topic for you to use. I posted some notes on using Access under Notes and Handouts but most of them are more than you need to know right now. You can also check the del.icio.us site (Access tutorials) Practice exercise The solution to the database is on the web - the queries vary. Note: Some assignments require software. If you are a distance learning student you have to make arrangements to access the software needed. For students who need Access, it is available through the MSDN Alliance. Click on this link to get information: MSDN Alliance Software You will receive an invitation from the college to the MSDN alliance (probably next week). I leave up the Smartboard Notes and audio lectures from previous semesters since much of the material is the same. You can go to the Smartboard and audio notes and get information on topics delivered last semester.You should look up Smartboard presentations on topics that you want to go over. Assignments: Note: Assignments are not due until the week after they are assigned. You are welcome to pass them in early. Again, remember that you will need to do two units of work some weeks! Game collection table to be developed Please remember that I do not want embedded spaces in the field names and I do not want all field sizes for text fields to default to 50 or the higher Access 2007 default. Please check back frequently to see if I have added anything! |