FS104 Computer Applications

Syllabus

Course Description: This course introduces students to the basic operation of computer hardware. File management and storage, basic word processing, spreadsheet, and database techniques are explored. The use of scanners, printers, external drives, and other equipment are examined. Students are introduced to the Internet as a research and networking tool.

Download the Word version of your syllabus here


Course Length: Summer 2010. Section B, 11 weeks. Monday July 12, 2010 to Monday September 20, 2010, from 8 a.m. – 12 noon, Room 010. Punctuality is expected. Points are deducted for excessive (more than 3) tardies.

Course Competencies:
Upon successful completion of this course, the student should be able to:

  • Operate a personal computer using current operating system interfaces
  • Use correct terms and definitions to describe the operations and applications of computers
  • Summarize hardware characteristics based on configuration, compatibility, processing speed, cost, and rendering speed
  • Match appropriate connection devices with external equipment
  • Compare and contrast operation systems
  • Describe and apply the major steps in the “imaging chain”
  • Produce documents using word-processing, spreadsheet, and database tools
  • Transfer data across platforms
  • Correlate keyboard functions with menu operations
  • Define characteristics of peripheral communications standards
  • Demonstrate cross-platform applications
  • Apply database and spreadsheet skills
  • Protect data and equipment through the use of virus utilities
  • Perform basic disk maintenance and data retrieval operations

Use and manage computer hardware peripherals for input, output, and storage

  • Operate difference kinds of peripheral hardware, including printers, scanners, external drives, and Wacom tablets
  • Employ appropriate input-output devices

Use an Internet browser

  • Identify the operational characteristics of the Internet and intranets as these compare to standalone systems

Manage and organize files

  • Create and organize directories, folders, and documents using file management techniques

Course Prerequisite(s): None

Required Texts: Microsoft Office 2007 by Cashman, Shelly (Cengage), ISBN 1-4188-4325-3

Materials and Supplies: Storage drive, notepad and pencil or pen

Estimated Homework Hours: 4 Hours per week

Technology Needed: PC and Mac computers will be used or discussed, access to Microsoft Office and Adobe Creative suite software, scanner, and the web.

Top of page

List of lectures and labs

Weeks: 1 2 3 4 5 6 7 8 9 10 11

Students are responsible to check this at least one day prior to class. Here you will find weekly lectures, homework assignments, and your standing within the class. Please email me at sharon@casabasa.com if you have any questions.

Week 1: July 12, 2010

Complete the student survey. Review of the school’s emergency evacuation procedures. Review of course and requirements. Contact is skaitner{at}aii.edu or sharon{at}casabasa.com.

Lecture:

  • Review of the school’s emergency evacuation procedures and overview.
  • Overview and Introduction to course.

Lab:

  • Review of the basics of Microsoft Word.
  • Create a flyer: Announce your services. Attention to design, visual hierarchy, and generally, getting acquainted with the software
  • Homework:

    • Review your book, paying special attention to File Management and the information on Word.
    • Read the Microsoft article: Steps to help secure your pc computer.
    • Bring your USB to class next week. We will be working with Photoshop and if you have any photographs or digital images saved, please bring them. On the otherhand, if you have any printed artwork you would like to scan and save on your USB, please bring as well. We can review the use of the scanner in the classroom.
    • Take this online Word quiz until you pass with 100%. Print results and bring to class.

arrow links to top of page

Week 2: July 19, 2010

Homework:

  • Create a logo. Don't worry if it's not exactly right the first time; logos take time to fully develop. Adobe PhotoShop (Word document) instructions courtesy of AI faculty.
  • Research, write and proof project 4 of Cases and Places, pg. WD143, about the month and year you were born. Print and bring to class next week. Be sure to do in the MLA format.
  • Bring book to class next week.

Week 3: July 26, 2010

Lecture:

  • Microsoft PowerPoint presentation software.

    Lecture:

    • Introduction to PowerPoint. How to put a presentation together.
    • General intro to grid systems.

    Lab:

    • Collecting images to create a PowerPoint presentation about you: resources available to you.
    • Creating and Editing a presentation: Using your book and your neighbors, work through Chapter 1 of your text.

Homework:

  • Using Chapter two as reference, create a presentation about YOU.
    • minimum 6 screens including a title and credits page. Please include your logo.
    • include at least one of each: photograph, sound clip, shape, demonstration of Bold and drop shadow applied to your name, clip art.
    • transitions between slides
    • Use at least 4 images (including one image of yourself, manipulated in Photoshop) that you have created

 

Week 4: August 2, 2010

Introduction to HTML.

Lecture:

  • About Coding

Lab:

Homework:

**All homework is due by week 5 to receive any credit at all. Remember, you only qualify for full credit if the work has been turned in on time. If you have not already done so, please email your url.

arrow links to top of page

Week 5: August 9, 2010

Lecture:

  • All past work is due today by midnight. No work from first half of quarter will be accepted after today. No exceptions.
  • Midterm Test

Lab:

  • 45 minute lab for any final "touch-up" to powerpoint projects. Powerpoint rubric.
  • Powerpoint presentations - please make sure your logo is included. Stand up straight, enunciate clearly, be proud and show off! Let us know anything special you did or learned in creating this presentation. SPELL CHECK!
    • Remember, your grade depends upon meeting the criteria listed week 4, use of the technology, good grammar and spelling, and your presentation. But have fun too. You worked hard on this!

Homework:

  • Complete Chapter One of the Excel 2007 up to inserting the 3d clustered column. Save your work to your USB and bring to class next week (due date).
  • Bring your text to class next week
  • Bring your web page and logo to class next week

 

Week 6: August 16, 2010

Lecture:

  • continuing with the .html page from week 4
  • Formulas, Functions, Formatting, and Web Queries. Walk and Rock chart due.
  • Presentations of web pages
  • Security on the Internet: a discussion of how to keep yourself safe on the Internet
  • Best Practices.

Lab:

  • As a group, we will begin Cases and Places, pg. EX156, Design and Create a Weight-Loss Plan Worksheet.
  • Animating your logo tutorial. Add to home webpage (index.html).
  • lab time to upload logo to your index.html page and to work on your web page

Homework:

  • If not completed in class, finish your weight loss worksheet and bring to class next week on your usb.

Week 7: August 23, 2010

Lecture: Introduction to data management software.

  • Project 1 page AC2, Access, all together in class.

Lab:

  • In Access, Project 2 "Querying a Database Using the Select Query Window". This is completed together in groups.
  • Take the Practice Test. If you score no more than 1 incorrect, show me the test and Project 2, and you will have completed your homework.

Homework:

  • Complete and save Project 2. Email your results for Practice Test if not completed in class.

arrow links to top of page

Week 8: August 30, 2010

Dreamweaver and XHTML: creating a website

Lecture:

  • An introduction to Adobe's Dreamweaver software, industry standard for creating websites.

Lab:

  • In Dreamweaver, we will create portfolio.html and link together with your home page, index.html.
  • Upload both pages onto your ols account website.

Homework:

  • Continue work on your website. Be sure to include at least 3 examples of your own work. Make one additional page for your artist profile and artist's statement. Due as your final project, week 10.

Useful Links:

Week 9: September 6, 2010

 

Labor Day holiday American flag

Homework:

  • Send me an email telling me why you're pleased with all you've learned this quarter. List as many new things you know now that you didn't know on the first day of class, that you can. 1 extra credit point to whomever lists the most.
arrow links to top of page

Week 10: September 13, 2010

Lecture:

  • [Final Exam]

Lab:

  • lab time
  • ALL HOMEWORK EXCEPT FOR WEBSITE IS DUE TODAY

Homework: Continue work on final project. Remember to spellcheck and to pay attention to details. Need additional help? Check out a lynda.com subscription at the school library.

Week 11: September 20, 2010

Lecture:

  • Final presentations

Lab:

  • Presentation of web sites

Homework: none

 

Logging into your personal grade

Please remember that the software I uses a tally of total points of a possible 100. You will not see the grade of "F" change until you are way into the quarter, somewhere around week 8 or 9.

Class Standings

Click on this individual score link to access scoring information on your completed projects.  Enter your name and id (password) exactly as you provided in the student survey.

I upgrade my grades every Sunday, usually no later than 2 p.m. I may update points for work received after this time, but before 7 p.m. only.

If there are any questions at all, please feel free to email me. I usually respond the same day and sometimes immediately, or at least within the hour.

If you have any problems, email me.

How you are graded and points assigned:

arrow links to top of page

Grading rubric - this is the worksheet that I use to grade your final project. It is a combination of this and individual assignments, attendance and participation that equals your grade.

Criteria by which you and your projects are graded for this course. Please see me if you have any questions.

Attendance and Class Participation Policy - Attendance and class participation are 25% of the final grade for the course. Students will be expected to attend class as well as act as active participants in class lectures. This is worth 10% of your overall grade. 5% is awarded for perfect attendance, recognizing that you cannot learn if you do not attend, and how difficult it is to do. This is a sign of excellence.

  • - 10% actively participation in daily lectures/labs - this is the minimum expectation
  • - 5% for perfect attendance
  • - 10% classroom collaboration - helping each other, asking questions, presenting solutions, sharing knowledge. There are regular acknowledgements and points given throughtout the quarter. Please refer to your individual weekly schedule for more details.

Assignments and homework are graded by points for a total of 45% of your grade. Usually the homework is a demonstrated skill, like emailing me your url. With this assignment, you are telling me that you can use the email, know what a url is and how to accurately send a link. Usually, I have more than one goal with an assignment, and each assignment builds on the previous.

Working from the chapters of the book is also a demonstration of skill. It shows whether or not you understand what you are doing. It can also demonstrate comprehension, organization, study habits, creativity and artistry.

Midterm and Final tests and presentations are a combination of tests and projects. The midterm test is a check for knowledge on both our parts. The final test demonstrates your hard work, skill and knowledge gained in this class.

Final Project Requirements

  • minimum three connected web pages: Home, About Me, Portfolio
  • navigation bar is consistent on all three pages, and each section is marked by an up, down and over feedback
  • all images are optimized for the web and use the alt attribute
  • all web pages are titled and there are no misspellings (in Dreamweaver, check spelling is under Commands)
  • the Portfolio section must contain a minimum of 4 graphics or photographs that you created - no pirated work allowed
  • your logo and branding are clear
  • well spoken pages created with care will receive higher points than pages sloppily done

These items total 30% of your grade.

 

 

 


Student information - Summer 2010

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

web site here

 


 

Your class standings listed below are meant to show how you compare, on average, with your fellow classmates. Items influencing your points include attendance, active participation, and timely (and accurate!) homework received. Plus your grades on tests and the final project.

 

Student class standings

ID T Abs Standings
399075 0 0 17.0%
394694 0 0 17.0%
336384 0 0 16.0%
354729 0 0 16.0%
362436 0 0 16.0%
359521 0 0 16.0%
6464 0 0 16.0%
215172 0 0 16.0%
384696 0 0 16.0%
2417 0 0 14.0%
375288 0 0 14.0%
375873 0 0 14.0%
0808 0 0 12.0%
393664 0 0 11.0%
1214 0 0 11.0%
377327 1 0 10.0%
2332 0 1 10.0%
363178 0 0 9.0%
369116 1 0 9.0%
375875 0 0 9.0%
359394 0 0 9.0%
392118 0 1 8.0%
396024 0 1 1.0%

 

Interesting readings

return to top of page

return to top of page

  • ~ peace, polka and piwo