BCT, Students will become independent users of technology for school and personal needs. Emphasis will also be placed on organization, following oral and written directions, independent work habits, and cooperative learning. Course Outline: • Keyboarding Skills • Ergonomics • Computer Literacy • Word Processing • Desktop Publishing • Fundamental • Document Processing (letters, memos, reports) • Databases • Spreadsheets • Telecommunications • Multimedia presentations.
7th grade must type with 25 gwam with 3 or fewer errors Keyboarding Grading
Chart 7th Grade
100 % | 15 + Drills |
| 98 % | 14 |
| 96 % | 13 |
| 94 | 12 |
| 92 | 11 |
| 90 | 10 |
| 85 | 9 |
| 80 | 8 |
| 76 | 7 |
| 72 | 6 |
| 60 | 5 |
| 50 | 4 - |
Do not skip any drills. Keyboarding makes up 25 % of your grade in computer science. Remember you will get a progress grade, 4 keyboarding technique grades and one (Testing / MS Excel) line chart grade).
Monday, March 22, 2010
Objectives:
CTO4.01 Identify Advantages of Word, Desktop Publishing SoftwareCTO4.02 Identify and Explain Word, Desktop Publishing TermsCTO4.03 Create basic documentsCTO4.04 Retrieve, format, and edit various documents CTO4.05 Create advanced documents.1. Microtype - Please check lessons completed via report link2. Lecture PowerPoint & Vocabulary3. Using a template Design a Certificate, save as certificate
Tuesday, March 23, 2010
CTO4.01 Identify Advantages of Word, Desktop Publishing SoftwareCTO4.02 Identify and Explain Word, Desktop Publishing TermsCTO4.03 Create basic documentsCTO4.04 Retrieve, format, and edit various documents CTO4.05 Create advanced documents.1. Microtype - Please check lessons completed via report link2. Lecture Right Tab Stop3. Performance Test: Design an Awards Program - Save as Awards
Wednesday, March 24 - 25, 2010
CTO4.01 Identify Advantages of Word, Desktop Publishing SoftwareCTO4.02 Identify and Explain Word, Desktop Publishing TermsCTO4.03 Create basic documentsCTO4.04 Retrieve, format, and edit various documents CTO4.05 Create advanced word processing and desktop publishing documents.1. Microtype - Please check lessons completed via report link2. Lecture about Templates3. Creating an invitation or Greeting Card Using a template of your choice, make an invitation or greeting card
Friday, March 26, 2010
CTO4.03 Create basic documents CTO4.04 Retrieve, format, and edit various documentsCTO4.05 Create advanced word processing and desktop publishing documents.
Review of lessons learned:Desktop Publishing concepts: http://www.quia.com/ba/119865.htmlWP Battle: http://www.quia.com/ba/119883.htmlWord Processing Terms: http://www.quia.com/cm/144970.htmlWord Processing and Desktop Publishing: http://www.quia.com/jg/1172057Word Processing: http://www.quia.com/hm/334438.thml
What ways can we create a document that reflects a great city?
Directions:
1. Change the font, and size of the Title to 24 pt and the Font of your choice.
2. The (C) means to CENTER and () means to indent {tab}. Erase codes when finished.
3. Bold and underline each answer.
4. Don't forget to erase the directions and do a Spell Check.
5. And add 3 graphics (text wrap all graphics!).
Name: ___________ Exploratory #: 7 Date __ - __ - __
(C) Job1: History of Gwinnett ()Gwinnett County was created by the state in ____. It is ____ square miles, and was named after ___________, one of Georgia’s three signers of the Declaration of Independence. A famous name rather than a famous man, Gwinnett never set _____ in the county that bears his name. ()Elisha Winn secured the site of the county seat by purchasing 250 _____ of land for $200, which was incorporate as the city of _______. By the end of the 1820s, Gwinnett’s population was more than 13,000. ()Gwinnett was swept into the modern era in the 1950s when Buford ____ was built. The result was the creation of Lake Sidney Lanier in 1957, which fostered a major industry for the state of Georgia – recreational ______. Two years later, Interstate 85, the county’s main thoroughfare, was completed to Pleasant Hill Road in Duluth. ()The 1980s was a decade of enormous growth. With the advent of Gwinnett Place Mall in 1984, the county shifted from a rural, agricultural economy to a booming metropolis with corporate ________, major manufacturing, high-technology and service industries. And for much of the ‘80s, Gwinnett held the title of “Fastest Growing County in the U.S.,” which Orange County, Florida (home of Disney World), had previously held. ()Even today, Gwinnett is the eighth fastest growing county in the nation, with a population estimated at 480,000. Comprised of 15 separate ______ and bordered by seven counties, the 1990s continue to infuse prosperity and growth with the Mall of Georgia, the TPC at Sugarloaf, and unprecedented corporate and residential growth.
Monday, March 29 - April 1, 2010
Report Formatting
CTO4.03 Create basic documents CTO4.04 Retrieve, format, and edit various documentsCTO4.05 Create advanced word processing and desktop publishing documents.
Review of lessons learned:
Editing a mixed up personal - Business Letter Research / Writing Skills
“It's a Bird, It's a Plane, It's Travel Time” Travel Brochure ProjectBrief Project Overview
In this project, students will demonstrate their Internet research and persuasive writing skills to create colorful, informative travel brochures to popular vacation destinations, all while gaining valuable communication skills working with their peers and exploring many areas of the world they have yet to see!
Appropriate Subjects and Grade LevelsBusiness
Length of Project
Approximately 3-4 days (55-minute class periods)
NOTE: The length of this project is an estimated minimum time needed for completion that may easily be expanded upon. The length of time will naturally increase as the project is expanded upon by the teacher as it is adapted to meet classroom and curriculum goals.
Travel Brochure Rubric
Outcomes/Products Assessments and Standards Matrix – identifies lesson outcomes, standards addressed, and ways to measure learning; includes a brief description of corresponding student activities
Student Materials Provided
Analyzing Travel Brochures student worksheet with short answer questions related to identifying attributes of an effective travel brochure
Travel Brochure Roles & Job Descriptions handout clarifying division of labor for the group’s travel brochure research and writing
Web Links handout with suggested web addresses useful for this project
Monday, April 5th - 6th, 2010
CTO4.03 Create basic documents CTO4.04 Retrieve, format, and edit various documentsCTO4.05 Create advanced word processing and desktop publishing documents. Review of lessons learned:Editing - proofreading an unbound report
Wednesday, April 7th - 9th, 2010
CTO4.03 Create basic documents CTO4.04 Retrieve, format, and edit various documentsCTO4.05 Create advanced word processing and desktop publishing documents. Review of lessons learned:Editing - Proofreading / Leftbound Report FormattingInternet Article Questions Directions: Answer each of the following questions in your own words using the article "The Internet: What's the fuss?" on the Internet. (Title - "The Internet: What's the fuss?", three - four paragraphs that answers the questions below, second page to include two - three paragraphs that includes the information for Part II.
1.What has made the Internet so popular? 2.What does ISP stand for and give one example? 3.What does HTML, URL, and HTTP mean? 4.The speed of the Internet is measured in (bps). What does bps mean? 5.Why has publishing on the Internet attracted so many people? 6.E-mail is a big part of the Internet. What does e-mail look like and name one advantage to using e-mail? 7.How many years ago was it before the Internet got its start? 8.What was the main reason it started? 9.A browser is what? 10. What are some of the reasons (name 2) for people not connecting to the Internet?
Part II
11. Give an example of a real URL. 12. When text is in a different color on a web site, that is referred to as what? 13. What is a browser and what is the most popular browser today? 14. Name a different browser than the one in question 13. 15. How are computer messages sent across the telephone?
Monday, April 12th - 16th, 2010
CT005.00 Utilize Spreadsheet software. CT05.01 Identify advantages and uses of spreadsheet software and charts/graphs.CT05.02 Identify and explain spreadsheet terminology.CT05.03 Create and save basic spreadsheets and apply formulas.CT05.04 Retrieve, edit, manipulate, and print various spreadsheets. CT05.05 Create various charts/graphs from spreadsheets.
Lesson 1: Entering Text and Numbers
Microsoft Excel is an electronic spreadsheet that runs on a personal computer. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. This tutorial teaches Microsoft Excel basics. Although knowledge of how to navigate in a Windows environment is helpful, this tutorial was created for the computer novice. This lesson will introduce you to the Excel window. You use the window to interact with Excel.
- The Microsoft Excel Window
- The Microsoft Office Button
- The Quick Access Toolbar
- The Title Bar
- Worksheets
- The Formula Bar
- The Status Bar
- Move Around a Worksheet
- Go To Cells Quickly
- Select Cells
- Enter Data
- Edit a Cell
- Wrap Text
- Delete a Cell Entry
- Save a File
- Close Excel
Lesson 2: Entering Excel Formulas and Formatting Data
Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window, and how to enter data. A major strength of Excel is that you can perform mathematical calculations and format your data. In this lesson, you learn how to perform basic mathematical calculations and how to format text and numerical data.
- Set the Enter Key Direction
- Perform Mathematical Calculations
- AutoSum
- Perform Automatic Calculations
- Align Cell Entries
- Perform Advanced Mathematical Calculations
- Copy, Cut, Paste, and Cell Addressing
- Insert and Delete Columns and Rows
- Create Borders
- Merge and Center
- Add Background Color
- Change the Font, Font Size, and Font Color
- Move to a New Worksheet
- Bold, Italicize, and Underline
- Work with Long Text
- Change a Column's Width
- Format Numbers
Lesson 3: Creating Excel Functions, Filling Cells, and Printing
By using functions, you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list. Microsoft Excel has many functions you can use. You can also use Microsoft Excel to fill cells automatically with a series. For example, you can have Excel automatically fill your worksheet with days of the week, months of the year, years, or other types of series.
A header is text that appears at the top of every page of your printed worksheet. A footer is text that appears at the bottom of every page of your printed worksheet. You can use a header or footer to display among other things titles, page numbers, or logos. Once you have completed your Excel worksheet, you may want to print it. This lesson teaches you how to use functions, how to create a series, how to create headers and footers, and how to print.
- Using Reference Operators
- Understanding Functions
- Fill Cells Automatically
- Create Headers and Footers
- Set Print Options
In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data, your chart will automatically update. This lesson teaches you how to create a chart in Excel.
Assignments / ExamplesDesigning a Survey
Students use their peers as a sample group to ask a series of questions. They must then take this data a create pie, bar, and line graphs.- http://www.crews.org/curriculum/ex/compsci/6thgrade/ssassign/survey01.htm.Spreadsheet FormulasThe use of formulas is very important feature of spread sheets. We will focus our attention on the =average, and =sum formulas. - http://www.crews.org/curriculum/ex/compsci/6thgrade/ssassign/formula01.htmPlanning a Party Design a party for your peers. This is an assignment that must be created using a spread sheet in ClarisWorks. A pie chart must be used to graph your party data. - http://www.crews.org/curriculum/ex/compsci/6thgrade/party.html
Monday, April 19th - 30th, 2010
CT006. Utilize database software.CT06.01 Identify advantages and uses of database software.CT06.02 Identify and explain database terminology.CT06.03 Create and save basic databases.CT06.04 Retrieve, manipulate, and print various databases. What is Microsoft Access?Microsoft Access is a Database Management System. It handles data management tasks the same way as Word handles document management and Excel handles statistics ...
Lesson 1 - Microsoft Access Introduction
Lesson 2 - Designing the application - tables, fields, data types, properties
Lesson 3 - Creating the database - primary key, creating tables
Lesson 4 - Defining Table relationships - referential integrity, primary and foreign keys
Lesson 5 - Entering data into Tables - data view, sorting and ordering
Lesson 6 - Creating data-entry forms - data validation, default values
Lesson 7 - Building simple Queries - sorting, selection criteria, working with dates
Lesson 8 - More complex Queries - multiple tables, linking, functions
Lesson 9 - Creating a Master/Detail form
Lesson 10 - The Microsoft Access Application Menu - the Switchboard
Lesson 11 - Creating Macros - autoexec, conditions
Lesson 12 - Writing Reports
Lesson 13 - Sales Analysis Reports with Microsoft Access
Lesson 14 - Action Queries - Updating data
Monday, May 3rd, 2010
CT007. Utilize multimedia / presentation graphics software.CT07.01 Identify advantages and uses of multimedia/presentation graphics software.CT07.02 Identify and explain multimedia/presentation graphics terminology.CT07.03 Plan and design basic presentations. CT07.04 Create, save, print, and present basic presentations. Cities of the World - Online Project
Get into teams of 4 students and decide on a city in the world to research. Then decide on who wants to be the technologist, historian, statistician, and attractions person. Find three facts. Write your facts down on note cards and create a PowerPoint slide from your notes. Sim3000 Codes
See all the code for the game.City Games... Finished with your presentation and now need a challenge? Take the CITY challenge and play some online games. http://www.crews.org/curriculum/ex/compsci/6thgrade/city_games.htmInternet Safety Quiz
This site is fun place to learn the rules of the road or should I say (ocean) surfing. Answer the questions found on this site and then print out your certificate (badge). Be a safe surfer today! Directions: Write a one page story as if the limitations of time, money, resources, people,, etc… were not an issue and you could solve some of the most difficult problems facing life today. Stick to the 6 areas below. Write at least 1 paragraph under each area! This should be an innovative or a new approach – “Think outside the box”
1. Population a. Why do people flock to certain cities and not others? b. How can we increase a city’s population but control how close people live together? c. *What factors balance how many people live in a city? 2. Unemployment a. What can be done to assist those people out of work or who have low paying jobs, or just hate their jobs and want a change? b. What ways can you attract and keep high paying jobs in a city? 3. Crime a. Describe why crime is so bad now. b. What challenges will we face in the future with crime? c. What new or innovated approach do you suggest to lower crime? d. *How did you feel about your ability to deal with crime in your sim town? 4. Pollution a. What ways are we polluting the air? b. What are the alternatives to gasoline, coal, landfills, etc…? c. How would you stop or lower pollution of our planet? d. *What are the challenges to get lower pollution levels? e. *Why is it such a challenge to change? 5. Health a. What problems do people face concerning their health? b. What ways can government help people live longer besides just build more hospitals? c. *What ways can you motivate people to live healthier lives?
6. Education a. What makes up a good school? b. What ways can you continue to have kids stay in school and really enjoy it and therefore learn more? c. *Why don’t kids like school more? * Optional
Wednesday, May 5th, 2010
Integrated Skills Shows links to other Microsoft Applications.
Shows the relative importance of each objective, competency, and unit. Emphasis is placed on cognitive and performance of assignments.Edit city report created in Microsoft Word at the end of 3rd quarter, modify to include the information from the link attached. Convert document into a web page. http://www.crews.org/curriculum/ex/compsci/6thgrade/mini/index.html
Monday, May 10th, 2010 Vocats Review
Monday, May 17th, 2010 Vocats Review
Monday, May 24th, 2010 Vocats Review and Exam