10:00 - 10:50; Monday, Wednesday, Friday; McMullen 101
Instructor:
Dr. Kevin Lillis
429 Ambroe Hall,
LillisKevinM
at
sau
dot
edu
, 309-269-8493
This course is a survey of computer systems and the role of the computer in different disciplines. Applications covered include an office suite (word processing, spreadsheet, and database), web browsing, and Internet research.
Textbooks, Syllabus, Assignments, Announcements, Office Hours, Prayer Before StudyMicrosoft Office 2007: Introductory Concepts and Techniques, Windows XP Edition
by Gary B. Shelly, Thomas J. Cashman, and Misty E. Vermaat
ISBN 141884327X
Available at
Amazon.com
Tomorrow's Technology and You, Introductory 9th edition
by George Beekman and Ben Beekman
ISBN 013504510X
Available at
Amazon.com
| Number | Assignment | Points | Due |
| 1 | Download the portable application called Notepad++. Use this program to write a plain text document containing
information about yourself. This information will be turned into a web
page later on. The text document should include:
| 10 | Fri 8/28 11:00 a.m. |
| 2 | Using the HTML Reference discussed in class, turn your text document from assignment 1 into an HTML page. The name of your web page must be index.html. For this assignment simply add the html, head, and body tags. You should also include a title tag in the head of your web page. You can separate your paragraphs using the br tag. | 10 | Mon 8/31 10:00 a.m. |
| 3 | In this assignment you will finish your personal web page that you started in assignment 2. Modify your web page to include:
|
10 | Wed 9/2 10:00 a.m. |
| 4 |
Complete Cases and Places exercise 4 on page WD 72 - "Design and Create a Flyer that Advertises You". In order to complete this assignment you will first need to work through Word Chapter 1. Note:You will only be able to submit this homework once on Blackboard. So make sure you have the Word document looking exactly the way you want. And then make sure you attach the correct file when turning in your homework. |
15 | Fri 9/4 11:59 p.m. |
| 5 | This was the in-class homework assignment. | 10 | Wed 9/3 10:50 a.m. |
| 6 | Layout the design for your Web site using storyboarding. This assignment can be done by hand and turned in at the beginning of class on Friday. As a minimum your site should include:
|
10 | Mon 9/14 At the beginning of class |
| 7 | Save your MS Word document from assignment 4 as a "Filtered HTML" file. | 5 | Fri 9/11 11:59 p.m. |
| 8 | Build your Web site on your flash drive. This includes the following:
|
15 | Mon 9/14 11:59 p.m. |
| 9 | Publish your Web site on the CIS2 server. To to this you will need to download and install the Portable App called Filezilla. | 10 | Tue 9/15 11:59 p.m. |
| 10 | Complete the Chapter 3 tutorial in the Office 2007 book. The turorial starts on page WD 146 and goes through page WD 204. There is nothing to turn in for the tutorial. Once you have completed the tutorial, complete Cases and Places exercise 4 on page WD 213 - "Create Your Resume and Cover Letter for a Potential Job". Turn in your Word documents from this exercise through Blackboard. Before you turn in this assignment, I strongly recommend that you bring your resume to the Resume Drive-Thru that the Career Center is holding on Monday, Tuesday, and Wednesday of this week. It is from 9:00 am to 6:00 pm on the 2nd floor of the Rogalski Center. |
15 | Wed 9/16 11:59 p.m. |
| 11 | Check local newspapers and online employment sources to find three additional advertisements for jobs relating to your major. Use the techniques discussed in class to convert your cover letter (and resume, if applicable) from assignment 10 into a merge document using this new data. For this assignment you are to turn in two MS Word files: the merge document, and the document containing the data. | 15 | Mon 9/21 11:59 p.m. |
| 12 | In-class binary number assignment. This assignment will be handed in at the end of class on Wednesday, 9/23. | 10 | Wed 9/23 at end of class |
| 13 | Take-home binary number assignment. This assignment will be handed in at the start of class on Friday, 9/25. | 20 | Fri 9/25 at start of class |
| 14 | Complete the Excel Chapter 1 tutorial in the Office 2007 book. The turorial starts on page EX 2 and goes through page EX 69. There is nothing to turn in for the tutorial. Once you have completed the tutorial, complete In the Lab Lab 3: College Cost and Financial Support Workskeet, which starts on page EX 77. Turn in your Excel documents through Blackboard. |
15 | Wed 10/7 11:59 p.m. |
| 15 | This assignment deals with credit card numbers. It you were to enter your credit card number wrong (typically by swapping adjacent digits, like 43 for 34, or getting pairs of the same digit wrong, so 899 becomes 889) then someone else could end up being charged for your purchase. To help prevent these simple typing errors credit card numbers are self checking. This means that a simple check can be preformed to see if the card number entered is valid or invalid. The check goes like this: Take an imaginary Visa card number 4000 1234 5678 9314 First we take every other digit in the number, going from left to right, starting with the first (i.e. the odd-numbered positions), and double it. This gives the numbers 8, 0, 2, 6, 10, 14, 18, 2. Where there are double digits in the resulting numbers (like 10, 14, 18) we add the two digits together to get (1, 5, 9), which has the same effect as subtracting 9. The list of doubled numbers now reads 8, 0, 2, 6, 1, 5, 9, 2. Now we add them together and then add all of the numbers in between (i.e. the even-numbered positions) that we missed out the first time (0, 0, 2, 4, 6, 8, 3, 4). This gives the sum, in order, as 8 + 0 + 0 + 0 + 2 + 2 + 6 + 4 + 1 + 6 + 5 + 8 + 9 + 3 + 2 + 4 = 60 In order for the card number to be valid, this number must be exactly divisible by 10, which in this case it is. Whereas, if the card number was 4000 1234 5678 9010, then the same calculation would have generated the number 53 and this number is not exactly divisible by 10. Assignment: Create an Excel spreadsheet that allows you to enter a 16 digit credit card number into a single cell and uses the above procedure to display a message saying whether the card number is valid or invalid. |
15 | Fri 10/9 11:59 p.m. |
| 16 | Write out three questions you have from reading Chapter 4 of the Beekman textbook (that's the skinny book). If you have no questions, write out three things you found particularly interesting. Your questions should be typed in MS Word and turned in using Blackboard. | 10 | Sat 10/24 11:59 p.m. |
| 17 | Complete the Excel Chapter 2 tutorial in the Office 2007 book. The turorial starts on page EX 81 and goes through page EX 144. There is nothing to turn in for the tutorial. Once you have completed the tutorial, complete Cases and Places number 3: Create a Fund-Raising Analysis Worksheet, which starts on page EX 158. Turn in your Excel documents through Blackboard. |
15 | Mon 10/26 11:59 p.m. |
| 18 | Write out three questions you have from reading Chapter 5 of the Beekman textbook (that's the skinny book). If you have no questions, write out three things you found particularly interesting. Your questions should be typed in MS Word and turned in using Blackboard. | 10 | Mon 11/2 |
| 19 | Complete the Excel Chapter 3 tutorial in the Office 2007 book. The turorial starts on page EX 161 and goes through page EX 228. There is nothing to turn in for the tutorial. Once you have completed the tutorial, complete Cases and Places number 3: Projected Used-Truck Savings, on page EX 246. Turn in your Excel documents through Blackboard. |
15 | Wed 11/4 11:59 p.m. |
| 20 | Create an HTML document that contains the tables from Exam 2. Your HTML tables don't have to match the Excel table exactly, but they should be close. You should use the three colors (red, green, blue), alignment should match (left, right, center), and the column widths should be close. You can use standard HTML borders though. Your HTML tables do not need to contain formulas that calculate the numbers shown. Please turn in this assignmet by publishing it to your personal web site you created for this class. |
15 | Sun 11/15 11:59 p.m. |
| 21 | Create the Excel spreadsheet from Exam 2. Please turn in your spreadsheet via Backboard. | 15 | Wed 11/18 11:59 p.m. |
| 22 | Save your Excel spreadsheet from Homework Assignment 21 as a web page and publish it on your personal web site for this class. | 5 | Wed 11/18 11:59 p.m. |
| 23 | Create a PowerPoint 2007 presentation using the concepts from the two PowerPoint chapters in the Office 2007 book. The topic of the presentation is left up to each student. | 10 | Thu 11/19 11:59 p.m. |
| 24 | Publish your PowerPoint presentation from Homework Assignment 23 as a web page and publish it on your personal web site for this class. | 5 | Thu 11/19 11:59 p.m. |
| 25 | Complete the Access Chapter 1 tutorial in the Office 2007 book. The turorial starts on page AC 1 and goes through page AC 64. There is nothing to turn in for the tutorial. Once you have completed the tutorial, complete Cases and Places number 3: Design and Create a Resturant Database, on page AC 71. Turn in your Access database through Blackboard. |
15 | Wed 12/2 11:59 p.m. |
| 26 | Create the database for students and advisors discussed in class. The database should have tables for students, advisors, and majors. Provide input forms for the student and advosor tables. | 15 | Wed 12/2 11:59 p.m. |
| 9/26/09 | After talking with students after class I realized that some of you may not be familiar with turning in homework through Blackboard. Therefore we will step through this process on Friday. This means Homework No. 1 is due at 11:00 a.m. on Friday. You should have the text file prepared and ready to turn in at the beginning of class on Friday. |
Emily Block
Miguel Calvillo
Brett Dahm
Deanna Dippolito
Steve Freeze
Mark Gemino
Jason Harris
Nichole Henggeler
Steve Herbert
Brian Jones
Lance Kennedy
Andrew King
Alisha Kjormoe
Lynsey Larson
Ann Lustig
Katie Matheny
Brett McGinnis
Pat Merritt
John Rowe
Chrissie Steljes
Alex Waterkotte
Maureen Wetzel