LINC 63: CLOUD-BASED DATA ANALYSIS TOOLS
Foothill College Course Outline of Record
|Effective Term:||Summer 2023|
|Hours:||1 lecture per week (12 total per quarter)|
|Advisory:||Basic computer skills and knowledge of Macintosh or Windows operating systems; basic skills and knowledge of internet technologies, such as using web browsers, email, bookmarking, searching, and downloading; not open to students with credit in LINC 269.|
|Degree & Credit Status:||Degree-Applicable Credit Course|
|Grade Type:||Letter Grade (Request for Pass/No Pass)|
Student Learning Outcomes
- Build, edit, and format worksheets.
- Create and format charts.
- Write formulas and use functions.
The student will be able to:
- Identify common functionalities of varying cloud-based data analysis tools
- Use a spreadsheet as a tool for financial management and planning
- Use a spreadsheet as a simple database
- Common functionalities
- Microsoft Excel
- Google Sheets
- Apple Numbers
- Financial management and planning
- Developing a spreadsheet structure
- Entering financial data
- Formatting cells
- Using the subtotals
- Entering simple functions
- Simple database
- Basic database concepts (e.g., field, record)
- Constructing a simple database
- Sorting and filtering data
- Summarizing data
- Creating a simple chart or graph
- Importing data from another source
Special Facilities and/or Equipment
2. When taught via the internet: Students must have current email accounts and ongoing access to computers with web browsing capability and internet access.
Method(s) of Evaluation
Creating a spreadsheet project using characteristics of quality defined by the class
Writing an evaluation critique and reflection for their own and classmates' final projects, with emphasis on use of constructive comments and suggested improvements with respect to established characteristics of good spreadsheet functionalities
Completion of a final project, including a worksheet with formulas, tables, conditional cell formatting
Method(s) of Instruction
Lecture presentations delivered in student-centered learning style, during which students take notes, follow demonstrations, or complete an activity
Facilitated discussions of live presentations, readings, or video presentations
Student presentations in small group and whole class situations
Representative Text(s) and Other Materials
Instructor-assigned notes, materials, and resources, including instructional materials, open education resources, multimedia, and websites.
Types and/or Examples of Required Reading, Writing, and Outside of Class Assignments
- Reading assignments include analysis of texts, selected examples, and student projects
- Writing assignments include a course project and multiple developmental projects, reflections, discussion responses, and peer feedback on projects
- Outside assignments include project planning and development, participation in online peer collaboration activities, and project development through an iterative process
When taught online, these methods may take the form of multimedia and web-based presentations. Assignments will be submitted online as well.