Description: Students will be exposed to a wide variety of computer-related topics and issues. The focus of this course will be the use of word-processing, spreadsheets, databases, and graphics in an integrated approach using Microsoft Office Suite. Simulations and applications are used throughout course to provide a real experience of the use of technology in our society. This course is designed to give the student a comprehensive understanding of a variety of Windows applications. Applications range from Microsoft Word, Access, Excel, and PowerPoint software programs. Internet exploration and Web page design will be incorporated throughout the course. Hands-on activities and applications will be used to provide real experiences of each software package. This course is designed to meet the needs of the varying levels of students from the beginning user to the most advanced computer user. The skills learned in this course are practical and can be applied toward all core curriculum areas as well as personal needs.

Prerequisites:
Keyboarding Skill
Access to computer outside of class (recommended)

Course Overview:
*The course overview is subject to change.

Office Basics 2003
Internet Basics
Microsoft Word
Integration-Word and Web
Microsoft Excel
Integration-Excel and Web
Microsoft Access
Microsoft PowerPoint
Office Integration

Course Format:

Lecture/introduction of Topic
Notes
Create application together
Create applications independently
Written Test/quiz
Production Test

Expectations:
Classroom

Be Respectful
Be prepared to learn
Follow all school rules

Supplies
Folder for graded assignments

Computer Lab

• Must have AUP on file
• No data disks/CDs/DVDs allowed without teacher permission
• No loading programs or files in your locker
• Internet and e-mail use must be class related
• No chats, games, etc.
• No sharing files
  1st offense failure on assignment
  2nd offense failure for 6 weeks

Evaluation:

• The majority of assignments are graded on a 10 point scale and grades are determined based upon the accuracy and proper formatting of documents
• Each grading period you will also receive an assignment completion grade. You will receive 5 points for every assignment that is submitted.
• Example: If 10 assignments have been submitted and graded, and you completed 8 of the 10 assignments you would earn 40/50 on assignment completion, which is an 80%. If you earned 10 points for all of the documents you would have 100%. This would average to a 90% on in class assignments.
• This grading method is used due to the varying skill levels in class.

In Class work/Homework--40%
Homework is not accepted late

Written quizzes/exams--20%
Ojective written exams that consist of T/F, MC, Short Answer, Essay

Production exams--utilizing software programs--30%
computer exams completed using various software programs learned. Students are given a problem and must complete in the designated time.

Participation--10%
Based upon attendance, behavior, work ethic, meeting deadlines, daily work grades.

Grading Scale:
6 Weeks grading scale
A+ 100
A 90-99
B 80-89
C 70-79
D 60-69
F 50-59

Semester Grades are figured based on percentages. It is important to do the best you can each grading period. A 59% does not average the same as a 25%.
Example: 90%, 90%, 25% = 68%
90%, 90%, 59% = 80%

Semester grades

Each 6 weeks =30%
Final = 10%

WELCOME BACK

REVIEW OF FINAL EXAM

Crash course in Powerpoint

What we will learn about today:

panes
views
orientation
navigation
running slide show
grayscale/Black&White
blank Slides
slide layouts
add slides
placeholders
rotate
textbox
design template
color scheme
slide backgroud
replace fonts
clipart & photographs
eidt clipart
slide transitions
animations

The culminating activity for this Unit will be to create your own presentation. You will be allowed to select your own topic. There are a few expectations but the sky is the limit on your topic.

1. You must research something or someone you do not know anything (or very little) about.

2. Your topic must be something worth learning because you will be presenting to the class.

3. Your topic must be approved and appropriate.

More details will be provided later but you should be thinking about your topic.

Powerpoint Lesson 3

Outlines
Summary Slide
Hide Slides
Link Slides
Format Bullets
Footers
Slide and Title master
Apply slide masters
Template
Custom Show

Continue/Review creating custom shows in Powerpoint. See topics above.

Pick topic day and include 5-7 main points you plan to include in your presentation.

Begin to explore websites that will provide you information related to your topic. Bookmark the site and also write the web address on the back of the topic selection sheet.

Begin gathering information for you powerpoint presentation.

Research and outlining should occur outside of class. That way class time can be used to create your presentation.

Continue with lesson 3 powerpoint demonstration. The following topics will be introduced today.

Work with objects
Format objects
Flip and Rotate objects
Layer objects
Group, ungroup, regroup objects
Grid and Guides
Align and distribute objects
Action buttons

REQUIREMENTS HANDOUT AND RUBRIC

PRESENTATION WORK TIME:

-PPT outline handout
-Include titles for each of your main ideas (add slides if needed)
-Using internet resources, begin to add content to outline.
-As homework, you will complete the handout prior to next class. (handwritten please or you can add content in ppt at home but be sure you have file available for next class period.

1st: Create your outline of information today in class. Print in outline view - File/Print/"PrintWhat"/Outline view (due today) and turn in to the tray at the end of the period.

2nd: Second step will be to create your slide design in "Slide Master View" View menu/master/slide master. You are expected to change fonts, colors, backgrounds, bullets, etc. You will not use an existing design template.

3rd: Third step will be to include graphics.

4th: Fourth step will be to complete slide transitions and animations.

5th: Fifth step will be to provide a written summary of explaining how you used each feature in the requirements of the assignment (see rubric). In Word you will list each requirement and provide a brief explanation on how you incorporated features into your presentation.

6th: Sixth step is to practice your presentation.

Final workday for powerpoint

Written reflection on use of PowerPoint- Open file
PowerPoint Reflection

Sub today

You will be completing Excel Lesson 5 individually (Pages: Intro Excel 109-141). You will need to read/skim the contents of the chapter prior to each TryItOut.

You must save the TryItOuts as "TryItE5-_) even though the directions do not call for you to do so.

Task 1 - Pages 109 - 118
-Read and complete TryItOuts 5-1, 5-2, 5-3, 5-4, 5-5,
5-6, 5-7
-Complete Rehearsal Task 1 page 116-117

Task 2 - Pages 119 - 125
-Read and complete TryItOuts E5-8, 5-9, 5-10, 5-11, 5-12,
5-13,
-Complete Rehearsal Task 2 page 124-125

Task 3 - Pages 127 - 133
-Read and complete TryitOuts E5-14, 5-15, 5-16
-Complete Rehearsal Task 3 page 132-133

Task 4 - Pages 134 - 141
-Read and complete TryitOuts E5-17, 5-18, 5-19, 5-20, 5-21
5-22
-Complete Rehearsal Task 4 page 140 - 141

Production Test

Even number computers complete the following assignments in order:

Act II - page Intro Excel - 143-144
Act I - page Intro Excel - 142 - 143
Act III - page Intro Excel - 144- 145

Odd number computer complete the following assignments in order:

Act III - page Intro Excel - 144- 145
Act II - page Intro Excel - 143-144
Act I - page Intro Excel - 142 - 143

Printing Directions:

-Put name and filename below spreasheet or in a footer for each document printed.
-Enhance overall appearance of each spreadsheet that is printed by modifying fonts, borders, etc.
-follow specific printing directions for each ACT (see below)
-staple printouts and turn in to tray.

ACT I - Print trial balance only in normal view (1 printout)

ACT II -
- Print Consolidated Sheet (normal view and formula view (ctrl+~). Be sure to fit to 1 page.
-print San Diego sheet (normal view)

ACT III -
-Print "Balance sheet" in normal view
-Print "Worksheet" in normal and forumla view (fit to one page)

Review production test

handback graded papers

Preview of Excel Charts

Production test 2 - Excel

In the shortcut to data files (test files folder) you will open the following files.

d33.2sched and d33.2ws
d34.1income

Follow directions on handout. You will not have a diagram to look at so you will need to make some decisions on formatting.

Printing:

33.2ws - print worksheet in normal and formula view (fit to one page). Staple and turn in to tray. Normal printout first.

34.1income - print Town store sheet in normal view and print consolidated sheet in normal and formula view. Staple in the order that documents were printed. Turn in to tray.

Complete Excel Lesson 6 together.

Excel Task 2 - begins on page 165

Complete Try-it-outs - pages 165-173
Complete Rehearsal - pages 174-177
Complete Acts I, II, III - pages 178 -181

Finish assignments from Mar 25

We will be grading these today.

Do not print anything because I will probably check most of your charts from your computer.

Review Explore Microsoft Access if time permits

Finish printing/grading charts from Excel Lesson 6.

Complete Excel Lesson 7 - Integration

Read, complete Try-it-outs, and tasks for Excel Lesson 7.

You will work independently

Written Test covering Excel Chapters 5-7

Excel Chart production test

-Open "Excel Chart Test" from shortcut (Excel Folder - Test Files)
-You will create 3 different embedded charts using the data from the income statment.
-You will decide what information from the chart would be most useful to display using a chart (ie. expenses, total income, gross profit, total expenses, net income, etc.) You must chart 3 different pieces of data.
-You will also create 3 different types of charts. You must use a bar chart, pie chart, and line chart.
-You will modify at least 4 features of your chart (fonts, colors, position of legend, add graphics, etc). Changes must be significant and noticable.

Work independently on the following assignments

You will be expected to read/skim the pages in the textbook prior to each assignment. You will be responsible for all content within the chapter.

Access Lesson 2

Rehearsal Task 1 - page 30
Rehearsal Task 2 - page 44
Performance Act I and II (go together)
-read all directions first
-draw a sketch of the fields needed for you table

Access Lesson 3

Rehearsal Task 1 - page 62
Rehearsal Task 2 - page 74
Performance Act I and II - page 77-78

Access Lesson 4

Rehearsal Task 1 - pg 88
Rehearsal Task 2 - pg 100
Rehearsal Task 3 - pg 110
Performance Act I and II - page 112 - 115

Access Lesson 5

--Copy all files from Y: drive to your locker for lesson 5 if you have not done so already.

--You will read and complete all Try Tt Outs, Tasks, and Acts for lesson 5.

Sub today

This is the last full day you have to complete documents and plan for your group presentation. By the end of class today you should have a clear and well-planned idea for delivering your presentation to me. This will be a formal presentation and you must cover all aspects (documents) of the final project.

Each group should complete a rubric. This will help to ensure that you have met all expectations for creativity, appearance, content, and accuracy. I would like each group to provide feedback about the rubric. Should something be added or removed, etc.

Delivery of presentation should be enthusiastic, creative, informative, and cover all aspects of the conference details.

I was not able to get the color printer up and running so if someone in your group has a color printer at home, I would encorage them to use this.

Written Final exam

Finalize - Final project presentation & printing of documents.

Group/Peer evaluations for final project