280 likes | 419 Vues
Schedule. Quick note about quiz scores Wrap up Chapter 9 Brief overview of Office Products Short notes about the class Labs & Project Next Week Spreadsheets – Chapter 13. Homework. Ensure you are able to access Google Docs
E N D
Schedule • Quick note about quiz scores • Wrap up Chapter 9 • Brief overview of Office Products • Short notes about the class Labs & Project • Next Week • Spreadsheets – Chapter 13
Homework • Ensure you are able to access Google Docs • This can be done by logging into mail.northgeorgia.edu, then click on “Drive” from the top menu • You can reset your password at password.northgeorgia.edu, or contact the IT Service Desk for assistance • You are also welcome to create a free account at gmail.com
Learning Objectives • Explain the function of the program counter • Explain why integration and photolithography are important in integrated circuits • Discuss the purpose of an operating system • Explain the purpose of a compiler • Describe how large tasks are performed with simple instructions
Recap • Last time we talked about: • The PC’s PC (Personal Computer’s Program Counter) • In-depth explanation of the Fetch/Execute Cycle • Assembly Language • Integrated Circuits (ICs) • Photolithography • Semiconductors • Field Effect
Transistors • A transistoris a connector between two wires that can be controlled to allow a charge to flow between the wires (conduct) or not • The transistor is a MOS(Metal Oxide Semiconductor) transistor • Modern computers are developed with CMOS technology(“complementary MOS”)
Combining the Ideas • Start with an information-processing task. • Task is performed by an application implemented as a large • The program performs the specific operations of the application • The program’s commands are compiled into many simple assembly language instructions • The assembly instructions are then translated into a more primitive binary form • Fetch/Execute Cycle executes the instructions
Summary • You learned the following: • The repeating process fetches each instruction (indicated by the PC), decodes the operation, retrieves the data, performs the operation, and stores the result back into the memory. • This process is hardwired into the control subsystem, one of the five components of a processor.
Summary • You learned the following: • The memory, a very long sequence of bytes, each with an address, stores the program and data while the program is running. • The ALU does the actual computing. • The input and output units are the interfaces for the peripheral devices connected to the computer.
Summary • You learned the following: • Machine instructions do not refer to the data (operands) directly, but rather indirectly. Thus, different computations can be done with an instruction, just by changing the data in the referenced memory locations each time the instruction is executed.
Summary • You learned the following: • Programmers must create complex computations by software layers, building up simple operations from the base instructions, more complex operations from the simple ones, and so forth. • Programmers use sophisticated programming languages to create operating systems as well as complex applications software.
Summary • You learned the following: • The basic ideas of integrated circuits are integrating active and connective components, fabrication by photolithography, and controlling conductivity through the field effect.
Microsoft Office Products • Word • Excel • PowerPoint • Publisher • Outlook • Access • Visio • Project
Word • Primarily used for basic word processing (writing papers) • Includes some advanced features, like Mail Merge, Tables, Charts, etc
Excel • Excel is a spreadsheet application • This includes performing calculations and creating graphs • There are a significant number of advanced functions we can use, as well as the ability to create your own.
PowerPoint • PowerPoint is a presentation software • Information can be included in a PowerPoint in many different formats, including text, images, graphs, etc
Publisher • Publisher is used for desktop publishing • It supports a wide array of formats and designs to support creating newsletters, brochures, etc
Outlook • Outlook is primarily used for email • It also includes a calendar, task manager, and contact manager
Access • Access is a database management system • In addition to storing the database structure and data, you can also use access to create forms for entering data into your database
Visio • Visio is primarily used for creating diagrams • It can also produce vector graphics
Project • Project is a project management software • Task lists can be created within a project, resources allocated to tasks, and graphs created to show project progress, as well as potential overlaps in required project resources.
Labs & Project • Your project for this class will be to create a website on a topic that interests you. • The labs we do throughout the semester will end up being several pieces of your website.