that they can use in other classes/life situations.<br><br> EASTERN ARIZONA COLLEGE - 2 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator Description Uses of computer hardware and software in business and society; computer terminology; program definition and flowcharting/algorithms; introduction to programming using general purpose language and word processing, spreadsheet, database, graphics, multimedia, and Internet. Business applications focus on spreadsheet creation and formatting along with database creation and formatting. Supplies Access to an Internet-connected personal computer.<br><br> USB flash drives and CD-RWs preferred. Some computer labs are equipped with ZIP drives. Competencies and Performance Standards 1.<br><br> Become computer literate. Learning objectives What you will learn as you master the competency: a. Define the term ccomputer literate. d b.<br><br> Understand how becoming computer literate makes you a savvy computer user and consumer. c. List how becoming computer literate helps you in a career.<br><br> d. List how becoming computer literate helps you understand and take advantage of future technologies. e.<br><br> Understand the challenges that computers bring to a digital society, and how becoming computer literate helps you deal with these changes. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified. Criteria - Performance will be satisfactory when: o Learner defines the term ccomputer literate. d o Learner understands becoming computer literate makes them a savvy computer user and consumer.<br><br> o Learner lists how becoming computer literate helps him/her in a career. o Learner lists how becoming computer literate helps him/her understand and take advantage of future technologies. o Learner understands the challenges that computers bring to a digital society and how becoming computer literate helps him/her deal with these challenges.<br><br> 2. Describe the basic parts and functions of a computer. Learning objectives What you will learn as you master the competency: a.<br><br> Explain what the four main functions of a computer are. b. Differentiate between data and information.<br><br> c. Define cbits d and cbytes d and how they are measured. d.<br><br> Define and list input devices. e. Define and list output devices.<br><br> f. List items on the front panel of the system unit. EASTERN ARIZONA COLLEGE - 3 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator g.<br><br> List items on the back of the system unit. h. Explain what is inside the system unit.<br><br> i. List steps to set up your computer to avoid strain and injury. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified.<br><br> Criteria - Performance will be satisfactory when: o Learner explains the four main functions of a computer. o Learner differentiates between data and information. o Learner defines cbits d and cbytes d and how they are measured.<br><br> o Learner defines and lists input devices. o Learner defines and lists output devices. o Learner lists items on the front panel of the system unit.<br><br> o Learner lists items on the back of the system unit. o Learner explains what is inside the system unit. o Learner lists steps to set up his/her computer to avoid strain and injury.<br><br> 3. Describe the Internet and the various systems and software that support its use. Learning objectives What you will learn as you master the competency: a.<br><br> Understand the different ways to communicate through the Internet with IM, Weblogs, podcasts, VoIP, Webcasts, wikis, e-mail, chat, newsgroups, and listservs. b. List the various kinds of multimedia files found on the Web, and what software is needed to use them.<br><br> c. Define e-commerce. d.<br><br> Manage online annoyances like spam, cookies, adware, spyware, malware, phishing, and Internet hoaxes. e. Define the types of Web browsers.<br><br> f. Define URL and its parts. g.<br><br> Use hyperlinks and other tools to navigate the Web. h. Use search engines and subject directories to search the Internet.<br><br> I. Define Boolean operators and how they help search the Web more efficiently. j.<br><br> Evaluate a Web site. k. Explain how data travels on the Internet.<br><br> l. List options for connecting to the Internet. m.<br><br> Locate an Internet Service Provider. n. Explain the origin of the Internet.<br><br> o. Discuss the future of the Internet. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified.<br><br> EASTERN ARIZONA COLLEGE - 4 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator Criteria - Performance will be satisfactory when: o Learner understands the different ways to communicate through the Internet with IM, Weblogs, podcasts, VoIP, Webcasts, wikis, e-mail, chat, newsgroups, and listservs. o Learner lists the various kinds of multimedia files found on the Web, and what software is needed to use them. o Learner defines e-commerce.<br><br> o Learner manages online annoyances like spam, cookies, adware, spyware, phishing, and Internet hoaxes. o Leaner defines the types of Web browsers. o Learner defines URL and its parts.<br><br> o Learner uses hyperlinks and other tools to navigate the Web. o Learner uses search engines and subject directories to search the Internet. o Learner defines Boolean operators and how they help search the Web more efficiently.<br><br> o Leaner evaluates a Web site. o Learner explains how data travels on the Internet. o Learner lists options for connecting to the Internet.<br><br> o Learner locates an Internet Service Provider. o Learner explains the origin of the Internet. o Learner discusses the future of the Internet.<br><br> 4. Define application software and its uses. Learning objectives What you will learn as you master the competency: a.<br><br> Differentiate between application software and system software. b. List the different kinds of application included in productivity software available for home use.<br><br> c. Identify various types of multimedia software. d.<br><br> Identify various types of entertainment software. e. Define reference software.<br><br> f. Identify the various types of drawing software. g.<br><br> List the various kinds of software businesses like to use. h. Find help for software problems.<br><br> i. List ways to obtain software. j.<br><br> Understand how to install, uninstall, and open software. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified. Criteria - Performance will be satisfactory when: o Learner differentiates between application software and system software.<br><br> o Learner lists the different kinds of application included in productivity software available for home use. o Learner identifies various types of multimedia software. o Learner identifies the various types of entertainment software.<br><br> EASTERN ARIZONA COLLEGE - 5 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator o Learner defines reference software. o Learner identifies the various types of drawing software. o Learner lists the various kinds of software businesses use.<br><br> o Learner finds help for software problems. o Learner lists ways to obtain software. o Learner understands how to install, uninstall, and open software.<br><br> 5. Understand the Operating System, Utility Programs, and File Management. Learning objectives What you will learn as you master the competency: a.<br><br> List the software included in system software. b. Identify the different types of operating systems.<br><br> c. List the most common desktop operating systems. d.<br><br> Explain how operating systems provide a means for users to interact with the computer. e. Explain how the operating system helps manage the processor.<br><br> f. Explain how the operating system manages memory and storage. g.<br><br> Explain how the operating system manages hardware and peripheral devices. h. Explain how the operating system interacts with application software.<br><br> i. Explain how the operating system helps the computer start up. j.<br><br> List the main desktop and windows features. k. Explain how the operating system helps keep the computer organized.<br><br> l. Identify the utility programs included in system software, and their functions. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified.<br><br> Criteria - Performance will be satisfactory when: o Learner lists the software included in the system software. o Learner identifies the different types of operating systems. o Learner lists the most common desktop operating systems.<br><br> o Learner explains how operating systems provide a means for users to interact with the computer. o Learner explains how the operating system helps manage the processor. o Learner explains how the operating system manages memory and storage.<br><br> o Learner explains how the operating system manages hardware and peripheral devices. o Learner explains how the operating system interacts with application software. o Learner explains how the operating system interacts with the computer start up.<br><br> o Learner lists the main desktop and window features. o Learner explains how the operating system helps keep the computer organized. o Learner identifies the utility programs included in system software, and their functions.<br><br> EASTERN ARIZONA COLLEGE - 6 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator 6. Evaluate and assess system hardware. Learning objectives What you will learn as you master the competency: a.<br><br> Explain the functions of the CPU and how to evaluate its performance. b. Explain how memory works and how to evaluate the amount of memory needed for projects.<br><br> c. Identify the computer 9s main storage devices. d.<br><br> Identify components that affect the output of video on a computer. e. Identify components that affect the computer 9s sound quality.<br><br> f. Identify the different kind of ports and their uses. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified.<br><br> Criteria - Performance will be satisfactory when: o Learner explains the functions of the CPU and how to evaluate its performance. o Learner explains how memory works and how to evaluate the amount of memory needed for projects. o Learner identifies the computer 9s main storage devices.<br><br> o Learner identifies the components that affect the output of a video on a computer. o Learner identifies the components that affect the computer 9s sound quality. o Learner identifies the different kinds of ports and their uses.<br><br> 7. Define the components and systems required for data communications and networking. Learning objectives What you will learn as you master the competency: a.<br><br> Define a network and list the advantages of setting one up. b. Differentiate between a client/server network and a peer-to-peer network.<br><br> c. List the main components of every network. d.<br><br> List the most common home networks. e. Define wired Ethernet networks, and explain how they are created.<br><br> f. Define wireless Ethernet networks, and explain how they are created. g.<br><br> Differentiate between power-line networks and Ethernet networks. h. List ways that hackers attack networks, and what harm they cause.<br><br> i. Differentiate between wireless and wired networks including their securities. j.<br><br> Identify the different types of viruses. k. List ways to protect a computer form viruses.<br><br> Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified. Criteria - Performance will be satisfactory when: o Learner defines a network and lists the advantages of setting one up. EASTERN ARIZONA COLLEGE - 7 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator o Learner differentiates between a client/server network and a peer-to-peer network.<br><br> o Leaner lists the main components of every network. o Learner lists the most common home networks. o Learner defines wired Ethernet networks and explains how they are created.<br><br> o Learner differentiates between power-line networks, and what harm they cause. o Learner differentiates between wireless and wired networks including their securities. o Learner identifies the different types of viruses.<br><br> o Learner lists ways to protect a computer from viruses. 8. Mobile computing.<br><br> Learning objectives What you will learn as you master the competency: a. List the advantages and limitations of mobile computing. b.<br><br> Identify the various mobile computing devices. c. Explain how cell phone components resemble a traditional computer, and how they function.<br><br> d. Define a portable media player and list its functions. e.<br><br> Define a PDA and identify its internal components and features. f. Understand how to synchronize a PDA with a desktop computer.<br><br> g. Define a tablet PC and its uses. h.<br><br> Differentiate between notebooks and desktop computers. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified. Criteria - Performance will be satisfactory when: o Learner lists the advantages and limitations of mobile computing.<br><br> o Learner identifies the various mobile computing devices. o Learner explains how cell phone components resemble a traditional computer, and how they function. o Learner defines a portable media player and lists its functions.<br><br> o Learner defines a PDA and identifies its internal components and features. o Learner understands how to synchronize a PDA with a desktop computer. 9.<br><br> Identify system hardware. Learning objectives What you will learn as you master the competency: a. Define a switch and explain how it works.<br><br> b. Define binary number system and explain what role it plays in a computer system. c.<br><br> Identify the CPU components and explain how they operate. d. Explain how CPUs process data and instructions.<br><br> e. Define cache memory. f.<br><br> Identify the different types of RAM. EASTERN ARIZONA COLLEGE - 8 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator g. Define a bus and explain how it functions in a computer system.<br><br> h. Explain how manufacturers create CPUs to run faster. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified.<br><br> Criteria - Performance will be satisfactory when: o Learner defines a switch and explains how it works. o Learner defines the binary number system and explains what role it plays in a computer system. o Learner identifies the CPU components and explains how they operate.<br><br> o Learner explains how CPUs process data and instructions. o Learner defines cache memory. o Learner identifies the different types of RAM.<br><br> o Learner defines a bus and explains how it functions in a computer system. o Learner explains how manufacturers create CPUs to run faster. 10.<br><br> Understand Software Programming. Learning objectives What you will learn as you master the competency: a. Explain the system development life cycle and identify the phases in the cycle.<br><br> b. Explain the life cycle of a program. c.<br><br> Explain what role a problem statement plays in programming. d. Understand the steps to create algorithms.<br><br> e. Explain how programmers move from algorithm code and what categories of language they may code in. f.<br><br> List the steps programmers use to move from code in a programming language to 1s and 0s the CPU can understand. g. Explain how a program is tested.<br><br> h. Identify the steps involved in completing a program. i.<br><br> Explain how programmers select the right programming language for a specific task. j. List the most popular programming languages for Windows and Web applications.<br><br> Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified. Criteria - Performance will be satisfactory when: o Learner explains the system development life cycle and identifies the phases in the cycle. o Learner explains the life cycle of a program.<br><br> o Leaner explains the role a program statement plays in programming. o Learner understands the steps to create algorithms. o Learner explains how programmers move from algorithm to code and what categories of language they may code in.<br><br> o Learners list the steps programmers use to move from code in a programming language EASTERN ARIZONA COLLEGE - 9 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator to 1s and 0s the CPU can understand. o Leaner explains how a program is tested. o Learner identifies the steps involved in completing a program.<br><br> o Learner explains how programmers select the right programming language for a specific task. o Learner lists the most popular programming languages for Windows and Web applications. 11.<br><br> Understand Databases and Information Systems. Learning objectives What you will learn as you master the competency: a. Define a dataset and list the benefits of using databases.<br><br> b. Identify the components of a database. c.<br><br> Differentiate among the different types of databases. d. Explain what database management systems do.<br><br> e. Explain how relational databases organize and manipulate data. f.<br><br> Differentiate between data warehouses and data marts. g. Define information system and identify what types of information systems are used in business.<br><br> h. Define data mining and explain how it works. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified.<br><br> Criteria - Performance will be satisfactory when: o Learner defines a database and lists the benefits of using databases. o Learner identifies the components of a database. o Learner differentiates among the different types of databases.<br><br> o Learner explains what database management systems do. o Learner explains how relational databases organize and manipulate data. o Learner differentiates between data warehouses and data marts.<br><br> o Learner defines information system and identifies what types of information systems are used in business. o Learner defines data mining and explains how it works. 12.<br><br> Network and Security. Learning objectives What you will learn as you master the competency: a. List the advantages of a business network.<br><br> b. Differentiate between a client/server network and a peer-to-peer network. c.<br><br> Identify the classifications of client/server networks. d. Identify the components needed to construct a client/server network.<br><br> e. Identify the various types of servers. f.<br><br> Explain the various network topologies (layouts), and why it is important in planning a EASTERN ARIZONA COLLEGE - 10 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator network. g. List the types of transmission media used in client/server networks.<br><br> h. Identify the software needed to run on computers attached to a client/server network, and how this software controls network communications. i.<br><br> Explain how network adapters enable computers to participate in a client/server network. j. List devices that assist in moving data around a client/server network.<br><br> k. List ways to secure large networks. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified.<br><br> Criteria - Performance will be satisfactory when: o Learner lists the advantages of a business network. o Learner differentiates between a client/server network and a peer-to-peer network. o Learner identifies the classifications of client/server networks.<br><br> o Learner identifies the components needed to construct a client/server network. o Learner identifies the various types of servers. o Learner explains the various network topologies (layouts), and why it is important in planning a network.<br><br> o Learner lists the types of transmission media used in client/server networks. o Learner identifies the software needed to run on computers attached to a client/server network, and how this software controls network communications. o Learner explains how network adapters enable computers to participate in a client/server network.<br><br> o Learner lists ways to secure large networks. 13. Understand how the Internet works.<br><br> Learning objectives What you will learn as you master the competency: a. Identify who manages and pays for the Internet. b.<br><br> Explain how the Internet 9s networking components interact. c. List data transmissions and protocols the Internet uses.<br><br> d. Explain the importance of IP addresses and domain names in Internet communications. e.<br><br> Differentiate between FTP and Telnet. f. Explain the uses of HTML and XML.<br><br> g. Explain how e-mail and instant messaging work, and how messages are kept secure. Performance Standards Competence will be demonstrated: o Completion of a quiz (with a passing grade) covering the learning objectives specified.<br><br> Criteria - Performance will be satisfactory when: o Learner explains how the Internet networking components interact. o Learner lists data transmissions and protocols the Internet uses. o Learner explains the importance of IP addresses and domain names in Internet communications.<br><br> EASTERN ARIZONA COLLEGE - 11 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator o Learner differentiates between FTP and Telnet. o Learner explains the uses of HTML and XML. o Learner explains how e-mail and instant messaging work, and how messages are kept secure.<br><br> 14. Create documents using Excel. Learning objectives What you will learn as you master the competency: a.<br><br> Understand spreadsheet software. b. Tour the Excel window.<br><br> c. Understand Formulas. d.<br><br> Enter labels and values and use AutoSum. e. Edit cell entries.<br><br> f. Enter and edit a simple formula. g.<br><br> Switch worksheet views. h. Choose print options.<br><br> Performance Standards Competence will be demonstrated: o through the successful completion of a worksheet project. o through the successful completion of chapter tests and quizzes. o by successfully completing the final exam.<br><br> Criteria - Performance will be satisfactory when: o Learner understands spreadsheet software. o Learner tours the Excel window. o Learner understands formulas.<br><br> o Learner enters labels and values and uses AutoSum. o Learner edits cell entries. o Learner enters and edits a simple formula.<br><br> o Learner switches worksheet views. o Learner chooses print options. 15.<br><br> Work with formulas and functions. Learning objectives What you will learn as you master the competency: a. Create a complex formula.<br><br> b. Insert a function. c.<br><br> Type a function. d. Copy and move cell entries.<br><br> e. Understand relative and absolute cell references. f.<br><br> Copy formulas with relative cell references. g. Copy formulas with absolute cell references.<br><br> h. Round a value with a function. EASTERN ARIZONA COLLEGE - 12 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator Performance Standards Competence will be demonstrated: o through the successful completion of a worksheet project.<br><br> o through the successful completion of chapter tests and quizzes. o by successfully completing the final exam. Criteria - Performance will be satisfactory when: o Learner creates a complex formula.<br><br> o Learner inserts a function. o Learner types a function. o Learner copies and moves cell entries.<br><br> o Learner understands relative and absolute cell references. o Learner copies formulas with relative cell references o Learner copies formulas with absolute cell references. o Learner rounds a value with a function.<br><br> 16. Format a worksheet. Learning objectives What you will learn as you master the competency: a.<br><br> Format values. b. Change font and font size.<br><br> c. Change attributes and alignment. d.<br><br> Adjust column width. e. Insert and delete rows and columns.<br><br> f. Apply colors, patterns, and borders. g.<br><br> Apply conditional formatting. h. Name and move a sheet.<br><br> i. Check spelling. Performance Standards Competence will be demonstrated: o through the successful completion of a worksheet project.<br><br> o through the successful completion of chapter tests and quizzes. o by successfully completing the final exam. Criteria - Performance will be satisfactory when: o Learner formats values.<br><br> o Learner changes font and font size. o Learner changes attributes and alignment. o Learner adjusts column width.<br><br> o Learner inserts and deletes rows and columns. o Learner applies colors, patterns, and borders. o Learner applies conditional formatting.<br><br> o Learner names and moves a sheet. EASTERN ARIZONA COLLEGE - 13 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator o Learner checks spelling. 17.<br><br> Create, manipulate, and format Charts. Learning objectives What you will learn as you master the competency: a. Plan a chart.<br><br> b. Create a chart. c.<br><br> Move and resize a chart. d. Change the chart design.<br><br> e. Change the chart layout. f.<br><br> Format a chart. g. Annotate and draw on a chart.<br><br> h. Create a pie chart. Performance Standards Competence will be demonstrated: o through the successful completion of a worksheet project.<br><br> o through the successful completion of chapter tests and quizzes. o by successfully completing the final exam. Criteria - Performance will be satisfactory when: o Learner plans a chart.<br><br> o Learner creates a chart. o Learner moves and resizes a chart. o Learner changes the chart design.<br><br> o Learner changes the chart layout. o Learner formats a chart. o Learner annotates and draws on a chart.<br><br> o Learner creates a pie chart. 18. Create a typical database containing customer, contract, and invoice data.<br><br> Learning objectives What you will learn as you master the competency: a. Define the terms field, record, table, relational database, primary key, and foreign key. b.<br><br> Create a blank database. c. Identify the components of the Microsoft Access window.<br><br> d. Create and save a table in Datasheet view. e.<br><br> Enter field names and records in a table datasheet. f. Open a table using the Navigation Pane.<br><br> g. Open an Access database. h.<br><br> Copy and paste records from another Access database. i. Navigate a table datasheet.<br><br> j. Create and navigate a simple query. EASTERN ARIZONA COLLEGE - 14 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator k.<br><br> Create and navigate a simple form. l. Create, preview, navigate, and print a simple report.<br><br> m. Learn how to manage a database by compacting, backing up, and restoring a database. Performance Standards Competence will be demonstrated: o in successful completion of multiple choice quizzes and practical exams o in successful completion of lab assignments and projects.<br><br> Criteria - Performance will be satisfactory when: o Learner defines the term fields, record, table, relational database, primary key, and foreign key. o Learner creates a blank database. o Learner identifies the components of the Microsoft Access window.<br><br> o Learner creates and saves a table in Datasheet view. o Learner enters field names and records in a table datasheet. o Learner opens a table using the Navigation Pane.<br><br> o Learner opens an Access database. o Learner copies and pastes records from another Access database. o Learner navigates a table datasheet.<br><br> o Learner creates and navigates a simple query. o Learner creates and navigates a simple form. o Learner creates, previews, navigates, and prints a simple report.<br><br> o Learner understands how to manage a database by compacting, backing up, and restoring a database. 19. Build a database and define table relationships.<br><br> Learning objectives What you will learn as you master the competency: a. Learn the guidelines for designing databases and setting field properties. b.<br><br> View and modify field data types and formatting. c. Create a table in Design view.<br><br> d. Define fields and specify a table 9s primary key. e.<br><br> Modify the structure of a table. f. Import data from an Excel worksheet.<br><br> g. Create a table by importing an existing table structure. h.<br><br> Delete, rename, and move fields. i. Add data to a table by importing a text file.<br><br> j. Define a relationship between two tables. Performance Standards Competence will be demonstrated: o successful completion of laboratory assignments/projects o multiple choice quizzes and practical exams.<br><br> EASTERN ARIZONA COLLEGE - 15 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator Criteria - Performance will be satisfactory when: o Learner understands the guidelines for designing databases and setting field properties. o Learner views and modifies field data types and formatting. o Learner creates a table in Design view.<br><br> o Learner defines fields and specifies a table 9s primary key. o Learner modifies the structure of a table. o Learner imports data from an Excel worksheet.<br><br> o Learner creates a table by importing an existing table structure. o Learner deletes, renames, and moves fields. o Learner adds data to a table by importing a text file.<br><br> o Learner defines a relationship between two tables. 20. Maintain and Query a database.<br><br> Learning objectives What you will learn as you master the competency: a. Find, modify, and delete records in a table. b.<br><br> Learn how to use the Query window in Design view. c. Create, run, and save queries.<br><br> d. Update data using a query datasheet. e.<br><br> Create a query based on multiple tables. f. Sort data in a query.<br><br> g. Filter data in a query. h.<br><br> Specify an exact match condition in a query. i. Change the font size and alternating row color in a datasheet.<br><br> j. Use a comparison operator in a query to match a range of values. k.<br><br> Use the and/or logical operators in queries. l. Create and format a calculated field in a query.<br><br> m. Perform calculations in a query using aggregate functions to record group calculations. n.<br><br> Change the display of database objects in the Navigation Pane. Performance Standards Competence will be demonstrated: o successful completion of laboratory assignments/projects o multiple choice quizzes and practical exams. Criteria - Performance will be satisfactory when: o Learner finds, modifies, and deletes records in a table.<br><br> o Learner understands how to use the Query window in Design view. o Learner creates, runs, and saves queries. o Learner updates data using a query datasheet.<br><br> o Learner creates a query based on multiple tables. o Learner sorts data in a query. o Learner filters data in a query.<br><br> EASTERN ARIZONA COLLEGE - 16 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator o Learner specifies an exact match condition in a query. o Learner changes the font size and alternating row color in a datasheet. o Learner uses a comparison operator in a query to match a range of values.<br><br> o Learner uses the and/or logical operators in queries. o Learner creates and formats a calculated field in a query. o Learner performs calculations in a query using aggregate functions to record group calculations.<br><br> o Learner changes the display of database objects in the Navigation Pane. 21. Create forms and reports.<br><br> Learning objectives What you will learn as you master the competency: a. Create a form using the Form Wizard. b.<br><br> Modify a form 9s design in Layout View. c. Change a form 9s AutoFormat.<br><br> d. Add a picture to a form. e.<br><br> Change the color, line type, and position of items in a form. f. Navigate a form and find data using a form.<br><br> g. Maintain table data using a form. h.<br><br> Preview and print selected form records. i. Create a form with a main form and a subform.<br><br> j. Create a report using the Report Wizard. k.<br><br> Modify a report 9s design in Layout view. l. Move and resize fields in a report.<br><br> m. Insert a picture in a report. n.<br><br> Change the font color of a report title. o. Use conditional formatting in a report.<br><br> p. Preview and print a report. Performance Standards Competence will be demonstrated: o successful completion of laboratory assignments/projects o multiple choice quizzes and practical exams.<br><br> Criteria - Performance will be satisfactory when: o Learner creates a form using the Form Wizard. o Learner modifies a form 9s design in Layout View. o Learner changes a form 9s AutoFormat.<br><br> o Learner adds a picture to a form. o Learner changes the color, line type, and position of items in a form. o Learner navigates a form and finds data using a form.<br><br> o Learner maintains table data using a form. o Learner previews and prints selected form records. o Learner creates a form with a main form and a subform.<br><br> EASTERN ARIZONA COLLEGE - 17 - Introduction to Computer Based Systems Equal Opportunity Employer and Educator o Learner creates a report using the Report Wizard. o Learner modifies a report 9s design in Layout view. o Learner moves and resizes fields in a report.<br><br> o Learner inserts a picture in a report. o Learner changes the font color of a report title. o Learner uses conditional formatting in a report.<br><br> o Learner previews and prints a report. Types of Instruction Classroom Presentation On-campus laboratory and clinicals. Grading Information Grading Rationale The post-test will count as the final exam and be represented as 10% of the overall grade.<br><br> Grading Scale A 90-100% B 80-89% C 70-79% D 60-69% F Below 60%

less