Podcast
Questions and Answers
What is the primary function of secondary memory units?
What is the primary function of secondary memory units?
- To provide temporary storage for active processes
- To execute software instructions
- To convert electronic signals into human-readable form
- To permanently store data and programs after power is turned off (correct)
Which type of software is responsible for managing the hardware components of a computer system?
Which type of software is responsible for managing the hardware components of a computer system?
- Firmware
- System software (correct)
- Application software
- Utility software
Which of the following is an example of application software?
Which of the following is an example of application software?
- Windows operating system
- Device driver
- Web browser (correct)
- BIOS firmware
What is one of the major categories of software that deals with user-specific tasks?
What is one of the major categories of software that deals with user-specific tasks?
Which output device function converts electronic information into a format understandable by humans?
Which output device function converts electronic information into a format understandable by humans?
What is an example of a larger collection of related but independent programs?
What is an example of a larger collection of related but independent programs?
Why are computers considered powerful in processing information?
Why are computers considered powerful in processing information?
Which example does NOT represent secondary memory?
Which example does NOT represent secondary memory?
How can you preview a font color before applying it in Word 2016?
How can you preview a font color before applying it in Word 2016?
Which command is NOT mentioned as a way to modify selected text?
Which command is NOT mentioned as a way to modify selected text?
What is the final step to highlight text in Word 2016?
What is the final step to highlight text in Word 2016?
Which of the following is the correct order to change the font size?
Which of the following is the correct order to change the font size?
When you want to apply Bold, Italic, or Underline to text in Word 2016, what must you do first?
When you want to apply Bold, Italic, or Underline to text in Word 2016, what must you do first?
What shortcut is used to cut text in Word 2016?
What shortcut is used to cut text in Word 2016?
What action follows selecting the text you wish to change when adjusting font size?
What action follows selecting the text you wish to change when adjusting font size?
What is the primary purpose of a primary key in a database table?
What is the primary purpose of a primary key in a database table?
Which of the following best describes the function of filtering in a database?
Which of the following best describes the function of filtering in a database?
How do primary keys contribute to data integrity in a database?
How do primary keys contribute to data integrity in a database?
What role do forms play in database management?
What role do forms play in database management?
What is the main function of queries in a database system?
What is the main function of queries in a database system?
What option allows you to start the presentation from the slide currently visible in the Slide Preview pane?
What option allows you to start the presentation from the slide currently visible in the Slide Preview pane?
Which keyboard shortcut can be used to run a presentation from the current slide?
Which keyboard shortcut can be used to run a presentation from the current slide?
What should you do first before printing your presentation?
What should you do first before printing your presentation?
What is the first step to open an existing presentation?
What is the first step to open an existing presentation?
What appears when you select 'Save As' for the first time?
What appears when you select 'Save As' for the first time?
Which of the following steps is NOT part of the printing process in PowerPoint 2016?
Which of the following steps is NOT part of the printing process in PowerPoint 2016?
What will you need to do after selecting 'Save' for the first time?
What will you need to do after selecting 'Save' for the first time?
Which option is NOT a method for starting a presentation in PowerPoint?
Which option is NOT a method for starting a presentation in PowerPoint?
What is the purpose of a primary key in a database?
What is the purpose of a primary key in a database?
Which view provides a spreadsheet-like display of the data in Access?
Which view provides a spreadsheet-like display of the data in Access?
What is the first step in creating a blank database in Access?
What is the first step in creating a blank database in Access?
Which of the following is NOT an object typically found in an Access database?
Which of the following is NOT an object typically found in an Access database?
Which of these steps is essential when creating a table in Access?
Which of these steps is essential when creating a table in Access?
What does the Navigation Pane display in an Access database?
What does the Navigation Pane display in an Access database?
What is required to define a field in a table?
What is required to define a field in a table?
Which method can be used to create a new database in Access?
Which method can be used to create a new database in Access?
What is the first step to apply a page border in a document?
What is the first step to apply a page border in a document?
Which option is NOT available in the Borders and Shading Dialogue Box for customizing a border?
Which option is NOT available in the Borders and Shading Dialogue Box for customizing a border?
What command allows you to change the page orientation in Word?
What command allows you to change the page orientation in Word?
When would you use the SAVE AS function in Word?
When would you use the SAVE AS function in Word?
Which of the following steps is involved in changing the page size in Word?
Which of the following steps is involved in changing the page size in Word?
What occurs after you select a template from the New section in the File tab?
What occurs after you select a template from the New section in the File tab?
What does the Justify alignment option do to text in a document?
What does the Justify alignment option do to text in a document?
Which panel in the Borders and Shading Dialogue Box allows you to preview your changes?
Which panel in the Borders and Shading Dialogue Box allows you to preview your changes?
Flashcards
Secondary Memory
Secondary Memory
Stores data and programs permanently, even when the computer is turned off.
Output Unit
Output Unit
Hardware that shows the results of computer processing in a human-readable format.
Software
Software
Organized collections of instructions and data that tell a computer what to do.
System Software
System Software
Signup and view all the flashcards
Application Software
Application Software
Signup and view all the flashcards
Computer Performance
Computer Performance
Signup and view all the flashcards
Computer Memory
Computer Memory
Signup and view all the flashcards
Input/Output (I/O) Devices
Input/Output (I/O) Devices
Signup and view all the flashcards
Cut Text
Cut Text
Signup and view all the flashcards
Paste Text
Paste Text
Signup and view all the flashcards
Change Font
Change Font
Signup and view all the flashcards
Font Size
Font Size
Signup and view all the flashcards
Font Color
Font Color
Signup and view all the flashcards
Highlight Text
Highlight Text
Signup and view all the flashcards
Bold Text
Bold Text
Signup and view all the flashcards
Text Alignment
Text Alignment
Signup and view all the flashcards
Paragraph Alignment
Paragraph Alignment
Signup and view all the flashcards
Page Border
Page Border
Signup and view all the flashcards
Page Border Settings
Page Border Settings
Signup and view all the flashcards
Page Orientation
Page Orientation
Signup and view all the flashcards
Page Size
Page Size
Signup and view all the flashcards
New Document
New Document
Signup and view all the flashcards
Database Table
Database Table
Signup and view all the flashcards
Save
Save
Signup and view all the flashcards
Primary Key
Primary Key
Signup and view all the flashcards
Filtering Data
Filtering Data
Signup and view all the flashcards
Save As
Save As
Signup and view all the flashcards
Sorting Data
Sorting Data
Signup and view all the flashcards
Data Relationships
Data Relationships
Signup and view all the flashcards
Starting a presentation
Starting a presentation
Signup and view all the flashcards
PowerPoint tools
PowerPoint tools
Signup and view all the flashcards
Printing a presentation
Printing a presentation
Signup and view all the flashcards
Open existing presentation
Open existing presentation
Signup and view all the flashcards
Saving a Presentation
Saving a Presentation
Signup and view all the flashcards
Backstage view
Backstage view
Signup and view all the flashcards
Open Dialog Box
Open Dialog Box
Signup and view all the flashcards
Database Objects
Database Objects
Signup and view all the flashcards
Navigation Pane
Navigation Pane
Signup and view all the flashcards
Table Design View
Table Design View
Signup and view all the flashcards
Datasheet View
Datasheet View
Signup and view all the flashcards
Create a Blank Database
Create a Blank Database
Signup and view all the flashcards
Data Type
Data Type
Signup and view all the flashcards
Relate Tables
Relate Tables
Signup and view all the flashcards
Study Notes
Computer Skills (COMP 105) - Lecture Notes
- The lecture covered the concept of Information Technology (IT), Introduction to Computer, Hardware, and Software.
- Data is defined as facts and figures that relay specific information. However, it is unorganized.
- Information is processed data with relevance and purpose, often derived by contextualizing, categorizing, calculating, and condensing the data.
- Knowledge involves understanding and doing, representing processed information.
- IT systems involve hardware and software for capturing, processing, exchanging, storing, and presenting information.
- A computer is a general-purpose electronic device that is used for the production and processing of information, capable of calculating and storing results.
- Key functions of computers: accept data (input), process data according to rules, produce information (output), and store information for future use.
- Computers respond to instructions (programs) stored in memory.
- Computers process information by translating input into binary numbers and processing them to produce output.
- Computer functionalities include taking data as input, storing data/instructions, processing data into information, generating output, and controlling the processes.
- Computer systems consist of hardware (physical components) and software (instructions/programs).
- Hardware examples include RAM, ports, graphics card, power supply, cables, wifi card, motherboard, CPU, cooler, SSD, HDD, keyboard, monitor, speakers, USB drives, and mouse.
- Computer units include input unit, central processing unit (CPU), primary memory unit (RAM, ROM), secondary storage unit(hard disk, optical disk, flash memory), and output unit.
- Input devices serve to feed data and signals to a computer.
- Examples of input devices include keyboards, mice, joysticks, scanners, webcams, and microphones.
Computer Skills (COMP 105) - Lecture Notes #2
- Computer performance is measured by the amount of useful work accomplished in comparison to resources used.
- Good computer performance depends on features like: short response time, high throughput, low resource utilization, high availability, fast data compression, and high bandwidth.
- The latency/response time is the time taken for an input to be converted into an output (input-to-output time)
- Throughput shows the number of results produced per clock cycle.
- A trade-off exists between maximum performance and minimum cost. The best balance between performance and cost, especially in resource-sensitive applications (MIPS/Watt), is important.
- Software quality is impacted by performance, particularly the responsiveness of applications.
- Computer memory is a physical device for storing information temporarily or permanently.
- Memory is composed of chips on the motherboard or other circuit boards.
- Each byte has a unique memory location.
- Memory is categorized as internal processor memory (cache memory:registers, built-in cache), primary memory (RAM, ROM), and secondary memory (hard disk, optical disk, flash memory).
- Storage devices are used to store data outside the immediate computer memory.
Computer Skills (COMP 105) - Lecture Notes #3
- Software, particularly application response time, is critical for user interaction with a computer.
- Computer software, specifically application response time, is a key part of software quality.
- Computer memory is a physical device (electronic component) used to temporarily or permanently store data, instructions, and results.
Computer Skills (COMP 105) - Lecture Notes #4
- Windows 10's architecture comprises hardware, operating system (OS), programming language (like Java), and application programs (such as Word and Excel).
- Essential components of an operating system include device configuration (managing connected devices), file management (handling files, folders, and protection), and memory management (allocating RAM for processes).
- Common operating systems include network OS (Unix, Linux, Windows Server 2000), desktop OS (Windows XP/Me, Mac OS, DOS), and Mobile OS (Android).
- Key OS features are multi-tasking, multi-programming, parallel processing, buffering, and spooling.
- Windows 10 features include a start menu (using tiles for apps, search, task view), virtual desktops, and quick-access tools (power options, task manager, control panel, settings).
- Windows 10 settings include system configurations (display, monitors, default applications, power), devices (printers, mice, scanners), accounts (user accounts), privacy (location, camera), updates and security (Windows Update), and more.
- File Explorer is a tool to navigate files and folders, perform operations like moving/copying/renaming/deleting, and compressing.
- Compression reduces file sizes and is often useful for storage and transfer.
Computer Skills (COMP 105) - Lecture Notes #5
- A computer network is a collection of computers and devices connected via communication devices and transmission media. It can connect computers, printers, and scanners.
- Network communication involves processes between multiple computers where various devices exchange data, instructions, and information.
- Advantages of computer networks include sharing of devices (printers, scanners), programs, files, data, information, and a high-speed internet connection..
- Disadvantages include network management difficulties, delay connectivity issues, and risks from computer viruses.
- Network topologies (e.g., bus, ring, star) and communication technology (e.g., intranet, extranet, internet) are crucial aspects of network configuration.
- The internet is a wide area network that interconnects various devices across the world using communication media, forming a global network.
- Common internet services include electronic mail (email), file transfer protocol (FTP), Telnet, Usenet news, and the World Wide Web (WWW).
- Internet uses include online communication, software sharing, information posting, feedback, and customer support services.
- Advantages of the internet include its speed and cost-effectiveness, ease of global connectivity, and vast reach.
- Disadvantages include potential misinformation, unreliable content, and high initial setup costs.
Computer Skills (COMP 105) - Lecture Notes #6
- Microsoft Word 2016.
- The Word 2016 program allows the creation, editing, and generation of text documents such as letters.
- When opened, users have options to open recent documents, create a new file/document, or choose from templates.
- The program's interface involves elements like titles/bar (with window controls), quick access toolbar (for commonly used commands), tabs (e.g., File, Home, Insert, Design, Layout, References, Mailings, Review, View), and a 'Tell me' search box.
- The Page Overview presents the document's layout and structure, showcasing its elements such as pages and headings.
Computer Skills (COMP 105) - Lecture Notes #8
- Microsoft PowerPoint 2016 software is used to create presentations.
- When opened, PowerPoint displays a Start screen with options for creating a new presentation, searching for templates, or choosing from pre-made templates.
Computer Skills (COMP 105) - Lecture Notes #9
- Access 2016 databases
- Database fundamentals
- Tables in tables and field types.
- Primary keys: Unique identifiers for each row in a table ensuring each record is distinct and easy to reference. They enforce Data Integrity.
- Database Management Systems (DBMS): Software assisting creating, managing, and interacting with databases.
- Forms, queries, reports
- Create a database, create a table, create primary keys, relate two tables, enter data and edit data
- The navigation pane will display database objects such as tables, queries, and reports. A database has many objects.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Related Documents
Description
This quiz covers the basics of computer software, including types and functions of application software and secondary memory. Additionally, it focuses on specific tasks and features in Word 2016, such as text formatting and manipulating fonts. Test your knowledge on these essential concepts!