Computer Science Placement: Topics List
1. On Mac and Windows computers, you should know how to:
- Do basic video editing with iMovie or Windows Movie Maker;
- Use Gmail labels, filters, and attachments;
- Use the web and library databases for research, use Google Advanced Search for files and images;
- Create a web page with images and links, using basic HTML;
- Save and share files with cloud-based services like Google Docs, iCloud, Dropbox, etc.;
- Use flash drives and other removable media, connect to projectors and adjust display settings, install and update software, prevent viruses;
- Get help from a variety of sources to solve a tech problem or learn a new technique.
2. Using Word or Pages, you should know how to:
- Format text (font, size, color, style);
- Set margins and page layout;
- Use bullets and numbering for lists;
- Use headers and footers;
- Insert footnotes and endnotes;
- Add page numbers and page breaks;
- Create and format tables, add borders and shading;
- Insert symbols, equations, accents, hyperlinks, and text-wrapped images;
- Use spelling and grammar check;
3. Using Excel or Numbers, you should know how to:
- Use formulas and functions (average, sum, count, max);
- Use relative and absolute references (“locked” cells);
- Create charts, including pie and column charts and scatter plots;
- Label chart axes, set axis data source, set appropriate scales;
- Add trend lines and forecasts to graphs, then use the trend line equation for estimating values;
- Sort and filter data;
- Use spreadsheet printing features (reduce/enlarge, set print area, header/footer);
- Copy tables and graphs into a word processor or presentation program;
- Explain the difference between a spreadsheet and a database.
4. Using presentation software, you should know how to:
- Create a presentation from scratch;
- Add, remove, and re-order slides;
- Insert and resize images;
- Change slide backgrounds;
- Insert hyperlinks into slides;
- Add notes to a slide and print them.
5. Other software:
- Use Photoshop (http://creative.adobe.com/products/download/photoshop) to work with layers, magic wand, clone stamp, and liquify tools, drop shadows, filters, cropping, resizing, adding text, image adjustments, exporting, compression;
- Use Scratch (http://scratch.mit.edu/projects/editor) to create a simple program with multiple sprites, keyboard and mouse controls, sounds, and backdrops;
- Use Sketchup Make 2016 (http://www.sketchup.com/download/all) to create models with measurements, components, groups, follow-me, offset, and paint bucket tools, and 3D Warehouse models;
- Use Garageband to record audio, trim, split, loop, adjust track volume, use built-in beats, snap to grid, and export to MP3;
- Use bibliographic software.
Computer Science Placement: Sample Test Questions
I. Word Processing
- Create a new word processing document and name the file with your last name.
- Make all the margins 0.75 inches.
- Put your name in the header and an automatic page number in the footer.
- Create a table with one row and two columns, and a border around the outside.
- Insert a footnote on the word “footnote” and for the source, write “source.”
- Make a fake word that uses three common accents.
- Insert a page break.
II. Research and Presentations
Start a new presentation and in each slide, put answers to the following questions:
- If you wanted to figure out how to use a new program, how would you go about it? Please describe the steps you would take, including where and how you would search.
- Briefly describe what a database is and give an example.
- Below are some data for the baking club, showing cookie sales for their first 4 years in business. Begin a new spreadsheet and paste in these data:
Year # sold cost price profit 1 212 0.75 1.50 2 344 3 476 4 608 5
- In the cost, price, and profit columns, auto-fill the cost that goes into each cookie (75 cents), the price they sell them for ($1.50) and profit they make (profit is the price minus the cost, times # sold).
- Use a graph and a trend line to calculate how much money they'll raise in year 5, assuming the trend continues linearly (hint: you'll need to add the trend line equation).
IV. Other Software
- Using Scratch (http://scratch.mit.edu/projects/editor), create a script so the cat follows your mouse movement, but when it touches the bottom of the screen it says “Hello.”
- Using Sketchup, make a cube that’s five feet on all sides, add a window made of glass, make the window a component, and use the 3D Warehouse to insert something else, your choice.
- Using Photoshop, combine two images using two different layers. Clone-stamp something out of the top image, and cut away the background to reveal the image below. Add a drop-shadow.