1 / 27

CS 101 Midterm Review

This review covers topics such as earning bonus points, identifying file types, understanding optical drives, comparing ASCII and Unicode, important figures in computing history, formulas in spreadsheets, storage devices, and operating systems.

astonecipher
Download Presentation

CS 101 Midterm Review

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CS 101 Midterm Review Review

  2. 1. What is one way to get bonus points in this class? • Going to an Open Lab • Taking tests • Writing a paper • Coming to every lecture

  3. 2. A file with a path like c:\fall19\classes\cs101\sheet1.gif • Is a picture file – the gif tells you that • Is a text file – the folder classes tells you that • Is a spreadsheet – sheet1 tells you that • is a calendar file – spring15 tells you that

  4. 3. If an optical drive is labeled -R, • It can only be read from, not written to at all • It can be read from and written to many times • It can be written to once, read many times • It can only be written to, not read from

  5. 4. A file with a path like c:\fall19\classes\cs101\sheet1.gif • Is stored at the root of the hard drive • Is stored on the floppy drive • Is stored in the “My Documents” folder • None of the above

  6. 5. One difference between ASCII and Unicode is • ASCII is a newer code, Unicode is older • ASCII has a smaller number of codes, Unicode has many more • ASCII takes up more room per character than Unicode does • 4. All of these are correct.

  7. 6. Gordon Moore • Came up with an observation about how the power of computers (complexity of circuits) was doubling every 18 months/2 years. • Is one of the founders of Intel. • Is an engineer • All of these are true

  8. 7. Charles Babbage imagined the ________ with the help of Ada Lovelace. • abacus • Difference Engine • Enigma • first electronic computer

  9. 8. Who wrote Visicalc? • Steve Jobs and Bill Gates • Bill Gates and Steve Ballmer • Dan Bricklin and Bob Frankston • Al Gore

  10. 9. The value of the formula =5*3 + 8/2 • 27.5 • 19 • 31 • 18

  11. 10. How many megabytes are in 2 gigabytes? • 200 • 2048 • 0.5 • 2 • 1024

  12. 11. If the formula =C5+1 were in cell C5 • It would add 1 to the value already there • It would cause a precedence error • It would cause a #NAME error • It would cause a circular reference

  13. 12. The formula =sum(a3:a7) is the same as • =a3+a5 + a7 • =a3*a7 • =a3 + a4 + a5 + a6 + a7 • =a3/a7

  14. 13. The system clock • tells you what the date and time are • sends out a regular signal to all computer components • is used to make sure the hard drive is spinning fast enough • is not a factor in how fast the computer runs

  15. 14. Being volatile is a property of • data on a hard drive • data in RAM • a printout of a document • a file burned on a CD

  16. 15. What does it mean to freeze a spreadsheet? • the sheet is hung up and needs to be reloaded • some columns and rows will not scroll when the rest of the sheet does • all formulas are locked and cannot be altered • an error has been found in a formula and it must be fixed before anything can be added

  17. 16. Secondary storage devices are • Not necessary these days, we have plenty of RAM • Useful because RAM is volatile and they are not • Faster than RAM to access data • Very sturdy, they can be handled roughly without problems

  18. 17. Which storage device would have problems with a magnet? • A hard drive • A memory stick (flash drive) • A DVD • An SD card

  19. 18. Cache memory • Is between RAM and the keyboard • Is used to hold data which is going to be used frequently or in the near future • Holds data for a long time, it is not volatile • None of these is true

  20. 19. An IF function in Excel • has 3 parts: less than, greater than and equal to • has 3 parts: condition, true and false • has 4 parts: conditions, A, B and C • has 2 parts: condition and test

  21. 20. A macro is • a small program attached to a document • a recording of actions that can be played back later • vulnerable to virus attacks • all of the above

  22. 21. A clustered column chart • has a bar for each value charted, with height of bar proportional to the value represented • represents the percentage of a whole that each value is • shows the relationship of one set of values to another set of values

  23. 22. An operating system made by Bell Labs, open source, free, stable, is • Windows • Unix • Linux • iOS • Android

  24. 23. A CLI is • An interface where the user must remember the commands and filenames, not friendly • An interface using a pointing device, icons, drop-down menus, a visual metaphor • A part of an OS which handles the memory in the computer • A kind of file format which allows for animation and simple colors

  25. 24. Multitasking • Requires more than one CPU • Can only handle 3 tasks at a time • Is a simulation (an illusion) if done on one CPU • Is not available yet, is still under research

  26. 25. A macro in Excel will always be in a sheet with • “macro” in the file name • an extension of xlsm • a chart • numbers

  27. 26. Inserting a row or column into a spreadsheet • has to be done one cell at a time • will change any formulas which exist in the sheet only if they use absolute references • will change a range in a formula if the insertion is inside the range or to the left of or above the formula with the range • is not allowed once data has been entered into the sheet

More Related